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

please read the complete and read thoroughly. NO AIs and attached there are two parts please complete worksheet and discussion. Attached are tools you

please read the complete and read thoroughly. NO AIs and attached there are two parts please complete worksheet and discussion. Attached are tools you will need to watch, read a to complete.

Consider the feedback you received from your peers and your instructor, and revise your story. Add a paragraph at the end explaining what you revised,

Consider the feedback you received from your peers and your instructor, and revise your story. Add a paragraph at the end explaining what you revised, and/or what revisions you decided against and why. Submit the revised version through the assignment link. Grading criteria: Your story exhibits the original criteria and

Create a pamphlet using any type of publisher software you choose to educate clients on a current patient safety issue.

You have the option to write a 2 page double spaced, 12 font reflection. OR you have the option to send in a 3-5 minute video. The reflection will

You have the option to write a 2 page double spaced, 12 font reflection. OR you have the option to send in a 3-5 minute video. The reflection will cover the main points of the chapter that resonated with you as well as the article and how you would use

How Can eBay Dropshipping Automation Transform Your Selling Strategy?

For this assignment, students will reflect on and evaluate their teaching presentation to determine how to improve for next time. The Community Teaching

For this assignment, students will reflect on and evaluate their teaching presentation to determine how to improve for next time. The Community Teaching Project has indirect care experience requirements. The “Indirect Care Experience Hours” form, found in the Topic 1 Resources, will be used to document the indirect care experience

This assignment asks you to review and analyze the “Costco” case study on pp. C-18-42 of your textbook and respond to the following questions using both

This assignment asks you to review and analyze the “Costco” case study on pp. C-18-42 of your textbook and respond to the following questions using both theory and practical managerial thinking. For t This assignment asks you to review and analyze the “Costco” case study on pp. C-18-42 of your

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

This is a synthesis of research and common themes should form your supporting paragraphs

using both papers write me my own. use both as a reference. This is my friend’s papers. use the same evidence with video evidence (master Clinician) but

using both papers write me my own. use both as a reference. This is my friend’s papers. use the same evidence with video evidence (master Clinician) but throw in evidence from different sources about Down syndrome. Down syndrome – Symptoms and causes – Mayo Clinic this link is a

See attached doc Case Study Analysis – . Submit a 1-2 page paper. Use the following

See attached doc Case Study Analysis – . Submit a 1-2 page paper. Use the following information to formulate your analysis Mrs. Catherine Jones is a 74-year-old female who presents to you clinic with complaints of increased difficulty in getting up from a seated position and worsening right knee

Your assignment is a Unit Plan, which means that you must provide at least 5 lessons in plans. As you have likely noticed, we are using some of the

Your assignment is a Unit Plan, which means that you must provide at least 5 lessons in plans. As you have likely noticed, we are using some of the same scenarios that we used for our gradual release model lesson plan. IF you plan to use the same scenario, you

Geriatric Interview Questions You will have three interviews in total. You will interview someone who is between 18-30. You will do

Geriatric Interview Questions You will have three interviews in total. You will interview someone who is between 18-30. You will do another interview with someone between 35-50. Your last interview will be with someone who is 65 and older. Use the same questions each time. We will compare the answers

Scientific Reading Assignment Instructions: You can choose any of the three articles (below) to read and answer questions about. As you read, keep in mind

Scientific Reading Assignment Instructions: You can choose any of the three articles (below) to read and answer questions about. As you read, keep in mind what you think is good about these and what you’d do differently. I don’t expect for you to know all of the details of how

Diagram Answer Based on the scenario provided, here’s a step-by-step guide on how to create a data flow diagram (DFD) for the

Diagram Answer Based on the scenario provided, here’s a step-by-step guide on how to create a data flow diagram (DFD) for the Medical Center of DeVry: Step 1: Identify External Entities External entities are the sources and destinations of information entering and leaving the system. In this case, the external

The Presentation should cover the final Phase V “Scaling-It” of The Innovator’s Method. Here are the required elements in the Presentation: Required

The Presentation should cover the final Phase V “Scaling-It” of The Innovator’s Method. Here are the required elements in the Presentation: Required Topics To Cover in the Presentation: (1) Scaling the market and process (2) Implementing the V2MOM Vision-Values-Methods-Obstacles-Measures Scaling Tool (3) Developing a WPS Whole Product Solution (4) Braving