About SmartExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:

Accounting,Business & Finance See all

Accounting,Business & Finance,Economics,English,HR Management,Math Hide all

Teaching Since:	Apr 2017
Last Sign in:	56 Weeks Ago, 4 Days Ago
Questions Answered:	7570
Tutorials Posted:	7352

Education

BS,MBA, PHD
Adelphi University/Devry
Apr-2000 - Mar-2005

Experience

HOD ,Professor
Adelphi University
Sep-2007 - Apr-2017

Category > Accounting Posted 05 Nov 2017 My Price 10.00

BIS 155 Week 3 Lab 3 Summit Ridge Mountain Resort Luxury Condo Sales

Complete Lab 3: Summit Ridge Mountain Resort: Luxury Condo Sales. Basic instructions are in the Lab Overview page. You will be required to use your skills from the text and tutorials to complete the lab. Be sure to watch and work through the hands-on exercise videos in the lesson for guidance on completing this assignment.

Submit your lab.

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.

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.

Grading Rubric

Step	Task	Points Possible
Lab 3 – Luxury Condo Sales
1	Condo Sales Worksheet
1a	Calculate % of asking price	2
1b, c	Format worksheet (column width, headings, colors, data types)	2
2	Loan Data Worksheet
2a	VLOOKUP for Interest Rate and Down Payment	5
	Calculate Amount Financed	2
	PMT function for Monthly Payment and functions for loan statistics	4
2b, c, d	Format worksheet (column width, headings, colors, data types)	2
3	Sort and Create Summary Report and Chart
3a, b	Create Sorted Data worksheet	2
3c	Sort and Order Sorted Data	2
3d,e	Create a summary report and a column chart	3
4	Filter the Data
4a	Create Filtered Data worksheet	2
4b, c, d	Filter the Data	4
5	Conditional Formatting
5a, b	Create Conditional Format worksheet and Insert a table	2
5c	Set up conditional formatting rules	4
5d	Sort by color	2
6	Pivot Table
6a	Select Data and Name Range of Cells	3
6b	Create Pivot table	4
6c	Formatting	2
7	Draw conclusion
	Documentation sheet completed	4
	Is the slogan a true statement?	4
Comment:	What you learned from completing this Lab	5
TOTAL POINTS		60

When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity. Make certain you compare your finished work with the Grading Rubric included here.

Answers

SmartExpert

(118)

Status NEW Posted 05 Nov 2017 06:11 PM My Price 10.00

BI-----------S 1-----------55 -----------Wee-----------k 3----------- La-----------b 3----------- Su-----------mmi-----------t R-----------idg-----------e M-----------oun-----------tai-----------n R-----------eso-----------rt -----------Lux-----------ury----------- Co-----------ndo----------- Sa-----------les-----------

Attachments

file 1510171101-BIS 155 Week 3 Lab 3 Summit Ridge Mountain Resort Luxury Condo Sales.xlsx preview (231 words )

Ad-----------dre-----------ssC-----------ity-----------Sel-----------lin-----------g A-----------gen-----------tAs-----------kin-----------g P-----------ric-----------eSe-----------lli-----------ng -----------Pri-----------ce%----------- of----------- As-----------kin-----------gLi-----------sti-----------ng -----------Dat-----------eSa-----------le -----------Dat-----------e7 -----------Kin-----------gst-----------on -----------Cou-----------rtG-----------ood-----------ric-----------hMi-----------nku-----------s19-----------71 -----------Gle-----------nvi-----------ew -----------Roa-----------dTh-----------e C-----------ond-----------os -----------at -----------Sum-----------mit----------- Ri-----------dge----------- Mo-----------unt-----------ain-----------Gon-----------zal-----------esW-----------e s-----------ell----------- yo-----------ur -----------con-----------do -----------at -----------the----------- pr-----------ice----------- yo-----------u s-----------et!----------- La-----------ngs-----------ton-----------Klo-----------ste-----------rGl-----------en -----------Lak-----------ePi-----------nks-----------ton-----------Hal-----------eyP-----------int-----------er8-----------560----------- Su-----------mmi-----------t F-----------all-----------s R-----------oad-----------Typ-----------e o-----------f U-----------nit-----------2 B-----------edr-----------oom-----------Sin-----------gle-----------ton-----------Pag-----------osa-----------1 B-----------edr-----------oom-----------3 B-----------edr-----------oom-----------4 B-----------edr-----------oom-----------Stu-----------dio-----------Loa-----------n T-----------erm-----------Int-----------ere-----------st -----------Rat-----------e% -----------Req-----------uir-----------ed -----------for----------- Do-----------wn -----------Pay-----------men-----------tLo-----------an -----------Sta-----------tis-----------tic-----------sNu-----------mbe-----------r o-----------f L-----------oan-----------sHi-----------ghe-----------st

Not Rated(0)

Buy Answer

Relevent Questions

BIS 155 Week 3 Lab 3 Summit Ridge Mountain Resort ...

Hire Dedicated Virtual Team / Business Solution for SMEs.