Boreki Enterprise has the following 10 items in inventory. Theodore Boreki asks you, a recent OM graduate, to divide these items into ABCclassifications. Fill in the blanks and then answer the following questions. (Round dollar volume to the nearest whole number and percentageof dollar volume to two decimal places.)% of Total DollarDollarVolumeItemAnnual Demand Cost/UnitVolumeA22502048,00067,5005.567.81B8400012C7150045D11502000E910002020,0002.31F360150300,00012,000G2200150034.72H2600201.3915300300J8250012,5001.45

ABC analysis is the inventory management technique in which inventory items are divided into three…

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

As part of the employment interview for an accounting job at Sound Design, you have been asked to answer the questions below, based on an invoice from one of Sound Design's vendors, Target Electronic Wholesalers. Invoice Stock # Description Unit Price Amount 4811V Stereo Receivers 50 ✕ $293.50 = _______________________ 511CX Blu-Ray Players 25 ✕ $136.28 = _______________________ 6146M Home Theater Systems 40 ✕ $656.12 = _______________________ 1031A LCD TVs 20 ✕ $594.00 = _______________________ Merchandise Total _______________________ Insurance + Shipping $1,250.00 Invoice Total _______________________ An invoice. The top of the invoice is divided into several distinct sections. The first section is located in the top left of the invoice, is unlabeled, and contains an image of a target with an arrow in the center of the target. The second section is located in the top center of the invoice, is unlabeled,…
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 and percentage of dollar volume to two decimal places.) Item Annual Demand Cost/Unit Dollar Volume % of Total Dollar Volume A2 250 20 5000 .58 B8 4000 12 48,000 5.56 C7 1500 45 67,500 7.81 D1 150 2000 300000 34.72 E9 1000 20 20,000 2.31 F3 60 150 9,000 1.04 G2 200 1500 300,000 34.72 H2 600 20 12,000 1.39 15 J8 58 300 2500 300 5 90,000 12,500 10.42 1.45 For 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 as B C A
At theEOQ, what is the firm’s total inventory costper year, assuming safety stock = 15 units?
Do you think the safety stock (safety inventory) could be negative? What is the meaning of a negative safety inventory (hint: safety stock is the difference between the optimal inventory and the average demand)?
Jam costs $10/jar, requires a 6mo. lead time, and will sell for $35/jar. If you stock out, you'll face a $25/jar loss of goodwill. Placing an order costs $50, and money that is tied up in capital is assumed to have a 20% interest rate for calculating holding costs. During the 6-mo replenishment time, he sells ~100 jars, but with substantial variation. Estimates are a standard deviation of demand during each 6-mo period of 25 jars. Assume demand is described by a normal distribution. How should the Jam be ordered?
What is the relationship between the average inventory and the in-stock probability?a. The more the inventory, the lower the in-stock probability.b. There isn’t a definitive relationship—more inventory could mean a lower or a higherin-stock probability.c. The more the inventory, the higher the in-stock probability.
Please complete the problem usinf EXCEL, Show ALL formulas Demand for a popular athletic shoe is nearly constant at 800 pairs per week for a regional division of a national retailer. The cost per pair is $54. It costs $72 to place an order, and annual holding costs are charged at 22% of the cost per unit. The lead time is two weeks. a. What is the EOQ? b. What is the reorder point? c. What is the cycle time? d. What is the total annual cost?
asap!! A manager of an inventory system believes that inventory models are important decision making aids. Even though often using an EOQ policy, the manager never considered a backorder model because of the assumption that backorders were “bad” and should be avoided. However, with upper management’s continued pressure for cost reduction, you have been asked to analyze the economics of a backorder policy for some products that can possibly be backordered. For a specific product with D = 1200 units per year, Co = 160, = 4, and = 25, what is the difference in total annual cost between the EOQ model and the planned shortage or backorder model? If the manager adds constraints that no more than 25% of the units can be backordered and that no customer will have to wait more than 18 days for an order, should the backorder inventory policy be adopted? Assume 300 working days per year.
Describe the importance of control over inventory ? Describe three inventory cost flow assumptions and how they impact the income statement and balance sheet ?
Buckley Enterprise sells a product that cost $450 per unit and has a monthly demand of 5,000units. The annual holding cost per unit is calculated as 5% of the unit purchase price. It costs thebusiness $75 to place a single order. Currently the business places 12 orders each year.i) What is the total stock administrative cost of Buckley’s current inventory policy?ii) Is this the entity’s cost minimizing solution for this product each year? Explain.
10 Use the information presented in the graph to answer the following questions: Annual Cost C3 C2 Q1 You are also given the following information: Q1 =450 .Q2 = 700 C1 = 350 C2 = 750 1300 Q2 Order Quantity Which annual inventory cost component does the blue line represent? Total cost Which annual inventory cost component does the green line represent? Holding cost What is the Economic Order Quantity (EQ9) based on th Which annual inventory cost component does the red line represent? Ordering cost 220
Kelley, Inc. provided the following account balances for 2018: Cost of Goods Sold (Cost of sales) Beginning Merchandise Inventory Ending Merchandise Inventory $1,300,000 330,000 350.000 Calculate the average number of days that inventory was held by Kelley, Inc. during 2018. (Assume 365 days in a year. Round your intermediate calculations and final answer to two decimal places.) O A. 191.10 days O B. 92.64 days O C. 95.55 days O D. 98.38 days

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