just 3.16 a, b, c is to be done . not anything else
The objective is to minimize the total leasing cost for meet- ing the space requirements. a. Indicate why this is a costbenettrade-oif prob- lem by identifying both the activities and the ben- ets being sought from these activities. b. Identify verbally the decisions to be made, the con- straints on these decisions, and the overall measure of performance for the decisions. 0. Convert these verbal descriptions of the con- straints and the measure of performance into quantitative expressions in terms of the data and decisions. E* d. Formulate a spreadsheet model for this problem. Identify the data cells, the changing cells, the objec- tive cell, and the other output cells. Also show the Excel equation for each output cell expressed as a SUMPRODUCT function. Then use Solver to solve the model. 8. Summarize the model in algebraic form. E*3.15. Consider the following algebraic formulation of a cost benettrade-off problem involving three benets, where the decisions to be made are the levels of four activities (A., A2, A3, and A4): Minimize Cost = 2.4] + A2 A3 + 3A4 subject to Benet 1:3A1 + 2A2 2A3 + SA, 2 80 (minimum acceptable level) Benet 2: Al A2 + A4- 10 (minimum acceptable level) Benet 3: 141+ A2 A: + 2A4 2 30 (minimum acceptable level) and 14.20 A220 A320 A420 Formulate and solve the spreadsheet model for this problem. / Minimum Number of Consultants Required Time of Day to Be on Duty 8 AMnoon 6 Noon-4 PM 8 4 PM-8 PM 12 8 Flumidnight 6 Two types of computer consultants can be hired: fulltime and part-time. The fulltime consultants work for eight consecu- tive hours in any of the following shifts: morning (8 AM4 PM), afternoon (noon8 PM), and evening (4 Phimidnight). Full-time consultants are paid $14 per hour. Part-time consultants can be hired to work any of the four shifts listed in the table. Part-time consultants are paid 3 12 per hour. An additional requirement is that during every time period, there must be at least two full-time consultants on duty for every part-time consultant on duty. Larry would like to determine how many full-time and part-time consultants should work each shift to meet the above requirements at the minimum possible cost. a. Which category of linear programming problem does this problem t? Why? Formulate and solve a linear programming model for this problem on a spreadsheet. c. Summarize the model' 1n algebraic form. 3.17.* The Medequip Company produces precision medical diagnostic equipment at two factories. Three medical centers have placed orders for this month's production output. The fol- lowing table shows what the cost would be for shipping each unit from each factory to each of these customers. Also shown are the number of units that will be produced at each factory and the number of units ordered by each customer. A decision now needs to be made about the shipping plan for how many units to ship from each factory to each customer. a. Which category of linear programming problem does this problem fit? Why? _ Formulate and solve a linear programming model for this problem on a spreadsheet. c. Summarize this formulation in algebraic form. E * b. To From Customer 1 Factory 1 $600 Factory 2 400 Order size 300 units 3.16. Larry Edison is the director of the Computer Center for Buckly College. He now needs to schedule the stafng of the center. It is open from 8 AM until midnight. Larry has monitored the usage of the center at various times of the day and deter- mined that the following number of computer consultants are required. Unit Shipping Cost Customer 2 Customer 3 Output $800 $700 400 units 900 600 500 units 200 units 400 units 3.18. The Fagersta Steelworks currently is working two mines to obtain its iron ore. This iron ore is shipped to either of two storage facilities. When needed, it then is shipped on to the company's steel plant. The diagram below depicts this dis- tribution network, where M1 and M2 are the two mines, S] and 82 are the two storage facilities, and P is the steel plant. The