# Sales Report

Submitted By myarmy1
Words 329
Pages 2
3 Real Estate Sales Report

You own a small real estate company in Enid, Oklahoma. You want to analyze sales for selected properties. Your assistant prepared a spreadsheet with some of the data from the files. You need to calculate the number of days that the houses were on the market and their sales percentage of the list price. In one situation, the house was involved in a bidding war between two families that really wanted the house. Therefore, the sale price exceeded the list price.
a.Open the e01m3sales workbook and save the workbook as e01m3sales_LastnameFirstname so that you can return to the original workbook if necessary.
b.Delete the row that has incomplete sales data. The owners took their house off the market.
c.Calculate the number of days each house was on the market. Copy the formula down that column.
d.Calculate the sale price percentage of the list price. The second house was listed for \$500,250, but it sold for only \$400,125. Therefore, the sale percentage of the list price is 79.99%. Format the percentages with two decimal places.
e.Format prices with Accounting Number Format with zero decimal places.
f.Wrap the headings on row 4.
g.Insert a new column between the Date Sold and List Price columns. Move the Days on Market column to the new location. Then delete the empty column B.
h.Edit the list date of the 41 Chestnut Circle house to be 4/20/2012. Edit the list price of the house on Amsterdam Drive to be \$355,000.
i.Select the property rows, and then set a 20 row height. Adjust column widths as necessary.
j.Select landscape orientation, and then set the scaling to 130%. Center the data horizontally and vertically on the page.
k.Insert a header with your name, the current date code, and the current time code.
l.Save and close the workbook, and submit based on your instructor’s...

### Similar Documents

#### Sales Week Report

...Section A: Description of Products and Services. We are offering photobooth services during the sales week. We provide 2 themes every day. For each of the products and services listed will be further detailed as following: 1. Disney (fixed theme) Disney announced a change in their photography policy, or rather a return to an old policy: non-Disney photographers will now be allowed to photograph for events. For the last five years or so, if you were getting married in the park or any photo booth session, you had to use a photographer provided by Disney Fine Art Photography. This caused problems for some peoples who either were very attached to a particular non-Disney photographer’s style or who had a bad experience with the photographer that was assigned to them by Disney. So, it’s exciting that the pool has opened back up and peoples now have more choices. Hopefully, this will lead to more in-any social events. this is information that I’ve pulled from the Disney Fairy Tale Event Facebook page. 2.Sports The idea of sports theme come up after we collaborate with the group that selling Aimst jersey. The main objective of this idea is to attract customer buy jersey and at the same time will get special offer at our photo booth. On sports theme. This theme not only attracted many customers to visit to jersey booth but at the same time attract customer to visit our photo booth. On this theme we provide a few prop such as ball, hailer and etc. 3. Paris "The Streets of......

Words: 3363 - Pages: 14

#### Sales Skills and Process Report

Words: 1126 - Pages: 5

#### Sales Promotion Schemes Project Report Mba

...Sales Promotion Schemes Project Report MBA   One of the most difficult marketing decisions facing companies is how much to spend on promotional John Wanamaker, the departmental - store magazine, said, "I know that half of my advertising is wasted but I don't know which half." Thus it is not surprising that industries and companies vary considerably in how much they spend on promotion. Promotional expenditures might amount to 30-50% of sales in case in cosmetics industry and only 10-20% in the industrial equipment industry. Within a industry, a low and high spending companies can be found. How do companies decide on their promotion budget? There are mainly four methods of sales promotion :• Affordable Method :Many companies set the promotion budget at what they think the company can afford. One executive explained this method as follows : "Why, it’s simple. First I go upstairs to the controller and how much they can afford to give us this year. He says a million and half. Later, the boss comes to me and asks how much we should spend and I say ‘Oh about a million and half."It is a method which is uncertain one and makes long term planning difficult.• Percentage of Sales Method :Many companies set their promotion expenditures at a specified percentage of sales. Accordingly the sales is set on the basis of sales. | Advertising Effectiveness Project ReportInternal Customer Satisfaction Project Report | In this a specified sales percentage is decided for the promotional......

Words: 3276 - Pages: 14

#### Sales Report

...Dear E-Marketing student, This assignment is about comparing. You have to compare the websites of two competing companies with each other. It is an individual assignment and each student gets an individual grade. First part of the assignment is to compare the online presence of two different companies in the same line of business. For instance, compare the websites and everything available online of British Airways and Lufthansa. Find out what they offer to their customers and in what way. Check the navigation within their websites, the user friendliness, the graphics, and so on. But do also check the contents of these websites: do they offer products that are suitable for selling online anyway? Do also check famous e-commerce sites like amazon.com, bookings.com or expedia.com and others and check how they have found solutions for certain problems. Explain what you think is good and wrong and how it could be better and why, based on the theory in your reader and what has been discussed during the E-Marketing classes. In other words, come up with your personal opinion, which is, of course, a well founded opinion. In this personal opinion you also have to come up with directions for improvement. Part 2 The second part of this assignment is the comparison of the same two companies separately (so, for each one apart) between what these companies have promised in their vision / mission statement and business goals and what they are actually doing ‘in real life’ with......

Words: 392 - Pages: 2

Free Essay

#### Sales Report

Words: 948 - Pages: 4

#### Report on Organ Sales

Words: 1941 - Pages: 8

#### Predictive Sales Report

...Predictive Sales Report A retail store has recently hired you as a consultant to advice on economic conditions. One important indicator that the retail store is concerned about is the unemployment rate. The retail store has found that an increase in the unemployment rate will cause a lack of consumer spending in their stores. Retail stores use the unemployment rate to estimate how much inventory to keep at their stores, which is important in maintaining cost effectiveness. In this consultant role you will apply calculations and research to create a predictive sales report. * The mean yearly value using the average unemployment rate by month Year (x) | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Annual (y) | 1948 | 3.4 | 3.8 | 4.0 | 3.9 | 3.5 | 3.6 | 3.6 | 3.9 | 3.8 | 3.7 | 3.8 | 4.0 | 3.75 | 1949 | 4.3 | 4.7 | 5.0 | 5.3 | 6.1 | 6.2 | 6.7 | 6.8 | 6.6 | 7.9 | 6.4 | 6.6 | 6.05 | 1950 | 6.5 | 6.4 | 6.3 | 5.8 | 5.5 | 5.4 | 5.0 | 4.5 | 4.4 | 4.2 | 4.2 | 4.3 | 5.21 | 1951 | 3.7 | 3.4 | 3.4 | 3.1 | 3.0 | 3.2 | 3.1 | 3.1 | 3.3 | 3.5 | 3.5 | 3.1 | 3.28 | 1952 | 3.2 | 3.1 | 2.9 | 2.9 | 3.0 | 3.0 | 3.2 | 3.4 | 3.1 | 3.0 | 2.8 | 2.7 | 3.03 | 1953 | 2.9 | 2.6 | 2.6 | 2.7 | 2.5 | 2.5 | 2.6 | 2.7 | 2.9 | 3.1 | 3.5 | 4.5 | 2.93 | 1954 | 4.9 | 5.2 | 5.7 | 5.9 | 5.9 | 5.6 | 5.8 | 6.0 | 6.1 | 5.7 | 5.3 | 5.0 | 5.59 | 1955 | 4.9 | 4.7 | 4.6 | 4.7 | 4.3 | 4.2 | 4.0 | 4.2 | 4.1 | 4.3 | 4.2 | 4.2 | 4.37 | 1956 | 4.0 | 3.9 | 4.2 | 4.0 | 4.3 | 4.3...

Words: 3584 - Pages: 15

#### Sales Director Justification Report

...570002486 Sales Director Justification Report Martina Sedita ENG 315 – Professional Communications Dr. Rachel De Luise May, 30, 2015 Table of Contents Executive Summary 3 Problem Statement 3 Overview of Alternatives 3 Criteria 4 Methods 4 Evaluation of Alternatives 5 Findings and Analysis 6 Recommendation 7 References 8 Executive Summary This report reviews the overall practicality of a managerial used tracking system and its ability to create a more efficient sales department. Internet and programmer based evaluations along with employee knowledge base of programs should provide a good data sets for both reviewed programs. The report finds that Microsoft Excel offers the employees easier input options that perform similar tasks as Microsoft Access. This allows ABC Sales to develop the most robust data sets for the lowest cost, with minimal additional training requirements to existing staff. It is clear that ABC Sales Department needs to choose Microsoft Excel. Problem Statement The ABC Sales Department has an organizational problem. ABC Sales Department does not keep a record of annual inventory renewal schedules for their special projects. The sales department needs to start to keep these records in order to properly plan future budgets, set realistic goals for employees to reach, and be able to forecast proper pricing for renewals. The sales director needs to implement an easy to use and cost affective tracker for the managers to use. ......

Words: 2026 - Pages: 9

#### Sales Director Justification Report

...Sales Director Justification Report Martina Sedita ENG 315 – Professional Communications Dr. Rachel De Luise May, 30, 2015 Table of Contents Executive Summary 3 Problem Statement 3 Overview of Alternatives 3 Criteria 4 Methods 4 Evaluation of Alternatives 5 Findings and Analysis 6 Recommendation 7 References 8 Executive Summary This report reviews the overall practicality of a managerial used tracking system and its ability to create a more efficient sales department. Internet and programmer based evaluations along with employee knowledge base of programs should provide a good data sets for both reviewed programs. The report finds that Microsoft Excel offers the employees easier input options that perform similar tasks as Microsoft Access. This allows ABC Sales to develop the most robust data sets for the lowest cost, with minimal additional training requirements to existing staff. It is clear that ABC Sales Department needs to choose Microsoft Excel. Problem Statement The ABC Sales Department has an organizational problem. ABC Sales Department does not keep a record of annual inventory renewal schedules for their special projects. The sales department needs to start to keep these records in order to properly plan future budgets, set realistic goals for employees to reach, and be able to forecast proper pricing for renewals. The sales director needs to implement an easy to use and cost affective tracker for the managers to use. The managers......

Words: 2025 - Pages: 9

#### Review of Current System and Recommrndations for National Department of Parks and Recreation

...Reports The current manual system used by Nationals Parks for collections of fees, attendance, and tickets inventory, was not giving the administration the sufficient reports for decision making. The analysis of the old system shows: A. the collection of revenues comprised of 3 basics operation: 1) Collection of fees 2) Deposit of fees 3) Reporting the collections The current manual system for revenue and reconciliation of deposit are prone to errors, missing items and revenue shortages. B. The record of visitor attendance was made monthly using excel worksheets. And reports were quarterly or yearly. The current method for counting visitor numbers is time consuming and imprecise C. Delayed Vendor payments create serious cash flows problems during few months of each budget year. There will not be enough available operating funds to pay outstanding vendors invoices. An automated ticket and revenue collection system in the national parks will produce sufficient report for decision making to help managers. Our team recommends the implement of the following three reports: Ticket sales report, Monthly financial report, and Visitor attendance report. Functions of tickets sales report: 1. Indicate the daily sales 2. Track the printed tickets sales 3. Plans future marketing campaign 4. Know the preferable payment method by visitor The tickets will be categorized by parks site categorization. The payment will be categorized by methods: online purchase, prepaid ticket...

Words: 356 - Pages: 2

Free Essay

...SUPPORT CENTER 8725 John J. Kingman Rd. Suite 4950 Fort Belvoir, Virginia 22060-6222 Instruction Number: DESC-I-2 February 14, 2008 1884 Report Data Requirements and Processing Procedures 1.0. Purpose: Provide procedural guidance and instruction for accurate preparation of 1884 Reports and data entry into the Fuels Automated System (FAS). This procedure is coordinated with and approved by the Military Service Control Points (SCPs) and is issued as interim guidance pending inclusion to DoD 4140.25-M. Responsible Officers and/or Property Administrators shall ensure compliance with these procedures. 1.1. Applicability: All DESC Stock Point/Defense Fuel Supply Point (DFSP) locations that satisfy reportable fuel product grade and minimum storage capacity criteria. 1884 Reports shall be processed weekly by use of the Fuels Enterprise Server (FES) 1884 Report function described in paragraph 2.0. 1.1.1. Supersession: This revision supersedes DESC-T-I-2 dated July 1, 2005. 1.1.2. Reportable fuel product grades include JP8, JP5, F76, JP4, LTL, LO6, LA6, LA7, JTS, and SIH and shall be reflected in the 1884 Report. Stock Points/DFSP locations previously identified to report ground fuel product grades shall continue to do so. Reportable fuel product grades at individual stock points are pre-loaded into the Fuels Enterprise Server (FES) 1884 Report module. The Responsible Officers (RO)/Property Administrator (PA), or designated representative, shall contact the Business Systems......

Words: 1329 - Pages: 6

#### Third District Pheledelphia

...Miller 3/28/2011 Third district report Third District-Pheledelphia Business activity in the Third District has improved overall since the last Beige Book. Their was a strong increases in shipments and new orders in February.Third District banks reported little overall change in loan volume outstanding since the last Beige Book.Contacts in the commercial real estate sector said that leasing and construction activity have remained at low levels since the last Beige Book.The outlook among Third District business contacts is positive but not strong. Bankers expect only slight growth in lending over the next two quarters. Contacts in commercial real estate expect market conditions to improve slowly during the year. Manufacturing Third District manufacturers reported strong increases in shipments and new orders from January to February.Producers within the furniture, petroleum, and fabricated metals sectors reported no overall change in demand.Third District manufacturers expect business conditions to improve during the next six months.Among the firms surveyed in February, about half expect increases in new orders and shipments, and less than one-tenth expect decreases.Capital spending plans among area manufacturers remain positive, but lessened somewhat over the past two months, mostly from January to February. Retail Third District retailers generally reported modest year-over-year increases in sales in January and February.......

Words: 546 - Pages: 3

#### Digital Marketing

Words: 2437 - Pages: 10

Free Essay

#### Variance Analysis

...Sharrain Walls Variance Analysis Grand Canyon University: HCA-530 July 5, 2016 Introduction Various reports help with viewing and keeping track of the productivity of a department. Managers find these reports very helpful with assisting to find an issue, trend, overspending, and underspending. A report commonly used is a variance report, which compares the planned amount to the actual amount. This report is critical in determining major decisions and viewing fluctuations. The report can be in the form of a table or graph and can be considered favorable or unfavorable based on the results. Vice Presidents look for the report to be clear and direct. Managers should include all factors associated with the variance report as well as the relationships between variance reporting, interpreting variance report results, and actual reports. Variance Analysis When viewing the results of the report consider the hospital size and utilization of the services offered by the hospital. When performing a variance analysis, relationships can be identified. Favorable (positive) and unfavorable (negative) correlations are critical in business planning. An example would be, variance analysis may show that when sales for product a rise in sales for product B. This type of relationship may be used for success of other products (Cross, N.d.). When using a variance report for forecasting variance data allows managers to identify factors such as seasonal changes for the favorable and......

Words: 650 - Pages: 3

Free Essay