Given the following list of items, Item Annual Demand 101 102 103 104 105 201 202 203 204 205 Item 101 102 103 104 105 201 202 203 204 530 205 1,530 5,030 280 1,530 10,030 1,030 1,530 530 100 Ordering Cost ($) 10 10 25 15 35 25 10 20 40 10 (a) Calculate the annual usage cost of each item. (b) Classify the items as A, B, or C. Annual Usage ($) Item Classification O O O O O Holding Cost (%) O O 20 30 30 25 35 15 20 25 25 15 Unit Price ($) 0.50 0.20 1.00 4.50 1.20 0.75 1.35 0.20 0.80 2.50

Given the following list of items, Item Annual Demand 101 102 103 104 105 201 202 203 204 205 Item 101 102 103 104 105 201 202 203 204 530 205 1,530 5,030 280 1,530 10,030 1,030 1,530 530 100 Ordering Cost ($) 10 10 25 15 35 25 10 20 40 10 (a) Calculate the annual usage cost of each item. (b) Classify the items as A, B, or C. Annual Usage ($) Item Classification O O O O O Holding Cost (%) O O 20 30 30 25 35 15 20 25 25 15 Unit Price ($) 0.50 0.20 1.00 4.50 1.20 0.75 1.35 0.20 0.80 2.50

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

Perform an ABC analysis on the following set of products Item Annual Demand Unit Cost A211 800 R9 B390 100 R90 C003 450 R6 D100 400 R100 E707 85 R2000 F660 250 R320 G473 500 R75 H921 100 R75
Perform an ABC analysis on the following set of products. Item Annual Demand Unit Cost A211 800 $9 B390 100 $90 C003 450 $6 D100 400 $100 E707 85 $2,000 F660 250 $320 G473 500 $75 H921 100 $75 Answer: Item Annual Demand Unit Cost Volume Cumulative volume Cumulative percent Total =
Demand for portable music players for joggers has caused Nancy Industries (Nancy) to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nancy expects demand for music player to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demands for the players for last year was as follows : Month Demand (units) Jan 4200 Feb 4300 Mar 4000 Apr 4400 May 5000 Jun 4700 Jul 5300 Aug 4900 Sep 5400 Oct 5700 Nov 6300 Dec 6000 Question : From the choice of simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate to Nancy Industries? Why?
Why do we use "Specifications or bill of material" in the dependent inventory model?
Micro-Electronics Warehouse Headset and Webcam Sale Item Type Reg. Price After Savings Price BuddyChat 200 Headset $34.72 $24.40 BuddyChat 300 Headset $41.27 $34.91 BuddyCam HD Webcam $83.54 $61.46 You have decided to purchase the headset with the greatest markdown percent and the BuddyCam HD webcam in order to take advantage of an "Extra $15 Rebate" offer when you purchase both. What is the markdown percent on your total purchase including the rebate?
ABC analysis on the following set of products Item Annual Demand Unit CostA 211 800 R9B 390 100 R90C 003 450 R6D 100 400 R100E 707 85 R2,000F 660 250 R320G 473 500 R75H 921 100 R75 Soft goods department sells 175 units per month of a certain large bath towel. The unit cost of a towel to the manufacturer is R2.50 and the cost of placing an order has been estimated to be R12.00. There is an inventory carrying charge of 27% of the unit cost per year. What is the optimal order quantity, the order frequency, and the annual holding and setup cost. If the ordering cost can be cut to R4.00, what will be the new economicorder quantity, the order frequency, and annual holding and setup costs.
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: 12 units at $47 Jan. 11 Aug. 13 20 units at $48 Nov. 30 $564 960 735 Avaliable for sale $2,259 There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-sout (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). a First-in, first-out (FIFO) b. Last-in, first-out (LIFO) c. Weighted average cost Inventory Purchase Purchase 15 units at $49 47 units 1,284 X
Determine an A-B-C classification for these items:Item Unit Cost Annual Volume (00)1 $100 252 80 303 15 604 50 105 11 706 60 857 10 60b. Find the EOQ given this information: D = 4,500 units/year, S = $36, and H = $10 per unit per year. I just need help with part b.
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Compute the probability of a stock-out for the…
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Question: One of Fisher-Price’s managers felt…
(a) Give examples of independent and related dependent demand (b) APL company assembles and sales an electronics device (ED) on a contract basis. End item ED has composed of 3 units of subassembly BG and 5 units of component DD. BG is assembled using 3 DDs and 4 FCs. There are orders of 500 and 875 units of the device (ED) at the beginning of week 6 and week 8. In assembling BG, an extra 20 percent scrap allowance must be added. DD can only be ordered in whole cases of 400 units per case. One case of DD is received in each of week 1 and week 2. Also, there are 200 units of BG and 425 units of DD now on hand. The lead time for the item BG, DD, and FC is 2 weeks and that is for the item ED is 1 week.i. Calculate the required number of DD and FC for producing 100 units of ED. There is no stock of any item. ii. Prepare a material requirements plan for the component DD.
4) Rane Brake Linings gathered information for its brake lining components as presented in the table below. How would the firm classify these items according to an ABC classification system? Initial Information Part # Unit Cost Annual Demand 10 10 200 11 30 125 12 9 100 13 12 5000 14 50 195 15 6 300 16 100 70