1. Solve the following problem by using Solver in your spreadsheet: Steelco | manufactures three types of steel at different plants. The time required to manufacture 1 ton of steel (regardless of type) and the costs at each plant are shown in Table 8. Each week, 100 tons of each type of steel (1, 2, and 3) must be produced. Each plant is open 40 hours per week. Formulate a balanced transportation problem to minimize the cost of meeting Steelco's weekly requirements. TABLE 8 Plant 1 23 2 3 Steel 1 60 50 43 Cost (S) Steel 2 40 30 20 Steel 3 28 30 20 Time (minutes) 20 16 15 a. Write down the problem formulation ! b. Write down your conclusion ! 2. Write down the formal LP Formulation from Problem No. 1. 3. Solve the LP formulation from No.2 by using Excel Solver ! 4. Compare Problem No. 1 solution and Problem No. 2's solution, and then explain your conclusion !

1. Solve the following problem by using Solver in your spreadsheet: Steelco | manufactures three types of steel at different plants. The time required to manufacture 1 ton of steel (regardless of type) and the costs at each plant are shown in Table 8. Each week, 100 tons of each type of steel (1, 2, and 3) must be produced. Each plant is open 40 hours per week. Formulate a balanced transportation problem to minimize the cost of meeting Steelco's weekly requirements. TABLE 8 Plant 1 23 2 3 Steel 1 60 50 43 Cost (S) Steel 2 40 30 20 Steel 3 28 30 20 Time (minutes) 20 16 15 a. Write down the problem formulation ! b. Write down your conclusion ! 2. Write down the formal LP Formulation from Problem No. 1. 3. Solve the LP formulation from No.2 by using Excel Solver ! 4. Compare Problem No. 1 solution and Problem No. 2's solution, and then explain your conclusion !

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

s The company produces 30 tables in this year. The manager of the company wants to increase the productivity by 20% in the next year. To achieve this goal, how many tables need to be produced in the next year? Accessibility: Investigate
Estimate the forecasted sales price value for the year 2020 $85,000 $120,000 $105,000 $95,000
Identify the features that Business Intelligence incorporates which are found in the list below. a. TPS, OAS and KWS b. DSS, EIS and ESS c. TPS, MIS and KWS d. OAS, KWS and EIS
Below is data of lobster sales volume from a seafood company. We are using exponential smoothing (α = 0.5) and 3-year moving average to forecast it. a. Please fill the blanks above and write your processes below. b. What are the mean absolute deviations (MADs) of the two methods? Whichmethod will you choose based on the results? *Please solve for a-b and type or write all your work/steps and answers on paper* NO EXCEL, thank you
I could use a hand with this
You are asked to perform a study about the effect of the weather on software developer’s productivity (if any). The study is for a company called MySoftware which gave you access to all data you need to perform the study. They aim at relocating if they find an effect of the weather on their engineers. 1. Use the “Goal-Question-Metric” (GQM) approach to set up the study. derive a minimum of one objective, the associated question, and suitable metrics. The metrics and questions showed be mapped to each other. That is, after each question, state the metric(s) that you suggest to answer the question DB RESPONSE: When you reply to other peers’ posts, comment on whether their metrics are measurable, hard or easy to measure, or costly. Your discussion does not have to be "perfect", but it must be yours. Please check the Discussion Board grading rubric.
give details calculation
What relationship between x and y is suggested by the scattergram? OA a quadratic relationship with downward concavity OB. a linear relationship with positive slope OC. a linear relationship with negative slope D. a quadratic relationship with upward concavity
Dave F letcher, the general manager of NorthCarolina Engineering Corporation (NCEC), thinks that his firm'sengineering services contracted to highway construction firms aredirectly rela ted to the volume of highway construction businesscontracted with companies in his geographic area. He wondersif thjs is really so, and if it is, can this information help him planhjs operations better by forecasting the quantity of his engineeringservices required by construction firms in each quarter of theyear? The following table presents the sales of his services andtotal amounts of contracts for hjghway construction over the pasteight quarters:…
If the sales forecast estimates that 50,000 units of product will be sold during the following year, should the factory plan on manufacturing 50,000 units in the coming year? Explain.