Cohesion Case SCM_MBD2 Input boxes in tan Output boxes in yellow Given data in blue Answers in red Broadway Caf Units sold per month: Average unit sales price: Added lease payment, new offices: Sales month January February March April May June July August September October November December 20,000 $2.20 $2,500 Units 6,582 11,121 14,178 13,692 11,597 9,599 9,913 10,926 14,349 12,965 6,972 2,455 Unit variable costs: Current fixed costs: Projected fixed costs: $0.50 $5,000 $7,500 Sales Fixed Costs Variable Costs Sum EBIT Broadway Caf Units sold per month: Average unit sales price: 20,000 Unit variable costs: $2.20 Projected fixed costs: Sales month January February March April May June July August September October November December Units 6,582 11,121 14,178 13,692 11,597 9,599 9,913 10,926 14,349 12,965 6,972 2,455 Sales $0.30 $7,500 Fixed Costs Variable Costs Sum: EBIT