BREAK – EVEN POINT PROFIT = SALES – VARIABLE COST – FIXED


Question Description:

35

This class assignment is for Project Management and Decision Making In the assignment I need to find the: BREAK-EVEN ANALYSIS SENSITIVITY ANALYSIS CONTRIBUTION MARGIN …Of the product I choose which is Coca Cola Company (KO). You see I attached to files; one is the Income Statement of KO stock (you can also find it at Yahoo Finance), and the other one is the excel file of the formulas of Break-even analysis and sensitivity analysis. DECISION_ANALYSIS_-_BREAK-EVEN.xlsx BREAK – EVEN POINT PROFIT = SALES – VARIABLE COST – FIXED COST 0 = PRICE X – VC X – FC 0 = (P – VC) X – FC (P – VC) X = X FC = FC (P – VC) SENSITIVITY ANALYSIS AND BREAK-EVEN ANALYSIS X FIXED COST = VARIABLE COST 2.00 FC (P – VC) P= 2.39 2.50 40,000.00 21,621.62 27,397.26 29,629.63 60,000.00 32,432.43 41,095.89 44,444.44 80,000.00 43,243.24 54,794.52 59,259.26 100,000.00 54,054.05 68,493.15 74,074.07 3.85 VC= P x 0.61 = 3.85 x 0.62 = 2.39 Read more

Answer

35