HI I need assitance with these 5 questions

Questions: 1. How much of the fored costs were allocated between the Standard and Deluxe Boxes based on the Lumpsum Analysis Method? is the CEO correct that the Deluxe Box is not contributing much to company operating profit? Please elaborate on your answer and include evidence from Tab 1 of the Excel workbook. [insert your answer here] 2. The intern suggested splitting the costs, as you have done in the calculations performed in Tab 2 , based on sales volumes. Explain the impact of calculation performed in Tab 2, In your discussions, please elaborate on why the answer has changed from the calculations you performed in Tab L. Also indicate the benefit of accurate costing when trving to improve operating profit margins. linsert your answer herel 3. Based on the calculations in Tab 3 using ABC, comment on the operating profits made for each product. Explain in your report why operating profits have changed under ABC analysis. Also indicate which of the systems - that is the traditional systems (using lumpsum or volume-based cost allocation in Tab 1 and Tab 2) or the ABC systems, (Tab 3) provide the best answers for decision making to improve cost management in order to improwe operating profit. linsert your answer herel 4. The sustainablity manger is concemed about the Anti-Deluae Action group's impact on the company and supgested that materials and process of making the Deluxe flowes should be changed. As the process of making the Sustainable Deluxe Boces, will be less intensive, a suggestion is made that the selling price for the Sustainable Deluxe Boxes could be $23 per unit. Discuss whether changing the price to $23 is a viable option for LGI? Provide evidence from the Excel workbook, Tab 4. linsert your answer here] 5. If Largo Global inc decides to sell the Sustainable Deluxe Boxes at the price the CEO demands to maintain the same profit percentage as for Standard Boxes do you think the new price calculated in Tab 4is a viable option? Why is it important for tGI to know what their Breakeven quantity is? Aso indicate which other (non-numerical information) should be considered when deciding to pursue the Sustainable Delupe Box option. linsert your answer here]