Oriole Company's sales budget projects unit sales of part 198Z of10,100units in January,12,100units in February, and13,500units in March. Each unit of part 198Z requires3pounds of materials, which cost $4per pound. Oriole Company desires its ending raw materials inventory to equal 40% of the next month's production requirements, and its ending finished goods inventory to equal 20% of the next month's expected unit sales. These goals were met at December 31, 2019.

Prepare a production budget for January and February 2020.

ORIOLECOMPANY

Production Budget

For the Month Ending January 31, 2020

For the Quarter Ending February 28, 2020

For the Two Months Ending February 28, 2020

January

February

Total Pounds Needed for Production

Total Required Units

Cost Per Pound

Required Production Units

Desired Pounds in Ending Materials Inventory

Beginning Finished Goods Inventory

Units To Be Produced

Beginning Direct Materials

Direct Material Pounds Per Unit

Total Cost of Direct Materials Purchases

Desired Ending Finished Goods Inventory

Total Materials Required

Direct Materials Purchases

Expected Unit Sales

Add

Less

:

Direct Materials Purchases

Total Cost of Direct Materials Purchases

Direct Material Pounds Per Unit

Beginning Direct Materials

Units To Be Produced

Required Production Units

Expected Unit Sales

Desired Ending Finished Goods Inventory

Total Pounds Needed for Production

Beginning Finished Goods Inventory

Total Materials Required

Total Required Units

Cost Per Pound

Desired Pounds in Ending Materials Inventory

Expected Unit Sales

Required Production Units

Beginning Finished Goods Inventory

Total Materials Required

Total Cost of Direct Materials Purchases

Total Pounds Needed for Production

Cost Per Pound

Desired Ending Finished Goods Inventory

Desired Pounds in Ending Materials Inventory

Direct Material Pounds Per Unit

Direct Materials Purchases

Total Required Units

Units To Be Produced

Beginning Direct Materials

Add

Less

:

Beginning Finished Goods Inventory

Beginning Direct Materials

Desired Pounds in Ending Materials Inventory

Cost Per Pound

Total Cost of Direct Materials Purchases

Total Materials Required

Total Pounds Needed for Production

Total Required Units

Desired Ending Finished Goods Inventory

Units To Be Produced

Direct Material Pounds Per Unit

Required Production Units

Direct Materials Purchases

Expected Unit Sales

Cost Per Pound

Expected Unit Sales

Total Cost of Direct Materials Purchases

Total Pounds Needed for Production

Units To Be Produced

Total Required Units

Beginning Direct Materials

Beginning Finished Goods Inventory

Direct Material Pounds Per Unit

Required Production Units

Desired Ending Finished Goods Inventory

Total Materials Required

Desired Pounds in Ending Materials Inventory

Direct Materials Purchases

LINK TO TEXT

Prepare a direct materials budget for January 2020.

ORIOLECOMPANY

Direct Materials Budget

For the Two Months Ending February 28, 2020

For the Month Ending January 31, 2020

For the Quarter Ending February 28, 2020

January

Units To Be Produced

Expected Unit Sales

Desired Ending Finished Goods Inventory

Required Production Units

Desired Pounds in Ending Materials Inventory

Direct Material Pounds Per Unit

Beginning Finished Goods Inventory

Cost Per Pound

Direct Materials Purchases

Total Cost of Direct Materials Purchases

Total Materials Required

Total Pounds Needed for Production

Total Required Units

Beginning Direct Materials (Pounds)

Total Cost of Direct Materials Purchases

Expected Unit Sales

Required Production Units

Direct Materials Purchases

Total Required Units

Total Materials Required

Desired Ending Finished Goods Inventory

Cost Per Pound

Total Pounds Needed for Production

Beginning Direct Materials (Pounds)

Beginning Finished Goods Inventory

Units To Be Produced

Desired Pounds in Ending Materials Inventory

Direct Material Pounds Per Unit

Cost Per Pound

Beginning Direct Materials (Pounds)

Direct Material Pounds Per Unit

Beginning Finished Goods Inventory

Direct Materials Purchases

Expected Unit Sales

Desired Ending Finished Goods Inventory

Desired Pounds in Ending Materials Inventory

Required Production Units

Total Materials Required

Units To Be Produced

Total Cost of Direct Materials Purchases

Total Pounds Needed for Production

Total Required Units

Add

Less

:

Beginning Finished Goods Inventory

Cost Per Pound

Desired Ending Finished Goods Inventory

Total Required Units

Required Production Units

Direct Material Pounds Per Unit

Desired Pounds in Ending Materials Inventory

Total Cost of Direct Materials Purchases

Direct Materials Purchases

Beginning Direct Materials (Pounds)

Expected Unit Sales

Total Materials Required

Total Pounds Needed for Production

Units To Be Produced

Desired Pounds in Ending Materials Inventory

Total Cost of Direct Materials Purchases

Required Production Units

Total Required Units

Beginning Finished Goods Inventory

Expected Unit Sales

Cost Per Pound

Total Materials Required

Desired Ending Finished Goods Inventory

Beginning Direct Materials (Pounds)

Direct Material Pounds Per Unit

Units To Be Produced

Direct Materials Purchases

Total Pounds Needed for Production

Add

Less

:

Total Pounds Needed for Production

Total Required Units

Expected Unit Sales

Beginning Finished Goods Inventory

Units To Be Produced

Beginning Direct Materials (Pounds)

Required Production Units

Total Cost of Direct Materials Purchases

Desired Pounds in Ending Materials Inventory

Direct Materials Purchases

Desired Ending Finished Goods Inventory

Total Materials Required

Cost Per Pound

Direct Material Pounds Per Unit

Required Production Units

Direct Material Pounds Per Unit

Units To Be Produced

Total Required Units

Total Materials Required

Cost Per Pound

Beginning Direct Materials (Pounds)

Total Pounds Needed for Production

Beginning Finished Goods Inventory

Direct Materials Purchases

Desired Ending Finished Goods Inventory

Expected Unit Sales

Desired Pounds in Ending Materials Inventory

Total Cost of Direct Materials Purchases

Expected Unit Sales

Direct Material Pounds Per Unit

Required Production Units

Desired Pounds in Ending Materials Inventory

Total Cost of Direct Materials Purchases

Total Materials Required

Desired Ending Finished Goods Inventory

Total Pounds Needed for Production

Total Required Units

Cost Per Pound

Units To Be Produced

Direct Materials Purchases

Beginning Direct Materials (Pounds)

Beginning Finished Goods Inventory

$

Beginning Finished Goods Inventory

Desired Ending Finished Goods Inventory

Direct Material Pounds Per Unit

Total Required Units

Cost Per Pound

Desired Pounds in Ending Materials Inventory

Total Pounds Needed for Production

Direct Materials Purchases

Expected Unit Sales

Required Production Units

Units To Be Produced

Beginning Direct Materials (Pounds)

Total Cost of Direct Materials Purchases

Total Materials Required

$