A company has a total of 3 factories to produce steel and iron. Every month, the company must meet the following demands: 3200 tonnes of steel and 1000 tonnes of Iron. Each factory has a different shipping cost per tonne (£/tonne) for each product as shown in the table below: Factory 1 2 3 Steel 200 800 500 The warehouses in Factory 1, Factory 2 and Factory 3 can store 2000 tonnes, 1500 tonnes and 2500 tonnes of products, respectively. The company is seeking for a solution to minimise the shipping cost. Iron 500 400 1000 a) Based on the table above, determine the optimal monthly assignment plan for the factory. That is, how many tonnes each factory needs to be shipped to fulfil the demand. b) Suppose Factory 3 will not be available during the next few months. Keeping the same demand, is the company able to fulfil the demands? What would be the revised assignment plan to ensure demand is fulfilled? 1 2 3 c) The cost of raw materials in each factory is shown in the table below. Change the company objective function to minimize all costs and find the optimal assignment plan. Does the new solution change from the base case? If yes, how so? Factory Steel raw material Iron raw material cost cost 100 120 130 50 70 45

A company has a total of 3 factories to produce steel and iron. Every month, the company must meet the following demands: 3200 tonnes of steel and 1000 tonnes of Iron. Each factory has a different shipping cost per tonne (£/tonne) for each product as shown in the table below: Factory 1 2 3 Steel 200 800 500 The warehouses in Factory 1, Factory 2 and Factory 3 can store 2000 tonnes, 1500 tonnes and 2500 tonnes of products, respectively. The company is seeking for a solution to minimise the shipping cost. Iron 500 400 1000 a) Based on the table above, determine the optimal monthly assignment plan for the factory. That is, how many tonnes each factory needs to be shipped to fulfil the demand. b) Suppose Factory 3 will not be available during the next few months. Keeping the same demand, is the company able to fulfil the demands? What would be the revised assignment plan to ensure demand is fulfilled? 1 2 3 c) The cost of raw materials in each factory is shown in the table below. Change the company objective function to minimize all costs and find the optimal assignment plan. Does the new solution change from the base case? If yes, how so? Factory Steel raw material Iron raw material cost cost 100 120 130 50 70 45

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

Similar questions

Problem 8-9 Buying versus Leasing a Motor Vehicle [LO8-2] Purchase Costs Down payment Loan payment Estimated value at end of loan Opportunity cost interest rate $ 1,800 $ 730 for 36 months $ 4,600 5 percent Leasing Costs Security deposit Lease payment End of lease charges $ 760 $ 530 for 36 months $ 1,000 Based on the costs listed in the table above, calculate the costs of buying and of leasing a Note: Round your answers to the nearest whole number. Buying and Leasing Total purchase cost Total leasing cost
How do charts, graphs, tables, and other ‘visuals’ create value for You (as the sender) and Value for your Readers (as the receivers)?”
Using "Materials" and "POS" files provided as data sources, Identify the product Name whose sale is between 2500 to 2800 in October 2014. (" Materials" must be considered as Text file. create a relationship between Sheet 1 and "Materials") ( select all that apply). Group of answer choices Ikea Library with Doors, Mobile Sauder College with Doors, Metal Sauder Library with Doors, Metal Cuisinart Stove, Silver
Only typed answer and don't use chat gpt
Please type answer Getting to Market/it will be post in two separate screen shots to make sure it does not go over screen shot size. (unable to upload the information because of the MG size) You probably don't give much thought to all the steps required to make products you see displayed in your favorite stores. There are shelves of food products, racks of clothing, and aisles of electronics. It all comes through the chain of production. Directions: For each of the products identified in the right-hand column, list what would need to happen in the first sections of the chain of production before you would get to enjoy the product. The first one is completed for you. The other 5 Product need the PRIMARY, SECONDARY, TERTIARY AND PRODUCT FOR YOU COMPLETED IS: A can of sliced Pineapple, A ring or Bracelet, A Home, A Car and A Baseball Bat. The Your Favorite Book/Mag has been completed as an example. PRIMARY SECONDARY TERTIARY PRODUCT FOR YOU Trees are cut down The tree is chopped up…
Define Quantitative design for PowerPoint presentation?
Prompt 1: In the healthcare industry, everything is measured. From drip rates to dosages, it seems as though numbers are everywhere. But how does this reflect the care given to the patients? Which type of data (qualitative or quantitative) do you think yields the most information? Why? Which type of data (qualitative or quantitative) is most effective for forecasting future trends? Why? Which practices can a healthcare manager use to ensure that the data used for forecasting trends is accurate? Provide examples of data evaluation in different types of facilities. Provide examples of data evaluation for different types of issues, such as billing or loss of revenue.
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure. if you give incomple answer you will get dislike
Define Problem Solving & list the theories involved in problem solving (Understanding)
Formulate a questionnaire on the research topic "The effects of digital advertising on the marketing of products and services at GECCU". Provide 20 related questions
In the marketplace today, the demand for high-level salespeople
What are the similarities and differences between A3 reports and Kaizen Events?