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

Include a hypothesis slide after your background/introduction information. This should include the solution you propose and what you predict will

Include a hypothesis slide after your background/introduction information. This should include the solution you propose and what you predict will happen if your solution is implemented. It’s indicated on the “Problem” slide, but you want to have a slide that specifically states the Hypothesis. Include information from your statistical analysis. Make

please complete attachment Name: Section: 1. Ecological Footprint Estimating your overall impact on the environment is a

please complete attachment Name: Section: 1. Ecological Footprint Estimating your overall impact on the environment is a daunting task when you consider all the variables involved. A tool for roughly estimating your environmental impact has been developed and it presents the information in a manner that is easily visualized despite

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 3 Communications Management (MGT 421) Due Date: 4/5/2023 @ 23:59 Course Name: Communication Management Student’s Name: Course Code: MGT421 Student’s ID Number: Semester: 2nd

ASSESSING AND DIAGNOSING PATIENTS WITH ANXIETY DISORDERS, PTSD, AND OCD

Identify three local organizations in your community that deliver healthcare services to vulnerable populations

Explain the impact the success of the Great Heathen Army’s invasion in the late 9th Century had on Anglo-Saxon society.

What did international businesses do during/after each of the below-mentioned crisis to build resilience against global supply chains disruptions. You will

What did international businesses do during/after each of the below-mentioned crisis to build resilience against global supply chains disruptions. You will need to list out individually what was done after – 1. Pandemic 2. Russia-Ukraine War 3. Suez Canal Crisis 4. The Middle East Crisis One page for each topic.

Assignment: Prepare-Enrich Reflection Completion requirements For the assignment, you will write a one-page reflection on what you have

Assignment: Prepare-Enrich Reflection Completion requirements For the assignment, you will write a one-page reflection on what you have learned and observed through this training. This paper is due four days after the class meeting (Week 6, Day 4).

Read Chapter 1, War, pp. 1–20: Meyer-Fong, T. (2003). What Remains Coming to Terms with Civil War in 19th Century China. Stanford University

Read Chapter 1, War, pp. 1–20: Meyer-Fong, T. (2003). What Remains Coming to Terms with Civil War in 19th Century China. Stanford University Press. Columbia University. China and the West: Read the information in the background material, look for more information, and then write a 3- to 5-page paper answering

Instructions are attached Response to peers Your response should either add to their summary or respectfully challenge their

Instructions are attached Response to peers Your response should either add to their summary or respectfully challenge their position based on information that you have found in a peer-reviewed journal article. Your reply post should consist of 300 to 400 words. The use of quotations is not allowed. Please upload

Discussion 4 Urinary Function: Mr. J.R. is a 73-year-old man, who was

Discussion 4 Urinary Function: Mr. J.R. is a 73-year-old man, who was admitted to the hospital with clinical manifestations of gastroenteritis and possible renal injury. The patient’s chief complaints are fever, nausea with vomiting and diarrhea for 48 hours, weakness, dizziness, and a bothersome metallic taste in the mouth.

You are what you eat.” Have you ever heard that? Although that saying is not exactly true, what we do eat does impact how we concentrate in class, work,

You are what you eat.” Have you ever heard that? Although that saying is not exactly true, what we do eat does impact how we concentrate in class, work, perform in sports, and even affects our moods. The purpose of this activity is to deepen learning through reflective thinking. Follow

A Qualified Person for Pharmacovigilance is an individual residing within the European Economic Area (EEA), who is personally responsible by law for the

A Qualified Person for Pharmacovigilance is an individual residing within the European Economic Area (EEA), who is personally responsible by law for the safety of a human pharmaceutical product within the EEA

Short Paper We all have to eat, but there is a lot of controversy surrounding what is good to eat. Use peer-reviewed, scholarly articles

Short Paper We all have to eat, but there is a lot of controversy surrounding what is good to eat. Use peer-reviewed, scholarly articles to answer the question, “What is the best diet?”. Write a summary of your research in 500 words and cite and reference at least four articles(

6 posts. You can find the requirements in the file. Requirement: You will write 3 posts about whichever game you play/watch

6 posts. You can find the requirements in the file. Requirement: You will write 3 posts about whichever game you play/watch from 1990 to 1999 and 3 posts about whichever game you play/watch from 2000 to 2009. These games need to be played/watched for at least 15 minutes. Each post

Description College of Administration and Finance Sciences Assignment (2) Deadline: Saturday 04/05/2024 @ 23:59 Course Name: Cost

Description College of Administration and Finance Sciences Assignment (2) Deadline: Saturday 04/05/2024 @ 23:59 Course Name: Cost Accounting Student’s Name: Course Code: ACCT 301 Student’s ID Number: Semester: Second CRN: Academic Year: 1445 H For Instructor’s Use only Instructor’s Name:Rabab Farrash Students’ Grade: /15 Level of Marks: High/Middle/Low Instructions –

Case 6.3 Leonard v. PepsiCo, Inc., 210 F.3d 88 (2d Cir. 2000) The cases are assigned based on what team you are in so that case

Case 6.3 Leonard v. PepsiCo, Inc., 210 F.3d 88 (2d Cir. 2000) The cases are assigned based on what team you are in so that cases are distributed evenly. Each student will treat this as an individual assignment (you do not need to meet with your team). Your response should