c. Formulate Linear Optimization Models for the following:i.A company has been given a tender to supply maize to four drought zones. The cost oftransporting each unit from the grains depot to the drought zone is given below:1 | 2 | 34 Supply121 16 25 | 1317 18 14 2313332 27 18 4119Demand10 12 15436.2.

Find the Given details below: Given details: 1 2 3 4 Supply 1 21 16 25 13 11 2 17 18 14…

Answered: c. Formulate Linear Optimization Models…

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

1. XYZ Company is considering making a new product which requires several types of raw material: In Stock Required Raw Material Description Ayay Nil 100 Replacement Cost is $5 per unit. This material has limited supply. This material is also used to produce another product which has a contribution margin of $3.5 per unit of material Ayay. All available supply of material Ayay are needed to produce this another product. Benzam Nil 40 Current purchase price is $7/unit. Chizzum 100 150 purchased for $10/unit Current purchase price is $14/unit. The material has no use in the company other than for the project under consideration. Units in inventory can be sold for $12/unit. Dedee 120 50 purchased for $20/unit Current purchase price is $22/unit. The material is regularly used in current manufacturing operations. Required: Compute the relevant cost of each material.
Amalgamated Products which produces chemical materials has the following demand pattern for one of its key products. Weekly demand data is show below: Week Demand 1 1000 2 1250 3 800 4 1900 5 1640 6 2200 7 1870 8 2670 9 3210 10 2850 11 2200 12 2980 13 3790 14 4210 15 4716 Apply the Holt’s Model in forecasting the demand for period 16 What are the optimal values for alpha and beta if the decision-maker wishes to restrict both values to be between 0.25 and 0.65 What is the value of the minimized error term in this context? Show all related EXCEL plotsＢ Note: Include all EXCEL regression output and any plots
1iii- Please solve this question. Thanks
Qn1. Find the optimal solution to the transportation problem using MODI method. Warehouses Supply WI W2 W3 W4 P1 19 30 50 12 Plants 5. 2. P2 70 30 40 60 P3 40 10 60 20 3. 15 Demand 4)
Problem 3-31 (Algo) The following are sales revenues for a large utility company for years 1 through 11. Forecast revenue for years 12 through 15. Because we are forecasting four years into the future, you will need to use linear regression as your forecasting method. (Enter your answers In mlons.) YEAR REVENJE (MILLIONS) $4,875.0 5,865.7 5,523.4 5,729.9 5,500.9 5,190.0 $5,097.2 5,112.3 5,553.8 5,734.4 5,863.5 1 2 10 11 Period Forecast 12 13 14 15
State which forecast is best on the result for a., b., and c. forecasts. Explain your answer.
4. Spears Rowbuck has recorded the following sales figures. Calculate the seasonal indices for Thursday and Friday. Week 1 Week 2 Week 3 Week 4 Monday 43 51 40 66.0 Tuesday 45 41 57 58.6 Wednesday 22 37 30 34.7 Thursday 25 22 33 36.7 Friday 31 25 37 25.0 a. Thursday = 29.18, Friday = 29.50 b. Thursday = 0.2074, Friday = 1.1632 c. None of the other options. d. Thursday = 0.7678, Friday = 0.7763 e. Thursday = 0.6142, Friday = 0.6211
Problem 10-21 (Algorithmic) United Express Service (UES) uses large quantities of packaging materials at its four distribution hubs. After screening potential suppliers, UES identified six vendors that can provide packaging materials that will satisfy its quality standards. UES asked each of the six vendors to submit bids to satisfy annual demand at each of its four distribution hubs over the next year. The following table lists the bids received (in thousands of dollars). UES wants to ensure that each of the distribution hubs is serviced by a different vendor. Which bids should UES accept, and which vendors should UES select to supply each distribution hub? Distribution Hub Bidder 1 2 3 4 Martin Products 190 165 120 240 Schmidt Materials 140 240 150 200 Miller Containers 215 210 145 235 D&J Burns 175 185 190 290 Larbes Furnishings 200 185 155 230 Lawler Depot 230 190 140 230 Bidder Decision Bid Martin Products Schmidt Materials Miller…
The purpose of this assignment is to utilize Distribution Requirements Planning (DRP) parameters and inventory data to determine planned order releases in central warehouses. address each problem using full sentences and proper spelling and grammar and submit in an Excel template. 2. For the warehouse of Figure 14.8, suppose actual demands were 24, 16, and 18 in periods 1, 2, and 3, respectively. The initial DRP record is: Forecast requirements In transit Projected available balance Planned shipments Q=40; lead time=1; SS=6. 6 1 20 40 26 Period 2 3 4 5 20 20 20 20 6 266 26 40 40 a. Create the other three DRP records as done in Figure 14.8. What problem is created in period 2? What can be done? b. Does error addback work for this set of circumstances?
please solve within 30 minutes.
Give examples of the characteristics of the Just in Time System?
Question 2 A farmer in the Blue Mountains area of Jamaica wants to decide on the crop to plant next season. He wants to plant either ganja or coffee for export to the USA but need some help. He knows that if he plants ganja and the weather in the USA is predominantly cold he earns $10,000(US per month. If the weather is warm he earns $16,000. If he plants coffee and the weather is cold he earns 13,000 and if the weather is warm he earns $14000. In 40% of the years, the weather was cold and in 60 % the weather was warm. For $600, he could buy an expert weather forecast from CWD consulting. States of Nature with Profits ($) Does not include forecast cost Decision Warm Cold weather (C) Alternatives weather(W) Ganja $16,000 $10,000 Coffee $14,000 $13000 Prior Probabilities P(W) = 0.60 P(C) = .40 Conditional probability for a given state of nature where forecasts are either Good (G) or bad (B): That is: P (G|W) = 0.80; P (B|W) = 0.20; P (G|C) = 0.10; P (B|C) = 0.90 After vou have computed…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS