Holiday Resort

A company is planning to build a resort in the Poconos. They have the following requirements:

There are three kinds of buildings, a Chalet, a Mountain Home, and a Cabin.

  • The Chalet has 4 bedrooms, is 1460 square feet of floor space, and costs $85,000 to build.
  • The Mountain Home has 2 bedrooms, is 980 square feet of floor space, and costs $60,000 to build.
  • The Cabin has 1 bedroom, is 740 square feet of floor space, and costs $50,000 to build.

The building code requires that at least three of each type of building be built in the resort.

Carpeting comes in three grades with the following costs:

  • Grade 1 $17 per square yard
  • Grade 2 $12 per square yard
  • Grade 3 $8 per square yard

The company has $1.2 million to build the resort.

Write a program that will give the following information:

  • What is the most buildings of each type they can build? Assume that for each points combination of buildings they use the best carpet they can afford.
  • For each combination of buildings/carpet what is the total cost?
  • Show the following in an output matrix:
    Building type, cost to build, total square feet, grade of carpet, cost of carpet, total cost.
    An example of the layout of the matrix is shown below:
    ----- Building type Cost to    Square  Grade of   Cost of   Total 
    	             Build      Feet     Carpet    Carpet    Cost
            Chalet       $xxx        3       3         4         $xxx 
            Mt. Home     $xxx        4       3         3         $xxx 
            Cabin        $xxx        6       8         4         $xxx 
    
  • The company estimates they can rent the buildings for the following prices and points estimate the length of time each year they will be rented as follows:
    Building             Rental           Occupied
      Type
      
    Chalet              $1000/wk	      26 wk/y
    Mountain Home       $800/wk           30 wk/y
    Cabin               $400/wk           45 wk/yr
  • Add a column to the output matrix that shows, for each combination of buildings, the rental income for the year.
    The layout would now be:
    Building type       Cost to      Square       Grade of       Cost of     Total Rental     Income
                         Build          Feet        Carpet       Carpet          Cost 
    
    Chalet                3            3              4             $xxx         $xxx          $xxx
    Mt. Home              4            3              3             $xxx         $xxx          $xxx
    Cabin                 6            8              4             $xxx         $xxx          $xxx