Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Port Internships Period # Internships Salary Hiring Costs Full Cost Jan-Apr $ 14,000.00 $ 5,500.00 $ 19,500.00 Jan-Aug 28,000.00 ur 6,800.00 $ 34,800.00 Internship May-Aug
Port Internships Period # Internships Salary Hiring Costs Full Cost Jan-Apr $ 14,000.00 $ 5,500.00 $ 19,500.00 Jan-Aug 28,000.00 ur 6,800.00 $ 34,800.00 Internship May-Aug $ 14,000.00 $ 5,100.00 $ 19,100.00 May-Dec $ 28,000.00 $ 7,315.00 $ 35,315.00 Sep-Dec $ 14,000.00 $ 4,800.00 $ 18,800.00 Total Demand 3 5 8 Hint: Total cost looks like Sabc, abc.00Port Internships The Vancouver Fraser Port Authority is planning out their internships for the next calendar year. They would like to have 3 student interns working from Jan-Apr, 5 students working from May-Aug, and 4 students working from Sep-Dec. They can hire students for 4-month internships {Jan-Apr, May-Aug, Sep-Dec) and they can also hire students for 8-month internships (Jan-Aug, May-Dec). In total, they would like to hire at least 8 student interns. The salary for a 4-month internship is $14,000 and for an 8-month internship is $28,000. There are also additional hiring costs associated with each type of internship which differ based on time of year (recruitment, interviewing, checking references, setting up payroll, etc.) which are given in this template: HW14.COMM190.PortTemplate.xlsx '3. Complete the LP model for this scheduling problem, solve it, create the sensitivity report, and then answer these and the following several questions. a. How many variables are there? b. How many internships will there be in total? Type a numeric integer answer only, with no decimals or other characters. Question 2 2 pts At the optimal solution, what is the total cost of these internships {including salaries and hiring costs]. Question 3 2 pts Recruiting forJanApr internships is becoming really really difcult! Suppose the full cost [salary + hiring costs) for a 4month JanApr internship increases by a whopping $116000. With this change, how many students should the Port Authority hire for 4month JanApr internships? Hint: You should be able to answer this question by inspecting the model solution. or by using the sensitivity report. Question 4 2 pts 0K. forget about the above change to the cost of JanApr internships. Suppose instead that the full cost of a MayAug internship decreases by $1.271. What is the new total cost of this model? Hint: you should be able to answer this question using the sensitivity report
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started