REQUIRED: 1. Obtain the data from Original Budget you created on Worksheet 1. 2. Complete the four calulations below using the Orginal Budget data. 3. Complete a Strenghts/Weaknesses/Opportunities/Threats (SWOT) Analysis. ranchise Profile: Original Sales and Cost Dat: CATEGORY AMOUNT SALES $2,700,000 COSTS Food Costs $810,000 Paper Costs $108,000 Crew Payroll $540,000 Crew Payroll Taxes $54,000 Manager Payroll and Payroll Taxes $108,000 Advertising $108,000 Promotions $13.500 Outside Services - Landscaping $27,000 Linens $5,400 Operating Supplies $27.000 Maintenance and Repairs $40.500 Utilities $81.000 Training and Travel $16,200 Cooking 0:1 Waste Removal $5,400 Rent and Fees $391,500 Legal and Accounting 58.100 Insurance $54.000 Taxes and Licenses $27.000 Depreciation $94.500 Interest Expense $27.000 TOTAL COSTS $2,546,100 OPERATING PROFIT $153.900 Analysis 1) Calculate the Contribution Margin (CM) % 5) Enter your budget figures below Sales dollars Variable Costa Contribution Margin CM Fixed Cocts Net Profit 2) Calculate the Break-Even Point in $ a) Use the formula: BEP $ = (Fixed $/CM2) Break-Even Point 3) Calculate the Margin of Safety (MOS) a) Use the formula: Sales BEP Sales E MOS $ Margin of Safety b) Briefly describe the meaning of Margin of safety in the space below - 4) Calculate the Break-Even Point in $, assuming a profit target of $250.000 a) Use the formula: BEP $ = [(Fixed $. Profit Target)/CMX)] Bresk-Even Point 5) Calculate the Break-Even Point in $, assuming an Afte-tax profit target of $200,000 and a 30% tax rate: a) Use the formula BEP $ = [[Fixed $ +Profit Target)/CM%)] Break-Even Point SWOT Analysis: Describe 2 examples for each category of a SWOT Anaysis for McDonald's Franchises. Describe the location, environment and competition of the McDonald's you will analyze a) Strenght - What advantages do they have over their competition? 1 12 b) Weakness - What disadvantages do they have compared to their competition? 1 2. c) Opportunities - What conditions exist today that they can take advantage to improve? 3 1 = 2 5 d) Threats - What conditions exist today that could result in hinder their success? + 1 7 2 8