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.

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.

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

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.
The Pizza Man is a local shop that plans to make all of its sales this Saturday from its sidewalk tables during the town’s holiday parade. On this occasion, the shop’s owners know that customers will buy by the slice and any kind of pizza offered will sell. The Pizza Man offers plain, meat, vegetable, and supreme pizzas. Each variety has its own requirement for sauce, cheese, dough, and toppings (in ounces, as shown in the table), and each has its own selling price. The Pizza Man expects to use its entire stock of ingredients and wishes to maximize revenue from its sales. What mix of pizzas should be made? Formulate and solve the problem (assume that fractions (1.2 Supreme Pizza, etc.) can be sold). Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Motorama TV estimates the annual demand for its TVsis (and will be in the future) normally distributed, with amean of 6,000 and standard deviation of 2,000. Motorama must determine how much production capacity it shouldhave. The cost of building enough production capacity tomake 1,000 sets per year is $1,000,000 (equivalent in presentvalue terms to a cost of $100,000 per year forever). Exclusiveof the cost of building capacity, each set sold contributes$250 to profits. How much production capacity shouldMotorama have?
Mark Whiskey needs to decide how many balloons to order for an upcoming citywide event. Because each store buys bottles whiskey from Mark's as a package of 500 and there are 3 potentially interested stores, demand will be 0, 500, 1000, or 1500. Mark has a decision to make: whether to order 0, 500, 1000, or 1500 units (bottles). Each unit costs Mark $6 and is sold for $10 to the stores. Any bottle that Mark does not sell will be donated. Enter in cell B8 a single formula that calculates total profit based on the inputs and intermediary inputs given. Note that profit depends not just on price and cost but also on number of bottles sold, which depends on both the order size (E5) and the demand (E4). Note that the demand and order size values of 0 in cells E5 and E4 are only there to construct a flexible profit formula (i.e., their values could be anything). Fill in the above two-way data table using Data/What-If-Analysis/Data Table. Use INDEX & MATCH functions to automatically return…
I need a detailed explanation and assistance to solve this problem: Wineco produces wine cooler as a blend of wine, grape juice and apple juice ingredients, which it sells for $4 per gallon. The costs of ingredients are given in the following table: Cooler Ingredient Price per Gallon ($) wines 1.20 grape juice 1.40 Apple juice 0.60 Wineco owns a blending plant with a production capacity of 200 gallons per day. Because the plant is fully automated, all other production costs are negligible by comparison to the cost of ingredients, and can be ignored. Government regulations mandate that wine cooler products must satisfy the following guidelines: At least 10% of the blend produced must be grape juice. The ratio of apple juice to grape juice in the blend produced must be 2.5:1 The blend produced must contain between 20% and 25% wine. Wineco wishes to use LP in order to determine the quantities of ingredients to buy for a day’s production of wine cooler, so…
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?
Ray wishes to determine the optimal order quantity for its best-selling bike in his bike store. Ray pays the supplier a wholesale price of $118 each for this bike. Ray has estimated the average daily demand for this bike is 23 units. The store opens 304 days a year. The cost to carry one bike in the store for a whole year is 8% of the unit bike cost. Ray has estimated that, on average, the order processing cost, i.e., ordering cost, with the bike supplier each time is $152, and it roughly takes 20 working days to receive the order from the supplier. Ray wishes to avoid the stock-out situation with a probability of 95%, and this requires Ray to carry a safety stock of 30 bikes in the store. What is the optimal order quantity (EOQ value) that Ray should order each time from the bike supplier to minimize his long-run inventory cost?
The maintenance department of a large hospital uses about 816 cases of liquid cleanserannually. Ordering costs are $12, carrying costs are $4 per case a year, and the new priceschedule indicates that orders of less than 50 cases will cost $20 per case, 50 to 79 caseswill cost $18 per case, 80 to 99 cases will cost $17 per case, and larger orders will cost $16per case. Determine the optimal order quantity and the total cost.
A manager receives a forecast for next year. Demand is projected to be 600 units for the first half of the year and 920 units for the second half. The monthly holding cost is $2 per unit, and it costs an estimated $55 to process an order. a.Assuming that monthly demand will be level during each of the six-month periods covered by the forecast (e.g., 100 per month for each of the first six months), determine an order size that will minimize the sum of ordering and carrying costs for each of the six-month periods. (Round your answers to the nearest whole number.) Period Order Size 1 – 6 months?_____units 7 – 12 months?_____units b.If the vendor is willing to offer a discount of $10 per order for ordering in multiples of 50 units (e.g., 50, 100, 150), would you advise the manager to take advantage of the offer in either period? If so, what order size would you recommend? (Round intermediate calculations to 2 decimal places.) Period Order Size 1 – 6 months?____ units 7 – 12 months?____…
You are in charge of purchases at the student-run used-book supply program at your college, and you must decide how many introductory calculus, history, and marketing texts should be purchased from students for resale. Due to budget limitations, you cannot purchase more than 700 of these textbooks each semester. There are also shelf-space limitations: Calculus texts occupy 2 units of shelf space each, history books 1 unit each, and marketing texts 5 units each, and you can spare at most 1,200 units of shelf space for the texts. If the used book program makes a profit of $20 on each calculus text, $8 on each history text, and $16 on each marketing text, how many of each type of text should you purchase to maximize profit?
A newspaper publisher uses roughly 880 feet of baling wire each day to secure bundles of newspapers while they are being distributed to carriers. The paper is published Monday through Saturday. Lead time is six workdays. What is the appropriate reorder point quantity, given that the company desires a service level of 95 percent, if that stockout risk for various levels of safety stock is as follows: 1,500 feet, .10; 1,900 feet, .05; 2,100 feet, .02; and 2,400 feet, .01?
A newspaper publisher uses roughly 800 feet of baling wire each day to secure bundles of newspapers while they are being distributed to carriers. The paper is published Monday through Saturday.Lead time is six workdays. What is the appropriate reorder point quantity, given that the companydesires a service level of 95 percent, if that stockout risk for various levels of safety stock is as follows: 1,500 feet, .10; 1,800 feet, .05; 2,100 feet, .02; and 2,400 feet, .01?