excel steps needed

1. Refer to Example 1. The president of the firm has decided to shut down the plant for vacation and installation of new equipment in period 4. After installation, the cost per unit will remain the same, but the output rate for regular time will be 450. Regular output is the same as in Example 1 for periods 1, 2, and 3; 0 for period 4; and 450 for each of the remaining periods. Note, though, that the forecast of 400 units in period 4 must be dealt with. Prepare the aggregate plan, and compute its total cost