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

Network-1 Data mining-2 Project Management:- 2 Advance DataBase – 1 Loooking for new hires. Cyber- No

Network-1 Data mining-2 Project Management:- 2 Advance DataBase – 1 Loooking for new hires. Cyber- No dis Network In the high availability disaster recovery, explain in your own words the differences between the cold site, worm site, and hot site. Please reply to 2 of your classmates. Data mining In

Select one piece of Etruscan art and describe which formal elements or processes appear to have been inspired by ancient Greek art. Be as specific as you

Select one piece of Etruscan art and describe which formal elements or processes appear to have been inspired by ancient Greek art. Be as specific as you can. Include a photograph of your Etruscan selection so your classmates can see exactly which piece of architecture you are writing about. Explain

This case study may require you to deep a little deeper. I have added a video on cellular respiration which takes place in the mitochondria. Some extra

This case study may require you to deep a little deeper. I have added a video on cellular respiration which takes place in the mitochondria. Some extra information: one pound is roughly 3500 calories and the average adult eats about 2000 calories a day. Case Study #2 Cassie is

https://www.sciencenews.org/article/prioritize-family-self-pandemic Given the information in the above article, and what you have learned in our course’s

Given the information in the above article, and what you have learned in our course’s section on the social problems of families, respond to the following prompts. What are the implications of prioritizing family over self, according to the article? Do the findings in the article correspond to your experience

Every family has its celebrations. In this discussion, you are asked to describe one of yours. In your discussion post, include the following

Every family has its celebrations. In this discussion, you are asked to describe one of yours. In your discussion post, include the following information in paragraph form. · What are you celebrating? · Identify the occasion · For approximately many generations has your family celebrated this occasion in this way?

t # 2 – Internship Follies The Criminal Justice Faculty of Butica College founded by Serious University is discussing the effectiveness of its renowned

t # 2 – Internship Follies The Criminal Justice Faculty of Butica College founded by Serious University is discussing the effectiveness of its renowned internship program. Program Coordinator Profe Te

General Information:Students will observe a preschool child who is 3, 4, or 5 years old. Students will observe a childat their home or a child from a

General Information:Students will observe a preschool child who is 3, 4, or 5 years old. Students will observe a childat their home or a child from a popular TV show. An active child may provide more material foryour notes and case study, so take this into account when choosing your

I need someone to modify my portfolio, It has three parts, and I’ve already completed it and turned it in, My professor gave me feedback on it and I need

I need someone to modify my portfolio, It has three parts, and I’ve already completed it and turned it in, My professor gave me feedback on it and I need someone familiar with the NAEYC/CEC standards to do this. I’m only paying $30 because there’s not a lot that needs

CASE/ACC501 Accounting for Decision Making Case Assignment Required: Computations (use Excel) Prepare a flexible budget and show variances for the year that

CASE/ACC501 Accounting for Decision Making Case Assignment Required: Computations (use Excel) Prepare a flexible budget and show variances for the year that passed. Indicate whether the flexible budg

Question: Your extra credit assignment is to write a 6-8 page research paper on art therapy trauma treatment. This paper is to be in APA 7th edition format

Question: Your extra credit assignment is to write a 6-8 page research paper on art therapy trauma treatment. This paper is to be in APA 7th edition format with a title page and reference page (no abstract required) and have a minimum of at least 6 academic sources. You can use my lecture as

Dr. Bjork is interested in the effects of anxiety on test-taking. She knows from previous literature that individuals with diagnosed anxiety disorders

Dr. Bjork is interested in the effects of anxiety on test-taking. She knows from previous literature that individuals with diagnosed anxiety disorders tend to perform poorly on tests. She hypothesizes that individuals with anxiety disorders will perform better on tests when given extra time, but needs to have a specific length

The research study should be published within the past 5 years. Answer the following questions pertaining to your research. QUESTIONS IN A WORD

The research study should be published within the past 5 years. Answer the following questions pertaining to your research. QUESTIONS IN A WORD DOCUMENT AND ANSWER DIRECTLY BELOW EACH QUESTION. 1. From which database did you locate your article? (EBSCO, CINAHL Plus, etc. ) 2. How relevant is the research

You must read all the textbooks I uploaded before starting to write. You need to strictly follow the assignment requirements. I will request unlimited

You must read all the textbooks I uploaded before starting to write. You need to strictly follow the assignment requirements. I will request unlimited revisions if the assignment does not meet the requirements. I will request a refund if the assignment does not pass. If you cannot accept these

Module 6 Discussion APN Business Planning Discuss the process of Advanced

Module 6 Discussion APN Business Planning Discuss the process of Advanced Practice Nurse (APN) business planning from a system approach. Submission Instructions: · Your initial post should be at least 500 words, formatted and cited in current APA style with support from at least 3 academic sources. · Due april

This week, we will be analyzing social media posts. For those of you who do not typically use social media feel free to view videos on YouTube that are

This week, we will be analyzing social media posts. For those of you who do not typically use social media feel free to view videos on YouTube that are entertaining and informative. One of each. Everyone else, please use your favorite forms of social media to find intriguing videos.

please see attachment Assignment for Managerial Communication. Answer all

please see attachment Assignment for Managerial Communication. Answer all questions 1. Time management is one of the biggest challenges in our development agenda in The Gambia. As a Manager hired to initiate change in the “New Gambia”, what time management strategies will you employ to attain the objectives of the

I need help with my homework MTE/510 v5 Analysis of Professional Communication MTE/510 v5 Page 2 of 2 Analysis of Professional

I need help with my homework MTE/510 v5 Analysis of Professional Communication MTE/510 v5 Page 2 of 2 Analysis of Professional Communication Complete Parts 1–4 below. Part 1: Effective Communication Strategies and Resources Conduct research online to identify at least 3 effective communication strategies and corresponding resources. Use the chart below