Assume that Carmen's Cookies is preparing a budget for the month ending June 30. Management prepares the budget by starting with the actual results for April 30. Next, management considers what the differences in costs will be between April and June.

Management expects the number of cookies sold to be 20 percent greater in June than in April, and it expects all food costs (e.g., flour, eggs) to be 20 percent higher in June than in April. Management expects other labor costs to be 25 percent higher in June than in April, partly because more labor will be required in June and partly because employees will get a pay raise. The manager will get a pay raise that will increase the salary from $3,000 in April to $4,000 in June. Rent and utilities are not expected to change.

Required: Prepare a budget for Carmen's Cookies for June.

actual (April) budget (june)

Food

Flour 2,100 ___________

Eggs 5,200 ___________

Chocolate 2,000 ___________

nuts 2,000 ___________

other 2,200 ___________

TOTAL FOOD 13,500 ___________

Labor

Manager 3,000 ___________

Other 1,500 ___________

TOTAL LABOR 4,500 ___________

Utilities 1,800 ___________

Rent 5,000 ___________ TOTAL COOKIE COST 24,800 ___________

Number of Cookies sold 32,000 ___________