The soft goods department of a large department store sells 175 units per month of a certain large bath towel. The unit cost of a towel to the store is $2.50 and the cost of placing an order has been estimated to be $12.00. The store uses an inventory carrying charge of 1 = 27% per year. Determine (a) the optimal order quantity, (b) the order frequency, and (c) the annual holding and setup cost. If, through automation of the purchasing process, the ordering cost can be cut to $4.00, what will be (d) the new economic order quantity, (e) the order frequency, and (f) annual holding and setup costs?

The soft goods department of a large department store sells 175 units per month of a certain large bath towel. The unit cost of a towel to the store is $2.50 and the cost of placing an order has been estimated to be $12.00. The store uses an inventory carrying charge of 1 = 27% per year. Determine (a) the optimal order quantity, (b) the order frequency, and (c) the annual holding and setup cost. If, through automation of the purchasing process, the ordering cost can be cut to $4.00, what will be (d) the new economic order quantity, (e) the order frequency, and (f) annual holding and setup costs?

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

The Great North Supermarket stocks Munchkin Cookies. Demand for Munchkins is 5000 boxes per year (365 days). It costs the store $60 per order of Munchkins, and it costs $0.70 per box per year to keep the cookies in stock. Once an order for Munchkins is placed, it takes four days to reveive the order from a food distributor. Determine the following: a. Optimal order size (EOQ) b.Minimum total annual inventoy cost c. Reorder point (R) d. Number of orders e. Time between orders
An appliance store sells microwaves at a steady rate throughout the year. Each microwave costs the store $75 per unit, with an annual holding cost of 20%. Every time the store places an order for microwaves, they incur a $210 fixed cost for administrative and shipping costs (independent of the number of units ordered). Each microwave sits in the store's inventory for an average of two weeks (assuming 52 weeks in a year). If the store uses an optimal order quantity, what is the store's yearly demand for microwaves?
Consider the coffeehouse discussed below. Suppose that its setup cost for ordering was really only $15. Determine the error made in calculating the annual cost of holding and setup incurred as a result of its using the wrong value of K. (Note that this implies that its current order policy is suboptimal.) A specialty coffeehouse sells Colombian coffee at a fairly steady rate of 280 pounds annually. The beans are purchased from a local supplier for $2.40 per pound. The coffeehouse estimates that it costs $45 in paperwork and labor to place an order for the coffee, and holding costs are based on a 20 percent annual interest rate.
A Mercedes dealer purchases vehicles for $20,000. The annual holding cost is estimated to be 25% of the dollar value of inventory. The dealer sells an average of 500 cars per year. He believes that demand is backlogged, but estimates that if he is short one car for one year, he will lose $20,000 in future profits. Each time the dealer places an order for cars, the ordering cost amounts to $10,000. What is the (s, Q) ordering policy that results in a 90% CSL?
A company has an annual demand of 2500 units. The cost to place an order to replenish inventory is SR18.75 per order, and annual inventory holding cost per unit is SR1.5. On average, delivery of an order takes 3 working days (Lead time). Assume the store is open 250 days per year. What is the optimal order size? What is the optimal number of orders per year? What is the optimal number of days between orders? What is the Reorder Point (ROP)? What is the Reorder Point (ROP) with 2 days safety stock.
Rocky Mountain Tire Centre sells 20,000 tires of a particular type per year. The ordering cost for each order is $40, and the holding cost is 20% of the purchase price of the tires per year. The purchase price is $20. per tire if fewer than 500 tires are ordered, $18. Per tire if more than 500 but fewer than 1,000 tires are ordered and $17. per tire if 1,000 or more tires are ordered. How many tires should Rocky Mountain order each time it places an order? Quantity Unit Price 1-499 $20. 500-999 $18. 1000 & over $17 Based on available information, lead time demand for CD-ROM drives averages 50 units (normally distributed), with a standard deviation of 5 drives. Management wants a 97% service level. What value of Z should be applied? How many drives should be carried as safety stock?
Hal Itosis is a candy wholesaler. He purchases cases of Altoids mints from a distributor at $20 each and pays a fixed $2,420 shipping and handling charge per order. The total lead time from the distributor is 3 weeks. Assume an annual rate of 30% for inventory carrying charges and 50 weeks per year. Weekly demand is normally distributed with a mean of 3,000 cases and a standard deviation of 124 cases. Assume full backorders. What is the optimal order quantity? Suppose that Hal Itosis' optimal service level is 99% What is the optimal reorder point?
At sejahtera.com, a large retailer of popular books, demand is constant at 32,000 books per year. The cost of placing an order to replenish stock is $10, and the annual cost of holding is $4 per book. Stock is received five working days after an order has been placed. The backordering is not allowed. Assume 300 working days a year. a. calculate sejahtera.com’s optimal order quantity. b. calculate the optimal number of orders per year c. Calculate the optimal interval (in working days) between orders. d. Determine the demand during the lead time. e. Determine the reorder point. f. Determine the inventory position immediately after an order has been placed. g. Draw the model to represent the case.
The manager of a depanneur on Ste-Catherine’s street sells 5 cases of Corona per day. The order costs are $20 per order, Corona beers cost $15 per 12-pack, and each cash contains 6 12-packs. Orders arrive four days after they are placed, and the daily holding cost is 5% of the cost of the case. Assuming the stores supplier will give a 10% discount on orders exceeding 20 cases, how units should the manager order each time?
Cynthia Knott's oyster bar buys fresh Louisiana oysters for $5 per pound and sells them for $9 per pound. Any oysters not sold that day are sold to her cousin, who has a nearby grocery store, for $3 per pound. Cynthia believes that demand follows the normal distribution, with a mean of 100 pounds and a standard deviation of 14 pounds. How many pounds should she order each day? Refer to the standard normal table LOADING... for z-values. Part 2 Cynthia should order enter your response here pounds of oysters each day (round your response to one decimal place).
Helen needs 1159 kgs of chicken per day on average to make enchiladas for her store. The supplier charges a $67 delivery fee per order (which is independent of the order size) and $3.90 per kg. Helen’s annual holding cost is 20%. Assume 52 weeks per year and 7 days per week. If Helen wants to minimize inventory holding and ordering costs, how much chicken should she purchase with each order (in kgs)? Provide your answer as an integer value.Use Econimic Order Quantity formula. The answer is 8,513. Not sure how to get there.
Nationwide Auto Parts uses a periodic review inventory control system for one of its stock items. The review interval is 6 weeks, and the lead time for receiving the materials ordered from its wholesaler is 3 weeks. Weekly demand is normally distributed, with a mean of 100 units and a standard deviation of 20 units.a. What is the average and the standard deviation of demand during the protection interval?b. What should be the target inventory level if the firm desires 97.5 percent stockout protection?c. If 350 units were in stock at the time of a periodic review, how many units should be ordered?