William Beville's computer training school, in Richmond, stocks workbooks with the following characteristics:Demand DOrdering cost SHolding cost Ha) The EOQ for the workbooks is (round your response to the nearest whole number).b) What are the annual holding costs for the workbooks?Annual Holding Cost = Average Inventory x Annual Holding Cost per Item =c) What are the annual ordering costs?Annual Ordering Cost = Ordering Cost per Order Number of OrdersQH=$= Ordering Cost per Order x (Total Annual Demand/Order Size)D= $ (round your response to the nearest whole number).19,400 units/year$26/order$4/unit/year(round your response to the nearest whole number).

EOQ is calculated based on data and historical demand patterns, promoting data-driven…

Answered: William Beville's computer training…

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

41 Dunstreet's Department Store would like to develop an inventory ordering policy with a 90 percent probability of not stocking out. To illustrate your recommended procedure, use as an example the ordering policy for white percale sheets. Demand for white percale sheets is 3,400 per year. The store Is open 365 days per year. Every two weeks (14 days) inventory is counted and a new order is placed. It takes 12 days for the sheets to be delivered. Standard deviation of demand for the sheets is five per day. There are currently 170 sheets on-hand. How many sheets should you order? Note: Use Excel's NORM.S.INV function to find the z value. Do not round intermediate calculations. Round z value to 2 decimal places and final answer to the nearest whole number.
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 112, 500 units per year, an ordering cost of $3 per order, and carrying costs of $1.20 per unit. a. What is the economic ordering quantity? b. How many orders will be placed during the year? c. What will the average inventory be? d. What is the total cost of ordering and carrying inventory?
Mattress Firm sells water beds and assorted supplies. Their best-selling bed has an annual demand of 395 units. Ordering cost is $43; 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 pharmacist is trying to determine the inventory order and stock levels for a particular drug. The following information is available about the drug. Demand (D) 85 tablets/week Working weeks per year 52 weeks Unit holding cost per year (H) $6 Order cost (S) $44/order Standard deviation of weekly demand (sd) 15 tablets Lead time (L) 2 weeks Desired cycle service level 95% If the pharmacist uses the continuous review (Q) system to control the inventory of the drug, what would be the order quantity and reorder point? If the pharmacist uses the periodic review (P) system to control the inventory of the drug, what would be the review interval and target inventory level? (Hint: Use the EOQ model to derive the review interval P)
Sarah's Muffler Shop has one standard muffler that fits a large variety of cars. Sarah wishes to establish a reorder point system to manage inventory of this standard muffler. Annual demand Standard deviation of daily demand Item cost Annual holding cost 5,700 mufflers 5 mufflers per working day 30 per muffler 30% of the item value Use the above information to determine the best order size and the reorder point. Order Size = 252, R = 47 Order Size = 243, R = 40 Order Size = 300, R = 46 O Order Size = 302, R = 23 Ordering cost Service probability Lead time Working days $ 50 per order 90 % 2 working days 300 per year
Southern Markets, Inc. is considering the use of ABCanalysis to focus on the most critical SKUs in its inventory.Currently, there are approximately 20,000 different SKUswith a total dollar usage of $10,000,000 per year.a. What would you expect to be the number of SKUs and thetotal annual dollar usage for A items, B items, and C itemsat Southern Markets, Inc.? b. The following table provides a random sample of the unitvalues and annual demands of eight SKUs. Categorizethese SKUs as A, B, and C items.
EOQ, reorder point, and safety stock Alexis Company uses 937units of a product per year on a continuous basis. The product has a fixed cost of $44 per order, and its carrying cost is $4 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days' usage in inventory as a safety stock. a. Calculate the EOQ. b. Determine the average level of inventory. (Note: Use a 365-day year to calculate daily usage.) c. Determine the reorder point. d. Indicate which of the following variables change if the firm does not hold the safety stock: (1) order cost, (2) carrying cost, (3) total inventory cost, (4) reorder point, (5) economic order quantity.
Please do not give solution in image format thanku Prince Electronics, a manufacturer of consumer electronic goods, has five distribution centers in different regions of the country. For one of its products, a highspeed modem priced at $360 per unit, the average weekly demand at each distribution center is 85 units. Average shipment size to each distribution center is 450 units, and average lead time for delivery is 2 weeks. Each distribution center carries 2 weeks' supply as safety stock but holds no anticipation inventory. Part 2 a. On average, how many dollars of pipeline inventory will be in transit to each distribution center? $enter your response here. (Enter your response as an integer.)
Fisk Corporation is trying to improve its inventory control system and has installed an online system at its retail stores. Fisk anticipates sales of 58,800 units per year, an ordering cost of $4 per order, and carrying costs of $1.50 per unit. In the second year, Fisk Corporation finds that it can reduce ordering costs to $1 per order, but carrying costs will stay the same at $1.50 per unit. a-1. What is the economic ordering quantity for the second year? Economic ordering quantity (EOQ) a-2. How many orders will be placed during the second year? Number of orders a-3. What will the average inventory be for the second year? Average inventory Total costs units units a-4. What is the total cost of ordering and carrying inventory for second year? LA
Economic Order QuantityA pipe manufacturer requires a chemical for making plastic at the rate of 6000gallons per year. The cost of keeping the chemical storage is $10 per gallon peryear. Ordering costs are $200 per order. The chemical is bought at $45 pergallon.What is the EOQ and the Annual Total Cost?
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?
Andy's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from two different suppliers. The parts are needed throughout the entire 52-week year to assemble Uediracs for sale. Tegdiws are used at a relatively constant rate but the use of Widgets vary with demand. Andy wants to improve his inventory management system and use either a "P" system or a "Q" system. What are the advantages and disadvantages of each system in this application and what information is needed to choose between them?

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