Question
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020.
Sales units: | First quarter 5,400; second quarter 7,000; third quarter 7,600. | |
Ending raw materials inventory: | 40% of the next quarters production requirements. | |
Ending finished goods inventory: | 25% of the next quarters expected sales units. | |
Third-quarter production: | 7,840 units. |
The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to production and sales that occur in 2020. 4 pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $6 per pound.
Prepare a production budget by quarters for the 6-month period ended June 30, 2020.
HARDIN COMPANY Production Budget For the Six Months Ending June 30, 2020June 30, 2020For the Quarter Ending June 30, 2020 | ||||||
Quarter | ||||||
1 | 2 | Six Months | ||||
Desired Ending Direct MaterialsTotal Materials RequiredDirect Materials PurchasesBeginning Finished Goods UnitDirect Materials Per UnitBeginning Direct MaterialsRequired Production UnitsTotal Required UnitsExpected Unit SalesDesired Ending Finished Goods Unit | ||||||
AddLess: Expected Unit SalesDirect Materials Per UnitTotal Required UnitsDirect Materials PurchasesDesired Ending Finished Goods UnitTotal Materials RequiredRequired Production UnitsBeginning Direct MaterialsDesired Ending Direct MaterialsBeginning Finished Goods Unit | ||||||
Direct Materials Per UnitDesired Ending Direct MaterialsTotal Materials RequiredRequired Production UnitsBeginning Direct MaterialsExpected Unit SalesDirect Materials PurchasesTotal Required UnitsBeginning Finished Goods UnitDesired Ending Finished Goods Unit | ||||||
AddLess: Total Required UnitsExpected Unit SalesDesired Ending Finished Goods UnitTotal Materials RequiredDesired Ending Direct MaterialsBeginning Direct MaterialsDirect Materials PurchasesBeginning Finished Goods UnitDirect Materials Per UnitRequired Production Units | ||||||
Desired Ending Finished Goods UnitDesired Ending Direct MaterialsExpected Unit SalesRequired Production UnitsBeginning Direct MaterialsTotal Materials RequiredDirect Materials PurchasesDirect Materials Per UnitBeginning Finished Goods UnitTotal Required Units |
Prepare a direct materials budget by quarters for the 6-month period ended June 30
HARDIN COMPANY Direct Materials Budget June 30, 2020For the Six Months Ending June 30 For the Quarter Ending June 30 | |||||||
Quarter | |||||||
1 | 2 | Six Months | |||||
$ | $ | ||||||
$ | $ | $ |
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