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

Note: You will be filling out and uploading a lab report. Please see this experiments Report template. 1. Download and print out the Report_template for

Note: You will be filling out and uploading a lab report. Please see this experiments Report template. 1. Download and print out the Report_template for Experiment 3 Density of solid matter. 2. Access link to the youtube video for the experiment: 3. Use Data Table in template to record volume

Final I decided to change my topic to something that I am familiar with. Hope this is ok. 1. Complete the five steps to

Final I decided to change my topic to something that I am familiar with. Hope this is ok. 1. Complete the five steps to writing your research question as shown in the lecture. · Find something you are interested in and knowledgeable about. I am a Certified Nursing Assistant and

Assignment 1 – 1 page Methylglutaconic aciduria type 7 ( relates to the body ability to break down certain protein)

Assignment 1 – 1 page Methylglutaconic aciduria type 7 ( relates to the body ability to break down certain protein) First explain why you chose this disease. Then present a summary of the information you gathered during your research, including some of the following: · links to your sources of

watch the documentary film The Power of Big Oil write one paragraph (NOT one sentence!) with your thick notes, thoughts and critical questions. Use some

watch the documentary film The Power of Big Oil write one paragraph (NOT one sentence!) with your thick notes, thoughts and critical questions. Use some keywords that apply to this film’s topic. Your

Đồng hồ cơ giá 1 triệu – Lựa chọn tối ưu cho người mới bắt đầu Đồng hồ là một phụ kiện không thể thiếu trong cuộc sống hàng ngày của chúng ta, đặc

Đồng hồ cơ giá 1 triệu – Lựa chọn tối ưu cho người mới bắt đầu Đồng hồ là một phụ kiện không thể thiếu trong cuộc sống hàng ngày của chúng ta, đặc biệt là với phái mạnh. Trong thế giới đồng hồ rộng lớn, đồng hồ cơ

1-2 Journal Assignment: Take An Assessment To complete this assignment, you will take a self-assessment. You will then be asked to reflect on the aspects and

1-2 Journal Assignment: Take An Assessment To complete this assignment, you will take a self-assessment. You will then be asked to reflect on the aspects and results of it. There are many personality tests available to use for personal and professional use. To complete this assignment, first choose one of

I need help wth my homework assignment Requires Lopeswrite Assessment Description You have a standard practice of displaying all student work in you

I need help wth my homework assignment Requires Lopeswrite Assessment Description You have a standard practice of displaying all student work in your classroom. Recently, you assigned students to write any essay and submit a pictorial depiction on the person they considered to be their hero. One of your students

at 2.5 seconds, the helicopter has a kinetic energy of 20 j. what is the mechanical energy at that time

Reconstruct the correct entries under accrual accounting principles and post the effects to T accounts

Calculus is a branch of mathematics that deals with the study of rates of change and accumulation of quantities. It has two main branches: differential

Calculus is a branch of mathematics that deals with the study of rates of change and accumulation of quantities. It has two main branches: differential calculus and integral calculus. 1. **Differential Calculus**: This branch focuses on the concept of derivatives, which represent the rate of change of a function. It’s

Post in the Discussion area at least 2 paragraphs responding to the following prompts: Describe the graph you selected from the video on technology’s

Post in the Discussion area at least 2 paragraphs responding to the following prompts: Describe the graph you selected from the video on technology’s long tail including: What does the graph show? What values are on the y- and x-axis? What is the overall pattern displayed on the graph? Be

Congratulations, you have been chosen to build out a network for a new facility for your company, ACME, Inc. Office Schematic, (select ) each office

Congratulations, you have been chosen to build out a network for a new facility for your company, ACME, Inc. Office Schematic, (select ) each office is approximately a 10’x10′ space with 10′ ceilings. Building is roughly 125’x150′. Your focus will only be for the areas marked A, B, C,

Creating a Business Plan Project: Part 1 A business plan provides a business with a vision for the future and a clear strategy for expanding the business.

Creating a Business Plan Project: Part 1 A business plan provides a business with a vision for the future and a clear strategy for expanding the business. Understanding the components of a business pl

BY DAY 5 Respond to two or more of your colleagues’ posts in one or more of the following ways: Relate any similarities between your results and those

BY DAY 5 Respond to two or more of your colleagues’ posts in one or more of the following ways: Relate any similarities between your results and those of your colleague. Respectfully pose one or two questions to your colleague about their results that may provide them with further insight