Show and explain the break-even point by extracting relevant information from the case in MS Excel

Diana Company, a sole proprietorship, sells only one product. The regular price is $160. Variable costs are 55% of this selling price,and fixed costs are $8,400 a month. Management decides to decrease the selling price from $160 to $145 per unit. Assume that the cost of the product and the fixed operating expenses are not changed by this pricing decision.
(a) At the original selling price of $160 a unit, what is the contribution margin ratio? _______________%
(b) At the original selling price of $160 a unit,what dollar volume of sales per month is required for DianaCompany to break-even? (Round your answer to the nearest whole dollar) $_______________
(c) At the original selling price of $160 a unit, what dollar volume of sales per month is required for DianaCompany to earn a monthly operating income of $6,500? (Round your answer to the nearest whole dollar)$________________
(d) At the reduced selling price of $145 a unit, what is the contribution margin ratio? _______________%
(e) At the reduced selling price of $145 a unit, what dollar volume of sales per month is required to break-even? (Round your intermediate percentage to one decimal place and final answer to the nearest wholedollar)$_______________
(f) Show and explain the break-even point by extracting relevant information from the case in MS Excel

Complete the assignment with a discussion of what you gained from reading about these two entrepreneurs.

You have been given the assignment to read Beer School: Bottling Success at The Brooklyn Brewery. Upon completion of reading this informative book dealing with this real life rags to riches entrepreneurial….

Prepare an income statement and an owner’s equity statement for the 2 months ended December 31, 2019, and a classified balance sheet as of December 31, 2019.

Instructions Cookie Creations (Chapter 4) This assignment is a continuation of the Cookie Creations case study from Chapters 1–3. You will use the information from the previous chapters and from….

Complete Problems 5 and 6 from Chapter 16 in the textbook.

Complete Problems 5 and 6 from Chapter 16 in the textbook. Follow the text directions for Problem 5 closely. Problem 6 should be in paragraph form and answer all parts….