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				$	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 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 $7,400 plus $3.20 per liter of gelato sold and the actual wages for June were $28,400. Via Gelato expected to sell 6,400 liters in June, but actually sold 6,600 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.)

Answer 1

Solution

Via Gelato
Revenues and Spending Variance
For the Month ended June
Revenue	$ 7,460.00	U
Expenses:
Raw material	$ 360.00	U
Wages	$ 120.00	F
Utilities	$ 670.00	U
Rent	$ 0.00	None
Insurance	$ 0.00	None
Miscellaneous	$ 630.00	F
Total Expenses	$ 280.00	U
Net Operating Income	$ 7,740.00	U

Working

	D=(A x C) +B	A	B	C
Revenue	$ 198,000	6600		$    30.00
Expenses:		6600
Raw material	$ 42,570	6600		$       6.45
Wages	$ 28,520	6600	$      7,400.00	$       3.20
Utilities	$ 16,630	6600	$      3,430.00	$       2.00
Rent	$ 4,400	6600	$      4,400.00	$           -
Insurance	$ 3,150	6600	$      3,150.00	$           -
Miscellaneous	$ 15,020	6600	$         830.00	$       2.15
Total Expenses	$ 110,290
Net Operating Income	$ 87,710