You own a wheat warehouse with a capacity of 20,000 bushels. At the beginning of month 1, you have 6,000 bushels of wheat. Each month, wheat can be bought and sold at the price per 1000 bushels given in the Table Month Selling price Purchase price 1 3 8 2 6 8 3 7 2 4 1 3 5 4 4 6 5 3 7 5 3 8 1 2 9 3 5 10 2 5 The sequence of events during each month is as follows: a. You observe your initial stock of wheat. b. You can sell any amount of wheat up to your initial stock at the current month’s selling price. c. You can buy (at the current month’s buying price) as much wheat as you want, subject to the warehouse size limitation. Your goal is to formulate an LP that can be used to determine how to maximize the profit earned over the next 10 months and solve using Excel so

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter4: Linear Programming Models
Section: Chapter Questions
Problem 89P
icon
Related questions
Question

You own a wheat warehouse with a capacity of 20,000 bushels. At the
beginning of month 1, you have 6,000 bushels of wheat. Each month, wheat
can be bought and sold at the price per 1000 bushels given in the Table

Month Selling price Purchase price
1 3 8
2 6 8
3 7 2
4 1 3
5 4 4
6 5 3
7 5 3
8 1 2
9 3 5
10 2 5

The sequence of events during each month is as follows:
a. You observe your initial stock of wheat.
b. You can sell any amount of wheat up to your initial stock at the
current month’s selling price.
c. You can buy (at the current month’s buying price) as much wheat as
you want, subject to the warehouse size limitation.
Your goal is to formulate an LP that can be used to determine how to maximize
the profit earned over the next 10 months and solve using Excel solver

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Knowledge Booster
Optimization models
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,