Please show cell references so I know what you did! Thank you.

Col. Drake's Oil Change, Inc. Background Information: Col. Drake's Oil Change, Inc. is a small but rapidly expanding provider of oil change services for automobiles. Col. Drake's owner (great-great-great-great granddaughter of the famous Titusville pioneer) is not too sure about demand for oil change services in Cridersville, OH, and has hired you to help determine how profitable her business would be at different volumes. Her accountant has provided you with the price and cost data shown in Exhibit 3. Required: (1) In an Excel spreadsheet create a table that shows Col. Drake's weekly revenues, total costs, and profit before taxes for car volumes from 0 to 375 in steps of 5 (that is: 0,5, 10, ..., 370, 375). Hint: Remember to use absolute and relative references where appropriate. (2) The accountant mentioned that the parameters (price, cost data and volume at which labor costs go up) provided in Exhibit 3 are subject to considerable uncertainty. In addition these values are relatively controllable by management. You should therefore design the worksheet so that if Ms. Drake asks about the effect of changing any of the given parameters, you can respond simply by changing the value of the parameter itself, not the logic of your worksheet. Hint: Think about using the "IF" function when computing labor costs (3)Losses should be shown either in red font on white background or in white font on a red background, but this should be done automatically, not manually for each cell. (4) Create a chart which shows revenue, expenses, and profit for Col. Drake's Oil Change, Inc. Exhibit 3 24 Price of service ($ per car) 9 Costs of oil, oil filter, and disposal ($ per car) 1,150 Rent, utilities, depreciation ($ per week) 250 Volume at which at which labor costs increase (cars/week) 1,200 Labor costs for 0-250 cars/week ($ per week) 2,100 Labor costs for 251-375 cars/week ($ per week) Your spreadsheet should be designed in such as way that if any of the variables above - price, rent, costs, etc change, they will automatically be reflected in the result. I will test your spreadsheet as I am grading them to verify that you have used formulas in the body of the spreadsheet. Col. Drake's Oil Change, Inc. Background Information: Col. Drake's Oil Change, Inc. is a small but rapidly expanding provider of oil change services for automobiles. Col. Drake's owner (great-great-great-great granddaughter of the famous Titusville pioneer) is not too sure about demand for oil change services in Cridersville, OH, and has hired you to help determine how profitable her business would be at different volumes. Her accountant has provided you with the price and cost data shown in Exhibit 3. Required: (1) In an Excel spreadsheet create a table that shows Col. Drake's weekly revenues, total costs, and profit before taxes for car volumes from 0 to 375 in steps of 5 (that is: 0,5, 10, ..., 370, 375). Hint: Remember to use absolute and relative references where appropriate. (2) The accountant mentioned that the parameters (price, cost data and volume at which labor costs go up) provided in Exhibit 3 are subject to considerable uncertainty. In addition these values are relatively controllable by management. You should therefore design the worksheet so that if Ms. Drake asks about the effect of changing any of the given parameters, you can respond simply by changing the value of the parameter itself, not the logic of your worksheet. Hint: Think about using the "IF" function when computing labor costs (3)Losses should be shown either in red font on white background or in white font on a red background, but this should be done automatically, not manually for each cell. (4) Create a chart which shows revenue, expenses, and profit for Col. Drake's Oil Change, Inc. Exhibit 3 24 Price of service ($ per car) 9 Costs of oil, oil filter, and disposal ($ per car) 1,150 Rent, utilities, depreciation ($ per week) 250 Volume at which at which labor costs increase (cars/week) 1,200 Labor costs for 0-250 cars/week ($ per week) 2,100 Labor costs for 251-375 cars/week ($ per week) Your spreadsheet should be designed in such as way that if any of the variables above - price, rent, costs, etc change, they will automatically be reflected in the result. I will test your spreadsheet as I am grading them to verify that you have used formulas in the body of the spreadsheet