d. Suppose a worker in the molding department calls in sick. Now eight fewer hours are available that day in the molding department. How much would this affect total prot? Would it change the optimal production quantities? e. Suppose one of the workers in the molding department is also trained to do finishing. Would it be a good idea to have this worker shift some of her time from the molding to the nishing? Indicate the rate at which this would increase or decrease total prot per minute shifted. How many minutes can be shifted before this rate might change? 1'. The allowable decrease for Clay (ounces) Used constraint is missing from the sensitivity report. What numbers should be there? Explain how you were able to deduce the number. Question 3 (20 marks) Yakima Construction Corporation (YCC) is considering a number of different development projects. The cash out-ows that would be required to complete each project are indicated in the table below, along with the expected net present value (NPV) of each project (in millions of dollars). Project 5 Each project must be done in full (with the corresponding cash ows for all four years) or not done at all. Furthermore, there are following additional considerations. Project 2 cannot be done unless project 3 is also undertaken, and project 3 and 4 would compete with each other, so they should not both be chosen. YCC expects to have the following cash available to invest in these projects: $40 million for year 1, $2 million for year 2, $16 million for year 3, and $12 million for year 4. Any available money not spent i given year is then available to spend the following year. YCC's policy is to choose their projects so as maximize their total expected net present value (NPV). a. Formulate a BIP model in algebraic form for this problem. b. [EXCEL] Solve the model using solver