A company is manufacturing two products, A and B, at the production facilities in town X and Y. Four customers have ordered the following amounts in the coming period: Product A Produet B 700 Customer I Customer 2 400 550 650 Customer 3 500 800 Customer 4 600 400 The company has currently no products on stock. The products are distributed either directly from the facilities to the customers, or through the intermediate stocks K and L. Both facilities use one unit production time for each of the products and have a total capacity of 2700 time units as shown in the table to the left, while the capacities for the stocks K and L are shown in the table to the right. Time A Time B Capacity 1 Stock K 4000 m Stock L Factory X Factory Y 2700 Сараcity 4500 m Product A Product B 3 m? 2700 Space/unit 2 m² Distribution costs per unit from the production facilities to stocks or customers are: K L 2 3 4 190 160 200 55 65 75 45 150 160 Y 170 210 150 B X 50 70 140 180 150 190 Y 60 40 150 160 200 140 Similarly, the distribution costs from stocks to customers are: 2 130 3 95 K 110 120 85 115 140 75 B K 100 120 90 110 80 110 130 70 Formulate the problem as an LP problem where the main objective is to minimize the costs. Define objective function, constraints, variables and parameters used. i) Find the optimal solution by using Solver in Excel.

The distribution of daily demand for rental trucks at a vehicle rental company is shown in the following table: Relative Frequency Demand 0.07 0 0.14 1 0.15 2 0.14 3 0.12 4 0.08 5 0.3 6 Trucks are rented by the day only and the company makes $14 per rented truck per day. The rental company keeps four trucks at this location. Assuming that the stocking decision is optimal, what is the implied range of excess cost per truck per day? a. 0 and 186 b. 8.58064 and 14 c. 14 and 24.8889 d. 6 and 8.58064 e. 34.2759 and 79.3333

1 ton of material 1 ton of material 2, and 11/13 3 10 The Kashif Corporation blends three raw materials to produce two products: a fuel additive and a solvent base. Each ton of fuel additive is a mixture of ton of material 1 and 3 ton of material 3. A ton of solvent base is a mixture of // Kashif's production is constrained by a limited availability of the three raw materials. For the current production period, Kashif has the following quantities of each raw material: material 1, 20 tons; material 2, 5 tons; material 3, 21 tons. Management wants to achieve the following P, priority level goals. Goal 1: Produce at least 30 tons of fuel additive. Goal 2: Produce at least 15 tons of solvent base. Assume there are no other goals. (a) Is it possible for management to achieve both P₁ level goals given the constraints on the amounts of each material available? If not, which constraint is the limiting factor? O Yes. It is possible to satisfy both P₁ level goals. O No. There is an insufficient…

Q: The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1200 Satin 24 20 15 2000 Plain fabric 40 40 30 7500 Leather 11 11 10 1000 Profit per model $50 $44 $40   a) Generate the Sensitivity Report in EXCEL for the model that you built. Interpret, in context, the Shadow Price for the Leather and the Satin constraints.  Include units in your interpretations.