Inventory records show the following:SeriesQRS--==Unit Cost$1,751.34$462.00$88.44$382.73$96.42$38.04$34.23Count6226314245117Calculate the usage values of the series and determine which is most likely to be classified asclass A

Given, Unit cost and count Total cost = Unit cost * Count Volume % = Individual total cost / Sum of…

Answered: Inventory records show the following:…

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

Which of the following is a valid approach to introduce safety stock for dependent demand items? None of the other answer choices are correct. Safety stock is never introduced for dependent demand items A, B, and C are all valid approaches A. Increase the replenishment order by a quantity specified by some estimate of expected plan error B. Add Safety Time into the requirements plan C. Utilize statistical techniques to set safety stocks directly for a dependent demand item
Inventory classification system VED is based on a. Values of consumptions. b. Criticalities of the components. c. Consumption patterns of components. d. Values of components in stock
Your company currently keeps a safety stock of 554 units of a particular product that has a lead time of 10 days. Records indicate that the weekly demand was as follows: 1176 955 780 1052 736 842 748 993 852 738 794 1444 1333 1372 1106 706 923 734 786 729 1357 1165 1277 683 1106 What is the current service level? Input your result as the decimal form and round to 4 decimal places. You are requested to recommend a safety stock that will ensure an average service level of 97.5%. The lead time is not expected to change. What safety stock would you recommend? (0 decimal places)
The ROP is an important input in determining the EOQ. True False
Oriental Healthcare is a multi-specialty hospital catering to a variety of illnessesconnected to the heart and respiratory systems. The demand for a class of medicalconsumable is generally random. Recently, an examination of the stores records overa period of 10 weeks revealed the following weekly consumption pattern:Week No. Consumption(Units)1 1202 1093 894 1405 1106 1457 778 1209 13010 80The supplier of the item takes on an average 2 weeks to deliver once the order isplaced. Design an appropriate inventory control policy for a periodic review systemfor a review frequency of 4 weeks for a 99% service level
NEED ALL THREE QUESTIONS Item X is a standard item stocked in a company's inventory of component parts. Each year the firm, on a random basis, uses about 2,700 of item X, which costs $25 each. Storage costs, which include insurance and cost of capital, amount to $9 per unit of average inventory. Every time an order is placed for more item X, it costs $6. a. Whenever item X is ordered, what should the order size be? (Round your answer to the nearest whole number.) b. What is the annual cost for ordering item X? (Round your answer to 2 decimal places.) c. What is the annual cost for storing item X? (Round your answer to 2 decimal places.)
Please help solve all.. please A company is planning to purchase 90,800 units of a particular item in the year ahead. The item is purchased in boxes each containing 10units of the item, at a price of $200 per box. A safety inventory of 250 boxes is kept. Besides, the company estimates to be charged the transporation cost of $15 per order. It should be assumed that ordering costs change in proportion to the number of orders place. The cost of holding an item in inventory for a year (including insurance, interest and space costs) is 15% of the purchase price. The cost of placing and receiving orders is to be estimated from cost data collected relating to similar orders, where costs of $5,910 were incurred on 30 orders. It should be assumed that ordering costs change in proportion to the number of orders placed. 2% should be added to the above ordering costs to allow for inflation. Assume that usage of the item will be even over the year. Required a. Calculate the order quantity that…
Carol Cagle bas a repetitive manufacturing plantproducing trailer bitches in Arlington, Texas. The plant has anaverage inventory tu rnover of only 12 times per year. She hastherefore determined that she will reduce her component lotsizes. She has developed the following data for one component,the safety chain clip:Annual demand = 31,200 unitsDaily demand = 120 unitsDaily production (in 8 hours) = 960 unitsDesired lot size (I hour of production) = 120 unitsHolding cost per unit per year = $12Setup labor cost per hour = $20How many minutes of setup time should she have her plant manageraim for regarding this component?
During the last 5 weeks, demands for a certain SKU at a retailer were 7 units (5 weeks ago), 4 units, 4 units, 4 units, and 5 units (last week). The retailer uses a period review model with order-up-to level 71 units, a review period of 2 weeks, and the lead time is 11 weeks. It is time to order. How much should the retailer order?
Here are statistics on order sizes of Megalith Construction Supply’s shipments of two kinds of construction materials last year. Girders Rivets Mean 160 2800 Std. Dev. 48 702 Which order sizes have greater variability? Multiple Choice Rivets Cannot be determined without knowing n Girders They are the same.
6. XYZ has developed the following data from its Material A Safety stock Average (normally) daily use Maximum daily use Minimum daily use E0Q 280 240 180 1.000 200 Cost of placing an order Working days per year P20 250 days Lead time 6 days What is the reorder point?
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 48,400 units per year, an ordering cost of $3 per order, and carrying costs of $1.50 per unit. a. What is the economic ordering quantity? _____________Units b. How many orders will be placed during the year? _____________Orders c. What will the average inventory be? ____________Units d. What is the total cost of ordering and carrying inventory? $__________

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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.

SEE MORE TEXTBOOKS

Inventory records show the following: Series Q R S T U V W Unit Cost $1,751.34 $462.00 $88.44 $382.73 $96.42 $38.04 $34.23 Count 6 22 63 14 24 51 17 Calculate the usage values of the series and determine which is most likely to be classified as class A