CVP USING EXCEL The Power Tool Division of ABC Hardware sells one product, Jig Saw, and has the following data for the second quarter: Vwwe op To find Create a worksheet in Excel using the example provided. Using this worksheet, enter the data from above and calculate the amounts below. Just a note: all the shaded cells in the example MUST USE FORMULAS, FUNCTIONS, AND CELL REFERENCES for this project to be the most efficient Determine (to the nearest dollar or unit or to the nearest hundredth of a percent): 1. The pretax income profit when 1.200 units are sold. Break-even volume in units and sales dollars Contribution margin ratio Sales dollars and units needed to generate a pretax income of 557,000. Calculate the margin of safety in dollars and percent at a pretax income of $57,000. Name this worksheet Initial Calculations, Create a second worksheet in the Excel workbook by copying the initial Calculations worksheet (right click on tab). In this sheet, assume the price of the product increased to $175 Recalculate the five requirements above. Name this worksheet Increased Sales Price Create a third worksheet in the Excel workbook. In this sheet assume that rather than increasing the price of the product, the Power Tool Division cut variable costs by 20% Recalculate the five requirements above. Name this worksheet Decreased Variable Costs. Create a fourth worksheet in the Excel workbook. In this sheet. assume that the Power Tool Division moved its store to a new location that increased the rent $2,000 a quarter and decreased the shipping costs $2 per unit. Recalculate the five requirements above. Name this worksheet Increased Fixed Costs. Select which method yields you the best altermative for caming income. Color this tab red. CAFE