The NextGen distribution is working on improving inventory management by performing an ABC Analysis. The management team considers the following factors for the analysis: hits and criticality to operations. The criticality to operations has been calculated using the Analytical Hierarchy Process (AHP) by an outside consultant, Given the initial ABC categories combine these two categories to come up with the final classification. Assume A item is 5, B is 4, and C is 1 point. And criticality is three times as important as hits. Finally, top 70% is a next 25 %B and the rest are C items. (Use three decimal place accuracy for ratio and cumulative ratio calculations when needed, e.g., 0.123) a. Perform the final ABC Analysis by combining hits and criticality. Item 1 2 3 4 5 6 7 8 9 10 Hits A C B A C C C B B A Criticality B B C B A B A A

The NextGen distribution is working on improving inventory management by performing an ABC Analysis. The management team considers the following factors for the analysis: hits and criticality to operations. The criticality to operations has been calculated using the Analytical Hierarchy Process (AHP) by an outside consultant, Given the initial ABC categories combine these two categories to come up with the final classification. Assume A item is 5, B is 4, and C is 1 point. And criticality is three times as important as hits. Finally, top 70% is a next 25 %B and the rest are C items. (Use three decimal place accuracy for ratio and cumulative ratio calculations when needed, e.g., 0.123) a. Perform the final ABC Analysis by combining hits and criticality. Item 1 2 3 4 5 6 7 8 9 10 Hits A C B A C C C B B A Criticality B B C B A B A A

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

. MBPF Inc. manufactures prefabricated garages. The manufacturing facility purchases sheet metal that is formed and assembled into finished products—garages. Each garage needs a roof and a base, and both components are punched out of separate metal sheets prior to assembly. Production and demand data for the past eight weeks are shown in Table below. Observe that both production and demand vary from week to week. Now, track the inventory at the end of each week, measured in number of finished garages. Also, construct the inventory build-up diagram. MBPF Inc. manufactures prefabricated garages. The manufacturing facility purchases sheet metal that is formed and assembled into finished products—garages. Each garage needs a roof and a base, and both components are punched out of separate metal sheets prior to assembly. Production and demand data for the past eight weeks are shown in Table below. Observe that both production and demand vary from week to week. Now, track the inventory at…
QUESITON 26 Calculate the percentage of assets committed to inventory, where Panda lnc has $44,000,000 in total assets and 11,400,000 of inventory. QUESITON 27 Supply chain management is ... A.a set of procedures connecting suppliers to customers B.Design, operation and improvement of productive systems C.A sequence of activities across organizations that are involved in producing and delivering a product or service D.a series of activities from suppliers to customers that add value to a product or service QUESITON 28 SCOR stands for A.Supply Chain Operations Reference model B.Supply Chain Operations Resilience C.Supply Chain Organsational Resources D.
a) Designate an identity to the warehouse system above and explain why you have chosen this identity. b) Select and explain the stages where the following evaluations would take place. Economic Order Quantity, Balancing Inventory levels, Cost effectiveness.
A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a servicelevel of .98. The order interval is 14 days, and lead time is 2 days. Average demand for one itemis 40 units per day, and the standard deviation of demand is 3 units per day. Given the on-handinventory at the reorder time for each order cycle shown in the following table, determine theorder quantities for cycles 1, 2, and 3.Cycle On Hand1 422 83 103
Lot sizing A producer with one product faces the following forecasted demand for the next 10 weeks: week 1. 2. 3. 4. 5. 6. 7. 8. 9. 10 Requirement 30 12 72 11 24 42 35 30 75 68 Assume furthermore that the producer faces a Set-up cost (K) equal to 132 each time production takes place and storage costs (h) of 0.6 per unit per week. a) Find the cost of the two extreme strategies Lot - for - lot (produce exactly what is needed in each period) and Produce - once (produce everything needed in the first period).
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,500 May 2,300 February 1,700 June 2,100 March 1,700 July 1,900 April 1,700 August 1,500 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $125 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. The average monthly demand requirement=18001800 units. (Enter your response as a whole number.) In order to arrive at the costs, first compute the ending inventory and stockout units for each month by filling in…
Pol Industries uses a job order cost system and applies manufacturing overhead costs to jobs using a predetermined overhead rate based on direct labour-hours. The following data were extracted from the company's accounting records for Year 6 Estimated Actual Manufacturing overhead costs 50,000 54,000 direct labour-hours 20,000 hours 24,000 hoursJob #461 was completed during the year and the following costs had been incurred on that job:direct materials 4000 direct labour 1500(at $5.00 per direct labour hour) Suppose Job #461 contained 100 units. What unit cost would appear on the job cost sheet for job #461? Show ALL calculations.
I need assistance to solve the following problem in Operations Analysis. 2) A coffee store is experiencing sales of 280 pounds of coffee beans per year. The supplier charges the store $2.40 per pound, and the paperwork and labor costs incurred by the store in placing an order total $45 per order. Holding costs are based on 20% interest rate per annum. a) What is the optimal order size (write down the model name, its parameters and formula)? b) What is the time between order placements (include the formula)? c) What is the average annual holding cost (include the formula)? d) If the lead time is 3 weeks, what is the reorder level based on inventory on hand (include the formula)?
Gunes Corporation uses the weighted-average method in its process costing system. This month, the beginning inventory in the first processing department consisted of 800 units. The costs and percentage completion of these units in beginning inventory were: Cost PercentCompleteMaterials costs $ 10,600 65% Conversion costs $ 12,800 30% A total of 8,500 units were started and 7,400 units were transferred to the second processing department during the month. The following costs were incurred in the first processing department during the month: CostMaterials costs $ 142,100 Conversion costs $ 359,500 The ending inventory was 50% complete with respect to materials and 35% complete with respect to conversion costs. The cost per equivalent unit for conversion costs for the first department for the month is closest to:$44.58$46.16$40.03$48.47
i have found anther answer for this question on bartleby and it has a lot less working out and he didnt give answer to second question but the answer he gave for the first one is very different i am not sure which one to use below is his answer: Step 1: Basic Information The question is related to Economic order quantiy Economic Order Quantity is that level of inventory at which ordering cost and handling cost are minimum. It is calculated with the help of following formula Economic Order Quantity = √2RO ÷ C R = Annual Requirment C = Carrying or Holding cost O = Ordering Cost Step 2: Solution Economic Order Quantity = √2RO ÷ C Economic Order Quantity = √2 × 3000 × 20 ÷ 4.25 Economic Order Quantity = √28,235.294117647 Economic Order Quantity = 168.0336100834 pounds R = Annual Requirment i.e.250 × 12 = 3000 pounds per annum. C = Carrying or Holding cost i.e. £4.25 O = Ordering Cost i.e. £20 Quantity to be ordered = 168.03 pounds. Supplier = Vendor 1 should be used as the cost…
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,200 February 1,600 June 2,200 March 1,800 July 1,800 April 1,800 August 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. Part 2 The average monthly demand requirement=17751775 units. (Enter your response as a whole number.) Part 3 In order to arrive at the costs, first compute the ending inventory and stockout units for each month…
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,200 February 1,600 June 2,200 March 1,800 July 1,800 April 1,800 August 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. Part 2 The average monthly demand requirement=1775 units. (Enter your response as a whole number.) Part 3 In order to arrive at the costs, first compute the ending inventory and stockout units for each month by…