Excel Lab With Instructions (easy)

Anonymous
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

Prof_Holley
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
600

500

400

300

200

100

0
-50

0

50

100

150

200

250

300

-100
y for C1

y for C2

y for C3

Linear (y for C1)

Linear (y for C2)

Linear (y for C3)

350

400


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
constraints.
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
region.
6. Determine the ...

flag Report DMCA
Review

Anonymous
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