Homework Help is Here – Start Your Trial Now!
Business
Operations Management
How many units of product does Factory 2 deliver to Store 1 (answer to whole number)?

How many units of product does Factory 2 deliver to Store 1 (answer to whole number)?

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
See similar textbooks
icon
Related questions
Question
This question will be used to answer the next several questions. You own 3 factories and 4 stores that sell your products. The table below includes the cost to deliver each individual product to each store from that factory, as well as the cost of producing a given item at each production center, as well as the maximum and minimum individual items each store needs to receive to sell, and the number of individual items that can be produced in each factory. You can copy and paste the data in the table below into Excel without typing values in individually (but do quality control the paste for accuracy); copy-paste should work but if it does not, try paste - paste special - and select unicode text. Factory1 Factory2 Factory3 min max cost to produce max production Store1 Store2 Store3 Store4 2.45 800 2.89 950 3.24 1180 3.87 3.51 6.76 6.95 4.31 3.85 2.76 2.92 Use linear programming to maximize profit. 2.21 7.09 4.47 2.13 Price 300 400 500 650 370 450 400 520 9.99 10.49 14.49 11.29 How many units of product does Factory 2 deliver to Store 1 (answer to whole number)?
Transcribed Image Text:This question will be used to answer the next several questions. You own 3 factories and 4 stores that sell your products. The table below includes the cost to deliver each individual product to each store from that factory, as well as the cost of producing a given item at each production center, as well as the maximum and minimum individual items each store needs to receive to sell, and the number of individual items that can be produced in each factory. You can copy and paste the data in the table below into Excel without typing values in individually (but do quality control the paste for accuracy); copy-paste should work but if it does not, try paste - paste special - and select unicode text. Factory1 Factory2 Factory3 min max cost to produce max production Store1 Store2 Store3 Store4 2.45 800 2.89 950 3.24 1180 3.87 3.51 6.76 6.95 4.31 3.85 2.76 2.92 Use linear programming to maximize profit. 2.21 7.09 4.47 2.13 Price 300 400 500 650 370 450 400 520 9.99 10.49 14.49 11.29 How many units of product does Factory 2 deliver to Store 1 (answer to whole number)?
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS