Our Services

Get 15% Discount on your First Order

M&M Case Study: Break-Even Analysis This exercise provides you the opportunity to apply break-even analysis concepts and Excel skills

February 25, 2024

M&M Case Study: Break-Even Analysis

This exercise provides you the opportunity to apply break-even analysis concepts and Excel skills to a case study problem. The activity continues our work with Mars Inc. M&M candies.

Assignment

Your company is a wholesaler of Mars candies, and you are responsible for the M&M product line. Mars has given you some pricing forecast data concerning 2022 product prices and payment terms. You need to determine the break-even points for your facility based on the information detailed below.

Plain M&M Analysis: You have identified the following 2022 price points on cases of Plain M&M candies from five different suppliers (variable costs)

· Supplier A: 48-count 1.74 oz bags will have a cost of $15.91 per case

· Supplier B: 48-count 1.74 oz bags will have a cost of $14.75 per case

· Supplier C: 48-count 1.74 oz bags will have a cost of $15.00 per case

· Supplier D: 48-count 1.74 oz bags will have a cost of $14.91 per case

· Supplier E: 48-count 1.74 oz bags will have a cost of $15.65 per case

Your additional costs are below:

· Fixed costs for your warehouse are $4,500,000 annually

· The selling price per case is $32.99

· Labor costs (variable cost) for the warehouse are $7.57 per case

· Marketing costs (variable cost) for the candy are $3.00 per case

Assignment:

Part #1:
You need to analyze the break-even point for each of the listed supplier options
(** Hint-You will need to calculate five break-even points).

In the Excel document for this assignment, there are five tabs named “Part #1 Supplier A” through “Part #1 Supplier E”. Each tab represents one of the five payment options. Complete the indicated break-even analysis by filling in the indicated columns, cells, and graphs. Remember, every chart must have a title, axis labels, axis titles, and a legend.

Determine the supplier option that results in the lowest break-even point based on the number of cases and dollars
(** Hint – it should be the same price point option for both the number of cases and dollars). Complete the information on the “Conclusions” tab for Part #1.

Part #2:
The market has changed. Your VP of sales indicates that the market will support a

$36.00 per case selling price. To accomplish this, however, marketing costs will need to be increased by 35%. You need to analyze the break-even point for the option you selected with the lowest break-even point in Part #1. Use the “Part #2” tab in the document for your analysis. Complete the information on the “Conclusion” tab for Part #2.

Part #3
– Finally, answer the question on the “Conclusions” tab for Part #3.

Submit one file with the filename

Breakeven.xlsx

image1.jpeg

image2.png

>Business & Finance homework help

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Module 5: Visual Media Why It Matters: Visual Media Our prehistoric ancestors struggled, rock in hand, to carve just the right picture into the wall

Module 5: Visual Media Why It Matters: Visual Media Our prehistoric ancestors struggled, rock in hand, to carve just the right picture into the wall of the cave, hoping that someone would come along and understand the story being told. They may have drawn stick figures with spears, or a

Both boards of nursing and national nursing associations have significant impacts on the nurse practitioner profession and scope of

Both boards of nursing and national nursing associations have significant impacts on the nurse practitioner profession and scope of practice. Understanding these differences helps lend credence to your expertise as a professional. In this Assignment, you will practice the application of such expertise by communicating a comparison of boards of

Problem-Solution Week 8: Problem-Solution Presentation · Submitting a website url, a media recording, or a

Problem-Solution Week 8: Problem-Solution Presentation · Submitting a website url, a media recording, or a file upload · Available after Apr 13 at 11:59pm This week, you will prepare your written argument for oral delivery. Imagine you have submitted a proposal in written form, and your audience asks you

MBA 620 Module Five Report Guidelines and RubricOverview When performing an evaluation to determine the performance or health of a company, it is important

MBA 620 Module Five Report Guidelines and RubricOverview When performing an evaluation to determine the performance or health of a company, it is important to identify and evaluate any current or potential risks the company might face. In this assignment, you will perform a risk assessment for TransGlobal Airlines to

In my discussion, I wrote about surgical site infection and use of nursing informatics The term “knowledge worker” was first coined by management

In my discussion, I wrote about surgical site infection and use of nursing informatics The term “knowledge worker” was first coined by management consultant and author Peter Drucker in his book, The Landmarks of Tomorrow (1959). Drucker defined knowledge workers as high-level workers who apply theoretical and analytical knowledge, acquired through

After viewing the YouTube Video Brain on Drugs, (1) Identify and discuss three new areas of learning related to the video. (2) How will this change the

After viewing the YouTube Video Brain on Drugs, (1) Identify and discuss three new areas of learning related to the video. (2) How will this change the way you view an individual’s drug addiction? This assignment should be at least three paragraphs, double- spaced, Times Roman 12-Point Font.

Assessment Description School counselors are leaders and advocates. In what ways does being involved in a professional organization, such as ASCA, help

Assessment Description School counselors are leaders and advocates. In what ways does being involved in a professional organization, such as ASCA, help school counselors be strong leaders and advocates within their schools and communities? This discussion question is informed by the following CACREP Standards: 2.F.1.d. The role and process of

EI and Sustainable Choices Emotional Intelligence (EI) enables leaders to make decisions that consider diverse stakeholder

EI and Sustainable Choices Emotional Intelligence (EI) enables leaders to make decisions that consider diverse stakeholder perspectives and environmental impacts, fostering ethical and sustainable choices. Explore the relationship between EI and ethical and sustainable choices in your field. Leaders equipped with high EI can navigate the challenges of ethical decision-making

Need names of all the rocks and minerals in the attached

Need names of all the rocks and minerals in the attached document image5.jpeg image6.jpeg image7.jpeg image8.jpeg image9.jpeg image10.jpeg image11.jpeg image12.jpeg image13.jpeg image14.jpeg image15.jpeg image16.jpeg image17.jpeg image18.jpeg image19.jpeg image20.jpeg image21.jpeg image1.jpeg image2.jpeg image3.jpeg image4.jpeg

Dispositions and Learning Environments [WLOs: 1, 2] [CLOs: 3, 4] Throughout this course, you have learned about various strategies supporting delays,

Dispositions and Learning Environments [WLOs: 1, 2] [CLOs: 3, 4] Throughout this course, you have learned about various strategies supporting delays, disabilities, and disorders across various domains of development. Along with understanding these strategies, in order to truly support the needs of children developing atypically, you must also reflect

Part I: How and why did the U.S. Military lose the war in Vietnam? Look at the military strategy, political and diplomatic limitations, and other

Part I: How and why did the U.S. Military lose the war in Vietnam? Look at the military strategy, political and diplomatic limitations, and other challenges. Part II: What advances did the military make during the war, as an organization? What issues did the military face by the end of the

only do the assessment 2. Business & the United Nations Sustainable Development Goals (UNSDGs) CORP3543 Contemporary Business Issues 1 Key

only do the assessment 2. Business & the United Nations Sustainable Development Goals (UNSDGs) CORP3543 Contemporary Business Issues 1 Key questions What are the Sustainable Development Goals? Why are they important? What is the role for business in achieving the SDGs? What are the current practices adopted by businesses? What

Business and Entrepreneurship INSTRUCTIONS: During the pandemic, some restaurants automatically included ″Gratuity″ in your bill. There was even a

Business and Entrepreneurship INSTRUCTIONS: During the pandemic, some restaurants automatically included ″Gratuity″ in your bill. There was even a ″COVID-19″ fee included. I′ve seen ″suggested″ tip start at 15%. Patrons called foul on restaurants that automatically included these fees. I remember seeing posts on social media by dissatisfied patrons complain that

Plagiarism Free In an essay, the student should briefly explain the subject of the articles, the areas of commonality, and the substantive differences in their

Plagiarism Free In an essay, the student should briefly explain the subject of the articles, the areas of commonality, and the substantive differences in their presentation. The student should then a