Jordin Henry's machine shop uses 2,500 brackets during the course of a year. These brackets are purchased from asupplier 90 miles away. The following information is known about the brackets:Annual demandHolding cost per bracket per yearOrder cost per orderLead timeWorking days per yeara) What is the EOQ?units (round your response to two decimal places).b)What is the average inventory if the EOQ is used?What would be the annual inventory holding cost? $c)Given the EOQ, how many orders will be made annually? orders (round your response to two decimal places).What would be the annual order cost? $ (round your response to two decimal places).2,500$1.25$19.75f) What is the reorder point (ROP)?2 days250units (round your response to two decimal places).(round your response to two decimal places).d) Given the EOQ, what is the total annual cost of managing (ordering and holding) the inventory? $response to two decimal places).e) What is the time between orders?days (round your response to two decimal places).units (round your response to two decimal places).(round your

Jordin Henry's machine shop uses 2,500 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The following information is known about the brackets: Annual demand Holding cost per bracket per year Order cost per order Lead time Working days per year units (round your response to two decimal places). b)What is the average inventory if the EOQ is used? What would be the annual inventory holding cost? $ c)Given the EOQ, how many orders will be made annually? What would be the annual order cost? $ (round your response to two decimal places). a) What is the EOQ? 2,500 $1.25 $19.75 2 days 250 units (round your response to two decimal places). (round your response to two decimal places). orders (round your response to two decimal places). d)Given the EOQ, what is the total annual cost of managing (ordering and holding) the inventory? $ response to two decimal places). e)What is the time between orders? days (round your response to two decimal places). f) What is the reorder point (ROP)? units (round your response to two decimal places). (round your

Jordin Henry's machine shop uses 2,500 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The following information is known about the brackets: Annual demand Holding cost per bracket per year Order cost per order Lead time Working days per year units (round your response to two decimal places). b)What is the average inventory if the EOQ is used? What would be the annual inventory holding cost? $ c)Given the EOQ, how many orders will be made annually? What would be the annual order cost? $ (round your response to two decimal places). a) What is the EOQ? 2,500 $1.25 $19.75 2 days 250 units (round your response to two decimal places). (round your response to two decimal places). orders (round your response to two decimal places). d)Given the EOQ, what is the total annual cost of managing (ordering and holding) the inventory? $ response to two decimal places). e)What is the time between orders? days (round your response to two decimal places). f) What is the reorder point (ROP)? units (round your response to two decimal places). (round your

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

Wear A Mask (WAM) uses a continuous review system and operates 52 weeks per year with the following characteristics: Demand (d) = 52,505 units/week Ordering cost (S) = $55.00/order Holding cost (H) = $2.50/unit/year ■ Lead time (L) = 3 week(s) Cycle-service level = 90%, z = 1.28 ▪ Demand is normally distributed, with a standard deviation of weekly demand of 103 units. ■ ▪ Current on-hand inventory is 1,040 units, with no scheduled receipts and no backorders. What is the optimal order quantity? (Enter your response rounded to nearest whole number.)
Joe Henry's machine shop uses 2,450 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The following information is known about the brackets: Annual demand 2,450 Holding cost per bracket per year $1.65 Order cost per order $18.50 Lead time 2 days Working days per year 250 a) What is the EOQ? __units (round your response to two decimal places). b) What is the average inventory if the EOQ is used?__ units (round your response to two decimal places). What would be the annual inventory holding cost? $__ (round your response to two decimal places). c) Given the EOQ, how many orders will be made annually?__orders (round your response to two decimal places). What would be the annual order cost? $__ (round your response to two decimal places). d) Given the EOQ, what is the total annual cost of managing (ordering and holding) the inventory? __ $ (round your response to two decimal places). d)…
K William Beville's computer training school, in Richmond, stocks workbooks with the following characteristics: Demand D 19,400 units/year Ordering cost S $27/order Holding cost H $5/unit/year a) The EOQ for the workbooks is 458 (round your response to the nearest whole number) b) What are the annual holding costs for the workbooks? $ (round your response to the nearest whole number).
Joe Henry's machine shop uses 2,460 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The following information is known about the brackets: Annual demand 2,460 Holding cost per bracket per year $ 1.65 Order cost per order $20.00 Lead time 22 days Working days per year 250 a) What is the EOQ? b) What is the average inventory if the EOQ is used? What would be the annual inventory holding cost? c) Given the EOQ, how many orders would be made each year? What would be the annual order cost? d) Given the EOQ, what is the total annual cost of managing (ordering and holding) the inventory? e) What is the time between orders? f) What is the reorder point (ROP)?
Joe Henry's machine shop uses 2,530 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The following information is known about the brackets: Annual demand 2,530 Holding cost per bracket per year $1.65 Order cost per order $18.25 Lead time 2 days Working days per year 250 Part 2 a) What is the EOQ? enter your response here units (round your response to two decimal places). Part 3 b) What is the average inventory if the EOQ is used? enter your response here units (round your response to two decimal places). What would be the annual inventory holding cost? $enter your response here (round your response to two decimal places). Part 4 c) Given the EOQ, how many orders will be made annually? enter your response here orders (round your response to two decimal places). What would be the annual order cost? $enter your response here (round…
Can someone please help me with the folowing problems on excel with the formulas. Thank you
Assuming Normal Distribution, what would the optimal (s,Q) policy be for the given parameters below? Given data: Demand daily has mu = 1768, sigma = 5.37, with a unit purchased cost is $15 (annual interest rate is 20%). The order cost is $50 with a back ordering cost of $25. The order lead time is 3 days.
Joe Henry's machine shop uses 2,500 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The fo llowing information is known about the brackets: a) Given the information, what would be the economic order quantity (EOQ)?b) Given the EOQ, what would be the average inventory? What would be the annual inventory holding cost?c) Given the EOQ, how many orders would be made each year? What would be the annual order cost?d) Given the EOQ, what is the total annual cost of managing the inventory?e) What is the time between orders?f) What is the reorder point (ROP)?
Abey Kuruvilla, of Parkside Plumbing, uses 1,250 of a certain spare part that costs $26 for each order, with an annual holding cost of $27. a) Calculate the total cost for order sizes of 25, 40, 50, 60, and 100 (round your responses to two decimal places). b) What is the economic order quantity? units (round your response to two decimal places).
Annual demand (D) is 49,000 units. Ordering Cost (S) is $1,000 per order. Holding cost (H) is $2 per unit per year. Find economic order quantity (Q*). 7,000 units 49,000,000 units 4,950 units 3,500 units 4,083 units
William Beville's computer training school, in Richmond, stocks workbooks with the following characteristics: a) The EOQ for the workbooks is (round your response to the nearest whole number). b) What are the annual holding costs for the workbooks? $ (round your response to the nearest whole number). c) What are the annual ordering costs? $ (round your response to the nearest whole number). Demand D Ordering cost S Holding cost H 19,300 units/year $24/order $4/unit/year