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) 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)

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...
icon
Related questions
icon
Concept explainers
Topic Video
Question

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

 

 

  1. a) What is the EOQ? __units (round your response to two decimal places).

 

  1. 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).

 

  1. 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).

 

  1. d) Given the EOQ, what is the total annual cost of managing (ordering and holding) the inventory? __ $ (round your response to two decimal places).

 

  1. d) What is the time between orders? __ days (round your response to two decimal places)

 

  1. f) What is the reorder point (ROP)? __ units (round your response to two decimal places)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 9 steps

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.