please answer this question on excel

Instructions: Using the information below, complete the tables for B.E. Now Industries in excel. You will need to create the table in excel. To complete the requirements you must use proper cell referencing, formulas, and formatting. . For table 1: calculate the required amounts identified in Column A and enter your associated response in units or dollars in Column B - Fortable 2: determine the impact of the change identified in Column A and enter the impact in Column B Information: The costing manager for B.E. Now Industries is tasked with forecasting expected breakeven and profitability levels for its Cost Cover Division. Although the expectation is that the division will be profitable next year, the fear is that continued slow growth in the local economy will cause the division to struggle to reach breakeven. As part of the forecast, the manager must be prepared to explain the impact on various cost components of changes in certain assumptions The manager has received the following information from the Accounting Department: B.E. NOW INDUSTRIES Cost Cover Division Variable Costing Components Actuals Sales price (per unit) $90 Variable costs (per unit) $63 Fixed costs $810,000 Desired pretax profit $135,000 Tax rate 35% Table 1: 1 Calculation Amount 2 Breakeven point (in units) 3 Breakeven point (in dollars) 4 Units needed to earn desired profit 5 Sales dollars needed for desired profit MacBook Pro Table 2: B 1 Change Impact Impact on the contribution margin if fixed costs increase by $40,000 III id H Impact on the contribution margin ratio if per unit sales and variable costs both decrease by $10 Impact on total variable costs if the desired pretax profit increases by $50,000 Impact on breakeven in units if tax rate decreases to 30 percent IT