Exhibit 4.xlsx

XLSX spreadsheet 47 KB Posted

Attached to
RFP- State Forest State Park Yurts and Huts
Solicitation number
RFP PMAA 20180000000000000019 6
Issued by
Kit Carson County, Colorado

About this file

This Excel spreadsheet contains monthly NSN book sales data and occupancy records for ten yurt facilities across multiple years (2011-2018). The facilities tracked include Agnes Creek, Clark Peak, Dancing Moose, Grass Creek, Medicine Bow, Nohku Hut, North Fork Canadian, Ruby Jewel, Lower Mont. Pass, and Upper Mont. Pass. The data records monthly sales figures without discounts, state forest fees calculated at 9 percent, sales tax calculations, and occupancy percentages for each location. The spreadsheet also includes detailed daily occupancy logs for November 2015 through April 2016, showing rates ranging from 85 to 120 per day across the various yurt locations. Total annual sales across all facilities vary significantly by year, ranging from approximately $108,000 to $213,000 in gross revenue before fees and taxes. The 2018 data is incomplete, containing only January through April records with a total of 77,608 in sales and 2,245 visitors recorded through April.

The pricing structure appears to reflect variable daily rates for yurt occupancy, with rates typically between 85 and 120 per unit per day. State forest fees are consistently applied at 9 percent of monthly revenues, and sales tax is calculated separately. Occupancy percentages range from 22 percent to 90 percent across different months and facilities, with higher occupancy generally occurring during summer months (July-August) and lower occupancy during winter months (May-June). The data suggests these are recreational yurt rentals operating under state forest management, with revenue variations indicating seasonal demand patterns typical of outdoor hospitality operations.

View the file

Other files

File Type Posted
Exhibit 1_Part4.pdf PDF
RFP Exhibit B.pdf PDF
Exhibit 6.pdf PDF
RFP Exhibit F.pdf PDF
Exhibit 1_Part2.pdf PDF
RFP Exhibit C.pdf PDF
Amendment_1.pdf PDF
Addendum _1.pdf PDF
RFP State Forest State Park Yurts and Huts.doc.pdf PDF
RFP Exhibit D.pdf PDF
RFP Exhibit E.pdf PDF
Exhibit 5_Part1.pdf PDF
Exhibit 3.xlsx XLSX spreadsheet
Q&A.pdf PDF
Exhibit 5_Part2.pdf PDF
Exhibit 2.pdf PDF
RFP Exhibit A.pdf PDF
Exhibit 1_Part1.pdf PDF
Exhibit 1_Part3.pdf PDF
Show all 19

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

NSN Books

2011
JanuaryFebuaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal (yurt)W/O Discounts

Agnes Creek 1845 1440 2205 1390 755 140 1820 1335 570 420 225 UNK 12145 13350

Clark Peak 2145 2315 1200 1510 225 800 885 855 745 580 455 UNK 11715 15730

Dancing Moose 1336 1320 2160 1000 810 1175 1665 2060 830 535 675 UNK 13566 13610

Grass Creek 2225 1625 1575 720 440 645 1335 1525 505 945 755 UNK 12295 13320

Medicine Bow 1775 1690 2060 995 150 710 1540 1190 1084 460 580 UNK 12234 14225

Nohku Hut 1710 2045 2745 1550 710 360 1480 1520 1030 630 950 UNK 14730 15355

North Fork Canadian 1580 2195 2490 570 240 1055 70 1255 1680 645 255 UNK 12035 12910

Ruby Jewel 1628 1995 2235 1500 140 165 1115 645 1245 945 755 UNK 12368 13885

Lower Mont. Pass 2220 1655 1830 300 350 615 1655 450 730 120 400 UNK 10325 11030

Upper Mont. Pass 1230 1660 1700 865 200 360 590 520 835 205 0 UNK 8165 8940

Total (monthly)176941794020200104004020602512155113559254548550500119578132355
State Forrest1592.461614.61818936361.8542.251093.951021.95832.86493.65454.5010762.02
Sales Tax1574.7661596.661797.8925.6357.78536.2251081.7951010.595823.606488.165449.45010642.442

Total -fees 108935.558

2012
JanuaryFebuaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal (yurt)W/O DiscountsOccupancy

Agnes Creek 1875 2060 1955 680 330 545 725 755 760 500 275 1045 11505 13315 36

Clark Peak 1705 2300 1985 1020 565 1050 1100 1320 430 300 635 1360 13770 16240 53

Dancing Moose 2370 1790 1940 860 475 1275 1500 1010 1035 680 690 1200 14825 15635 51

Grass Creek 2335 2070 1805 600 460 620 1180 515 975 430 215 1360 12565 13675 52

Medicine Bow 1690 2045 1730 715 480 980 1235 1215 1255 555 985 1750 14635 17120 56

Nohku Hut 2005 2475 2075 1395 405 1150 1475 1370 760 405 1000 1120 15635 16330 56

North Fork Canadian 1750 1390 1500 190 210 640 1000 575 655 610 625 855 10000 1115 37

Ruby Jewel 2475 2129 1735 590 820 355 780 885 1390 680 250 880 12969 15205 49

Lower Mont. Pass 1430 1595 2560 180 195 490 800 615 940 355 330 790 10280 13060 26

Upper Mont. Pass 1070 1525 1160 310 0 0 410 195 520 140 195 920 6445 8250 26

Total (monthly)18705193791844565403940710510205845587204655520011280122629129945
State Forrest1683.451744.111660.05588.6354.6639.45918.45760.95784.8418.954681015.211036.61
Sales Tax187051724.7311641.605582.06350.66632.345908.245752.495776.08414.295462.81003.9227954.236
Occupancy486462232236706153293744

Total -fees 94674.764

2013
JanuaryFebuaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal (yurt)W/O DiscountsOccupancy %

Agnes Creek 1520 1560 1355 770 610 640 1260 1335 480 560 420 915 11425 12850 40

Clark Peak 1560 1815 1895 980 210 510 1355 1030 1035 450 595 1990 13425 15245 53

Dancing Moose 1180 1745 1765 490 470 1235 1710 1645 985 930 1200 2100 15455 15575 57

Grass Creek 1610 1565 2515 670 365 1190 1700 805 810 555 315 1560 13660 15200 52

Medicine Bow 1740 2035 2165 530 370 1160 1795 1510 1290 415 830 1450 15290 17305 60

Nohku Hut 1760 1845 1725 940 865 630 1925 1930 1100 595 1035 1470 15820 17980 56

North Fork Canadian 1520 1740 2590 530 520 885 1565 1385 140 870 695 1220 13660 14890 45

Ruby Jewel 1895 1545 2290 640 195 540 840 1420 780 770 870 1700 13485 16025 59

Lower Mont. Pass 1205 1540 1140 710 0 310 935 1040 735 280 335 505 8735 11030 30

Upper Mont. Pass 1130 1240 1120 250 0 410 535 615 420 215 200 940 7075 10325 26

Total (monthly)151201663018560651036057510136201271577755640649513850128030146425
State Forrest1360.81496.71670.4585.9324.45675.91225.81144.35699.75507.6584.551246.511522.7
Sales Tax1345.681480.071651.84579.39320.845668.391212.181131.635691.975501.96578.0551232.6511394.67
Occupancy %516465252239736355333946

Total -fees 116635.33

2014
JanuaryFebuaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal (yurt)W/O DiscountsOccupancy

Agnes Creek 500 815 985 815 1360 730 630 1360 2180 1590 1570 150 12685 15380 44

Clark Peak 1140 450 715 740 1050 1055 1215 1865 1225 1785 1250 1105 13595 14405 55

Dancing Moose 1050 1030 540 1600 595 1330 1250 1675 2070 390 1380 1140 14050 16840 63

Grass Creek 350 515 380 480 675 910 935 1635 1075 1115 1925 1620 11615 13215 47

Medicine Bow 1190 1440 370 1200 890 1185 430 2050 1780 1115 240 1725 13615 15440 52

Nohku Hut 670 1020 1800 1075 940 570 1175 490 1495 2265 1205 860 13565 15605 55

North Fork Canadian 400 1240 600 360 770 2250 970 1315 785 1565 1515 780 12550 13205 41

Ruby Jewel 790 710 265 450 285 1500 1070 520 2630 935 1230 540 10925 12395 50

Lower Mont. Pass 240 300 0 0 1090 925 310 755 1570 2160 1150 2240 10740 12875 38

Upper Mont. Pass 420 460 870 0 1225 715 500 855 2065 1425 1125 1110 10770 13410 37

Total (monthly)675079806525672088801117084851252016875143451259011270124110142770
State Forrest607.5718.2587.25604.8799.21005.3763.651126.81518.751291.051133.11014.311169.9
Sales Tax600.75710.22580.725598.08790.32994.13755.1651114.281501.8751276.7051120.511003.0311045.79
Occupancy434843284853566583706342

Total -fees 113064.21

2015
JanuaryFebuaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal (yurt)Occupancy

Agnes Creek 1220 1570 2110 840 880 1300 2420 2110 1835 525 1055 1260 17125

Clark Peak 1240 1250 2960 1160 310 820 2220 1910 1435 1605 995 2145 18050

Dancing Moose 1680 1640 1780 1180 1390 2290 2960 2310 1930 2045 1015 2415 22635

Grass Creek 1890 1820 2110 730 1140 1020 2240 1710 1815 1600 1285 1890 19250

Medicine Bow 1440 1680 2000 820 1060 1710 2690 2350 2425 1760 2100 1935 21970

Nohku Hut 1260 1840 2780 1350 920 1460 2060 2450 2110 970 1075 1460 19735

North Fork Canadian 1820 1350 2090 220 500 940 2100 1985 2005 1855 1390 1670 17925

Ruby Jewel 1440 1280 2580 620 500 800 1720 2025 1835 1495 800 1995 17090

Lower Mont. Pass 1060 1910 1910 440 200 600 1520 1940 1410 1075 505 1470 14040

Upper Mont. Pass 1150 1890 1960 440 840 780 1540 950 1285 800 295 1470 13400

Total (monthly)1420016230222807800774011720214701974018085137301051517710181220
State Forrest12781460.72005.2702696.61054.81932.31776.61627.651235.7946.351593.916309.8
Visitors2432843681251192494023743192311844383336
2016
JanuaryFebuaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal (yurt)Occupancy
Agnes Creek271024901620137042013902510224016451180860198020415

Clark Peak 3200 2440 2740 1320 345 1490 2825 1490 1340 1930 580 2160 21860

Dancing Moose 2160 2020 2320 1280 440 2195 3035 2670 2350 1750 1247.5 1860 23327.5

Grass Creek 2080 2400 2580 1150 715 1710 2025 1815 1475 1565 1215 1980 20710

Medicine Bow 2580 2120 2520 940 805 2100 2750 2100 2635 2510 1605 2160 24825

Nohku Hut 3000 2580 2490 1680 885 1645 2510 1880 1730 1600 845 2100 22945

North Fork Canadian 2460 2130 1910 1080 1265 1645 2130 2175 1520 1350 1475 2310 21450

Ruby Jewel 2690 2380 2850 1660 630 1330 2110 1415 1620 1265 780 2090 20820

Lower Mont. Pass 2130 2110 1640 660 0 1160 2280 820 1285 925 590 2070 15670

Upper Mont. Pass 2330 2020 2110 880 275 735 2300 1115 820 1285 635 2070 16575

Total (monthly)25340226902278012020578015400244751772016420153609832.520780208597.5
State Forrest (9%)2280.62042.12050.21081.8520.213862202.751594.81477.81382.4884.9251870.218773.775
Visitors5684575572691313195654102942712315074579
Occupancy %74687235224682585751375754.9166666667
2017
JanuaryFebuaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal (yurt)
Agnes Creek211024502265137562018652490232021158851360256022415

Clark Peak 2140 2240 2635 1015 1175 1300 2645 2280 1765 1340 1010 1750 21295

Dancing Moose 1800 2480 2185 1575 1462.50 2730 2740 2935 1910 2070 1640 2740 26267.50

Grass Creek 2270 2310 2440 1265 985 1862.5 2660 1645 1800 1545 1855 1690 22327.5

Medicine Bow 2120 2270 2495 1035 1032.50 2050 2865 2670 2850 1060 1610 2370 24427.50

Nohku Hut 2460 2470 2535 2335 845 1405 2615 2180 1505 550 1365 2545 22810

North Fork Canadian 2455 2310 2855 1425 1017.50 1525 2327.5 1650 1870 1455 1560 1725 22175.00

Ruby Jewel 2220 1940 2240 1285 420 1697.5 2145 1535 1602.5 1015 775 2060 18935

Lower Mont. Pass 1430 1150 2330 880 630 1545 2380 1250 1305 895 700 1690 16185

Upper Mont. Pass 1560 1560 2060 955 525 1435 2455 1565 1525 420 1010 1895 16965

Total (monthly)205652118024040131458712.501741525322.52003018247.5112351288521025213802.5
State Forrest (9%)1850.851906.22163.61183.05784.1251567.352279.0251802.71642.2751011.151159.651892.2519242.225
Visitors5795836303392764276404793562432505815383
Occupancy %78747441396390695741416160.6666666667
2018
JanuaryFebuaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal (yurt)
Agnes Creek20701635221515507470

Clark Peak 2440 1570 2535 940 7485

Dancing Moose 2100 2350 2055 1080 7585.00

Grass Creek 2220 1675 2340 430 6665

Medicine Bow 2290 1930 2505 1260 7985.00

Nohku Hut 2360 2800 2495 1910 9565

North Fork Canadian 2330 3145 2845 990 9310.00

Ruby Jewel 2300 1728 2195 970 7193

Lower Mont. Pass 1760 1995 2350 915 7020

Upper Mont. Pass 2190 2065 2050 1025 7330

Total (monthly)220602089323585110700000000077608
State Forrest (9%)1985.41880.372122.65996.3000000006984.72
Visitors6206246713302245
Occupancy %7375783521.75

&"Helvetica Neue,Regular"&12&K000000&P

November 2015

Agnes CreekClark PeakDancing MooseGrass CreekMedicine BowNohku HutNorth Fork CanadianRuby JewelLower Mont. PassUpper Mont. Pass
1115105
29585
39585
495
5859585
6105115115115105105
7105115105115105105105105
8105105105
9
1095
1195
128595
13115115105115105105105
14115115105115105105105
15105
16
17
18
19
20105115115105115
21105115115105115105
2295105105
2385858585
2485958585
25859585958585
26851159585858585
27105115115105115105105105105105
28115105115105105105105
29105115105105
3095
Total105599510151285210010751390800505295

&"Helvetica Neue,Regular"&12&K000000&P

December 2015

Agnes CreekClark PeakDancing MooseGrass CreekMedicine BowNohku HutNorth Fork CanadianRuby JewelLower Mont. PassUpper Mont. Pass
195
2
3
4115115105115105105
5115115105115105105
6115105105
795
8
995
109595
11105115115105115105105105
12105115115105115105105105105
13115115105105
14115
15115
16105
17105105
18115115105105105
19105115115105115105105105105105
20105115115105115105105105105105
21105115115105115105105105105
22105115115105115105105
23115115105105105105105
24105115105105105105105
25105115105115105105105105105
26105115115105115105105105105105
27115115105115105105105105
28115115105115105105105
29105115115105115105105105105
30105115115105115105105105105105
31105115115105115105105105105105
Total1260214524151890193514601670199514701470

&"Helvetica Neue,Regular"&12&K000000&P

January 2016

Agnes CreekClark PeakDancing MooseGrass CreekMedicine BowNohku HutNorth Fork CanadianRuby JewelLower Mont. PassUpper Mont. Pass
1110120120110120110110110110110
2110120120110120110110110110110
3120120120110110110
490100100100909090
59010010010090909090
690100100901009090909090
79010010010090909090
8110120120110120110110110110110
9110120120110120110110110110110
10110120120110120110110110110
1190100100909090909090
12901009090909090
13909010090909090
149010010090909090
15110120110120110110110110110
16110120120110120110110110110110
17110120120110120110110110110110
18901009090909090
19100100909090
201009090
2190100909090
22110120120110120110110110110110
23110120120110120110110110110110
24110120120110120110110110110
25901009010090909090
2690909090
27901001009090
28901001009090
29110120120110120110110110110110
30110120120110120110110110110110
31110120110110110
Total2710320021602080258030002460269021302330

&"Helvetica Neue,Regular"&12&K000000&P

Feburary 2016 Agnes Creek Clark Peak Dancing Moose Grass Creek Medicine Bow Nohku Hut North Fork Canadian Ruby Jewel Lower Mont. Pass Upper Mont. Pass

190909090
290
3100909090
41009090909090
5110120120110120110110110110110
6110120120110120110110110110110
7110120110110110110110
890100909090
99090
1090100909090
11901001009090909090
12110120120110120110110110110110
13110120120110120110110110110110
14110120120110120110110110110110
15901001009090909090
1690100100901009090909090
179010090100909090
18909010090909090
19110120120110120110110110110110
20110120120110120110110110110110
21110120120110120110110110110
22901001009090909090
239010010090909090
24901009010090909090
2590100100100909090
26110120120110120110110110110110
27110120120110120110110110110110
28110120120110120110110110110
29901009010090909090

Total 2490 2440 2020 2400 2120 2580 2130 2380 2110 2020

&"Helvetica Neue,Regular"&12&K000000&P

March 2016 Agnes Creek Clark Peak Dancing Moose Grass Creek Medicine Bow Nohku Hut North Fork Canadian Ruby Jewel Lower Mont. Pass Upper Mont. Pass

1100909090
210090
31009090
4110120120110120110110110110110
5110120120110120110110110110110
6120110120110110110110
710090100909090
89010090
9901009090
1010090909090
11110120120110120110110110110110
12110120120110120110110110110110
13120120110120110110110110110
14100100901009090909090
1590100901009090909090
16901009010090909090
1790100901009090909090
18110120120110120110110110110110
19110120120110120110110110110110
20120120110120110110110110
219010010010090909090
229010010090100909090
23100901009090
24901001009090909090
25110120120110120110110110110110
26110120120110120110110110110110
27110120120110110110
281009090909090
291001001009090
30901001001009090
311009090

Total 1620 2740 2320 2580 2520 2490 1910 2850 1640 2110

&"Helvetica Neue,Regular"&12&K000000&P

April 2016 Agnes Creek Clark Peak Dancing Moose Grass Creek Medicine Bow Nohku Hut North Fork Canadian Ruby Jewel Lower Mont. Pass Upper Mont. Pass

1110120120110120110110110110110
2110120120110120110110110110110
3110110
490
59090
6909090
79090
8110120120110120110110110110110
9110120120110120110110110110110
10
1110090
1290
1390
149090
15110120120110120110110110110110
16110120120110120110110110110110
17120110
1890
19
2090
2190
22110120120110110110
23110120120110110110
24120110
25100
26100
27
28
29110120110110110110
30110120110120110110110

Total 1370 1320 1280 1150 940 1680 1080 1660 660 880

&"Helvetica Neue,Regular"&12&K000000&P

File details come from the government source that posted it. Updated .