# Excel Lab With Instructions (easy)

*label*Mathematics

*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

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

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