#### Question Details

##### [solution] » Question: Question: Step 1: Complete Income Statement It is time

Brief item decscription

Step-by-step solution file

Item details:

Question: Question: Step 1: Complete Income Statement It is time
More:

Question:

Question: Step 1: Complete Income Statement

It is time to build the formulas needed to complete the income statement. Begin working on the Income Statement worksheet and complete formulas for all of the cells marked in gray.

1. Enter the formula to calculate the Condo Rentals Revenue in C13 Multiple the Quantity of Condo Rental Days * the Price for Condo Rental.
2. Enter the formula to calculate the Ski Lift Revenue in C14 Multiple the Quantity of Ski Lift Tickets * the Price for Ski Lift Tickets.
3. Enter the formula to calculate the Winter X Games Revenue in C17 Multiple the Quantity of X Games Tickets * the Price for X Games Tickets.
4. Enter the formula to calculate the Total Revenues in C20 and Total Expenses in C34.
5. Make sure the cell references for Total Revenues and Total Expenses are placed in cells C37 and C38 respectively.
6. Enter the formula to calculate the Net Income in cell C39.
7. Apply professional formatting to all of this data using the image below as a guide.

Income Statement

Step 2: Build the One-Variable Data Tables

Now that the Income Statement is complete, begin to address the questions about the condo rentals and ski lift tickets.

1. Build a one-variable data table based on condo rental days. The initial values for Revenue and Net Income for cells I6 and I7 should be cell references from the income statement.
2. Build a one-variable data table based on the quantity of ski lift tickets. The initial values for Revenue and Net Income for cells I14 and I15 should be cell references from the income statement.
3. Apply conditional formatting to highlight Net Income of at least \$250,000 for each of the one-variable data tables.
4. In cell G17, a question exists. "If management has a target net income of at least \$250,000, which of the above SPECIFIC scenarios in the condo rentals or ski tickets one-variable data table would you recommend using? Explain your reasoning." Make sure you place your answer in the text box beginning in cell G20.
5. Apply professional formatting to all of this data using the image below as a guide.

One-Variable Data Tables

Step 3: Build the Two-Variable Data Table

Once the one-variable data tables are complete, begin to address the questions about the X Games tickets sold.

1. Build a two-variable data table based on the quantity and price of the X Games tickets sold.  Enter a reference to Net Income in cell I27 from the income statement.
2. Apply conditional formatting to highlight Net Income of at least \$250,000 for each of the two-variable data table.
3. In cell G37, a question exists. "If management has a target net income of at least \$250,000. Which of the above SPECIFIC combinations of price and quantity of X Games Tickets in the two-variable data table would you recommend using? Explain your reasoning."
4. Make sure you place your answer in the text box beginning in cell G40.
5. Apply professional formatting to all of this data using the image below as a guide.Two-Variable Data Table

Step 4: Create the Scenario Summary

You addressed quite a few questions. Now it is time to create a Scenario Summary.

1. Assign names to all of the income statement cell values in column C in the assumptions, revenues, expenses, and summary sections using the labels in column B. For example, select cells B5:C10, and then on the Formula tab in the Defined Names Group, select "Create from Selection" and use the left column as the name (repeat on lower sections).
2. Build three scenarios by changing cells C8, C15, C16, C29, and C30 using the following data: Optimistic, Mid-range, and Pessimistic.Scenario Details
3. Generate the Scenario Summary using C37:C39 as the result cells.
4. Move the Scenario Summary sheet after the Income Statement and apply professional formatting to all of this data using the image below as a guide.

Completed Scenarios

Step 5: Create Pivot Tables From Warming Hut Data

Select the Warming Hut Sales Worksheet. You notice the data are not formatted or organized well.

1. Use the Warming Hut Sales data to build Pivot Tables.
2. Build the first Pivot Table to summarize total sales by category and by location. Name this sheet Pivot Table 1.
3. Build the second Pivot Table to summarize total sales by category and by season for only the Summit View location. Name this sheet Pivot Table 2.
4. Build the third Pivot Table to summarize total sales by month and by product for only the Mogul Hill location. Name this sheet Pivot Table 3.
5. Choose one of the created Pivot Tables and add a professional chart to the same worksheet.
6. Apply professional formatting to all of this data using the image below as a guide.   Click Image to Expand

Summit Ridge Mountain Resort One Variable Data T Income Statement

Current Year

Assumptions

Quantity of Condo Rental days

Price for Condo Rental

Quantity of Ski Lift tickets

Price for Ski Lift tickets

Quantity of X Games tickets 300

1015

4430

83

275 Price for X Games tickets 799 Revenues

Condo Rental revenue

Ski Lift revenue

Ski Resort Restaurant revenue

Ski Resort Retail revenue

Winter X Games revenue

Other revenue Effect of Varying Number of Commissions

Depreciation

Insurance

Interest Expense

IT consultants

Maintenance and repairs

Payroll

Office supplies

Utilities One Variable Data T

Effect of Varying Number of

Revenue

Net Income 437856.93

342721.49

Question ======&gt;

79516.89 If management has a targe

OR ski tickets Response ======&gt; Type your response here Total Revenues

Expenses

Net Income 125000

32832

86750

85000

69750

150000

142000

790645

15000

76855 Two Variable Data T

cell needs a formula Total Expenses

Summary

Total Revenue

Total Expenses

Net Income Question ======&gt; If management has a targ

quantity of X Games Tic Response ======&gt; Type your response here One Variable Data Table - Condo Rental Days

Effect of Varying Number of Condo Rental Days on Revenue and Net Income

Initial Values

250

275

300 325 350 375 5000 5250 5500 Net Income One Variable Data Table - Ski Lift Tickets

Effect of Varying Number of Ski Lift Tickets on Revenue and Net Income

Initial Values

4250

4500

4750

Net Income

If management has a target net income of at least \$250,000 which of the above SPECIFIC scenarios in the condo rentals

OR ski tickets one variable data table would you recommend using? Explain your reasoning.

Type your response here Two Variable Data Table - X Games Tickets &amp; Price

====&gt; Effect of Varying Price for X Games Tickets on Revenue and Net Income

200

225

250

275

799

849

899

949

999

1049

1099 300 325 If management has a target net income of at least \$250,000 which of the above SPECIFIC combinations of price and

quantity of X Games Tickets in the two variable data table would you recommend using? Explain your reasoning.

Type your response here 400 5750 os in the condo rentals

asoning. 350 inations of price and

ain your reasoning. Summit Ridge Ski Lodge - Warming Hut Monthly Sales Revenue Location

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Miscellaneous Products Category

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Miscellaneous Month

January

January

January

January

January

January

January

February

February

February

February

February

February

February

March

March

March

March

March

March

March

April

April

April

April

April

April

April

May

May

May

May

May

May

May

June

June

June

June

June

June

June Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Bunny Den

Mogul Hill

Mogul Hill

Mogul Hill Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch Food

Food

Food

Food

Food

Drinks - non-alcoholic

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Miscellaneous

Food

Food

Food July

July

July

July

July

July

July

August

August

August

August

August

August

August

September

September

September

September

September

September

September

October

October

October

October

October

October

October

November

November

November

November

November

November

November

December

December

December

December

December

December

December

January

January

January Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous January

January

January

January

January

February

February

February

February

February

February

February

February

March

March

March

March

March

March

March

March

April

April

April

April

April

April

April

April

May

May

May

May

May

May

May

May

June

June

June

June

June

June

June

June Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill

Mogul Hill Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food July

July

July

July

July

July

July

July

August

August

August

August

August

August

August

August

September

September

September

September

September

September

September

September

October

October

October

October

October

October

October

October

November

November

November

November

November

November

November

November

December

December

December

December

December Mogul Hill

Mogul Hill

Mogul Hill

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food December

December

December

January

January

January

January

January

January

January

January

February

February

February

February

February

February

February

February

March

March

March

March

March

March

March

March

April

April

April

April

April

April

April

April

May

May

May

May

May

May

May

May

June

June Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol June

June

June

June

June

June

July

July

July

July

July

July

July

July

August

August

August

August

August

August

August

August

September

September

September

September

September

September

September

September

October

October

October

October

October

October

October

October

November

November

November

November

November

November

November Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View

Summit View Miscellaneous Products

Breakfast

Brunch

Lunch

Dinner

To Go Snacks

Non-Alcohol Beverages

Alcohol Beverages

Miscellaneous Products Miscellaneous

Food

Food

Food

Food

Food

Drinks - non-alcoholic

Drinks - Alcohol

Miscellaneous November

December

December

December

December

December

December

December

December Total Sales

Season

1125.56 Winter

1158.52 Winter

2215.38 Winter

3125.13 Winter

789.56 Winter

1616.23 Winter

566.76 Winter

1361.92 Winter

1401.8 Winter

2680.61 Winter

955.37 Winter

1955.69 Winter

1955.64 Winter

685.78 Winter

1496.99 Winter

1540.83 Winter

2946.45 Winter

4156.42 Winter

1050.12 Winter

2149.57 Winter

751.79 Winter

1615.13 Winter

1662.43 Winter

3178.98 Winter

4484.44 Winter

1133 Winter

2319.21 Winter

811.12 Winter

1049.84 Off

1080.58 Off

2066.34 Off

2914.89 Off

736.45 Off

1507.49 Off

527.23 Off

671.9 Off

691.57 Off

1322.46 Off

1865.53 Off

471.33 Off

964.79 Off

337.43 Off 564.39 Off

580.92 Off

1110.86 Off

1567.04 Off

395.91 Off

810.43 Off

283.44 Off

541.82 Off

557.68 Off

1066.43 Off

1504.36 Off

380.08 Off

778.01 Off

272.1 Off

567.82 Off

584.45 Off

1117.62 Off

1576.57 Off

398.32 Off

815.35 Off

285.16 Off

664.35 Off

683.81 Off

1307.61 Off

1844.59 Off

466.04 Off

953.96 Off

333.64 Off

890.23 Winter

916.3 Winter

1752.2 Winter

2471.75 Winter

624.49 Winter

1278.31 Winter

447.08 Winter

1531.2 Winter

1576.04 Winter

3013.79 Winter

4251.41 Winter

1074.12 Winter

2198.7 Winter

768.97 Winter

2987.16 Winter

2554.36 Winter

4278.19 Winter 1618.87 Winter

879.1 Winter

598.79 Winter

2215.25 Winter

545.98 Winter

3704.08 Winter

3167.41 Winter

5304.96 Winter

2007.4 Winter

1090.08 Winter

742.5 Winter

2746.91 Winter

677.02 Winter

4333.77 Winter

3705.87 Winter

6206.8 Winter

2348.66 Winter

1275.4 Winter

868.72 Winter

3213.88 Winter

792.11 Winter

4810.49 Winter

4113.51 Winter

6889.55 Winter

2607.01 Winter

1415.69 Winter

964.28 Winter

3567.41 Winter

879.24 Winter

1587.46 Off

1357.46 Off

2273.55 Off

860.31 Off

467.18 Off

318.21 Off

1177.25 Off

290.15 Off

1000.1 Off

855.2 Off

1432.34 Off

542 Off

294.32 Off

200.47 Off

741.66 Off

182.79 Off 420.04 Off

359.18 Off

601.58 Off

227.64 Off

123.62 Off

84.2 Off

311.5 Off

76.77 Off

452.39 Off

386.84 Off

647.9 Off

245.17 Off

133.13 Off

90.68 Off

335.48 Off

82.69 Off

533.81 Off

456.47 Off

764.53 Off

289.3 Off

157.1 Off

107.01 Off

395.87 Off

97.57 Off

912.82 Off

780.57 Off

1307.34 Off

494.7 Off

268.64 Off

182.98 Off

676.94 Off

166.84 Off

1944.31 Winter

1662.61 Winter

2784.63 Winter

1053.71 Winter

572.2 Winter

389.75 Winter

1441.88 Winter

355.37 Winter

2819.25 Winter

2410.78 Winter

4037.72 Winter

1527.87 Winter

829.69 Winter 565.13 Winter

2090.73 Winter

515.29 Winter

3128.56 Winter

2789.89 Winter

4278.19 Winter

5789.13 Winter

569.23 Winter

1256.19 Winter

4326.19 Winter

891.54 Winter

3389.26 Winter

3189.56 Winter

4789.23 Winter

6725.89 Winter

726.26 Winter

1689.23 Winter

5836.32 Winter

1121.99 Winter

3456.74 Winter

3698.25 Winter

5148.73 Winter

7256.78 Winter

811.46 Winter

1756.21 Winter

6174.56 Winter

1489.23 Winter

3291.11 Winter

3214.51 Winter

4687.53 Winter

6354.12 Winter

718.11 Winter

1599.23 Winter

5369.36 Winter

1002.25 Winter

1109.09 Off

749.26 Off

1298.23 Off

3219.69 Off

418.78 Off

716.82 Off

4412.72 Off

452.13 Off

534.36 Off

224.36 Off 453.24 Off

1583.23 Off

212.36 Off

412.45 Off

1952.23 Off

212.78 Off

415.12 Off

179.45 Off

354.89 Off

987.65 Off

369.23 Off

364.25 Off

1654.89 Off

257.69 Off

379.85 Off

789.25 Off

489.23 Off

789.23 Off

354.21 Off

312.58 Off

2457.29 Off

311.21 Off

401.25 Off

847.91 Off

501.26 Off

887.91 Off

471.94 Off

478.53 Off

2671.96 Off

253.19 Off

479.27 Off

978.91 Off

529.23 Off

1102.21 Off

522.12 Off

656.19 Off

2934.31 Off

301.09 Off

1965.31 Winter

2489.11 Winter

3121.21 Winter

4856.39 Winter

454.59 Winter

1154.87 Winter

3965.91 Winter 795.64 Winter

2987.22 Winter

3324.12 Winter

3978.27 Winter

6125.91 Winter

672.54 Winter

1358.12 Winter

4957.89 Winter

911.21 Winter

STATUS
QUALITY
Approved

This question was answered on: Feb 21, 2020

Solution~00066410127.zip (18.37 KB)