Question

Carreras Café is a Spanish restaurant in a college town. The owner expects that the number of meals served in June will be 40 percent below those served in May, because so many students leave for the summer. In May, the restaurant served 4,800 meals at an average price of $15. In the summer (June through August), the average price of a meal typically increases by 35 percent and the average food cost of a meal increases by 20 percent. Other costs are typically unchanged during the summer. The following cost information is available for May.

Service costs (variable with respect to meals)
Variable service costs (with respect to meals)
Food costs	$	11,200
Labor		16,800
Other variable costs		5,700
Fixed service costs		9,700
Total service costs	$	43,400
Marketing and administrative costs
Marketing (variable with respect to meals)		6,000
Administrative (fixed)		4,200
Total marketing and administrative costs	$	10,200
Total costs	$	53,600

Required:

Prepare a budgeted income statement for June.

Answer 1

Sales Revenue			$ 58,320.00
Service Costs:
Food cost			$   8,064.00
Labor		[($ 16800 / 4800) x 2880]	$ 10,080.00
Other variable cost		[($ 5700 / 4800) x 2880]	$   3,420.00
Fixed service cost			$   9,700.00
Total service cost			$ 31,264.00
Gross profit margin			$ 27,056.00
Marketing and adm.
Marketing (variable)		[($ 6000 / 4800) x 2880]	$   3,600.00
Adm. (Fixed)			$   4,200.00
Total M&A cost			$   7,800.00
Operating profit			$ 19,256.00

Workings
Sales Revenue
Units to be sold		(4800 x 60%)		2880
Average price		($ 15 x 135%)		$        20.25
			Revenue	$ 58,320.00
Food cost
Existing food cost per unit ($ 11200 / 4800)				$           2.33
Units to be sold				2880
Food cost				$   6,720.00
Increase in food cost (6720 x 120%)				$   8,064.00