Question
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 constranits
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
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