Create an LP Model. Coca Cola PH has three bottling plants located at three differentplaces. Each plant produces three different drinks. The capacities of thethree plants, in number of bottles per day are as follows:RoyalSprite20004000CokeCanlubang PlantImus PlantSta. Rosa Plant300010001000100020005003000A market survey indicates that during any month, there will be ademand of 24.000 bottles of Coke, 16.000 bottles of Royal and 48.000bottles of Sprite. The operating cost per day of running these plants areP600,000, P400,000 and P500.000 in Canlubang, Imus and Sta. Rosaplants, respectively. Formulate it as an LP to find the number of daysthat the company should run each plant during the month so that theproduction cost is minimized while meeting the market demand.

This question is related to the topic-decision making and this topic falls under the operations…

Answered: plants, respectively. Formulate it as…

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

Explain how is the moving avarages l approach equivalent to exponential smoothing ?
The Northville Post Office experiences a seasonal pattern of daily mail volume every week. The followingdata for two representative weeks are expressed in thousands of pieces of mail:Day Week 1 Week 2Sunday 5 8Monday 20 15Tuesday 30 32Wednesday 35 30Thursday 49 45Friday 70 70Saturday 15 10Total 224 210 a. Calculate a seasonal factor for each day of the week.b. If the postmaster estimates 230,000 pieces of mail to be sorted next week, forecast the volume foreach day of the week.
12.4. The chairperson of the department of management at Tech wants to forecast the number of students who will enroll in operations management next semester in order to determine how many sections to schedule. The chair has accumulated the following enrollment data for the past eight semesters: Students Enrolled Semester in OM 1 270 2 310 250 4 290 370 6. 410 7 400 8. 450 a. Compute a three-semester moving average forecast for semesters 4 through 9. b. Compute the exponentially smoothed forecast (a = .20) for the enrollment data. c. Compare the two forecasts using MAD and indicate the most accurate. 3.
The Yeasty Brewing Company Produces a popular local beer known as Iron Stomach. Beer sales are somewhat seasonal, and Yeasty is planning its production and workforce levels on March 31 for the next six months. The demand forecasts are as follows: Month April May June July August September Production Days 14 20 24 26 20 18 Forecasted Demand (in hundreds of cases) 75 100 200 140 100 50 As of March 31, Yeasty had 70 workers on the payroll. Over a period of 20 working days when there are 100 workers on the pay roll, Yeasty produced 10,000 cases of beer. The cost to hire each worker is $200 and the cost of laying off each worker is $400. Holding costs amount to 1 dollar per case per month. As of March 31, Yeasty expects to have 3,000 cases of beer in stock. It plans to start October with 3,500 cases on hand. a) Formulate the problem of planning Yeasty's production levels as a linear program. b) Use Excel solver to solve the problem and give the solution (decision variables and objective…
12.2. The manager of the I-85 Carpet Outlet needs to be able to forecast accurately the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpets from one of the outlet’s many competitors. The manager has collected the following demand data for the past eight months: Month Demand for Soft Shag Carpet (1000 yd)1 52 103 64 85 146 107 98 12 a. Compute a three-month moving average forecast for months 4 through 9. b. Compute a weighted three-month moving average forecast for months 4 through 9. Assign weights of .55, .33, and .12 to the months in sequence, starting with…
12.2 The manager of the I-85 Carpet outlet needs to be able to forecast accurately the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpets from one of the outlets many competitors. The manager has collected the following demand data for the past 8 months. Month 1 2 3 4 5 6 7 8 Demand for Soft Shag Carpet (1000 yd) 5 10 6 8 14 10 9 12 a. Compute a three-month moving average forecast for months 4 through 9.
The historical data for 4 perlods demand are 65, 60, B0, ond 70respectively Calculate the weighted moving verae (WMA) forecast of perlod 5 with welghts (0,4, 0,6)
Sarah has been custom manufacturing sweaters now for 7 years. Her annual sales are shown below. Year Sales 1 178 2 215 3 233 4 301 5 337 6 330 7 361 What are her forecasted sales for year 8 using a 3 year moving average? What are her forecasted sales for year 8 using a 5 year weighted average where w1=.4, w2=.3, w3=.15, w4=.1, w5=.05? What are her forecasted sales for year 8 using exponential smoothing? Assume year 7 forecast was 323. Select your own alpha. Which forecast method is the best for Sarah to use based on MAD? Why?
The chairperson of the department of management at Tech wants to forecast the number of students who will enroll in operations management next semester in order to determine how many sections to schedule. The chair has accumulated the following enrollment data for the past 15 semesters: Using 2 Semester Weighted moving average compute the forecasted number of student for semester 16 the weight are 4 for the most recent semester and 2 for the older one. Semester Students Enrolled in OM 1 270 2 310 3 250 4 290 5 370 6 410 7 400 8 450 9 440 10 470 11 520 12 515 13 525 14 542 15 503
In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,200 radials each year. In the past 2 years, 240 and 260, respectively were sold in fall, 350 and 310 in winter, 140 and 165 in spring, and 300 and 635 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,200 radials. Based on next year's projected sales, what is the demand for summer going to be (enter your responses as whole numbers): 468 250 330 153
Tropical Leisure Limited Tropical Leisure Limited has been making high quality Caribbean leisure wears for over twenty-fiveyears, in old rented premises located in the heart of the Barbadian capital of Bridgetown. Thecompany has a flexible labour force of about twenty employees and three directors, only one ofwhom, namely Mr. Grant, the managing director, is fully active in the business.The company specializes in leisure and swim wear garments. Their current range consists of teeshirts, shorts, skirts and bath suits in rich vibrant Caribbean colours and styles for men, women andchildren. The company capacity is 400-500 garments per week, depending on style and continuityof the production run, but additional floor space and machines could be brought in quickly to raiseproduction levels to a maximum of 1000 garments weekly if required.Trade sources estimated that the Barbadian market was valued at US$ 1.5 billion in 2010 but sincethen inflation and recession has deflated the market,…
Data collected on the yearly demand for 50- pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Estimate demand for vear 12 with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other two years are each given a weight of 1. Year Demand (Bags) 4 6. 3 4. 4. 10 6 8. 8. 8. 12 10 14 11 15 O A. 13.67 O B. 14.00 OC. 14.87 O D. 11.79 Click to select your answer. Us MacBook Air 888 * ES F2 F4 F6 F7 4) F9 F10 %23 2$ & * 4 6. 7 8 9. Q W R T Y F C V В alt command command option %#3

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

plants, respectively. Formulate it as an LP to find the number of days that the company should run each plant during the month so that the production cost is minimized while meeting the market demand.