A manufacturing cell makes three models of a product – AKC1011, BC0001, and AC0102. The daily demand for the three products are as follows: 200 of AKC1011, 500 BC0001, and 300 of AC0102. Develop a balanced mixed-model sequence that should be repeated throughout the day in order to meet demand.

A manufacturing cell makes three models of a product – AKC1011, BC0001, and AC0102. The daily demand for the three products are as follows: 200 of AKC1011, 500 BC0001, and 300 of AC0102. Develop a balanced mixed-model sequence that should be repeated throughout the day in order to meet demand.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Hilliard Electronics produces specially coded computer chips for laser surgery in 64MB, 256MB, and 512MB sizes. (1MB means that the chip holds 1 million bytes of information.) To produce a 64MB chip requires 8 hours of labor, a 256MB chip takes 13 hours, and a 512MB chip requires 16 hours. Hilliard’s monthly production capacity is 1,200 hours. Mr. Blank, the firm’s sales manager, estimates that the maximum monthly sales of the 64MB, 256MB, and 512MB chips are 40, 50, and 60, respectively. The company has the following goals (ranked in order from most important to least important): 1. Fill an order from the best customer for thirty 64MB chips and thirty-five 256MB chips. 2. Provide sufficient chips to at least equal the sales estimates set by Mr. Blank. 3. Avoid underutilization of the production capacity. Formulate this problem using goal programming
Duluth Electronics makes two types of scooters: Falcon and Hawk. The Falcon model has a lighter engine and a smaller frame to make novice riders easier to balance. The Hawk is a little bigger and uses a heavier engine. Falcon requires 6 hours of manufacturing time and Hawk takes only 3 hours. Duluth's main plant in Kentucky has 2,100 hours of engine manufacturing time available. Duluth's vendors have the ability to supply as many Falcon frames as needed, but they only provide 280 Hawk frames. Falcon requires 2 hours of testing and 2.5 hours for Hawk. There are only 1,000 hours available for testing. The finance department estimates that the Falcon model contributes a profit of $2,400 and the Hawk $1,800. Determine the optimal solution for this problem. Recommend what you think is a good strategy for Duluth, given your computations. Type your final answers in the space provided and show your graph in the solutions file (no need for hand-drawn graphs, but the feasible region should be…
An Soda company sells about 400 gallons of its highly demanded beverage each week. The estimated cost to store as well maintain one gallon of this product is $0.50 per week. Each time the Soda company places an order from its supplier, the following costs are incurred, independent of the size of the order: a $300 delivery fee, $50 unloading and storage, and a $60 transaction fee. Once an order is placed, it arrives exactly 2 work days later. The Soda company, supplier, and delivery carrier all operate 7 days per week. Question: What is the optimal (s,Q) policy?
Dr. Thompson makes three bean mixes for coffee shops located in the Austin. The three mixes, referred to as the Tameka Mix, the Christian Mix, and the Tamia Mix, are made by mixing different percentages of five types of beans. In preparation for the fall season, Dr. Thompson just purchased the following shipments of beans at the prices shown: Type of Beans Shipment Amount in pounds Cost Per Shipment in dollars Arabica 6000 7500 Robusta 7500 7125 Liberica 7500 6750 Excelsa 6000 7200 Juno 7500 7875 The Tameka Mix consists of 15% Arabica, 25% Robusta beans, 25% Liberica, 10% Excelsa, and 25% Juno. The Christian Mix consists of 20% of each type of beans, and the Tamia Mix consists of 25% Arabica, 15% Robusta beans, 15% Liberica, 25% Excelsa, and 20% Juno. Dr. Thompson analyzed the cost to get the beans ready and determined that the profit contribution per pound is $1.65 for the Tameka Mix, $2.00 for the Christian Mix, and $2.25 for the…
Dr. Thompson makes three bean mixes for coffee shops located in the Austin. The three mixes, referred to as the Tameka Mix, the Christian Mix, and the Tamia Mix, are made by mixing different percentages of five types of beans. In preparation for the fall season, Dr. Thompson just purchased the following shipments of beans at the prices shown: Type of Beans Shipment Amount in pounds Cost Per Shipment in dollars Arabica 6000 7500 Robusta 7500 7125 Liberica 7500 6750 Excelsa 6000 7200 Juno 7500 7875 The Tameka Mix consists of 15% Arabica, 25% Robusta beans, 25% Liberica, 10% Excelsa, and 25% Juno. The Christian Mix consists of 20% of each type of beans, and the Tamia Mix consists of 25% Arabica, 15% Robusta beans, 15% Liberica, 25% Excelsa, and 20% Juno. Dr. Thompson analyzed the cost to get the beans ready and determined that the profit contribution per pound is $1.65 for the Tameka Mix, $2.00 for the Christian Mix, and $2.25 for the…
each Distributors packages and distributes industrial supplies. A standard shipment can be packaged in a class A container, a class K container, or a class T container. A single class A container yields a profit of $10; a class K container, a profit of $8; and a class T container, a profit of $12. Each shipment prepared requires a certain amount of packing material and a certain amount of time. Formulate and solve this problem using LP software. Resources Needed per Standard Shipment Class of Container Packing Material (pounds) Packing Time (hours) A 2 2 K 1 6 T 3 4 Total amount of resource available per week 120 pounds 210 hours Hugh Leach, head of the firm, must decide the optimal number of each class of container to pack each week. He is bound by the previously mentioned resource restrictions but also decides that he must keep his 6 full-time packers employed all 210 hours (6 workers × 35 hours)…
An electronics firm produces two models of pocket calculators: the A-100 (A), which is an inexpensive four-function calculator, and the B-200 (B), which also features square root and percent functions. Each model uses one (the same) circuit board, of which there are only 2,500 available for this week's production. Also, the company has allocated a maximum of 800 hours of assembly time this week for producing these calculators, of which the A-100 requires 15 minutes (.25 hours) each, and the B-200 requires 30 minutes (.5 hours) each to produce. The firm forecasts that it could sell a maximum of 4,000 A- 100's this week and a maximum of 1,000 B-200's. Profits for the A-100 are $1.00 each, and profits for the B-200 are $4.00 each. What is the objective function? What is the assembly time constraint (in hours)? Which of the following is not a feasible production/sales combination? What are optimal weekly profits?
A linear programming computer package is needed. Frandec Company manufactures, assembles, and rebuilds material-handling equipment used in warehouses and distribution centers. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and a metal strap. Frandec's production schedule calls for 4,500 Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing and purchase costs per unit are shown. Component Manufacturing Cost Purchase Cost Frame $39.00 $52.00 Support $12.50 $16.00 Strap $7.50 $8.50 Three departments are involved in the production of these components. The time (in minutes per unit) required to process each component in each department and the available capacity (in hours) for the three departments are as follows. Component Department Cutting Milling…
A linear programming computer package is needed. Frandec Company manufactures, assembles, and rebuilds material-handling equipment used in warehouses and distribution centers. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and a metal strap. Frandec's production schedule calls for 5,500 Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing and purchase costs per unit are shown. Component Manufacturing Cost Purchase Cost Frame $39.00 $52.00 Support $12.50 $16.00 Strap $7.50 $8.50 Three departments are involved in the production of these components. The time (in minutes per unit) required to process each component in each department and the available capacity (in hours) for the three departments are as follows. Component Department Cutting Milling…
A linear programming computer package is needed. Frandec Company manufactures, assembles, and rebuilds material-handling equipment used in warehouses and distribution centers. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and a metal strap. Frandec's production schedule calls for 5,500 Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing and purchase costs per unit are shown. Component Manufacturing Cost Purchase Cost Frame $39.00 $52.00 Support $12.50 $16.00 Strap $7.50 $8.50 Three departments are involved in the production of these components. The time (in minutes per unit) required to process each component in each department and the available capacity (in hours) for the three departments are as follows. Component Department Cutting Milling…
. A commercial orchard grows, picks, and packs apples and pears. A peck (quarter bushel) of apples takes 4 minutes to pick and 5 minutes to pack; a peck of pears takes 5 minutes to pick and 4 minutes to pack. Only one picker and one packer are available. How many pecks each of apples and pears should be picked and packet every hour (60 minutes) if the profit is $3/peck for apples and $2/peck for pears? Solve graphically as a linear program and confirm analytically.
Patz Company produces two types of machine parts: Part A and Part B, with unit contribution margins of $400 and $800, respectively. Assume initially that Patz can sell all that is produced of either component. Part A requires two hours of assembly, and B requires five hours of assembly. The firm has 400 assembly hours per week. What if market conditions are such that Patz can sell at most 100 units of Part A and 80 units of Part B? Express the objective function with its associated constraints for this case. Objective function: Max Z = $400 A + $800 B Assembly-hour constraint fill in the blank 7 A + fill in the blank 8 B ≤ fill in the blank 9 Demand constraint for Part A A ≤ fill in the blank 10 Demand constraint for Part B B ≤ fill in the blank 11 Identify the optimal mix and its associated total contribution margin.Component A $fill in the blank 12 units Component B $fill in the blank 13 units Total contribution $fill in the blank 14