Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June:
Fixed Element per Month |
Variable Element per Liter |
Actual Total for June |
|||||||
Revenue | $ | 13.00 | $ | 72,540 | |||||
Raw materials | $ | 4.75 | $ | 30,330 | |||||
Wages | $ | 5,700 | $ | 1.50 | $ | 14,560 | |||
Utilities | $ | 1,730 | $ | 0.30 | $ | 3,800 | |||
Rent | $ | 2,700 | $ | 2,700 | |||||
Insurance | $ | 1,450 | $ | 1,450 | |||||
Miscellaneous | $ | 660 | $ | 0.45 | $ | 2,990 | |||
While gelato is sold by the cone or cup, the shop measures its activity in terms of the total number of liters of gelato sold. For example, wages should be $5,700 plus $1.50 per liter of gelato sold and the actual wages for June were $14,560. Via Gelato expected to sell 6,000 liters in June, but actually sold 6,200 liters.
Required:
Calculate Via Gelato revenue and spending variances for June. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June:
Fixed Element per Month |
Variable Element per Liter |
Actual Total for June |
|||||||
Revenue | $ | 13.00 | $ | 72,540 | |||||
Raw materials | $ | 4.75 | $ | 30,330 | |||||
Wages | $ | 5,700 | $ | 1.50 | $ | 14,560 | |||
Utilities | $ | 1,730 | $ | 0.30 | $ | 3,800 | |||
Rent | $ | 2,700 | $ | 2,700 | |||||
Insurance | $ | 1,450 | $ | 1,450 | |||||
Miscellaneous | $ | 660 | $ | 0.45 | $ | 2,990 | |||
While gelato is sold by the cone or cup, the shop measures its activity in terms of the total number of liters of gelato sold. For example, wages should be $5,700 plus $1.50 per liter of gelato sold and the actual wages for June were $14,560. Via Gelato expected to sell 6,000 liters in June, but actually sold 6,200 liters.
Required:
Calculate Via Gelato revenue and spending variances for June. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
Revenue spending variance
Flexible budget | Actual | revenue and spending variance | |
Actual sold | 6200 | 6200 | |
Revenue | 80600 | 72540 | 8060 U |
expense | |||
Raw materials | 29450 | 30330 | 880 U |
Wages | 15000 | 14560 | 440 F |
Utilities | 3590 | 3800 | 210 U |
Rent | 2700 | 2700 | 0 None |
Insurance | 1450 | 1450 | 0 None |
Miscellaneous | 3450 | 2990 | 460 F |
Total expense | 55640 | 55830 | 190 U |
Net operating income | 24960 | 16710 | 8250 U |
Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas...
Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Fixed Element per Month Variable Element per Liter Actual Total for June Revenue $ 23.00 $ 140,540 Raw materials $ 5.75 $ 37,030 Wages $ 6,700 $ 2.50 $ 21,800 Utilities $ 2,730 $ 1.30 $ 11,600 Rent $ 3,700 $ 3,700 Insurance $ 2,450 $ 2,450 Miscellaneous $ 760 $ 1.45 $ 9,390 While gelato...
Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Fixed Element per Month Variable Element per Liter Actual Total for June Revenue $ 12.00 $ 71,540 Raw materials $ 4.65 $ 29,230 Wages $ 5,600 $ 1.40 $ 13,860 Utilities $ 1,630 $ 0.20 $ 3,270 Rent $ 2,600 $ 2,600 Insurance $ 1,350 $ 1,350 Miscellaneous $ 650 $ 0.35 $ 2,590 While gelato...
Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Fixed Element per Month Variable Element per Liter Actual Total for June Revenue $ 28.00 $ 171,540 Raw materials $ 6.25 $ 40,530 Wages $ 7,200 $ 3.00 $ 26,300 Utilities $ 3,230 $ 1.80 $ 15,000 Rent $ 4,200 $ 4,200 Insurance $ 2,950 $ 2,950 Miscellaneous $ 810 $ 1.95 $ 12,890 While gelato...
Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Fixed Element per Month Variable Element per Liter Actual Total for June Revenue $ 12.00 $ 71,540 Raw materials $ 4.65 $ 29,230 Wages $ 5,600 $ 1.40 $ 13,860 Utilities $ 1,630 $ 0.20 $ 3,270 Rent $ 2,600 $ 2,600 Insurance $ 1,350 $ 1,350 Miscellaneous $ 650 $ 0.35 $ 2,590 While gelato...
Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Fixed Element per Month Variable Element per Liter Actual Total for June Revenue $ 30.00 $ 190,540 Raw materials $ 6.45 $ 42,930 Wages $ 7,400 $ 3.20 $ 28,400 Utilities $ 3,430 $ 2.00 $ 17,300 Rent $ 4,400 $ 4,400 Insurance $ 3,150 $ 3,150 Miscellaneous $ 830 $ 2.15 $ 14,390 While gelato...
Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June Fixed Element per Month Revenue Raw materials Wages Utilities Rent Insurance Miscellaneous Variable Element per Liter $ 12.00 $ 4.65 $ 1.40 $ 0.20 $ 5,600 $ 1,630 $ 2,600 $ 1,350 $ 650 Actual Total for June $ 71,540 $ 29, 230 $ 13,860 $ 3,270 $ 2,600 $ 1,350 $ 2,590 $ 0.35 While...
Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Fixed Element per Month Variable Element per Liter Actual Total for June Revenue $ 12.00 $ 71,540 Raw materials $ 4.65 $ 29,230 Wages $ 5,600 $ 1.40 $ 13,860 Utilities $ 1,630 $ 0.20 $ 3,270 Rent $ 2,600 $ 2,600 Insurance $ 1,350 $ 1,350 Miscellaneous $ 650 $ 0.35 $ 2,590 While gelato...
Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Fixed Element per Month Variable Element Actual Total per Liter 29.00 S 6.35 3.10 s 1.90 for June 175,540 40,630 $ Revenue Raw materials 7,300 $ 3,330 4,300 3,050 Wages Utilities 26,400 16,100 4,300 3,050 12,990 Rent Insurance $ 2.05 Miscellaneous 820 While gelato is sold by the cone or cup, the shop measures its activity...
Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Fixed Element per Month Variable Element per Liter Actual Total for June Revenue $ 16.00 $ 90,540 Raw materials $ 5.05 $ 31,630 Wages $ 6,000 $ 1.80 $ 16,900 Utilities $ 2,030 $ 0.60 $ 6,000 Rent $ 3,000 $ 3,000 Insurance $ 1,750 $ 1,750 Miscellaneous $ 690 $ 0.75 $ 5,200 While gelato...
Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Fixed Element per Month Revenue Raw materials Wages Utilities Rent Insurance Miscellaneous Variable Element per liter $ 19.00 $ 5.35 $ 2.10 $ 0.90 $ 6,300 $ 2,330 $ 3,300 $ 2,050 $ 720 Actual Total for June $ 111,530 $ 33,830 $ 18,900 $ 8,100 $ 3,300 $ 2,050 $ 6,900 $ 1.05 While gelato...