please anwer (b),(c) and (d)
Question 1 A. Francophone is a telecommunication company, which is located in the Accra Adabraka. The company sells mobile phones and accessories. Most of their newly released phones are ordered. Francophone stocks three main phones for walk-in customers. Every week, they generate profits of GH600 from selling Galaxy S2. GH400 from Galaxy S3 and GHC300 from Galaxy S4. The overall weekly cost of these types of phones are GH1,800, GH42,100 and GH1,200 respectively, This week, Francophone has a budget of GH 12,000 available to buy these three types of phones. During sales, each phone type must be unpacked, leading to 8 hours of unpacking time for S2 phones, 12 hours for $3 phones and 16 hours for S4 phones. The manager estimates that he and his workers have 120 labour hours available to unpack the three types of phones. He has enough space to order 20 phones this week. The manager also wants to stock at least twice as many S4 as S2 and 3 phones because S4 phones sell better. a) Formulate a linear programming model for this problem. ANG B. Use the table below to answer the following questions Table 1: Solver Output Variable cells Final Reduced Objective Allowable Allowable Cell Value Cost Coefficient Increase Decrease 5859 Galaxy S2 Galaxy S3 $8511 Galaxy S4 900 Name 3 0 1E30 320 $B$10 0 6 600 400 300 -320 0 290.91 1E30 600 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price RH Side Increase Decrease $F54 budget LHS 9000 0 12000 1E30 3000 $F55 Labour LHS 120 30 120 40 120 SF36 space LHS 9 0 20 1E30 $F$7 mix LHS 0 180 10 75 b) Determine the minimum profit for Galaxy S3 so that it will attain a positive value in the optimal solution AP (5) c) Explain with reasons why reduce cost for galaxy3 is negative AP (5) d) If Francophone could raise their budget by GHc1,500 per week or increase the weekly hours to 150, which should it choose? Advice. With reasons. AN (3) Question 1 A. Francophone is a telecommunication company, which is located in the Accra Adabraka. The company sells mobile phones and accessories. Most of their newly released phones are ordered. Francophone stocks three main phones for walk-in customers. Every week, they generate profits of GH600 from selling Galaxy S2. GH400 from Galaxy S3 and GHC300 from Galaxy S4. The overall weekly cost of these types of phones are GH1,800, GH42,100 and GH1,200 respectively, This week, Francophone has a budget of GH 12,000 available to buy these three types of phones. During sales, each phone type must be unpacked, leading to 8 hours of unpacking time for S2 phones, 12 hours for $3 phones and 16 hours for S4 phones. The manager estimates that he and his workers have 120 labour hours available to unpack the three types of phones. He has enough space to order 20 phones this week. The manager also wants to stock at least twice as many S4 as S2 and 3 phones because S4 phones sell better. a) Formulate a linear programming model for this problem. ANG B. Use the table below to answer the following questions Table 1: Solver Output Variable cells Final Reduced Objective Allowable Allowable Cell Value Cost Coefficient Increase Decrease 5859 Galaxy S2 Galaxy S3 $8511 Galaxy S4 900 Name 3 0 1E30 320 $B$10 0 6 600 400 300 -320 0 290.91 1E30 600 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price RH Side Increase Decrease $F54 budget LHS 9000 0 12000 1E30 3000 $F55 Labour LHS 120 30 120 40 120 SF36 space LHS 9 0 20 1E30 $F$7 mix LHS 0 180 10 75 b) Determine the minimum profit for Galaxy S3 so that it will attain a positive value in the optimal solution AP (5) c) Explain with reasons why reduce cost for galaxy3 is negative AP (5) d) If Francophone could raise their budget by GHc1,500 per week or increase the weekly hours to 150, which should it choose? Advice. With reasons. AN (3)
