Question: Prepare a variance analysis between the budget and actual. You should present three variances: (1) the difference in profit due to selling more or less
Prepare a variance analysis between the budget and actual. You should present three variances: (1) the difference in profit due to selling more or less units, (2) the difference in profit due to selling units at a higher or lower price, and (3) the difference in profit due to producing more or less units. 4) In terms of variances, discuss the budget and the actual performance and changes needed to make in the budget.
| Price | Cups Sold | Cups Produced | Profit | |
| $0.65 | 122 | 148 | $49.70 | |
| $0.65 | 196 | 258 | $75.80 | |
| $0.65 | 166 | 208 | $66.30 | |
| $0.65 | 26 | 68 | $3.30 | |
| $0.65 | 44 | 88 | $11.00 | |
| $0.60 | 118 | 168 | $37.20 | |
| $0.60 | 188 | 238 | $65.20 | |
| $0.60 | 98 | 138 | $31.20 | |
| $0.60 | 158 | 168 | $61.20 | |
| $0.60 | 158 | 178 | $59.20 | |
| Actual | $0.62 | 128 | 163 | $46.76 |
| Budget | $0.50 | 280 | 290 | $82.00 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
