include steps please

Contrnbution margin ratio This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet a. Coastal Company budgets sales of $1,230,000, fixed costs of $85,800, and variable costs of $381,300. What is the contribution margin ratio for Coastal Company? sin4 b. If the contribution margin ratio for Bushner Company is 55%, sales were $558,000, and foxed costs were $217,900, what was the operating income