Question: Please solve using Excel Solver and upload formulas from Excel so I can see how the problem is supposed to be done. Please do not

Please solve using Excel Solver and upload formulas from Excel so I can see how the problem is supposed to be done. Please do not write out the answer. It must be solved in Excel.
Please solve using Excel Solver and upload
(C) Frijo-Lane Food Products owns farms in the Southwest and Midwest where it grows and harvests potatoes. It then ships these potatoes to three processing plants in Atlanta, Baton Rouge, and Chicago where different varieties of potato products, including chips, are produced. Recently, the company has experienced a growth in its product demand so it wants to buy one or more new farms to produce more potato products. The company is considering six new farms with the following annual fixed costs and projected harvest. Farms 1 2 3 4 5 Fixed Annual Costs Projected Annual Harvest ($1000s) (thousands of tons) $405 11.2 $390 10.5 $450 12.8 $368 S520 10.8 S465 9.6 9.3 The company currently has the following additional available production capacity (tons) at its three plants that it wants utilize Plant A B Available Capacity (thousands of tons) 12 10 14 The shipping costs (S) per ton from the farms being considered for purchase to the plants are as follows. MUST be solved in Excel. Not Plant (shipping costs, S/ton) written or typed Farm A out. Please solve in Excel Solver. 1 18 15 12 2 13 Please upload 3 16 18 screen shots of 4 19 formulas used in 5 17 19 12 Solver. Please 16 12 state the final decision. The company wants to know which of the six farms it should purchase that will meet available production capacity at the minimum cost, including annual fixed costs and shipping costs. 17 10 14 15 16

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!