Question

In: Statistics and Probability

Potato Foods Co, a major producer of mashed potato, is considering the purchase of 4 potato...

Potato Foods Co, a major producer of mashed potato, is considering the purchase of 4 potato farms, see below.


Farm

Annual Costs

($1,000s)

Projected Annual Harvest (1000s of tons)

Idaho

404

11.2

Washington

361

8.5

Wisconsin

338

6.8

Colorado

307

5.3


The company will be processing the potato from the farms at its three plants, see below.

Plant

Potato Projected Annual Consumption

(1000s of tons)

Tennessee

6.1

Kansas

5.2

Utah

8.9

Total

20.2


Ignoring shipping costs, the company needs to determine what farms to purchase to satisfy the projected potato consumption at the minimum total annual cost. With the purpose of a balanced geographic distribution, follow the guidelines:

-Exactly one farm between Idaho and Washington must be purchased; in other words, at least one of the two farms but NOT both.

- At most one farm between Idaho and Wisconsin must be purchased; in other words, none or either the Idaho farm or the Wisconsin farm can be purchased, but NOT both

-At least one of the following farms must be purchased: Wisconsin, Colorado

-If Washington farm is purchased, then Wisconsin farm must also be purchased

-No more than three farms must be purchased


Define the variables, formulate the problem, and SOLVE it in Excel (generate the Answer report)

Please answer in excel and post pictures so i can see how to do this on my own.

Solutions

Expert Solution

Let indicate that the farm i is purchased and indicate that the farm i is not purchased, where i=1,2,3,4 indicate that the farm is Idaho, Washington, Wisconsin, Colorado respectively.

These indicator variables are the decision variables.

The total annual cost is

the company needs to determine what farms to purchase to satisfy the projected potato consumption at the minimum total annual cost and hence the above is the objective function.

The constraints are

satisfy the projected potato consumption

The total projected annual Harvest is

This has to meet the Projected total Annual Consumption of 20.2 (1000s of tons)

-Exactly one farm between Idaho and Washington must be purchased; in other words, at least one of the two farms but NOT both.

- At most one farm between Idaho and Wisconsin must be purchased; in other words, none or either the Idaho farm or the Wisconsin farm can be purchased, but NOT both

-At least one of the following farms must be purchased: Wisconsin, Colorado

-If Washington farm is purchased, then Wisconsin farm must also be purchased

-No more than three farms must be purchased

The LP model can be stated as

Minimize

s.t.

Prepare this

get this

set up the solver using data--->solver

get this

ans: To minimize the cost buy the farms at Washington, Wisconsin, Colorado at at total annual cost of $1006 ($1,000s)


Related Solutions

4. A researcher testing sodium content of snack foods examines samples of two brands of potato...
4. A researcher testing sodium content of snack foods examines samples of two brands of potato chips that both claim to be low in sodium. A random sample of 25 lunch-size bags of chips for Super Chips indicates an average of 80 milligrams of sodium per bag, with a standard deviation of 5 milligrams. A second sample of 22 lunch-size bags of Real Potato Snacks shows an average of 77 milligrams of sodium per bag, with a standard deviation of...
Fresh Foods is considering the purchase of a new packaging system. The system costs $50,715. The...
Fresh Foods is considering the purchase of a new packaging system. The system costs $50,715. The company plans to borrow three-quarters (3/4) of the purchase price from a bank at 9% per year compounded annually. The loan will be repaid using equal, annual payments over a 6-year period. The payments will be made at the end of each year for the life of the loan, with the first payment occurring at the end of year 1. The system is expected...
Fresh Foods is considering the purchase of a new packaging system. The system costs $55022. The...
Fresh Foods is considering the purchase of a new packaging system. The system costs $55022. The company plans to borrow three-quarters (3/4) of the purchase price from a bank at 10% per year compounded annually. The loan will be repaid using equal, annualpayments over a 7-year period. The payments will be made at the end of each year for the life of the loan, with the first payment occurring at the end of year 1. The system is expected to...
Fresh Foods is considering the purchase of a new packaging system. The system costs $180623. The...
Fresh Foods is considering the purchase of a new packaging system. The system costs $180623. The company plans to borrow three-quarters (3/4) of the purchase price from a bank at 8% per year compounded annually. The loan will be repaid using equal, annualpayments over a 7-year period. The payments will be made at the end of each year for the life of the loan, with the first payment occurring at the end of year 1. The system is expected to...
The One Ring company, a leading producer of fine cast silver jewelry, is considering the purchase...
The One Ring company, a leading producer of fine cast silver jewelry, is considering the purchase of new casting equipment that will allow it to expand its product line. The up-front cost of the equipment is $750,000. The company expects that the new equipment will produce a steady income throughout its 10-year life. a) If One Ring requires a 12% return on its investment, what minimum yearly cash inflow will be necessary for the company to go forward with this...
Pappy's Potato has come up with a new product, the Potato Pet that they are considering...
Pappy's Potato has come up with a new product, the Potato Pet that they are considering launching. The company has determined they will need a fixed asset investment at the beginning of the project of $260,000. This asset will last for four years which is the life of the project. Also, they will need to have more net working capital (NWC) of which they have estmated an amount of $16,500 for this purpose. The NWC will be recovered when the...
Pappy's Potato has come up with a new product, the Potato Pet that they are considering...
Pappy's Potato has come up with a new product, the Potato Pet that they are considering launching. The company has determined they will need a fixed asset investment at the beginning of the project of $260,000. This asset will last for four years which is the life of the project. Also, they will need to have more net working capital (NWC) of which they have estmated an amount of $16,500 for this purpose. The NWC will be recovered when the...
The Button Co. is considering the purchase of a new machine for $30,000 that has a...
The Button Co. is considering the purchase of a new machine for $30,000 that has a life of 5 years and would be depreciated on straightline basis to a zero salvage value over its life. The machine is expected to save the firm $12,500 per year in operating costs. Alternatively, the firm can lease the machine for $7,300 annually for 5 years, with the first payment due at the end of the first year. The firm's tax rate is 21...
Enjoy Inc. is a producer of potato chips. A single production process at Enjoy​ ​Inc., yields...
Enjoy Inc. is a producer of potato chips. A single production process at Enjoy​ ​Inc., yields potato chips as the main​ product, as well as a byproduct that can be sold as a snack. Both products are fully processed by the splitoff​ point, and there are no separable costs. For September 2017​ the cost of operations is $485,000. Production and sales data are as​ follows: Production (in pounds) Sales (in pounds) Selling Price per Pound Potato Chips 54,000 41,040 $16...
SaltySalty​, Inc. is a producer of potato chips. A single production process at SaltySalty​, ​Inc., yields...
SaltySalty​, Inc. is a producer of potato chips. A single production process at SaltySalty​, ​Inc., yields potato chips as the main​ product, as well as a byproduct that can be sold as a snack. Both products are fully processed by the splitoff​ point, and there are no separable costs. For September 20172017​, the cost of operations is $ 485 comma 000$485,000. Production and sales data are as​ follows: LOADING... ​(Click the icon to view the production and sales​ data.)There were...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT