solution

Hi-precision company produces bases for special purpose devices such as long-range Cameras and telescopes. This company produces three type of four type of lenses in three plants. Each type of lenses can be produced at each plant, but each plant has its own restrictions and costs. Product Resource constraints are given in Table 1-3 for each plant. The company has 3500 pound of raw material in the inventory. The company has three major costumes (A, B, C). For each customer, the maximum sales of each product is given in Tablet the product sale prices and shipping costs are given in Table and Table 6 respectively. The production cost for each plant-product prair is given in Table 7 Customer A and B require special inspection on products those are shipped from plant I and plant 2. These product are inspected at a center, then sent to their destinations The capacity of this center is 1500 units. A) Formulate a linear program to determine the production amounts and shipping amounts to maximize the profit. You can use the following decision variable in your LP Fue number of product i produced at plant j and sold to customer k b) Solve the resulting problem in Excel Solver c) If you could get more material, how much would you like? How would you use it? What would you be willing to pay? Answer using excel sitivity report d) If you could get more inspection capacity, how much would you like? How would you use it? What would you be willing to pay? Answer using excel sensitivity report ) At what plant(s) would you like to add extra machine beura? How much would you be willing to pay per bour? How many extra hours would you like? Answer using excel sensitivity report INA he + 11 LH 15 CA That es 11 TER PER B = t THER