MY NUMBER 3

Project 3 Questions – Report Template

Instructions: Answer the five questions below. They focus entirely on improving the EBITDA of Largo Global Inc. (LGI) based on the information provided in the Excel workbook. Provide support for your reasoning from the readings in Project 3, Step 1, and the discussion in Project 3, Step 3. Be sure to cite your sources in APA 7th ed. style.

Provide a detailed response below each question. Use 12-point font and double spacing. Maintain the existing margins in this document. Your final Word document, including the questions, should not exceed 5 pages. Include a title page in addition to the five pages. Any tables and graphs you choose to include are excluded from the five-page limit. Name your document as follows: P3_Final_lastname_Report_date.

You must address all five questions and make full use of the information on all tabs.

You are strongly encouraged to exceed the requirements by refining your analysis. Consider other tools and techniques that were discussed in the required and recommended reading for Project 3. This means adding an in-depth explanation of what happened in the year for which data was provided to make precise recommendations to LGI.

Title Page

Name

Course and section number

Faculty name

Submission date

Questions:

1. How much of the costs were allocated between the standard and deluxe models of the product? Is the marketing manager correct that LGI is making significant margins on the Deluxe Loot Box? Please elaborate on your answer and include evidence from Tab 1 of the Excel workbook.

[insert your answer here]

2. The IT manager indicated that splitting the costs, as you have done in the calculations performed in Tab 2, does nothing to improve the bottom line. She said: "The amounts are relatively small and as it all comes from the same pot in the end, there is no need to split the costs, it just creates additional coding categories for the system." Explain why the calculation performed in Tab 2 is important. In your discussions, also indicate the benefit of accurate costing when trying to improve profit margins.

[insert your answer here]

3. Based on the calculations in Tab 3 using ABC, comment on the profits made for each product type. Explain in your report why this has changed under ABC costing. Also indicate which one of the two systems; that is, historical cost or ABC, provides the best answers for decision making to improve cost management to improve EBITDA.

[insert your answer here]

4. The marketing manager suggested that to improve EBITDA and increase sales volume, the Deluxe Loot Box should be sold at the same margin as the Standard Loot Box. Base your answers on the ABC calculations performed in Tab 3 to indicate how much Largo will need to charge for the Deluxe Loot Box. Indicate how many Deluxe Loot Boxes the company will have to sell at the new price to break even. Discuss whether changing the price is a viable option for Largo. Provide evidence from the Excel workbook, Tab 4.

[insert your answer here]

5. If Largo Global Inc. is unable to sell the Deluxe Loot Box for more than $27.86, discuss possible alternatives. Doing the same thing LGI is already doing is not an option; you must suggest how to improve EBITDA.

Discuss the facts that should be considered in determining whether manufacturing the Loot Boxes in-house could lead to a price reduction. No calculations are required for Question 5

[insert your answer here]