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				$	21.00		$	133,540
Raw materials				$	5.55		$	37,130
Wages	$	6,500		$	2.30		$	21,300
Utilities	$	2,530		$	1.10		$	10,000
Rent	$	3,500					$	3,500
Insurance	$	2,250					$	2,250
Miscellaneous	$	740		$	1.25		$	8,790

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 $6,500 plus $2.30 per liter of gelato sold and the actual wages for June were $21,300. 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

If it is helpful, please rate the answer and if any doubt arises let me know

Via Gelato
Revenue and Spending Variance
For the month ended June 30
	Revenue and Spending Variance
Revenue	$                            5,060	U
Expenses:
Raw material	$                                500	U
Wages	$                                380	F
Utilities	$                                210	U
Rent	$                                   0	None
Insurance	$                                   0	None
Miscellaneous	$                                200	F
Total expense	$                                130	U
Net operating income	$                            5,190	U
Workings:
Via Gelato
Revenue and Spending Variance
For the month ended June 30
		Actual	Revenue and Spending Variance		Flexible Budget
Liters	(q)	6,600			6,600
Revenue	($21X q)	$ 1,33,540	$             5,060	U	$ 1,38,600
Expenses:
Raw material	($5.55 X q)	$     37,130	$                 500	U	$     36,630
Wages	[$6500+ ($2.30 X q)]	$     21,300	$                 380	F	$     21,680
Utilities	[$2530 + ($1.10 X q)]	$     10,000	$                 210	U	$       9,790
Rent	$                            3,500	$       3,500	$                    -	None	$       3,500
Insurance	$                            2,250	$       2,250	$                    -	None	$       2,250
Miscellaneous	[$740 + ($1.25 X q)]	$       8,790	$                 200	F	$       8,990
Total expense		$     82,970	$                 130	U	$     82,840
Net operating income		$     50,570	$             5,190	U	$     55,760