The Johnny Ho Manufacturing Company in Columbus, Ohio, is putting out four new electronic components. Each of Ho's four plants has the capacity to add one more product to its current line of electronic parts.The unit-manufacturing costs for producing the different parts at the four plants are shown in the accompanying table.ComponentC53C81D5D44The optimal assignment of plants to components that minimizes the cost is:The cumulative cost of the optimal assignment of plants to components =Plant 1Plant 2Plant 3Plant 410.140.030.400.1920.130.040.360.12dollars (round your response to two decimal places).Plant30.090.060.320.1540.100.070.330.11

Manufacturing cost is the total cost of all assets consumed during the time spent making a…

Answered: The Johnny Ho Manufacturing Company in…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter11: Simulation Models

Section: Chapter Questions

Problem 69P: The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon...

See similar textbooks

Similar questions

Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. The firm can sell all it produces. Both models use the same electronic components. Two of these can be obtained only from a single supplier. For the next month, the supply of these is limited to 4,000 of component A and 3,500 of component B. The number of each component required for each product and the profit per unit are in the table below. This question is interested in maximizing the profit). a) Identify the decision variables, objective function, and constraints in simple verbal statements. b) Mathematically formulate a linear optimization model. Components Required/Unit A B Profit/Unit LaserStop 18 6 $124 SpeedBuster 12 8 $136 Solve this question in Excel by using SOLVER. Please clearly explain what is the optimal solution? What is the resulting output of the objective function at the optimal solution? P.S. please solve in Excel.
33 White & Becker Tools (W&B) requires 2,000 elec- tric motors next month for its product line of weed trimmers. Each motor is composed of three com- ponents: a coil, a shaft, and housing. W&B has the capability to produce these components or purchase them from an outside vendor. The costs of produc- ing them and purchasing them are shown in the following table. COMPONENT Coil Shaft Housing DEPART- MENT PRODUCTION COST PER UNIT Fabrication 0.5 Molding 0.4 Inspection 0.2 $2.60 $1.80 $1.40 The components that are produced by W&B must pass through three departments: fabrication, molding, and inspection. The number of hours each component requires in each department and the total number of hours available next month in each department are shown in the following table: 0.2 0.7 0.3 PURCHASE COST PER UNIT COIL SHAFT HOUSING AVAILABILITY (HR.) (HR.) (HR.) (HR.) $3.12 $2.16 $1.68 0.6 0.3 0.4 3,000 3,000 1,800 In order to determine the number of components that will be produced and the number…
PRODUCT MIX: The JP Manufacturing Company produces two products. Resource requirements for production are given in the table. There are 1500 hours of assembly worker hours available per week, 600 hours of paint time, and 200 hours of the inspection time. Regular customers will demand at least 150 units of the regular line and 90 of the super. Formulate an LP model that will determine the optimal product mix on a weekly basis. Product Profit contribution Assembly time (hr) Paint time (hr) Inspection time (hr) Product A 50 1 1/2 1/5 Product B 75 1.5 3/4 1/5
Suppose the following costs for a 10-hour round-trip flight apply to the time frame and expenses of an unscheduled 5-hour charter flight from Baltimore to Las Vegas (and return the next day) on a seven-year-old Boeing 737–800 with 120 occupied seats. Some costs listed in the table have been aggregated up to the flight level from a seat-level decision where they are incurred. Others have been allocated down to the flight level from an entry/exit or maintain-ownership company-level decision. Still other costs vary with the go/no go flight-level decision itself. Your job is to analyze each cost item and figure out the “behavior of cost”—that is, with which decision each cost varies. Fuel and landing fees =$5,200 Quarterly airframe maintenance re: FAA certificate = $1,000 Unscheduled engine maintenance per 10 flight hours =$1,200 Pro rata time depreciation for seventh year of airframe = $7,200 Flight pay for pilots per round-trip flight = $4,200 Long-term hangar facility lease = $6,600…
The Noname Computer Company builds a computer designated model ICU2. It imports the motherboard of the computer from Taiwan, but the company inserts thesockets for the chips and boards in its plant in Lubbock, Texas. Each computerrequires a total of ninety 64K dynamic random access memory (DRAM) chips.Noname sells the computers with three add-in boards and two disk drives. The company purchases both the DRAM chips and the disk drives from an outside supplier.The product structure diagram for the ICU2 computer is given in Figure 8–6.Suppose that the forecasted demands for the computer for weeks 6 to 11 are220, 165, 180, 120, 75, 300. The starting inventory of assembled computers inweek 6 will be 75, and the production manager anticipates returns of 30 in week 8and 10 in week 10.c. Determine the schedule of outside orders for the disk drives
The Noname Computer Company builds a computer designated model ICU2. It imports the motherboard of the computer from Taiwan, but the company inserts thesockets for the chips and boards in its plant in Lubbock, Texas. Each computerrequires a total of ninety 64K dynamic random access memory (DRAM) chips.Noname sells the computers with three add-in boards and two disk drives. The company purchases both the DRAM chips and the disk drives from an outside supplier.The product structure diagram for the ICU2 computer is given in Figure 8–6.Suppose that the forecasted demands for the computer for weeks 6 to 11 are220, 165, 180, 120, 75, 300. The starting inventory of assembled computers inweek 6 will be 75, and the production manager anticipates returns of 30 in week 8and 10 in week 10.a. Determine the MPS for the computers.
Company ZWZ manufactures three products in a serial system; Product XA is manufactured in Stage 1, Product XB in Stage 2, and XC in Stage 3. Product XB has a sales potential in the market; hence, some of it can be sold at the end of Stage 2, and the remaining can be moved to Stage 3. The third stage produces Product XC, and then delivers it to customers. Two units of Product XA produced in Stage 1 are required for each unit of Product XB in Stage 2. In addition, four units of Product XB produced in Stage 2 are required for each unit of Product XC in Stage 3. Stage 1 can only use regular time; however, Stage 2 has the options of using regular time and overtime in manufacturing. On the other hand, Stage 3 has only one alternative, which is subcontracting. The pertinent data are provided below: Stage 2 Stage 1 11 No overtime No subcontracting No sales 0.07 Unit regular time cost (TL) Unit overtime cost (TL) Unit subcontracting cost (TL) Unit selling price (TL) Unit processing time (hrs)…
She must travel to Kenya to check on quality and transportation. The trip will cost $2,500. The cost of the handbag is $10 and shipping to the United States can occur through the postal system for $2 per handbag or through a freight company which will ship a container that can hold up to 1,000 handbags at a cost of $1,000. The freight company charges $1,000 even if less than 1,000 handbags are shipped. Leslie will sell the handbags to retailers for $20. Assume there are no other costs and benefits. what is the output level that both shipping methods yield same profit? Ho
A manufacturer produces three models (I, II, and III) of a certain product using raw materials A and B. The labor time per unit model of I is twice that of Il and three times that of III. The entire labor force of the factory can produce the equivalent of 1500 units of Model I. Market requirements specify the ratios 3:2:5 for the production of the three respective models and minimum demand levels should be satisfied. Requirement Raw Material II Availability A 2 3 5 4000 В 4 2 7 6000 Minimum demand 200 200 150 Price per unit 30 20 50 The objective is to maximize the total revenue. a. Formulate a linear programming model for this problem. b. Discuss your findings in the context of assumptions of linear programming.
Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens are given below. The profit for either model is $1000 per lot. Plastic Ink Assembly Molding Time Fliptop Model 3 5 5 Formulate a LP Model for this problem. Tiptop Model 4 4 2 Available 36 40 30
The Tubular Ride Boogie Board Company has manufacturing plants in Tucson, Arizona and Toronto, Ontario. You have been given the job of coordinating distribution of the latest model, the Gladiator, to outlets in Honolulu and Venice Beach. The Tucson plant, when operating at full capacity, can manufacture 620 Gladiator boards per week, while the Toronto plant, beset by labor disputes, can produce only 410 boards per week. The outlet in Honolulu orders 500 Gladiator boards per week, while Venice Beach orders 530 boards per week. Transportation costs are as follows. Tucson to Honolulu: $10 per board; Tucson to Venice Beach: $5 per board. Toronto to Honolulu: $20 per board; Toronto to Venice Beach: $10 per board. (a) Assuming that you wish to fill all orders and ensure full capacity production at both plants, is it possible to meet a total transportation budget of $9,900? O Yes O No If so, how many Gladiator boards are shipped from each manufacturing plant to each distribution outlet? (If…
As part of its initiative to implement just-in-time (JIT) manufacturing at the motorcycle assembly plant in Exercise 1, Harley has reduced the number of engines loaded on each truck to 100. If each truck trip still costs $1,000, how does this decision impact annual inventory costs at Harley? What should the cost of each truck be if a load of 100 engines is to be optimal for Harley? Exercise 1 - Harley-Davidson has its engine assembly plant in Milwaukee and its motorcycle assembly plant in Pennsylvania. Engines are transported between the two plants using trucks, with each trip costing $1,000. The motorcycle plant assembles and sells 3000 motorcycles a year. Each engine costs $500. Harley incurs a holding cost of 20 percent per year. How many engines should Harley load onto each truck? What is the cycle inventory of engines at Harley?(Please show all steps in EXCEL)

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

The Johnny Ho Manufacturing Company in Columbus, Ohio, is putting out fou The unit-manufacturing costs for producing the different parts at the four plan Com