Question

The Bakery produces organic bread that is sold by the loaf. Each loaf requires 1/2 of a pound of flour. The bakery pays $2.50 per pound of the organic flour used in its loaves. The bakery expects to produce the following number of loaves in each of the upcoming four​ months:______.

Data Table
July 1,500 loaves
August 1,880 loaves
September 1,680 loaves
October 1,560 loaves
The bakery has a policy that it will have 20% of the following​ month's flour needs on hand at the end of each month. At the end of​ June, there were 150 pounds of flour on hand. Prepare the direct materials budget for the third​ quarter, with a column for each month and for the quarter.
Begin the direct materials by determining the total quantity needed, then complete the budget.
July August September Quarter
Units to be produced
Multiply by: Pounds of flour needed per unit
Quantity needed (Ibs) for production
Plus: Desired ending inventory of direct materials
Total quantity (lbs) needed

Answer 1

The Bakery

Direct materials budget

For the third​ quarter of year 202x

July August September Quarter

Budgeted production units 1,500 1,880 1,680 5,600

Materials required per unit 0.5 0.5 0.5 0.5

Materials needed for Px 750 940 840 2,530

+ Desired ending inventory 188 168 156 156

Total materials required 938 1,108 996 2,686

- Beginning inventory -150 -188 -168 -150

Units to be purchased 788 920 828 2,536

Cost per unit $2.50 $2.50 $2.50 $2.50

Total cost materials costs $1,970 $2,300 $2,070 $6,340