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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started