Question 3, Problem 12 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 answerthe following questions. (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.)Dollar% of Total DollarItemAnnual Demand Cost/UnitVolumeVolumeA225020B840001248,00067,5005.56C71500457.81D11502000E910002020,0002.31F36015034.721.39G22001500300,00012,000H26002015300300J8250012,5001.45ItemAnnual DemandCost/UnitA225020B8400012C7150045D11502000E9100020F360150G22001500H26002015300300J825005

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 Item Annual Demand Cost/Unit Volume % of Total Dollar Volume A2 250 20 B8 4000 12 48,000 5.56 C7 1500 45 67,500 7.81 D1 150 2000 E9 1000 20 20,000 2.31 F3 60 150 G2 200 1500 300,000 34.72 H2 600 20 12,000 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.) Dollar Item Annual Demand Cost/Unit Volume % of Total Dollar Volume A2 250 20 B8 4000 12 48,000 5.56 C7 1500 45 67,500 7.81 D1 150 2000 E9 1000 20 20,000 2.31 F3 60 150 G2 200 1500 300,000 34.72 H2 600 20 12,000 1.39 15 300 300 J8 2500 12,500 1.45

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

The chapter presented various approaches for the control of inventory investment. Discuss three additional approaches not included that might involve supply chain managers.
Solve step by step, do calculations manually not in software The demand for a certain article is 400 art/month. The ordering cost is $35 and the storage cost is $10/month. The purchase cost is $15 but if 70 items or more are purchased there is a discount andThey drop at $10. a) Obtain the optimal amount of inventory Yb) Obtain the total cost of inventoryc) Is it convenient to accept the discount?d) What is the cost of inventory with quantity m? Solve step by step, do calculations manually not in software
Your objective is to help company by determining EOQ* (Economic Order Quantity) that minimizes the totalinventory cost for a company that sells ceiling fans. Your worksheet provides information about the currentorder quantity, demand quantity and other costs.Questions: Answer A and Ba. With the current order quantity, what is the total cost of inventory?b. Implement the problem in Excel and find the order quantity (EOQ) (round to nearest integer) that givesminimum inventory cost. Note: this is a Non-linear programming, hence select “GRG Nonlinear” method inSolver- How much money would company save by switching to optimum quantity from current orderquantity?
Brock Co. adopted the dollar-value LIFO inventory method as of January 1, year 1. A single inventory pool and an internally computed price index are used to compute Brock’s LIFO inventory layers. Information about Brock’s dollar-value inventory follows: What was Brock’s dollar-value LIFO inventory at December 31, year 2? a. $80,000 b. $74,000 c. $66,000 d. $60,000
Rafiki Bar uses 10,000 cases of millet beer monthly. One case costs Shs.5,000. Holding cost is 30% of the cost of a case p.a while ordering cost is Shs.100,000 per order. The firm works 360 days in a year while lead time is 6 days. Required: ii. Determine the days between orders and the reorder point iii. Determine the total cost of the inventory policy iv. Suppose actual holding cost turns out to be 15% instead of 30% and the inventory policy above is implemented for a year, determine the cost of prediction error if every other parameter estimate turns out as predicted.
Custom Computers, Inc. assembles custom home computersystems. Th e heat sinks needed are bought for $12 each and areordered in quantities of 1300 units. Annual demand is 5200 heatsinks, the annual inventory holding cost rate is $3 per unit, andthe cost to place an order is estimated to be $50. Calculate thefollowing:(a) Average inventory level(b) Th e number of orders placed per year(c) Th e total annual inventory holding cost(d) Th e total annual ordering cost(e) Th e total annual cost
Tacky Souvenirs sells lovely handmade tablecloths at its islandstore. These tablecloths cost Tacky $15 each. Customers wantto buy the tablecloths at a rate of 240 per week. The companyoperates 52 weeks per year. Tacky, the owner, estimates hisordering cost at $50. Annual holding costs are 20 percent of theunit cost. Lead time is 2 weeks. Using the information given,(a) Calculate the economic order quantity.(b) Calculate the total annual costs using the EOQ.(c) Determine the reorder point.
Dave's Sporting Goods sells Mountain Mouse freeze-dried meals. Dave's uses a continuous review system to manage meal inventories. Suppose Mountain Mouse offers the following volume discounts to its customers: 1−950 meals: $6.50 per meal 951 or more meals: $4.50 per meal. Annual demand is 2,900 meals, and the cost to place an order is $23. Suppose the holding cost is $1.50 per meal per year. How many meals should Dave's order at a time? Part 2 Dave's Sporting Goods should order ______ meals at a time to take advantage of the lower cost per unit. (Enter your response rounded to the nearest whole number.)
The following information relates to Unique Ltd for the year 2020: Annual Demand 408,375 units Annual cost of Holding £1.50 Annual cost of placing an order £ 500Required: (iv) Calculate the total annual inventory cost (excluding the purchasecost)
I need a detailed explanation on how to solve this problem: A paint shop implements an inventory policy on its stock of white paint, which costs the store $6 per can. Monthly demand for cans of white paint is normal with mean 28 and standard deviation 8. The replenishment lead time is 14 weeks. Excess demand is backordered, but costs $10 per back ordered can in labor and loss of goodwill. There is a fixed cost of $15 per order, and the holding cost is based on 30% interest rate per annum. In your computations, assume 4 weeks per month. - Write down the model name and parameters. - What are the optimal lot size and reorder points for white paint (include the formulas)? - What is the optimal safety stock (include the formula)? *** Suppose the paint shop from the above problem adopts a service level policy. - What are the optimal lot size and reorder points for white paint, such that 90% of the cycles are filled without backordering (include all formulas)? - What is the fill rate…
Rapallo Sneakers, Inc. sells a pair of LG sneakers for $42. Due to the recent fitness craze, these shoes are in high demand: 52 pairs of shoes are sold per week. The ordering cost is $42 per order, and the annual holding cost is 25 percent of the selling price. If the store operates 48 weeks a year, what can you say about the size of the current order quantity of 225 pairs?
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?