Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

pLEASE USE EXCEL SOLVER TO SOLVE THIS Showing alll the formula for the decision variable, objective function and constranits La Libertia is a summer camp

pLEASE USE EXCEL SOLVER TO SOLVE THIS Showing alll the formula for the decision variable, objective function and constranitsimage text in transcribed

La Libertia is a summer camp program tucked in the deep Smokies. The location of La Libertia is beautiful, surrounded by high mountains, on the side of a lake, with a river flowing through the campsite. Every year, they host groups of kids from different schools, church programs, and girls or boy scouts. Theres one goal of the maximization of fun within the duration the kids have to spend. A typical camp experience runs for 4-days and discounting the amount of time the kids spend on eating, sleeping, and free time, there are roughly 32 hours of fun. The camp manager, Mr. Blake Smith, surveyed the past years participants on the level of fun they had received and collected the data that is given to you in P1-SummerCamp on the activities involving camp place, mountains, river, lake, and nighttime. Mr. Smith would like to create a package to offer to the participants to maximize the fun within a four-day camp (3-nights) to ensure their return. To showcase the diversity of the activities, he needs there will be at least one activity in the package from each category: Campsite activities: face painting, jewelry making, geocaching, and watercolor art classes. Mountain activities: horseback riding, rock climbing, nature walking, archery, and mountain biking. River activities: Fishing by the river, paddle boarding, kayaking, canoeing, and rafting. Lake activities: Fishing by the lake, paddle boarding, kayaking, boating, and swimming. Nighttime activities: Smores by the campfire, storytelling by the campfire, dancing by the campfire, and show-and-tell.

a) Please help out Mr. Smith in creating the most fun camp package he can offer. Note that since there are only 3-nights at the camp, at most three of the nighttime activities can be selected. Additionally, note that each activity may appear in the package at most once.

b) nce several of the river and lake activities are similar, the fun package should not include the same type of activity from the lake and river list. For instance, kayaking can be either on the lake or on the river and vice versa. How would your solution change from part (a)?

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

Driving Strategic Decisions From Financial Reports In The Global Economy

Authors: Samuel 0 Omoniyi

1st Edition

979-8853393608

More Books

Students also viewed these Accounting questions