A manufacturer produces both widgets and gadgets. Widgets generate a profit of $70 each and gadgets have a profit margin of $45 each. To produce each item, a setup cost is incurred. This setup cost is $400 for widgets and $500 for gadgets. Widgets consume 5 units of raw material A and 6 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Each day, the manufacturer has 500 units of each raw material available. Assume that it is possible to produce fractional quantities of widgets and gadgets. Set up the problem in Excel and find the optimal solution.

A manufacturer produces both widgets and gadgets. Widgets generate a profit of $70 each and gadgets have a profit margin of $45 each. To produce each item, a setup cost is incurred. This setup cost is $400 for widgets and $500 for gadgets. Widgets consume 5 units of raw material A and 6 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Each day, the manufacturer has 500 units of each raw material available. Assume that it is possible to produce fractional quantities of widgets and gadgets. Set up the problem in Excel and find the optimal solution.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter11: Simulation Models

Section: Chapter Questions

Problem 47P

See similar textbooks

Similar questions

A manufacturer of Blu-ray Discs (BDs) estimates the yearly demand for a BD to be 10,000. It costs $400 to set up the machinery to burn the BDs, plus $3 for each one produced. If it costs the company $2 to store a BD for a year, how many should be burned at a time and how many production runs will be needed to minimize costs? BDs burned at a time production runs
A plastic canister manufacturing company maintains an annual safety stock of 500 units of plastic caps. If the company places an annual purchase order for 1,800 units of these caps, its average annual inventory, in units, is between: ( )1,500 and 1,300 ( )3,200 and 3,000 ( )2,400 and 2,200 ( )1,200 and 1,000 ( )1,900 and 1,700
A manufacturer has been shipping his product (moderately heavy machines), mounted only on skids withoutcomplete crating. To avoid crating he must ship in freight cars which contain only his machines. To do thishe must pay freight on a car capacity load of 42 tons regardless of whether or not the car is completely full.In the past he actually has shipped only 30 tons in each car. The carload freight rate is P4.10 per hundredpounds. If the machine is crated so that they can be shipped in mixed car lots, along with other merchandise,they can be shipped at a rate of P4.20 per hundred pounds with the freight bill computed only on the actualweight shipped. The cost of crating would be P25 per machine and would increase the shipping weight from1,200 to 1,220 pounds per machine. Which procedure should be followed? (1 ton = 2,200 lbs)
. Sarah’s Organic Soap Company makes four kinds of organic liquid soap: “regular,”“lavender,” “citrus,” and “tea tree.” Demands for the four scents are 150, 120, 75, and50 kgs per hour, respectively. Sarah’s production process can produce any soap at therate of 450 kgs per hour, but 1.5 hours are needed to switch between scents. Duringthose switchover times, the process doesn’t produce any soap. Sarah wants to choosea production schedule that (i) cycles repeatedly through the four scents, (ii) meets therequired demand, and (iii) minimizes the amount of inventory held.How many kgs of “regular” should Sarah produce before switching over to another scent?
Compute Lead Time Jackson Fabricators Inc. machines metal parts for the automotive industry. Under the traditional manufacturing approach, the parts are machined through two processes: milling and finishing. Parts are produced in batch sizes of 80 parts. A part requires 2 minutes in milling and 6 minutes in finishing. The move time between the two operations for a complete batch is 7 minutes. Under the lean philosophy, the part is produced in a cell that includes both the milling and finishing operations. The operating time is unchanged; however, the batch size is reduced to 5 parts and the move time is eliminated. Determine the value-added, non-value-added, and total lead times, and the value-added ratio under the traditional and lean manufacturing methods. If reguired, round percentages to one decimal place. Traditional Philosophy Lean Manufacturing Philosophy Value-added time 8 V min 8 V min Non-value-added time 632 X min 48 x min Total lead time 640 x min 56 x min Value-added ratio…
A wallpaper company estimates the demand for a certain pattern to be 925 rolls per year. It costs $750 to set up the presses to print the pattern, plus $150 to print each roll. If the company can store a roll of wallpaper for a year at a cost of $4, how many rolls should it print at a time and how many printing runs on average will it need in a year to minimize production costs? (Assume the wallpaper sells steadily throughout the year, and the company reorders more whenever the stock runs out. Round the number of rolls per print to the nearest whole number and the average number of printing runs per year to two decimal places.) rolls per print rolls print runs per year runs
A producer of electronic parts wants to take account of both production rate and demand rate in deciding on its lot sizes. A particular $50 part can be produced at a rate of 1000 units per month, and the demand rate is 200 units per month. The firm uses a carrying charge of 24 percent a year, and the setup cost is $200 each time the part is produced.a. What lot size should be produced?b. If the production rate is ignored, what would the lot size be? How much does this smaller lot size cost the firm on an annual basis?c. Draw a graph of on-hand inventory versus time
A company wishes to store the following SKUs so there is 100% accessibility. Theitems are stored on pallets that can be stacked three high.a. How many pallet positions are needed?b. What is the cube utilization?c. If the company bought racking for storing the pallets, how many pallet positionsare needed to give 100% accessibility?
A manufacturer has a production facility that requires 10,237 units of component JY21 per year. Following a long-term contract, the manufacturer purchases component JY21 from a supplier with a lead time of 6 days. The unit purchase cost is $31.4 per unit. The cost to place and process an order from the supplier is $168 per order. The unit inventory carrying cost per year is 12.2 percent of the unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is appropriate. If the manufacturer uses a constant order quantity of 1,053 units per order, what is the annual holding cost? Use at least 4 decimal places.
In a large microelectronics plant, the assembly cell for circuit boards has a demand for 250 units an hour. Two feeder cells supply parts A and B to the assembly cell (one A and one B for each board). Standard containers that look like divided trays are used. A container will hold 24 As or 10 Bs. It takes 10 minutes to fill up a container with As and 24 minutes to fill up a container with Bs. Transit time to the assembly cell is 5 minutes for both A and B. No safety factor is used. Set up a kanban control system for the assembly process.
. 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.
Emarpy Appliance is a company which produces all kinds of major. Bud Banis, the president of Emarpy, is concerned about the production policy for the company’s bestselling refrigerator. The annual demand for this has been about 8,000 units each year, and this demand has been constant throughout the year. The production capacity is 200 units per day. Each time production starts, it costs the company $120 to move materials into place, reset the assembly line, and clean the equipment. The holding cost of a refrigerator is $50 per year. The current production plan calls for 400 refrigerators to be produced in each production run. Assume there are 250 working days per year. (b) If the company were to continue to produce 400 units each time production starts, how many days would production continue? (c) Under the current policy, how many production runs per year would be required? What would the annual set-up cost be? (d) If the current policy continues, how many refrigerators would be…