Transportation Model (Linear programming model formulation)
Consider the following transportation problem ... Formulate this problem as a linear programming model and solve it by using Solver in Excel. (Please see the attached file).
Consider the following transportation problem ... Formulate this problem as a linear programming model and solve it by using Solver in Excel. (Please see the attached file).
Please find the problem statement in the attachment.
Please state all your assumptions and show all your work. Define your decision variables clearly. Briefly explain your constraints and objective functions. Define all units of measure (e.g. hours, $, $/hour, etc) Explain what software package you used (e.g. LINDO, LINGO, EXCEL solver, etc). For EXCEL solver, be sure to give a se
Please answer questions, listed below and also shown in original format in the attachment; show work and explain in Microsoft Word and Excel how you came to each solution. 1. As part of its planning process, the Sam Manufacturing Company must determine the mix of its products to be manufactured next year. The company produce
Part a ACE's four plants ship goods to 3 warehouses which in turn ship to 5 retailers The shipping costs per unit are: 4 5 Product Capacity Plant Salt Lake Dallas Cost/unit unit/week 1 LA 30 40 208 200 2 Kcity 25 45 214 300 3 Savannah 45 30 215 300 6 7 8 Wa
Southern Air is considering purchase of new aircraft and has set aside $1.5B dollars for this. They have enough pilots to crew 30 new planes and enough maintence personnel to crew 40 new short range planes. Maint for long range planes is 1.67 times that for short range planes Maint for med range planes is 1.33 times th
Solve the following integer (linear) programming model problem graphically by manual hand-drawn construction of the graph. Minimize 6X + 11Y Subject to 9X + 3Y > 27 7X + 6Y > 42
A publishing house publishes three weekly magazines-daily life, agriculture today, and surf's up. Publication of one issue of each of the magazines requires the following amounts of production time and paper: Production (hr.) Paper (lbs.) Daily Life
Given the following all-integer linear program: MAX 3x1 + 2x2 such that 3x1 + x2 <= 9 x1 + 3x2 <= 7 -x1 + x2 <= 1 x1, x2 >= 0 and integer a. Solve the problem as a linear program ignoring the integer constraints. Show that the optimal solution to the linear program gives fractional valu
Tots Toys makes a plastic tricycle that is composed of three major components: a handlebar-front wheel-pedal assembly, a seat and frame unit, and rear wheels. The company has orders for 12,000 of these trikes. As indicated in the table below, the company obviously does not have the resources available to manufacture everythi
State all the assumptions and show all the work. Define your decision variables clearly. Briefly explain the constraints and objectives functions and define all unit of measure. Consider the following linear programming problem: Max x + 3y s.t. -x +
State all the assumptions and show all the work. Define your decision variables clearly. Briefly explain the constraints and objectives functions and define all unit of measure. You have been put in charge of the Davidson oil refinery. The refinery produces gas and heating oil from crude oil. Gas sells for $11 per barrel and
State all the assumptions and show all the work. Define your decision variables clearly. Briefly explain the constraints and objectives functions and define all unit of measure. During the next three months Airco must meet (on time) the following demands for air conditioners: month 1, 300; month 2, 400; month 3, 500. Air cond
State all the assumptions and show all the work. Define your decision variables clearly. Briefly explain the constraints and objectives functions and define all unit of measure. Consider the following LP model: Max Z = x1 + x2 s.t. x1 + 3x2 <=8 x1 + x2 <=4 x1 , x2 =>0 a) So
Suppose you are charged with doing a linear programming type of analysis at your job and come to the conclusion that there is no feasible solution to your problem. What do you do now? What are your recommendations to your superior going to be?
State the dual of the following linear programming problem. Minimize w = 5y_1 + 8y_2 Subject to: 2y_1 5y_2 ≥ 9 2y_1 + 3y_2 ≥ 11 7y_1 + 2y_2 ≥ 5 With y_1 ≥ o, y_2 ≥ 0. Please see attachment for better format.
Maximize the objective function 2x + 3y subject to the constraints that x + twice y is at most 6; and the sum of 5 times x and 3 times y is at most 15; with both decision variables non-negative. Find the optimal solution using linear programming and the graphical solution procedure. What is the value of the objective functio
Please solve this problem using excel solver.
1. The binding constraints for this problem are the first and second. Min x1 + 2X2 s.t. x1 + x2> 300 2x1 + x2> 400 2x1 + 5x2> 750 x1, x2 > 0 a. Keeping cf2 fixed at 2, over what range can cf1 vary before there is a change in the optimal solution point? b. Keeping cf1 fixed at
To the extent permitted by local law, each Acme Home Improvements store, including AMC, is open from 7 am - 11 pm every day. Acme Mexico City planners have provided the following table, which identifies the minimum number of customer service employees estimated to be needed on the floor of the store each hour of the day:
1) Develop an LP model for the problem. 2) Solve the LP model using Solver in excel I have posted problem below: Questions Acme Mexico City purchases two products (Product 1 and Product 2) that it stocks from three different vendors (Vendor A, Vendor B and Vendor C). The suppliers have limited capacity
A market research firm's three clients each requested that the firm conduct a sample survey. Four available statisticians can be assigned to these three projects; however, all four statisticians are busy, and therefore, each can handle only one client. The following data who the number of hours required for each statistician t
A manufacturer of electronic equipment produces 2 types of TVs: Plasma (X) and LCD (Y). In the first X, wins $ 500 and the second and wins $ 400. Both TVs are subjected to two manufacturing processes: Assembly (Assembly) and Test (Testing). Plasma is consumed in the 6 and 3 hours respectively and the LCD using 4 and 10 hours res
16)A manufacturer of electronic equipment produces 2 types of TVs: Plasma (X) and LCD (Y). In the first X, wins $ 500 and the second and wins $ 400. Both TVs are subjected to two manufacturing processes: Assembly (Assembly) and Test (Testing). Plasma is consumed in the 6 and 3 hours respectively and the LCD using 4 and 10 hours
14)ABC Corporation, produces two types of drinks. For each of them should be made by 3 processes, which are: Distilling, Bottling and Packing. In the drink X is used in each process the next time: 6, 3 and 4 hours respectively. As for the drink and is used in the above processes 6, 6 and 2 hours respectively. The distillation p
13) ABC Corporation, produces two types of drinks. For each of them should be made by 3 processes, which are: Distilling, Bottling and Packing. In the drink X is used in each process the next time: 6, 3 and 4 hours respectively. As for the drink and is used in the above processes 6, 6 and 2 hours respectively. The distillation
12) ABC Corporation, produces two types of drinks. For each of them should be made by 3 processes, which are: Distilling, Bottling and Packing. In the drink X is used in each process the next time: 6, 3 and 4 hours respectively. As for the drink and is used in the above processes 6, 6 and 2 hours respectively. The distillation
9) ABC Corporation, produces two types of drinks. For each of them should be made by 3 processes, which are: Distilling, Bottling and Packing. In the drink X is used in each process the next time: 6, 3 and 4 hours respectively. As for the drink and is used in the above processes 6, 6 and 2 hours respectively. The distillation p
8)ABC Corporation, produces two types of drinks. For each of them should be made by 3 processes, which are: Distilling, Bottling and Packing. In the drink X is used in each process the next time: 6, 3 and 4 hours respectively. As for the drink and is used in the above processes 6, 6 and 2 hours respectively. The distillation pl