Thomas Kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation. Thomas's fastest-moving inventory item has a demand of 5,900 units per year. The cost of each unit is $101, and the inventory carrying cost is $11 per unit per year. The average ordering cost is $31 per order. It takes about 5 days for an order to arrive, and the demand for 1 week is 118 units. (This is a corporate operation, and there are 250 working days per year).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).c) What is the optimal number of orders per year? [ ] orders (round your response to two decimal places).d) What is the optimal number of days in between any two orders? [ ] days (round your response to two decimal places).e) What is the annual cost of ordering and holding inventory? $[ ] per year (round your response to two decimal places).f) What is the total annual inventory cost, including the cost of the 5,900 units? $[ ] per year (round your response to two decimal places).

As per Bartleby guidelines, we can only solve the first three subparts of one question at a…

Answered: a) What is the EOQ? units (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

a) The average monthly demand requirement = ____units (round to nearest whole number.) B) The total stockout cost = $____(nearest whole number) C) The total inventory carrying cost = $____(nearest whole number) D) The total cost, excluding normal time labor costs, is = $_____(nearest whole number)
L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the ← table below: How would the plant classify these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places) Item Code Avg. Inventory (units) 1289 2347 2349 2363 2394 2395 L. Houts Plastics Charlotte Inventory Levels Value Dollar Volume (S/unit) 3.50 6782 7844 8210 8310 9111 360 300 120 65 60 25 222216 20 10 7 4.00 2.50 1.80 1.75 2.25 1.15 2.05 1.60 2.00 3.00 1,200 300 105 23 25 14 18 3,134 % of Dollar Volume 38.29 9.57 3.35 0.73 0.78 0.45 0.57
Dave’s local college football team is playing for the national championship in next month’s bowl game, and he’s thinking about having “We’re number one” T-shirts imprinted in honor of the team. It’s too late to get the shirts before game day, but if he orders today, he can get them within a few days after the game. The shirts must be ordered in multiples of 1000, and Dave has estimated the amount of profit he will make for possible outcomes of the game. Given the following payoff table, what will Dave do if he uses the maximin criterion? The maximax criterion? The minimax regret criterion? Order no shirts $0 wins $0 loses $0 ties Order 1000 shirts $800 wins $-200 loses $200 ties Order 2000 shirts $1600 wins $-400 loses $300 ties
Need in Detail (No AI)
If D = 8,500 per month, S = $42 per order, and H= $2.50 per unit per month, a) What is the economic order quantity? The EOQ is b) How does your answer change if the holding cost doubles? The EOQ is units (round your response to the nearest whole number). The EOQ is units (round your response to the nearest whole number). c) What if the holding cost drops in half? units (round your response to the nearest whole number).
Abey Kuruvilla, of Parkside Plumbing, uses 1,230 of a certain spare part that costs $24 for each order, with an annual holding cost of $25. Part 2 a) Calculate the total cost for order sizes of 25, 40, 50, 60, and 100 (round your responses to two decimal places). Order Size Total Cost ($) 25 enter your response here 40 enter your response here 50 enter your response here 60 enter your response here 100 enter your response here b) What is the economic order quantity? units (round your response to two decimal places).
Please do not give solution in image format thanku
If annual sales in are 65,000 units, price per unit is $25, carrying costs are 30%, and fixed costs per order is $100, then EOQ is 1,316.56. True or False?
The fixed quantity version of EOQ compares and contrasts with the fixed interval version. Where will each of the scenarios be used?
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)?
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
20 Lead time for one of your fastest-moving products is a) What would be an appropriate reorder point? 100 days. Demand during this period averages units per day. units (enter your response as a whole number). b) How does your answer change if demand during lead time doubles? c) How does your answer change if demand during lead time drops in half? units (enter your response as a whole number). units (enter your response as a whole number).

SEE MORE QUESTIONS

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

a) What is the EOQ? units (round your response to two decimal places). b) What is the average inventory if the EOQ is used? c) What is the optimal number of orders per year? units (round your response to two decimal places). orders (round your response to two decimal places).