Question: Complete the table using the figures provided for the three products: A, B and C. Last months budget for sales Product Cost price Sale price
Complete the table using the figures provided for the three products: A, B and C.
Last months budget for sales
| Product | Cost price | Sale price | Budget sales last month | Total costs on sales | Budget profit 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 | ||||
Last months sales (actuals)
| 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 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
