3. The president of a small manufacturing firm is concerned about the continual growth in manufacturing costs in the past several years. The data series of the cost per unit for the firm's leading product over the past eight years is as follows: Year 1 2 3 4 Cost/Unit ($) 26 27.5 32 33 a. 39.00 to 42.00 b. 45.00 to 48.00 c. 49.00 to 52.00 d. 53.00 to 55.00 Year 5 6 7 8 Cost/Unit ($) 34.5 36 37 39 Develop a simple linear regression model for these data. Construct a chart for this time series. Develop a simple linear regression model for these data. What is the forecasting Cost/unit($) for Year 9?

3. The president of a small manufacturing firm is concerned about the continual growth in manufacturing costs in the past several years. The data series of the cost per unit for the firm's leading product over the past eight years is as follows: Develop a simple linear regression model for these data. Construct a chart for this time series. Develop a simple linear regression model for these data. What is the forecasting Cost/unit(\$) for Year 9 ? a. 39.00 to 42.00 b. 45.00 to 48.00 c. 49.00 to 52.00 d. 53.00 to 55.00 3. The Attaran Corporation manufactures two electrical products: portable air conditioners and portable heaters. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each heater must go through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time are available and up to 140 hours of drilling time may be used. - Each air conditioner sold yields a profit of $25. Each heater assembled may be sold for a $15 profit. Please define the decision variables, the objectrve function, and formulate the constraints. Next, please formulate the LP model and solve for the optimal values of the decision variables and the maximum profit on Excel Solver