Please check the attached files! Hw and its excel.
OSCM 471/571 Optimization and Decision Support Modeling for Business
Homework 3, Spring 2023
Notice for Homework 3
Instructor: Seokjun Youn (
[email protected]
)
·
Due date: Thursday 3/16, 11:59 pm
·
Please submit your files to D2L > Assignments > Homework 3
1.
A Word file (or PDF) with your answers combined into a single document.
2.
An Excel spreadsheet template with your answers (for some sub-questions).
·
This homework is made up of THREE questions (20 pts):
· Lecture 3-2: LP What-if Analysis
·
Q1: 5 sub-questions (4 pts)
·
Q2: 4 sub-questions (4 pts)
·
Q3: 1 sub-questions (2 pts)
· Lecture Note 4: Network Models
·
Q4: 1 sub-questions (3 pts)
·
Q5: 2 sub-questions (3.5 pts)
·
Q6: 2 sub-questions (3.5 pts)
·
Students may choose either handwriting or word processing (or both).
· Handwriting: please properly scan or take photos and organize them into one file before uploading in D2L.
·
Please write down your solutions step-by-step for partial credit.
·
You may use:
· Your textbook and notes from the class.
· Notes or sources from a related class or internet source.
· Discussion with the instructor.
· Voluntary, mutual, and cooperative discussion with other students currently taking the class.
·
You may not use:
· Solution manuals (printed or electronic).
· Copying from other students in this class, including expecting them to reveal their solutions in “discussion.â€
· It is fine if your answer is not 100% correct. However, if you do not put enough effort to the assignment, your score for this homework will be lower than your expectation. So, please try to convince your logic to instructor.
Your Name:
1. Ken and Larry, Inc., supplies its ice cream parlors with three flavors of ice cream: chocolate, vanilla, and banana. Due to extremely hot weather and a high demand for its products, the company has run short of its supply of ingredients: milk, sugar, and cream. Hence, they will not be able to fill all the orders received from their retail outlets, the ice cream parlors. D
Q2
| Union Airways Personnel Scheduling Problem | ||||||||||||
| 6am-2pm | 8am-4pm | Noon-8pm | 4pm-midnight | 10pm-6am | Range Name | Cells | ||||||
| Shift | Shift | Shift | Shift | Shift | CostPerShift | C5:G5 | ||||||
| Cost per Shift | $170 | $160 | $175 | $180 | $195 | MinimumNeeded | J8:J17 | |||||
| Total | Minimum | NumberWorking | C21:G21 | |||||||||
| Time Period | Shift Works Time Period? (1=yes, 0=no) | Working | Needed | ShiftWorksTimePeriod | C8:G17 | |||||||
| 6am-8am | 1 | 0 | 0 | 0 | 0 | >= | 48 | TotalCost | J21 | |||
| 8am-10am | 1 | 1 | 0 | 0 | 0 | >= | 79 | TotalWorking | H8:H17 | |||
| 10am- 12pm | 1 | 1 | 0 | 0 | 0 | >= | 65 | |||||
| 12pm-2pm | 1 | 1 | 1 | 0 | 0 | >= | 87 | |||||
| 2pm-4pm | 0 | 1 | 1 | 0 | 0 | >= | 64 | |||||
| 4pm-6pm | 0 | 0 | 1 | 1 | 0 | >= | 73 | |||||
| 6pm-8pm | 0 | 0 | 1 | 1 | 0 | >= | 82 | |||||
| 8pm-10pm | 0 | 0 | 0 | 1 | 0 | >= | 43 | |||||
| 10pm-12am | 0 | 0 | 0 | 1 | 1 | >= | 52 | |||||
| 12am-6am | 0 | 0 | 0 | 0 | 1 | >= | 15 | |||||
| 6am-2pm | 8am-4pm | Noon-8pm | 4pm-midnight | 10pm-6am | ||||||||
| Shift | Shift | Shift | Shift | Shift | Total Cost | |||||||
| Number Working |
Q3
| Wyndor Glass Co. Product-Mix Problem | ||
| Doors |
![Please check the attached files! Hw and its excel.
OSCM 471/571 Optimization and Decision Support Modeling for Business
Homework 3, Spring 2023
Notice for Homework 3
Instructor: Seokjun Youn (
[email protected]
)
·
Due date: Thursday 3/16, 11:59 pm
·
Please submit your files to D2L > Assignments > Homework 3
1.
A Word file (or PDF) with your answers combined into a single document.
2.
An Excel spreadsheet template with your answers (for some sub-questions).
·
This homework is made up of THREE questions (20 pts):
· Lecture 3-2: LP What-if Analysis
·
Q1: 5 sub-questions (4 pts)
·
Q2: 4 sub-questions (4 pts)
·
Q3: 1 sub-questions (2 pts)
· Lecture Note 4: Network Models
·
Q4: 1 sub-questions (3 pts)
·
Q5: 2 sub-questions (3.5 pts)
·
Q6: 2 sub-questions (3.5 pts)
·
Students may choose either handwriting or word processing (or both).
· Handwriting: please properly scan or take photos and organize them into one file before uploading in D2L.
·
Please write down your solutions step-by-step for partial credit.
·
You may use:
· Your textbook and notes from the class.
· Notes or sources from a related class or internet source.
· Discussion with the instructor.
· Voluntary, mutual, and cooperative discussion with other students currently taking the class.
·
You may not use:
· Solution manuals (printed or electronic).
· Copying from other students in this class, including expecting them to reveal their solutions in “discussion.â€
· It is fine if your answer is not 100% correct. However, if you do not put enough effort to the assignment, your score for this homework will be lower than your expectation. So, please try to convince your logic to instructor.
Your Name:
1. Ken and Larry, Inc., supplies its ice cream parlors with three flavors of ice cream: chocolate, vanilla, and banana. Due to extremely hot weather and a high demand for its products, the company has run short of its supply of ingredients: milk, sugar, and cream. Hence, they will not be able to fill all the orders received from their retail outlets, the ice cream parlors. D
Q2
Union Airways Personnel Scheduling Problem
6am-2pm
8am-4pm
Noon-8pm
4pm-midnight
10pm-6am
Range Name
Cells
Shift
Shift
Shift
Shift
Shift
CostPerShift
C5:G5
Cost per Shift
$170
$160
$175
$180
$195
MinimumNeeded
J8:J17
Total
Minimum
NumberWorking
C21:G21
Time Period
Shift Works Time Period? (1=yes, 0=no)
Working
Needed
ShiftWorksTimePeriod
C8:G17
6am-8am
1
0
0
0
0
>=
48
TotalCost
J21
8am-10am
1
1
0
0
0
>=
79
TotalWorking
H8:H17
10am- 12pm
1
1
0
0
0
>=
65
12pm-2pm
1
1
1
0
0
>=
87
2pm-4pm
0
1
1
0
0
>=
64
4pm-6pm
0
0
1
1
0
>=
73
6pm-8pm
0
0
1
1
0
>=
82
8pm-10pm
0
0
0
1
0
>=
43
10pm-12am
0
0
0
1
1
>=
52
12am-6am
0
0
0
0
1
>=
15
6am-2pm
8am-4pm
Noon-8pm
4pm-midnight
10pm-6am
Shift
Shift
Shift
Shift
Shift
Total Cost
Number Working
Q3
Wyndor Glass Co. Product-Mix Problem
Doors
<](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAyAAAAGQAQMAAABs65Z3AAAABlBMVEX/8P8AAADXkkSvAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEvklEQVR4nO3dTWsbRxzH8f8wsLqMsrd2hFzrFRRWLMgqEVFfyi4C9aIYF0PwwSgjDMqhanyVaUvegkOgSaDQMQPSZVNfVRwaGYF78UFGF6VR7c5IkRsX7CBj01J+H7At9OAv87C3ZUQEAAAAAAAAAAAAAAAAAAAAAAAAAHALyo/ePwiIuP2j5y/YB5r1dd+9NH3SIzF/bWnBSGAuRCL3/zhTswgPdPRhZF4RtJiPROjDCF0/wvdOxhuUW0ltDQI2fr1Mqf1uf7z5evmO5kxHG3UKehEbrT2gpbKv2UBslhaNlLe8SlYklH/Z6oQRRUchiQprtDpHYUZz0lFiqNyLeLb9i50uGfF8u1NdeCRcBFnWpCjo1bimyMSKKkyllYl3ta913NQUHESUTTddhDx5osziEX/09u2pjbw5nkYeKn/AGn8q83DXjSQ+rbsIfzeN+Do1jtXZNUbiybRyIxHcTpeJSFbYlh1JFEwjiruINxsJRR6dKL14xCvcFR3K7ybVMKCqySs5yH+31DH5nemadAwFb/reXeHWxC5Opt2pLByxm+rX8Sblgq4ZSCqZHPlx/+R40+Ts7uLD4aadrkTzA/GAyqltzUZi897yghEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAID/Ft83R5LEmSg/OVQ0dKfCuKNw3EEyjmRjd2aMO0qG6vPPGHeojNLu0/Yn1bdvuzqSaVdXirTElwKqKNamYBbR55HWeeT9QTaafndn8EwjGfu8F3w0EvTEp2Mq8VJAXyku5iPQNI80z9+q53/OphGaRz5SmEW8HtU8sUJ7iqdfTJY+f5Q6HA3XSquUerXXY81S7o5vGoM10vHz7FZnNKSD5TvdRsOs/UHSz2ovFJPiqu93+5dH9hMbSYT4otGwkSQQBUMVqYPqOonVSpE1q/mmjLfCNtXjl993Km1NB2Em2VNm5zHJzOMoNUg35XqmXQsuj+ia12MtKcgwG2lOI9pG3GE4tYKdLhN59nfWrlW826uFdroO7INYmXSL6kFCXphW0j5zxUkvLiLZqV3vznmEbY2nEf/YRc4iz9+7EDHx7pvDaUS6SFZMZPzz/lXTpWuf2C0ciSA5j3BvNhI5HYmOPIr/GekxZcR4HvHsSCi6fLrsFi7YiBaZNlNsJwltxPOKSVC1keOwyFqV2ZrY+QzdmlBiH2QSN13KrkmLvPwP9g3t3hVr8v5i1GVfpvp08mK5XNjvDnobk5Kdrlq+x8b3crnt7uFAUP0zu7sMbZCxu8uYkZjY3SUo1T+e1OPt7Sum66LZ7r98bi9cEh9cQgtZKEKT60UAAAAAAAAAAAAAAAAAAAD+TbPvZXJ33PiKD2e3uXCth+PbiUjtbnNxES8+3GndTsR90dCMCEPhXfaBa0W638QDsfFbSKQ9/vVPxdXcl1SQYtHvG7pSOXn1LBTJeoG44qP2kVzPa6pKWbzJSNC7/2P2fjMquTuRskLL+KmijgxudCQ28vzdLBLNI6wpo5tdEzsSbiOF88gT4jzQNxuxa5KdJFHotnC2rd0NOx47bNzsFu5++/SkvRHllb0YR2u6Hj9R/tBMbvRivGB2t52+tf//dySnbjcCAAD/P38BCjXWxKPVxjgAAAAASUVORK5CYII=)
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.