Premium Essay

Sales Report

In: Computers and Technology

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

Premium Essay

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

Premium Essay

Sales Skills and Process Report

...Sales Skills and Process Report   Sales Skills and Process Report I began my search for a carport by looking and three different companies for variations in quality of materials used for construction and price. This structure is ultimately going to be used as a barn for horses. I found what I wanted at Midway Motors in Lawrenceburg, Indiana. Midway Motors is a dealer who prepares orders for their customers. I already knew some information about the carport Midway had for sale because I had a brochure and I also did some research on the internet before I went to talk to a sales person. This report is based on the purchasing of a carport. Probing Questions: Open ended and close ended I told the sales person I was looking for a carport to use as a beginning structure for a horse barn. To relieve my uncertainty and doubt about this product the sales person then informed me these structures are very popular in our area for the purpose I want to use it for. I was given basic general information about the product which is the dimensions of the carport which are 18 x21x 6 including overhung boxed eaves. Additionally, there are also thirteen different colors to choose from. The salesman also gave me an initial cost for the size structure I wanted. Customer Pain/Needs and Quantitative Questions: I wanted to know the price of the carport because I have a limited budget. I also wanted upgrades or options to increase the sturdiness of the structure. I also needed to have......

Words: 1126 - Pages: 5

Premium Essay

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

Premium Essay

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

...Sum of Dispatch Qty Invoice Date Customer Name Ship-to Name Dec-15 Jan-16 Grand Total Arihant Trading Company (R) Arihant Trading Company (R) 88.93 90.49 179.42 Ashif Traders 13.17 13.17 Asif Traders 11.04 11.04 Balaji Developers 9.81 9.81 Overseas Packaging Insustries pvt Ltd 21.87 21.87 Pearl Enterprises 12.51 12.51 S.K Enterprise 9.45 9.45 S.K.Enterprise 10.74 10.74 SK Enterprise 43.46 43.46 Arihant Trading Company (R) Total 101.44 210.03 311.47 Brijeshkumar & Co. (R) Brijeshkumar & Co. (R) 23 23 Brijeshkumar & Co. (R) Total 23 23 Deccan Lime Company (R) Deccan Lime Company (R) 12.54 12.54 Deccan Lime Company. (R) 162.59 203.03 365.62 National Traders 12.72 12.72 Rainbow Marble House 11.1 11.1 Shree Mahavir Lime Depot 10.6 13.07 23.67 Sputnik Traders 35.23 35.23 Wonder Tiles 23.7 23.7 Deccan Lime Company (R) Total 185.73 298.85 484.58 Fazila Enterprises(R) Fazila Enterprises(R) 137.69 137.69 Fazila Enterprises(R) Total 137.69 137.69 Harish Enterprises Harish Enterprises 41.36 40.19 81.55 Harish Enterprises Total 41.36 40.19 81.55 Jaffer Enterprise (R) Asian Paint Ltd 11.75 11.75 Deep Traders 72.74 25.29 98.03 Maheshwari Marble 104.61 163.68 268.29 Palak Enterprises 23.41 23.41 Ramnath Adappa 19.36 19.36 Jaffer Enterprise (R) Total 200.76 220.08 420.84 Padmavati Corporation (R) Jai Gopal Krishna CHS Ltd 11.23 11.23 Mahalaxmi Traders 71.68 71.68 R.K.Stone 21.6 21.6 Padmavati Corporation......

Words: 948 - Pages: 4

Premium Essay

Report on Organ Sales

...Report on organ sales Peng Yl Tutor: F.Yang Study skills 6/12 International Business Class 5 Table of contents 1. Executive summary This report was to research whether we should legalize the sale of human organs. It examined the cases about organ sales all over the world. The major methodology is case study of quality research. The main findings were that situation of organ translation and sales in entire world. It was concluded that legalize the sales of human organs can not make more people get rescue and the sale of human organs is a kind of crime. The recommendations are that organ sales should be banned and society needs a law to control the black market. 2. Introduction Here is the report concerning about whether we should legalize the sale of human organs. People has discussed about it for a long time. According to public reports, China has become the world's second largest organ transplantation country. In China, There are about ten thousand cases of transplant operation each year. Besides, millions of patients are waiting for organ transplants. Under the serious imbalance of organ supply, some patients tend to buy organs through black market. It resulted in the formation of underground organ trading chain. My assumption in this report is organ sales can not be legalized. The scopes of this report are the cases about organ sales all over the world. The methodology I used is quality......

Words: 1941 - Pages: 8

Premium Essay

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

Premium Essay

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

Premium Essay

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

Premium Essay

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

Leadership

...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

Premium Essay

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

Premium Essay

Digital Marketing

...BY STEP GUIDE TO BUILDING REPORTS THAT ACTUALLY ALLOW BUSINESSES TO MAKE ACTIONABLE INSIGHTS PAGE 1 INTRODUCTION HOW OFTEN HAVE YOU LOOKED FOR REPORTING AND ANALYTICS TO GET BUSINESS INTELLIGENCE AND HAVE END UP WITH MOUNDS OF DATA ON EXCEL SPREADSHEETS? MORE OFTEN THAN NOT, YOU FIND YOURSELF WITH AN ENDLESS SUPPLY OF REPORTS BUT ARE STILL UNABLE TO GET ANSWERS TO YOUR MOST CRITICAL BUSINESS QUESTIONS? DON’T WORRY – YOU’RE NOT ALONE. Many companies are faced with the same exact issues that you are. It’s very likely these companies have one or more of the following foundational problems: ›› They don’t tie business results back to business objectives or measure against a set of key goals THE 6 STEPS FOR BETTER REPORTING Instead of diving right in and building another report, I’m going to recommend that you take a step back to outline a measurement framework using the following steps: ›› They lack a cohesive strategy to measure 01 IDENTIFY BUSINESS OBJECTIVES ›› They tend to build reports from the 02 DETERMINE KPIs 03 DEFINE KPI GOALS 04 IDENTIFY SUPPORTING METRICS 05 DETERMINE REPORTING DIMENSIONALITY 06 ORGANIZE INTO A FRAMEWORK their efforts across the entire business ground up and overload their end-users with pages of data and metrics with few next steps or optimization suggestions DO YOU NOTICE A THEME HERE? It boils down to a lack of planning in report development. We’ve been......

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

Branding Instructions for Free Reports

...Branding Instructions For Free Reports - - Save This Document For Future Reference - One of the most powerful marketing tools on the Internet is giving away content. Free reports branded with your Clickbank affiliate hop link are perfect. These reports provide valuable information, prove the product is worth investing in and result in more sales for you. Branding any of our Free Reports is quite easy... Step One Download the free brandable PDF report to your computer. Just right click on the link on that says Viral Report on the download page and “save target as”. Then save the file anywhere you want on your computer. Step Two Download the branding tool to your computer. Just right click on the link that says Branding Tool on the download page and “save target as”. Then save the file anywhere you want on your computer. Step Three Once you’ve downloaded and saved the free report and branding tool the next step is easy. Open the branding tool by clicking on it. Then click “Run”. The branding tool will then open. You’ll be asked to drag and drop your brandable PDF file into the window. Go ahead and do as instructed. Step Four After you’ve dropped the brandable PDF file of the free report into the window allow the tool to process the report. A new window will appear asking you to type in your Clickbank affiliate ID. After you type in your Clickbank affiliate ID in the space provided click on the “Brand” tab in the lower menu. You’ll be prompted to “remember to save your......

Words: 546 - Pages: 3