What is the total annual cost of purchasing 78 units per order (purcha

Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 112, 500 units per year, an ordering cost of $3 per order, and carrying costs of $1.20 per unit. a. What is the economic ordering quantity? b. How many orders will be placed during the year? c. What will the average inventory be? d. What is the total cost of ordering and carrying inventory?

Problem 20-30 (Algo) It is your responsibility, as the new head of the automotive section of Nichols Department Store, to ensure that reorder quantities for the various items have been correctly established. You decide to test one Item and choose Michelin tires, XW size 185 x 14 BSW. A perpetual inventory system has been used, so you examine this, as well as other records, and come up with the following data: Cost per tire Holding cost Demand Ordering cost Standard deviation of daily demand Delivery lead time Order quantity $ tires 50 each percent of tire cost per year Because customers generally do not wait for tires but go elsewhere, you decide on a service probability of 90 percent. Assume the demand occurs 365 days per year. a. Determine the order quantity. (Round your answer to the nearest whole number.) 15 1,100 per year $ 22 per order 4 tires 5 days

weekly demand for  hamleys  (a  famous toy brand) at a  toy store is  normally disrtibuted with a mean of  250 and a  standrd  devaiton of 150.Ther  toy store is  opened 7 days   a week.The  toy  store owner  continoulsy monitors  the  inventory  .Hamleys  takes  2 weeks to fill an order  with a standard  devaiton of 4  days. 1] how much inventory  should the sotre  carry  at the  reorder  point. 2] how much inventory would that be at the  reorder point if the cycle  service  was  increased to  98%?

Can someone please help me with the folowing problems on excel with the formulas. Thank you

The materials manager for a billiard ball maker must periodically place orders for resin, one of the raw materials used in producing billiard balls. She knows that manufacturing uses resin at a rate of 50 kilograms each day, and that it costs $.04 per day to carry a kilogram of resin in inventory. She also knows that the order costs for resin are $100 per order, and that the lead time for delivery is four days. If the order size was 1,000 kilograms of resin, what would be the average inventory level?

Reorder Point Ordering: Average daily demand ( d) is 5 units with a std. dev. (od) of 1 unit. Average lead time ( LT) is 24 days with a std. dev. (OLT) of 1 day. The inventory manager wants to operate within 3 std. deviations (z = 3). Find the reorder point (ROP) and safety stock (S). ROP=141, SS=120 ROP=141, SS=21 ROP=120, SS=21 ROP=21, SS=141

Palin's Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or order-up-to level). $ 35 Ordering cost Service probability Lead time per order 2,970 6. mufflers Annual demand Standard deviation of daily demand mufflers per working day 89 % working days per muffler * of item value working days $21.00 4 Item cost 36 Working days 270 per year Annual holding cost Review period 22 a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV) function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Optimal target level b. If the service probability requirement is 90 percent, the optimal target level will: O Increase O Decrease O Stay…

Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 97,200 units per year, an ordering cost of $4 per order, and carrying costs of $1.50 per unit. What is the economic ordering quantity? How many orders will be placed during the year? What will the average inventory be? What is the total cost of ordering and carrying inventory?

Discount-Mart, a major East Coast retailer, wants todetermine the economic order quantity (see Chapter 12 for EOQformulas) for its halogen lamps. It currently buys all halogenlamps from Specialty Lighting Manufacturers in Atlanta. Annualdemand is 2,000 lamps, ordering cost per order is $30, and annualcarrying cost per lamp is $12. a) What is the EOQ?b) What are the total annual costs of holding and ordering(managing) this inventory?c) How many orders should Discount-Mart place with SpecialtyLighting per year?