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.

Chapter5: Network Models

Section: Chapter Questions

Problem 80P

See similar textbooks

Similar questions

Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements are Day M T W Th F S Su Requirements 7 3 4 4 5 4 5 Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have 2 consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S-Su pair in case of a tie. (Note: If there is a tie that cannot be broken by following the preference to the S-Su pair, choose the pair closest to the beginning of the considered week.) The minimum number of workers is 7 workers. (Enter your response as a whole number.) Specify the workforce schedule for each employee by indicating the day offs (other days are considered to be…
Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements areDay M T W Th F S SuRequirements 6 3 5 3 7 2 3Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have two consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S–Su pair in case of a tie.
Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements are Day M T W Th F S Su Requirements 7 3 5 5 6 2 2 Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have 2 consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S-Su pair in case of a tie. (Note: If there is a tie that cannot be broken by following the preference to the S-Su pair, choose the pair closest to the beginning of the considered week.) Part 2 The minimum number of workers is _________workers. (Enter your response as a…
2) A farmer is planning the crops that will be planted in the upcoming season. The farmer can get $353.08 per metric ton of soybean, $119.42 per metric ton of barley, $163.80 per metric ton of corn, and $212.64 per metric ton of wheat. The total capacity of the farm is 400 metric tons of product. Based on rising tariffs, at most, the soybeans should constitute 20% of the total crop. Prices for barley and wheat have been declining, so corn should at least be 175 metric tons. a. Solve the linear program using Solver and write the strategy. b. Run a sensitivity analysis and identify the constraints that are binding. c. What is the change in the objective function value if the minimum for corn was 100 metric tons and the farmer acquired land that could produce 75 more metric tons of crop? Please show work in excel
A company has three plants at location A,B and C which produce the same product. It has to supply this to buyers located at P, Q and R. The weekly plant capacities for A, B and C are 250, 800 and 350 units respectively, while the buyer requirements are 700, 200 and 500 for P, Q and R respectively. The unit shipping cost (in Ksh) are given as Plant Buyer P Buyer Q Buyer R A 8 4 10 B 9 7 9 C 6 5 8 Determine the distribution for the company so as to minimize the cost of transportation using least cost method.
A cement company has 3 (three) factories in different locations, namely in A, B, and C. Production costs in A are Rp. 600,000 per ton, in B Rp. 400,000 per ton and in C Rp. 500,000,- per ton. Each factory currently only produces 100,000 tons per day according to market demand, even though the actual installed capacity of the three factories can produce 120,000 tons per day. The company sends production from the three factories to 3 (three) distributor locations, namely X, Y, and Z. The demand for Distributor X is 100,000 tons per day, Distributor Y is 120,000 tons per day, and Distributor Z is 80,000 tons per day. The company wants to use warehouses located at J and K with a storage capacity of 125,000 tons and 175,000 tons per day respectively and shipping costs (in thousands of rupiah) as shown in the table below. The value "M" means it is not possible to make a delivery. Note: “x” in the table denoted by the last number of your ID number. Example, if my ID is 2602296545, then the…
ou are given a linear programming problem. Maximize P = 3x + 3y subject to 5x + 3y ≤ 30 Resource 1 2x + 3y ≤ 21 Resource 2 x ≤ 4 Resource 3 y ≥ 0 x ≥ 0 (a) Use the method of corners to solve the problem. The maximum is P = at (x, y) = . (b) Suppose P = cx + 3y. Find the range of values that the coefficient c of x can assume without changing the optimal solution. ≤ c ≤ (c) Find the range of values that Resource 1 can assume. ≤ (Resource 1) ≤ (d) Find the shadow price for Resource 1.
A steel manufacturing company at Balakong has operating hours from 7.45am to 5.45 pm. It also includes 15 minutes for 5S activities, lunch break from 12pm-1.15pm, evening break 10mins, morning break 10 mins. The plant is closed every Saturday and Sunday. The production runs three variants of products- A, B and C. Determine the takt time to satisfy customer demand of 1800 units monthly of product C The company has determined that the standard time is 1.1 man hour per unit. Help them to determine the number of operators needed, considering the attendance rate is 92%.
Amy Zeng, owner ofZeng's Restaurant Distributions,supplies nonperishable goods to restaurants around the metroarea. She stores all the goods in a storage area with a single dockand one aisle. The goods are divided into five categories accordingto the following table. The table indicates the number of tripsper month to store or retrieve items in each category, as well asthe number of storage blocks taken up by each. The following picture of the storage area provides an identificationnumber for each of the 16 storage blocks. For each item category,indicate into which blocks it should be stored.
A plant has sufficient capacity to manufacture any combination of four different products (A, B, C, D). For each product, time is required to be invested in four different machines, which is expressed in hours per kilogram of product, as shown in the following table as shown in the following table: (attached image) Each machine has an availability of 60 hours per week. Products A, B, C and D can be sold at $9, $7, $6 and $5per kilo, respectively. Variable labor costs are $2 per hour for machines 1 and 2, and $3 per hour for machines 3 and 4. The material costs for each kilogram of product A are $4. The material costs for each kilogram of products B, C, D and D are $4 each kilogram of products B, C and D are $1. What needs to be done:Formulate a profit-maximizing PL model given the maximum demand per product shown in the table (there are 16 variables). Note: The picture is in spanish, but I mean... is pretty easy to understand
A plant has sufficient capacity to manufacture any combination of four different products (A, B, C, D). For each product, time is required to be invested in four different machines, which is expressed in hours per kilogram of product, as shown in the following table as shown in the following table: (attached image) Each machine has an availability of 60 hours per week. Products A, B, C and D can be sold at $9, $7, $6 and $5per kilo, respectively. Variable labor costs are $2 per hour for machines 1 and 2, and $3 per hour for machines 3 and 4. The material costs for each kilogram of product A are $4. The material costs for each kilogram of products B, C, D and D are $4 each kilogram of products B, C and D are $1. What needs to be done:Formulate a profit-maximizing PL model given the maximum demand per product shown in the table (there are 16 variables). Note: do the exercise by hand, or do it digitally, but not in excel.
The admissions office at State University wants to de-velop a planning model for next year’s entering freshman class. The university has 4500 available openings forfreshman. Tuition is $8600 for an in-state student and$19,200 for an out-of-state student. The university wantsto maximize the money it receives from tuition, but bystate mandate it can admit no more than 47% out-of-statestudents. Also, each college in the university must have atleast 30% in-state students in its freshman class. In orderto be ranked in several national magazines, it wants thefreshman class to have an average SAT score of 1150.Following are the average SAT scores for last year’sfreshman class for in-state and out-of-state students ineach college in the university, plus the maximum size ofthe freshman class for each college. a. Formulate and solve a linear programming model thatwill determine the number of in-state and out-of-statestudents that should enter each college. b. If the solution in part (a) does not…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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.