+1(978)310-4246 credencewriters@gmail.com
  

https://youtu.be/Wca0p155x5s (Links to an external site.)https://youtu.be/vxpeEf8MYaY (Links to an external site.)Let me know if this help.

https://youtu.be/dsikl5ahBRghttps://youtu.be/LdmZ2VdNYBghttps://youtu.be/AXIp1Umr8DMhttps://youtu.be/OBHwbU-Wc_shttps://youtu.be/B3biWsBLeCwhttps://youtu.be/MO8uQnIch6I

Fast is moving some employees into a newly renovated floor in one of their buildings. There are 14 employees involved and there are 10 offices on the renovated floor, four of which seat two people. The Fast HR (HumanResources) director knows happy employees are productive employees and let the 14 staff members visit the new space and give their preference by a rank of 10 (first choice) to 1 (last choice).11How should the HR manager assign the offices to maximize the preference of all 14 employees?Hints: The decision variables are the employee office assignments.The objective function would be to maximize the sum of preferences the employees get, e.g. ifemployee 1 gets office 1, and employee 3 gets office 2, the sum of their preferences would be 3+8=11.Assignments must be binary.Employees and rankings are integers.No employee can have more than 1 office assignment.Every employee must have an assignment.Every office must be used to capacity, i.e. a 2-person office must have 2 employees assigned and 1-person offices can only have 1 employee assigned.Some of the hints are constraints.22The HR manager has decided to include consideration of the employees’ seniority in the decision. Revise your decision model to include using the Employee Seniority Ranking to weight their preference scores. An employee’s Preference Score with a higher Seniority Rank is worth more than an employee’s Preference Score with a lower Seniority Rank. Rerun Solver to find a new solution.

Criteria
Identify all decision variables
State the objective function as a mathmatical formula
Identify all constraints
Build an appropriate decision model in Excel
Set up constraints with “left side” and “right side”
binary constraints connected to model?
Solver dialog set up properly?
-objective cell
-constraints
-correct engine
Problem 1 Problem 1a Problem 1b
0
n/a
n/a
1
n/a
n/a
1
n/a
n/a
1
n/a
n/a
1
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
1
n/a
n/a
1
n/a
n/a
1
n/a
n/a
Solution stated or clearly identified
Totals of Earned Points
Points Possible
1
8
9
1
1
1
1
1
1
Problem 1c Problem 2 Problem 3a Problem 3b
n/a
1
1
1
n/a
1
0
1
n/a
1
1
1
n/a
1
1
1
n/a
1
1
1
n/a
1
1
1
n/a
n/a
n/a
n/a
n/a
1
1
1
n/a
1
1
1
n/a
1
1
1
1
1
1
1
10
10
1
9
10
1
10
10
Totals
Total
Points
Earned
40
42
%
Possible
Points
95.2%
Notes:
1. These are all Yes/No or Right/Wr
answers/responses, they get the 1
part, they get 0.
2. Enter data in the blue cells. The
other cells are protected against ac
3. I expect the instructors to make
feedback in the student’s submitte
4. The instructor should insert a ne
front and copy/paste the complete
Paste Special with Formating to pa
prevent the student from changing
5. The instructor will enter the raw
by how ID sets up the course grade
are all Yes/No or Right/Wrong decisions. If the student has the correct
/responses, they get the 1 point. If they don’t get it correct or fail to complete that
data in the blue cells. The gray cells marked “n/a” do not apply to the problem. All
ls are protected against accidental changes.
ct the instructors to make notes using the Review function to give students additional
k in the student’s submitted Excel workbook.
structor should insert a new worksheet/tab in the student’s Excel workbook at the
d copy/paste the completed Rubric for the student into that worksheet. Note: use the
ecial with Formating to paste just the values and format into student’s workbook to
the student from changing the scoring.
structor will enter the raw points or % score into the Canvas gradebook as required
D sets up the course gradebook for the assignments.
M8A1 Fast Data V1.02
27-Jun-18
Fast purchasing problem
Fast has four plants that make discs for conventional disc drives. A major raw material for the
plants is copper. Fast buys the copper from five different companies.
How much copper should Fast buy to minimize the total cost of the copper and shipping?
Copper prices (per ton)
Plant 1
Plant 2
Plant 3
Plant 4
Company 1 Company 2 Company 3 Company 4 Company 5
$50
$47
$48
$45
$43
Cost of shipping from companies to plants (per ton)
Company 1 Company 2 Company 3 Company 4 Company 5
$9
$4
$5
$4
$4
$7
$6
$3
$2
$4
$7
$3
$7
$5
$2
$8
$4
$5
$6
$7
Amounts of copper to buy (tons)
Plant 1
Plant 2
Plant 3
Plant 4
Total Purchased from each
company
Available supply
Total
Bought for
Company 1 Company 2 Company 3 Company 4 Company 5 each plant
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
350
250
210
300
490
Cost of Copper
Cost of shipping
Total cost
Total Cost = Total Cost of Copper + Total Shipping Cost
A major raw material for the
he copper and shipping?
Plant
Demand
430
350
400
370
Project
1
Return $600,000
Fast Engineers Required
8
Additional Costs $190,000
2
3
4
5
6
7
$680,000
$750,000
$400,000
$350,000
$725,000
$340,000
10
7
4
8
10
8
$400,000
$370,000
$180,000
$225,000
$275,000
$130,000
operator
RHS
Decision_Variables
Return
Engineers Used
Costs
Constraints
P1&P2
P2&P4
P1&P2
P2&P4
LHS
Engineers Available
/ Budget
35
$1,200,000
Totals
Total_Return
Total_Engineers
Total_Costs
Employee
Office Rank
Office Capacity
1
1
2
1
3
1
4
1
5
2
6
1
7
2
8
2
9
2
10
1
Emp. Seniority Ranking
1
3
2
1
4
6
5
8
9
10
7
2
5
3
2
6
1
7
9
8
4
10
3
10
8
1
9
7
4
3
6
2
5
4
7
3
2
9
5
4
8
6
1
10
5
1
3
6
8
5
2
9
10
7
4
6
4
9
1
5
6
8
2
7
10
3
7
2
1
10
9
5
3
6
8
4
7
8
6
5
1
3
2
4
7
8
9
10
9
8
9
10
5
4
3
2
1
6
7
5
6
4
7
3
2
7
5
3
Employee
Office Assignment
Office
Capacity
1
1
2
1
3
1
4
1
5
2
6
1
7
2
8
2
9
2
1
10
1
2
3
4
5
6
7
8
Assignments per Employee
Employee Preference Score
Weighted Preference Score
Note: this is one way to organize your model, but you are free to use your imagination.
9
10
9
10
3
2
5
4
1
7
8
6
11
7
3
5
2
9
8
1
10
4
6
12
6
5
1
9
10
2
3
4
7
8
13
6
8
10
9
1
2
3
4
5
7
14
6
3
5
9
1
2
10
4
8
7
2
5
7
5
4
10
11
12
13
14
Total # of
Employees in
Office
Total Preference Score
Total Weighted Preference Score

Purchase answer to see full
attachment

  
error: Content is protected !!