4. Quantity Discount Model Unitex, the manufacturer of clear cosmetic boxes in problem (2), consumes 379 rolls of PVC sheets annually. Ordering costs are P510 and canrying costs are P150 per roll a year. Given the following infomation, determine the optimal order quantity and the total cost. Range 1 to 49 Price 620 50 to 79 480 80 to 99 340 100 or more 210

4. Quantity Discount Model Unitex, the manufacturer of clear cosmetic boxes in problem (2), consumes 379 rolls of PVC sheets annually. Ordering costs are P510 and canrying costs are P150 per roll a year. Given the following infomation, determine the optimal order quantity and the total cost. Range 1 to 49 Price 620 50 to 79 480 80 to 99 340 100 or more 210

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

Maira Hijab Enterprise (MHE) is a supplier that sells Exclusive Embroidery Silk Hijabs to boutique and online resellers. The annual demand is approximately 360 hijabs. MHE pays RM50 for each hijab and estimates that the annual holding cost is 2 percent of the hijab's value. It costs approximately RM100 to place an order (managerial and clerical costs). Required: Determine the economic order quantity (EOQ) (Round up your answers to the nearest figure). а. b. Assuming a 300-day work year, how many orders should be processed per year and what is the expected time between orders? С. Calculate the total cost for the order. d. After several months of the introduction of the Exclusive Hijab, MHE decides to all costs related to their product due to the increment of hijab’s costs by the supplier. MHE currently orders 1000 hijabs per month. The new information as regards to the Exclusive Hijab is as follows: i. The ordering cost for these is RM100 per order and ii. The carrying cost is assumed…
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?
Howard BooksLynelle Howard owns a thriving independent bookstore in artsy New Hope,Pennsylvania. She must decide how many copies to order of a new book, Powerand Self-Destruction, an exposé on a famous politician’s lurid affairs. Interest inthe book will be intense at first and then fizzle quickly as attention turns to othercelebrities.The book’s retail price is $27 and the wholesale price is $19. The publisher willbuy back the retailer’s leftover copies at a full refund, but Howard Books incurs $5in shipping and handling costs for each book returned to the publisher.Lynelle believes her demand forecast can be represented by a normal distributionwith a mean of 310 and a standard deviation of 100.
1. Calculate Economic Order Quantity (EOQ), number of orders, annual ordering costs, annual carrying costs  and total inventory costs from the following: Annual consumption: 6000 units ; Cost of placing one Order: RO 60 Carrying cost per unit: RO 22. Find out the EOQ, Annual ordering cost and annual holding cost from the following information. The demand  is 19500 units per year, holding cost is RO 4 per unit for a year and ordering cost is RO 25 order. 3. Find out the ordering cost from the following information, Annual demand is 240 units, holding cost RO 4 per  unit for a year and EOQ is 60 units.
The annual demand, ordering cost, and the annual inventory carrying cost rate for a certain item are 600 units, Quantity 1 to 49 50 to 249 250 and up Price $5.00/unit $4.50/unit $ 4.10/unit $20/order and 30% of item price, respectively. (a) Assume the discounts applied to all the units in the order, what should the order quantity be in order to minimize the average annual cost? Also, show the minimal average annual cost.    (b) Assume the discounts applied to the units are incremental, what should the order quantity be in order to minimize the average annual cost? Also, show the minimal average annual cost.
A material manager adopts the policy to place an order for a minimum quantity of 500 of a particular item in order to avail a discount of 10 percent. It was found from the company records that for last year 8 orders were placed each of size 200 Nos, ordering cost is ksh 500 per order. Inventory carrying charges at 40 per cent cost unit is ksh 400. (a) Show whether the purchase manager is justified in his decision    (b) What is the effect of this decision on the company
A large distributor of oil-well drilling equipment operated over the past two years with EOQ policies based on an annual holding cost rate of 22%. Under the EOQ policy, a particular product has been ordered with a Q* 80. A recent evaluation of holding costs shows that because of an increase in the interest rate associated with bank loans, the annual holding cost rate should be 27%. a. What is the new economic order quantity for the product? b. Develop a general expression showing how the economic order quantity changes when the annual holding cost rate is changed from I to I
A company has an annual demand for a specific item of 12,000 units. The carrying cost per unit per year is R.50, and the cost to place an order is R80. Calculate the Economic Order Quantity (EOQ) and also explain the following related terms • Re-order Level, • Ordering Point, • and Minimum Level.
The maintenance department of a large hospital uses about 816 cases of liquid cleanser annually. Ordering costs are $12, carrying costs are $4 per case a year, and the new price schedule indicates that orders of less than 50 cases will cost $20 per case, 50 to 79 cases will cost $18 per case, 80 to 99 cases will cost $17 per case, and larger orders will cost S16 per case. Determine the optimal order quantity and the total cost Show your result on diagram with order quantity on X axis and cost on Y axis.
If the following data is known in determining the Quantity Discount with EOQ - Demand rate = 100.000 - Ordering Cost = 5000 - Holding/Carrying cost = 600 Price Range LOWER UPPER PRICE 1 1 1000 1000 2 1001 1500 900 3 1501 3000 800 4 3001 3500 700 5 3501 3750 650 6 3751 4000 600 Based on the data provided, determine the optimal order quantity and total cost for this case! 2 1001 1500 900 3 1501 3000 800 4 3001 3500 700 5 3501 3750 650 6 3751 4000 600
.. 12.41 Barbara Flynn is in charge of maintaining hospital supplies at General Hospital. During the past year, the mean lead time demand for bandage BX-5 was 60 (and was normally distributed). Furthermore, the standard deviation for BX-5 was 7. Ms. Flynn would like to maintain a 90% service level. a) What safety stock level do you recommend for BX-5? b) What is the appropriate reorder point? PX ..12.42 Based on available information, lead time demand for PC jump drives averages 50 units (normally distributed), with a stand- ard deviation of 5 drives. Management wants a 97% service level. a) What value of Z should be applied? b) How many drives should be carried as safety stock? c) What is the appropriate reorder point? Px ... 12.43 Authentic Thai rattan chairs (shown in the photo) are delivered to Gary Schwartz's chain of retail stores, called The Kathmandu Shop, once a year. The reorder point, without safety stock, is 200 chairs. Carrying cost is $30 per unit per year, and the cost…
Based on an EOQ-type ordering criterion, what costmust be taken to zero if the desire is to have an orderquantity of a single unit?