The Tiernan Gallery and Art Museum distributes to its visitors a printed guide to its collections. There are about 18000 visitors per year. Holding costs for the brochures are 20% and it costs $30 to place an order with the printer. The printer has offered the following discount schedule: Category Order Size Unit Cost 1 0-1499 $2.50 1500-2999 $2.20 3 3000 and over $1.80 Make a Quantity Discount table. How many brochures should be printed at a time?

The Tiernan Gallery and Art Museum distributes to its visitors a printed guide to its collections. There are about 18000 visitors per year. Holding costs for the brochures are 20% and it costs $30 to place an order with the printer. The printer has offered the following discount schedule: Category Order Size Unit Cost 1 0-1499 $2.50 1500-2999 $2.20 3 3000 and over $1.80 Make a Quantity Discount table. How many brochures should be printed at a time?

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 14P

See similar textbooks

Similar questions

BIKO is a bike retailer located in the outskirts of Paris. BIKO purchases bikes from PMX in orders of 250 bikes which is the current economic order quantity. PMX is now offering the following bulk discounts to its customers: 2% discount on orders above 200 units 4% discount on orders above 500 units 6% discount on orders above 600 units BIKO is wondering if the EOQ model is still the most economical and whether increasing the order size would actually be more beneficial. Following information is relevant to forming the decision: Annual demand is 5000 units Ordering cost is $100 per order Annual holding cost is comprised of the following: 5% insurance premium for the average inventory held during the year calculated using the net purchase price Warehousing cost of $6 per unit Purchase price is $200 per unit before discount (Hint: We need to compare the total inventory cost of the order quantities at the various discount levels with that of the economic order quantity)
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.
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?
Petromax Enterprises uses a continuous review policy to manage the inventory for one of its SKUs. The following information is available on the item. The firm operates 50 weeks in a year. Demand = 90,000 units/year Ordering Cost = $60/Order Holding Cost = $3/Unit/Order Lead Time = 10 weeks Standard Deviation of Weekly Demand = 200 units Suppose due to some recent changes to the target service level, they have determined the reorder point to be 20,000. If the inventory position of this SKU is currently 19,600, how many units should they order? (Round your answer to the nearest whole number, if it has decimals. Input 0 if they should not order now.)
GM Electronics expects to sell 800 alarm systems each month of 2022 at R4 000 each. The cost price of eachalarm system is R2 000. The inventory holding cost of an alarm system is 1% of the unit cost price. The cost ofplacing an order for the alarm systems is estimated at R60. Calculate the annual economic order quantity from the information provided below.
The manager of a large electronics store wants to begin stocking a universal TV remote control device. Expected daily demand is 25 units (250 working days a year). The remote controls can be purchased from either supplier A or supplier B. Their price lists are as follows: Supplier A Supplier B Quantity Unit price Quantity Unit price 1-199 $14 1-149 $14.1 200-499 $13.8 150-349 $13.9 500+ $13.6 350+ $13.7 Ordering cost is $40 per order and annual holding cost is 25 percent of unit price. Lead time for either supplier is 10 days. Which supplier should be chosen and what kind of inventory ordering policy should be adopted?
Calculate the annual economic order quantity from the information provided below. INFORMATIONGM Electronics expects to sell 800 alarm systems each month of 2022 at R4 000 each. The cost price of eachalarm system is R2 000. The inventory holding cost of an alarm system is 1% of the unit cost price. The cost ofplacing an order for the alarm systems is estimated at R60.
Please do not give solution in image format thanku 12. Vintage-looking art replicas are delivered to an art store once a year. The reorder point for the pieces without safety stock is 200 pieces. The carrying cost is $30 per unit per year, and the cost of a stockout is $70 per chair per year. Given the following demand probabilities during the lead time, how much safety stock should be carried? Demand: 0 100 200 300 400 Probability: 0.2 0.2 0.2 0.2 0.2
ITEMS 18 to 20 ARE BASED ON THE FOLLOWING INFORMATION: The following information pertains to Emy Manufacturing Corporation's Product X: Annual demand 33,750 units Annual cost to hold one unit of inventory P15 Setup cost (or the cost to initiate a production run) P500 Beginning inventory of product X 0 At present, the Company produces 2,250 units of Product X per production runt for a total of 15 production runs per year. The company is considering to use the EOQ model to determine the economic lot size and the number of production runs that will minimize the total inventory carrying cost and setup cost for Product X. At present, the company's total annual inventory costs is P 7,500. c. P24,375. P16,875. d. P22,500.
Glorious Gadgets is a retailer of astronomy equipment. They purchase equipment from a supplier and then sell it to customers in their store. The function C(x)=1.5x+12500x^−1+5000 models their total inventory costs (in dollars) as a function of x the lot size for each of their orders from the supplier. The inventory costs include such things as purchasing, processing, shipping, and storing the equipment.A) What lot size should Glorious Gadgets order to minimize their total inventory costs? (NOTE: your answer must be the whole number that corresponds to the lowest cost.) B) What is their minimum total inventory cost?
Penalty costs can be assessed only against the number of units of demand that cannot be satisfied, or against the number of units weighted by the amount of time thatan order stays on the books. Consider the following history of supply and demandtransactions for a particular part:Number of Items Demand duringMonth Received MonthJanuary 200 520February 175 1,640March 750 670April 950 425May 500 280June 2,050 550Assume that starting inventory at the beginning of January is 480 units.a. Determine the ending inventory each month. Assume that excess demands areback-ordered.b. Assume that each time a unit is demanded that cannot be supplied immediately,a one-time charge of $10 is made. Determine the stock-out cost incurred duringthe six months (1) if excess demand at the end of each month is lost, and (2) ifexcess demand at the end of each month is back-ordered.c. Suppose that each stock-out costs $10 per unit per month that the demandremains unfilled. If demands are filled on a first-come,…
The Bucks Grande exhibition baseball team plays 50 weeks each year and uses an average of 350 baseballs per week. The team orders baseballs from Coopers-Town, Inc., a ball manufacturer noted for six-sigma–level consistency and high product quality. The cost to order baseballs is $100 per order and the annual holding cost per ball is 38 percent of the purchase price. Coopers-Town’s price structure is: Order Quantity Price per Unit 1–999 ........ $7.50 1,000–4999 ...... $7.25 5,000 or more ..... $6.50 a. How many baseballs should the team buy per order? b. What is the total annual cost associated with the best order quantity? c. Coopers-Town, Inc., discovers that, owing to special manufacturing processes required for the Buck’s base-balls, it has underestimated the setup time required on a capacity-constrained piece of machinery. Coopers-Town adds another category to the price structure to provide an incentive for larger orders and thereby hopes to reduce…