pls help!!!

- TBC estimates selling 5,000 case of your new drink line in the upcoming period. - Each case will retail for $45. - Variable cost per case total \$20. - Fixed costs for the period are expected to total $85,000. Management has requested the following calculations: - Based on estimated sales data: - Contribution margin per unit - Contribution margin ratio - Prepare a contribution margin statement - Required sales in dollars to achieve breakeven - Required sales quantity (units) to breakeven - Prepare a contribution margin income statement if the retail price decrease by 20% and the fixed costs increase by 10%. Organize your work in excel. Be sure things are properly labeled so management can understand the data being provided, You may use multiple tabs if you find it helpful