David Austin recently purchased a chain of dry cleaners in northern Wisconsin. Although the business is making a press, he could recognize a substantial increase in profits. The new press costs $15,400 to purchase and install and can press 40 shirts an hour (or 320 per day). David estimates that with the new press, it will cost $0.25 to launder and press each shirt. Customers are charged $1.10 per shirt. a. How many shirts will David have to press to break even? b If David cuts his price to $0.99 a shirt, he expects to be able to stabilize his customer base at 250 shirts per day. How long would it take to break even at the reduced price of $0.99? Should David cut his price and buy the new press?

David Austin recently purchased a chain of dry cleaners in northern Wisconsin. Although the business is making a press, he could recognize a substantial increase in profits. The new press costs $15,400 to purchase and install and can press 40 shirts an hour (or 320 per day). David estimates that with the new press, it will cost $0.25 to launder and press each shirt. Customers are charged $1.10 per shirt. a. How many shirts will David have to press to break even? b If David cuts his price to $0.99 a shirt, he expects to be able to stabilize his customer base at 250 shirts per day. How long would it take to break even at the reduced price of $0.99? Should David cut his price and buy the new press?

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.
An orthopedic physician group practice uses 12cc syringes from Sherwood for their cortisone injections. During the each of last two years, 40000 of them were used in the office. Each syringe costs $1.50. The physician’s office annually discards, on average, 500 of the syringes that have became inoperable (broken, wrong injection material, lost). The syringes are stored in a room that occupies 2% of the storage area. The storage area constitutes 10% of the leased space. The annual office lease costs $60,000. The group practice can secure loans from a local bank at 6% interest to purchase the syringes. For each placed order, it takes about three hours for an office assistant (whose hourly wage is $9.00 and who receives $3.25 in fringe benefits) to prepare, and communicate the order, and place its shipment in storage. In addition, each order’s overhead share of equipment and supplies (phone, fax, computer, stationary paper) is approximately $4.50. In the past, the office assistant always…
There are four fare classes on a flight with the following rates: Y: $800 B: $500 M: $350 T: $200 The EMSR of the next seat is $425. According to EMSRa, what is the lowest fare class open? Y M T B
Smith Inc. is a retail mail order firm that currently uses a centralized collection system that requires all checks to be sent to its flotation headquarters. An average of 6 days is required for mailed checks to be received, 3 days for Smith Inc. to process them, and 2 days for the checks to clear through its bank. A proposed lockbox system would decrease the mailing and processing time to 2 days and the check clearing time for 1 day. Smith Inc. has an average daily collection of P250,000. If Smith Inc. adopts this proposed lockbox system, its average cash balance will increase by. A. 1.2M B. 450k C. 750k D. 2M
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…
Jays Office Supplies sells Printers, which it orders from Brands mart Inc in . Because of shipping and handling costs, each order must be for 5 printers. Because of the time it takes to receive an order, the company places an order every time the present stock drops to 5 Printers. It costs $50 to place an order. It costs the company $500 in lost sales when a customer asks for a Printer and the warehouse is out of stock. It costs $100 to keep each Printer stored in the warehouse. If a customer cannot purchase a Printer when it is requested, the customer will not wait until one comes in but will go to a competitor. The following probability distribution for demand for Printer has been determined: Questions 1.Simulate CWD 's ordering and sales policy for 20 weeks 2. Compute the average cost of the policy PLEASE NOTE I SENT THIS IN ALREADY BUT I REALIZED I LEFT OUT SOME VITAL INFORMATION AND AGAIN THIS IS NOT FROM ANOTHER SITE.
(Southern Fresh) Shelf space in the grocery business is a valuable asset. Every good supermarket spends a significant amount of effort attempting to determine the optimal shelf space allocation across products. Many factors are relevant to this decision: the profitability of each product, the size of each product, the demand characteristics of each product, and so forth. Southern Fresh has decided to make a policy that every product will receive enough shelf space to ensure that 98.75 percent of customers will find that their first choice is available. Consider Hot Bull corn chips, a local favorite. Average daily demand for this product is 55, with a standard deviation of 30. Bags of Hot Bull can be stacked 20 deep per facing. (A facing is the width on a shelf required to display one item of a product.) Deliveries from Southern Fresh’s central warehouse occur two days after a store manager submits an order. (Actually, in most stores, orders are generated by a centralized computer…
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…
JokersRWild makes playing cards in several different styles, but a “standard” deck of cards is used for planning purposes. The average worker at JokersRWild can make 10,000 sets of decks of cards per month at a cost of $3.40 per deck during regular production and $3.70 during overtime. The company currently employs 35 workers. Experience shows that it costs $1,700 to hire a worker and $1,700 to fire a worker. Inventory carrying cost is $.49 per deck per month. The beginning inventory is 54,000, and at least that amount is desired each month. Assume hiring and layoff/firing, if necessary, occur at the beginning of the month. Month January February March April May June Demand 200,000 240,000 200,000 530,000 540,000 870,000 e. Develop a six-month production plan based on chase by changing workforce level. (Leave no cells blank - be certain to enter "0" wherever required.) Chase Production Plan – Changing Workforce Level Month Demand Regular Production Ending…
Mytown’s street department repaves a street every 8 years. Potholes cost $15,000 per mile beginning at the end of Year 3 after construction or repaving. The cost to fix potholes generally increases by $15,000 each year. Repaving costs are $200,000 per mile. Mytown uses an interest rate of 8%. What is the EUAC for Mytown’s policy? What is the EUAC for the optimal policy? What is the optimal policy?The plant manager may purchase a piece of unusual machinery for $10,000. Its resale value after 1 year is estimated to be $3000. Because the device is sought by antique collectors, resale value is rising $500 per year.
Western Chassis produces high-quality polished steel and aluminum sheeting and two lines ofindustrial chassis for the rack mounting of Internet routers, modems, and other telecommunicationsequipment. The contribution margin (contribution toward profit) for steel sheeting is $0.40 per poundand for aluminum sheeting is $0.60 per pound. Western earns $12 contribution on the sale of aStandard chassis rack and $15 contribution on a Deluxe chassis rack. During the next productioncycle, Western can buy and use up to 25,800 pounds of raw unfinished steel either in sheeting or inchassis. Similarly, 20,400 pounds of aluminum are available. One standard chassis rack requires 16pounds of steel and 8 pounds of aluminum. A Deluxe chassis rack requires 12 pounds of each metal.The output of metal sheeting is restricted only by the capacity of the polisher. For the next productioncycle, the polisher can handle any mix of the two metals up to 4,000 pounds of metal sheeting. Chassismanufacture can be…
You own a wheat warehouse with a capacity of 20,000 bushels. At the beginning of month 1, you have 6,000 bushels of wheat. Each month, wheat can be bought and sold at the price per 1000 bushels given in the Table