can you please help me to solve this

BA325 QUANTITATIVE DECISION MAKING HOMEWORK ASSIGNMENT #1 Due date: November 20, Friday, 5 pm. 1. Temizpak Corporation manufactures high-quality washing machines. Orders received from several retail stores for the next 3 months sum up as in the following table: WN3 Month Number of units 1 150 130 210 Due to the labor agreements, the wages of the workers therefore the production costs increase every month. The cost to produce a machine is $250 in month 1, $270 in month 2. and $300 in month 3. If there are washing machines that are not sold in the month of their production, there is a $20 cost to carry this item in the inventory for one month. However, one cannot carry more than 60 units per month in the inventory. The company starts with an inventory of SO units, and must finish the 3rd month with zero inventory. The company wants to minimize the total costs while meeting the demands. a) (20 points) Formulate this problem by using LP. b) (20 points) Solve the LP problem by using Excel solver. In the optimal solution how many units are produced in each month? c) (10 points) How do the optimal solution and the objective function value change if the limit of carrying inventory is 50 instead of 60? (Answer this question by examining the sensitivity report.) 2. Ayse nl is running for mayor in a small town of Anatolia. She has selected four ways to advertise: television ads, radio ads, billboards and newspaper ads. The costs, the audience reached by each type of ad and the maximum number of ads to be usable are given in the following table. Type of ad Cost per ad Audience reached per ad Maximum number 700 TL 30,000 Radio 400 TL 20,000 12 Billboards 500 TL 24,000 Newspapers 100 TL 8,000 TV 10 8 10 In addition, Aye has decided that there should be at least 6 ads on TV or radio or a combination of these two. The amount spent on billboards and newspapers together must not exceed the amount spent on TV ads. The monthly budget for advertising is 15000 TL How many ads should be placed in each medium to maximize the total number of people reached? a) (35 points) Formulate and solve the LP problem by using Excel solver. b) (15 points) How do the optimal solution and the objective function value change if each TV add can reach 33,000 people? What if Ayse decides to increase the monthly budget to 16000 while at the same time the combined number of TV and radio ads must be at least 7; how do the optimal solution and the objective function value change then? (Answer part b by the information you obtain from the Excel Sensitivity Report.) BA325 QUANTITATIVE DECISION MAKING HOMEWORK ASSIGNMENT #1 Due date: November 20, Friday, 5 pm. 1. Temizpak Corporation manufactures high-quality washing machines. Orders received from several retail stores for the next 3 months sum up as in the following table: WN3 Month Number of units 1 150 130 210 Due to the labor agreements, the wages of the workers therefore the production costs increase every month. The cost to produce a machine is $250 in month 1, $270 in month 2. and $300 in month 3. If there are washing machines that are not sold in the month of their production, there is a $20 cost to carry this item in the inventory for one month. However, one cannot carry more than 60 units per month in the inventory. The company starts with an inventory of SO units, and must finish the 3rd month with zero inventory. The company wants to minimize the total costs while meeting the demands. a) (20 points) Formulate this problem by using LP. b) (20 points) Solve the LP problem by using Excel solver. In the optimal solution how many units are produced in each month? c) (10 points) How do the optimal solution and the objective function value change if the limit of carrying inventory is 50 instead of 60? (Answer this question by examining the sensitivity report.) 2. Ayse nl is running for mayor in a small town of Anatolia. She has selected four ways to advertise: television ads, radio ads, billboards and newspaper ads. The costs, the audience reached by each type of ad and the maximum number of ads to be usable are given in the following table. Type of ad Cost per ad Audience reached per ad Maximum number 700 TL 30,000 Radio 400 TL 20,000 12 Billboards 500 TL 24,000 Newspapers 100 TL 8,000 TV 10 8 10 In addition, Aye has decided that there should be at least 6 ads on TV or radio or a combination of these two. The amount spent on billboards and newspapers together must not exceed the amount spent on TV ads. The monthly budget for advertising is 15000 TL How many ads should be placed in each medium to maximize the total number of people reached? a) (35 points) Formulate and solve the LP problem by using Excel solver. b) (15 points) How do the optimal solution and the objective function value change if each TV add can reach 33,000 people? What if Ayse decides to increase the monthly budget to 16000 while at the same time the combined number of TV and radio ads must be at least 7; how do the optimal solution and the objective function value change then? (Answer part b by the information you obtain from the Excel Sensitivity Report.)