pc102_w05_document_applicationactivity_breakeven

.xlsx

School

Brigham Young University, Idaho *

*We aren’t endorsed by this school

Course

102

Subject

Economics

Date

Apr 3, 2024

Type

xlsx

Pages

5

Uploaded by JusticeMantis608

W05 Application Activity: Break-Even Analysis Part 1: Type Your Refreshing Drink's Name Here: Lemon Aid Feedback Key: C A CR N For instructions, see your Canvas course Modules - W05 Application Activity: Break-Even Analysis. = C orrect = Check A nswer, Cell Referencing is Correct = Check C ell R eferencing, Answer is Correct = N ot Correct
Part 2: Annual Fixed Cost Part 3: P Shop Rental $320.91 Price Utilities (power, water, trash) $113.39 % of Demand Annual Fixed Cost $5,211.60 C Part 4 Variable Costs $0.30 Break-Even Point = Fixe Revenue: Cost: Neighborhood Market Fixed Cost per Month Break-Even Point (# of cups sold) *After inputing you formula, do the R match? If so, yo calculated the br The break-even poi cups sold when the match. When refer Part 5, the break-ev at the intersection additional cups sol even point will
Price and % of Demand $0.85 C C January 272 156 58% February 608 350 March 1,054 606 4: Break-Even Point April 1,988 1,143 May 3,193 1,836 9476 C June 4,123 2,371 ed Cost / (Price - Variable Costs) July 3,057 1,758 August 3,193 1,836 $8054 September 3,766 2,165 $8054 October 2,690 1,547 November 2,094 1,204 December 737 424 End of Year Total Units (Cups) Sold 0 15,396 Annual (Fixed and Variable) Costs $ 5,212 $ 9,830 Annual Revenue $0 $ 13,086 Annual Net Profit $ 3,256 Profit Margin 25% Read Chart Price Range Monthly Demand Price Adjusted Demand ur break-even point Revenue and Cost ou have properly reak-even point. nt is the number of e cost and revenue rring to the chart in ven point is shown of both lines. Any ld after the break- become profit. Beginning of Year
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help