On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017 Sales units First quarter5,300 second quarter6,700 third quarter7,800 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,430units The ending raw materials and finished goods inventories at December 31, 2016, follow the same percentage relationships to production and sales that occur in 2017 4pounds of raw materials are required to make each unit of finished goods Raw materials purchased are expected to cost $4per pound (a)Prepare a production budget by quarters for the 6 month period ended June 30, 2017 HARDIN COMPANY Production Budget June 30, 2017For the Quarter Ending June 30, 2017For the Six Months Ending June 30, 2017 Quarter 1 2 Year Expected Unit SalesDirect Materials PurchasesDesired Ending Direct MaterialsDirect Materials Per UnitTotal Required UnitsBeginning Direct MaterialsTotal Materials RequiredDesired Ending Finished Goods UnitRequired Production UnitsBeginning Finished Goods Unit AddLess Total Materials RequiredExpected Unit SalesRequired Production UnitsDirect Materials PurchasesTotal Required UnitsBeginning Finished Goods UnitDirect Materials Per UnitBeginning Direct MaterialsDesired Ending Direct MaterialsDesired Ending Finished Goods Unit Direct Materials Per UnitTotal Required UnitsExpected Unit SalesDirect Materials PurchasesBeginning Finished Goods UnitRequired Production UnitsDesired Ending Direct MaterialsTotal Materials RequiredBeginning Direct MaterialsDesired Ending Finished Goods Unit AddLess Direct Materials PurchasesDesired Ending Direct MaterialsTotal Required UnitsExpected Unit SalesDirect Materials Per UnitBeginning Finished Goods UnitDesired Ending Finished Goods UnitTotal Materials RequiredRequired Production UnitsBeginning Direct Materials Expected Unit SalesDirect Materials Per UnitDirect Materials PurchasesRequired Production UnitsTotal Materials RequiredDesired Ending Finished Goods UnitTotal Required UnitsBeginning Finished Goods UnitBeginning Direct MaterialsDesired Ending Direct Materials

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 28, 2024

On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017. Sales

On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017.

Sales units:	First quarter5,300; second quarter6,700; third quarter7,800
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,430units.

The ending raw materials and finished goods inventories at December 31, 2016, follow the same percentage relationships to production and sales that occur in 2017.4pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $4per pound.

(a)Prepare a production budget by quarters for the 6-month period ended June 30, 2017.

HARDIN COMPANY Production Budget June 30, 2017For the Quarter Ending June 30, 2017For the Six Months Ending June 30, 2017
Quarter
1	2	Year
Expected Unit SalesDirect Materials PurchasesDesired Ending Direct MaterialsDirect Materials Per UnitTotal Required UnitsBeginning Direct MaterialsTotal Materials RequiredDesired Ending Finished Goods UnitRequired Production UnitsBeginning Finished Goods Unit
AddLess: Total Materials RequiredExpected Unit SalesRequired Production UnitsDirect Materials PurchasesTotal Required UnitsBeginning Finished Goods UnitDirect Materials Per UnitBeginning Direct MaterialsDesired Ending Direct MaterialsDesired Ending Finished Goods Unit
Direct Materials Per UnitTotal Required UnitsExpected Unit SalesDirect Materials PurchasesBeginning Finished Goods UnitRequired Production UnitsDesired Ending Direct MaterialsTotal Materials RequiredBeginning Direct MaterialsDesired Ending Finished Goods Unit
AddLess: Direct Materials PurchasesDesired Ending Direct MaterialsTotal Required UnitsExpected Unit SalesDirect Materials Per UnitBeginning Finished Goods UnitDesired Ending Finished Goods UnitTotal Materials RequiredRequired Production UnitsBeginning Direct Materials
Expected Unit SalesDirect Materials Per UnitDirect Materials PurchasesRequired Production UnitsTotal Materials RequiredDesired Ending Finished Goods UnitTotal Required UnitsBeginning Finished Goods UnitBeginning Direct MaterialsDesired Ending Direct Materials