Question: linear programming problem E. The municipality of Aladen plans to develop several new recreational facilities that must be completed with a budget of PhP35 million.

linear programming problem E. The municipality of

linear programming problem

E. The municipality of Aladen plans to develop several new recreational facilities that must be completed with a budget of PhP35 million. A survey was conducted among residents to determine their presences as to the type of facilities they would like to be built. Their preferred facilities with additional information are tabulated in the table below. Facility Construction cost per facility (Php. In thousand) Hectares needed People per month Annual maintenance cost (Php) Basketball court 300 3 700 3000 250 5 1000 6000 Playground Soccer field Volle ball court 75 2 800 3000 175 3 1200 7000 The municipality has decided that at least 15 facilities will be built and has set aside 55 hectares to be used for the construction. 1. How many facilities for each type should be constructed that maximizes the number of people using the new facilities per month? Write/type the "mathematical notation" for the goal of this case in the space below. 2. Implement on Excel and solve using Solver. Paste a screen capture of the Excel solution in the space below. Suppose the municipality's budget officer raised the budget implication to maintaining these facilities. Per her computation, the annual maintenance cost of all the new facilities should not exceed P80,000 3. How many facilities for each type should then be constructed? Write/type the "mathematical notation for the revised goal. 4. Implement on Excel and solve using Solver. Paste a screen capture of the Excel solution in the space below

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 General Management Questions!