An electronic store sells 1100 model X computers annually. Annual carrying cost is 12% of the unit cost. Order cost is $80. The lead time for receiving computers is 5 days. The supplier offers discounted prices for the store based on order quantity as given below: Order quantity (Q) Unit Price ($) Q < 50 440 50 <=Q <75 420 75 <= Q < 99 400 Q >= 100 390 Give your answers to two decimal places. Find the minimum cost order quantity at price level $400 Find the optimal order quantity Find the annual ordering cost for optimal order quantity

An electronic store sells 1100 model X computers annually. Annual carrying cost is 12% of the unit cost. Order cost is $80. The lead time for receiving computers is 5 days. The supplier offers discounted prices for the store based on order quantity as given below: Order quantity (Q) Unit Price ($) Q < 50 440 50 <=Q <75 420 75 <= Q < 99 400 Q >= 100 390 Give your answers to two decimal places. Find the minimum cost order quantity at price level $400 Find the optimal order quantity Find the annual ordering cost for optimal order quantity

Name: An electronic store sells 1100 model X computers annually. Annual carr
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: An electronic store sells 1100 model X computers annually. Annual carrying cost is 12% of the unit cost. Order cost is $80. The lead time for receiving computers is 5 days. The supplier offers discounted prices for the store based on order quantity a

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.4: Simulation With Built-in Excel Tools

Problem 15P

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
Vallie Enterprise sells a product that cost $200 per unit and has a monthly demand of 500 units. The annual holding cost per unit is calculated as 2% of the unit purchase price. It costs the business $30 to place a single order. The maximum number of units sold for any one week is 150 and minimum sales 80 units. The vendor takes anywhere from 2 to 4 weeks to deliver the merchandise after the order is placed. The EOQ model is appropriate. i) What is the cost minimizing solution for this product each year? ii) Determine the re-order level, minimum inventory level and maximum inventory level for the product.
ANT Infra orders two kinds of precast items: A and B for use in its projects from two different suppliers. The precasts are needed throughout the entire 52-week year. Precast A are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. While, precast B is ordered from a supplier who delivers by every three weeks. Data for both precast items are as follows:Item Precast A Precast BAnnual demand 10,000 5,000Holding cost (% of item cost)20% 20%Order cost $150 $25Lead time 4 weeks 1 weekSafety stock 55 units 5 unitsItem cost $10.00 $2.00 a. Employ Q system for precast A and calculate the EOQ, the reorder point, total inventory cost? b. Employ P system for precast B and estimate the target level inventory and total inventory cost?
E - Max uses the basic EOQ model to determine the order quantity . They used to buy electronics from a Korean supplier in Dubai with a lead - time of 5 days . Recently , the supplier has decided to close the warehouse in Dubai and deliver all items from Korea directly to customers in Oman with a lead time of 10 days . Under this situation , the economic order quantity will (Q^ * ) 1)double 2)None of these 3)increase , but not double 4)decrease by a factor of two 5)do remain the same
Long last Appliance Store has a demand of 1300 units per month for one of its fast selling portable smoothie machine (model G), it incurs a fixed order placement, transportation and receiving cost of $3000 each time an order is delivered. Each machine cost the company $550 and the company has a holding cost of 12%. The company has two other models of the smoothie machine which are also popular with consumers. Evaluate the company’s inventory management policy if lots for each model are ordered and delivered independently by determining the following: The optimal order size The cycle inventory The number of orders per year The annual ordering and holding cost The total cost of the inventory Briefly state rationale for the approach used for (a-e)
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. 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?
The "Footcandy" shoes store supplies men's black formal shoes. Every 3 months the "Footcandy" shoes store can sell approximately 500 pairs of shoes at a constant price. The store is currently ordering 500 everytime they order. It costs $ 30 to place the order. 20% is the annual rate for the storage fee. With an order of 500 pairs of shoes, the store got the lowest price at $ 28 per pair. The order quantity discounts offered by the manufacturer are as follows Quantity Price 1 0-99 $36 2 100-199 $32 3 200-299 $30 4 300 $28 a. What is the minimum cost order amount for the shoes? b. What is the annual savings from Footcandy Store?
A confectioner buys plastic boxes in bulk and uses them to pack chocolates. The annual requirement of these boxes is 1,200, and each box costs $30. The ordering and carrying costs are $10 per order and 20%, respectively. The supplier from whom the confectioner purchases these boxes sells them only in lots of 25, that is, you only purchase quantities in multiples of 25 boxes. If the supplier offers 2% discount on the cost of each box when the purchases are in quantities of 300 at a time, should the confectioner accept this offer?
The materials manager of a tire manfacturer must predict periodically place order for a key chemical one of the raw materials used in manufacturing uses the chemical at a rate of 300lbs each week and the lead time of delivery is 4 days. Assume that the manufacturing operation runs 5 days a week. At what point should the chemical be reorderedd a. when 1200lbs are remaining b. where 0lbs are remaining c. where 375lbs are remaining d. when 240lbs are rem
ABC firm uses roughly 3,400 pounds of chemical dye a year. Currently, the firm purchases 300 pounds per order and pays P120.00 per pound. The supplier has just announced that orders of 1,000 pounds or more will be filled at a price of P80.00 per pound. The manufacturing firm incurs a cost of P4,000.00 each time it submits an order and assigns an annual holding cost of 17% of the purchase price per pound. a. Determine the order size that will minimize the total cost.b. If the supplier offered the discount at 1,500 pounds instead of 1,000 pounds, what order size would minimize total cost?
A phone retailer buys three phone models from the same supplier. The retailer pays per unit cost of each product of $100, $120 and $150 for the three models. The supplier charges $200 per order, independent of the quantity and models of the products purchased, which includes the cost of order processing, shipping and insurance. Holding costs are based on a 25 percent annual interest rate. The retailers sells an average of 35,000, 30,000 and 25,000 units of the three models, respectively. a) Analytically, i.e. without the use of a computer, provide a heuristic for the three-product ordering decision. b) Find the optimal procurement decision numerically
A company is using a continuous review system for its inventory. Due to the contracts made with the customers, the weekly demand is constantly 40 units. The average lead time of orders is 2 weeks and the standard deviation of lead time is 1 week. The current service level is 95%. In order to reduce inventory holding costs, the company wants to reduce its reorder point. To achieve this, there are two options that have approximately the same cost for the company: reduce the standard deviation of lead time to 0.5 weeks or reduce the service level to 90%. A) Which option is more advantageous for the company? B) How much reduction does this option bring in the reorder point as opposed to the current situation? Show your calculations