Excel Lab With Instructions (easy)

timer Asked: Jun 26th, 2018
account_balance_wallet $40

Question description

Easy calculus problems that use Excel to be solved

Step-by-step instructions are included

Thank you very much

Tutor Answer

School: Rice University

Hey buddy!Attached is the complete assignment.Please have a look at it and feel free to seek any further clarification. If
there's no further work to be done. I'd really appreciate if you could
leave a 5 star⭐ ⭐ ⭐ ⭐ ⭐ feedback for me on Studypool. This would be so helpful in
me securing further work and continue to tutor.Thanks. 😉

Chart Title














y for C1

y for C2

y for C3

Linear (y for C1)

Linear (y for C2)

Linear (y for C3)



MA 117 Laboratory Project 5
A farmer has 360 acres of land on which to plant corn and wheat. She has
$24,000 in resources to use for planting and tending the fields and storage
facility sufficient to hold 18,000 bushels of the grain (in any combination). From
past experience, she knows that it costs $120 / acre to grow corn and $60 / acre
to grow wheat; also, the yield for the grain is 100 bushels / acre for corn and 40
bushels / acre for wheat. If the market price is $225 per acre for corn and $100
per acre for wheat, how many acres of each crop should she plant in order to
maximize her revenue?

1. Set up a linear programming problem, choosing variables, finding a
formula for your objective function, and inequalities to represent the
2. You will need to decide a reasonable range for your variables, and
then put in a column of values within that range for the x-variable in
column A. Then you want to solve each constraint equation for y,
and use that formula to get values in the "y for C1", etc., columns (B,
C, D). Then graph the three constraint lines on one graph (as you did
in Lab 1: open its Word document if you need refreshing on how to
do this).
3. When you've done this, print page 1 of your lab, and shade in the
feasible region.
4. Find the corners of the feasible region using goal seek to find
intersections of lines, as you did in Lab 1.
5. Find in column H the values of f at the corners of the feasible
6. Determine the ...

flag Report DMCA

Totally impressed with results!! :-)

Similar Questions
Hot Questions
Related Tags

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors