Wanda Lux must select a supplier for a plastic bottle and proprietary dispenser for its new hair shampoo. Three suppliers have placed bids; at Wanda's request, all bids are for a shipping quantity (Q)of 20,000 bottles with annual requirements (D) of 40,000 units. Wanda's factory operates 250 days a year. The following table shows each supplier's price, estimated annual freight costs, and currentlead times; management has added estimates for holding costs and administrative oversight costs for each supplier.UsingFreightCostsSupplier$3,000Dover PlasticsEvan & SonsFarley, Inc.$3,500$4,500a. Which of the three suppliers will provide the lowest annual cost to Wanda Lux?AnnualPrice/Unit Holding Cost/Unit(P)View an example Get more help.$5.10$5.00$5.15(H)$1.02$1.00$1.03LeadTime (L)(days)14171847Dis the lowest cost alternative, with annual total costs to Wanda Lux of $. (Enter your response rounded to the nearest whole number.)Annual AdministrativeCosts$4,000$3,000$5,000Clear allCheck answer

Annual demand = 40000 units Number of operating days = 250 Daily requirement = 40000/250 = 160…

Answered: Wanda Lux must select a supplier for a…

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

I need question D solved please (a) What was their average aggregate inventory value? =46,410,239(b) What was their average inventory (measured in weeks of supply)? =6.97(c) What was their inventory turnover?=7.1771BIT operates on a build-to-stock policy, and therefore stores its finishedgoods in a warehouse capable of housing up to 70,000 units. Its annual overhead cost (fixed cost) is $117,000; and it costs $3/unit to house the finished goods. BIT has been approached by a warehouse company offering to house the finished goods for a unit cost of $4.5/unit, with an annual contract cost of $30,000. (d) Should BIT continue operating its own warehouse, or should it employthe warehouse company? Why?
Horizon Cellular manufactures cell phones for exclusive use in its communication network. Management must select a circuit board supplier for a new phone soon to be introduced to the market. The annual requirements (D) are 40,000 units and Horizon's plant operates 250 days per year. The data for three suppliers are in the attached table. Annual Freight Costs Shipping Quantity (Q) Supplier 10,000 20,000 Price/Unit (p) Annual Holding Cost/Unit (H) Lead Time (L) (days) Annual Administrative Cost Material Costs Abbott $11,000 $8,500 $29 $5.80 4 $11,000 $232,000.00 Baker $12,000 $9,500 $31 $6.20 3 $12,000 $1,240,000 Carpenter $9,000 $7,000 $28 $5.60 8 $9,000 $1,120,000 Which supplier and shipping quantity will provide the lowest total cost for Horizon Cellular? Using the supplier [X] and a shipping quantity of [X] units is the lowest cost alternative, with annual total costs to Horizon Cellular of [X]. (Quantity and Annual Total Costs are integer…
Eight Flags operates several amusement parks in the Midwest. The company stocks machine oil to service the machinery for the many rides at the parks. Eight Flags needs 30,000 gallons (D) of oil annually; the parks operate 50 weeks a year. Management is unsatisfied with the current supplier of oil and has obtained two bids from other suppliers. The data are contained in the following table. D i Annual Freight Costs Shipping Quantity (Q) (wks) Cost Supplier Sharps Winkler 5,000 $5,200 $5,400 Price/Unit Annual Holding Lead Time (L) Annual Administrative 10,000 15,000 (P) Cost/Unit (H) $3,600 $3,200 $3.70 $3.700 $3,400 $0.74 5 $4,000 $5,000 $3.90 $0.78 6 Which supplier and which shipping quantity will provide the lowest costs for Eight Flags? Using and a shipping quantity of is the lowest cost alternative, with annual total costs to Eight Flags of $. (Enter your response as an integer.)
Identify the SKU’s that management should spend time on and give reasons for your choice(s) in the diagram below. Explain your answer.
Mr. Dan Stockman is the procurement manager for Slicker Image (SI), an upscale retailer of novelty products. It is mid-August, and Mr. Stockman is wondering how many units of a new multi-function smart bracelet to order for the upcoming holiday season (November and December). The Malaysian manufacturer of this item, TechToys, requires orders to be placed in late August for delivery in late October, in time for holiday sales. Based on past experience with similar products, Mr. Stockman believes that the holiday demand (Nov-Dec) for the bracelet is Normally distributed with a mean of 3,000 units and standard deviation of 900. TechToys sells the item to SI at a unit price of $ 145 per unit, and SI has decided to set the retail price at $ 200 during the regular selling season (Nov-Dec). At the end of December, SI will mark down the price by 50% (i.e., sell the item for $ 100) to sell off any left-over items. TechToys incurs a cost of $ 105 per unit to manufacture this bracelet. For…
Why would this cause a procurement professional to integrate with trucking or train companies more intensely? With the Mississippi River at its 8th-lowest water level on record, grounding risk has increased for barge operators,and multiple groundings have been reported on the Lower MississippiOn Tuesday, the U.S. Coast Guard relayed reports of new barge groundings near Stack Island, Mississippi andMemphis, Tennessee, and waterway closures are in effect around both sites. Coast Guard Sector Lower MississippiRiver has reported eight groundings in the past week due to low water levels. "Due to low water levels on the Lower Mississippi River, we have seen an increase in commercial vesselgroundings," said Capt. Eric Carrero, Director of Western Rivers and Waterways at Coast Guard District Eight. "Inresponse, the Coast Guard established a Marine Transportation System Recovery Unit with our federal, state, local,and maritime industry partners to facilitate safe navigation and the continued…
Describe how the suppliers using a factor weighting appraoch ?

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