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...
-
Matthew, Mark and Luke were in partnership sharing profits and losses in the ratio 5 : 3 : 2, financial statements being made up annually to 30 June. Fixed capitals were to bear interest at the rate...
-
The U.S. Postal Service is concerned with the time it takes to deliver mail. It would like not only to deliver mail as quickly as possible but also to have as little variation as possible. Twenty...
-
State a conclusion. Exercises 1015 refer to the following data: Anthropologists can estimate the birthrate of an ancient society by studying the age distribution of skeletons found in ancient...
-
What macroenvironmental factors have affected Targets performance during that period? When you hear the term discount retail, two names that usually come to mind: Walmart and Target. The two have...
-
Download the Early Childhood Professional Resource Guide Template document. Visit the websites for the first three organizations (Center on the Developing Child, NAEYC, and Zero to Three) and...
-
Consider the simple braking system shown below. The disk weighs 50 N, and the bar weighs 0.1 N. The coefficient of friction between the disk and the floor is H=0.6 a) If the magnitude of the moment M...
-
When did object orientation come into the existence?
-
What are the two types of hierarchy available in object orientated approach?
-
In which way, UML augments the object oriented-based system development?
-
Under entity analysis which of the following is considered to identify real world objects? (a) Roles (b) Tangible things (c) Substances that occupy the domain (d) All of the above
-
What are the problems with the traditional analysis strategies?
-
Which of the following statements about human evolution is correct? The upright posture and enlarged brain of humans evolved separately. Human evolution has occurred within an unbranched lineage....
-
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.
-
The partnership of King. Queen, \&- Page has experienced operating losses for three consecutive years. The partners-who have shared profits and losses in the ratio of King, \(15 \%\) : Queen, \(60...
-
ABACUS is a partnership owned by Allen, Bacon, and Cush, who share profits and losses in the ratio of \(1: 3: 4\). The account balances of the partnership at June 30 follow. Requirements 1. Prepare...
-
On June 30, Allie Hayes and Mandy McKay formed a partnership. The women agree to invest equal amounts of capital. Hayes invests her proprietorship's assets and liabilities (credit balances in...
Study smarter with the SolutionInn App