Engineering Management ENM 2004 Management Science Spring 2021 Homework 1 Due date: 12 April 2021, 23:59 1. A textile company produces two types of silk wear ties and shirts Shirt is a heavier grade of silk cloth and such, require 8.5 pounds of raw wilk per yard, whereas the res 6 pounds of raw silk per yard. A yard of shirt requires 3 hours of procesing time and of the tequires 3.2 h. Although the demand for the la practically limited to maximum demand for shirt 1x 550 yards per month. The manufacture 7500 pounds of milk and 500 bonis oproceng Lime Available one month. The manufacturers profit of $2.5 per yard of the and $3.10 per yard of shirt. The matter want to know how many yard of each type of war to produce to maximize proti - Formulato aliment programming model for thin problem. 1. Save the problem by wing excel solver. State the the optimal production mix and objective value. Include the excel file you generate (emitivity report, wir report, excredel) What would be the elect on the optimal solition company could obtain only 7000 pounds of wilk per month? Anwwer thix by wing your stivity report 2. Suppose we have a company that wells while. We have the type of vehicle motorcycle, bike and car. A motorcycle com 51.200, a od $1700, and become $900. We will motorcycle for $1800, er for $2200, and best for $1.200 (hintalate the net profil lubtracting cost from itselling price). We have $150 able this month to purch welcu Each which must be bleda motorcycle roques hours to emble bike 12 hours and a require 16 hours. We estimate that we and our emplo have 10 ho avilable to semble vehicles. We have enough space in our store to order 25 vehicles this month and we locale proces for each type of the vehicle). Bol on patsalen, we want to work at least twice Many bike i the other the combined en well better Formulate a la programming model for this problem Solve the linear programming model formulated in part(s) buying the computer Set optimal solution. Include the excel bile you inte (tivity port, Anwer report, excel model) Should we try to increase our budget for purchasing vehicle, increase pace to wtock vehicles, or incre labor hours to wemble vehicles Why? Answer this by using tuitivity report you obtained 3. A pharmacist blends four chemical components into three type of drug poinpills, blood pilla w sleeping pills. The maximum quantities available of each component and the cool per unit and follow Component Max. Available in grams/day Cl/ 1 5100 $10 2 21100 8 3 4200 12 4 1800 6 To ensure that eachdrug ko certain sential characteristics, the plumpul limits on the percentages of the components in each blend The limits as well as the selling prices for the Deus various are follow The pharmacist wants to pro 3000 grams of each Componentit Selling Price Hest Nothof $15 Not more than 250 of 2 Blood Notkuthu 20 of 2 15 Note than 10 Sleeping No more than wo Not less than 15 of 1 Management wishes to determine the optimal mix of the four components that will be prolit Formate a linear programming model for this problem. Just formulate it please) 4. Suppone a company rolowa new product and wants to follow an effective advertising strategy The company allocate $200000 for advertise activities Newspapers and TV channelse options to evaluate. The table given below the number people reached by using with different brands and me Type Nw costo Now 1000 New B700 News 100 TVP 10000 00 TVR 2500 TV Each newspaper ad costs $2000 and TV ad costs $15000 Almont, 40 wpap ads and 20 TV s can be purchased Formulate an LP model for the company to maximize the number of people reached by the adjust formulate pe w Important Reminder 1: Notice that this hot work task requires individual work. Your work should be yours and unique. No cheating or you will get a 0 (nero). In addition, no inte submission or you will set (xero). Important Reminder 2: You should submit your excel files and solution documents vix it- slearning Alternative ways for submission will not be compted. Important Reminder 3: Please write dearly. I cannot read what you write, cannot ride your work Grading policy for homework: Each qotion is 25 points Reference Bernard W. Taylor 2016. Introduction to Management Science, Pearson, Inc., USA