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

Need a minimum of 15 pages with a minimum of 10 references on the strategic analysis of Tesla. The assignment is to choose a public traded company struggling

Need a minimum of 15 pages with a minimum of 10 references on the strategic analysis of Tesla. The assignment is to choose a public traded company struggling with key strategic issues. The goal is to

· By Day 1 of this week, you will create a new patient profile (You can Make up your information as needed for History and Physical,

· By Day 1 of this week, you will create a new patient profile (You can Make up your information as needed for History and Physical, findings, vitals and such. New profile is to be made up*Not Provided to each individual. · 80 year old white male with angina lives on

In this area, we will discuss the significance of the accounting equation, the rules of debit and credit, and the steps in the accounting cycle. We will talk

In this area, we will discuss the significance of the accounting equation, the rules of debit and credit, and the steps in the accounting cycle. We will talk about recording of transactions, normal balances, and the creation of the trial balance. Let’s begin by asking this question: What is the

STUDENT COVER SHEET- Student and Trainer/Trainer Details

STUDENT COVER SHEET- Student and Trainer/Trainer Details Student ID Student name Contact number Email address Trainer name Jason Chu Course and Unit Details Course code ICT50118/ICT60115 Course name Diploma/Advanced Diploma of IT Unit code ICTICT608 Unit name Interact with a client on a business level Assessment Title Assessment 1 –

CONCEPT Globalization OTHER INSTRUCTIONS ATTACHED Course Number & Title Assignment Number Student First and Last Name Date

CONCEPT Globalization OTHER INSTRUCTIONS ATTACHED Course Number & Title Assignment Number Student First and Last Name Date Submitted INTRODUCTION (What is the topic/change?) OBJECTIVE (Why is this the best topic/change?) SOLUTION (What will this help?) CONCLUSION (Results after recommended changes, any supportive facts) References Sample electronic reference to use

Topic: Aggravated Assault In San Antonio You will complete your problem-solving essay this week. This essay is the culmination of many weeks of hard work

Topic: Aggravated Assault In San Antonio You will complete your problem-solving essay this week. This essay is the culmination of many weeks of hard work on your part, and for that, you are to be congratulated. What you have written is more than just another essay for another class. It

Watch the “Avoidance of Accountability” video on youtube Share a time when you spoke the truth in love. Post your response in a conversational tone

Watch the “Avoidance of Accountability” video on youtube Share a time when you spoke the truth in love. Post your response in a conversational tone and narrative form. With whom do you confront difficult issues? Does behavioral accountability always precede results? What role does selfishness play in accountability? What

Will you help me with my homework? Policies in healthcare have an impact on individuals, whether at the institutional, local, state, or federal

Will you help me with my homework? Policies in healthcare have an impact on individuals, whether at the institutional, local, state, or federal level. As a profession, nursing has the opportunity to influence health policies on all levels. By understanding healthcare policies, nurses can be advocates for patients as a

Assignment 2 Please read the Florida statutes on the security of confidential personal information (501.171): to an external

Assignment 2 Please read the Florida statutes on the security of confidential personal information (501.171): to an external site. · Summarize the salient features of the stature [300 words]. · Assume that you are the Chief Information Security Officer of an organization. What steps will you take to ensure

Students will be expected to write an 8-10 page APA style research paper on Rehabilitation Counseling. The paper should be written in APA format and the

Students will be expected to write an 8-10 page APA style research paper on Rehabilitation Counseling. The paper should be written in APA format and the topic should be approved by the instructor. The following should be included: 1. Title/running Head 2. Abstract (200 words or

Prepare a training module for families on one of the topics listed below. The training module should include a PowerPoint presentation and other

Prepare a training module for families on one of the topics listed below. The training module should include a PowerPoint presentation and other handouts appropriate to the training, notes on the information that will be shared beyond the PowerPoint slides, and a resource list for families of where they can

Assignment: Create an Executive Summary for the “I Spark Change: Comprehensive Project Plan.” The main goal here is a concise

Assignment: Create an Executive Summary for the “I Spark Change: Comprehensive Project Plan.” The main goal here is a concise executive summary that contains enough details for an investor to assess the scope, potential, risk, and financial reward. Some things to include: Our five-year goal is to have 1 billion

A journal assignment where you will compare confidence intervals to gambling. Simply discuss any similarities and/or differences you see between the

A journal assignment where you will compare confidence intervals to gambling. Simply discuss any similarities and/or differences you see between the two, along with personal / professional experience with gambling and/or confidence intervals.

What have you found is the most challenging aspect of qualitative research design? Why? Submission Instructions: Your initial post should be at least 200

What have you found is the most challenging aspect of qualitative research design? Why? Submission Instructions: Your initial post should be at least 200 words, formatted and cited in current CMOS if

SHEILA- UP TO 4/28/2024- CLASS 1 *** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC* **** THIS ASSIGNMENT HAS 3 PARTS / PLEASE LABEL EACH PART

SHEILA- UP TO 4/28/2024- CLASS 1 ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC***** ****** THIS ASSIGNMENT HAS 3 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** PART 1- Module 7- DISCUSSION – (SHEILA)- Golfer Delegation vs. Stewardship Delegation What are the differences between Golfer Delegation