Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed
image text in transcribedimage text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Algebra

Authors: Michael Sullivan, Michael Sullivan III

11th Edition

0135226864, 9780135226865

More Books

Students also viewed these Mathematics questions

Question

What is meant by Career Planning and development ?

Answered: 1 week ago

Question

What are Fringe Benefits ? List out some.

Answered: 1 week ago