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

13/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:

Reflection 6 points

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

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:

Writing Factory
Accounting & Finance Specialist
A Grade Exams
Chartered Accountant
Finance Master
Finance Homework Help
Writer Writer Name Offer Chat
Writing Factory

ONLINE

Writing Factory

I have read and understood all your initial requirements, and I am very professional in this task.

$19 Chat With Writer
Accounting & Finance Specialist

ONLINE

Accounting & Finance Specialist

I will cover all the points which you have mentioned in your project details.

$36 Chat With Writer
A Grade Exams

ONLINE

A Grade Exams

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$41 Chat With Writer
Chartered Accountant

ONLINE

Chartered Accountant

I have read and understood all your initial requirements, and I am very professional in this task.

$24 Chat With Writer
Finance Master

ONLINE

Finance Master

I have read your project details. I can do this within your deadline.

$47 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$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

4rd 003 520 25 - Strategic management in international context - Is correlation coefficient r2 - Penn foster exam answers 2018 - Chemical properties of nylon 6 - Taits mitre 10 somerville - Galapagos islands climate graph - Interprofessional collaboration - Apple performance management system - Sap technical skills list - 320 slice ct scan price - Efferent and aesthetic reading - Fourier transform triangle wave example - Case 18 ford motor company new strategies for international growth - How to prove a parallelogram in coordinate geometry - Haemophilus parahaemolyticus gram stain - Psychology - Yellow bone marrow contains a large percentage of ________. - Gerry walk thru gate model 545 - Reef-building corals are classified as metamorphic - Enthalpy of decomposition of ammonium chloride - The standard error of the estimate, sest, is essentially the - Animal models and mutations - A multinational corporation that adopts the naive immoralist approach to ethics will most likely - AVD1 Due in 12 Hours - Which type of muscle tissue possesses striations - Nursing practice problem - Structuredquery log temp folder - Good morning in sign language bsl - Absolute wbc count formula - Application of the Problem-Solving Model and Theoretical Orientation to a Case Study - Fitzwilliam museum enterprises ltd - Kks power plant classification system pdf - Charlotte's web chapter 19 summary - 2. what is the purpose of anti-drug legislation in relation to public order crime? - Ghtf sg3 n18 2010 - Newburgh to perth bus times - Cyclone tracy evacuation list - Week One Study Guide - Ifac qualified line manager - Whole foods market case analysis - Benchmark- Nursing Process: Approach to Care - Tertiary preparation course tafe - Genesis jesus he knows me reaction - Seven Samurai movie review - An Essay for my Africana Studies course - Susquehanna equipment rentals - Skill related components of fitness - 7 4 word problem practice parallel lines and proportional parts - Bolt torque to axial force - Application security week1 - Just a view - 5-3-1 activity: historical context chart - Head loss due to pipe fittings lab report - Fish 4 ever tuna coles - Iolp level 3 example - Glencoe states of matter virtual lab - Discusison(MIS) - Chapter 23 consumer rights and responsibilities answers - Formalization in organizational structures tends to - Maps of moreton bay reefs - Cus discussion week 6 - Silicon dioxide giant covalent structure - Magpie box room banchory - Training, New Information System, & Evaluation - Complex report (part of it is in excel) - Write analyst report - Pgp encryption igolder - Company closing letter to clients - Absolute value function transformations worksheet - Value chain analysis for coca cola - Marketers and senior managers like to see graphical - What is genetic mutation jiskha - What is competitive profile matrix - Chipotle lake mead and civic center - Reply to my peers - Ellen foster chapter 14 summary - Kitchen gadgets draw a context diagram for the order system - Framing the lesson examples - S vt 1 2at 2 solve for a - Once upon a time nadine gordimer questions - Windermere international summer school - Synthesis of aspirin from salicylic acid lab report - Interview - Wendy Lewis 2 - Mosque tower crossword clue - Initiating the Project-1 - Indian writing in english history - Applying the 21 synectics steps examples - a 600 word response on the difference between Presidential and Congressional Reconstruction with in 12 hours - Research - Individual success plan example gcu - Order 2147297: Do you think GMO food should be banned? - The texas constitutional convention of 1974 - Introduction to econometrics exam questions - Spotty handed villainesses audience - Teksystems timesheets - Geographic distribution of power - Corporate IT Security Audit Compliance - Research Paper: COSO Framework