Fuqua Companys sales budget projects unit sales of part 198Z of 10,000 units in January, 12,400 units in February, and 13,300 units in March. Each unit of part 198Z requires 3 pounds of materials, which cost $5 per pound. Fuqua Company desires its ending raw materials inventory to equal 40% of the next months production requirements, and its ending finished goods inventory to equal 20% of the next months expected unit sales. These goals were met at December 31, 2019.

FUQUA COMPANY Production Budget For the Month Ending January 31, 2020For the Quarter Ending February 28, 2020For the Two Months Ending February 28, 2020

January

February

Expected Unit SalesUnits To Be ProducedTotal Materials RequiredCost Per PoundRequired Production UnitsBeginning Direct MaterialsBeginning Finished Goods InventoryTotal Required UnitsTotal Pounds Needed for ProductionTotal Cost of Direct Materials PurchasesDirect Materials PurchasesDirect Material Pounds Per UnitDesired Pounds in Ending Materials InventoryDesired Ending Finished Goods Inventory

AddLess: Cost Per PoundTotal Required UnitsDesired Ending Finished Goods InventoryTotal Materials RequiredBeginning Direct MaterialsUnits To Be ProducedDirect Material Pounds Per UnitRequired Production UnitsTotal Cost of Direct Materials PurchasesBeginning Finished Goods InventoryExpected Unit SalesDesired Pounds in Ending Materials InventoryDirect Materials PurchasesTotal Pounds Needed for Production

Required Production UnitsDesired Pounds in Ending Materials InventoryDesired Ending Finished Goods InventoryDirect Material Pounds Per UnitDirect Materials PurchasesCost Per PoundTotal Cost of Direct Materials PurchasesUnits To Be ProducedTotal Required UnitsBeginning Finished Goods InventoryExpected Unit SalesTotal Pounds Needed for ProductionTotal Materials RequiredBeginning Direct Materials

AddLess: Total Required UnitsDesired Pounds in Ending Materials InventoryUnits To Be ProducedDesired Ending Finished Goods InventoryBeginning Direct MaterialsTotal Pounds Needed for ProductionRequired Production UnitsTotal Cost of Direct Materials PurchasesDirect Material Pounds Per UnitCost Per PoundExpected Unit SalesBeginning Finished Goods InventoryDirect Materials PurchasesTotal Materials Required

Beginning Direct MaterialsExpected Unit SalesTotal Materials RequiredBeginning Finished Goods InventoryTotal Required UnitsDirect Material Pounds Per UnitCost Per PoundUnits To Be ProducedDesired Pounds in Ending Materials InventoryTotal Pounds Needed for ProductionTotal Cost of Direct Materials PurchasesDirect Materials PurchasesRequired Production UnitsDesired Ending Finished Goods Inventory

Prepare a direct materials budget for January 2020.

FUQUA COMPANY Direct Materials Budget For the Quarter Ending February 28, 2020For the Month Ending January 31, 2020For the Two Months Ending February 28, 2020
		January
Direct Material Pounds Per UnitCost Per PoundUnits To Be ProducedDirect Materials PurchasesTotal Pounds Needed for ProductionDesired Ending Finished Goods InventoryTotal Required UnitsRequired Production UnitsExpected Unit SalesBeginning Finished Goods InventoryTotal Cost of Direct Materials PurchasesBeginning Direct Materials (Pounds)Total Materials RequiredDesired Pounds in Ending Materials Inventory
Beginning Direct Materials (Pounds)Total Materials RequiredDesired Ending Finished Goods InventoryRequired Production UnitsTotal Required UnitsTotal Pounds Needed for ProductionBeginning Finished Goods InventoryUnits To Be ProducedDirect Materials PurchasesTotal Cost of Direct Materials PurchasesDesired Pounds in Ending Materials InventoryDirect Material Pounds Per UnitCost Per PoundExpected Unit Sales
Total Cost of Direct Materials PurchasesTotal Required UnitsDirect Materials PurchasesBeginning Direct Materials (Pounds)Direct Material Pounds Per UnitUnits To Be ProducedCost Per PoundTotal Materials RequiredExpected Unit SalesBeginning Finished Goods InventoryRequired Production UnitsTotal Pounds Needed for ProductionDesired Pounds in Ending Materials InventoryDesired Ending Finished Goods Inventory
AddLess: Beginning Direct Materials (Pounds)Beginning Finished Goods InventoryCost Per PoundTotal Cost of Direct Materials PurchasesDesired Ending Finished Goods InventoryTotal Materials RequiredUnits To Be ProducedTotal Pounds Needed for ProductionTotal Required UnitsDirect Material Pounds Per UnitDesired Pounds in Ending Materials InventoryDirect Materials PurchasesRequired Production UnitsExpected Unit Sales
Desired Pounds in Ending Materials InventoryUnits To Be ProducedCost Per PoundTotal Pounds Needed for ProductionDirect Material Pounds Per UnitTotal Materials RequiredDesired Ending Finished Goods InventoryRequired Production UnitsDirect Materials PurchasesExpected Unit SalesTotal Required UnitsTotal Cost of Direct Materials PurchasesBeginning Direct Materials (Pounds)Beginning Finished Goods Inventory
AddLess: Cost Per PoundDesired Pounds in Ending Materials InventoryTotal Materials RequiredDesired Ending Finished Goods InventoryTotal Required UnitsBeginning Finished Goods InventoryDirect Material Pounds Per UnitUnits To Be ProducedTotal Cost of Direct Materials PurchasesExpected Unit SalesRequired Production UnitsTotal Pounds Needed for ProductionDirect Materials PurchasesBeginning Direct Materials (Pounds)
Expected Unit SalesCost Per PoundDesired Ending Finished Goods InventoryRequired Production UnitsTotal Required UnitsDirect Material Pounds Per UnitUnits To Be ProducedDesired Pounds in Ending Materials InventoryBeginning Direct Materials (Pounds)Total Cost of Direct Materials PurchasesDirect Materials PurchasesTotal Pounds Needed for ProductionBeginning Finished Goods InventoryTotal Materials Required
Direct Material Pounds Per UnitTotal Required UnitsBeginning Direct Materials (Pounds)Units To Be ProducedBeginning Finished Goods InventoryRequired Production UnitsExpected Unit SalesDesired Ending Finished Goods InventoryTotal Cost of Direct Materials PurchasesTotal Pounds Needed for ProductionCost Per PoundDirect Materials PurchasesTotal Materials RequiredDesired Pounds in Ending Materials Inventory		$
Units To Be ProducedBeginning Direct Materials (Pounds)Total Pounds Needed for ProductionTotal Cost of Direct Materials PurchasesExpected Unit SalesDesired Ending Finished Goods InventoryTotal Required UnitsDirect Materials PurchasesDesired Pounds in Ending Materials InventoryBeginning Finished Goods InventoryTotal Materials RequiredRequired Production UnitsDirect Material Pounds Per UnitCost Per Pound		$