Week 1,2,3 Lab Summit Ridge Mountain Resort-Case Solution Sample

QUESTION

 

Lab Overview

Scenario/Summary

You are new to the staff of Summit Ridge Mountain Resort. One of the benefits to your employment is a free mountain ski pass. You are anxious to complete your work and enjoy a run down the mountain but know management is looking to you for important details and analysis for the ski resort overall. This week, management has asked that you begin to prepare a report for the Village Shop sales. The report will summarize all sales of all items and include the total profit-to-date with the amount remaining to reach the profit goal. You will open the partially completed workbook, create formulas, and format your work professionally.

Deliverables

After completing the steps below, turn in one Excel 2016 workbook. Rename the workbook with your lastname_first initial_Week1_Lab. xlsx. Example: If your name were Jane Doe, your workbook would be Doe_J_Week1_Lab.xlsx.

When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity.

The grading rubric for this assignment is available in the weekly Lab assignment page. The most successful students always review the criteria in this rubric before uploading their lab. This allows them to check that they have completed all of the steps in the lab. It is a very helpful final review prior to submission.

Lab Resources

Microsoft Office: Excel 2016

Options for Accessing Microsoft Excel 2016

  1. Use a personal copy on your PC. You can request a copy of Microsoft Office 2016 via the Student Software Store icon on the Course Resources page. Instructions – How to get your copy of Office 2016 (Links to an external site.)Links to an external site.
  2. If you are a MAC user, click to read the MAC User Information.
  3. If you do not have Excel 2016 installed locally, then access the software by going to the Course Resources page, Lab Resources section, and click the Virtual Lab Citrix icon.

Lab Steps

Preparation

You will be using Microsoft Excel 2016 for this lab.

Be sure you have read the required chapter materials and reviewed the hands-on exercise videos located on the Lesson page before you begin the lab. The videos provide detailed examples that walk you through steps similar to those you will be completing in the week’s lab. Completing the hands-on exercise examples will provide both practice and instruction to help you complete the lab steps successfully.

Your final Excel workbook for this lab should include two worksheets (Documentation and Sales-Data).

Begin: Opening and Saving

Download the spreadsheet STUDENT_BIS155_W1_Lab1_Starter_File.xlsx (Links to an external site.)Links to an external site.. You will be prompted to save the file. Click yes.

Open the saved file from your Download folder on your computer.

Note: If you are using the Remote Lab environment, you will need to follow the instructions for uploading the file. These instructions can be found on the Lab page when you click on the Lab icon on Course Resources.

To save the spreadsheet with a new file name

  • open the workbook in Excel 2016; and
  • in Excel, click File then Save as and rename it as lastname_first initial_Week1_Lab.xlsx (Jane Doe would save the file as Doe_J_Week1_Lab.xlsx).

Step 1: Adding a Documentation Sheet

  1. Insert a new spreadsheet into the workbook.
  2. Change the tab name from sheet 2 to Documentation. The documentation sheet should be moved to the first sheet in the workbook.
  3. Include your name, the date, and the purpose of the spreadsheet.
  4. Make sure you include block color formatting and text wrapping as needed. Your documentation sheet should look something like the one below.

Documentation Sheet

Step 2: Adding Calculations (Formulas)

Now we need to begin working on the worksheet with all of the data.

  1. Create the formulas needed to calculate the following for each item.
  2. Column N: Total Quantity Sold = Sum of all Daily Sales
  3. Column O: Net Selling Price = Selling Price * (1 – Sales Discount)
  4. Column P: Total Sales = Total Quantity Sold * Net Selling Price
  5. Column Q: Total Profit = Total Sales – (Cost per item * Total Quantity Sold)
  6. Column R: Average Profit % = Total Profit / Total Sales
  7. Create a Grand Total for the Total Profit column and place it in cell B21.
  8. Create a formula to calculate the Remaining Profit needed and place it in cell B22.
  9. Remaining Profit = The Profit Goal – Total Profit (all items)

One of the strengths of Excel is its ability to make tedious and repetitious calculations for speed and to reduce errors. Like all tools, there is always the possibility that you could use it incorrectly, so with formulas, it is important to verify the formulas you enter are correct. Notice that the daily sales columns between columns C and N are hidden in the picture below.

Click on Image to Expand

Step 3: Formatting

Apply formatting to your spreadsheet.

Your goal is to take into consideration readability, reliability, and reusability. Remember that presentation has an impact on the viewer, and professional appearance is important for reporting data, just as personal appearance impacts perception. The goal is to make the data more readable and possibly to highlight data that might otherwise be lost in many numbers.

The minimum formatting requirements (per the Grading Rubric) are the following.

  1. Title Rows formatted as titles, centered across all columns A–R
  2. Apply text wrapping to the column headers.
  3. Make professional font size and color changes.
  4. Make use of shading and borders.
  5. Format for currency, percentage, and numeric formatting.

Click Image to Expand

Step 4: Professional Appearance (Cleanup)

Cleanup the formatting of your report, taking into account professional appearance.

The Minimum Requirement (per the Grading Rubric)

  1. Apply a color and assign a descriptive name to each tab (sheet) in the workbook.
  2. Hide the Daily Sales columns (D–M).
  3. Create a custom page header with your professor’s name and your name.
  4. Set the page orientation to landscape.

 

Remember, professional appearance doesn’t only promote better readability of your report, it represents you as a professional.

Click Image to Expand

Finish: Save and Submit

Save your Excel file. Saving your file often is good practice (Ctrl + s).

Your Excel file should contain two worksheets.

  • Documentation
  • Sales-Data

Remember to provide a comment in the comments area explaining what you learned from completing this lab activity. Submit your completed Excel file (see the Deliverables above).

Keep this finished work, because you will be using it to begin the lab for Week 2.

 

Lab Overview

Scenario/Summary

Management at Summit Ridge Mountain Resort is very pleased with your initial report. This week, management has asked that you add to the prior analysis and incorporate some visual images concerning the Village Shop sales. This new analysis will require the use of new formulas, new functions, and several charts to graphically depict the report findings. This updated Excel workbook will be used for a presentation to the board of directors.

Deliverables

Submit one workbook to the Lab submission page. When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity.

File naming convention: If your name is Jane Doe, then your file should be named very similar to Doe_J_Week2_Lab.xlsx.

Make certain you compare your finished work with the Grading Rubric available on the Lab submission page.

Lab Resources

Microsoft Office: Excel 2016

Options for Accessing Microsoft Excel 2016

  1. Use a personal copy on your PC. You can request a copy of Microsoft Office 2016 via the Student Software Store icon on the Course Resources page.
  2. If you are a MAC user, click to read the MAC User Information.
  3. If you do not have Excel 2016 installed locally, then access the software by going to the Course Resources page, Lab Resources section, and click the Virtual Lab Citrix icon.

Lab Steps

Preparation

This lab will use Microsoft Excel 2016.

Be sure you have read the required chapter materials and reviewed the hands-on exercise videos located on the Lesson page before you begin the lab. The videos provide detailed examples that walk you through steps similar to those you will be completing in the week’s lab. Completing the hands-on exercise examples will provide both practice and instruction to help you complete the lab steps successfully.

Your final assignment workbook should include six worksheets (Documentation, Sales Data, Daily Item Totals, Total Items Bar Chart, Percent of Sales Pie Chart, and Profits by Day Line Chart).

To begin, open the Week 1 Lab you submitted last week and make any corrections or modifications.

Save this as a new Excel workbook named Doe_J_Week2_Lab.xlsx.

Follow the lab steps below to create formulas, utilize functions, and add charts to graphically depict the sales over time and by product.

Step 1: Create Daily Item Totals Worksheet

Click on the Sales Data worksheet. We need to see all of the hidden data, so unhide all hidden columns. Once you can see all the hidden data, we need to select data to copy to a new worksheet. Sort your data in A to Z order. Select the accessories data in column A, hold your control key down, and then select the daily sales data in columns D through M. Copy this selected data to a new sheet.

Click on the Image to Expand

  1. The Daily Sales data will look as follows on the new worksheet. Please name the tab for this worksheet Daily Item Totals.

Click on the Image to Expand

Create daily totals using the SUM function for each day and for each item. Make these pronounced by adding a bold font and some color formatting.

Click on the Image to Expand

  1. Let’s add a formula to calculate the percentage of sales for each item in column M. Percent of sales can be determined by dividing the total of each item (L4) by the total of all items (L17).
  2. Add functions to determine the best sale item, the lowest sale item, and the average of all sale items.
  3. Last, add a column called Profit per Item. Subtract the cost of the item from net selling price and place it in column N.

Click on the Image to Expand

Step 2: Create the Total Items Bar Chart

  1. Using the Daily Item Totals sheet, select the accessories data in column A, hold your control key down, and then select the Total Items Column L. While this data is selected, click the Insert tab on the ribbon. Choose a 2-D Bar Chart.
  2. Move this chart to a new worksheet.
  3. Your chart needs a professional title, and the worksheet tab should also be named appropriately.

Horizontal Bar Chart

Step 3: Create the Percentage of Sales Pie Chart

  1. Using the Daily Item Totals sheet, select the accessories data in column A, hold your control key down, and then select the Percent of Sales Column M. While this data is selected, click the Insert tab on the ribbon. Choose a 3-D Pie Chart.
  2. Move this chart to a new worksheet.
  3. Your chart needs a professional title, and the worksheet tab should also be named appropriately.

Pie Chart

Step 4: Create 10-Day Sales Report & Line Chart

  1. Copy the Daily Sales data to a new worksheet.
  2. Calculate the profit per item. Subtract the cost of the item from the net selling price and place it in column L.
  3. Next, create a new area on the same worksheet and calculate the profits for each item. For example, the profits for gloves in cell B19 are calculated as B3 * $L3.
  4. Autofill all item profits and create totals. 
  5. Lastly, select the dates across the horizontal, hold down the control key, and select the daily totals along the bottom. Insert a Line Chart like below.
  6. Give the chart a title, but leave it on the same worksheet.

Profits by Day Line Chart

Step 5: Professional Appearance (Cleanup)

Cleanup the formatting of your Excel workbook, taking into account professional appearance.

The Minimum Requirement (per the Grading Rubric)

  1. Apply a color and assign a descriptive name to each tab (sheet) in the workbook.
  2. Update the documentation worksheet to include contents of each worksheet.
  3. Make certain to include a custom page header on the Sales Data worksheet with your name and your instructor’s name.
  4. Set the page orientation to landscape.

 

Remember, professional appearance doesn’t only promote better readability of your report but represents you as a professional.

Finish: Save and Submit

Save your Excel file. Saving your file often is good practice (Ctrl + s).

Your Excel file should contain six worksheets.

  • Documentation
  • Sales Data
  • Daily Item Totals
  • Total Items Bar Chart
  • Percent of Sales Pie Chart
  • Profits by Day

Submit one workbook. When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity.

File naming convention: If your name was Jane Doe, then your file would be named Doe_J_Week2_Lab.xlsx.

week 3

ab Overview

Scenario/Summary

You are becoming more confident in your new position at Summit Ridge Mountain Resort. You are still meeting new coworkers and slowly but surely being asked to use more of your Excel skills for different departments at the resort. The manager handling sales for all of the condos in the Summit Ridge Mountain Village needs some help with his sales analysis. This report needs to clearly list and summarize all new loans for condominium sales and incorporate advanced functions and state loan statistics. In addition, you have been asked to investigate the claim made by the financing company to determine the true track record of the company in selling condos for the asking price. This will require advanced analysis techniques.

Software Citation Requirements

This course uses open-source software, which must be cited when used for any student work. Citation requirements are on the Open Source Applications page.
Please review the installation instruction files to complete your assignment.

Deliverables

After completing the steps below, turn in one Excel 2016 workbook. Rename the workbook with your lastname_first initial_Week3_Lab. xlsx. Example: If your name were Jane Doe, your workbook would be Doe_J_Week3_Lab.xlsx.

Make sure that you provide a comment explaining what you learned in the submission “Assignment Comment” box.

The grading rubric for this assignment is available in the weekly Lab assignment page. The most successful students always review the criteria in this rubric before uploading their lab.

Lab Resources

Microsoft Office: Excel 2016

Options for Accessing Microsoft Excel 2016

  1. Use a personal copy on your PC. You can request a copy of Microsoft Office 2016 via the Student Software Store icon on the Course Resources page.
  2. If you are a MAC user, click to read the MAC User Information.
  3. If you do not have Excel 2016 installed locally, then access the software by going to the Course Resources page, Lab Resources section, and click the Virtual Lab Citrix icon.

Lab Steps

Preparation

You will be using Microsoft Excel 2016 for this lab.

Be sure you have read the required chapter materials and reviewed the hands-on exercise videos located on the Lesson page before you begin the lab. The videos provide detailed examples that walk you through steps similar to those you will be completing in the week’s lab. Completing the hands-on exercise examples will provide both practice and instruction to help you complete the lab steps successfully.

Begin: Opening and Saving

Download the spreadsheet STUDENT_BIS155_W3_Lab3_Starter_File.xlsx (Links to an external site.)Links to an external site.. You will be prompted to save the file. Click yes.

Open the saved file from your Download folder on your computer.

Note: If you are using the Remote Lab environment, you will need to follow the instructions for uploading the file. These instructions can be found on the Lab page when you click on the Lab icon on Course Resources.

To save the spreadsheet with a new file name,

  • open the workbook in Excel 2016; and
  • in Excel, click File then Save as and rename it as lastname_first initial_Week3_Lab.xlsx (Jane Doe would save the file as Doe_J_Week3_Lab.xlsx).

Step 1: Add Formulas, Functions, and Formatting to Condo Sales Data Worksheet

Now we need to begin working on the worksheet 1. Let’s begin by renaming sheet 1 to Condo Sales Data.

  1. Create the formula needed to calculate the percent of asking price.
  2. Column H: Selling Price/ Asking Price
  3. Format the data on this sheet for currency, percent, and so forth.
  4. Format the title rows and center them across the column selection. Format the column headings appropriately.

An example of what your Condo Sales worksheet might look like is below.

Click Image to Expand

Step 2: Add Formulas, Functions, and Formatting to Loan Data Worksheet

Now we need to begin working on the worksheet 2. Let’s begin by renaming sheet 2 to Loan Data.

  1. Use the VLOOKUP function to determine the Interest Rate & PMT function to determine the monthly payment.
  2. Column E: Interest Rate using VLOOKUP
  3. Column F: Down Payment = VLOOKUP to determine % Required for Down Payment * Selling Price
  4. Column G: Amount Financed = Selling Price – Down Payment
  5. Column H: Monthly Payment = PMT function (Monthly payment is at the beginning of each period)
  6. Cells C41 – C44: Use functions COUNT, MIN, MAX & SUM to complete these loan statistics
  7. Format the data on this sheet for currency, percent, and so forth.
  8. Format the title rows and center them across the column selection. Format the column headings appropriately.
  9. Format the Loan Term Data and Loan Statistics with a clean outside border, color formatting, currency, and percent.

An example of what your Loan Data worksheet might look like is below.

Loan Data Worksheet

Step 3: Sort and Create Summary Report and Chart

  1. To create the Sorted Data worksheet, begin by creating a copy of the Condo Sales Data. Once a copy has been made of the Condo Sales Data and moved to a new sheet, name the new worksheet Sorted Data. We will not need the Address column, so please delete that column of data from the Sorted Data worksheet.
  2. Convert the data in the Sorted Data worksheet into a table. Select the rectangular block of cells contained in the Sorted Data worksheet. Click the Insert tab and select Tables from the Tables group. Remember to check that your table has headers.
  3. Sort the data by selling agent and then by asking price. Once the data has been sorted, you can convert it back into a range. You must convert to range before you can provide a summary report.
  4. Create a summary report showing total asking and total selling price by selling agent. Using subtotals, you will select the criteria for your subtotal. Each time the agent name changes, you want the total (sum) of both the Asking Price and Selling Price. Make sure the outline level of your subtotal is set to two on the left top area of your screen. Make sure you format your worksheet professionally.
  5. Click Image to Expand
  6. Create a Column Chart to compare asking price versus selling price by agent. Make certain you provide a professional chart title and formatting for your chart. Include a legend to show what each color represents. Move this chart to a new worksheet and name it Ask vs. Sell Price Chart.
  7. Click Image to Expand

Step 4: Create Filtered Data Worksheet

  1. To create the Filtered Data worksheet, begin by creating a copy of the Condo Sales Data. Once a copy has been made of the Condo Sales Data and moved to a new sheet, name the new worksheet Filtered Data.
  2. Convert the data in the Filtered Data worksheet into a table. Select the rectangular block of cells contained in the Filtered Data worksheet. Click the Insert tab and select Tables from the Tables group. Remember to check that your table has headers.
  3. Click the drop-down box next to Selling Agent. Uncheck Select All, and then check Langston.
  4. Now click the drop-down next to City and select only Pagosa. Now only the properties sold by Langston in Pagosa will display.
  5. Click Image to Expand

Step 5: Create Conditional Formatting Worksheet

  1. To create the Conditional Formatting worksheet, begin by creating a copy of the Condo Sales Data. Once a copy has been made of the Condo Sales Data and moved to a new sheet, name the new worksheet Conditional Formatting.
  2. Convert the data in the Conditional Formatting worksheet into a table. Click the Insert tab and select Tables from the Tables group. Remember to check that your table has headers.
  3. Select the data for just the column reflecting the % of Asking Price field. From the Home tab select Conditional Formatting from the Styles group and choose Manage Rules. Three new rules will need to be created.
    1. Format only cells that are greater than or equal to 100%; associate a green fill color and a black font with this rule.
    2. Format only cells that are between 95% and 99.9%; associate a yellow fill color and black font with this rule.
    3. Format only cells that are less than 95%; associate a red fill color and white font with this rule.
  1. Now sort the data based on the percentage of the asking price. Click the filter drop-down arrow and select Sort by Smallest to Largest.
  2. Click Image to Expand

Step 6: Create a Pivot Table

  1. In this step, we will create a named range called CondoSalesData. Open the Condo Sales Data worksheet and select Cells A3 through J33. From the Formulas tab select Define Name from the Defined Names group. Give this segment of the worksheet the name CondoSalesData. Notice it will appear in the name box when all of these cells are selected.
  2. Create a pivot table based on the CondoSalesData range.
    1. Select Selling Agent as your row labels.
    2. Click on City and then drag it into the Column Labels field.
    3. Select % of Asking (Price) as your values by clicking and then dragging it onto the values area.
    4. The summary value of the percent will be a SUM. To change this, click the drop-down area in the Values field and select Value Field Settings.
      1. Change the summary type to Average.
      2. Change the number format to percent with two decimals by clicking the Number Format button
      3. Change the summary label to Average % of Asking Price.
  1. Apply Data Bars Conditional Formatting to the percentages. Last, hide the field headers. Rename the sheet PivotTable, and move it so it is the last tab in the workbook.
  2. Click Image to Expand

Step 7: Professional Appearance (Cleanup)

Cleanup the formatting of your Excel workbook, taking into account professional appearance.

The Minimum Requirement (per the Grading Rubric)

  1. Apply a color and assign a descriptive name to each tab (sheet) in the workbook.
  2. Create the documentation worksheet using a format similar to Labs 1 and 2. Be sure to include a description of each worksheet. An image is provided below.
  3. Make certain to include a custom page header with your name and your instructor’s name on the Condo Sales Data worksheet.
  4. Based on your analysis, provide your conclusion concerning the Finance Company slogan. Do they really sell a condo for the asking price? Provide your answer on the Documentation sheet.

Remember, professional appearance doesn’t only promote better readability of your report; it represents you as a professional.

Week 3 Documentation Sheet

Step 8: Finish and Submit

Save your Excel file. Saving your file often is good practice (Ctrl + s).

Your Excel file should contain eight worksheets.

  • Documentation
  • Condo Sales Data
  • Loan Data
  • Sorted Data
  • Ask vs. Sell Price Chart
  • Filtered Data
  • Conditional Formatting Data
  • PivotTable

Submit one workbook. When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity.

File naming convention: If your name is Jane Doe, then your file should be named very similar to Doe_J_Week3_Lab.xlsx.

 

ANSWER

 

Cooper J Week1 Lab xlsl.

Dovumentation

Village Shop Sales
Created By Julia Cooper        
Date 2/1/2022        
Purpose Documentation Workbook on Village Shop Sales to Date        
Sales Data Contains Sales Data and calculation from Sales Data      

Sales Data

            Julia Cooper
               
Summit Ridge Mountain Resort
Village Shop Sales
               
Accessories Selling Price Cost per Item Total Quantity Sold Net Selling Price Total Sales Total Profit Avg. Profit %
Socks $12.00 $6.00 100 $10.56 $1,056.00 $456.00 43.18%
Gloves $21.00 $10.50 48 $18.48 $887.04 $383.04 43.18%
Mittens $22.00 $11.00 44 $19.36 $851.84 $367.84 43.18%
Goggles $25.00 $12.50 84 $22.00 $1,848.00 $798.00 43.18%
Sunglasses $18.00 $9.00 121 $15.84 $1,916.64 $827.64 43.18%
Sweater $35.00 $21.00 120 $30.80 $3,696.00 $1,176.00 31.82%
Scarves $50.00 $30.00 42 $44.00 $1,848.00 $588.00 31.82%
Sun Block $6.00 $2.50 148 $5.28 $781.44 $411.44 52.65%
T-shirts $26.00 $13.00 183 $22.88 $4,187.04 $1,808.04 43.18%
Ski pants $99.00 $49.00 92 $87.12 $8,015.04 $3,507.04 43.76%
Ski coats $150.00 $75.00 88 $132.00 $11,616.00 $5,016.00 43.18%
Long underwear $40.00 $19.00 138 $35.20 $4,857.60 $2,235.60 46.02%
Lip Balm $6.00 $1.50 252 $5.28 $1,330.56 $952.56 71.59%
               
Sales Discount: 0.12     Grand Total $18,527.20    
Profit Goal: $80,000.00     Remaining Profit $61,472.80    
Total Profits to date: $18,527.20            
Remaining Profit to Reach Goal $61,472.80          

 

Cooper J Week 2 Lab xlsl.

Documentation

Summit Ridge Mountain Resort
Village Shop Sales
Created By Julia Cooper        
Date 2/1/2022        
Purpose Documentation Workbook on Village Shop Sales to Date        
Sales Data Contains Sales Data and calculation from Sales Data        
Daily Item Totals Contains Daily Item Totals        
Total Quantity Sold Contains Total Quantity Sold        
Percentage of Sales Contains Percentage of Sales        
Profits by Data Contains Profits by Data      

 

Sales Data

 

Rajeev Bandhopadhyay                               Subhabrata Mukherjee
                                   
Summit Ridge Mountain Resort
Village Shop Sales
                                   
Accessories Selling Price Cost per Item 11/1/2016 11/2/2016 11/3/2016 11/4/2016 11/5/2016 11/6/2016 11/7/2016 11/8/2016 11/9/2016 11/10/2016 Total Quantity Sold Net Selling Price Total Sales Total Profit Avg. Profit %
Gloves $21.00 $10.50 5 3 7 3 6 5 3 7 3 6 48 $18.48 $887.04 $383.04 43.18%
Goggles $25.00 $12.50 2 7 8 9 16 2 7 8 9 16 84 $22.00 $1,848.00 $798.00 43.18%
Lip Balm $6.00 $1.50 44 31 22 19 15 34 31 22 19 15 252 $5.28 $1,330.56 $952.56 71.59%
Long underwear $40.00 $19.00 25 11 15 16 2 25 11 15 16 2 138 $35.20 $4,857.60 $2,235.60 46.02%
Mittens $22.00 $11.00 3 4 5 4 6 3 4 5 4 6 44 $19.36 $851.84 $367.84 43.18%
Scarves $50.00 $30.00 5 3 2 6 5 5 3 2 6 5 42 $44.00 $1,848.00 $588.00 31.82%
Ski coats $150.00 $75.00 7 4 11 13 9 7 4 11 13 9 88 $132.00 $11,616.00 $5,016.00 43.18%
Ski pants $99.00 $49.00 7 5 12 16 6 7 5 12 16 6 92 $87.12 $8,015.04 $3,507.04 43.76%
Socks $12.00 $6.00 12 15 9 11 3 12 15 9 11 3 100 $10.56 $1,056.00 $456.00 43.18%
Sun Block $6.00 $2.50 25 8 15 13 13 25 8 15 13 13 148 $5.28 $781.44 $411.44 52.65%
Sunglasses $18.00 $9.00 15 22 15 14 7 15 11 1 14 7 121 $15.84 $1,916.64 $827.64 43.18%
Sweater $35.00 $21.00 16 17 11 9 7 16 17 11 9 7 120 $30.80 $3,696.00 $1,176.00 31.82%
T-shirts $26.00 $13.00 10 12 21 27 22 10 12 21 17 31 183 $22.88 $4,187.04 $1,808.04 43.18%
Total     176 142 153 160 117 166 131 139 150 126          
Sales Discount: 0.12                                
Profit Goal: $80,000.00                                
Total Profits to date: $18,527.20                                
Remaining Profit to Reach Goal $61,472.80                                
                                 

 

Daily Item Total

Summit Ridge Mountain Resort      
Village Shop Sales      
                           
Accessories 11/1/2016 11/2/2016 11/3/2016 11/4/2016 11/5/2016 11/6/2016 11/7/2016 11/8/2016 11/9/2016 11/10/2016 Total Quantity Sold Percent of Sales Profit Per Item
Gloves 5 3 7 3 6 5 3 7 3 6 48 3% $7.98
Goggles 2 7 8 9 16 2 7 8 9 16 84 6% $9.50
Lip Balm 44 31 22 19 15 34 31 22 19 15 252 17% $3.78
Long underwear 25 11 15 16 2 25 11 15 16 2 138 9% $16.20
Mittens 3 4 5 4 6 3 4 5 4 6 44 3% $8.36
Scarves 5 3 2 6 5 5 3 2 6 5 42 3% $14.00
Ski coats 7 4 11 13 9 7 4 11 13 9 88 6% $57.00
Ski pants 7 5 12 16 6 7 5 12 16 6 92 6% $38.12
Socks 12 15 9 11 3 12 15 9 11 3 100 7% $4.56
Sun Block 25 8 15 13 13 25 8 15 13 13 148 10% $2.78
Sunglasses 15 22 15 14 7 15 11 1 14 7 121 8% $6.84
Sweater 16 17 11 9 7 16 17 11 9 7 120 8% $9.80
T-shirts 10 12 21 27 22 10 12 21 17 31 183 13% $9.88
Total 176 142 153 160 117 166 131 139 150 126 1460    
                           
Best Sale Item: 252                        
Lowest Sale Item: 42                        
Average of all items: 112                    

 

Total Quantity Solved

 

Percentage of Sales

 

Profit by Day

                       
10 Day Sales Report  
Accessories 11/1/2016 11/2/2016 11/3/2016 11/4/2016 11/5/2016 11/6/2016 11/7/2016 11/8/2016 11/9/2016 11/10/2016 Profit Per Item
Gloves 5 3 7 3 6 5 3 7 3 6 $7.98
Goggles 2 7 8 9 16 2 7 8 9 16 $9.50
Lip Balm 44 31 22 19 15 34 31 22 19 15 $3.78
Long underwear 25 11 15 16 2 25 11 15 16 2 $16.20
Mittens 3 4 5 4 6 3 4 5 4 6 $8.36
Scarves 5 3 2 6 5 5 3 2 6 5 $14.00
Ski coats 7 4 11 13 9 7 4 11 13 9 $57.00
Ski pants 7 5 12 16 6 7 5 12 16 6 $38.12
Socks 12 15 9 11 3 12 15 9 11 3 $4.56
Sun Block 25 8 15 13 13 25 8 15 13 13 $2.78
Sunglasses 15 22 15 14 7 15 11 1 14 7 $6.84
Sweater 16 17 11 9 7 16 17 11 9 7 $9.80
T-shirts 10 12 21 27 22 10 12 21 17 31 $9.88
                       
                       
                       
Profits by Day  
Accessories 11/1/2016 11/2/2016 11/3/2016 11/4/2016 11/5/2016 11/6/2016 11/7/2016 11/8/2016 11/9/2016 11/10/2016  
Gloves $39.90 $23.94 $55.86 $23.94 $47.88 $39.90 $23.94 $55.86 $23.94 $47.88  
Goggles $19.00 $66.50 $76.00 $85.50 $152.00 $19.00 $66.50 $76.00 $85.50 $152.00  
Lip Balm $166.32 $117.18 $83.16 $71.82 $56.70 $128.52 $117.18 $83.16 $71.82 $56.70  
Long underwear $405.00 $178.20 $243.00 $259.20 $32.40 $405.00 $178.20 $243.00 $259.20 $32.40  
Mittens $25.08 $33.44 $41.80 $33.44 $50.16 $25.08 $33.44 $41.80 $33.44 $50.16  
Scarves $70.00 $42.00 $28.00 $84.00 $70.00 $70.00 $42.00 $28.00 $84.00 $70.00  
Ski coats $399.00 $228.00 $627.00 $741.00 $513.00 $399.00 $228.00 $627.00 $741.00 $513.00  
Ski pants $266.84 $190.60 $457.44 $609.92 $228.72 $266.84 $190.60 $457.44 $609.92 $228.72  
Socks $54.72 $68.40 $41.04 $50.16 $13.68 $54.72 $68.40 $41.04 $50.16 $13.68  
Sun Block $69.50 $22.24 $41.70 $36.14 $36.14 $69.50 $22.24 $41.70 $36.14 $36.14  
Sunglasses $102.60 $150.48 $102.60 $95.76 $47.88 $102.60 $75.24 $6.84 $95.76 $47.88  
Sweater $156.80 $166.60 $107.80 $88.20 $68.60 $156.80 $166.60 $107.80 $88.20 $68.60  
T-shirts $98.80 $118.56 $207.48 $266.76 $217.36 $98.80 $118.56 $207.48 $167.96 $306.28  
  $1,873.56 $1,406.14 $2,112.88 $2,445.84 $1,534.52 $1,835.76 $1,330.90 $2,017.12 $2,347.04 $1,623.44  
                     

 

 

Cooper J Week3 Lab xlsl.

Documentation

Summit Ridge Mountain Resort Village Shop Sales Data
NAME   Julia Cooper
Date   2/1/2022
Purpose   Workbook on Shop Sales
Analysis   According to the data analysis done the asking price for the condos are quite a good offer
Content    
Condo Sales Data   Original Sales Data Stats
Loan Data   Loan Calculation and Stats
Sorted Data   Sorted Data using subtotal by selling agent
Ask Vs Sell Price Chart   Chart comparing Ask vs Sale price
Filtered Data   Filtered Data reflecting Langston for only Pagosa
Conditional Formating Data   Data formatted & sorted in order by % of asking price
Pivot Table   Average % asking price by Agent with condition

 

Condo Sales Data

The Condos at Summit Ridge Mountain
We sell your condo at the price you set!
Customer Address Type of Unit City Selling Agent Asking Price Selling Price % of Asking Listing Date Sale Date
Jones 8560 Summit Falls Road 4 Bedroom Pagosa Gonzales $725,000.00 $645,250.00 89% 4/1/2017 4/15/2017
Curp 7 Kingston Court 3 Bedroom Lazy Springs Langston $500,000.00 $465,000.00 93% 4/3/2017 4/10/2017
Aiello 7 Kingston Court 2 Bedroom Lazy Springs Kloster $219,000.00 $215,000.00 98% 4/4/2017 5/2/2017
Arnold 1971 Glenview Road 1 Bedroom Glen Lake Goodrich $110,000.00 $106,000.00 96% 4/12/2017 7/3/2017
Harris 1971 Glenview Road 1 Bedroom Glen Lake Minkus $165,000.00 $156,750.00 95% 4/12/2017 5/12/2017
Slaughter 7 Kingston Court 3 Bedroom Lazy Springs Pinter $450,000.00 $382,500.00 85% 4/15/2017 4/30/2017
Dyer 7 Kingston Court 3 Bedroom Lazy Springs Minkus $345,000.00 $339,999.00 99% 4/18/2017 5/23/2017
Graham 7 Kingston Court 3 Bedroom Lazy Springs Minkus $325,000.00 $308,750.00 95% 4/19/2017 5/31/2017
Pindergast 1971 Glenview Road 3 Bedroom Glen Lake Gonzales $325,000.00 $302,250.00 93% 4/28/2017 5/1/2017
Morgan 7 Kingston Court Studio Lazy Springs Pinkston $98,000.00 $93,100.00 95% 4/30/2017 6/19/2017
Rodgers 8560 Summit Falls Road 1 Bedroom Pagosa Langston $410,000.00 $397,700.00 97% 5/1/2017 6/25/2017
Fritz 1971 Glenview Road 2 Bedroom Glen Lake Gonzales $250,000.00 $255,000.00 102% 5/1/2017 5/18/2017
Collins 8560 Summit Falls Road 2 Bedroom Pagosa Singleton $185,500.00 $179,000.00 96% 5/1/2017 5/4/2017
Barboza 8560 Summit Falls Road 3 Bedroom Pagosa Kloster $77,500.00 $75,900.00 98% 5/5/2017 7/14/2017
Qualls 1971 Glenview Road 4 Bedroom Glen Lake Gonzales $450,000.00 $382,500.00 85% 5/5/2017 5/15/2017
Yates 7 Kingston Court 4 Bedroom Lazy Springs Pinkston $823,000.00 $799,000.00 97% 5/12/2017 6/6/2017
Young 8560 Summit Falls Road 3 Bedroom Pagosa Langston $650,000.00 $598,000.00 92% 5/15/2017 6/9/2017
Weger 7 Kingston Court 2 Bedroom Lazy Springs Singleton $310,000.00 $291,400.00 94% 5/22/2017 5/29/2017
Burnes 7 Kingston Court 1 Bedroom Lazy Springs Haley $147,800.00 $150,000.00 101% 5/22/2017 6/15/2017
Smith 1971 Glenview Road 2 Bedroom Glen Lake Goodrich $285,000.00 $276,450.00 97% 5/28/2017 6/18/2017
Thomas 8560 Summit Falls Road 2 Bedroom Pagosa Langston $179,900.00 $163,709.00 91% 5/31/2017 8/19/2017
Stone 8560 Summit Falls Road 1 Bedroom Pagosa Pinter $189,900.00 $182,304.00 96% 5/31/2017 6/1/2017
Oliver 1971 Glenview Road 2 Bedroom Glen Lake Haley $259,900.00 $246,905.00 95% 6/2/2017 9/2/2017
Morris 7 Kingston Court 1 Bedroom Lazy Springs Minkus $189,900.00 $186,102.00 98% 6/6/2017 7/25/2017
Miranda 8560 Summit Falls Road 2 Bedroom Pagosa Kloster $275,000.00 $264,000.00 96% 6/13/2017 7/21/2017
Medley 7 Kingston Court Studio Lazy Springs Minkus $89,000.00 $86,330.00 97% 6/18/2017 7/8/2017
Lind 8560 Summit Falls Road 2 Bedroom Pagosa Gonzales $254,500.00 $236,685.00 93% 6/23/2017 9/21/2017
King 8560 Summit Falls Road 2 Bedroom Pagosa Langston $555,000.00 $565,000.00 102% 6/24/2017 6/30/2017
Jordan 1971 Glenview Road 1 Bedroom Glen Lake Haley $165,900.00 $159,264.00 96% 6/29/2017 9/4/2017
Hall 8560 Summit Falls Road 1 Bedroom Pagosa Singleton $245,900.00 $233,605.00 95% 6/30/2017 8/14/2017

 

Average % of Asking Price City      
Selling Agent Glen Lake Lazy Springs Pagosa Total Result
Gonzales 93%   91% 92%
Goodrich 97%     97%
Haley 96% 101%   97%
Kloster   98% 97% 97%
Langston   93% 95% 95%
Minkus 95% 97%   97%
Pinkston   96%   96%
Pinter   85% 96% 91%
Singleton   94% 96% 95%
Total Result 95% 96% 95% 95%

 

LoanData

The Condos at Summit Ridge Mountain
We sell your condo at the price you set!
Customer Selling Agent Selling Price Loan Term Interest Rate Down Payment Amount to be Financed Monthly Payment
Jones Gonzales $645,250.00 30 6.25% $161,312.50 $483,937.50 ($17,375.70)
Curp Langston $465,000.00 30 6.25% $116,250.00 $348,750.00 ($12,521.81)
Aiello Kloster $215,000.00 20 6.00% $43,000.00 $172,000.00 ($9,013.56)
Arnold Goodrich $106,000.00 15 5.75% $15,900.00 $90,100.00 ($6,209.74)
Harris Minkus $156,750.00 15 5.75% $23,512.50 $133,237.50 ($9,182.79)
Slaughter Pinter $382,500.00 20 6.00% $76,500.00 $306,000.00 ($16,035.76)
Dyer Minkus $339,999.00 15 5.75% $50,999.85 $288,999.15 ($19,917.96)
Graham Minkus $308,750.00 30 6.25% $77,187.50 $231,562.50 ($8,314.21)
Pindergast Gonzales $302,250.00 30 6.25% $75,562.50 $226,687.50 ($8,139.18)
Morgan Pinkston $93,100.00 15 5.75% $13,965.00 $79,135.00 ($5,454.02)
Rodgers Langston $397,700.00 20 6.00% $79,540.00 $318,160.00 ($16,672.99)
Fritz Gonzales $255,000.00 20 6.00% $51,000.00 $204,000.00 ($10,690.50)
Collins Singleton $179,000.00 30 6.25% $44,750.00 $134,250.00 ($4,820.22)
Barboza Kloster $75,900.00 15 5.75% $11,385.00 $64,515.00 ($4,446.40)
Qualls Gonzales $382,500.00 20 6.00% $76,500.00 $306,000.00 ($16,035.76)
Yates Pinkston $799,000.00 30 6.25% $199,750.00 $599,250.00 ($21,515.98)
Young Langston $598,000.00 30 6.25% $149,500.00 $448,500.00 ($16,103.32)
Weger Singleton $291,400.00 30 6.25% $72,850.00 $218,550.00 ($7,847.00)
Burnes Haley $150,000.00 15 5.75% $22,500.00 $127,500.00 ($8,787.36)
Smith Goodrich $276,450.00 20 6.00% $55,290.00 $221,160.00 ($11,589.76)
Thomas Langston $163,709.00 20 6.00% $32,741.80 $130,967.20 ($6,863.26)
Stone Pinter $182,304.00 20 6.00% $36,460.80 $145,843.20 ($7,642.83)
Oliver Haley $246,905.00 15 5.75% $37,035.75 $209,869.25 ($14,464.29)
Morris Minkus $186,102.00 15 5.75% $27,915.30 $158,186.70 ($10,902.30)
Miranda Kloster $264,000.00 30 6.25% $66,000.00 $198,000.00 ($7,109.16)
Medley Minkus $86,330.00 15 5.75% $12,949.50 $73,380.50 ($5,057.42)
Lind Gonzales $236,685.00 30 6.25% $59,171.25 $177,513.75 ($6,373.60)
King Langston $565,000.00 30 6.25% $141,250.00 $423,750.00 ($15,214.68)
Jordan Haley $159,264.00 20 6.00% $31,852.80 $127,411.20 ($6,676.91)
Hall Singleton $233,605.00 20 6.00% $46,721.00 $186,884.00 ($9,793.55)
               
  Loan Term Interest Rate % Required for Down Payment        
  15 0.0575 0.15        
  20 0.06 0.2        
  30 0.0625 0.25        
  Loan Statistics            
    Number of Loans 30        
    Highest Amount Financed $599,250.00        
    Lowest Amount Financed $64,515.00        
    Total Amount Financed $6,834,099.95        
               
  Todays Date            
             

 

Sorted Data

The Condos at Summit Ridge Mountain
We sell your condo at the price you set!
Customer Type of Unit City Selling Agent Asking Price Selling Price % of Asking Listing Date Sale Date
Barboza 3 Bedroom Pagosa Kloster $77,500.00 $75,900.00 98% 5/5/2017 7/14/2017
Medley Studio Lazy Springs Minkus $89,000.00 $86,330.00 97% 6/18/2017 7/8/2017
Morgan Studio Lazy Springs Pinkston $98,000.00 $93,100.00 95% 4/30/2017 6/19/2017
Arnold 1 Bedroom Glen Lake Goodrich $110,000.00 $106,000.00 96% 4/12/2017 7/3/2017
Burnes 1 Bedroom Lazy Springs Haley $147,800.00 $150,000.00 101% 5/22/2017 6/15/2017
Harris 1 Bedroom Glen Lake Minkus $165,000.00 $156,750.00 95% 4/12/2017 5/12/2017
Jordan 1 Bedroom Glen Lake Haley $165,900.00 $159,264.00 96% 6/29/2017 9/4/2017
Thomas 2 Bedroom Pagosa Langston $179,900.00 $163,709.00 91% 5/31/2017 8/19/2017
Collins 2 Bedroom Pagosa Singleton $185,500.00 $179,000.00 96% 5/1/2017 5/4/2017
Morris 1 Bedroom Lazy Springs Minkus $189,900.00 $186,102.00 98% 6/6/2017 7/25/2017
Stone 1 Bedroom Pagosa Pinter $189,900.00 $182,304.00 96% 5/31/2017 6/1/2017
Aiello 2 Bedroom Lazy Springs Kloster $219,000.00 $215,000.00 98% 4/4/2017 5/2/2017
Hall 1 Bedroom Pagosa Singleton $245,900.00 $233,605.00 95% 6/30/2017 8/14/2017
Fritz 2 Bedroom Glen Lake Gonzales $250,000.00 $255,000.00 102% 5/1/2017 5/18/2017
Lind 2 Bedroom Pagosa Gonzales $254,500.00 $236,685.00 93% 6/23/2017 9/21/2017
Oliver 2 Bedroom Glen Lake Haley $259,900.00 $246,905.00 95% 6/2/2017 9/2/2017
Miranda 2 Bedroom Pagosa Kloster $275,000.00 $264,000.00 96% 6/13/2017 7/21/2017
Smith 2 Bedroom Glen Lake Goodrich $285,000.00 $276,450.00 97% 5/28/2017 6/18/2017
Weger 2 Bedroom Lazy Springs Singleton $310,000.00 $291,400.00 94% 5/22/2017 5/29/2017
Pindergast 3 Bedroom Glen Lake Gonzales $325,000.00 $302,250.00 93% 4/28/2017 5/1/2017
Graham 3 Bedroom Lazy Springs Minkus $325,000.00 $308,750.00 95% 4/19/2017 5/31/2017
Dyer 3 Bedroom Lazy Springs Minkus $345,000.00 $339,999.00 99% 4/18/2017 5/23/2017
Rodgers 1 Bedroom Pagosa Langston $410,000.00 $397,700.00 97% 5/1/2017 6/25/2017
Qualls 4 Bedroom Glen Lake Gonzales $450,000.00 $382,500.00 85% 5/5/2017 5/15/2017
Slaughter 3 Bedroom Lazy Springs Pinter $450,000.00 $382,500.00 85% 4/15/2017 4/30/2017
Curp 3 Bedroom Lazy Springs Langston $500,000.00 $465,000.00 93% 4/3/2017 4/10/2017
King 2 Bedroom Pagosa Langston $555,000.00 $565,000.00 102% 6/24/2017 6/30/2017
Young 3 Bedroom Pagosa Langston $650,000.00 $598,000.00 92% 5/15/2017 6/9/2017
Jones 4 Bedroom Pagosa Gonzales $725,000.00 $645,250.00 89% 4/1/2017 4/15/2017
Yates 4 Bedroom Lazy Springs Pinkston $823,000.00 $799,000.00 97% 5/12/2017 6/6/2017
               
The Condos at Summit Ridge Mountain
Customer Type of Unit City Selling Agent Asking Price Selling Price % of Asking Listing Date Sale Date
      Kloster Total $571,500.00 $554,900.00      
      Minkus Total $1,113,900.00 $1,077,931.00      
      Pinkston Total $921,000.00 $892,100.00      
      Goodrich Total $395,000.00 $382,450.00      
      Haley Total $573,600.00 $556,169.00      
      Gonzales Total $2,004,500.00 $1,821,685.00      
      Langston Total $2,294,900.00 $2,189,409.00      
      Singleton Total $741,400.00 $704,005.00      
      Pinter Total $639,900.00 $564,804.00      
      Grand Total $9,255,700.00 $8,743,453.00    

 

Ask vs Sell Price chart

 

Filtered Data

The Condos at Summit Ridge Mountain
We sell your condo at the price you set!
Customer Address Type of Unit City Selling Agent Asking Price Selling Price % of Asking Listing Date Sale Date
Rodgers 8560 Summit Falls Road 1 Bedroom Pagosa Langston $410,000.00 $397,700.00 97% 5/1/2017 6/25/2017
Young 8560 Summit Falls Road 3 Bedroom Pagosa Langston $650,000.00 $598,000.00 92% 5/15/2017 6/9/2017
Thomas 8560 Summit Falls Road 2 Bedroom Pagosa Langston $179,900.00 $163,709.00 91% 5/31/2017 8/19/2017
King 8560 Summit Falls Road 2 Bedroom Pagosa Langston $555,000.00 $565,000.00 102% 6/24/2017 6/30/2017

 

Conditional Formating

The Condos at Summit Ridge Mountain
We sell your condo at the price you set!
Customer Address Type of Unit City Selling Agent Asking Price Selling Price % of Asking Listing Date Sale Date
Slaughter 7 Kingston Court 3 Bedroom Lazy Springs Pinter $450,000.00 $382,500.00 85% 4/15/2017 4/30/2017
Qualls 1971 Glenview Road 4 Bedroom Glen Lake Gonzales $450,000.00 $382,500.00 85% 5/5/2017 5/15/2017
Jones 8560 Summit Falls Road 4 Bedroom Pagosa Gonzales $725,000.00 $645,250.00 89% 4/1/2017 4/15/2017
Thomas 8560 Summit Falls Road 2 Bedroom Pagosa Langston $179,900.00 $163,709.00 91% 5/31/2017 8/19/2017
Young 8560 Summit Falls Road 3 Bedroom Pagosa Langston $650,000.00 $598,000.00 92% 5/15/2017 6/9/2017
Curp 7 Kingston Court 3 Bedroom Lazy Springs Langston $500,000.00 $465,000.00 93% 4/3/2017 4/10/2017
Pindergast 1971 Glenview Road 3 Bedroom Glen Lake Gonzales $325,000.00 $302,250.00 93% 4/28/2017 5/1/2017
Lind 8560 Summit Falls Road 2 Bedroom Pagosa Gonzales $254,500.00 $236,685.00 93% 6/23/2017 9/21/2017
Weger 7 Kingston Court 2 Bedroom Lazy Springs Singleton $310,000.00 $291,400.00 94% 5/22/2017 5/29/2017
Harris 1971 Glenview Road 1 Bedroom Glen Lake Minkus $165,000.00 $156,750.00 95% 4/12/2017 5/12/2017
Graham 7 Kingston Court 3 Bedroom Lazy Springs Minkus $325,000.00 $308,750.00 95% 4/19/2017 5/31/2017
Morgan 7 Kingston Court Studio Lazy Springs Pinkston $98,000.00 $93,100.00 95% 4/30/2017 6/19/2017
Oliver 1971 Glenview Road 2 Bedroom Glen Lake Haley $259,900.00 $246,905.00 95% 6/2/2017 9/2/2017
Hall 8560 Summit Falls Road 1 Bedroom Pagosa Singleton $245,900.00 $233,605.00 95% 6/30/2017 8/14/2017
Stone 8560 Summit Falls Road 1 Bedroom Pagosa Pinter $189,900.00 $182,304.00 96% 5/31/2017 6/1/2017
Miranda 8560 Summit Falls Road 2 Bedroom Pagosa Kloster $275,000.00 $264,000.00 96% 6/13/2017 7/21/2017
Jordan 1971 Glenview Road 1 Bedroom Glen Lake Haley $165,900.00 $159,264.00 96% 6/29/2017 9/4/2017
Arnold 1971 Glenview Road 1 Bedroom Glen Lake Goodrich $110,000.00 $106,000.00 96% 4/12/2017 7/3/2017
Collins 8560 Summit Falls Road 2 Bedroom Pagosa Singleton $185,500.00 $179,000.00 96% 5/1/2017 5/4/2017
Rodgers 8560 Summit Falls Road 1 Bedroom Pagosa Langston $410,000.00 $397,700.00 97% 5/1/2017 6/25/2017
Smith 1971 Glenview Road 2 Bedroom Glen Lake Goodrich $285,000.00 $276,450.00 97% 5/28/2017 6/18/2017
Medley 7 Kingston Court Studio Lazy Springs Minkus $89,000.00 $86,330.00 97% 6/18/2017 7/8/2017
Yates 7 Kingston Court 4 Bedroom Lazy Springs Pinkston $823,000.00 $799,000.00 97% 5/12/2017 6/6/2017
Barboza 8560 Summit Falls Road 3 Bedroom Pagosa Kloster $77,500.00 $75,900.00 98% 5/5/2017 7/14/2017
Morris 7 Kingston Court 1 Bedroom Lazy Springs Minkus $189,900.00 $186,102.00 98% 6/6/2017 7/25/2017
Aiello 7 Kingston Court 2 Bedroom Lazy Springs Kloster $219,000.00 $215,000.00 98% 4/4/2017 5/2/2017
Dyer 7 Kingston Court 3 Bedroom Lazy Springs Minkus $345,000.00 $339,999.00 99% 4/18/2017 5/23/2017
Burnes 7 Kingston Court 1 Bedroom Lazy Springs Haley $147,800.00 $150,000.00 101% 5/22/2017 6/15/2017
King 8560 Summit Falls Road 2 Bedroom Pagosa Langston $555,000.00 $565,000.00 102% 6/24/2017 6/30/2017
Fritz 1971 Glenview Road 2 Bedroom Glen Lake Gonzales $250,000.00 $255,000.00 102% 5/1/2017 5/18/2017
                 

 

Pivot Table

Average % of Asking Price City      
Selling Agent Glen Lake Lazy Springs Pagosa Total Result
Gonzales 93%   91% 92%
Goodrich 97%     97%
Haley 96% 101%   97%
Kloster   98% 97% 97%
Langston   93% 95% 95%
Minkus 95% 97%   97%
Pinkston   96%   96%
Pinter   85% 96% 91%
Singleton   94% 96% 95%
Total Result 95% 96% 95% 95%

 

Looking for best Case Study Assignment Help. Whatsapp us at +16469488918 or chat with our chat representative showing on lower right corner or order from here. You can also take help from our Live Assignment helper for any exam or live assignment related assistance.