math 201 project 1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Math 201 Project 1 PowerPoint Presentation
Download Presentation
Math 201 Project 1

Loading in 2 Seconds...

play fullscreen
1 / 19

Math 201 Project 1 - PowerPoint PPT Presentation


  • 230 Views
  • Uploaded on

Math 201 Project 1. Case 5-3 in Hillier and Hiller. Project 1. Final report due at start of class Thursday, October 23, 2008. Final reports submitted on Thursday after the start of class will accrue a 10% lateness penalty.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Math 201 Project 1' - marrim


Download Now An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
math 201 project 1

Math 201 Project 1

Case 5-3 in Hillier and Hiller

project 1
Project 1
  • Final report due at start of class Thursday, October 23, 2008.
    • Final reports submitted on Thursday after the start of class will accrue a 10% lateness penalty.
    • No final reports will be accepted after Thursday, Oct. 23, 2008 for any reason, no matter how good the reason is.
    • Final reports must be submitted in hard copy form; no email submissions will be accepted.
  • Team leaders are responsible for collecting team contributions and compiling the final report.
  • Go to www.calvin.edu/~cgm3/math201.html for downloadable materials.
elements of the problem
Elements of the Problem
  • Data
  • Decisions
  • Constraints
  • Measure of Performance
project 1 data
Project 1 Data
  • Family labor: home farm
  • Wages from work on neighboring farm
data cont d
Data, cont’d
  • Two types of livestock:
    • Dairy cows
    • Chickens
  • Three crops
    • Soybeans (cash crop)
    • Corn (cash crop and cattle feed)
    • Wheat (cash crop and chicken feed)
data cont d1
Data, cont’d
  • Livestock value:
    • 30 cows, total value $35,000
    • 2,000 hens, total value $5,000
  • $20,000 investment fund available to buy new livestock
    • Each new cow: $1,500
    • Each new hen: $3
  • Barn can hold maximum of 42 cows
  • Chicken house can hold maximum of 5,000 hens
  • Depreciation:
    • Value of herd of cows depreciates 10%/year
    • Value of flock of hens depreciates 25%/year
data cont d2
Data, cont’d
  • Available acreage for planting: 640 acres
  • Total family living expenses: $40,000 / year
data cont d4
Data, cont’d
  • Data per acre planted (estimates for good weather)
  • W&S = Winter and Spring; S&F = Summer and Fall
where do we want to end up
Where do we want to end up?
  • The family wants to decide how many acres to plant for each crop, and how many new livestock (cows and hens) to buy, with the goal of maximizing the family’s total monetary worth at the end of the coming year.
  • As their consultants, we need to provide them with optimal solutions with respect to estimated conditions for good weather and bad weather (drought, flood).
decisions
Decisions
  • How much acreage should be planted for each crop?
  • How many new cows and hens should the family purchase?
constraints
Constraints
  • The family needs to plant enough acres of corn to provide feed for the cows:
    • Acres of corn > (1 acre/cow) times (# of cows)
  • The family needs to plant enough acres of wheat to provide chicken feed:
    • Acres of wheat > (0.05 acres/chicken) times (# of chickens)
  • The total spent on new livestock must be no greater than the amount in the investment fund ($20,000)
  • Barn constraint: total # of cows < 42
  • Chicken house constraint: total # of hens < 5,000
constraints cont d
Constraints, cont’d
  • Total hours worked by family = planting hours + livestock care hours + hours on neighboring farm
  • Planting hours and livestock care hours determined by acreage and number of livestock
  • Hours on neighboring farm: optional (decision)
  • Total hours worked by family W&S must not exceed the total available (4,000 hrs)
  • Total hours worked by family S&F must not exceed the total available (4,500 hrs)
decisions revised
Decisions, revised
  • How much acreage should be planted for each crop?
  • How many new cows and hens should the family purchase?
  • How many hours should the family work on the neighboring farm?
measure of performance
Measure of Performance
  • The measure of performance is the family’s total monetary worth at the end of one year.
  • Their total monetary worth is the following sum:

Total Net Income

+ End of Year Value of Assets

+ Leftover Investment Fund

- Total Living Expense

= Total Monetary Worth

project assignment
Project Assignment
  • Do parts a) – e) and g) – i) of Case 5-3, pp.182-183 in the textbook.
  • Use the spreadsheet template provided on your instructor’s website to start your work.
  • Hint for part d): the Sensitivity Report prints “objective coefficients” for functions that are not the final objective function.
    • For example, the total net value of the plantings is a SUMPRODUCT of the acres planted cells and the net value cells. The Sensitivity Report treats the net value cells as “objective coefficients.”
    • Thus, your assignment in part d) is to use the Sensitivity Report “objective coefficient” information to find allowable ranges for the net value per acre planted for each of the three crops.
project assignment1
Project Assignment
  • Hint for part d) continued: a portion of the Sensitivity Report for the spreadsheet model:
  • This is NOT the whole Sensitivity Report, just the portion relevant to part d).
project assignment2
Project Assignment
  • Your report should model each scenario in part e) with its own spreadsheet model. These should be tabs in your Excel spreadsheet file.
  • Planning: your study group should have at least parts a) - d) completed by Monday and have a very good start on parts e) – i). We will use lab time on Monday to help you complete the project, but you must come to lab with some work done already, or it will be difficult for me to help you.