Skousen buys tennis balls at P 25 per dozen from its wholesaler. Skousen will sell 35,000 dozens of tennis balls evenly throughout the year. Skousen desires a 12% percent return on investment (cost of capital) on its inventory investment. In addition, rent, insurance and related taxes for each dozen tennis balls in inventory amounts to P 0.50. The cost per order is P 8. Skousen uses a 350-day year. What is the average number of tennis balls does Skousen maintain? O 200 tennis balls O 2,400 tennis balls O 4,800 tennis balls O 400 tennis balls

Skousen buys tennis balls at P 25 per dozen from its wholesaler. Skousen will sell 35,000 dozens of tennis balls evenly throughout the year. Skousen desires a 12% percent return on investment (cost of capital) on its inventory investment. In addition, rent, insurance and related taxes for each dozen tennis balls in inventory amounts to P 0.50. The cost per order is P 8. Skousen uses a 350-day year. What is the average number of tennis balls does Skousen maintain? O 200 tennis balls O 2,400 tennis balls O 4,800 tennis balls O 400 tennis balls

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

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.)
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
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…
At Matthews Car Repair, customer demand for a certain brand of motor oil is normally distributed with a mean of 15 gallons and a standard deviation of 6 work-days. To be 95% sure that Compact Car Repair will not run out of oil, we should reorder when motor oil in stock is less than _______ gallons. a. 24.9 b. 22.6 c. 23.7 d. 20
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.
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.
8. A local retailer anticipates an annual demand 12000 units of a product. The retailer allows shortages for that product, and these shortages are backordered at a rate of 4 OMR per unit backordered. The cost of ordering is 200 OMR, whereas, the annual holding cost is 1 OMR per unit. The retailer operates 300 days per year. What is the optimal maximum inventory level? Round - up to the nearest integer ? a. 1987 b. 1789 c. 1960 d. None is correct e. 1898
Millennium Liquors is a wholesaler of sparkling wines. Its most popular product is theFrench Bete Noire, which is shipped directly from France. Weekly demand is 45 cases.Millennium purchases each case for $120, there is a $300 fixed cost for each order(independent of the quantity ordered), and its annual holding cost is 25 percent.a. What order quantity minimizes Millennium’s annual ordering and holding costs?b. If Millennium chooses to order 300 cases each time, what is the sum of its annualordering and holding costs?c. If Millennium chooses to order 100 cases each time, what is the sum of the orderingand holding costs incurred by each case sold?d. If Millennium is restricted to ordering in multiples of 50 cases (e.g., 50, 100, 150, etc.),how many cases should it order to minimize its annual ordering and holding costs?e. Millennium is offered a 5 percent discount if it purchases at least 1000 cases. If itdecides to take advantage of this discount, what is the sum of its annual…
ABC, a company that sells pump housings to other manufacturers, would like toreduce its inventory cost by determining the optimal number of pump housings to obtainper order. The annual demand is 1 000 units, the ordering cost is 10 MU/order, and theaverage carrying cost per unit per year is 0.50 MU. Calculate EOQ .(i.e.the optimalnumber of units per order). Please mention formulas and do it in detail so I can understand.
A producer of tires has an annual demand for a specific brand of tire. Theannual demand is 14,000. The cost of ordering these tires for the distributioncenter for each order is $1,200 per order. The annual holding cost is $8.50 pertire per year (in U.S. dollars): (In Excel with formulas)a What is the EOQ and the total annual cost at EOQ?b If the company decides to place more frequent orders, then theordering cost would increase to $1,800 per order. Nevertheless, the increasedfrequency of orders would decrease the annual holding cost to $6.50 per tireper year. Should the distribution center order tires more frequently?
Each year, Y Company purchases 20,000 units of an item that costs P 640 per unit. The cost of placing an order is P 480, and the cost to hold the item in inventory for one year is P 150. What is the average inventory level, assuming that the minimum inventory level is zero? 2.Determine the total annual ordering cost and the total annual holding cost for the item if the EOQ is used.
Please do not give solution in image formate thanku Ann Chovies, owner of the Perfect Pasta Pizza Parlor, uses 40 pounds of pepperoni each day in preparing pizzas. There are 300 working days in a year. Order costs for pepperoni are $10.00 per order, and carrying costs are $6 per pound per year. Lead time for each order is 5 days, and the pepperoni itself costs $5.00 per pound. If she were to order 80 pounds of pepperoni at a time, what would be the average inventory level? Round your answers to zero decimal digits. 35 pounds 60 pounds None of the other choices are correct 40 pounds 25 pounds 2) If she were to order 80 pounds of pepperoni at a time, what would be the length of an order cycle? Round your answers to zero decimal digits. None of the other choices are correct 2 days 4 days 3 days 0.4 days