Indicate which of the five payment options has the lowest break-even point and provide the break-even...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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$: Indicate the new break-even point in dollars and units. BEPU: BEP$: 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. A Units B Fixed Costs Enter # of units sold to format the x-axis and $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Enter fixed costs in each row Part #1-Supplier A C Variable Costs Break Even Analysis for Supplier A $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 D Total Cost Enter formula to calculate variable costs Part #1-Supplier B $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 E Total Revenue Enter formula to calculate total costs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 F Part #1-Supplier C G Enter formula to calculate total revenue Dollars (Cost) H Variable Cost Selling Price Per Unit Fixed Cost BEPU BEP$ $25,000,000 $20,000,000 $15,000,000 $10,000,000 Part #1-Supplier D $5,000,000 $0 0 25000 50000 75000 100000 125000 150000 Fixed Costs Break Even Analysis for Supplier A Part #1-Supplier E 175000 200000 K 225000 250000 Replace this figure with a graph 000542 Variable Costs 300000 L Units Sold 325000 Part #2 Analysis M Enter correct data here Insert formulas to calculate break-even point in units and break-even point in dollars 350000 375000 400000 425000 Total Cost N 450000 475000 500000 525000 Conclusions Total Revenue + O 550000 575000 600000 P 625000 650000 Q 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 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$: Indicate the new break-even point in dollars and units. BEPU: BEP$: 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. A Units B Fixed Costs Enter # of units sold to format the x-axis and $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Enter fixed costs in each row Part #1-Supplier A C Variable Costs Break Even Analysis for Supplier A $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 D Total Cost Enter formula to calculate variable costs Part #1-Supplier B $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 E Total Revenue Enter formula to calculate total costs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 F Part #1-Supplier C G Enter formula to calculate total revenue Dollars (Cost) H Variable Cost Selling Price Per Unit Fixed Cost BEPU BEP$ $25,000,000 $20,000,000 $15,000,000 $10,000,000 Part #1-Supplier D $5,000,000 $0 0 25000 50000 75000 100000 125000 150000 Fixed Costs Break Even Analysis for Supplier A Part #1-Supplier E 175000 200000 K 225000 250000 Replace this figure with a graph 000542 Variable Costs 300000 L Units Sold 325000 Part #2 Analysis M Enter correct data here Insert formulas to calculate break-even point in units and break-even point in dollars 350000 375000 400000 425000 Total Cost N 450000 475000 500000 525000 Conclusions Total Revenue + O 550000 575000 600000 P 625000 650000 Q 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
Expert Answer:
Answer rating: 100% (QA)
lets calculate the breakeven point for each supplier Supplier A Fixed Costs 4500000 Selling Price Pe... View the full answer
Related Book For
Cost Accounting A Managerial Emphasis
ISBN: 978-0133392883
6th Canadian edition
Authors: Horngren, Srikant Datar, George Foster, Madhav Rajan, Christ
Posted Date:
Students also viewed these business writing questions
-
The ethical culture within the banking and finance sector has been under the spotlight. There have been many examples of MARKET MANIPULATION e.g. LIBOR (London Interbank Offer Rate) scandal and...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Assume that on July 1, 2014, Big Corp. loaned little Corp. $12,000 for aperiod of one year at 6percent interest. What amount of interest revenue will big report for 2014? What amount of cash will big...
-
Jeff Immelt became CEO and chairman of GE on September 7, 2001. Analyze GE's external environment since 2001 using PESTEL and discuss the effects these changes have had on GE. Is Immelt responsible...
-
A. C .Tech Manufacturing Appliances manufactures three sizes of kitchen appliances: small, medium, and large. Product information is provided below. Small Medium Large Unit sellingprice$430$550$1,230...
-
On December 31, 2017, Phillip (Appendix 10A) Company issued \(\$ 600,000\) of ten-year, nine percent bonds payable for \(\$ 496,771\), yielding an effective interest rate of twelve percent. Interest...
-
(a) What are the factors to consider in deciding whether a fast or slow approach to change is best? (b) What are the factors to consider in deciding whether a top-down or participatory approach to...
-
Part I Fill in the blank: Choose the following word(s) which best completes the sentence. Use each word only once. (10 at 3 points each blank) lateral hypothalamus cingulate cortex episodic...
-
From the below balances make Trial Balance, an income statement and Balance sheet. Stock 1st October 2018 41.600, Carriage outwards 2,100. Carriage inwards 3,700 Returns inwards 1540 Returns outwards...
-
What is the main pressure that purchasing professionals feel from internal customers especially senior management when making purchasing decisions?
-
Could you elaborate on the factors contributing to interest rate differentials across international bond markets, and how do these disparities influence capital flows and foreign exchange rates?
-
Mecca Copy, a photocopying center located on University Avenue, provided the following data to prepare a budgeted balance sheet for next year: Ending Balances Cash Accounts receivable Supplies...
-
Because Reginald got fired from his previous job, he was able to land a new gig as a production manager at Widgets of America. He's only been on the job for 3 weeks. However, he shared with all of...
-
The entries in a purchases journal are posted to the what is journal entry
-
When looking for official information regarding the FLSA, what easily accessible document provides guidance from the Department of Labor as to the application of the exemptions? When looking for...
-
Find a least expensive route, in monthly lease charges, between the pairs of computer centers in Exercise 11 using the lease charges given in Figure 2. a) Boston and Los Angeles b) New York and San...
-
ABC systems apply only to manufacturing companies. Do you agree? Explain.
-
Provide examples of interdependencies and relate them to the decision framework.
-
Give an example of how a manager can decrease variable costs while increasing fixed costs.
-
Construct simulation algorithms for the following distributions: (a) The weib (a, \(\lambda\) ) distribution, with cdf \(F(x)=1-\mathrm{e}^{-(\lambda x) \alpha}, x \geqslant 0\), where \(\lambda>0\)...
-
Write a program that generates and displays 100 random vectors that are uniformly distributed within the ellipse \[ 5 x^{2}+21 x y+25 y^{2}=9 \] [Hint: Consider generating uniformly distributed...
-
Let \([X, Y]^{\top}\) be uniformly distributed on the triangle with corners \((0,0),(1,2)\), and \((-1,1)\). Give the distribution of \([U, V]^{\top}\) defined by the linear transformation \[...
Study smarter with the SolutionInn App