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 $4,500 in April to $5,400 in June. Rent and utilities are not expected to change. Required: Prepare a budget for Carmen's Cookies for June.

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 $4,500 in April to $5,400 in June. Rent and utilities are not expected to change.

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





Explanation:

Food:

Flour = $3,600 × 1.2 = $4,320

Eggs = $6,700 × 1.2 = $8,040

Chocolate = $3,500 × 1.2 = $4,200

Nuts = $3,500 × 1.2 = $4,200

Other = $3,700 × 1.2 = $4,440

Labor:

Other = $3,000× 1.25 = $3,750

Number of cookies sold = 47,000 × 1.2 = 56,400