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

min 175 words Discuss the following with the class: Describe three situations where you have used a spreadsheet in your personal or professional life. Next,

min 175 words Discuss the following with the class: Describe three situations where you have used a spreadsheet in your personal or professional life. Next, think about two new scenarios where you cou

EVIDENCE BASE IN DESIGN When politics and medical science intersect, there can be much debate. Sometimes anecdotes or hearsay are misused as evidence

EVIDENCE BASE IN DESIGN When politics and medical science intersect, there can be much debate. Sometimes anecdotes or hearsay are misused as evidence to support a particular point. Despite these and other challenges, however, evidence-based approaches are increasingly used to inform health policy decision-making regarding causes of disease, intervention strategies,

Art Discussion Post: Why are mosaic and tapestry discussed in a chapter on painting? In what ways are these art forms similar to painting? How do they depart

Art Discussion Post: Why are mosaic and tapestry discussed in a chapter on painting? In what ways are these art forms similar to painting? How do they depart from painting? ”please reference chapter 7

requesting guidance Introduction Welcome to our Final Essay. The last few weeks have been spent analyzing other essays.We have

requesting guidance Introduction Welcome to our Final Essay. The last few weeks have been spent analyzing other essays.We have read a variety of mostly online articles, closely examining how effective their argument is. Now it is your turn. For this Final essay, you will use the various content from this

analyze how health care fraud can be identified. Many of the detection strategies in financial services can be applied, remember- a transaction is a

analyze how health care fraud can be identified. Many of the detection strategies in financial services can be applied, remember- a transaction is a transaction! You can use multiple case examples to identify the scenarios and specific data that could/should have been monitored to identify the fraud. Use additional research

several vulnerable populations who are susceptible to chronic illnesses Healthy People 2030 objectives for the older adult.

5.4 Assignment: Journal – The Curiosity Conversation Getting Started This journal entry is an extension of the previous

5.4 Assignment: Journal – The Curiosity Conversation Getting Started This journal entry is an extension of the previous assignment in 5.3, where you summarized the findings of your curiosity conversation with a pastor or counselor. This assignment goes beyond just reporting the details of the conversation to a personal integration

Help to explain how to get to the answer and the steps involved.

Closely examine one International Organization and determine if the Organization is still relevant and effective in today’s global environment. Write: a

Closely examine one International Organization and determine if the Organization is still relevant and effective in today’s global environment. Write: a persuasive 3- 5 page essay about this organization which addresses the key points below Remember: This is a persuasive essay/presentation, and your goal is to focus on one organization, explore key questions about

select an area of improvement in the healthcare setting. You will do an RCA for this area this week. Tasks: Visit the following

select an area of improvement in the healthcare setting. You will do an RCA for this area this week. Tasks: Visit the following link:Determine-root-cause-5-whys Read the introduction to RCA( Root Cause Analysis). Read the RCA process. Conduct and report an RCA for the area of improvement you selected. Include

Discuss the recent developments that have generated widespread concern for white-collar crime in the United States.

There are many forms of abuse in the current US medical system. Some of these abuses are initiated by medical professional and some are initiated by the

There are many forms of abuse in the current US medical system. Some of these abuses are initiated by medical professional and some are initiated by the consumer. Explore “both sides” of this issue as you research the topic this week.

For this exercise, you will need to create a crime scene sketch. Choose a room in your home that has five items of evidence and four items that are not

For this exercise, you will need to create a crime scene sketch. Choose a room in your home that has five items of evidence and four items that are not evidence. Complete a hand-drawn sketch and submit it as either a photograph or scan. Follow the lecture provided to guide

Review the Learning Resources assigned this week.Review the Concept Map resources.Explore the listed agonist spectrum and consider the action and receptor of

Review the Learning Resources assigned this week.Review the Concept Map resources.Explore the listed agonist spectrum and consider the action and receptor of each:AgonistPartial agonistAntagonistInver

Worksheet 2.1: Letter of Inquiry Questionnaire [removed]

Learning for Early childhood education Age 3-5 This assignment serves as a compilation of influential works you have read/viewed over the thirteen

Learning for Early childhood education Age 3-5 This assignment serves as a compilation of influential works you have read/viewed over the thirteen week period. A bibliography, personal summary and analysis of the chosen literature and readings that helped shaped your course learning is required. The intention is to keep a

One of the most important uses of these statements is to evaluate past performance and project future performance. Investors use the financial

One of the most important uses of these statements is to evaluate past performance and project future performance. Investors use the financial statements in many ways. Address one of the following prompts in a brief but thorough manner. What are the major financial statements and what types of information does