State University must purchase 1100 computers fromthree vendors. Vendor 1 charges $500 per computerplus a total delivery charge of $5000. Vendor 2 charges$350 per computer plus a total delivery charge of$4000. Vendor 3 charges $250 per computer plus atotal delivery charge of $6000. Vendor 1 will sell theuniversity at most 500 computers, vendor 2, at most900, and vendor 3, at most 400. The minimum orderfrom any vendor is 200 computers. Determine how tominimize the cost of purchasing the needed computers.

State University must purchase 1100 computers fromthree vendors. Vendor 1 charges $500 per computerplus a total delivery charge of $5000. Vendor 2 charges$350 per computer plus a total delivery charge of$4000. Vendor 3 charges $250 per computer plus atotal delivery charge of $6000. Vendor 1 will sell theuniversity at most 500 computers, vendor 2, at most900, and vendor 3, at most 400. The minimum orderfrom any vendor is 200 computers. Determine how tominimize the cost of purchasing the needed computers.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

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
The Frist Corporation has the followinginternal controls related to inventory:1. Only authorized inventory warehousing personnel are allowed in inventory storageareas.2. All inventory products are stored in warehousing areas that are segregated fromother storage areas used to house equipment and supplies.3. All inventory held on consignment at Frist Corporation is stored in a separatearea of the warehouse.4. The inventory purchasing system only allows purchases from pre-approved vendors.5. The perpetual inventory system tracks the average number of days each inventoryproduct number has been in the warehouse.6. Microchips are embedded in each product and when inventory items are removedfrom the warehouse to shipping, radio-frequencies signal a deduction of inventoryto the perpetual inventory system.7. On a weekly basis, inventory accounting personnel take samples of inventoryproducts selected from the perpetual inventory system and verify that the inventoryis on-hand in the warehouse…
The Delta company uses three raw materials to make cakes. Delta is trying to reduce warehousing costs and establishes three policies to that end: i) The annual number of orders for all products must be at least 20 per contractual terms with transportation providers. ii) The average inventory in units must be a maximum of 1800. iii) Because the raw material is perishable, there can never be more than 2000 units in inventory of raw material 1. Raw material 2 has a maximum allowed of 1200 units and the raw material 3 can store maximum 400 units. The following table shows the product information: Materia Demanda Costos por unidad Costo por prima (u/año) ordenar ($) 2200 2 300 2 500 4 650 3 3000 10 100 Consider an interest rate of 10% per year. A) Formulate the problem as a mathematical programming model that minimizes the total annual cost. b) Represent the problem in a single equation including the constraints in terms of lambda c) Find the optimized batch sizes for the company's raw…
Pls help
Lindsay Electronics, a small manufacturer of electronic research equipment, has approximately 6,500 items in its inventory and has hired Joan Blasco-Paul to manage its inventory. Joan has determined that 9% of the items in inventory are A items, 34% are B items, and 57% are C items. She would like to set up a system in which all A items are counted monthly (every 18 working days), all B items are counted quarterly (every 61 working days), and all C items are counted semiannually (every 124 working days). How many items need to be counted each day? The total number of items that need to be counted each day is items (round your response to the nearest whole number).
Your firm uses a periodic review system for all SKUs classified, using ABC analysis, as B or C items. Further, it uses a continuous review system for all SKUs classified as A items. The demand for a specific SKU, currently classified as an A item, has been dropping. You have been asked to evaluate the impact of moving the item from continuous review to periodic review. Assume your firm operates 52 weeks per year; the item’s current characteristics are:Demand 1D2 = 15,080 units/yearOrdering cost 1S2 = $125.00/orderHolding cost 1H2 = $3.00/unit/yearLead time 1L2 = 5 weeksCycle@service level = 95 percentDemand is normally distributed, with a standard deviation of weekly demand of 64 units.a. Calculate the item’s EOQ.b. Use the EOQ to define the parameters of an appropriate continuous review and periodic review system for this item.c. Which system requires more safety stock and by how much?
A manufacturer of exercise equipment purchases the pulley section of the equipment from a supplier who lists these prices: less than 1,000, $5 each; 1,000 to 3,999, $4.95 each; 4,000 to 5,999,$4.90 each; and 6,000 or more, $4.85 each. Ordering costs are $50, annual carrying costs per unitare 40 percent of purchase cost, and annual usage is 4,900 pulleys. Determine an order quantitythat will minimize total cost.
Lindsay Electronics, a small manufacturer of electronic research equipment, has approximately 7,100 items in its inventory and has hired Joan Blasco-Paul to manage its inventory. Joan has determined that 9% of the items in inventory are A items, 39% are B items, and 52% are C items. She would like to set up a system in which all A items are counted monthly (every 19 working days), all B items are counted quarterly (every 60 working days), and all C items are counted semiannually (every 119 working days). How many items need to be counted each day? The total number of items that need to be counted each day is _______ items (round your response to the nearest whole number). To find the number of items counted per day for each class of items, use the following formula: Number of items counted per day=Inventoryx Percent of inventory/ Working days. Sum the number of items for each class to arrive at the total number of items that need to be counted each day.
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?
Lindsay Electronics, a small manufacturer of electronic research equipment, has approximately 6,900 items in its inventory and has hired Joan Blasco-Paul to manage its inventory. Joan has determined that 12% of the items in inventory are A items, 34% are B items, and 54% are C items. She would like to set up a system in which all A items are counted monthly (every 22 working days), all B items are counted quarterly (every 62 working days), and all C items are counted semiannually (every 123 working days). How many items need to be counted each day? The total number of items that need to be counted each day is _ items? (round response to the nearest whole number).
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
The GIIC -Company must determine a policy for ordering coal to operate 15 smelters. Each smelter requires exactly 5 tons of coal per day to operate, and the firm operates 360 days per year. The purchasing manager has negotiated a contract to obtain the coal for 5 BD per ton for the coming year. The purchasing manager has determined that the ordering cost is 40 BD per order, and the cost of holding coal is 20% per ton of its value. i. Determine the optimal quantity of coal to receive in each order. ii. Determine the total inventory-related costs associated with the optimal ordering policy (do not include the cost ii. If five days' lead time is required to receive an order of coal, how much coal should be on hand when an iv. Optimal quantity 1837.11 Tons, Total cost 1837.11 BD, Inventory during LT 275 Tons of the coal). order is placed? i. Optimal quantity 1469.694 Tons, Total cost 1469.694 BD, Inventory during LT 375 Tons ii. Optimal quantity 734.85 Tons, Total cost 1649.694 BD,…