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
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 |
Step by Step Solution
3.46 Rating (149 Votes )
There are 3 Steps involved in it
Step: 1
Product Gross profit budget Gross profit actual Variance A ...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