Parts List by Markup Percentage

 
This report prints parts by a range of parts markup percentages. It shows all parts with a certain markup percentage, their average and selling prices, on hand quantity, and extension. In the subtotals, it shows the total selling (retail) price, the average(cost) price, and the difference (profit). You are prompted for a range of markup percentages in tenths (do not use decimals in the prompt)
and part facility. 
This may be used to check your markup percentages while also giving dollar totals, and comparing cost vs. retail prices. 


Prints the following: 
Part number
Part description
Part markup percentage
Selling or retail price
Average or cost price
Quantity on hand, all stocking areas
Value on hand(average price times quantity on hand)
Primary vendor number
Primary vendor abbreviation 
Subtotals by markup percent: 
Count of part numbers
Selling value(selling price times quantity on hand)
Cost value(average price times quantity on hand)
Difference or profit(selling value minus cost value) 
Grand totals: 
Count of part numbers
Selling value(selling price times quantity on hand)
Cost value(average price times quantity on hand)
Difference or profit(selling value minus cost value)