this is an Excel assignment. please show all functions used. preferably a screen shot of excel. thanks.

Alabama Company produces lawnmowers. The following table contains monthly information regarding Alabama's manufacturing costs, production volumes, machine hours, and direct labor hours. Requirements: 1. Starting in cell Al, enter the above table in a worksheet named Data. 2. Create a regression that predicts total manufacturing costs based on the number of direct labor hours. a. The regression output must be on a new worksheet named DLH. b. On the DLH worksheet, create a user input cell where Alabama can enter the expected number of direct labor hours for next month. i. Pretend that you are the user. Makeup and enter the expected number of direct labor hours for next month. c. On the DLH worksheet, use the regression results to create a formula that calculates the predicted total manufacturing costs based on the expected number of direct labor hours entered by the user. 3. Create a regression that predicts total manufacturing costs based on the number of machine hours assuming that there are no fixed costs. a. The regression output must be on a new worksheet named MH. b. On the MH worksheet, create a user input cell where Alabama can enter the expected number of machine hours for next month. i. Pretend that you are the user. Makeup and enter the expected number of machine hours for next month. c. On the MH worksheet, use the regression results to create a formula that calculates the predicted total manufacturing costs based on the expected number of machine hours entered by the user. 4. Create a regression that predicts total manufacturing costs based on the number of lawnmowers produced, the number of machine hours, and the number of direct labor hours. Assume that Alabama DOES have fixed costs. a. The regression output must be on a new worksheet named Multi. b. On the Multi worksheet, create user input cells where Alabama can enter the expected number of lawnmowers produced, expected number of machine hours, and expected number of direct labor hours for next month. i. Pretend that you are the user. Makeup and enter the expected number of lawnmowers to be produced, expected number of machine hours, and expected number of direct labor hours for next month. c. On the Multi worksheet, create a formula that calculates the predicted total manufacturing costs using the expected number of lawnmowers produced, expected number of machine hours, and expected number of direct labor hours entered by the user. 5. The worksheets must be in the following order: Data, DLH, MH, Multi