Please complete all the requirement. Use Excel if possible. (See attachment)

Requirements:

1) Compute the number of cartons of calendars that Team Spirit Calendars must sell each month to break even.

2) Compute the dollar amount of monthly sales that the company needs in order to earn $308,000 in operating income (round the contribution margin ratio to two decimal places).

3) Prepare the company?s contribution margin income statement for June for sales of 450,000 cartons of calendars.

Minicase 6 - Cost-Volume-Profit Analysis Team Spirit Calendars imprints calendars with college names. The company has fixed expenses of $1,095,000 each month plus variable expenses of $6.50 per carton of calendars. Of the variable expense, 68% is cost of goods sold, while the remaining 32% relates to variable operating expenses. The company sells each carton of calendars for $16.50. Requirements: 1) Compute the number of cartons of calendars that Team Spirit Calendars must sell each month to breakeven. 2) Compute the dollar amount of monthly sales that the company needs in order to earn $308,000 in operating income (round the contribution margin ratio to two decimal places). 3) Prepare the company's contribution margin income statement for June for sales of 450,000 cartons of calendars