The Onenote Co., which makes a single product, has threeplants and four customers. The respective plants will be able toproduce 60, 80 and 40 units, during the following period. Thecompany has promised to sell 40 units to customer 1, 60 unitsto customer 2, and at least 20 units to customer 3. Bothcustomer 3 and 4 want to buy as many of the remaining unitsas possible. The net profit associated with shipping one unitfrom plant i to customer j is given in the table:ClientPlant1231$800 $$500 $$ 600 $2700 $200 $400 $3500 $100 $300 $Management wants to know how many units to sell tocustomers 3 and 4 and how many units to ship from eachplant to each customer to maximize profit.Solve this exercise using Excel Solver step by step.200300500

PlantClient1234Supply1$800$700$500$200602$500$200$100$300803$600$400$300$50040Demand 4060200

Answered: The Onenote Co., which makes a single…

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

Solve Problem 1 with the extra assumption that the investments can be grouped naturally as follows: 14, 58, 912, 1316, and 1720. a. Find the optimal investments when at most one investment from each group can be selected. b. Find the optimal investments when at least one investment from each group must be selected. (If the budget isnt large enough to permit this, increase the budget to a larger value.)
A chocolate maker has contracted to operate a small candy counter in a fashionable store. To startwith, the selection of offerings will be intentionally limited. The counter will offer a regular mixof candy made up of equal parts of cashews, raisins, caramels, and chocolates, and a deluxe mixthat is one-half cashews and one-half chocolates, which will be sold in one-pound boxes. In addition, the candy counter will offer individual one-pound boxes of cashews, raisins, caramels, andchocolates.A major attraction of the candy counter is that all candies are made fresh at the counter. However, storage space for supplies and ingredients is limited. Bins are available that can hold theamounts shown in the table.IngredientCapacity(pounds per day)Cashews 120Raisins 200Caramels 100Chocolates 160In order to present a good image and to encourage purchases, the counter will make at least 20boxes of each type of product each day. Any leftover boxes at the end of the day will be removedand given to a…
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.
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.
The figure below shows the nodes (A−I) and capacities (labelled on arcs in TB/s) of a computer network. The firm would like to know how much information can flow from node A to node I. Which nodes are the sink and source for this problem? Multiple Choice: Node A is the source, Node I is the sink. Node A is the sink, Node B is the source. Node A is the sink, Node I is the source. Node B is the sink, Node I is the source. Node B is the source, Node I is the sink.
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…
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…
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.
You own wheat warehouse with capacity of 20,000 bushels. At the beginning of month 1, you have 6,000 bushels of wheat. Each month, wheat can be bought and sold at the price per 1000 bushels given in the table Month Selling price ($) Purchase prie ($) 1 3 8 2 6 8 3 7 2 4 1 3 5 4 4 6 5 3 7 5 3 8 1 2 9 3 5 10 2 5 The sequence of events during each month is as follows: a. You observe your initial stock of wheat. b. You can sell any amount of wheat up to your initial stock at the current month's selling price. c. You can buy(at the current month's buying price) as much wheat as you want, subject to the warehouse size imitation. Your goal is to formulate an LP that can be used to determine how to maximise the profit earned over the next 10 months and solve using Excel solver or AMPL
An XYZ company has a W, H, O plant with a monthly production capacity of 60 tons, 50 tons, and 42 tons, respectively; and has 3 sales warehouses in cities A, B, C, D Where each warehouse has a monthly requirement of 30 tons, 34 tons, 44 tons and 25 tons. With shipping cost W to ABCD = IDR 12,000,-, IDR. 8.000,-, Rp. 12.000,-, Rp. 14,000,-; H to A B C D = Rp. 8.000,-, Rp. 18.000,-, Rp. 10,000,-, Rp. 6.000,-; and O to ABCD = Rp. 16.000,-, Rp. 16.000,-, Rp. 2,000, Rp. 10,000,-. Please calculate using Vogel's Approximation Method or VAM Question a. What is the best transportation model in your opinion to solve the above problems? b. What is the minimum transportation cost to solve the shipping transportation problem! c. Based on these calculations, give suggestions regarding the transportation model and the amount of costs incurred by the company!
Riesemberg Medical Devices is allocating next year's budget among its divisions. As a result, the R&D Division needs to determine which R&D projects to fund. Each project requires various software and hardware and consulting expenses, along with internal human resources. A budget allocation of $1,300,000 has been approved, and 35 engineers are available to work on the projects. The R&D group has determined that at most one of projects 11 and 77 should be pursued, and that if project 66 is chosen, then project 11 must also be chosen. Develop a model to select the best projects within the budget.

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