Question: PLEASE SOLVE USING EXCEL... DYNAMIC PROGRAMMING... dont copy old answer of this question Case Problems in Dynamic Programming Using Excel 1) A construction company has

 PLEASE SOLVE USING EXCEL... DYNAMIC PROGRAMMING... dont copy old answer of PLEASE SOLVE USING EXCEL... DYNAMIC PROGRAMMING... dont copy old answer of this question

Case Problems in Dynamic Programming Using Excel 1) A construction company has four projects in progress. According to the current allocation of manpower, equipment, and materials, the four projects can be completed in 15, 20, 18, and 25 weeks. Management wants to reduce the completion times and has decided to allocate an additional PhP350,000 to all four projects. The new completion times as functions of the additional funds allocated to each projects are given in Table 1. How should the PhP350,000 be allocated among the projects to achieve the largest total reduction in completion times? Assume that the additional funds can be allocated only in blocks of PhP50,000. Table 1. Completion Times (in weeks) Project 1 Project 2 Project 3 Project 4 VIN Additional Funds (in PhP10,000) 0 5 10 15 20 25 30 35 15 12 10 8 7 6 5 4 20 16 13 11 9 8 7 7 18 15 12 10 9 8 7 6 o. Sia 25 21 18 16 14 12 11 10 ON

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!