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 Volume % of Total Dollar Item Annual Demand Cost/Unit Volume A2 500 300 4000 1500 B8 12 48,000 7.02 C7 45 67,500 9.87 D1 20 35 1000 20,000 E9 20 2.92 F3 34 250 300,000 12,000 43.85 G2 H2 200 600 1500 20 1.75 15 1000 65 J8 2500 12,500 1.83

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 Volume % of Total Dollar Item Annual Demand Cost/Unit Volume A2 500 300 4000 1500 B8 12 48,000 7.02 C7 45 67,500 9.87 D1 20 35 1000 20,000 E9 20 2.92 F3 34 250 300,000 12,000 43.85 G2 H2 200 600 1500 20 1.75 15 1000 65 J8 2500 12,500 1.83

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
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
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.
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)?
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?
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
At theEOQ, what is the firm’s total inventory costper year, assuming safety stock = 15 units?
The children’s buyer needs to average a 51% markup. He needs topurchase 300 dresses that will retail for $28,200 total. He hasalready placed an order for 148 dresses at $42.00 each (cost) thatwill retail for $90.00 each. What is the most that he can pay ofeach of the remaining dresses in order to obtain the 51% markup?Round to 2 decimal points.
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?
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)
What does the ABC analysis entail! What is the underlying premise? What are the three criteria for conducting an ABC inventory analysis?