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.

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

ABC Apple Juice Company produces and markets fresh fruit juice. During the apple harvest season, trucks bring apples from the fields to the process plant during a workday that runs long hours from 7AM. On peak days, approximately 3,000 kg of apples are trucked in per hour. Trucks dump their contents in a holding bin with a storage capacity of 9,000 kg. When the bin is full, incoming trucks must wait until it has sufficient available space. A conveyor moves apples from bin to the processing plant. The plant is configured to process apples at the rate of 2,000 kg per hour. Trucks arrive uniformly between 7:00AM to 5:00PM. Each truck holds about 1,000 kg of apples. The truck drivers are paid at the rate of $10 per hour. As ABC makes fresh juice, it does not store apples. Processing plant starts at 10:00AM and ends when all the apples received during the day have been processed. It takes 2 hours to clean the empty plant that must be kept ready for the next day production. Trucks are owned…
A company possesses two manufacturing plants, each of which can produce three products, X, Y, and Z, from a common raw material. However, the proportion in which the products are produced differs in each plant, and so are plant's operating costs per hour. Data on production per hour and costs are given below, together with current orders in hand of each product. Products Operating cost per hour Y Plant A 4 9. Plant B 4 2 10 Orders on hand 50 24 60 Formulate the above as a linear programming problem. Find the number of production hours needed to fulfill the orders on hand at minimum cost using the using Big M method.
Assuming your company is producing Apple and Samsung phone cases. It is required to process in the assembly and paint shops to make either phone case. It takes 1/60 of a day and 1/40 of a day to paint an Apple case and a Samsung case in the paint shop, respectively. It takes 1/50 of a day to assemble either type of case in the assembly shop. An Apple phone case and a Samsung phone case yield profits of $300 and $220, respectively, per case sold. What is a maximum-profit daily production plan for your company?
Jawad has calculated the possible profits from three different scenarios for the expansion of his restaurant, each for a different amount of advertising and promotion. He has chosen to implement the scenario that offers the greatest profit. Jawad has decided to a. minimin O b. minimnax c. maximax d. maximin
Beeson Co. is experiencing a decrease in sales and operating income for the fiscal year ending December 31st. Julia Faure, controller of Beeson Co., has suggested that all orders received before the end of the fiscal year be shipped by midnight, December 31st even if shipping department must work overtime. Since Beeson Co. ships all merchandise FOB shipping point, it would record all such shipments as sales for the year ending December 31st, thereby offsetting some of the decreases in sales and operating income.Discuss whether Julia Faure is behaving in a professional manner and what are the implications of her actions?
14
A suburb of Dayton, Ohio, has four local dry cleaners that compete with each other on the basis of price and service speed. Each of them can perform the same basic services at the same level of quality. The following table provides the price that each dry cleaner charges to clean a two-piece suit, as well as the quoted number of days that the service will take. Dry Cleaner Price Number of Days A $ 8.00 3 B $ 9.50 3 C $ 9.00 2 D $ 7.50 4 Which of these dry cleaners are NOT on the efficient frontier?
The capacity of a restaurant would be the Multiple Choice minimum operating cost of the restaurant during a workweek. average number of customers that visit the restaurant on weekends. maximum number of customers who can be effectively served at any one particular time. total number of customers who have visited the restaurant since its establishment. average number of employees who work in the restaurant on a normal day.
A Company currently has 230 units of a product on-hand that it orders every three weeks when the salesperson visits the premises. Average demand for the product is 20 units per day with a standard deviation of 5 units. Lead time for the product to arrive is seven days. Management has a goal of 95 percent probability of not stocking out for this product. The salesperson is due to come in late this afternoon when 210 units are left in stock. How many units should be ordered?
Consider an E2/M/1/4 model with the arrival rate of 3 jobs per hour and a service rate of 4 jobs per hour. Note that this system has a capacity of 4 jobs Compute the steady-state probabilities and the system performance measures of utilization, CTs, WIPs, and throughput.
What is the drum, buffer and rope concept that comes from the theory of constraint? (Eli goldratt)

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