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

500 word discussion 2 references/intext citations Due 7/2/2024 A. Formal Discussion Question: You must answer all

500 word discussion 2 references/intext citations Due 7/2/2024 A. Formal Discussion Question: You must answer all three queries below, and scholarly citations and references must be included in your responses- Your response to this discussion question must be at least 500 words, substantive, contain appropriate citations, and all references

Description We worked together on my research which will be attached in the attachments. I would like you to make me a PowerPoint presentation

Description We worked together on my research which will be attached in the attachments. I would like you to make me a PowerPoint presentation containing the research details like the introduction, the objectives, references, and the prisma and other details. 1 Master of Healthcare Administration HCM 600 Research Project The

Topic: S. 1339: Pharmacy Benefit Manager Reform Act 1. Analyze the law and generate a concise overview of the key aspects using

Topic: S. 1339: Pharmacy Benefit Manager Reform Act 1. Analyze the law and generate a concise overview of the key aspects using your own language. Provide the bill number and title. (Alternatively, you can utilize H.R. or S.R. as these are legislation now in the resolution phase). 2. 1. The

Parasites – Eating Us Alive! BIOL 2268: Medical Microbiology Lab Due in D2L Assignment folder on Tuesday, March 5, 11:59 pm NOTE: This

Parasites – Eating Us Alive! BIOL 2268: Medical Microbiology Lab Due in D2L Assignment folder on Tuesday, March 5, 11:59 pm NOTE: This content associates with Chapter 12 in the lecture course. Instructions: Complete the following lab exercise assignment (type your answers into the document using a different colored font).

Who can assist with two (2) APA formatted human-written responses, including citations to the following? Case Study 1 Psoriasis is a chronic autoimmune

Who can assist with two (2) APA formatted human-written responses, including citations to the following? Case Study 1 Psoriasis is a chronic autoimmune condition characterized by red, inflamed, a

The purpose of this exercise is to conduct a brief examination of the book of the prophet Amos employing the ‘three-world’ organizing framework for

The purpose of this exercise is to conduct a brief examination of the book of the prophet Amos employing the ‘three-world’ organizing framework for literary analysis. At the same time, it is an opportunity to explore the book about the oracles and life of one of Israel’s great prophets, the

attached Comment about this post: Hi Everyone! I very much enjoyed this week’s readings on intimacy. This week’s topic really got me thinking about

attached Comment about this post: Hi Everyone! I very much enjoyed this week’s readings on intimacy. This week’s topic really got me thinking about intimacy and the importance of intimacy in relationships. I think we can all agree that intimacy is one of the building blocks of a meaningful friendship

GEOL 1447 Name: _ Meteorology Date: _ Lab 3 Temperature Structure of the Lower Atmosphere Main Lab Assignment

GEOL 1447 Name: _______________________ Meteorology Date: _______________________ Lab 3 Temperature Structure of the Lower Atmosphere Main Lab Assignment Adapted from Introduction to Meteorology Lab Manual by Professor Bart Geerts, University of Wyoming I. Introduction The vertical profile of atmospheric temperature, dewpoint (a measure of the moisture content of the air),

Context A large proportion of promotional decisions occur at the manager level with HR facilitating the process. Generally, there is a great deal of

Context A large proportion of promotional decisions occur at the manager level with HR facilitating the process. Generally, there is a great deal of organizational value in employee promotion, however, trend analysis indicates that there are potential and unforeseen pitfalls as well. Post a Response Describe both of the following

Directions: Write a 200-250-word response to one of these questions. no chat gpt or plagiarism. You can find “Edison, New Jersey” in our textbook or you

Directions: Write a 200-250-word response to one of these questions. no chat gpt or plagiarism. You can find “Edison, New Jersey” in our textbook or you can find it here:”Edison, New Jersey” by Junot Diaz EDISON, NEW JERSEY – Junot Diaz Answer 1 of the following questions about the story: 1.

Description 510 Dis (Eman) The Saudi Food and Drug Authority and the Ministry of Health have objectives as a component of Saudi Vision 2030’s

Description 510 Dis (Eman) The Saudi Food and Drug Authority and the Ministry of Health have objectives as a component of Saudi Vision 2030’s healthcare strategy. The National Transformation Program of Saudi Arabia provided guidance for the establishment of the healthcare goals for the country’s vision in 2030(Ali, 2018). The

How important is corporate governance when it comes to investing in a firm? Does a firm’s social presence need to be considered before an individual decides to

How important is corporate governance when it comes to investing in a firm? Does a firm’s social presence need to be considered before an individual decides to invest? Why, or why not?

sdfs gs gsjlgs, gskgn sgwkengs.ke, g Page 3 III. Page: Conflict Management Essentials A. Crucial Conversation Skills B. Conflict Management in the

sdfs gs gsjlgs, gskgn sgwkengs.ke, g Page 3 III. Page: Conflict Management Essentials A. Crucial Conversation Skills B. Conflict Management in the Healthcare Setting Write a paragraph (400 words ) that provides and highlights the major and essential features of A. Crucial Conversation Skills B. Conflict Management in the Healthcare

instructions are attached APA style. APA Format, in-text citations and references Please include the reference a

instructions are attached APA style. APA Format, in-text citations and references Please include the reference after each answer as numbered below. 2.Describe the pros and cons of having retention elections for state judges. 3. Discuss what professionals have attempted in an effort to curb school shootings. 5. Define system, estimator,

1- Read “Case 18.3: Wearable Technologies Supporting AI in Healthcare” and write an essay that answers the following questions: 1. What is

1- Read “Case 18.3: Wearable Technologies Supporting AI in Healthcare” and write an essay that answers the following questions: 1. What is wearable technology, and how has it evolved beyond its initial purpose of tracking athletic activities? 2. What are the different types of data that wearable technology can collect,

5-3 Journal: Final Project Question 2 In this assignment, you will write a journal entry in which you choose another question or area that you would like to

5-3 Journal: Final Project Question 2 In this assignment, you will write a journal entry in which you choose another question or area that you would like to address as part of your final project; you

DISCUSSION RESPONCE DATA SCIENCE APPLICATIONS AND PROCESSES DATA SCIENCE APPLICATIONS AND PROCESSES Read a selection of your colleagues’ responses

DISCUSSION RESPONCE DATA SCIENCE APPLICATIONS AND PROCESSES DATA SCIENCE APPLICATIONS AND PROCESSES Read a selection of your colleagues’ responses and respond to two of your colleagues. Expand upon your colleague’s posting or offer an alternative perspective. PEER #1 Shinu Mary Rajan Data Science, Application and Process Leveraging data is essential for supporting initiatives in