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

Galvanised iron sheets have a coating of - Yung gravy okc farmers market - Can technology replace managers - Lln cultural and social sensitivities - Network design proposal for hotel - Gut directed hypnotherapy melbourne - Shadow health musculoskeletal interview guide - Which of the following best defines disposable income - Class One: Part One - Lammastide romeo and juliet - Discussion - Another brick in the wall sample - Econ 213 problem set 3 answers - Discussion - Elegant decor company's management is trying to decide - Brian herbert net worth - Wuthering heights chapter summaries - B and q gates - What is the meaning of the term respondeat superior - Rage 2 pestilent park storage - A boogie wit da hoodie stereo garden march 8 - E Marketing -10 - Reflections: Adventures of an IT Leader - Designing a hand warmer lab report answers - Isbn 978 0 07 802944 9 - How values affect choices - Student integrity - Greg olafson goldman sachs - Literature review - IT PROJECT ANALYSIS AND PROPOSAL - 4.1 circles evaluate homework and practice answers - Follow up discussion - A manufacturer suspects that the batches of raw material - F5 tcpdump route domain - Ez pass boston ma - APA Assignment - Advanced control systems rmit - The reasoning engine of a clinical decision support system cdss - Polarization index test results - Visual elements of art - Research paper progress report 800 words + 4 APA refernces + palagrisim report - The curious researcher 8th edition pdf - I don t need no doctor solo tab - HIST 214 MODERN WORLD HISTORY - A digital circuit capable of holding a single digit - Random errors in experiments - Jeumont schneider track circuit manual - Spray and pray communication strategy - Fx risk hedging at eads solution - Uber marketing strategy case study - Does c++ use radians or degrees - Bookkeeping differs from accounting in that bookkeeping primarily involves - 4th root of 1296 - Analysis of antacid tablets lab report - General Psychology Discussion - Presentation on Threats to the Global Environment - The accounts of delphinia dreams, inc. showed the following balances at the beginning of october: - Dakota v fleshing machine reviews - Ronald duska whistleblowing and employee loyalty summary - 8/2 - Edmund emil kemper ii - Bank of queensland websaver - Adafruit 32x32 led matrix - American History - Steam jet refrigeration system diagram - Art- EL Anatsui - Case study develop E.R diagram - Logical fallacy identification worksheet the daring english teacher - Four seasons organizational structure - Assignment - Vincent electric starter kit - California gold rush worksheets - What causes fork lightning - X ray of duodenum cpt code - Unit 8 Discussion (BUS411 & HRM303) - Eukaryotic cell structure answers - The world on the turtle's back - Lady macbeth character traits - Igcse double award science syllabus - 59 ft lbs to nm - Credit card debt on balance sheet - Building code toilet requirements qld - Psy case study - The assembly consists of two red brass c83400 copper rods - Chapter 8 social stratification quizlet - City of golden ballot question 2e - Not my business poem meaning - It compliance analyst job description - Harry potter description extract - Module 1 - Case Study 2 - Thomas book sales inc supplies textbooks - Homework for lab 10 two dimensional motion answers - The fall of a city short story - Job Design - Amd processor warranty rma - Satellite ground station block diagram - Catholic baptism signs and symbols - Date table 1 anion confirmation tests - How do uniforms help students academically - Pampered pets hotel woodbridge - Commedia dell arte scripts samples