View the step-by-step solution to:

REGIONAL REALTY ASSOCIATION AUTHOR DATE PURPOSE ANALYSIS CORA WILKE 1/23/2016 ANALYSIS OF THE CLAIM BY LUKE LIBERTY REALTY No they should not...

Good Day I was working with a friend of yours screen name HellBaron but I am not able to ask him a direct question right now for some reason.  I am needing help with a lab from my Excel class but once I  open it, you will have 4 hours to complete and turn in.  I wanted to attach my prior labs in Excel so you have an idea of what to expect once the document it opened.  I have put the deadline to this Saturday only because that is the date everything needs to be done.  I need to know the best date and time that you want me to open up the document.

REGIONAL REALTY ASSOCIATION AUTHOR CORA WILKE DATE 1/23/2016 PURPOSE ANALYSIS ANALYSIS OF THE CLAIM BY LUKE LIBERTY REALTY No they should not advertise that they your get your price. On the analysis the average price they get of the asking price is 95.26%. Out of the twenty nine sales they only managed to get the asking price in three of the sales only!
Background image of page 1
Luke Liberty Realty We get your price and we sell it quickly! Address City Selling Agent Asking Price Selling Price % of Asking LisTng Date Sale Date 8687 Kenwood Road Miami Hernandez $725,000 $645,250 89.0% 1-Apr 15-Apr 7 Kingston Court Sunrise Carey $500,000 $465,000 93.0% 3-Apr 10-Apr 1370 Pinellas Road Sunrise Lugo $219,000 $215,000 98.2% 4-Apr 2-May 10995 SW 88 Court Coral Gables Goodrich $110,000 $106,000 96.4% 12-Apr 3-Jul 1971 Glenview Road Coral Gables Minkus $165,000 $156,750 95.0% 12-Apr 12-May 8030 Steeplechase Drive Sunrise Merkin $450,000 $382,500 85.0% 15-Apr 30-Apr 2006 Cutwater Court Sunrise Minkus $345,000 $339,999 98.6% 18-Apr 23-May 4081 Lybyer Avenue Sunrise Minkus $325,000 $308,750 95.0% 19-Apr 31-May 758 University Drive Coral Gables Hernandez $325,000 $302,250 93.0% 28-Apr 1-May 224 Rockaway Street Sunrise Pijuan $98,000 $93,100 95.0% 30-Apr 19-Jun 11971 SW 269 Terrace Miami Carey $410,000 $397,700 97.0% 1-May 25-Jun 8307 S Indian River Drive Coral Gables Hernandez $250,000 $255,000 102.0% 1-May 18-May 9408 Forest Hills Circle Miami Reuter $185,500 $179,000 96.5% 1-May 4-May 16235 Orange Boulevard Miami Lugo $77,500 $75,900 97.9% 5-May 14-Jul 2448 Woodacres Road Coral Gables Hernandez $450,000 $382,500 85.0% 5-May 15-May 1414 N Sheridan Road Sunrise Pijuan $1,250,000 $1,225,000 98.0% 12-May 6-Jun 10700 Lake Shore Lane Miami Carey $650,000 $598,000 92.0% 15-May 9-Jun 605 Reservoir Drive Sunrise Reuter $310,000 $291,400 94.0% 22-May 29-May 81 Island Drive South Sunrise Bethune $147,800 $150,000 101.5% 22-May 15-Jun 1 Southampton Place Coral Gables Goodrich $285,000 $276,450 97.0% 28-May 18-Jun 1629 NW 43rd Street Miami Carey $179,900 $163,709 91.0% 31-May 19-Aug 21 Compass Road Miami Merkin $189,900 $182,304 96.0% 31-May 1-Jun 30 Kent Road Coral Gables Bethune $259,900 $246,905 95.0% 2-Jun 2-Sep 520 E Spring Street Sunrise Minkus $189,900 $186,102 98.0% 6-Jun 25-Jul 4916 Rock Spring Road Miami Lugo $275,000 $264,000 96.0% 13-Jun 21-Jul 8923 Harris Drive Sunrise Minkus $89,000 $86,330 97.0% 18-Jun 8-Jul 1132 SW 52nd Street Miami Hernandez $254,500 $236,685 93.0% 23-Jun 21-Sep 10 Vestal Drive Miami Carey $555,000 $565,000 101.8% 24-Jun 30-Jun 103 Jasper Drive Coral Gables Bethune $165,900 $159,264 96.0% 29-Jun 4-Sep 1600 Reeves Street Miami Reuter $245,900 $233,605 95.0% 30-Jun 14-Aug
Background image of page 2
Show entire document
Upper Saddle River Marching Band—Fundraising Event Creator: Cora Wilke Date: 1/10/2015 Purpose: Board of Directors Presentation on Fundraising Sales to date
Background image of page 1
Upper Saddle River Marching Band - Fundraising Event Band Booster Equipment Sales through Day 10 Proft Goal: 50,000 QuanTty Sold Each Day Item Selling Price Cost per Item 7/4/2015 7/5/2015 7/7/2015 7/8/2015 7/9/2015 7/10/2015 7/11/2015 7/12/2015 7/13/2015 7/14/2015 Net Selling Price Total Sales Total Proft Avg. Proft % Tee Shirt 15 7 56 12 14 22 18 17 19 19 18 25 $ 12.75 $ 2,805.00 $1,265.00 45% Baseball Hat 20 6.5 22 9 8 11 8 13 14 12 8 10 $ 17.00 $ 1,955.00 $1,207.50 62% Golf Shirt 30 11 6 7 6 9 5 11 8 11 7 14 $ 25.50 $ 2,142.00 $1,218.00 57% Head Covers 23 14 2 5 8 3 9 4 9 7 2 11 $ 19.55 $ 1,173.00 $333.00 28% Warm Up Suit 60 34 23 10 8 12 12 14 15 14 16 12 $ 51.00 $ 6,936.00 $2,312.00 33% Sweater 35 13 23 13 11 15 12 19 15 14 16 12 $ 29.75 $ 4,462.50 $2,512.50 56% Sweat Shirt 20 8.5 5 1 0 1 2 2 2 2 6 2 $ 17.00 $ 391.00 $195.50 50% Sweat Pants 20 7.5 10 2 5 2 8 8 8 8 13 4 $ 17.00 $ 1,156.00 $646.00 56% Calling Card 100 45 10 2 5 2 4 8 8 8 13 4 $ 85.00 $ 5,440.00 $2,560.00 47% Lamp 135 65 18 6 11 4 10 8 8 8 13 4 $ 114.75 $ 10,327.50 $4,477.50 43% Grand Totals: $ 36,788.00 $ 16,727.00 478% Sales Discount: 0.15 All Items Average Proft 48% $ 33,273.00 Remaining Proft to Reach Goal
Background image of page 2
Show entire document
FIRST NATIONAL BANK Author Cora Wilke Date 1/14/2016 Purpose Monthly New Loan Report
Background image of page 1
LOAN REPORT
Background image of page 2
Show entire document
TUDENT EDUCATION TRUS UTHOR CORA WILKE DATE 29 January 2016 URPOSE DONOR'S INFORMATION WHO CONTRIBUTED TO THE AUCTION
Background image of page 1
FirstName LastName Address City State Zip Code Item Donated Item Value Number ATending Shelly Martn 123 NorTh STreeT Pi±sburgh PA 15697 Massage $50 2 Kelly KripTon 456 NorTh STreeT Pi±sburgh PA 15697 FooTball ²ickeTs $75 2 Kim Jansen 678 NorTh STreeT Pi±sburgh PA 15697 Golf Clubs $200 4 Donna Reed 901 NorTh STreeT Pi±sburgh PA 15697 HoTel Accommodatons $100 5 Huong Pham P.O. Box ABC Pi±sburgh PA 15697 ResTauranT Gi³ Cert´caTe $60 1 George Martn 555 Kaminini STreeT Pi±sburgh PA 15697 Car Wash Card $50 1 Marion McMahon 2216 CaTharine STreeT Pi±sburgh PA 15697 AuTomotve Gi³ Cert´caTe $50 2 CaTherine McQuaide 31 OakmonT Circle Pi±sburgh PA 15697 10 pounds of Fresh Fish $100 2 ChrisTopher Martnez 15709 Holly Grove Rd. Pi±sburgh PA 15697 Lei-Making Class $25 2 G Mican 3509 Carla Drive Pi±sburgh PA 15697 STarbucks Gi³ Card $10 2 George McFall 123 NorTh STreeT Pi±sburgh PA 15697 Movie ²ickeTs + Popcorn $20 2 KrisTen KripTon 456 NorTh STreeT Pi±sburgh PA 15697 Free PhoTography Siµng $45 4 Kim Jones 678 NorTh STreeT Pi±sburgh PA 15697 Fondue SeT $20 4 Dan Reed 901 NorTh STreeT Pi±sburgh PA 15697 Yoga Class $100 4 Huong Ngyun P.O. Box ABC Pi±sburgh PA 15697 HealTh Club IniTaton Waiver $250 3 RoberT McMahon 2216 CaTharine STreeT Pi±sburgh PA 15697 Web SiTe Services $100 2 Dennis BooThe 3646 SeTon Hall Way Pi±sburgh PA 15697 YMCA Swimming Lessons $65 4 Emiko Francani 800 NorTh STreeT Pi±sburgh PA 15697 Gi³ Cert´caTe for Floral ArrangemenT $75 2 ²ara Huber 9507 Sandy Elms Pi±sburgh PA 15697 LapTop CompuTer $1,000 2 Benjamin Brown 143 SunseT Avenue Pi±sburgh PA 15697 DigiTal Camera $400 3 RoberT Hall P. O. Box 121802 Pi±sburgh PA 15697 Grocery Gi³ Cert´caTe $50 4 CaTherine McCue 31 OakmonT Circle Pi±sburgh PA 15697 ResTauranT Gi³ Cert´caTe $40 4 Jennifer Ward 377 Hillman Avenue Pi±sburgh PA 15697 1-Year Free Co¶ee $100 2 Michael Anderson 1 Clark SmiTh Drive Pi±sburgh PA 15697 Gi³ BaskeT $75 2 NaTalie Barguno 1661 Cardinal Drive Pi±sburgh PA 15697 ²oy STore Gi³ Cert´caTe $50 1
Background image of page 2
Student Education Trust 123 Adams Street Pittsburgh, PA 15697 Shelly Martin 123 North Street PittsburghPA15697 Dear Shelly, Thank you for your generous donation to the Student Education Trust Fundraiser. We are delighted to accept the following donation: Item:Massage Item Value: 50 Enclosed you will ±nd the 2 tickets you requested for this Fundraising event, which will take place on Friday, October 24, 2015. We will be looking forward to seeing you and giving our personal thanks. Thank you again for your support of the fund. The proceeds will support international animal rescue e²orts. With special thinks, Jeo²rey McMillan President Student Education Trust
Background image of page 01
Student Education Trust 123 Adams Street Pittsburgh, PA 15697 Kelly Kripton 456 North Street PittsburghPA15697 Dear Kelly, Thank you for your generous donation to the Student Education Trust Fundraiser. We are delighted to accept the following donation: Item: Football Tickets Item Value: 75 Enclosed you will ±nd the 2 tickets you requested for this Fundraising event, which will take place on Friday, October 24, 2015. We will be looking forward to seeing you and giving our personal thanks. Thank you again for your support of the fund. The proceeds will support international animal rescue e²orts. With special thinks, Jeo²rey McMillan President Student Education Trust
Background image of page 02
Show entire document
Carina's Dining Analysis Created by: Cora Wilke Date Created 2/22/2016 Date Modifed 2/22/2016 Purpose Contents Summary art Analysis Comment PerForm analysis oF revenues From Carina's restauramt This sheet contains the total revenue from the three restaurants: Downtown, Southside and Northside per quarter and dining category This sheet contains a chart displaying the trends per dining category per quarter According to my analysis I think Carina should add another store to her chain.This is because the current stores are doing well according to the revenues. Is she should add another store it should be prefferably for delivery since that is where there is growth in revenues
Background image of page 1
Carina's Dining Analysis 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total Dine-In $97,000 $85,000 $75,000 $61,000 $318,000 Pick-up $108,000 $110,000 $108,000 $109,000 $435,000 Delivery $72,000 $95,000 $126,000 $157,000 $503,000 Total $277,000 $290,000 $309,000 $327,000 $1,203,000
Background image of page 2
Show entire document
Adair's Day Care Solution Author Cora Wilke Date Created 2/6/2016 Last Modified 2/22/2016 Purpose Contents Income Statement Scenario Summary Recommendation Analysis of the eFects of change in assumptions on expenses and Net Income for Adair Daycare Provides information for various factors that aFect the Expenses and Net Income Provides a summary for the various scenarios for Adair Day Care (Economy Mid Range and High) Adair should consider using the Economy or High values since they maximize pro±ts compared to the Mid Range option.
Background image of page 1
Adair's Day Care Income Statement Teacher:Student Ratio Required Students Teachers 1 1 Assumptions 7 2 Number of Children/Day 8 13 3 Average Days per Year 250 19 4 Teacher Cost per Year 26,000 Food per Child per Day 1.3 Effect of varying number of children on expenses and n Supplies per Child per Year 60 Initial Values 6 7 8 9 10 Expenses $79,480 $52,735 $79,108 $79,480 $79,853 $80,225 Annual Revenue Net Income $20,520 $22,265 $8,393 $20,520 $32,648 $44,775 Tuition per Day 50 Annual Revenue $ 100,000 Fee Effect on Income of Varying Fee and Numbe Annual Variable Expenses $ 20,520 6 7 8 9 10 Food Expenses 2,500 35 -$235 -$17,858 -$9,480 -$1,103 $7,275 Supplies per Year 480 40 $7,265 -$9,108 $520 $10,148 $19,775 Teacher Cost 52,000 45 $14,765 -$358 $10,520 $21,398 $32,275 Total Variable Expenses $ 54,980 50 $22,265 $8,393 $20,520 $32,648 $44,775 55 $29,765 $17,143 $30,520 $43,898 $57,275 Annual Fixed Expenses 60 $37,265 $25,893 $40,520 $55,148 $69,775 Insurance 5,000 65 $44,765 $34,643 $50,520 $66,398 $82,275 Maintenance 6,500 70 $52,265 $43,393 $60,520 $77,648 $94,775 Administrative & Advertising 1,000 75 $59,765 $52,143 $70,520 $88,898 $107,275 Est. Taxes 12,000 Total Fixed Expenses $ 24,500 Summary Total Revenue 100,000 Total Expenses 79,480 Net Income $ 20,520
Background image of page 2
Show entire document
StaTsTcs Creator: Cora Wilke Date: 2/21/2016 Purpose: The value of statistics lies in the ability to analyze data more effectively for the purpose of improving decision making
Background image of page 1
State Avg °F Avg °C Rank 62.8 17.1 7 26.6 -3 50 60.3 15.7 10 60.4 15.8 9 59.4 15.2 12 45.1 7.3 39 49 9.4 29 55.3 12.9 16 70.7 21.5 1 63.5 17.5 5 70 21.1 2 44.4 6.9 40 51.8 11 23 51.7 10.9 25 47.8 8.8 36 54.3 12.4 19 55.6 13.1 15 66.4 19.1 3 41 5 48 54.2 12.3 20 47.9 8.8 35 44.4 6.9 40 41.2 5.1 47 63.4 17.4 6 54.5 12.5 18 42.7 5.9 45 48.8 9.3 30 49.9 9.9 28 43.8 6.6 42 52.7 11.5 22 53.4 11.9 21 45.4 7.4 37 59 15 13 40.4 4.7 49 50.7 10.4 26 59.6 15.3 11 48.4 9.1 33 48.8 9.3 30 50.1 10.1 27 62.4 16.9 8 45.2 7.3 38 57.6 14.2 14 64.8 18.2 4 Avg °F Avg °C Rank 48.6 9.2 32 Mean 51.94 Mean 11.07 Mean 25.44 42.9 6.1 44 Standard Error 1.23 Standard Error 0.68 Standard Error 2.06 55.1 12.8 17 Median 51.20 Median 10.65 Median 25.50 48.3 9.1 34 Mode 44.40 Mode 7.30 Mode 40.00 51.8 11 23 Standard DeviaTon 8.71 Standard DeviaTon 4.83 Standard DeviaTon 14.55 43.1 6.2 43 Sample Variance 75.80 Sample Variance 23.33 Sample Variance 211.76 42 5.6 46 Kurtosis 0.37 Kurtosis 0.38 Kurtosis -1.19 Skewness -0.01 Skewness -0.01 Skewness 0.01 Count 50 50 50 Range 44.10 Range 24.50 Range 49.00 Average 51.944 11.074 25.44 Minimum 26.60 Minimum -3.00 Minimum 1.00 Median 51.2 10.65 25.5 Maximum 70.70 Maximum 21.50 Maximum 50.00 Mode 44.4 6.9 23 Sum 2597.20 Sum 553.70 Sum 1272.00 Min 26.6 -3 1 Count 50.00 Count 50.00 Count 50.00 Max 70.7 21.5 50 Alabama Alaska Arizona Arkansas California Colorado ConnecTcut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachuse±s Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota ²ennessee ²exas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

PFA. Do not forget to... View the full answer

solution.xlsx

BIS-155 Final Exam Practical Problems
Music on Demand (V3)
Name:
Date: Music on Demand-Sales by Product
Product
Vinyl Albums
Cassettes
Digital
Single Songs
Headsets
Turn tables
Speakers
Wiring...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online