Question

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 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,600 plus $1.40 per liter of gelato sold and the actual wages for June were $13,860. 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

Revenue and Spending Variances

For the Month Ended June 30

Revenue		"U/F"
Expenses
Raw Materials
Wages
Utilities
Rent
Insurance
Miscellaneous
Total Expense
Net Operating Income

Answer 1

Solution

Via Gelato
Revenues and Spending Variance
For the Month ended June 30
Revenue	$    2,860.00	U
Expenses:
Raw material	$ 400.00	U
Wages	$        420.00	F
Utilities	$ 400.00	U
Rent	$                 -	None
Insurance	$                 -	None
Miscellaneous	$        230.00	F
Total Expenses	$ 150.00	U
Net Operating Income	$    3,010.00	U

Working

	A=B +(C x D)	C	B	D
Revenue	$ 74,400	6200		12
Expenses:		6200
Raw material	$ 28,830	6200		4.65
Wages	$ 14,280	6200	5600	1.4
Utilities	$ 2,870	6200	1630	0.2
Rent	$ 2,600	6200	2600
Insurance	$ 1,350	6200	1350
Miscellaneous	$ 2,820	6200	650	0.35
Total Expenses	$ 52,750
Net Operating Income	$ 21,650