Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Case study break even analysis

14/10/2021 Client: muhammad11 Deadline: 2 Day

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, where you are responsible for the M&M product line. Mars has given you some pricing forecast data concerning 2021 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 2021 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 $15.65 per case
Supplier C: 48-count 1.74 oz bags will have a cost of $14.75 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.00 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 $5.67 per case
Marketing costs (variable cost) for the candy are $2.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

$35.00 per case selling price. To accomplish this, however, marketing costs will need to be increased by 25%. 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

Grading:

Part #1:

Break-even graph for optimal option 10 points

Graph Title 1 point
x-axis title 1 point
x-axis labels 1 point
y-axis title 1 point
y-axis labels 1 point
Legend 2 points
Data lines (fixed costs, revenue, and total costs) 3 points
Correct break-even point (in units) for each supplier option (2 points each) 10 points Correct break-even point (in dollars) for each supplier option (2 points each) 10 points

Part #2:

Correct new break-even point (in units) for optimal supplier option 2 points Correct new break-even point (in dollars) for optimal supplier option 2 points

New break-even graph for the optimal option 10 points

Graph Title 1 point
x-axis title 1 point
x-axis labels 1 point
y-axis title 1 point
y-axis labels 1 point
Legend 2 points
Data lines (fixed costs, revenue, and total costs) 3 points
Conclusions

Part #1:

Identification of optimal options:

Optimal option 1 point
BEPU 1 point
BEP$ 1 point
Part #2:

Identification of new break-even points:

BEPU 1 point
BEP$ 1 point
Part #2:

Part #1-Supplier A
Break Even Analysis for Supplier A Variable Cost
Selling Price Per Unit
Fixed Cost
Units Fixed Costs Variable Costs Total Cost Total Revenue BEPU
$0 $0 $0 $0 BEPS
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
Insert formulas to calculate break-even point in units and break-even point in dollars

Enter correct data here

Enter # of units sold to format the x-axis and calculate costs.

Enter fixed costs in each row

Enter formula to calculate variable costs

Enter formula to calculate total costs

Enter formula to calculate total revenue

Replace this figure with a graph

Part #1-Supplier B
Break Even Analysis for Supplier B Variable Cost
Selling Price Per Unit
Fixed Cost
Units Fixed Costs Variable Costs Total Cost Total Revenue BEPU
$0 $0 $0 $0 BEPS
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
Replace this figure with a graph

Part #1-Supplier C
Break Even Analysis for Supplier C Variable Cost
Selling Price Per Unit
Fixed Cost
Units Fixed Costs Variable Costs Total Cost Total Revenue BEPU
$0 $0 $0 $0 BEPS
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
Replace this figure with a graph

Part #1-Supplier D
Break Even Analysis for Supplier D Variable Cost
Selling Price Per Unit
Fixed Cost
Units Fixed Costs Variable Costs Total Cost Total Revenue BEPU
$0 $0 $0 $0 BEPS
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
Replace this figure with a graph

Part #1-Supplier E
Break Even Analysis for Supplier E Variable Cost
Selling Price Per Unit
Fixed Cost
Units Fixed Costs Variable Costs Total Cost Total Revenue BEPU
$0 $0 $0 $0 BEPS
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
Replace this figure with a graph

Part #2 Analysis
Break Even Analysis for New Costs Variable Cost
Selling Price Per Unit
Fixed Cost
Units Fixed Costs Variable Costs Total Cost Total Revenue BEPU
$0 $0 $0 $0 BEPS
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
Replace this figure with a graph

Conclusions
Part #1 Conclusion
Indicate which of the five payment options has the lowest break-even point and provide the break-even point in dollars and units.
Option:
BEPU:
BEP$:
Part #2 Conclusion
Indicate the new break-even point in dollars and units.
BEPU:
BEP$:
Part #3 Reflection
Discuss whether the new BEP increased or decreased. Since the selling price increased and the variable costs increased, explain why the BEPU behaved as you have observed.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Coursework Help Online
Homework Guru
Solution Provider
Online Assignment Help
Math Specialist
Ideas & Innovations
Writer Writer Name Offer Chat
Coursework Help Online

ONLINE

Coursework Help Online

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$23 Chat With Writer
Homework Guru

ONLINE

Homework Guru

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$39 Chat With Writer
Solution Provider

ONLINE

Solution Provider

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$49 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$28 Chat With Writer
Math Specialist

ONLINE

Math Specialist

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$34 Chat With Writer
Ideas & Innovations

ONLINE

Ideas & Innovations

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$16 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Research Paper - Staff training record template - Film Analysis II - What scene is depicted in the last supper - Error 1920 service tenable nessus - 7. .COURSE NAME: MANAGERIAL ECONOMICS - Buffalo farm equipment myrtleford - Managerial Accounting - Question 1 - Article notes - Annotated Bibliography - Another one bites the dust superbowl commercial - Sociology Question - Acct 212 course project - Bit stuffing program in c using files - What is a zork - Apa ethical guidelines ap psychology - Paper size bigger than a4 - The marrow thieves frenchie quotes - Guinea bissau country code - Metzger dowdeswell & co llc - SOCW 6103 Week 7 - Discussion 2: External Consequences of Addiction - Chapter 8 human resources culture and diversity test - Crieff to comrie bus - Determination of iron by titration with potassium permanganate - What is the davis moore thesis - Fish cheeks by amy tan - Case Study Analysis IT - Discuss Question - Louis vuitton in japan case study - Choir of hard knocks clarko - Orange county school of the arts - China population per square mile - A limitation of gestalt therapy is that it - Is graffiti art or vandalism - Roberta kathleen parks lafayette ca - Heart i want to make love to you - Cost of marginal investment in accounts receivable - Three forms of equity in reward strategy - Cognition 5th edition smilek ebook - Sales revenue less cost of goods sold is called - Sharon pope autopilot - Potassium hydrogen phthalate buffer preparation - Telstra byo tablet plans - Appositional and interstitial growth occurs in two different directions - All else equal, the contribution margin must increase as: - Chapter 3 rocks materials of the solid earth - Bloom's taxonomy second language acquisition - Miller corporation has a premium bond making semiannual payments - Finance wk 3 - Web penske intranet logistics index - William shakespeare webquest answer key - Resource management process model - 561 Week 8 Global Health Risk Paper - Why should we ban cell phones in school - Basswood furniture project answers - Ni nta qiagen handbook - How many cubic centimeters of water will the tank hold - Limits and continuity quiz - One study found that english speaking adults could relearn - Colt paterson replica uberti - Moving man simulation online - Nurs 6051 week 11 assignment - Gopro be a hero marketing campaign - Po box 6707 silverwater nsw 2128 - The vampire diaries the awakening book pdf - What are the basic objectives of monetary policy - Newburgh enlarged city school district launchpad - Need By Friday - Dali concept 6 speakers - Dfes excellence and enjoyment - Sticky fingers hell and back tab - Case Study - IT Planning at ModMeters - Define constructive conflict - Finance equations & answers pdf - Monthly retirement planning worksheet answers - Perception checking statement examples - Outside liabilities in balance sheet - Humanities assignment - Fluctuating demand in b2b marketing examples - Serial position effect lab report - Using itunes to distribute podcasts is unrealistic for most organizations - Clean utility room in hospital - Create new email account windows live mail - Sections of a quantitative research report - Formation of a corrie - Ampex 8 track recorder - Elements of fiction worksheet - Tyco traffic & transportation - What does yellow balloons mean - Organizing and Delegating Work - Uws handbook construction management - An ideal shelter for housing a temperature-measurement instrument should be - Charles motuzick son of tracey thurman - Number of orders per year formula - 1 oz to 5 gallon ratio - In the design and development department of China's small and medium-sized electronic game companies, flexible human resource management will have an impact on employee loyalty. - El doctor salinas caer radiografías - Cloud computing - Merrill glass poet biography - Why was sean payton suspended