I am on a timer please answer all the questions

QUESTION 4

1. Student must use the excel to complete the following four questions and upload a single excel file to Blackboard.

   Question 4 20 points Plants A, B, C, and D produce the same item that is demanded by customers W, X, Y, and Z in the amounts shown in the table. The cost to ship one unit between each combination of plants and customers is also shown in the table. The corporation wishes to minimize the total transportation costs of this assignment problem. Decide the amount of assignment by using Excel Solver. Recall "C08 solver.xls"

   	W	X	Y	Z	Total Supply
   A	$12	$6	$4	$22	20,000
   B	$7	$10	$8	$26	19,000
   C	$10	$23	$21	$9	14,000
   D	$29	$15	$13	$11	17,000
   Total Demand	22,000	15,000	18,000	15,000

   Question 5

   30 points

   A counseling service records the number of calls to their hotline for the last year. Calculate three different forecasts:

   (1) forecast1: simple moving average of three periods (2) forecast2: exponential smoothing with an alpha of 0.5 (3) forecast3: regression

   Month	Demand	Forecast1	Forecast2	Forecast3
   January	111
   February	127
   March	146
   April	159
   May	165
   June	165
   July	178
   August	182
   September	191
   October	208
   November	223
   December	228