Wheat Harvest - setup

.xlsx

School

York University *

*We aren’t endorsed by this school

Course

2010

Subject

Aerospace Engineering

Date

Oct 30, 2023

Type

xlsx

Pages

5

Uploaded by GrandSnow10118

Microsoft Excel 16.0 Answer Report Worksheet: [Wheat Harvest - setup.xlsx]Sheet1 Report Created: 2022-08-11 9:18:26 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.015 Seconds. Iterations: 6 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 $B$16 TOTAL COST Chicago 0 6510 Variable Cells Cell Name Original Value Final Value Integer $F$4 Nebraska Kansas City 0 0 Contin $G$4 Nebraska Omaha 0 200 Contin $F$5 Colorado Kansas City 0 110 Contin $G$5 Colorado Omaha 0 0 Contin $F$11 Kansas City Chicago 0 0 Contin $G$11 Kansas City Cincinnati 0 110 Contin $F$12 Omaha Chicago 0 110 Contin $G$12 Omaha Cincinnati 0 90 Contin Constraints Cell Name Cell Value Formula Status Slack $F$13 TOTAL Chicago 110 $F$13=$F$14 Binding 0 $G$13 TOTAL Cincinnati 200 $G$13=$G$14 Binding 0 $F$18 Kansas City Chicago 0 $F$18=$G$18 Binding 0 $F$19 Omaha Chicago 0 $F$19=$G$19 Binding 0 $H$4 Nebraska TOTAL 200 $H$4<=$I$4 Binding 0 $H$5 Colorado TOTAL 110 $H$5<=$I$5 Not Binding 90
Microsoft Excel 16.0 Answer Report Worksheet: [Wheat Harvest - setup.xlsx]Sheet1 Report Created: 2023-10-04 9:27:56 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.031 Seconds. Iterations: 10 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 $I$19 Omaha Supply 142000 0 Variable Cells Cell Name Original Value Final Value Integer $G$4 Nebraska Omaha 1000 0 Contin $H$4 Nebraska TOTAL 2000 0 Contin $I$4 Nebraska Supply 0 200 Contin $G$5 Colorado Omaha 0 0 Contin $H$5 Colorado TOTAL 500 0 Contin $I$5 Colorado Supply 2500 200 Contin $G$6 TOTAL Omaha 3000 0 Contin $H$6 TOTAL TOTAL 0 0 Contin $I$6 TOTAL Supply 0 0 Contin Constraints Cell Name Cell Value Formula Status Slack $G$7 Omaha $G$7=$G$8 Binding 0 $H$7 TOTAL $H$7=$H$8 Binding 0 $I$7 Supply $I$7=$I$8 Binding 0 $J$4 Nebraska $J$4<=$K$4 Binding 0 $J$5 Colorado $J$5<=$K$5 Binding 0 $J$6 TOTAL $J$6<=$K$6 Not Binding 3000
COST: SHIPPED: GRAIN ELEVATORS GRAIN ELEVATORS FARM Kansas City Omaha FARM Kansas City Omaha TOTAL Nebraska 16 10 Nebraska 0 200 200 Colorado 15 14 Colorado 110 0 110 TOTAL 110 200 COST: SHIPPED: MILL MILL GRAIN ELEVATOR Chicago Cincinnati GRAIN ELEVATOR Chicago Cincinnati TOTAL Kansas City 6 10 Kansas City 0 110 110 Omaha 7 11 Omaha 200 0 200 TOTAL 200 110 Demand 200 110 TOTAL COST 6150 TRANSSHIPMENT: GRAIN ELEVATOR Should be Kansas City 0 0 Omaha 0 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: When there is an excess demand of a product in an unregulated market, the tendency is for O quantity…
Q: You deal 7 cards off of a 52-card deck and line them up in a row. How many possible lineups are…
Q: An analyst takes a random sample of 25 firms in the telecommunications industry and constructs a…
Q: Jim Green wants to receive $3,500 each year for 12 years. How much must Jim invest today at 12%…
Q: Find the area bounded by the curve and the line y = 13. Area = x = t-1/t y = t+1/t
Q: Write an equation for the polynomial graphed bel 5+ 4+ 3+ 2+ 1- -5 4 -3 -2 2 3 4 5 -2+ -3 - -4+ -5+…
Q: You are given the following reactions to complete in lab. However, you recognize an issue with the…
Q: Complete the description of the piecewise function graphed below. Use interval notation to indicate…
Q: Athos, Porthos, and Aramis each like to take fencing lessons. The price of a fencing lesson is $10.…
Q: 4 Find the inverse of the function f(x) = x-1. 3 -1 Draw the functions f and f 2. 1 2 3 -5 -4 -3 -2…
Q: Samson Winery in Pleasant Valley, New York, has two departments: Fermenting and Packaging. Direct…
Q: In the 1860 election, how many different presidential candidates received Electoral College votes?…
Q: For each of the described curves, decide if the curve would be more easily given by a polar equation…
Q: Let h(x)=f(x)−g(x). If f(x)=9x2 and g(x)=8x, what is h′(−5)?Do not include "h′(−5)=" in your answer.…
Q: Which politician is credited with creating the template for the disciplined, patronage-based…
Q: significance level to test th mull and alternative hypoth =H₂
Q: How can an organization prevent budgetary slack in the budgeting process since the bonuses of…
Q: Locate absolute extrema Question Identify the absolute minimum value of f(x) = 2x2 + x + 1 over [-2,…
Q: Please describe the ability with public speaking, the ability to present programs to educate…
Q: Pitt Company is considering two alternative investments. The company requires a 12% return from its…
Q: If someone uses the equation (y= -20.5893(x) + 24.3929) to predict the percentage of weeds killed…
Q: For the development of an information system architecture to handle this new service, it is…
Q: d period cash flow of $1.1 million and pays no dividends. The present value of the company's future…
Q: I ran a regression, with many variables to predict the result of another variable which was the…
Q: Q represent a mass (in grams) of carbon , whose half-life is  5715 years. The quantity of 1 carbon…