Due Tuesday October 16, 2012 1.1 Eastman publishing Company is considering publishing a paperback textbook on spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and production setup is estimated to be $80,000. Variable production and material costs are estimated to be $3 per book. Demand over the life of the book is estimated to be 4,000 copies. The publisher plans to sell the text to college and university bookstores for $20 each. a. What is the breakeven point? b. What profit or loss can be anticipated with a demand of 4,000 copies? c. With a demand of 4,000 copies, what is the minimum price per copy that the publisher must charge to break even? 1.2 Creative Sports Design (CSD) manufactures a standard-size racket and an oversize racket. The firm’s rackets are extremely light due to the use of a magnesium-graphite alloy. Each standard-size racket uses 0.125 kilograms of the alloy and each oversize racket uses 0.4 kilograms; over the next two-week production period only 80 kilograms of the alloy are available. Each standard-size racket uses 10 minutes of manufacturing time and each oversize racket uses 12 minutes. Also, 40 hours of manufacturing time are available each week. The profit contributions are $10 for each standard-size racket and $15 for each oversize racket. How many rackets of each type should CSD manufacture over the next two weeks to maximize the total profit contribution? a. Define decision variables and formulate the problem. b. Solve the problem using the graphical method. 1.3 Management of High Tech Services (HTS) would like to develop a model that will help allocate their technician’s time between service calls to regular contract customers and new customers. A maximum of 80 hours of technician time is available over the two-week planning period. To satisfy cash flow requirements, at least $800 in revenue (per technician) must be generated during
Due Tuesday October 16, 2012 1.1 Eastman publishing Company is considering publishing a paperback textbook on spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and production setup is estimated to be $80,000. Variable production and material costs are estimated to be $3 per book. Demand over the life of the book is estimated to be 4,000 copies. The publisher plans to sell the text to college and university bookstores for $20 each. a. What is the breakeven point? b. What profit or loss can be anticipated with a demand of 4,000 copies? c. With a demand of 4,000 copies, what is the minimum price per copy that the publisher must charge to break even? 1.2 Creative Sports Design (CSD) manufactures a standard-size racket and an oversize racket. The firm’s rackets are extremely light due to the use of a magnesium-graphite alloy. Each standard-size racket uses 0.125 kilograms of the alloy and each oversize racket uses 0.4 kilograms; over the next two-week production period only 80 kilograms of the alloy are available. Each standard-size racket uses 10 minutes of manufacturing time and each oversize racket uses 12 minutes. Also, 40 hours of manufacturing time are available each week. The profit contributions are $10 for each standard-size racket and $15 for each oversize racket. How many rackets of each type should CSD manufacture over the next two weeks to maximize the total profit contribution? a. Define decision variables and formulate the problem. b. Solve the problem using the graphical method. 1.3 Management of High Tech Services (HTS) would like to develop a model that will help allocate their technician’s time between service calls to regular contract customers and new customers. A maximum of 80 hours of technician time is available over the two-week planning period. To satisfy cash flow requirements, at least $800 in revenue (per technician) must be generated during