Warhawk Company produces televisions. The following table contains monthly information regarding Warhawk's manufacturing costs, production volumes, machine hours, and direct labor hours Total Televisions Number of Number of Month Manufacturing direct labor produced machine bours Costs hours January S1,709,880 13.800 15.000 1.500 February $1,708.550 13.750 11.250 2.100 March $1,667130 12.750 2.500 2.400 April $2.647,000 14.780 10.150 5.400 May $1.918,680 14.330 7.500 3.160 Jung $1,907,030 13.950 10.500 3,600 July $1.785,650 13.30 11.250 2.100 August S1.569.750 12.530 7.900 1.800 September 51.698,350 12.980 80250 2.560 October $1.904.000 14.250 13.150 3.160 November SI 906,530 13.950 10.500 3600 Docember S12596,150 13.150 12.750 1.200 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 televisions produced a. The regression output must be on a new worksheet named Televisions b. On the Televisions workshet, create an input section where Warhawk can enter the expected number of televisions produced for next month i Makeup and enter the expected number of televisions to be produced next month c. Os the Televisions worksheet, use the regression results to create a formula that calculates the predicted total manufacturing costs based on the expected number of televisions produced entered in part 26 3. Create a regression that predicts total manufacturing costs based on the number of televisions produced assuming that there are no fixed costs. a. The regression output must be on a new worksheet named No Fixed. b. On the No Fixed worksheet, create an input section where Warhawk can enter the expected number of televisions produced for next month i. Makeup and enter the expected number of televisions to be produced next month c. On the No Fixed worksheet, use the regression results to create a formula that calculates the predicted total manufacturing costs based on the expected number of televisions produced entered in part 3 4. Create a regression that predicts total manufacturing cents based on the number of Televisions produced, the number of machine hours and the number of direct labor hours Assume that Warhawk DOES have fixed costs The regression output must be on new worksheet named Multiple On the worksheet named Multiple, create an input section where Warhawk can enter the expected number of televisions produced, expected number of machine hours, and expected number of direct labor hours for next month Makeup and enter the expected number of televisions to be produced expected number of machine hours and expected number of direct labor hours for next month c. On the worksheet named Multiple, crcate a formula that calculates the predicted total manufacturing costs using the expected number of televisions produced. expected number of machine hours and expected number of direct labor hours entered in part 4 5. The worksheets must be in the following order: Data (int). Televisions, No Fixed Multiple casti
