Q1 JC Dollar is a clothing store and needs to sell 200 of its shirts and 100 pairs of trousers left over from last season. One idea is to put together two offers, Package A and Package B. A is a package of one shirt and a pair of pants for $30. B consists of three shirts and a pair of pants, which will sell for $50. Management wants to sell more than 20 packages of A and more than 10 of B. How many of each do they have to sell to maximize revenue generated from the promotion?
Q2 USF is preparing a trip for 400 students. Krashnburn rents buses has 10 buses with a capacity of 50 seats each and 8 buses of 40 seats each, but only has 9 drivers available. The large bus rents for $800 and the small bus, $600. How many of each type bus should be rented for the trip for the least possible cost?
Q3 The Lewis N. Clark Company sells both international outdoor adventures and low-end local camping sites. It wants to place TV ads to be seen by the following audiences:
At least 65 million High Income Men (HIM)
At least 72 million High Income Women (HIM)
At least 70 million Low Income people (LIP)
The advertising costs and potential audiences in millions of viewers for 1 minute ads on various types of shows are listed below. It has an $800,000 budget. The company wants at least two ads on sportshows, two on new shows, and two on soap operas. Also, it wants no more than 10 ad on any one show. The number of ads of each type must be an integer.
|
Show Type
|
HIM
|
HIW
|
LIP
|
Cost
|
|
Sports shows
|
7
|
8
|
4
|
$120,000
|
|
Game Show
|
3
|
6
|
5
|
$40,000
|
|
News
|
6
|
3
|
5
|
$50,000
|
|
Sitcom
|
4
|
7
|
5
|
$40,000
|
|
Drama
|
6
|
6
|
8
|
$60,000
|
|
Soap Operas
|
3
|
5
|
4
|
$40,000
|
Q4 The manager of a "6/10 Market" opens his store at 6AM, closes at 10PM. The number of workers he wants on duty each two-hour slot is shown below. By union rules, he must hire all full time workers and each worker must work the standard 5-8 plan. Use Solver to solve this staff scheduling problem using the integer constraint. How many workers will be needed?
Note - The demand pattern for this operation is nasty in that it will require far more workers than the theoretical minimum of 9 shown below.
INPUTS:
DEMAND MATRIX A: Enter the number of workers needed each 2 hour span.
|
Shift
|
Shift
|
Sun
|
Mon
|
Tue
|
Wed
|
Thu
|
Fri
|
Sat
|
|
12AM-2AM
|
1
|
|
|
|
|
|
|
|
|
2AM-4AM
|
2
|
|
|
|
|
|
|
|
|
4AM-6AM
|
3
|
|
|
|
|
|
|
|
|
6AM-8AM
|
4
|
2
|
2
|
2
|
2
|
2
|
2
|
2
|
|
8AM-10AM
|
5
|
2
|
2
|
2
|
2
|
2
|
2
|
2
|
|
10AM-12PM
|
6
|
2
|
2
|
2
|
2
|
2
|
2
|
2
|
|
12PM-2PM
|
7
|
5
|
3
|
3
|
3
|
3
|
3
|
5
|
|
2PM-4PM
|
8
|
5
|
3
|
3
|
3
|
3
|
3
|
5
|
|
4PM-6PM
|
9
|
6
|
4
|
3
|
3
|
3
|
4
|
5
|
|
6PM-8PM
|
10
|
6
|
4
|
4
|
4
|
4
|
4
|
6
|
|
8PM-10PM
|
11
|
6
|
3
|
3
|
3
|
3
|
4
|
6
|
|
10PM-12AM
|
12
|
|
|
|
|
|
|
|
Total Workerhours: 360
Unadjusted Workers Required: 9
Q5 The Bubba BBQ Company manufactures its backyard BBQ grills in three plants and ships them to distributors in the four cities shown below. The cost to transport a grill from each plant to each destination is also shown and so is the anticipated demand this quarter from each region and the capacity that each plant will have in terms of how many units it can supply this quarter. Determine the optimal shipping plan to minimize shipping costs.
Transportation Cost Matrix: Cost per Unit Shipped From Each Plant to Each Region
Q6: You must answer all of the prior questions to be eligible for extra on this question
Use the following historical returns to answer the following questions. Use Solver's GRG Nonlinear Method
Q6a "How should I allocate the money in my portfolio to maximize average return over 40 years?" What could be your worst return in any single year based on the historical record?
Q6b "How should I allocate the money in my portfolio to maximize average return over 40 years but lose no more than 20% in any one year? How much did you have to give up in terms of the ending value?
Q6c "How should I allocate the money in my portfolio to maximize minimum return over 40 years?"
Q6d "How should I allocate the money in my portfolio to maximize minimum return over 40 years but lose no more than 20% in any one year? How much did you have to give up in terms of the ending value?
Attachment:- homework.xlsx