Answered: William Beville's computer training… | bartleby

Practical Management Science

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

Related questions

Question

**William Beville’s Computer Training School Inventory Analysis**

William Beville’s computer training school, located in Richmond, manages its workbook inventory with the following characteristics:

- **Demand (D):** 19,400 units/year
- **Ordering Cost (S):** $27/order
- **Holding Cost (H):** $5/unit/year

**Questions:**

a) The Economic Order Quantity (EOQ) for the workbooks is **458** units. (Response rounded to the nearest whole number)

b) What are the annual holding costs for the workbooks? $[Response needed] (Round your response to the nearest whole number)

This setup provides an insight into the inventory management process by calculating EOQ, which helps optimize ordering and holding costs by determining the most efficient quantity to order at a time.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Blurred answer

Similar questions

Ottis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The cost of placing an order is $30. The cost of holding one unit of inventory for one year is $15.00. Currently, Ottis places 160 orders of 4,000 plastic housing units per year. Compute the economic order quantity. Economic order quantity = 1600 Compute the ordering, carrying, and total costs for the EOQ. How much money does using the EOQ policy save the company over the policy of purchasing 4,000 plastic housing units per order?
The electrolyte drink for our beloved NMSU soccer team average normally distributed demand of 5 units and a standard deviation of 1 unit. Lead time for replenishment is fixed at four days. (a) What is the reorder point if there is no safety stock? (b) What is the reorder point if the service level is 80 percent? (c) How much more safety stock is required if the service level is raised from 80 percent to 90 percent?
Using relevant eoq calculations Which order size would you recommend that the hospital use?
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)…
← 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? $ 1145 (round your response to the nearest whole number). c) What are the annual ordering costs? $ (round your response to the nearest whole number).
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 6,000 units a year. The purchasing cost of each unit is $16 (additional 5% discount applies if at lease 150 units ordered a time), and the inventory carrying cost is $3 per unit per year. The average ordering cost is $10 per order. It takes about 3 working days for an order to arrive. (This is a corporate operation, and there are 300 working days per year.) Answer the following questions, Q1~Q5. Note that you must include Excel formulas/calculations showing how you arrive at the answer. Q1: Assume that the demand is consistent throughout the year. What is the ROP? Note that stockouts and unnecessary inventory holding should be avoided at any times. Q2: Assume that the demand is consistent throughout the year. Based on the EOQ model, to minimize the costs of purchasing, ordering and inventory holding…
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?
Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices. The yearly demand for these connectors is 15,200 units. Southeastern estimates its annual holding cost for this item to be 323 per unit. The cost to place and process an order from the supplier is $73. The company operates 300 days per year, and the lead time to receive an order from the supplier is 2 working days. a) What is the economic order quantity? units (round your response to the nearest whole number). b) What are the annual holding costs? $ (round your response to the nearest whole number) c) What are the annual ordering costs? S (round your response to the nearest whole number). d) What is the reorder point? units (round your response to the nearest whole number).
Matthew Liotine's Dream Store sells water beds and assorted supplies. His best-selling bed has an annual demand of 405 units. Ordering cost is $38; holding cost is $5 per unit per year. a) To minimize the total cost, how many units should be ordered each time an order is placed? EOQ = units (round your response to the nearest whole number). b) If the holding cost per unit was $6.00 instead of $5, what would the optimal order quantity be? New EOQ = units (round your response to the nearest whole number). A
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
Yellow Press, Inc., buys paper in 1,500-pound rolls for printing. Annual demand is 3,000 rolls. The cost per roll is $1,000, and the annual holding cost is 28 percent of the cost. Each order costs $75. Part 2 a. How many rolls should Yellow Press order at a time? Yellow Press should order enter your response here rolls at a time. (Enter your response rounded to the nearest whole number.) Part 3 b. What is the time between orders? (Assume 200 workdays per year.) The time between orders is enter your response here days. (Enter your response rounded to one decimal place.)
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

SEE MORE 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

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.

SEE MORE TEXTBOOKS