Yummi Company makes five types of cookies. The budgeted and actual sales and selling prices follow.
Budgeted revenues:
Chocolate chip (45,000 boxes at $ 7.40 per box) ....................................... $ 333,000
Oatmeal raisin (25,000 boxes at $ 6.20 per box) ........................................ 155,000
Coconut (10,000 boxes at $ 6.60 per box) .................................................. 66,000
White chocolate (15,000 boxes at $ 7.60 per box) ..................................... 114,000
Macadamia nut (5,000 boxes at $ 12.00 per box) ....................................... 60,000
Total budgeted revenues ............................................................................. $ 728,000
Actual revenues:
Chocolate chip (57,600 boxes at $ 7.50 per box) ....................................... $ 432,000
Oatmeal raisin (28,000 boxes at $ 6.00 per box) ........................................ 168,000
Coconut (9,600 boxes at $ 6.20 per box) .................................................... 59,520
White chocolate (13,200 boxes at $ 7.50 per box) ..................................... 99,000
Macadamia nut (11,600 boxes at $ 11.00 per box) ..................................... 127,600
Total actual revenues .................................................................................. $ 886,120
Required
Prepare a spreadsheet that explains, using variances, and the difference between budgeted and sales revenues.