Problems solved in Excel – See Attachment Also see Solutions PDF for examples - Attached 14. 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 4000 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 4000 copies? c. With a demand of 4000 copies, what is the minimum price per copy that the publisher must charge to break even? d. If the publisher believes that the price per copy could be increased to $25.95 and not affect the anticipated demand of 4000 copies, what action would you recommend? What profit or loss can be anticipated? Chapter One Tab 54. Jackson Hole Manufacturing is a small manufacturer of plastic products used in the automotive and computer industries. One of its major contracts is with a large computer company and involves the production of plastic printer cases for the computer company’s portable printers. The printer cases are produced on two injection molding machines. The M-100 machine has a production capacity of 25 printer cases per hour, and the M-200 machine has a production capacity of 40 cases per hour. Both machines use the same chemical material to produce the printer cases; the M-100 uses 40 pounds of the raw material per hour and the M-200 uses 50 pounds per hour. The computer company asked Jackson Hole to produce as many of the cases during the upcoming week as possible; it will pay $18 for each case Jackson Hole can deliver. However, next week is a regularly scheduled vacation period for most of Jackson Hole’s production employees; during this time, annual maintenance is performed for all equipment in the plant. Because of the downtime for maintenance, the M-100 will be available for no more than 15 hours, and the M-200 will be available for no more than 10 hours. However, because of the high setup cost involved with both machines, management requires that, each machine must be operated for at least 5 hours. The supplier of the chemical material used in the production process informed Jackson Hole that a maximum of 1000 pounds of the chemical material will be available for next week’s production; the cost for this raw material is $6 per pound. In addition to the raw material cost, Jackson Hole estimates that the hourly cost of operating the M-100 and the M-200 are $50 and $75, respectively. a. Formulate a linear programming model that can be used to maximize the contribution to profit. b. Find the optimal solution. Chapter Two Tab Chapter 1 - 1 Breakeven Analysis Chapter 1 - 2 Profit Maximization (Problem 8) Variables Constraints Objective Solution LHS RHS Chapter 2 - 3 Simple Maximization Problem Variables Constraints LHS RHS Objective Solution Variables Constraints Objective Solution LHS RHS Chapter 2 - 4 Simple Minimization Problem Variables Constraints LHS RHS Objective Solution Variables Constraints Objective Solution LHS RHS Chapter 3 - 5 Dual Values (Shadow Prices) Variables Constraints LHS RHS LHS RHS Objective Solution Variables Constraints Objective Solution Chapter 3 - 6 Dual Values (Shadow Prices) Chapter 3 - 7 Reduced Costs Variables Constraints LHS RHS LHS RHS LHS RHS Objective Solution Variables Constraints Objective Solution Variables Constraints Objective Solution Chapter 3 - 8 Reduced Costs Chapter 3 - 9 Nonintuitive Dual Values Variables Constraints LHS RHS LHS RHS Objective Solution Variables Constraints Objective Solution Chapter 3 - 10 Nonintuitive Dual Values Chapter 3 - 11 Electronic Communications Variables Constraints Objective Solution LHS RHS Chapter 3 - 12 Electronic Communications Chapter 4 - 13 Media Selection Variables Constraints Objective Solution LHS RHS Chapter 4 - 14 Media Selection Chapter 4 - 15 Marketing Research Variables Constraints Objective Solution LHS RHS Chapter 4 - 16 Marketing Research Chapter 4 - 17 Portfolio Selection Variables Constraints Objective Solution LHS RHS Chapter 4 - 18 Portfolio Selection Chapter 4 - 19 Financial Planning Variables Constraints Objective Solution LHS RHS Chapter 4 - 20 Financial Planning Chapter 4 - 21 A Make-or-Buy Decision Variables Constraints Objective Solution LHS RHS Chapter 4 - 22 A Make-or-Buy Decision Chapter 4 - 23 Production Scheduling Variables Constraints Objective Solution LHS RHS Chapter 4 - 24 Production Scheduling Chapter 4 - 25 Workforce Assignment Variables Constraints Objective Solution LHS RHS Chapter 4 - 26 Blending Problems Variables Constraints Objective Solution LHS RHS Chapter 6 - 27 Transportation Problem Variables Constraints Objective Solution LHS RHS Chapter 6 - 28 Transshipment Problem Variables Constraints Objective Solution LHS RHS Chapter 6 - 29 Assignment Problem Variables Constraints Objective Solution LHS RHS Chapter 6 - 30 Shortest-Route Problem Variables Constraints Objective Solution LHS RHS Chapter 6 - 31 Maximal Flow Problem Variables Constraints Objective Solution LHS RHS Chapter 6 - 32 Maximal Flow Problem Chapter 6 - 33 Production and Inventory Problem Variables Constraints Objective Solution LHS RHS Chapter 7 - 34 All-Integer Linear Program Variables Constraints Objective Solution LHS RHS Chapter 7 - 35 Capital Budgeting Variables Constraints Objective Solution LHS RHS Chapter 7 - 36 Fixed Cost Variables Constraints Objective Solution LHS RHS Chapter 7 - 37 Distribution System Design Variables Constraints Objective Solution LHS RHS Chapter 7 - 38 Bank Location Variables Constraints Objective Solution LHS RHS Chapter 7 - 39 Bank Location Chapter 7 - 40 Product Design and Market Share Variables Constraints Objective Solution LHS RHS Chapter 7 - 41 Product Design and Market Share Chapter 9 - 42 Project Scheduling Chapter 9 - 43 Project Scheduling Expected activity time. Earliest start time (maximum of earliest finish times of immediate predecessors). Earliest finish time (earliest start time plus expected completion time). Latest finish time (minimum of latest start times of immediate followers). Latest start time (latest finish time minus expected completion time). Chapter 9 - 44 Project Scheduling with Uncertain Activity Times Chapter 9 - 45 Project Scheduling with Uncertain Activity Times Mean completion time. Earliest start time (maximum of earliest finish times of immediate predecessors). Earliest finish time (earliest start time plus mean completion time). Latest finish time (minimum of latest start times of immediate followers). Latest start time (latest finish time minus mean completion time). Chapter 9 - 46 Project Scheduling with Time-Cost Trade-Offs Variables Constraints Objective Solution LHS RHS Chapter 9 - 47 Project Scheduling with Time-Cost Trade-Offs New completion time. Earliest start time (maximum of earliest finish times of immediate predecessors). Earliest finish time (earliest start time plus new completion time). Latest finish time (minimum of latest start times of immediate followers). Latest start time (latest finish time minus new completion time). Chapter 10 - 48 Economic Order Quantity (EOQ) Model Optimal Inventory Policy Chapter 10 - 49 EOQ Model with Constant Supply Rate Optimal Inventory Policy Chapter 10 - 50 EOQ Model with Planned Shortages Optimal Inventory Policy Chapter 10 - 51 EOQ Model with Quantity Discounts Optimal Inventory Policy Chapter 10 - 52 Single-Period Inventory Model with Probabilistic Demand Chapter 10 - 53 EOQ Model with Probabilistic Demand Optimal Inventory Policy Chapter 11 - 54 M/M/1 Model Operating Characteristics Chapter 11 - 55 M/M/k Model Operating Characteristics Economic Analysis Chapter 11 - 56 M/M/k Model Chapter 11 - 57 M/G/1 Model Operating Characteristics Chapter 11 - 58 M/G/k Model with No Waiting Line Operating Characteristics Chapter 11 - 59 M/M/1 Model with Finite Calling Population Operating Characteristics Chapter 12 - 60 Risk Analysis Simulation Chapter 12 - 61 Inventory Simulation Chapter 12 - 62 Waiting Line Simulation (Single Server) Chapter 12 - 63 Waiting Line Simulation (Dual Server) Chapter 13 - 64 Decision Analysis State of Nature (Payoffs) State of Nature (Regrets) State of Nature (Probabilities) Chapter 13 - 65 Risk Analysis Risk Profiles Chapter 13 - 66 Sensitivity Analysis (Probabilities) Small complex Medium complex Large complex Chapter 13 - 67 Sensitivity Analysis (Large Complex Payoffs) Chapter 13 - 68 Decision Analysis with Sample Information State of Nature (Payoffs) State of Nature (Probabilities) Market Research (Probabilities) Market Research (Cond Probabilities) State of Nature (Post Probabilities) Expected Values Chapter 13 - 69 Risk Analysis Risk Profile Chapter 15 - 70 Moving Averages Chapter 15 - 71 Weighted Moving Averages Chapter 15 - 72 Exponential Smoothing Chapter 15 - 73 Linear Trend Chapter 15 - 74 Quadratic Trend Chapter 15 - 75 Exponential Trend Chapter 15 - 76 Seasonality Chapter 15 - 77 Seasonality With Trend Chapter 1 - 1 Breakeven Analysis Fixed Cost Unit Cost Sales Price Volume Total Cost Revenue Profit $3,000 $2 $5 1000 $5,000 $5,000 $0 (Goal Seek) Chapter 1 - 2 Profit Maximization (Problem 8) Variables Constraints Hours Objective Solution x 5 y 2 LHS 40
Purchase answer to see full attachment