RE 5

xlsx

School

York University *

*We aren’t endorsed by this school

Course

2010

Subject

Aerospace Engineering

Date

Oct 30, 2023

Type

xlsx

Pages

3

Uploaded by GrandSnow10118

Report
Microsoft Excel 16.0 Answer Report Worksheet: [Example 1.xlsx]Sheet1 Report Created: 2022-08-08 7:18:54 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 9 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Min) Cell Name Original Value Final Value $C$8 TOTAL COST Norfolk 0 142000 Variable Cells Cell Name Original Value Final Value Integer $G$4 Truck San Diego 0 1000 Contin $H$4 Truck Norfolk 0 2000 Contin $I$4 Truck Pensacola 0 0 Contin $G$5 Railroad San Diego 0 0 Contin $H$5 Railroad Norfolk 0 500 Contin $I$5 Railroad Pensacola 0 2500 Contin $G$6 Airplane San Diego 0 3000 Contin $H$6 Airplane Norfolk 0 0 Contin $I$6 Airplane Pensacola 0 0 Contin Constraints Cell Name Cell Value Formula Status Slack $G$7 TOTAL San Diego 4000 $G$7=$G$8 Binding 0 $H$7 TOTAL Norfolk 2500 $H$7=$H$8 Binding 0 $I$7 TOTAL Pensacola 2500 $I$7=$I$8 Binding 0 $J$4 Truck TOTAL 3000 $J$4=$K$4 Binding 0 $J$5 Railroad TOTAL 3000 $J$5=$K$5 Binding 0 $J$6 Airplane TOTAL 3000 $J$6=$K$6 Binding 0
COST: SHIPPED: DESTINATION Schools MODE San Diego Norfolk Pensacola Sectors SCH 1 SCH 2 SCH3 TOTAL Truck 12 6 5 A 5 8 6 19 Railroad 20 11 9 B 0 4 12 16 Airplane 30 26 28 C 4 0 7 11 D 7 2 5 14 E 12 7 0 19 TOTAL 28 21 30 TOTAL COST 606 Demand 4000 2500 2500
Supply 900 900 900 0
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Browse Popular Homework Q&A

Q: y^(2)y' + 2xy^(3) = 6x....find general solutions (implicit maybe) of the equation....dont use…
Q: Find the average value fave of the function f on the given interval. f(x) = 3x2 + 8x,    [−1, 5]
Q: The cost of renting a canoe is $20 for the first 4 hours and $4 per hour for additional hours. Write…
Q: 1 Introduction The objective of this project is to learn TCP client-server interaction using a…
Q: find the equation of a line perpendicular to y=-4x-7 and passing through the point (-4,6) put answer…
Q: 5) For each of the following functions, indicate the asymptotes (with equations, like x = 5 or y =…
Q: Use implicit differentiation to find sin(x²)+cos (y²) = 1 Possible Answers: dy dr dy dr = dy…
Q: BONUS!! Which of these quotes is NOT by the great philosopher and Roman emperor Marcus Aurelius?…
Q: Gas A is at a temperature of 15 degrees Celsius while Gas B is at a temperature of 30 degrees…
Q: Use Horner's algorithm to evaluate the following polynomial at the point indicated 2r +9x² +16 +12,…
Q: Given a binary search tree built to store data records, to determine the height of a subtree rooted…
Q: Find the rectangular coordinates of the points whose polar coordinates are given. ( a) ( 6, π/6) (b)…
Q: Leaders of the religious rights strongly supported a clear separation between church and state. True…
Q: How are the major lymphatic organs involved in defending against pathogens? Tonsils Thymus Spleen…
Q: Given f(x) = 2x2 + 5x and g(x) = 3x - 7, find: (g + f)(2)   (gf)(3)   If f(x) = 3x + 7, g(x) =…
Q: A price-weighted index consists of 4 stocks. The stock prices for these four stocks are $12, $34,…
Q: Find the quotient and remainder using long division or synthetic division. x3−5x2+2x+13 /x−2 The…
Q: Based on your evaluation you have in free cash flow. Free cash flow can be used for various reasons,…
Q: The server program will start first and keep listening to the specified port. Your client will…
Q: Problem 2: Find the intervals of increasing and decreasing. Find the intervals of concave up and…
Q: 1. First, assume a sociological stance to explain global stratification and its causes.
Q: Round to the nearest cent or hundreth percent as needed: Principal: ? Rate: 7% Time 15 months…