Using the budget information and sales figures provided about products: A, B and C, complete the table.
Question:
Using the budget information and sales figures provided about products: A, B and C, complete the table.
Budget
Product | Cost price | Sale price | Total budget sales last month | Total costs on sales | Gross profit budget last month | Profit % per item on sale price | ||
---|---|---|---|---|---|---|---|---|
# | $ | per item | on sales | |||||
A | $7.50 | $12.00 | 500 | $6,000 | $3,750 | $4.50 | $2,250 | 38% |
B | $9.25 | $17.00 | 400 | $6,800 | $3,700 | $7.75 | $3,100 | 46% |
C | $10.00 | $30.00 | 300 | $9,000 | $3,000 | $20.00 | $6,000 | 67% |
Total | 1,200 | $21,800 | $10,450 | $11,350 |
Sales
Product | Cost price | Sale price | Total sales last month | Total costs on sales | Gross profit last month | Profit % per item on sale price | ||
---|---|---|---|---|---|---|---|---|
# | $ | per item | on sales | |||||
A | $7.50 | $12.00 | 650 | $7,800 | $4,875 | $4.50 | $2,925 | 38% |
B | $9.25 | $17.00 | 500 | $8,500 | $4,625 | $7.75 | $3,875 | 46% |
C | $10.00 | $30.00 | 200 | $6,000 | $2,000 | $20.00 | $4,000 | 67% |
Total | 1,350 | $22,300 | $11,500 | $10,800 |
Product | Gross profit budget ($) | Gross profit actual ($) | Variance ($) |
---|---|---|---|
A | |||
B | |||
C | |||
Total |
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill