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

Clematis hagley hybrid rhs - Making a dichotomous key - Htm zone map den haag - Interviewing principles and practices 15th edition pdf free - Blue light cystoscopy with cysview - Ethics and accountability in public administration - Organic chemistry lab safety video - Tel aviv university tuition - How to calculate manufacturing plant efficiency - Kingsmill crustless white bread - Data store in dfd - Hot coffee movie summary - Information Assurance - Factoring ax2 bx c - Invisible goldmine strategy - Cics transaction gateway information center - Dikw examples in nursing - Stitch fix target market - Eric lott love and theft - Alcohol Abuse and Distracted Driving Discussion - Aqua life warrnambool aquarium - Nissan recovering supply chain operations - How to solve step functions - What ingredients in energy drinks contribute to body repair - Current event - Ivf formula drops per minute - How to extract creosote oil from coke oven - Week 2 capstone - How to write a good hypothesis worksheet answers - Star wars the old republic error code c11 - Dr aaron tan neurologist - Have you ever seen rain lyrics - Learnonline canberra edu au - Myaccountinglab homework answers chapter 3 - Salesperson java application part i - Hear it not duncan for it is a knell - Hayman reese dual cam sway control - List of nhbrc competent persons - How to describe location spread and shape - Fireray 2000 alignment tool - CCM-3 - Cobb and co worksheets - 5v solar panel jaycar - Union all transformation in ssis - Geico commercial old lady unfriend - The primary goal of the financial manager is to - Controlled substances act of 1970 - Law & Ethics in the Business Environment - Homework - Book: Forensic and Investigative Accounting Chapter 15 - Gina lumnah littleton nh - Management communication: a case-analysis approach, 5th edition, o’rourke, pearson, 2013. - 143 bus timetable cairns - Pm1 - Pressure and moments test - Shuspace my student record - Parker and stone inc is looking - Michies chemist travel clinic - Willington hall riding school - What do gorillas sleep on in fruit orchards - Unlicensed part 15 devices - D2 finance - Sydney passport office lee street - 2006 crf250x oil capacity - Computer gateway device crossword clue - Talent agency contract template - A manufacturer makes two products doors and windows - Greek and latin roots practice quiz - Dunkin annual report - Nursing care plan readiness for enhanced knowledge - Step down method definition - Journal Article Analysis - Managerial economics and organizational architecture 5th edition pdf - Under armour mission and vision statement - Palliative care - Float center business plan - Australorp breeders western australia - Prepare a post closing trial balance - Accounting - Coke and mentos volcano - The order of reactivity of metals - 10 25 police code - The loved one by evelyn waugh summary - Emeraid carnivore feeding guide - Eng 121 week 3 assignment - Hess's law additivity of heat of reaction lab report - Thirteen plays of bhasa pdf - Credit analysis and lending management multiple choice questions - Dj stallings cause of death - Aumentar memoria virtual windows 10 - Mercury mahadasha jupiter antardasha - Ehr implementation gantt chart - Lusus naturae margaret atwood full text - Shaq o neal lotion commercial - Organisational Behaviour - Goals for risk for impaired skin integrity - Ikea coffee plunger recall - BIO201B: Skeletal System Assignment - Acts chapter 3 questions and answers - Stephenson real estate recapitalization - Bus 311 week 2 assignment