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

see attachment Define Concepts Instructions: Define the following basic concepts related to social

see attachment Define Concepts Instructions: Define the following basic concepts related to social psychology, using the technical vocabulary of discipline. · · Self · Self-esteem · Self-concept · Social perception, · Nonverbal behavior · Self-fulfillment prophecy · Stereotypes · Prejudice · In-group and out-group discrimination · Social cognition · Social

Instructions: Respond to the following two discussion posts. Due date 6/8/2024 Discussion 1.1

Instructions: Respond to the following two discussion posts. Due date 6/8/2024 Discussion 1.1 Posts: Jazmine Discuss the differences between doubting the existence of God and questioning. -James 1:6-7 says, “but when you ask, you must believe and not doubt, because the one who doubts is like a wave of the

I need a research question written. The question is on Gentrification in Oakland, California between 1999 to 2007. The specific area is Downtown Oakland.

I need a research question written. The question is on Gentrification in Oakland, California between 1999 to 2007. The specific area is Downtown Oakland. The specific population is between African Americans and White residents. This is what the question should consist of: It should be able to discern who (population),

English literature paragraph: Write a 250-word response to the week’s reading prompt: Set on a foreign planet inhabited by insect-like beings, “Bloodchild”

English literature paragraph: Write a 250-word response to the week’s reading prompt: Set on a foreign planet inhabited by insect-like beings, “Bloodchild” is a coming-of-age story, raising provocative questions about sex roles, self-sacrifice, colonization, and species- interdependence. How does this theme of the coming-of-age story function throughout the short story?

You may have considerable practice with this interview question, either as an interviewer or interviewee. There are numerous websites that offer

You may have considerable practice with this interview question, either as an interviewer or interviewee. There are numerous websites that offer insight as to the best way to respond to this question and just as many websites encouraging interviewers to remove this question from their repertoire. Despite its use

Define and describe the concept of Organization Development, show how it operates, and describe the role of action research in strengthening an

Define and describe the concept of Organization Development, show how it operates, and describe the role of action research in strengthening an organization’s structure, culture, and processes. Strengthen your argument by choosing one of the seven illustrations cited in Chapter One that best fits your workplace. You will support your

please see attached GOVT 220 Presentation Assessment: Attacks on Christianity Assignment Instructions Overview Prior to beginning this assignment,

please see attached GOVT 220 Presentation Assessment: Attacks on Christianity Assignment Instructions Overview Prior to beginning this assignment, complete Watch: Tim Goeglein – Part 1 and Watch: Tim Goeglein – Part 2. Goeglien discusses the attacks on Christianity during a live presentation at Liberty in 2013. The threats he addresses

APA Style Writing: Small-Scale Literature Review Assignment Small-Scale Literature Review Assignment A literature review is a descriptive summary of

APA Style Writing: Small-Scale Literature Review Assignment Small-Scale Literature Review Assignment A literature review is a descriptive summary of research on a topic that has previously been studied. The purpose of a literature review is to inform readers of the significant knowledge and ideas that have been established on a topic. Its

you have to fill templates from a screenplay of movie I attached the templates and its examples also from where will get idea how to do. CAST AND CREW

you have to fill templates from a screenplay of movie I attached the templates and its examples also from where will get idea how to do. CAST AND CREW LIST- You need a character and actor name for your 3 or 4 characters- You need to fill in all 12

GLOBAL HEALTHCARE COMPARISON MATRIX AND NARRATIVE STATEMENT Note: This Assignment (both Parts 1 & 2) . If

GLOBAL HEALTHCARE COMPARISON MATRIX AND NARRATIVE STATEMENT Note: This Assignment (both Parts 1 & 2) . If you talk about a possible poor health outcome, do you believe that outcome will occur? Do you believe eye contact and personal contact should be avoided? You would have a difficult time practicing

NR222 Health and Wellness Required Uniform Assignment: Health Promotion Project Guidelines Purpose This a

NR222 Health and Wellness Required Uniform Assignment: Health Promotion Project Guidelines Purpose This assignment allows the learner to apply knowledge gained about health promotion concepts and strategies, enhance written communication skills, and demonstrate a beginning understanding of cultural competency. Course outcomes: This assignment enables the student to meet the following

In the Media Review Project you will be asked to review a media that incorporates domestic violence in their plot. Select a film that depicts domestic

In the Media Review Project you will be asked to review a media that incorporates domestic violence in their plot. Select a film that depicts domestic violence. Alternatively, you may select a book or television show instead of a movie. Regardless of the medium of choice, it cannot be older

read the Declaration of Independence, Articles of Confederation, and U.S. Constitution. Write a two-page essay discussing how these founding documents

read the Declaration of Independence, Articles of Confederation, and U.S. Constitution. Write a two-page essay discussing how these founding documents fit into the historical context of their time. How do they reveal the struggle to balance liberty and order? Cite excerpts to show more detail than you examined in the

Paper 1 Synthesis and Thesis · Write a one paragraph summary of the article you annotated. You may use your annotations. ·

Paper 1 Synthesis and Thesis · Write a one paragraph summary of the article you annotated. You may use your annotations. · Write a one paragraph synthesizing, and thesis each · Start with a topic sentence that sets up with synthesizing, and thesis Requirements · This must be done

Click on the links below to access the interactive online labs

5-2 Milestone Two: Evaluation and Comparison Milestone Two is due this module. To complete this assignment review the following documents: ●

5-2 Milestone Two: Evaluation and Comparison Milestone Two is due this module. To complete this assignment review the following documents: ● Milestone Two Guidelines and Rubric ● Final Project Guidelines and Rubric ● Milestone Two Template

How does Rupa Huq’s argument in “Rethinking Subculture” relate to Dick Hebdige’s understanding of subculture, as explained by Huq? Explain how Hebdige or

How does Rupa Huq’s argument in “Rethinking Subculture” relate to Dick Hebdige’s understanding of subculture, as explained by Huq? Explain how Hebdige or Huq’s understanding of style relates to how youth express identity and community today.