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.

Answer 1

Answer:

Data Table

Month July August September The third quarter

Flour budget (pound) 938 pounds 1,108 pounds 996 pounds 3,042 pounds

Flour budget (USD) $2,345 $2,770 $2,490 $7,605

Explanation:

Flour needs to produces organic bread:

In July = 1,500 x 1/2 = 750 pounds

In August = 1,880 x 1/2 = 940 pounds

In September = 1,680 x 1/2 = 840 pounds  

In October = 1,560 x 1/2 = 780 pounds

Flour needs on hand at the end of:

July = 940 x 20% = 188 pounds

August = 840 x 20% = 168 pounds

September = 780 x 20% = 156 pounds

Total flour needs:

In July = 750 + 188 = 938 pounds

In August = 940 + 168 = 1,108 pounds

In September = 840 + 156 = 996 pounds  

In the third quarter = 3,042 pounds

The bakery pays $2.50 per pound of the organic flour used in its loaves.

In July = 938 pounds x $2.50 = $2,345

In August = 1,108 pounds $2.50 = $2,770

In September = 996 pounds  $2.50 = $2,490

In the third quarter = $7,605

Data Table

Month July August September The third quarter

Flour budget (pound) 938 pounds 1,108 pounds 996 pounds 3,042 pounds

Flour budget (USD) $2,345 $2,770 $2,490 $7,605