The condensed income statement for the Colton Inn (CI) is as follows: Revenue Variable Cost Room Food Other Total department income Other variable expenses Other fixed costs Pretax income Income Taxes Net Income Room Food (1) Please compute finish the following table Revenue Other Total $ $ 5,000,000 3,000,000 500,000 $ $ $ 1,000,000 1,000,000 200,000 $ 2,200,000 8,500,000 (rent, 10% of room sales) (incl. depre, & ammort $500,000) $ $ $ $ $ $ 5,000,000 3,000,000 500,000 8,500,000 Fixed Cost $ 500,000 $1,000,000 $ 100,000 $1,600,000 Sales Mix Share 58.82% 100.00% (2) Please compute the weighted average CMR using the following formula: CMR (weighted)= Department Income $3,500,000 $1,000,000 $ 200,000 $ 4,700,000 $ 500,000 $ 2,000,000 $2,200,000 600,000 $1,600,000 CMR (Room)* Sales Mix Share (Rooms) + CMR (Food) * Sales Mix Share (Food) + CMR (Other)* Sales Mix Share (Other) (3) Please compute the total revenue at breakeven point (4) If the CI wants to make $1,500,000 of net income (after tax), what must its rooms sales equal (assume that the CI will maintain the same sales mix share)?