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
Formulate the action(s) necessary for customer knowledge management. I Gathering superior customer knowledge saves a firm the effort of codifying it. II Accumulating customer knowledge facilitates efficient investment decisions by a firm. III Customer information is transformed into knowledge through systematic organisation and analysis by a firm. Choose one correct option. (a) Both I and II (b) Both II and III (c) All of the listed choices (d) I only.
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?
Steamboat A catchy slogan or sales pitch of steamboat
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
Dear Students 1. Recall the distinctions of services: - High in search qualities - High in experience qualities - High in credence qualities From your understanding of the concept, what are the challenges associated with marketing of services for "high in experience qualities" versus "high in credence qualities" services?
Define Problem Solving & list the theories involved in problem solving (Understanding)