Question
Lily Industries had sales in 2021 of $5,467,200 and gross profit of $884,400. Management is considering two alternative budget plans to increase its gross profit
Lily Industries had sales in 2021 of $5,467,200 and gross profit of $884,400. Management is considering two alternative budget plans to increase its gross profit in 2022. Plan A would increase the unit selling price from $8.00 to $8.40. Sales volume would decrease by 100,500 units from its 2021 level. Plan B would decrease the unit selling price by $0.50. The marketing department expects that the sales volume would increase by 104,520 units. At the end of 2021, Lily has 32,160 units of inventory on hand. If Plan A is accepted, the 2022 ending inventory should be 28,140units. If Plan B is accepted, the ending inventory should be equal to 48,240 units. Each unit produced will cost $1.5 in direct labor, $1.3 in direct materials, and $1.2 in variable overhead. The fixed overhead for 2022 should be $1,523,580.
(a)
Prepare a sales budget for 2022 under each plan. (Round Unit selling price answers to 2 decimal places, e.g. 52.70.)
LILY INDUSTRIES Sales Budget choose the accounting period For the Quarter Ending December 31, 2022For the Year Ending December 31, 2022December 31, 2022 | ||||
---|---|---|---|---|
Plan A | Plan B | |||
select an opening sales budget item Direct LaborDirect MaterialsExpected Unit SalesProduction UnitsTotal SalesUnit Selling Price | enter a number of units | enter a number of units | ||
select a sales budget item Direct LaborDirect MaterialsExpected Unit SalesProduction UnitsTotal SalesUnit Selling Price | $enter a dollar amount rounded to 2 decimal places | $enter a dollar amount rounded to 2 decimal places | ||
select a closing sales budget item Direct LaborDirect MaterialsExpected Unit SalesProduction UnitsTotal SalesUnit Selling Price | $enter a total amount for the sales budget | $enter a total amount for the sales budget |
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