Question
(b) Prepare the direct materials budget for this product line by quarter and in total for 2020. (Round cost per pound to 2 decimal places,
(b)
Prepare the direct materials budget for this product line by quarter and in total for 2020. (Round cost per pound to 2 decimal places, e.g. 1.25 and other answers to 0 decimal places, e.g. 125.)
CURRENT DESIGNS Direct Materials Budget-Polyethylene Powder December 31, 2020For the Month Ending December 31, 2020For the Year Ending December 31, 2020 | ||||||||||
Quarter | ||||||||||
Q1 | Q2 | Q3 | Q4 | Total | ||||||
Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | ||||||||||
Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | ||||||||||
Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | ||||||||||
AddLess :Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | ||||||||||
Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | ||||||||||
AddLess :Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | ||||||||||
Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | ||||||||||
Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | $ | $ | $ | $ | ||||||
Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | $ | $ | $ | $ | ||||||
Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | ||||||||||
Beginning Inventory of PowderCost of Polyethylene Powder to be PurchasedCost of Required Finishing KitsCost Per PoundDesired Ending Inventory of PowderPounds of Polyethylene Powder Per UnitPounds of Polyethylene Powder to be PurchasedTotal Costs for Direct MaterialsTotal Pounds Needed for ProductionTotal Pounds of Powder RequiredUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time Per UnitTotal Direct Labor CostTotal Required Direct Labor Hours | $ | $ | $ | $ | $ |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started