EBK OM
6th Edition
ISBN: 9781305888210
Author: Collier
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 11, Problem 3PA
Summary Introduction
Interpretation:
Performance of the ABC analysis and explanation with respect to decisions and ideas.
Concept Introduction:
ABC analysis is nothing but the inventory categorization in which the inventory is divided into three categories A, B, and C in descending order. Category A contains the highest value, category B contains the values lower than the category a but the higher the category C, and category C contain the lowest values.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017.
(in millions)
2015
2016
2017
Beginning inventory
$ 2,100
$ 2,400
$ 2,300
Ending inventory
2,400
2,300
2,700
Cost of goods sold
18,227
20,071
20,478
Sales revenue
39,145
42,957
44,066
Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.)
2015
2016
2017
Days in inventory
days
We have seen the importance of demand forecasting affecting supply chain decisions in many ways. How does the reliability of demand forecasting affect a model to place warehouses for customers? Knowing that there is no specific answer that is always appropriate, how good (measured in percent close) do forecasts have to be in order to be used for network modeling?
Determine an A-B-C classification for these items:
Which items are A, B, and C - explain how you derive the answers? Use a table or excel spreadsheet to illustrate your work.
Item Unit Cost Annual Volume (000)1 300 252 90 303 30 604 50 105 15 706 100 407 10 60
Hint:Determine the Annual Dollar Value (Unit Cost * Annual Volume) for each item and the sum of the individual Annual Dollar Values. Arrange the items in descending order based on Annual Dollar Values. Then, determine the percentage of items and the percentage of…
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Disucss the concept of Monte Carlo Analysisarrow_forwardYour firm uses a periodic review system for all SKUS classified, using ABC analysis, as B or C items. Further, it uses a continuous review system for all SKUS classified as A items. The demand for a specific SKU, currently classified as an A item, has been dropping. You have been asked to evaluate the impact of moving the item from continuous review to periodic review. Assume your firm operates 52 weeks per year; the item's current characteristics are: Demand (D) = 15,080 units/year Ordering cost (S) = $125.00/order Holding cost (H) = $3.00/unit/year Lead time (L) = 5 weeks Cycle service level = 95 percent Demand is normally distributed, with a standard deviation of weekly demand of 64 units. -Calculate the item's EOQ. - Use the EOQ to define the parameters of an appropriate continuous review and periodie review system for this item. -Which system requires more safety stock and by how much? -How do you think each system can affect your procurement procedures/methods?arrow_forwardAnswer bold italicized questions Using excel. The Metropolitan Bus Company (MBC) purchases diesel fuel from AmericanPetroleum Supply. In addition to the fuel cost, American PetroleumSupply charges MBC $250 per order to cover the expenses of deliveringand transferring the fuel to MBC’s storage tanks. The lead time for anew shipment from American Petroleum is 10 days; the cost of holding agallon of fuel in the storage tanks is $0.04 per month, or $0.48 peryear; and annual fuel usage is 150,000 gallons. MBC buses operate 300days a year.a.What is the optimal order quantity for MBC?b.Howfrequently should MBC order to replenish the gasoline supply?c.TheMBC storage tanks have a capacity of 15,000 gallons. ShouldMBC consider expanding the capacity of its storage tanks?d.What isthe reorder point?arrow_forward
- Your firm uses a periodic review system for all SKUS classified, using ABC analysis, as B or C items. Further, it uses a continuous review system for all SKUS classified as A items. The demand for a specific SKU, currently classified as an A item, has been dropping. You have been asked to evaluate the impact of moving the item from continuous review to periodic review. Assume your firm operates 52 weeks per year; the item's current characteristics are: Demand (D) = 15,080 units/year Ordering cost (S) = $125.00/order Holding cost (H) = $3.00/unit/year Lead time (L) = 5 weeks Cycle service level = 95 percent Demand is normally distributed, with a standard deviation of weekly demand of 64 units. 1- How do you think each system can affect your procurement procedures/methods?arrow_forwardInventory Management You are the store manager at a local branch of DigiLife, a large electronics retail chain. A new version of a popular consumer electronics device called the Amulet is coming out this year. It is your job to sell as many Amulets as you can while minimizing your costs in order to maximize your store's profits. Your Goal Earn $1,000,000 in net profits of Amulet sales.arrow_forwardUse the table below to answer the following question(s). In the spreadsheet below, there is data on the price, cost, demand, and quantity produced for an item. There are also different "what if" values that can help a manager to calculate costs and revenue with variability in demand. Profit Model 12 What-If Demand Values 3 Data 20,000 40,000 |55,000 60,000 65,000 4 Unit Price ($) Unit Cost ($) Fixed Cost ($) Demand Quantity Produced 50 25 550,000 60,000 |55,000 7 10 Which of the following is the Excel formula to determine the number of units sold? =B8 =MIN(0,B8,B9) =MAX(0,B8,B9) =MIN(B8,B9)arrow_forward
- Green Gardens' owner has asked your advice about a possible problem at his business. Over the last 6 months the large-sized lawn and garden inventory (ie, tables, chairs, planters, etc.) has appeared to be short. The inventory records that employees use to determine what is on hand show that more inventory is available than can actually be located. This has cause frustration and mis-trust in the inventory records for the sales employees. The owner realizes that the problem is bigger than just frustrated employees. He is afraid that inventory is being stolen, a problem he didn't think possible given that these are large items that are not easily moved. Requirements: Provide the owner with two internal controls that he could implement to reduce the likelihood of theft of the lawn and garden inventory.arrow_forwardInformatics Corporation summarizes international information reports (on a weekly basis), prints sophisticated data and forecasts, which are purchased weekly by mutual funds, banks and insurance companies. This information is very expensive and the demand for the reports is limited to a maximum of 30 units. The possible demands are 0, 10, 20 and 30 reports per week. The profit per report sold is Rs. 30 and the loss per report unsold is Rs. 20. No production of extra reports during a week is possible. Further, there is a penalty cost of Rs. 25 per unit for not meeting the demand. Unsold reports cannot be carried on to the next week. Construct a pay-off table, & find out the number of reports to be produced if: Maximin or pessimistic strategy is used Maximax or optimistic strategy is used Laplace strategy is used Minimax Regret Strategy is usedarrow_forwardYour firm uses a periodic review system for all SKUs classified, using ABC analysis, as B or C items. Further, it uses a continuous review system for all SKUs classified as A items. The demand for a specific SKU, currently classified as an A item, has been dropping. You have been asked to evaluate the impact of moving the item from continuous review to periodic review. Assume your firm operates 52 weeks per year; the item’s current characteristics are:Demand 1D2 = 15,080 units/yearOrdering cost 1S2 = $125.00/orderHolding cost 1H2 = $3.00/unit/yearLead time 1L2 = 5 weeksCycle@service level = 95 percentDemand is normally distributed, with a standard deviation of weekly demand of 64 units.a. Calculate the item’s EOQ.b. Use the EOQ to define the parameters of an appropriate continuous review and periodic review system for this item.c. Which system requires more safety stock and by how much?arrow_forward
- As a logistics specialist, you are responsible for meeting customer demand. One of your customers places orders for you to supply four products by the end of October. You have limited capacity for raw material and other facilities. You are required to satisfy customer demand by manufacturing the products and/or buying from a supplier. After consulting with the production department, you obtained the following information. Product A Product B Product C Product D Order quantity 2000 3500 1500 2500 Hours required on machine X per unit 2 4 5 3 Hours required on machine Y per unit 4 3 6 2 Raw material in kilos 5 1 4 6 Time needed for Packaging per unit 36 minutes 30 minutes 45 minutes 24 minutes Available monthly hours per month: 8,000 on machine X, 6000 on machine Y, and 3,000 hours for packaging. Purchased items from your supplier are already packaged. Available raw material per month: 5,000 kilos…arrow_forwardRainbow Inc's products are given below. If the company's total labor capacity is 3200 hours/week, which of the products should be produced in a week? Regarding with this plan what will be the total sales and total variable costs of the firm per week? Total Labor Hour Demand Product / Unit Price / Unit vC / Unit (unit) XC610 2,500 1,000 300 XD740 4 3,100 1,500 250 ZS650 3 1,850 750 400 ST340 2 2,250 975 500arrow_forwardHazardous Household Product Inventory Complete the information in the dummy table provided below. List at least 10 products. Make sure to specify all the data entries in the column headings. Product Directions for use Storage Location in Home 1. 2. 3. 4. 5. 6. 7. 8. 9. 10.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Operations Management
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
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.
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY