Question
Lily Company estimates that unit sales will be 11,000 in quarter 1, 15,400 in quarter 2, 16,500 in quarter 3, and 19,800 in quarter 4.
Lily Company estimates that unit sales will be 11,000 in quarter 1, 15,400 in quarter 2, 16,500 in quarter 3, and 19,800 in quarter 4. The unit selling price is $70. 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 2022.
LILY COMPANY Production Budget choose the accounting period For the Six Months Ending June 30, 2022June 30, 2022For the Quarter Ending June 30, 2022 | |||||
---|---|---|---|---|---|
Quarter | |||||
1 | 2 | Six Months | |||
select an opening production budget item Direct Materials PurchasesTotal Required UnitsRequired Production UnitsBeginning Direct MaterialsExpected Unit SalesDesired Ending Direct MaterialsDirect Materials Per UnitDesired Ending Finished Goods InventoryTotal Materials RequiredBeginning Finished Goods Inventory | enter a number of units | enter a number of units | |||
select between addition and deduction AddLess: select a production budget item Beginning Finished Goods InventoryBeginning Direct MaterialsDesired Ending Direct MaterialsDirect Materials Per UnitTotal Materials RequiredExpected Unit SalesDirect Materials PurchasesTotal Required UnitsRequired Production UnitsDesired Ending Finished Goods Inventory | enter a number of units | enter a number of units | |||
select a summarizing line for the first part Direct Materials Per UnitDesired Ending Direct MaterialsDirect Materials PurchasesExpected Unit SalesTotal Materials RequiredBeginning Direct MaterialsDesired Ending Finished Goods InventoryRequired Production UnitsTotal Required UnitsBeginning Finished Goods Inventory | 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 item Beginning Direct MaterialsTotal Materials RequiredDirect Materials PurchasesDesired Ending Finished Goods InventoryRequired Production UnitsBeginning Finished Goods InventoryExpected Unit SalesDirect Materials Per UnitTotal Required UnitsDesired Ending Direct Materials | enter a number of units | enter a number of units | |||
select a closing production budget item Desired Ending Finished Goods InventoryExpected Unit SalesBeginning Direct MaterialsRequired Production UnitsBeginning Finished Goods InventoryTotal Required UnitsDirect Materials PurchasesDesired Ending Direct MaterialsTotal Materials RequiredDirect Materials Per Unit | 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