Q: The costs of producing product A, product B, or products
The costs of producing product A, product B, or products A and B bundled together are $50, $90, and $140, respectively. The file P08_23.xlsx lists the sizes of the three market segments for these prod...
See AnswerQ: Cook County needs to build two hospitals. There are nine cities
Cook County needs to build two hospitals. There are nine cities where the hospitals can be built. The number of hospital visits made annually by the inhabitants of each city and the x and y coordinate...
See AnswerQ: The file contains quarterly revenue for a sporting goods company over an
The file contains quarterly revenue for a sporting goods company over an 8-year period. It also contains quarterly “indicator” variables Q1, Q2, and Q3. Here Q1 is 1 for the first quarter of a fiscal...
See AnswerQ: Music radio WABC has commercials of the following lengths (in seconds
Music radio WABC has commercials of the following lengths (in seconds): 15, 15, 20, 25, 30, 35, 40, 57. The commercials must be assigned to 60-second breaks. What is the fewest number of breaks that a...
See AnswerQ: A Wall Street firm is trying to package nine mortgages for sale
A Wall Street firm is trying to package nine mortgages for sale. The sizes of the mortgages (in thousands of dollars) are listed in the file. To be sold, each package must consist of at least $1,000,0...
See AnswerQ: During the next 12 months, the amounts of electric power needed
During the next 12 months, the amounts of electric power needed (in thousands of kwh) are listed in the file. This power can be supplied using four generators. The generating capacity (in thousands of...
See AnswerQ: Bus 99 serves towns 1 through 10. We assume that town
Bus 99 serves towns 1 through 10. We assume that town k is |k – j| miles from town j. The numbers of people in the towns who want to take the bus each hour are listed in the file P08_29.xlsx. Bus 99 w...
See AnswerQ: Determine the best pricing policy if quantity discounts with a single-
Determine the best pricing policy if quantity discounts with a single-price breakpoint are used.
See AnswerQ: Other sensitivity analyses besides those discussed could be performed on the product
Other sensitivity analyses besides those discussed could be performed on the product mix model. Use SolverTable to perform each of the following. In each case keep track of the values in the decision...
See AnswerQ: Ten data sets must be assigned for storage to one of three
Ten data sets must be assigned for storage to one of three disk drives. Each disk drive can store 150 GB (about 150,000 MB). The sizes of the data sets (in MB) are listed in the file P08_30.xlsx. When...
See Answer
