Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

maximum revenue? amount of acres? please show work through excel Farmer Jonestnust determine how many acres of corn and wheat to plant this year. An

maximum revenue?
amount of acres?
please show work through excel image text in transcribed
Farmer Jonestnust determine how many acres of corn and wheat to plant this year. An acre of wheat yields 25 bushels of wheat and requires 10 hours of labor per week. An acre of corn yields 10 bushels of corn and requires 4 hours of labor per week. All wheat can be sold at $4 a bushel, and all corn can be sold at $3 a bushel. Seven acres of land and 40 hours per week of labor are available. Government regulations require that at least 30 bushels of corn be produced during the current year. Let 1= number of acres of corn planted, and 2= number of acres of wheat planted. Using these decision variables, formulate an LP whose solution will tell Farmer Jones how to maximize the total revenue from wheat and corn. By using Excel Solver, the obtained maximum revenue is $ by planting acres of corn and 2.8 acres of wheat (if your obtained values are NOT an integer, please round to Nearest 10 th; otherwise it does not match the answer). Instruction for "Fill in Multiple Blanks" questions: 1. In order to receive FULL credit, you must submit an Excel file to justify your answers by writing the complete LP model and solving the problem using Excel Solver. 2. If you only filled the blanks correctly without submitting an EXCEL file, you will receive a zero on these questions

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Survey of Accounting

Authors: Carl S Warren

6th edition

978-113318912, 1133189121, 978-1133189121

More Books

Students also viewed these Accounting questions

Question

What is a surrogate primary key, and when would you use one?

Answered: 1 week ago

Question

1. What is meant by venture capital?

Answered: 1 week ago