P3milestone

InProject3 you will analyse managerial and costing information to improve the company's EBITD activity-based costing and cost-volume-profit analysis to make recommendations about LGI's oper Step 1: Usethe informationyou calculated in Project 2 Tab 3 Profit Maximization to populatehas Step 2: Assumethe company operatesfor 12 monthsof the year convert theinformation you po to M for both the StandardandDeluxe Boxes. Step 3: Assume forthis projectthat the only variable costs in this company are materialsand lab

Standard Boxes Profit Maximization ( obtain Column C to H from Project 2) Price 5$22.00 $110.00 $10.00 5.5$21.60 $118.80 $10.00 6$21.20 $127.20 $10.00 6.5$20.80 $135.20 $10.00 7 $20.40 $142.80 $10.00 7.5 $20.00 $150.00 $10.00 8 $19.60 $156.80 $10.00 8.5 $19.20 $163.20 $10.00 9 $18.80 $169.20 $10.00 9.5 $18.40 $174.80 $10.00 10 $18.00 $180.00 $10.00 10.5 $17.60 $184.80 $10.00 11 $17.20 $189.20 $10.00 11.5 $16.80 $193.20 $10.00 12 $16.40 $196.80 $10.00 12.5 $16.00 $200.00 $10.00 13 $15.60 $202.80 $10.00 13.5 $15.20 $205.20 $10.00 14 $14.80 $207.20 $10.00 Deluxe Boxes Profit Maximization ( Columns C to H obtain from Project 2) Price 1$30.00 $30.00 $20.00 1.2$29.50 $35.40 $20.00 1.35$29.00 $39.15 $20.00 1.5$28.50 $42.75 $20.00 1.55$28.00 $43.40 $20.00 1.6$27.50 $44.00 $20.00 1.65$27.00 $44.55 $20.00 1.7$26.50 $45.05 $20.00InProject3 you will analyse managerial and costing information to improve the company's EBITD activity-based costing and cost-volume-profit analysis to make recommendations about LGI's oper Step 1: Usethe informationyou calculated in Project 2 Tab 3 Profit Maximization to populatehas Step 2: Assumethe company operatesfor 12 monthsof the year convert theinformation you po to M for both the StandardandDeluxe Boxes. Step 3: Assume forthis projectthat the only variable costs in this company are materialsand lab Standard boxes sold per month(millions)Revenue(price xvolume)Variable Cost per Standard box