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 60,000 units and Horizon's plant operates 250 days per year. The data for three suppliers are inthe following table.DAnnual Freight CostsShipping Quantity (Q)Annual10,000$11,000SupplierAbbottBakerCarpenterPrice/Unit20,000(P)$8,500$30$6,500$31$5,500Annual HoldingCost/Unit (H)$6.00$6.20Lead Time(L) (days)47Administrative Cost$11,000$9.000$9,000$8,000$29$5.803$8,000Which supplier and shipping quantity will provide the lowest total cost for Horizon Cellular?Usingand a shipping quantity ofunits is the lowest cost alternative, with annual total costs to Horizon Cellular of S. (Enter your response as an integer.)

Given information:Annual Demand (D) = 60,000 unitsNumber of weeks = 250 daysDaily Demand (d) =…

Answered: Using and a shipping quantity of units…

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

Effective Demand Management of Broken Hill Proprietary Company Limited (BHP) as part of overall Logistics and Supply Chain expertise
please answer correctly in a detailed manner.
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. Annual Freight Costs Shipping Quantity (Q) Price/Unit Annual Holding Lead Time (L) Annual Administrative 5,000 $5.000 Cost/Unit (H) $0.82 (p) 10,000 $3.500 $3,800 (wks) Supplier Sharps Winkler 15.000 Cost $3,100 $3,300 $4.10 $4,000 $5.200 $4.00 $0.80 6 $5,000 Which supplier and which shipping quantity will provide the lowest costs for Eight Flags? Using V and a shipping quantity of is the lowest cost alternative, with annual total costs to Eight Flags of $. (Enter your response as an integer.)
Zhou Bicycle Company Zhou Bicycle Company (ZBC), located in Seattle, is a whole- sale distributor of bicycles and bicycle parts. Formed in 1981 by University of Washington Professor Yong-Pin Zhou, the firm's primary retail outlets are located within a 400-mile radius of the distribution center. These retail outlets receive the order The company distributes a wide variety of bicycles. The most popular model, and the major source of revenue to the company, is the Air Wing. ZBC receives all the models from a single manufacturer in China, and shipment takes as long as 4 weeks from the time an order is placed. With the cost of com- munication, paperwork, and customs clearance included, ZBC estimates that each time an order is placed, it incurs a cost of $65. The purchase price paid by ZBC, per bicycle, is roughly 60% of the suggested retail price for all the styles available, and the inventory carrying cost is 1% per month ( 12% per year) of the purchase price paid by ZBC. The retail price…
What is a cross-dock facility? Give an example of how a cross-dock facility could be used by a large retailer.
In this problem, your company is a distributor of products. You serve as an inventory manager for the regional distribution center (DC) here in the Atlanta area. In this role, you schedule the purchase and shipment of products from various suppliers inbound to the Atlanta DC. Once you receive the products at the DC, they are stored in inventory until they are picked, packed, and shipped outbound to your company's downstream customers in response to orders. For each of your products, you currently use a single, dedicated supplier. Each of your suppliers ships their products to you from their facility using trucking services, and they provide you with choices of different LTL or truckload trucking carriers depending on your shipment size. Consider managing inventory now for product 101 produced by Supplier A. Currently, you face demand for product 101 of about 200 units per week. Each unit of product 101 has a purchase cost p of $500 and you decide to value your inventory at the slightly…
Case 1: Distribution woes hobble start-ups in India At 4 am every day, you will find a crowd of hawkers near the Chhatrapati Shivaji Railway Terminus in Mumbai. They line up to buy their daily inventory of newspapers and magazines from 15-odd distributors, all located in a dark lane outside the nearby New Empire Cinema. After making their purchases, the street vendors fan out into the city on bicycles, motorbikes, rickshaws, and trains. By 6 am, the crowd has vanished, and if you walk past the theatre during the day, you will most likely miss the nerve centre of magazine and newspaper distribution in Mumbai. Most hawkers in Mumbai have a cash budget of around US$3 or US$4 a day, and they usually have a similar amount tied up in unsold inventory (returns). Elsewhere in the country, vendors have even less cash to spare. The key question an entrepreneur wishing to launch a new periodical must ask is: Why would a hawker want to lock up his scarce capital in my product? Failing to ask that…
Professor Gaffney needs to ship 800 pounds of laboratory equipment to a colleague across country. Due to limited departmental funds, Dr. Gaffney would like to minimize total shipment costs. Currently, the freight classification is 77.5. However, a local equipment manufacturing company is willing to specially package the equipment in order to drop the freight classification to 55. Use the table below to calculate the break-even cost of using this service. Class <500 (lbs) 500 (lbs) 1,000 (lbs) 2,000 (lbs) 5,000 (lbs) 10,000 (lbs) ≥20,000 (lbs) 50 34.31 28.56 24.61 23.24 17.24 15.48 10.68 55 36.97 30.55 26.57 24.16 18.46 17.39 11.66 60 39.74 32.33 27.57 26.51 20.79 19.37 12.03 65 41.06 34.18 29.27 28.15 21.77 20.29 13.46 70 44.33 36.93 31.29 29.84 22.87 21.13 14.46 77.5 48.53 39.82 34.83 32.75 24.46 23.58 15.75 85 51.89 42.44 36.17 34.08 26.97 26.14 17.32 92.5 55.94 46.12 39.75 37.35 28.76 28.08 18.77 100 60.07 49.31 42.43 40.15 30.86 30.54 20.39 In…
The logistics of moving goods around the world-between countries and within countries-has been troubled by volume constraints in most parts of the supply chain from carriers to warehousing. O primarily in warehouses and distribution centers O primarily in ocean and rail carriers O mostly in the trucking industry
As an insurance student Explain the importance of insurance in supply chain and logistics business

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

Using and a shipping quantity of units is the lowest cost alternative, with annual total costs to Horizon Cellular of S. (Enter your response as an integer)