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 thefollowing questions. (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.)ItemAnnual Demand Cost/UnitDollarVolume% of Total DollarVolumeA2250205000.58B840001248,0005.56C715004567,5007.81D1150200030000034.72E910002020,0002.31F3601509,0001.04G22001500300,00034.72H26002012,0001.3915J8583002500300590,00012,50010.421.45For 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 asBCA

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

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
All Seasons Flower Shop uses 870 clay pots a month. The pots are purchased at $ 6 each. Annual holding cost per pot is estimated to be 35% of purchase cost. Ordering cost is $ 40 per order. The shop operates 12 months in a year. What would be the difference in total cost if an order quantity of 1000 is used instead of the EOQ. Note: calculate the difference as “total cost with Q = 1000 – total cost with EOQ”.
m12h6p2
Mac-in-the-Box, Inc., sells computer equipment by mail andtelephone order. Mac sells 1,200 flat-bed scanners per year.Ordering cost is $300, and annual holding cost is 16 percentof the item’s price. The scanner manufacturer offers thefollowing price structure to Mac-in-the-Box: What order quantity minimizes total annual costs?
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…
the economic order quantity (see Chapter 12 for EOQformulas) for its halogen lamps. It currently buys all halogenlamps from Specialty Lighting Manufacturers in Atlanta. Annualdemand is 2,000 lamps, ordering cost per order is $30, and annualcarrying cost per lamp is $12.a) What is the EOQ?b) What are the total annual costs of holding and ordering(managing) this inventory?c) How many orders should D iscount-Mart place with SpecialtyLighting per year?
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…
3 Which of the following inventory models considers backorder costs? O a. Economic Order Quantity with Quantity Discounts O b. Basic Economic Order Quantity C. Economic Order Quantity with Planned Shortages Od. Economic Production Quantity
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?

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