a. Construct:i. ABC analysis by annual dollar usageii. ABC analysis by current inventory value(Performing the tables and charts in excel)b. Based on these analyses, do you think the firm is stocking the correct inventories? Given the following inventory information:ItemUnit costAnnual usageCurrent inventorynumber($)(units)(units)B1112.001008,000J1210.506,500120K200.504,0001,000L352.001,500375М3711.002,000500T61140.00500800W641.5080020,000Х683.008,0002,000Y8964.001,000500Y948.003,500125

ABC analysis is a management of inventory technique that identifies the value of inventory items…

Construct: i. ABC analysis by annual dollar usage ii. ABC analysis by current inventory value (Performing the tables and charts in excel) b. Based on these analyses, do you think the firm is stocking the correct inventories?

Construct: i. ABC analysis by annual dollar usage ii. ABC analysis by current inventory value (Performing the tables and charts in excel) b. Based on these analyses, do you think the firm is stocking the correct inventories?

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

Please do not give solution in image formate thanku.
2.7 Which of the following help explain how the Reorder Point (ROP) works in conjunction with the Economic Order Quantity (Q), the number of orders (N) and the time between orders (T)? a) The Economic Order Quantity (Q) and the Annual Demand (D) are used to determine the number of Order (N) b) The number of orders (N) and the number of days that a firm works (W) are used to determine the time span between orders (T) c) Orders are placed every T days unless the inventory on hand fall to or below the Reorder Point d) Only a and b e) f) Only b and c All of a, b and c 2.8 The objective of Inventory Management is to balance inventory investment (cost) and customer service. a) TRUE b) False 2.9 The Economic Order Quantity (EOQ), the number of orders, the Reorder Point (ROP), the time between orders are important analytics in Inventory Management. a) TRUE b) FALSE 2.10 The number of working days for a firm is an important input in calculating the components of the Economic Order Quantity…
1. Net sales for the hosiery department in May wee $30,620. Book inventory at the end of the month showed that $97,831 should be on hand. Physical inventory showed $97,560. Determine shortage or overage percent. Present your answer with a percent sign, rounded to two decimal places (i.e. 19.64%). 2. Using the data below, determine the closing book inventory. Not all information given may be needed. Present your answer with a dollar sign, comma separator, rounded to the dollar. (i.e. $19,567) Opening inventory $89,760 Gross purchases $43,620 RTV $860 Cash discounts $320 Markdowns $5,246 Markdown cancellations $318 Employee discounts $784 Gross sales $49,318 Customer returns $2,945 Net markups $760 3. Calculate the shortage or overage percent, given the following information. Present your answer with a percent sign, rounded to two decimal places (i.e. 19.64%). NOTE. There is another question in this quiz using the same data. Opening inventory…
The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with backorders. Given this information, what is the number in the cell with the question mark?
Month# Jan Feb Mar Apr May June Forecast# 1800 1500 1100 1500 2100 1600 Name Labor hours per unit (hr/unit) Initial number of workers Safety Stock (units) Working hours in a day(hr/day) Beginning inventory(units) Value 5 30 0 9 450 Month# Jan Feb Mar Apr May June Working Days available 21 21 21 21 21 19 The tables present forecasts, production, and cost information for aggregate planning. Using a level strategy with backorders to produce at average demand, now many workers are required each month? (Round up the calculated number of workers to the nearest whole number, and round the production rate to the nearest whole number
1. Sit-Yuen Foo has produced monthly forecasts of demand for a family of products as shown below. At the end of each month he reviews performance, and assigns a notional holding cost of $30 for every unit held in stock. If there are shortages, 20 per cent of orders are lost with a cost of $300 a unit, and the rest are met by back-orders, with a cost of $75 a unit. Each time the production rate changes there is a cost of $22,500. Designed capacity is 600 units a month, but utilization seldom reaches 80 per cent. How can Sit-Yuen Foo design an aggregate plan for the products? Month 3 4 6. 7 8 10 Aggregate demand 460 420 390 450 540 375 240 150 100 210
The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with lost sales, i.e., without backorders. Given this information, what is the number in the cell that says xx?
12. Determine the planned purchases for January (a) at retail and (b) at cost for the lingerie department when the seasonal merchandise plan indicates the following planned figures: Round to the nearest dollar. Sales $88,000 Markdowns 8% BOM Stock $81,000 EOM Stock $66,000 Markup 49%
1. Determine the inventory order quantity for Diamant’s distributor.2. Compare the optimal order quantity with a seasonally adjusted forecast for demand. Doesthe order quantity seem adequate to meet the seasonal demand pattern for Diamonds(i.e., is it likely that shortages or excessive inventories will occur)?
Please ASAP. Thank you.
here its the right answered please just provide me an explanation of how did you get this number with an calculation(24, 33, 33, 18, 10)
c4 need urgent in 15 minutes