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

As a way to introduce yourself to the rest of the class, please tell tell us a bit about you: 1. Tell us about your experiences with Anatomy &

As a way to introduce yourself to the rest of the class, please tell tell us a bit about you: 1. Tell us about your experiences with Anatomy & Physiology. Did you enjoy the course or find it challenging? In what way? Do you feel prepared to begin the study

Upload a draft of your Annotated Bibliography . You will receive full credit if your draft has MLA style citations and 150+ word annotation paragraphs for

Upload a draft of your Annotated Bibliography . You will receive full credit if your draft has MLA style citations and 150+ word annotation paragraphs for all 5 sources. The last day to submit a late draft is Friday, May 17th. Submitting a complete first draft can you earn 10 of points for this assignment. The

Prompt: Write a three-to-four-page paper on the Kingdom of God as the “big picture” or the “storyline” of the Bible (title page and works cited page are not

Prompt: Write a three-to-four-page paper on the Kingdom of God as the “big picture” or the “storyline” of the Bible (title page and works cited page are not included in the page count). Make sure to i

Research paper topic Syrian Presbyterian Culture and Notions of Familial Piety You will do in depth researchYour presentation will focus on some (not all)

Research paper topic Syrian Presbyterian Culture and Notions of Familial Piety You will do in depth researchYour presentation will focus on some (not all) of the following regarding the cultural group:body language/gesture aspects; notions of etiquette; gender, age, religion influences; notionsof “work”; holidays, clothing, religious traditions; sporting activities; educational systems;

Discourse Community Draft #144 unread replies.44 replies. Purpose of the Assignment: To practice drafting a discourse community analysis paper and get feedback

Discourse Community Draft #144 unread replies.44 replies. Purpose of the Assignment: To practice drafting a discourse community analysis paper and get feedback on an early stage draft. To practice giv

You are required to deliver a presentation which demonstrates your understanding of perspectives in psychology. Your presentation must include the

You are required to deliver a presentation which demonstrates your understanding of perspectives in psychology. Your presentation must include the following:- • A description of two psychological perspectives. • An evaluation of the key assumptions of the identified psychological perspectives. • An evaluation of the work of key theorists relating

President Kennedy enacted a major change to our health care state by deinstitutionalizing those with mental illness. However, those with mental health care

President Kennedy enacted a major change to our health care state by deinstitutionalizing those with mental illness. However, those with mental health care issues must navigate a complex system of ca

In this course, you will experience the first segment of a multi-year integrated case study that offers you the opportunity to apply the knowledge gained

In this course, you will experience the first segment of a multi-year integrated case study that offers you the opportunity to apply the knowledge gained in the course to a real-world situation. The case study weaves together practical application with doctoral research by requiring that the business decisions made regarding

Week 6 Research Proposal Project: Data Analysis Plan Data Analysis Plan For this section of your research proposal assignment,

Week 6 Research Proposal Project: Data Analysis Plan Data Analysis Plan For this section of your research proposal assignment, you will carefully design a plan for analyzing your quantitative data. Explain in detail how you will go about analyzing your data. Be sure to: · Include definitions of all variables

Submit a 1,000 word research paper outline on the following: Examine and describe the healthcare delivery system in the country of Tanzania and analyze the

Submit a 1,000 word research paper outline on the following: Examine and describe the healthcare delivery system in the country of Tanzania and analyze the political, social, ethical, and financial in

write a well developed essay using this outline and works cited page Thesis- The rapid advancement of artificial intelligence technology has sparked fears

write a well developed essay using this outline and works cited page Thesis- The rapid advancement of artificial intelligence technology has sparked fears about its potential to disrupt traditional employment structures, leading to job displacement and economic instability in various sectors I. IntroductionA. Defining AI and automationB. Rising concerns about AI’s impact on jobs and

Alexis – Disc. 4 Alexis Dea Good Morning Team, Today, I want to discuss a critical issue that

Alexis – Disc. 4 Alexis Dea Good Morning Team, Today, I want to discuss a critical issue that affects our company’s growth, culture, and social responsibility: the lack of diversity and inclusion in innovation and marketing. This problem not only influences our internal environment but also impacts how our

INSTRUCTIONS- · Answer the five (5) quiz questions below. Answer questions that · Provide an evidence-based rationale for each of your answers to

INSTRUCTIONS- · Answer the five (5) quiz questions below. Answer questions that · Provide an evidence-based rationale for each of your answers to the five (5) questions. · Provide a citation and matching reference is required from the course textbook for each of the five (5) rationales. Textbook name provide below

You are required to create a thread in response to 1 of the 4-5 provided prompts (choose only 1) for each forum.

TH3001 Critical and Creative Thinking and Problem Solving(Written Communication)

Create a risk breakdown structure for John’s move shown on Figure 11.5. Copy and fill in all the text in the Excel Template I have provided for you

Create a risk breakdown structure for John’s move shown on Figure 11.5. Copy and fill in all the text in the Excel Template I have provided for you here: Risk Breakdown Structure.xlsxDownload Risk Breakdown Structure.xlsx Add your name, and save a copy to your hard or flash drive. Then upload

Cite examples of how operations research works in tandem with other business functions. How can poor operations research affect the entire supply

Cite examples of how operations research works in tandem with other business functions. How can poor operations research affect the entire supply chain? minimum 400 words 2 references