Project 3 Report - How much of the fixed costs were allocated

Question # 00653501
Subject: Business
Due on: 07/06/2024
Posted On: 07/06/2024 05:23 AM
Tutorials: 1
Rating:
4.9/5
Question Dot Image

Project 3 Report

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.

Make sure that you look at opportunities to go the extra mile in your report through graphs , additional insights and high quality referenced sources. 

 

Questions:

1. How much of the fixed 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.

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 1. Also indicate the benefit of accurate costing when trying to improve operating profit margins.

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 improve operating profit.

4.The sustainability manger is concerned about the Anti-Deluxe Action group’s impact on the company and suggested that materials and process of making the Deluxe Boxes should be changed. As the process of making the Sustainable Deluxe Boxes, 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.

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 4 is a viable option? Why is it important for LGI to know what their Breakeven quantity is? Also indicate which other (non-numerical information) should be considered when deciding to pursue the Sustainable Deluxe Box option.

Dot Image
Getsolution Posted By :
Questions: 15084 Tutorials: 15083
Tutorials for this Question

Project 3 Report - How much of the fixed costs were allocated

Tutorial # 00652396
Posted On: 07/06/2024 05:25 AM
Feedback Score: Not rated yet!
Purchased By: 2
Getsolution
Posted By:
Questions:
15084
Tutorials:
15083
Report this Tutorial as Inappropriate
Tutorial Preview
The solution of Project 3 Report - How much of the fixed costs were allocated...
Attachments
Project_3_Report_-_How_much_of_the_fixed_costs_were_allocated.ZIP (18.96 KB)

Great! We have found the solution of this question!

Related Questions
How To Write A Great Information Technology Strategic Plan
How To Write A Great Information Technology Strategic Plan . Pick a fortune 500 company . List the advancement over the next 5 years that this company should acheive to be successful. Then write a doc …
Imagine that the CFO of your manufacturing company is seeking
Assignment-5 Imagine that the CFO of your manufacturing company is seeking your help regarding a decision to switch to an Activity Based Costing system from their traditional Absorption Costing sys …
Lewin’s theory was created in the 1940s,How would you modify
Lewin’s theory was created in the 1940s. How would you modify/alter his theory to ensure that it remains relevant and applicable within KSA? Discuss any changes to be made to his theory to refle …
Unit 4 Multivariate Data Analysis and Management Project
Unit 4 Multivariate Data Analysis and Management Project Using the information from Units 1, 2, & 3, Big D Incorporated will be examining how multivariate techniques can serve the organization …
Marketing Unit 4 Discussion - Big D Incorporated is nearing completion
Marketing unit 4 Primary Task Response: Within the Discussion Board area, write 400-600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the …
Workplace Conflict Resolution And Ethical Standards
AU Workplace Conflict Resolution And Ethical Standards Discussion 1)In a response, describe a conflict situation you have experienced in the workplace. Explain the impact that the communication pro …
Machine Utilization Gantt Chart -Sequence the jobs shown
Saudi Electronic University Machine Utilization Gantt Chart Assignment Question(s): (Marks 5) Question 1:  Sequence the jobs shown below by using a Gantt chart. Assume that the move time …
Discussion - Starting a consultant business
Discussion: Starting a consultant business Focused on the knowledge and skills needed to start a business, including marketing and branding. Create a discussion post related to the concepts in the …
Business - Assess an established economic theory
Business Question Your assignment is to assess an established economic theory or economic policy or treaty that affects more than one country. You will write an 8- 12 page argumentative/persuasive …
The word ethics usually evokes a strong emotional reaction or opinion
The word ethics usually evokes a strong emotional reaction or opinion from most business students The word ethics usually evokes a strong emotional reaction or opinion from most business …
Recent Questions
How To Write A Great Information Technology Strategic Plan
How To Write A Great Information Technology Strategic Plan . Pick a fortune 500 company . List the advancement over the next 5 years that this company should acheive to be successful. Then write a doc …
Leadership Essay - Choose any two leaders who you consider
 South University Leadership Essay put well-known personalities and  yourself under the microscope to learn what makes you and the  individuals you select not only leaders but also w …
Open Heart Surgery - Why is the hospital considering
South University Open Heart Surgery Case Study  read Case 19: The Case for Open Heart Surgery at Cabarrus Memorial Hospital Why is the hospital considering this additional service? …
Community Blood Center Full Case Analysis
South University Community Blood Center Full Case Analysis Review the case: Community Blood Center of the Carolinas: Donations, Donations, Donations.  Complete  a full case analysis in …
Imagine that the CFO of your manufacturing company is seeking
Assignment-5 Imagine that the CFO of your manufacturing company is seeking your help regarding a decision to switch to an Activity Based Costing system from their traditional Absorption Costing sys …
Lewin’s theory was created in the 1940s,How would you modify
Lewin’s theory was created in the 1940s. How would you modify/alter his theory to ensure that it remains relevant and applicable within KSA? Discuss any changes to be made to his theory to refle …
Unit 2 Chicago versus United States Demographic Profile Analysis
Unit 2 Chicago versus United States Demographic Profile Analysis Presentation For this assignment, you will need to become familiar with specialized business intelligence (BI) software, then downlo …
Intercultural Communication Competence - identify what techniques you can implement
Ashford University Intercultural Communication Competence Discussion 1)In a 250-300 word response, identify what techniques you can implement to improve the likelihood that your communications will …
Unit 4 Multivariate Data Analysis and Management Project
Unit 4 Multivariate Data Analysis and Management Project Using the information from Units 1, 2, & 3, Big D Incorporated will be examining how multivariate techniques can serve the organization …
Marketing Unit 4 Discussion - Big D Incorporated is nearing completion
Marketing unit 4 Primary Task Response: Within the Discussion Board area, write 400-600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the …