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

EMH280: Interact with the Unit 4 Scenario before starting your discussion post. http://coursematerials.net/emh280/unit_4/index.html#/ Answer the following

EMH280: Interact with the Unit 4 Scenario before starting your discussion post. Answer the following questions: Identify the social media response option you will make. Briefly discuss the thought process for your decision, including what information most impacted your decision. Identify and discuss at least one risk communication consideration in

Week 8 Discussion: Software Development Security Your Task: Develop an “intake” briefing for a group of software engineers who have been tasked

Week 8 Discussion: Software Development Security Your Task: Develop an “intake” briefing for a group of software engineers who have been tasked with developing a standard set of security review processes for virtual teams. The purpose of these processes is to ensure that compliance for software security requirements is verified

The BSN student will select a practitioner of complementary or alternative therapy practice and will conduct an interview. Exploration of therapies,

The BSN student will select a practitioner of complementary or alternative therapy practice and will conduct an interview. Exploration of therapies, treatments, and conditions are investigated. Interview discussion will include if the practitioner collaborates with practitioners of Western Medicine. The assignment will be written, submitted via the appropriate portal, and

Competency Determine and decompose stakeholder and sponsor business needs to solve complex challenges. Student

Competency Determine and decompose stakeholder and sponsor business needs to solve complex challenges. Student Success Criteria View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane. Scenario The Happy Pup Daycare Company (

Deliverable 4 – Evaluate an Emerging Technology Top of Form Bottom of Form Assignment Content 1. Top of Form Competency Create

Deliverable 4 – Evaluate an Emerging Technology Top of Form Bottom of Form Assignment Content 1. Top of Form Competency Create a process that seeks out new technology and how to effectively use that technology for competitive advantage. Student Success Criteria View the grading rubric for this deliverable by selecting

Patients’ Rights, Privacy, and Confidentiality [WLOs: 1, 2, 3] [CLOs: 3, 7] Prior to beginning work on this discussion, Read Chapters 13 and 16 in your

Patients’ Rights, Privacy, and Confidentiality [WLOs: 1, 2, 3] [CLOs: 3, 7] Prior to beginning work on this discussion, Read Chapters 13 and 16 in your textbook. Read the book Patient ConfidentialityLinks to an external site.. Review the webpage Patient RightsLinks to an external site.. Watch the video Clinical Record Keeping and Confidentiality

All instructions are shown in the attached. Irvine Valley College Cultural Anthropology 2—Honors Ethnography Project Project: Ethnography

All instructions are shown in the attached. Irvine Valley College Cultural Anthropology 2—Honors Ethnography Project Project: Ethnography Evaluation Paper Points: 100 Due Date: (See the Appendix A module or the syllabus for the date) Recommended length: 9-11 Pages Introduction This class features a writing project, which is based the reading

Show the process of solving each problem. The answer is already provided. Plane Motion If a rigid body moves with both translational and

Show the process of solving each problem. The answer is already provided. Plane Motion If a rigid body moves with both translational and rotational motion, it is said to be in general plane motion. To analyze general plane motion, equations describing the translation of the center of gravity and the

Problems: ABC Analysis, EOQ, Reorder Point, & Safety Stock

Description Note: There are 2 parts to this assignment. Part 1 You have depicted a specific network from within your sector graphically and presented your

Description Note: There are 2 parts to this assignment. Part 1 You have depicted a specific network from within your sector graphically and presented your depiction to your classmates and instructor. This week, you will explore in depth the nodes, assets, and links within your selected network. In 2 pages, deliver a

Good evening, I need to write a QALMRI Writing Assignment for my class by reading an article. NO PLAGIARISM AND IT HAS TO BE IN YOUR OWN WORDS. you will an

Good evening, I need to write a QALMRI Writing Assignment for my class by reading an article. NO PLAGIARISM AND IT HAS TO BE IN YOUR OWN WORDS. you will answer the question it asks you one paragraph each. please do not plagiarize.

The purpose of this assignment is to describe the effects of various substances on consciousness, discuss the connection between substances and

The purpose of this assignment is to describe the effects of various substances on consciousness, discuss the connection between substances and neurotransmitters, identify short and long-term impacts

Instructions: · Each reply post is expected to be at least 150 words · Include at least one peer-reviewed article into each reply post and provide APA in-text

Instructions: · Each reply post is expected to be at least 150 words · Include at least one peer-reviewed article into each reply post and provide APA in-text citations and references for all of your sources PEER 1: Renée Catanzaro Ms. Callsenck is a recently married, middle-aged Caucasian woman. She

can you please help me understand what each of these symbols represent? first 4 are icons, second 4 are symbols, third 4 are index

Instructions: Due Tuesday 06/6 At least 3 paragraphs long with 3 peer-reviewed references. You have recently been hired to investigate possible

Instructions: Due Tuesday 06/6 At least 3 paragraphs long with 3 peer-reviewed references. You have recently been hired to investigate possible fraud at a local college. You walk into the main office and see 3 computers that were allegedly used to perpetrate fraud involving the theft of student tuition money. Explain what

Vinhomes Cổ Loa, một dự án đô thị hiện đại và quy mô lớn của Tập đoàn Vingroup, tọa lạc tại khu vực Đông Anh, Hà Nội. Dự án này được kỳ vọng sẽ mang

Vinhomes Cổ Loa, một dự án đô thị hiện đại và quy mô lớn của Tập đoàn Vingroup, tọa lạc tại khu vực Đông Anh, Hà Nội. Dự án này được kỳ vọng sẽ mang đến một không gian sống đẳng cấp, kết hợp hài hòa giữa tiện ích

NUR680: Week 5 Written Assignment Page 1 ` Week 5 Assignment Guidelines: Curriculum

NUR680: Week 5 Written Assignment Page 1 ` Week 5 Assignment Guidelines: Curriculum Design, Regulation, and Accreditation in Nursing Education Assignment Overview: This week will focus on curriculum design, regulation, and accreditation. Upload your paper/presentation by Sunday night at 11:59 pm Mountain Time. Assignment Details: There are three parts to