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.) Dollar % of Total Dollar Item Annual Demand Cost/Unit Volume Volume A2 3500 50 48.000 67,500 B8 4000 12 4.69 C7 1500 45 6.60 D1 6000 20 E9 1000 20 20,000 1.96 F3 500 500 G2 200 1500 300,000 29.34 H2 600 20 12,000 1.17 15 1750 10 J8 2500 5 12,500 1.22

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.) Dollar % of Total Dollar Item Annual Demand Cost/Unit Volume Volume A2 3500 50 48.000 67,500 B8 4000 12 4.69 C7 1500 45 6.60 D1 6000 20 E9 1000 20 20,000 1.96 F3 500 500 G2 200 1500 300,000 29.34 H2 600 20 12,000 1.17 15 1750 10 J8 2500 5 12,500 1.22

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.) % of Total Dollar Dollar Volume Item Annual Demand Cost/Unit Volume A2 250 20 48,000 67,500 5.56 7.81 B8 4000 12 C7 1500 45 D1 150 2000 E9 1000 20 20,000 2.31 F3 60 150 300,000 12,000 G2 200 1500 34.72 H2 600 20 1.39 15 300 300 J8 2500 12,500 1.45
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)?
What does the ABC analysis entail! What is the underlying premise? What are the three criteria for conducting an ABC inventory analysis?
Variety Manufacturer purchases a component from a Asian supplier. The demand for that component is exactly 70 units each day. The company is open for business 250 days each year. When the company reorders the product, the lead time from the supplier is exactly 10 days. The product costs $14.00. The company determined that its inventory carrying cost is 20%. The company’s order cost is $30.00. What is the annual holding cost?
Regardless of the size of an organisation, having a proper inventory management system is very important for any business. It can help an organisation keep track of all supplies and determine the exact prices. It can also help assist an organisation manage sudden changes in demand without sacrificing customer experience or product quality. In an essay, you are required to analyse inventory management at Ikea.Comment on whether you believe Ikea should make use of the ABC analysis of inventory classification. Justify your stance by discussing at least three key points.Evaluate factors impacting the future of procurement in relation to Ikea such as the fourth industrial revolution.
At theEOQ, what is the firm’s total inventory costper year, assuming safety stock = 15 units?
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?
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
An ophthalmologist's office operates 52 weeks per year, 6 days a week. It purchases disposable contact lenses for $11.70 per pair and sells for $50. The demand is 90 pairs per week. Order cost is $54 per order. Annual interest rate is 27%. Lead-time is 3 weeks. Standard deviation of weekly demand is 15 pairs. Given that 98% service-level. Clearly identify different types of stocks: cycle, safety and pipeline. a. Find a (Q, r) policy for this situation c. Find average service level (fill rate) of the policy (a) d. Find average backorder level of the policy (a) e. Find average inventory level of the policy (a)
As inventory manager, you must decide on the order quantity for an item that has an annual demand of 2,000 units. Placing an order costs you $20 each time. Your annual holding cost, expressed as a percentage of average inventory value, is 20 percent. Your supplier has provided the following price schedule:Minimum Order Quantity Price per Unit1 $2.50200 $2.40300 $2.251,000 $2.00What ordering policy do you recommend?
in a standard ABC analysis, 50 to 60 percent of the number of items in inventory but only about 10 15 percent the annual dollar value represent