please complete the question

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 For table 2: determine the impact of the change identified in Column A and enter the impact in Column 8 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 Sales price (per unit) Variable costs (per unit) Actuals $90 $63 Fixed costs $810,000 $135,000 Desired pretax profit Tax rate 35% Table 1: A B 1 Calculation Amount 2 Breakeven point (in units) 123 3 Breakeven point (in dollars) 4 Units needed to eam desired profit 5 Sales dollars needed for desired profit MacBook Pro Q Search or type URL $ % & 3 4 5 6 7 W E R T Y U 1P D F S G H J K CO Table 2: Impact 1 Change Impact on the contribution margin if fixed costs increase by $40,000 Impact on the contribution margin ratio if per 3 unit sales and variable costs both decrease by $10 Impact on total variable costs if the desired 4 pretax profit increases by $50,000 Impact on breakeven in units if tax rate 5 decreases to 30 percent 2 2 Page MacBook Pro Q Search or type URL $ % &