Question: EXCEL PLEASE! 2. Successfully navigating the waters during sea voyages is a challenging task. A captain's most important decision is selecting the right crew for

EXCEL PLEASE! 2. Successfully navigating theEXCEL PLEASE!

2. Successfully navigating the waters during sea voyages is a challenging task. A captain's most important decision is selecting the right crew for the voyage. A mix of different skill sets are required to sail the ship efficiently, navigate to the destination, and fish for food along the way. Table 1 shows a list of crew members that are available for you to hire for the voyage. Each crew member demands a salary for the voyage and has different skill levels of Fishing, Sailing, and Navigation. In order for your journey to be successful, you must have a cumulative skill of 15 or more in each of the three skill categories from all of your chosen crew members. You may choose as many crew members as you like. Skills Name Fishing Sailing Navigation Salary Amy 3 5 1 $46,000 Bill 1 2 5 $43,000 Carl 3 4 2 $47,000 Dan 4 3 1 $36,000 Eva 4 2 2 $43,000 Fred 1 3 4 $55,000 Greg 3 1 5 $68,000 Henry 5 4 2 $64,000 Ida 3 3 3 $60,000 Table 1 Formulate the model and solve it with Excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!