Question
Paige Company estimates that unit sales will be 11,000 in quarter 1, 12,800 in quarter 2, 15,000 in quarter 3, and 18,900 in quarter 4.
Paige Company estimates that unit sales will be 11,000 in quarter 1, 12,800 in quarter 2, 15,000 in quarter 3, and 18,900 in quarter 4. Management desires to have an ending finished goods inventory equal to 25% of the next quarters expected unit sales. Prepare a production budget by quarters for the first 6 months of 2020.
PAIGE COMPANY Production Budget choose the accounting period June 30, 2020For the Six Months Ending June 30, 2020For the Quarter Ending June 30, 2020 | |||||
---|---|---|---|---|---|
Quarter | |||||
1 | 2 | Six Months | |||
select an opening production budget item Required Production UnitsTotal Materials RequiredBeginning Direct MaterialsTotal Required UnitsBeginning Finished Goods InventoryExpected Unit SalesDesired Ending Finished Goods InventoryDesired Ending Direct MaterialsDirect Materials Per UnitDirect Materials Purchases | enter a number of units | enter a number of units | |||
select between addition and deduction AddLess : select a production budget itemTotal Materials RequiredTotal Required UnitsBeginning Finished Goods InventoryDirect Materials PurchasesDirect Materials Per UnitBeginning Direct MaterialsRequired Production UnitsDesired Ending Finished Goods InventoryDesired Ending Direct MaterialsExpected Unit Sales | enter a number of units | enter a number of units | |||
select a summarizing line for the first part Desired Ending Finished Goods InventoryExpected Unit SalesRequired Production UnitsTotal Materials RequiredBeginning Finished Goods InventoryDirect Materials Per UnitBeginning Direct MaterialsDesired Ending Direct MaterialsDirect Materials PurchasesTotal Required Units | enter a total number of units for the first part | enter a total number of units for the first part | |||
select between addition and deduction AddLess : select a production budget itemBeginning Finished Goods InventoryTotal Materials RequiredBeginning Direct MaterialsDesired Ending Direct MaterialsTotal Required UnitsDesired Ending Finished Goods InventoryDirect Materials Per UnitDirect Materials PurchasesExpected Unit SalesRequired Production Units | enter a number of units | enter a number of units | |||
select a closing production budget item Direct Materials Per UnitExpected Unit SalesBeginning Direct MaterialsRequired Production UnitsDirect Materials PurchasesDesired Ending Direct MaterialsTotal Materials RequiredTotal Required UnitsBeginning Finished Goods InventoryDesired Ending Finished Goods Inventory | enter a total number of units | enter a total number of units | enter a total number of units |
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