Question

7.

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				$	14.00		$	83,540
Raw materials				$	4.85		$	31,430
Wages	$	5,800		$	1.60		$	15,800
Utilities	$	1,830		$	0.40		$	4,500
Rent	$	2,800					$	2,800
Insurance	$	1,550					$	1,550
Miscellaneous	$	670		$	0.55		$	4,050

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,800 plus $1.60 per liter of gelato sold and the actual wages for June were $15,800. Via Gelato expected to sell 6,200 liters in June, but actually sold 6,400 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	$ 6,060.00	U
Expenses:
Raw material	$ 390.00	U
Wages	$ 240.00	F
Utilities	$ 110.00	U
Rent	$ 0.00	None
Insurance	$ 0.00	None
Miscellaneous	$ 140.00	F
Total Expenses	$ 120.00	U
Net Operating Income	$ 6,180.00	U

Working

Standard revenue and cost
	D=(A x C) +B	A	B	C
Revenue	$ 89,600	6400		$    14.00
Expenses:		6400
Raw material	$ 31,040	6400		$       4.85
Wages	$ 16,040	6400	$      5,800.00	$       1.60
Utilities	$ 4,390	6400	$      1,830.00	$       0.40
Rent	$ 2,800	6400	$      2,800.00	$           -
Insurance	$ 1,550	6400	$      1,550.00	$           -
Miscellaneous	$ 4,190	6400	$         670.00	$       0.55
Total Expenses	$ 60,010
Net Operating Income	$ 29,590