How much of each type of cargo should Paul accept, if the profit per ton for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
How much of each type of cargo should Paul accept, if the profit per ton for Cargo 1 decreases to $52? Why? Please answer correctly by observing following picture. Where X1, X2, X3, and X4 represent the amount (tons) to load to the ship for Cargos 1, 2, 3 and 4. The first two pictures are describing that cargo 1 had $70 profit per unit. Next it will transform into $52. 123456780 A 2 Linear Programmming Model Decision Variables 6 Number to Make 9 10 Constraint 1 11 Constraint 2 12 Constraint 3 13 Constraint 4 14 Constraint 5 15 Constraint 6 16 17 18 Unit Profit B X₁ 4800 1 40 1 70 C X₂ 5000 1 35 1 50 D X3 325 1 60 1 60 E X₁ 1700 1 55 1 LHS F LL 11825 480000 4800 5000 325 1700 Total Profit 80 741500 G <= <= <= <= <= RHS H 13000 480000 4800 5000 1200 1700 1 Microsoft Excel 16.73 Sensitivity Report 2 Worksheet: [LP 6.xlsx]Sheet1 3 Report Created: 29/5/2023 4:12:40 pm 4 LO 5 6 Variable Cells 7 8 9 10 11 12 13 14 Constraints 15 16 17 18 19 20 21 22 23 Cell $B$6 $C$6 $D$6 $E$6 Name Number to Make X1 Number to Make X2 Number to Make X3 Number to Make X4 Cell Name $F$10 Constraint 1 LHS $F$11 Constraint 2 LHS $F$12 Constraint 3 LHS $F$13 Constraint 4 LHS $F$14 Constraint 5 LHS $F$15 Constraint 6 LHS Final Value 4800 5000 325 1700 Final Value 11825 480000 4800 5000 325 1700 Reduced Objective Cost Coefficient 0 0 0 0 70 50 60 80 Shadow Constraint Price R.H. Side 0 1 30 15 0 25 13000 480000 4800 5000 1200 1700 Allowable Increase 1E+30 1E+30 25.71428571 1E+30 Allowable Increase 1E+30 52500 487.5 557.1428571 1E+30 354.5454545 Allowable Decrease 30 15 60 25 Allowable Decrease 1175 19500 1312.5 1500 875 954.5454545 34567 Decision Variables 6 Number to Make 8 9 10 Constraint 1 11 Constraint 2 12 Constraint 3 13 Constraint 4 14 Constraint 5 15 Constraint 6 16 17 18 Unit Profit X₁ 4800 1 40 1 $52 X₂ 5000 1 35 1 $50 X3 325 1 60 1 $60 X4 1700 1 55 1 LHS 11825 <= 480000 <= 4800 <= 5000 <= 325 <= 1700 <= Total Profit $80 655100 RHS Comments 13000 480000 4800 5000 1200 1700 1 Microsoft Excel 16.73 Sensitivity Report 2 Worksheet: [LP(12).xlsx]Sheet1 3 Report Created: 4/6/2023 1:52:31 am 4 5 6 Variable Cells 7 8 Cell Name 9 $B$6 Number to Make X1 10 $C$6 Number to Make X2 11 $D$6 Number to Make X3 12 $E$6 Number to Make X4 13 14 Constraints 15 16 17 18 19 20 21 22 Cell Name $F$10 Constraint 1 LHS $F$11 Constraint 2 LHS $F$12 Constraint 3 LHS Constraint 4 LHS $F$13 $F$14 Constraint 5 LHS $F$15 Constraint 6 LHS Final Value 4800 5000 325 1700 Final Value 11825 480000 4800 5000 325 1700 Reduced Objective Cost Coefficient 0 0 0 0 Shadow Constraint Price 0 1 52 50 60 80 12 15 0 25 R.H. Side Allowable Increase 1E+30 1E+30 18 1E+30 Allowable Increase 1E+30 52500 487.5 13000 480000 4800 5000 557.1428571 1200 1E+30 1700 354.5454545 Allowable Decrease 12 15 60 25 Allowable Decrease 1175 19500 1312.5 1500 875 954.5454545 How much of each type of cargo should Paul accept, if the profit per ton for Cargo 1 decreases to $52? Why? Please answer correctly by observing following picture. Where X1, X2, X3, and X4 represent the amount (tons) to load to the ship for Cargos 1, 2, 3 and 4. The first two pictures are describing that cargo 1 had $70 profit per unit. Next it will transform into $52. 123456780 A 2 Linear Programmming Model Decision Variables 6 Number to Make 9 10 Constraint 1 11 Constraint 2 12 Constraint 3 13 Constraint 4 14 Constraint 5 15 Constraint 6 16 17 18 Unit Profit B X₁ 4800 1 40 1 70 C X₂ 5000 1 35 1 50 D X3 325 1 60 1 60 E X₁ 1700 1 55 1 LHS F LL 11825 480000 4800 5000 325 1700 Total Profit 80 741500 G <= <= <= <= <= RHS H 13000 480000 4800 5000 1200 1700 1 Microsoft Excel 16.73 Sensitivity Report 2 Worksheet: [LP 6.xlsx]Sheet1 3 Report Created: 29/5/2023 4:12:40 pm 4 LO 5 6 Variable Cells 7 8 9 10 11 12 13 14 Constraints 15 16 17 18 19 20 21 22 23 Cell $B$6 $C$6 $D$6 $E$6 Name Number to Make X1 Number to Make X2 Number to Make X3 Number to Make X4 Cell Name $F$10 Constraint 1 LHS $F$11 Constraint 2 LHS $F$12 Constraint 3 LHS $F$13 Constraint 4 LHS $F$14 Constraint 5 LHS $F$15 Constraint 6 LHS Final Value 4800 5000 325 1700 Final Value 11825 480000 4800 5000 325 1700 Reduced Objective Cost Coefficient 0 0 0 0 70 50 60 80 Shadow Constraint Price R.H. Side 0 1 30 15 0 25 13000 480000 4800 5000 1200 1700 Allowable Increase 1E+30 1E+30 25.71428571 1E+30 Allowable Increase 1E+30 52500 487.5 557.1428571 1E+30 354.5454545 Allowable Decrease 30 15 60 25 Allowable Decrease 1175 19500 1312.5 1500 875 954.5454545 34567 Decision Variables 6 Number to Make 8 9 10 Constraint 1 11 Constraint 2 12 Constraint 3 13 Constraint 4 14 Constraint 5 15 Constraint 6 16 17 18 Unit Profit X₁ 4800 1 40 1 $52 X₂ 5000 1 35 1 $50 X3 325 1 60 1 $60 X4 1700 1 55 1 LHS 11825 <= 480000 <= 4800 <= 5000 <= 325 <= 1700 <= Total Profit $80 655100 RHS Comments 13000 480000 4800 5000 1200 1700 1 Microsoft Excel 16.73 Sensitivity Report 2 Worksheet: [LP(12).xlsx]Sheet1 3 Report Created: 4/6/2023 1:52:31 am 4 5 6 Variable Cells 7 8 Cell Name 9 $B$6 Number to Make X1 10 $C$6 Number to Make X2 11 $D$6 Number to Make X3 12 $E$6 Number to Make X4 13 14 Constraints 15 16 17 18 19 20 21 22 Cell Name $F$10 Constraint 1 LHS $F$11 Constraint 2 LHS $F$12 Constraint 3 LHS Constraint 4 LHS $F$13 $F$14 Constraint 5 LHS $F$15 Constraint 6 LHS Final Value 4800 5000 325 1700 Final Value 11825 480000 4800 5000 325 1700 Reduced Objective Cost Coefficient 0 0 0 0 Shadow Constraint Price 0 1 52 50 60 80 12 15 0 25 R.H. Side Allowable Increase 1E+30 1E+30 18 1E+30 Allowable Increase 1E+30 52500 487.5 13000 480000 4800 5000 557.1428571 1200 1E+30 1700 354.5454545 Allowable Decrease 12 15 60 25 Allowable Decrease 1175 19500 1312.5 1500 875 954.5454545
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these general management questions
-
From a management perspective, formulate and explain your company's offensive or defensive strategy to improve its market position in the next 3 years. Explain whether your company will be a first...
-
The Philbrick Company has two plants on opposite sides of the United States. Each of these plants produces the same two products and then sells them to wholesalers within its half of the country. The...
-
The company has recently designed two different types of feed. Both are ideally balanced for different animals, and have received a lot of attention at recent trade shows and state fairs. They have...
-
Consider a single-output, non-preemptive queueing system. It has three queues connected to the single output, and packets in the queues are handled based on a strict-priority order. The three queues...
-
Interest rates on 4-year Treasury securities are currently 7%, while 6-year Treasury securities yield 7.5%. If the pure expectations theory is correct, what does the market believe that 2-year...
-
A twenty-foot equivalent unit (TEU) is a standard measurement of volume in container shipping. The majority of containers are either 20 or 40 feet in length. A 20-foot container is 1 TEU; a 40-foot...
-
Many medical PET scans use the isotope \({ }^{18} \mathrm{~F}\), which has a half-life of \(1.8 \mathrm{~h}\). A sample prepared at 10:00 A.M. has an activity of \(20 \mathrm{mCi}\). What is the...
-
The scenario: Croton City started its calendar year 2013 with the following General Fund balances (all numbers are in thousands of dollars). Croton has adopted the following budgetary and accounting...
-
Read the article: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC6338434/ then state the following Purpose and goal 1. Knowledge-define or describe key concepts from this article 2. Analysis- compare...
-
Suppose you are a euro-based Italian Investor, and you are Investing 11,200 to buy shares of a British company at 50 per share. The exchange rate is 1.40 per pound. The stock pays a 1 dividend one...
-
5 3. Use a half-angle formula to find the exact value of tan 12
-
Advertising Assignment Pick a global product / brand that is marketed in the United States and discuss how it is advertised the same way or differently in a country of your choice (country and...
-
How does the Global Citizenship Education (GCED) benefited the society in resolving environmental issues? a)One environmental issue to focus on. b) What is infographics with 2 examples and how it'd...
-
what are the risk management strategy for construction of modular home. create the project risk management strategy and recommendation for project board to address the risk associated with modular...
-
On April 24, 2012, Rebecca purchased a government-guaranteed short-term investment maturing on July 5, 2012. How much did Rebecca pay for the investment if she will receive $6000 on the maturity date...
-
Three companies ET plc, Ant plc, Tiger plc operate in the same type of business and hence incur similar operation risks. However, the companies have different capital structure as described in the...
-
On 1 June 2020, the company sold a product to a customer for $5,000 cash. The company sets its selling price by employing a 100% mark up on the cost of inventory. The customer has the ability to...
-
Explain how the graph of each function can be obtained from the graph of y = 1/x or y = 1/x 2 . Then graph f and give the (a) Domain (b) Range. Determine the largest open intervals of the domain over...
-
Calculate the amount of the child and dependent care credit allowed for 2012 in each of the following cases, assuming the taxpayers had no income other than the stated amounts. a. William and Carla...
-
Joan is a self-employed attorney in New York City. Joan took a trip to San Diego, CA, primarily for business, to consult with a client and take a short vacation. On the trip, Joan incurred the...
-
Ken paid the following amounts for interest during 2012: Qualified interest on home mortgage...........................................$4,700 Auto loan...
-
Consider the equation of motion \[\frac{d^{2} u}{d \varphi^{2}}+u-\frac{1}{p}=3 \lambda u^{2}\] where \(p\) and \(\lambda\) are constants. Find the solution using perturbation theory to first order...
-
Consider the one dimensional harmonic oscillator with angular frequency \(\omega\) perturbed by the small non-linear potential \(\epsilon q^{4}\). (a) Find the solution using the perturbation...
-
The celebrated Lorentz attractor is described by the differential equations \[\frac{d x}{d t}=-\sigma x+\sigma y \quad, \quad \frac{d y}{d t}=-x z+\alpha x-y \quad, \quad \frac{d z}{d t}=x y-\beta...
Study smarter with the SolutionInn App