Holding Cost (%) Price ($) Annual Ordering Cost ($) Unit Item Demand 101 500 10 20 0.50 102 1500 10 30 0.20 103 5000 25 30 1.00 104 250 15 25 4.50 105 1500 35 35 1.20 201 10000 25 15 0.75 202 1000 10 20 1.35 203 1500 20 25 0.20 204 500 40 25 0.80 205 100 10 15 2.50

Holding Cost (%) Price ($) Annual Ordering Cost ($) Unit Item Demand 101 500 10 20 0.50 102 1500 10 30 0.20 103 5000 25 30 1.00 104 250 15 25 4.50 105 1500 35 35 1.20 201 10000 25 15 0.75 202 1000 10 20 1.35 203 1500 20 25 0.20 204 500 40 25 0.80 205 100 10 15 2.50

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

A hospital treating COVID patients needs to buy gloves, gowns, and masks for the health care professionals working at the facility. The hospital has two suppliers who can supply the items. The cost, and the maximum number of each item each supplier can provide is given below: Supplier A Supplier B Gloves (cost, max units) ($0.30/unit, 20,000) ($0.35/unit, 11,000) Gowns Masks ($2.00, ($2.50, 5000) 10,000) ($1.75, 7000) ($2.55, 9,500) The hospital immediately needs 30,000 units of gloves, 5500 units of gowns, and 12,500 masks. To account for the economies of scale in logistics, the Supplier A has a requirement of at least 25,000 units in the order, while Supplier B has a requirement of a minimum order size of 10,000 units and a maximum order size of 20,000. What is is the minimum total cost of order that the hospital needs to pay to the suppliers to get the items?
QUESITON 26 Calculate the percentage of assets committed to inventory, where Panda lnc has $44,000,000 in total assets and 11,400,000 of inventory. QUESITON 27 Supply chain management is ... A.a set of procedures connecting suppliers to customers B.Design, operation and improvement of productive systems C.A sequence of activities across organizations that are involved in producing and delivering a product or service D.a series of activities from suppliers to customers that add value to a product or service QUESITON 28 SCOR stands for A.Supply Chain Operations Reference model B.Supply Chain Operations Resilience C.Supply Chain Organsational Resources D.
Genchev Industries conducts an ABC analysis of its inventory and develops the following table from its findings. Item Annual Usage Unit Cost Dollar Usage 1 9,960 $43.20 $430,272 2 3,362 $22.80 $76,654 3 8,332 $9.90 $82,487 4 3,074 $22.30 $68,550 5 2,968 $8.40 $24,931 6 4,195 $25.00 $104,875 7 4,536 $19.20 $87,091 8 9,538 $65.60 $625,693 9 3,484 $3.20 $11,149 10 10,232 $5.70 $58,322 Which of these items is a C item? a. Item 8 b. Item 6 c. Item 5 d. Item 1
“Supply chain management has been a very vital tool in the competitive world of business, and this depends on the product and its supply chain. Managing inventory is a critical activity for the success of supply chain since inventory impacts the costs of goods sold as well as supports customer service”. Discuss the validity of this statement
“oh fada” receives supplies from a wide range of suppliers directly and adds value by breaking down bulk, customising certain items, and holding stocks until customers require them. The number of inflows of various ranges of goods serving the same purpose has begun to increase with several large amounts laying ideal in warehouse and threatening to become obsolete and also adding up unnecessary cost. The coding system does not allow for ease of identification of the products and wrong item are often picked as the difference between the right and wrong item can be just one digit. Orders are received by telephone and there is no provision for electronic ordering. The stock coding system is a sequential one and has contributed to several issues including inaccurate order entry as it is not possible to find the product details from the codes in use. The products for the orders are manually picked by a team, stock records is done manually with a lot of errors and does not update stock…
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…
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January February 4,100 4,200 March 3,900 April 4,300 May 4,900 June 4,600 July 5,200 August 4,800 September 5,300 October 5,600 November 6,200 December 5,900
B15. The restaurant uses 24 bottles of wine to operate and it has 3 bottles in hand. Calculate the Desired Ending Inventory (DEl) if the number of days in the delivery period is 2 and the safety factor is 10%. Using the Periodic Order Method, calculate the number of bottles that the restaurant should order.
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
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…
6.
What type of warehouse storage system (e.g., static, mobile, mezzanine flooring, wire partitions) you will use for the following product categories- i) Wooden Furniture ii) Chemical container.Describe why?