Boreki Enterprise has the following 10 items in inventory. Theodore Boreki asks you, a recent OM graduate, to divide these items into ABC classifications. Fill in the blanks and then answer the following questions. (Round dollar volume to the nearest whole number andpercentage of dollar volume to two decimal places.)ItemA2B8C7D1E9F3G2H215J8Item F3 should be classified asAnnual Demand Cost/Unit50030040001215004535202501500206552010003420060010002500Dollar % of Total DollarVolumeVolume48,00067,50020,000300,00012,00012,500For the following two questions consider only items A2 and F3 for relative classification (these are some of the items for which you computed the metrics).Based on the percentages of dollar volume, item A2 should be classified as7.029.872.9243.851.751,83

Inventory management is the aspect of production management of an organization including storing,…

Boreki Enterprise has the following 10 items in inventory. Theodore Boreki asks you, a recent OM graduate, to divide these items into ABC classifications. Fill in the blanks and then answer the following questions. (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places) Item A2 B8 C7 Dollar Volume D1 E9 F3 Annual Demand Cost/Unit 500 300 4000 12 45 1500 20 1000 20,000 34 35 20 250 1500 20 65 ☐ G2 200 300,000 12,000 H2 600 15 1000 F J8 2500 5 12,500 For the following two questions consider only items A2 and F3 for relative classification (these are some of the items for which you computed the metrics). Based on the percentages of dollar volume, item A2 should be classified as Item F3 should be classified as 48,000 67,500 n O % of Total Dollar Volume 7.02 9.87 2.92 43.85 1.75 1.83

Boreki Enterprise has the following 10 items in inventory. Theodore Boreki asks you, a recent OM graduate, to divide these items into ABC classifications. Fill in the blanks and then answer the following questions. (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places) Item A2 B8 C7 Dollar Volume D1 E9 F3 Annual Demand Cost/Unit 500 300 4000 12 45 1500 20 1000 20,000 34 35 20 250 1500 20 65 ☐ G2 200 300,000 12,000 H2 600 15 1000 F J8 2500 5 12,500 For the following two questions consider only items A2 and F3 for relative classification (these are some of the items for which you computed the metrics). Based on the percentages of dollar volume, item A2 should be classified as Item F3 should be classified as 48,000 67,500 n O % of Total Dollar Volume 7.02 9.87 2.92 43.85 1.75 1.83

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

It is your responsibility, as the new head of the automotive section of Nichols Department Store, to ensure that reorder quantities for the various items have been correctly established. You decide to test one item and choose Michelin tires, XW size 185 × 14 BSW. A perpetual inventory system has been used, so you examine this as well as other records and come up with the following data: Cost per tire $35 each Holding cost 20 percent of tire cost per year Demand 1,000 per year Ordering cost $20 per order Standard deviation of daily demand 3 tires Delivery lead time 4 days Because customers generally do not wait for tires but go elsewhere, you decide on a service probability of 98 percent. Assume the demand occurs 365 days per year. Determine the order quantity. Note: Round your answer to the nearest whole number. Determine the reorder point. Note: Use Excel's NORM.S.INV() function to find the z value. Round z value to 2 decimal places and final answer to the…
10 Use the information presented in the graph to answer the following questions: Annual Cost C3 C2 Q1 You are also given the following information: Q1 =450 .Q2 = 700 C1 = 350 C2 = 750 1300 Q2 Order Quantity Which annual inventory cost component does the blue line represent? Total cost Which annual inventory cost component does the green line represent? Holding cost What is the Economic Order Quantity (EQ9) based on th Which annual inventory cost component does the red line represent? Ordering cost 220
DAT, Inc. produces digital audiotapes to be used in the consumer audio division. DAT lacks sufficient personnel in its inventory supply section to closely control each item stocked, so it has asked you to determine an ABC classification. Here is a sample from the inventory records: ITEM AVERAGEMONTHLY DEMAND PRICE PER UNIT 1 700 $ 6.00 2 200 4.00 3 2,000 12.00 4 1,100 20.00 5 4,000 21.00 6 100 10.00 7 3,000 2.00 8 2,500 1.00 9 500 10.00 10 1,000 2.00 Develop an ABC classification for these 10 items. Item Monthly Usage ($) Class 1 2 3 4 5 6 7 8 9 10
Do you think the safety stock (safety inventory) could be negative? What is the meaning of a negative safety inventory (hint: safety stock is the difference between the optimal inventory and the average demand)?
The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items as a health care facility. Develop an A-B-C classification of these items. Step 1: find annual dollar value, Step 2: arrange in importance (A,B,C), find percent of items and percent of dollar value Item Unit Cost Usage K34 $10 200 K35 25 600 K36 36 150 M10 16 25 M20 20 80 Z45 80 200 F14 20 300 F95 30 800 F99 20 60 D45 10 550 D48 12 90 D52 15 110 D57 40 120 N08 30 40 P05 16 500 P09 10 30
Your company has the following items in inventory: Unit Cost $9 $90 $6 Item A B с D E F G H Annual Demand 1200 100 4500 400 35 250 1000 100 $150 $2000 $120 $90 $75 a) What is the annual dollar volume for all items b) Perform an ABC analysis on the data. Which are the A items, the B items and the C item: c) Why is it desirable to classify items into groups, as the ABC classification scheme does? d) Define and discuss the term "productivity" with help of productivity equation.
(a) Ignoring taxation, calculate the optimum order level of inventory over a one-year planning period using the EOQ model. (b) Estimate the level of safety inventory that should be carried by Toyzrfun Ltd. (c) If Toyzrfun Ltd were to be offered a quantity discount by its suppliers of 1% for orders of 30 000 units or more, evaluate whether it would be beneficial for the company to take advantage of the quantity discount. Assume for this calculation that no safety inventory is carried. (d) Estimate the expected total annual costs of inventory management if the EOQ had been (i) 50% higher, and (ii) 50% lower than its actual level. Comment upon the sensitivity of total annual costs to changes in the EOQ.
Question 1 For supply item ABC, Andrews Company has been ordering 400 units per week. A new purchasing agent has been hired by the company who wants to start using the economic-order- quantity method and its supporting decision elements. She has gathered the following information: Annual demand in units Lead time, in days Ordering costs Insurance and handling costs Purchase price per unit Return on cash investment 20,800 5 $22 $7 $15 15% Required
Discuss what is meant by ABC analysis of inventory.Name several measures that can determine ABCstatus
MAY I ASK FOR THE SOLUTIONS AND ANSWERS OF NOS. 12 to 17 (kindly refer to the table) Thank you! ABC Corporation resells one type of candle. It has 250 working days. Each day, it sells an average of 500 boxes but may sometimes sell a maximum of 600 boxes. The supplier takes an average of 5 days to deliver the order. During busier times, the supplier may take 7 days. Based on ABC’s records, ordering cost average P400 per order. Storage cost per box average P5 per year. There is also an opportunity cost of 1% per year for every peso invested in inventories. Each box of candles costs P450. If ABC would continue its current inventory management policy, it would keep 10,000 boxes as safety stock and order tendays-worth of inventory. (A) Reorder Point 1. What should be the reorder point in boxes? 2. How much would the normal lead time usage be? 3. How much should ABC keep as safety stock? (B) Economic Order Quantity 4. What is the annual demand for the boxes of candles? 5. How much is the…
We have demand for a product with 1500 units/ month. The vendor offers. quantity discounted method for purchasing as the table below: Order Quantity condition Price (USD) 1+299 10 >300 7 Ordering lead-time is 3 days. Ordering cost 10 $/ order, salary for ordering staff is 3S/ order. Monthly Warehouse renting free is 5%, and interest rate is 7%. Salary for warehousing staff is 300$/month. Please suggest the best ordering policy. I
Boreki Enterprise has the following 10 items in inventory. Theodore Boreki asks you, a recent OM graduate, to divide these items into ABC classifications. Fill in the blanks and then answer the following questions. (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) % of Total Dollar Dollar Volume Item Annual Demand Cost/Unit Volume A2 250 20 48,000 67,500 5.56 7.81 B8 4000 12 C7 1500 45 D1 150 2000 E9 1000 20 20,000 2.31 F3 60 150 300,000 12,000 G2 200 1500 34.72 H2 600 20 1.39 15 300 300 J8 2500 12,500 1.45