In the past, Taylor Industries has used a fixed-time period inventory system that involved taking a complete inventory count of all itemseach month. However, increasing labor costs are forcing Taylor Industries to examine alternative ways to reduce the amount of laborinvolved in inventory stockrooms, yet without increasing other costs, such as shortage costs. Here is a random sample of 20 of Taylor'sitems.ITEMNUMBERANNUALUSAGEANNUALITEMUSAGENUMBER1$1,70011$ 13,400212,3001280032,4001342,700450,9001410,200513,100151,40069001610,50072,200174,200811,3001862,00095,300193,7001015,400203,100a. Classify each item in inventory using an ABC plan.

Let's delve deeper into the process of classifying inventory items using an ABC analysis.**1.…

Answered: In the past, Taylor Industries has used…

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

Sam's Pet Hotel operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $13.00 per bag. The following information is available about these bags: ≻Demand=75 bags/week ≻Order cost=$55.00/order ≻Annual holding cost=25 percent of cost ≻Desired cycle-service level=80 percent ≻Lead time=4 weeks (24 working days) ≻Standard deviation of weekly demand=15 bags ≻Current on-hand inventory is 320 bags, with no open orders or backorders. Part 2 a. Suppose that the weekly demand forecast of 75 bags is incorrect and actual demand averages only 50 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error? The costs will be $enter your response here higher owing to the error in EOQ. (Enter your response rounded to two decimal places.) a. What is the EOQ? What would the average time between orders (in weeks)? b. What should R be? c. An inventory withdraw…
Investigate the historical evolution of inventory management strategies, with a focus on the contributions of R. H. Wilson.
52 Demand for an item is 3,800 units per year. Each order placed costs $15; the annual cost to carry items in inventory is $10 each. In what quantities should the item be ordered? Note: Round your answer to the nearest whole number.
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.
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
Jean-Ma rie Bourjolly's restau rant has the followinginventory items that it orders on a weekly basis: a) Which is the most expensive item, using annual dollar volume?b) Which are C items?c) What is the annual dollar volume for all 20 items?
Use ABC analysis to determine the items deserving mostattention and tightest inventory control
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?
Alpha Products, Inc., is having a problem trying to control inventory. There is insufficient time to devote to all its items equally. The following is a sample of some items stocked, along with the annual usage of each item expressed in dollar volume. ITEM ANNUAL DOLLAR USAGE ITEM ANNUAL DOLLAR USAGE a S 30, 100 k S 1,700 b 27,000 120,000 c 93,000 m 111,000 d 1,400 n 3,000 e 1,800 o 500 f 30,000 p 114, 000 g 1,600 q 2,600 h 2,500 г 28,000 i 3, 200 s 2, 800 j 1,500 t 3, 100 a. Suggest a system for allocating control time? multiple choice ABC analysis Cycle counting b. Specify where each item from the list would be placed.
Discuss how inventory expenses must be balanced and kept to q minimum through inventory control
A manufacturer buys cardboard boxes from a supplier. The annual demand is 40,000 boxes and is uniformly distributed. The boxes cost $5 each. The estimated order cost is $10, and the carrying cost rate is 20% per year. What is the EOQ and what is the annual order and carrying cost? How many times a year are orders placed, and what is the average time, in weeks, between orders? Using the answer from (b), if you round the average time between orders to the nearest week, what should the order quantity be? Would you recommend using this order quantity and time interval? Suppose that the actual demand turns out to be 80,000 boxes instead of 40,000 boxes.If you had used the EOQ from the (a), what would be the annual order and carrying cost be?
David's Delicatessen flies in Hebrew National salamis regularly to satisfy a growing demand for the salamis in Silicon Valley. The owner, David Gold, estimates that the demand for the salamis is pretty steady at 175 per month. The salamis cost Gold $1.85 each. The fixed cost of calling his brother in New York and having the salamis flown in is $200. It takes three weeks to receive an order. Gold's accountant, Irving Wu, recommendsan annual cost of capital of 22 percent, a cost of shelf space of 3 percent of the value of the item, and a cost of 2 percent of the value for taxes and insurance. How many salamis should Gold have on hand when he phones his brother to send another shipment?

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