Horizon Cellular manufactures cell phones for exclusive use in its communication network. Management must select a circuit board supplier for a new phone soon tobe 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 thefollowing table.Annual Freight CostsShipping Quantity (Q)Price/Unit(p)$28$30$31Annual HoldingCost/Unit (H)$5.60Lead TimeAnnual10.000(L) (days)SupplierAbbott20,000Administrative Cost$7,500$6,000$9,000$10.000$9.000$11.000$10,000$9.000$11,000$6.00$6.20Baker9Carpenter7Which supplier and shipping quantity will provide the lowest total cost for Horizon Cellular?UsingV and a shipping quantity ofV units is the lowest cost alternative, with annual total costs to Horizon Cellular of S. (Enter your responseas an integer.)

Given data: Annual Freight costs Shipping Quantity($) Shipping Quantity($) Price/Unit($) Annual…

Answered: Horizon Cellular manufactures cell…

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

IL Data related to the inventories of Metro Supply are presented below: 困 Surgical Equipment $ 260 170 240 Surgical Supplies $ 120 Rehab Rehab Selling price Cost Equipment S 340 Supplies $ 165 90 250 235 162 Replacement cost Costs to sell Normal gross profit ratio 80 158 30 25 10 30% 30% 30% 20% *Show your computation! If not, no credit A) In applying the lower of cost or market rule, the inventory of surgical equipment would be valued at: B) In applying the lower of cost or market rule, the inventory of surgical supplies would be valued at: C) In applying the lower of cost or market rule, the inventory of rehab equipment would be valued at: D) In applying the lower of cost or market rule, the inventory of rehab supplies would be valued at:
Rationalization and Optimization: Creating aManageable Supply Base
Reactions and additional comments: Per the textbook definition, the term bullwhip effect “Describes the distortions in a supply chain caused by changes in customer demand, resulting in large swings in inventory levels as the orders ripple upstream from the retailer to the distributor and manufacturer” (Wallace, 2020, p. 137). The term is derived from physics. When cracking a whip, someone just has to snap their wrist and it causes a wave like effect that increases with a chain reaction. The bullwhip effect is a term that was first used in the 1990s. The makers of Pampers had many changes in order volumes, when usually diapers were bought at a constant rate (The Bullwhip effect : History and solutions, 2021). This caused the company to receive hard hits in demand with each new order from the retailers. For example, during the Covid-19 pandemic, everyone was told to stay home, go to school from home, and work from home. This caused the need for many more computers and electronic…
[8] United States. Your harvest has just come in and you picked 795,000 pounds of apples. You need to distribute the harvest to the appropriate warchouse locations. You manage an apple orchard that distributes fruit throughout the southeast part of the [A] Using the following warchouse information, allocate the apples to their appropriate locations. DEMAND STANDARD DESIRED WARE CURRENT STOCK DEVIATION OF DEMAND HOUSE INVENTORY FORECAST AVAIL- ABILITY Atlanta 35,000 lbs 190,000 lbs 20,000 lbs 95% Miami 10,000 Ibs 170,000 lbs 18,000 lbs 95% Columbia 45,000 lbs 155,000 Ibs 10,000 lbs 85% Memphis 5,000 lbs 145,000 Ibs 25,000 lbs 80% [B] Discuss two additional methods to push inventory into a network.
Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the table below. Annual usage is 1,100 valves; order cost is $10 per order; and annual inventory holding costs are $7.55 per unit. D D Vendor A Quantity 1-14 15-24 25-99 100-199 200-399 400+ Price $35.00 34.75 33.55 32.35 31.15 30.75 Vendor C Vendor D Vendor A D Vendor B Vendor B Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrigation should order units at a time from (enter your response as a whole number). Quantity 1-24 25-99 100-199 200-399 400+ Price $34.75 34.00 32.80 31.60 30.50 MacBook Air O Vendor C Quantity 1-49 50-149 150-299 300+ Price $34.50 33.75 32.50 31.10 Vendor D Quantity 1-149 150-299 300+ Price $34.25 33.00 31.00 Next
1. Maxmin Trading Company buys 1,000 pcs of chair per month. The cost per chair is Php500 and ordering cost is Php400. The inventory carrying cost is estimated at 10% of the price of the chair. Determine the EOQ. 2. Maxmin Trading Company buys 1,000 pcs of chair per month. The cost per chair is Php500 and ordering cost is Php400. The inventory carrying cost is estimated at 10% of the price of the chair. Determine the total carrying cost. 3. Maxmin Trading Company buys 1,000 pcs of chair per month. The cost per chair is Php500 and ordering cost is Php400. The inventory carrying cost is estimated at 10% of the price of the chair. Determine the total ordering cost. 4. Maxmin Trading Company buys 1,000 pcs of chair per month. The cost per chair is Php500 and ordering cost is Php400. The inventory carrying cost is estimated at 10% of the price of the chair. Determine the number of orders required per year. 5. Minmax Processing Company has an average requirement of 5 boxes of…
4. Distinguish between a supplier and a prime vendor. 5. Describe the Farm/School Meals Initiative.
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…
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…
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.)
From the following particulars calculate (1) Inventory turnover ratio and(2) Inventory conversion period. Cost of goods sold is Rs 4,50,000,Opening stock was Rs.1,25,000, Closing stock wasRs.1,75,000

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