DECISION SUPPORT SYSTEM

PART THREE (45 Points) 3-1 Assuming that the data given below is information in the learning curve for an employee in producing a particular product. Time (Hour) 107 90 Unit 4 8 12 14 16 20 24 28 30 B8X8816 a- Do you think that this employee can meet a demand of 10 units in three months if he works 8 hours a day? 6- If not, how many units he can produce within 3 months. C- How should the learning curve of the employee to produce 10 units within 4 months 3-2 A candidate for mayor in a small town has allocated $40.000 for last-minute advertising in the days preceding the election. Two types of ads will be used: radio and television. Each radio ad costs $200 and reaches an estimated 3,000 people. Each television ad costs $500 and reaches an estimated 7,000 people. In planning the advertising campaign, the campaign manager would like to reach as many people as possible, but she has stipulated that at least 10 ads of each type must be used. Also, the number of radio ads must be at least as great as the number of television ads. How many ads of each type should be used? How many people will this reach? 3-3 The following table presents a risk analysis for XYZ Furniture. TABLE 200 15 UM INC 900 20 FC TABLE-MAX TABLE-MN-D CHAR-MEAN CHAR-SD 1200 200 D 600 12.34 2 S 103 102 TABL-D TABLETVC TBALS-R 1 14 3000 3760 2 133 3000 5320 125 3000 5000 104 3000 4160 10 31 3000 5240 2000 300 3640 2000 3240 0 3000 0 3000 4120 CHARO CHAIR-TVC CHARR TVC TC REVENUE PROFIT 592.0362 596.4525 582.4155 609.8623 600.388 572.8399 607.0015 606.9615 607.5794 618.6449 2200 7200 7200 7200 7200 7200 7200 7200 7200 7200 11840.23 11920.OS 1164831 12197.25 12000.76 115968 12140.03 1213923 12151.59 12172.9 10200 10200 1020 10200 10200 10200 10200 10200 10200 10200 11400 10200 10200 10200 10200 10200 10200 10200 10200 10200 19600.23 1724.05 1664831 16357.25 15127.76 152368 15380.03 1641923 12151.59 174129 4200.734 7047.0S 544831 6197.246 9127.761 5086.790 5180031 6219.229 1951.588 7212.218 1. What is the probability distribution of the Table demand and the Chair demand? 2- Identify an example for sample sampling and trial 3. If the company is producing only Tables, what will be their maximum profit? 4- The following frequency table was provided for the above project: Frequency Probability Cumulative probability Profit 5000 6000 7000 8000 9000 10000 11000 10 60 70 180 50 10 20 15% 18% 45% 13% 3% 18% 35% 80% 99% 95% 100% 5% The manger wants to take a decision on the above project, what should be the manager decision ho a) The manger can accept profit of $8000 or above b) The manager can accept profit of $8000 c) The manager can accept profit of $7000