Question 7-14: The Electrocomp Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each fan must go through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time are available and up to 140 hours of drilling time may be used. Each air conditioner sold yields a profit of $25. Each fan assembled may be sold for a $15 profit. Formulate and solve this LP production mix situation to find the best combination of air conditioners and fans that yields the highest profit. Use the corner point graphical approach.Click here for more on this paper.......
Question 7-15: Electrocomp’s management realizes that it forgot to include two critical constraints (see Problem 7-14). In particular, management decides that there should be a minimum number of air conditioners produced in order to fulfill a contract. Also, due to an oversupply of fans in the preceding period, a limit should be placed on the total number of fans produced. (a) If Electrocomp decides that at least 20 air conditioners should be produced but no more than 80 fans should be produced, what would be the optimal solution? How much slack is there for each of the four constraints?
(b) If Electrocomp decides that at least 30 air conditioners should be produced but no more than 50 fans should be produced, what would be the optimal solution? How much slack is there for each of the four constraints at the optimal solution?Click here for more on this paper.......
Question 7-18: The dean of the Western College of Business must plan the school’s course offerings for the fall semester. Student demands make it necessary to offer at least 30 undergraduate and 20 graduate courses in the term. Faculty contracts also dictate that at least 60 courses be offered in total. Each undergraduate course taught costs the college an average of $2,500 in faculty wages, and each graduate course costs $3,000. How many undergraduate and graduate courses should be taught in the fall so that total faculty salaries are kept to a minimum?
Question: 8-3 (Restaurant work scheduling problem). The famous Y. S. Chang Restaurant is open 24 hours a day. Waiters and busboys report for duty at 3 A.M., 7 A.M., 11 A.M., 3 P.M., 7 P.M., or 11 P.M., and each works an 8-hour shift. The following table shows the minimum number of workers needed during the six periods into which the day is divided. Chang’s scheduling problem is to determine how many waiters and busboys should report for work at the start of each time period to minimize the total staff required for one day’s operation. (Hint: Let Xi equal the number of waiters and busboys beginning work in time period i, where i = 1, 2, 3, 4, 5, 6.)
NUMBER OF WAITERS PERIOD TIME AND BUSBOYS REQUIRED 1 3 A.M.–7 A.M. 3 2 7 A.M.–11 A.M. 12 3 11 A.M.–3 P.M. 16 4 3 P.M.–7 P.M. 9 5 7 P.M.–11 P.M. 11 6 11 P.M.–3 A.M . 4Click here for more on this paper.......
(a) Add this additional constraint: Total Number of Workers to Start the Shifts must be less than or equal to 31.
Question 8-4: (Animal feed mix problem) The Battery Park Stable feeds and houses the horses used to pull tourist-filled carriages through the streets of Charleston’s historic waterfront area. The stable owner, an ex-racehorse trainer, recognizes the need to set a nutritional diet for the horses in his care. At the same time, he would like to keep the overall daily cost of feed to a minimum. The feed mixes available for the horses’ diet are an oat product, a highly enriched grain, and a mineral product. Each of these mixes contains a certain amount of five ingredients needed daily to keep the average horse healthy. The table on this page shows these minimum requirements, units of each ingredient per pound of feed mix, and costs for the three mixes. in addition, the stable owner is aware that an overfed horse is a sluggish worker. Consequently, he determines that 6 pounds of feed per day are the most that any horse needs to function properly. Formulate this problem and solve for the optimal daily mix of the three feeds.Click here for more on this paper.......
FEED MIX
DIET OAT ENRICHED MINERAL MINIMUM DAILY REQUIREMENT PRODUCT GRAIN PRODUCT REQUIREMENT (INGREDIENTS) (UNITS/LB) (UNITS/LB) (UNITS/LB) (UNITS) A 2 3 1 6 B 0.5 1 0.5 2 C 3 5 6 9 D 1 1.5 2 8 E 0.5 0.5 1.5 5 Cost/lb $0.09 $0.14 $0.17
Question 8-6: Eddie Kelly is running for reelection as mayor of a small town in Alabama. Jessica Martinez, Kelly’s campaign manager during this election, is planning the marketing campaign, and there is some stiff competition. Martinez has selected four ways to advertise: television ads, radio ads, billboards, and newspaper ads. The costs of these, the audience reached by each type of ad, and the maximum number of each is shown in the following table: COST AUDIENCE MAXIMUM TYPE OF AD PER AD REACHED/AD NUMBER TV $800 30,000 10 Radio $400 22,000 10 Billboards $500 24,000 10 Newspapers $100 8,000 10
In addition, Martinez has decided that there should be at least six ads on TV or radio or some combination of those two. The amount spent on billboards and newspapers together must not exceed the amount spent on TV ads. While fundraising is still continuing, the monthly budget for advertising has been set at $15,000. How many ads of each type should be placed to maximize the total number of people reached?Click here for more on this paper.......
Question 14-19: Every home football game for the past eight years at Eastern State University has been sold out. The revenues from ticket sales are significant, but the sale of food, beverages, and souvenirs has contributed greatly to the overall profitability of the football program. One particular souvenir is the football program for each game. The number of programs sold at each game is described by the following probability distribution:Click here for more on this paper.......
NUMBER (IN 100s) OF PROGRAMS SOLD PROBABILITY 23 0.15 24 0.22 25 0.24 26 0.21 27 0.18
Historically, Eastern has never sold fewer than 2,300 programs or more than 2,700 programs at one game. Each program costs $0.80 to produce and sells for $2.00. Any programs that are not sold are donated to a recycling center and do not produce any revenue. (a) Simulate the sales of programs at 10 football games. Use the last column in the random number table (Table 14.4) and begin at the top of the column.
(b) If the university decided to print 2,500 programs for each game, what would the average profits be for the 10 games simulated in part (a)?
(c) If the university decided to print 2,600 programs for each game, what would the average profits be for the 10 games simulated in part (a)?Click here for more on this paper.......
Question 14-25: Stephanie Robbins is the Three Hills Power Company management analyst assigned to simulate maintenance costs. In Section 14.6 we describe the simulation of 15 generator breakdowns and the repair times required when one repairperson is on duty per shift. The total simulated maintenance cost of the current system is $4,320. Robbins would now like to examine the relative cost-effectiveness of adding one more worker per shift. The new repairperson would be paid $30 per hour, the same rate as the first is paid. The cost per breakdown hour is still $75. Robbins makes one vital assumption as she begins—that repair times with two workers will be exactly one-half the times required with only one repairperson on duty per shift. Table 14.13 can then be restated as follows:
REPAIR TIME REQUIRED (HOURS) PROBABILITY 0.5 0.28 1 0.52 1.5 0.20 1.00
(a) Simulate this proposed maintenance system change over a 15-generator breakdown period. Select the random numbers needed for time between breakdowns from the second-from-thebottom row of Table 14.4 (beginning with the digits 69). Select random numbers for generator repair times from the last row of the table (beginning with 37).
(b) Should Three Hills add a second repairperson each shift? Use Excel's Solver to complete the problems.
Table 14-4 Table of Random Numbers 52 06 50 88 53 30 10 47 99 37 66 91 35 32 00 84 57 07 37 63 28 02 74 35 24 03 29 60 74 85 90 73 59 55 17 60 82 57 68 28 05 94 03 11 27 79 90 87 92 41 09 25 36 77 69 02 36 49 71 99 32 10 75 21 75 90 94 38 97 71 72 49 98 94 90 36 06 78 23 67 89 85 29 21 25 73 69 34 85 76 96 52 62 87 49 56 59 23 78 71 72 90 57 01 98 57 31 95 33 69 27 21 11 60 95 89 68 48 17 89 34 09 93 50 44 51 50 33 50 95 13 44 34 62 64 39 55 29 30 64 49 44 30 16 88 32 18 50 62 57 34 56 62 31 15 40 90 34 51 95 26 14 90 30 36 24 69 82 51 74 30 35 36 85 01 55 92 64 09 85 50 48 61 18 85 2 3 08 54 17 12 80 69 24 84 92 16 49 59 27 88 21 62 69 64 48 31 12 73 02 68 00 16 16 46 13 85 45 14 46 32 13 49 66 62 74 41 86 98 92 98 84 54 33 40 81 02 01 78 82 74 97 37 45 31 94 99 42 49 27 64 89 42 66 83 14 74 27 76 03 33 11 97 59 81 72 00 64 61 13 52 74 05 81 82 93 09 96 33 52 78 13 06 28 30 94 23 37 39 30 34 87 01 74 11 46 82 59 94 25 34 32 23 17 01 58 73 59 55 72 33 62 13 74 68 22 44 42 09 32 46 71 79 45 89 67 09 80 98 99 25 77 50 03 32 36 63 65 75 94 19 95 88 60 77 46 63 71 69 44 22 03 85 14 48 69 13 30 50 33 24 60 08 19 29 36 72 30 27 50 64 85 72 75 29 87 05 75 01 80 45 86 99 02 34 87 08 86 84 49 76 24 08 01 86 29 11 53 84 49 63 26 65 72 84 85 63 26 02 75 26 92 62 40 67 69 84 12 94 51 36 17 02 15 29 16 52 56 43 26 22 08 62 37 77 13 10 02 18 31 19 32 85 31 94 81 43 31 58 33 51
Table 14.13 Generator Repair Times requiredClick here for more on this paper.......
NUMBER RANDOM REPAIR TIME OF TIMES CUMULATIVE NUMBER REQUIRED (HOURS) OBSERVED PROBABILITY PROBABILITY INTERVAL 1 28 0.28 0.28 01 to 28 2 52 0.52 0.80 29 to 80 3 20 0.20 1.00 81 to 00 Total 100 1.
SEE ATTACHMENT FOR CORRECT FORMAT
No comments:
Post a Comment