IM.51 The BYU-Idaho University Store has 7,800 items in its inventory. The management of these items should be as prescribed in the table below: Item Percent of Cycle Count Interval (Days) Class Items A 20% B 35% C 45% 20 80 120 How many "A" items should there be? (Display your answer to the nearest whole number.) 1560 How many "C" items should there be? (Display your answer to the nearest whole number.) 3510 How many "B" items should be counted each day? (Display your answer to two decimal places.) 12455.63 How many total items should be counted each day? (Display your answer to two decimal places.) Number

IM.51 The BYU-Idaho University Store has 7,800 items in its inventory. The management of these items should be as prescribed in the table below: Item Percent of Cycle Count Interval (Days) Class Items A 20% B 35% C 45% 20 80 120 How many "A" items should there be? (Display your answer to the nearest whole number.) 1560 How many "C" items should there be? (Display your answer to the nearest whole number.) 3510 How many "B" items should be counted each day? (Display your answer to two decimal places.) 12455.63 How many total items should be counted each day? (Display your answer to two decimal places.) Number

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

c) Even if there is substantial uncertainty in the parameters in the EOQ-model, it is still quite a useful model. Discuss why.
Please explain me in brief about Pros and Cons of Re-Order Point Control and Re-Order Cycle Control Inventory control Systems.
L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) Item Code Avg. Inventory (units) Value ($/unit)1289 380 3.252347 300 4.002349 120 2.502363 70 1.302394 60 1.752395 25 1.756782 20 1.157844 12 2.058210 10…
Which of the following is ‘data’? i. Number of items in inventory in the store were 3,000 ii. Value of items in the store was OMR 5,000 iii. Total items with value OMR 1,500 to OMR 3,000 were 500
Describe the 3 differences between a fixed-quantity (Q) and a fixed-period (P) inventory ns4 a. system? Fixed Quality Inventory Fixed Period Inventory
Problem 7 Lynne Chappell manages the inventory of supplies in a large hospital. To determine which items should be closely monitored, Lynne decided to use the ABC classification schemeto group the items on the basis of their value. Asthe following table shows, she took a random sample of20 items and recorded the annual usage and unit cost ofeach. How should each item be classified?Inventory Item Unit cost(in U.S.dollars) AnnualUsageP21 $80 800A12 $400 70K43 $50 100S54 $60 90C25 $50 130D76 $30 170E27 $20 200F38 $300 90H19 $520 120Q10 $10 100R82 $20 80G65 $80 70L71 $220 200M94 $70 80V45 $15 60T62 $30 180I17 $20 80W22 $300 90O37 $700 85N88 $5 100
XYZ Company has developed the following data from its Material A: Safety stock 280 Average (normally) daily use 200 Maximum daily use 240 Minimum daily use 180 Economic order quantity 1000 Cost of placing an order $20 Working days per year 250 days Lead time 6 days 1. What is the cost of carrying an inventory per unit per year? 2. What is the average inventory?
L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? (Round individual dollar volumes to two decimal places. Also round percentage of dollar volume to two decimal places.) L. Houts Plastics Charlotte Inventory Levels Item Code Avg. Inventory (units) Value ($/unit) Dollar % of Dollar Volume Volume 1289 360 4.00 2347 300 4.00 1,200 36.20 2349 120 2.50 300 9.05 2363 75 1,50 2394 60 1.75 105 3.17 2395 35 2.00 6782 20 1.15 23 0.69 7844 12 2.05 24.6 0.74 8210 5 1.60 8310 7 2.00 14 0.42 9111 3.00 18 0.54 3,315.1 For the following three questions, consider only items 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics). Based on the percentages of dollar volume, item number…
NING SYSTEM (ACADEMIC) tory Management - Spring21 Time left 1:14:19 Alocal Omani retail store finds out the its competition is ordering 50O kgs each order of a coffee brand. Over years the local Omani store has realized that its competition has adopted an economic ordering quantity (EOQ) policy for ordering. Whereas, local Omani store has determined that it take OMR 25 to order and the annual holding cost is 25% of the price of the coffee brand. The price of the coffee brand is OMR 100 per kg. What is the annual demand for this coffee brand? Round up to the nearest integer None is correct Ob. 100,000 150,000 O d. 90,000 125.000 NEXT PAGE US PAGE
L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the ← table below: How would the plant classify these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places) Item Code Avg. Inventory (units) 1289 2347 2349 2363 2394 2395 L. Houts Plastics Charlotte Inventory Levels Value Dollar Volume (S/unit) 3.50 6782 7844 8210 8310 9111 360 300 120 65 60 25 222216 20 10 7 4.00 2.50 1.80 1.75 2.25 1.15 2.05 1.60 2.00 3.00 1,200 300 105 23 25 14 18 3,134 % of Dollar Volume 38.29 9.57 3.35 0.73 0.78 0.45 0.57
dt = demand Kt = ordering cost Ct = cost per item ht = holding cost per item per unit time
3. (Ch9) A store has collected the following information on one of its products: Demand = 4,500 units/year Standard deviation of weekly demand = 12 units Ordering costs = $40/order Holding costs = $3/unit/year Cycle-service level = 90% (z for 90% = 1.28) Lead-time = 2 weeks Number of weeks per year = 52 weeks a. If a firm uses the continuous review system to control the inventory, what would be the order quantity and reorder point? b. The firm decided to change to the periodic review system to control the item's inventory. For the most recent review, an inventory clerk checked the inventory of this item and found 300 units. There were no scheduled receipts or backorders at the time. How many units should be ordered? (HINT: Use the EOQ model to derive P, the time between reviews.)