Numerical problem. We did problem 6.1 in class. Some points to remember (hints): Depreciation is 5 years / 20% factor which is a Fixed Cost. Interest expense is calculated annually (Principal amount borrowed x Interest rate) and is also a fixed cost. The textbook calls the fixed costs "Known Costs"; it's the same thing. P6.1 You have the following projections about the costs in a family restaurant for next year: Net income required: Depreciation: 22% after income tax on the owner's present investment of $80,000, income tax rate is 28%. Present book value (consolidated) of furniture and equipment is $76,000, depreciation rate is 20%. Interest: Known Costs Insurance License $ 3,000 2,500 Utilities 8,400 Maintenance 3,600 Administration 9,800 Salaries 41,600 Interest on a loan outstanding of $35,000 is 8%. Variable Costs Food cost, 38% of sales revenue Wage cost, 34% of sales revenue Other costs, 12% of sales revenue What do you need to do. 1. Setup the Contribution Margin Statement format (your template) and enter in what you know. Contribution Margin Statement - Template Sales - Variable Costs = Contribution Margin - Fixed Costs =Operating Income -Taxes -Net Income Dollar Amounts Percentage NOTE: You do NOT need to enter your answers on this paper/page. You do NOT need to use my template, you can make your own if you prefer. 2. Use Bottoms up method or formulas in textbook and compute Breakeven Sales for the restaurant. 3. The owner wants to earn at a MINIMUM: 22% after income tax on the owner's present investment of $80,000, income tax rate is 28%. This step should be part of your answer to step 1 when you set up the original contribution margin statement (template). **** Calculate the SALES required to provide this minimum level of Net Income for the restaurant. 4. Table and Graph time. Hint: How many points do you need to create a line? The answer is2. So make your cost and profit table: What is the fewest number of rows you need to make your graph? See Hint above. 4a. Fill in your table Sales (level of activity) Fixed Cost Variable Cost Total Cost Operating Income 4b. Using the graph paper attached or graph paper that you have in your school supplies, construct a neatly drawn, Cost-Volume - Profit graph. Hint: The Sales Revenue line isy = x; draw that line in first. Required: draw the total cost line Optional: you can also draw the fixed cost line and the variable cost line (You must draw *required* the total cost line (3 lines). 4c. Show the Breakeven point on your graph. What is the amount according to the graph? How does it compare with your answer to breakeven in part 2 of this question (above). Hopefully, it is pretty close