Boreki Enterprise has the following 10 items in inventory. Theodore Boreki asks you, a recent OM graduate, to divide these items into ABC classifications. Fill in the blanks and then answer the following questions. (Round dollar volume to the nearest whole number andpercentage of dollar volume to two decimal places.)ItemA2B8C7D1E9F3G2H215J8Item F3 should be classified asAnnual Demand Cost/Unit50030040001215004535202501500206552010003420060010002500Dollar % of Total DollarVolumeVolume48,00067,50020,000300,00012,00012,500For the following two questions consider only items A2 and F3 for relative classification (these are some of the items for which you computed the metrics).Based on the percentages of dollar volume, item A2 should be classified as7.029.872.9243.851.751,83

Inventory management is the aspect of production management of an organization including storing,…

Answered: Boreki Enterprise has the following 10…

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

Discuss with examples the two methods of inventory control. Which method do you think is better for a retail store with several items of small value?
Please show work so I can understand it. Given this information: •Expected demand during lead time = 800 units • Standard deviation of lead time demand = 40 units Assuming that lead time demand is distributed normally. The risk of stockout is 5 percent during lead time (a) What amount of safety stock is appropriate? (b) Calculate ROP
IL Data related to the inventories of Metro Supply are presented below: 困 Surgical Equipment $ 260 170 240 Surgical Supplies $ 120 Rehab Rehab Selling price Cost Equipment S 340 Supplies $ 165 90 250 235 162 Replacement cost Costs to sell Normal gross profit ratio 80 158 30 25 10 30% 30% 30% 20% *Show your computation! If not, no credit A) In applying the lower of cost or market rule, the inventory of surgical equipment would be valued at: B) In applying the lower of cost or market rule, the inventory of surgical supplies would be valued at: C) In applying the lower of cost or market rule, the inventory of rehab equipment would be valued at: D) In applying the lower of cost or market rule, the inventory of rehab supplies would be valued at:
please show work in excel The New Haven Foundation gave a grant to the Affordable Computers Co.(ACC) to manufacture low cost computers for children in developing countries. ACC needs 3000 memory chips per month for use in producing these hardware. The ordering cost is 12 dollars, and holding cost is 0.3 dollars per chip per year. a) What is the economic order quantity for the memory chips? b) Based on your answer to part (a), what would be the time between orders? (Hint: Q/D)
Joe Henry's machine shop uses 2,530 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The following information is known about the brackets: Annual demand 2,530 Holding cost per bracket per year $1.65 Order cost per order $18.25 Lead time 2 days Working days per year 250 Part 2 a) What is the EOQ? enter your response here units (round your response to two decimal places). Part 3 b) What is the average inventory if the EOQ is used? enter your response here units (round your response to two decimal places). What would be the annual inventory holding cost? $enter your response here (round your response to two decimal places). Part 4 c) Given the EOQ, how many orders will be made annually? enter your response here orders (round your response to two decimal places). What would be the annual order cost? $enter your response here (round…
www.www A toy manufacturer uses approximately 40000 silicon chips annually. The chips are used at a steady rate during 350 working days per year. The annual holding cost is $4 per chip, ordering cost is $145, and lead time is 5 days. Determine the annual cost saving if company uses optimal EOQ (part a) instead of current order quantity of 3000 units (Round your answer to 1 decimal places)
Discuss what is meant by ABC analysis of inventory.Name several measures that can determine ABCstatus
A museum of natural history is having problems managing their inventories. Low inventory turnover is squeezing profit margins and causing cash-flow problems. A Class A item, a birdfeeder is also a top-selling item. See information for this item in the table below. Management has been ordering in lots of 390 units. 1) What is the annual cost of the current policy (hint: find the current total cost with the current order size, Q)? 2) What is the Economic Order Quantity or the optimum order quantity (EOQ) for the birdfeeders? 3) What is the total annual cost of ordering at the EOQ? How much could be saved if the museum ordered at the EOQ opposed to their current order size of 390 units? 4) When should the museum place an order, at how many units (i.e.: what is their reorder point or lead time demand)? Sales per week (demand) Purchase cost Order cost Annual holding cost Birdfeeder: Operating weeks per year Lead time for orders (weeks) Order size EOQ (calculated) 18 $ $ 60.00 45.00 25% of…
A company has a demand for 25,750 units annually. The holding cost is 33% of the item cost which is $10.00. The ordering or set-up cost is $250.00 per order and the lead time is 5 days. Assume that there are 350 days per year Suppose a price break of $50 per order is offered for purchase quantities of 2,000 or greater. Question: What is the reorder point for this inventory strategy? What is the inventory position immediately after an order is placed for the inventory strategy that you have selected?
4
Please help me with this practice problem. Please use specific equations that apply and where to put them. Please list out the steps. Thank you
Please Show EVERY Working VERY Clearly! Calculate the Economic Order Quantity, Total Annual Cost, Reorder Point, and ADDITIONAL Annual Cost (using a GRAPH) if the Procurement Manager increase the order quantity by 25% from the above EOQ.

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