Example research essay topic: Actual Actual Actual Actual Actual Actual Actual Sales - 471 words

NOTE: Free essay sample provided on this page should be used for references or sample purposes only. The sample essay is available to anyone, so any direct quoting without mentioning the source will be considered plagiarism by schools, colleges and universities that use plagiarism detection software. To get a completely brand-new, plagiarism-free essay, please use our essay writing service.
One click instant price quote

This is your final project for BUSI 180. You will use all four programs Excel, Access, Word, and PowerPoint. The project is due on or before December 19 th. Create the following spreadsheet in Excel: 1 st Qtr 2 nd Qtr 3 rd Qtr 4 th Qtr Total 2001 2001 % Goal Name Sales Actual Actual Actual Actual Actual Goal Reached Demand, Amy 142789 47899 41567 81266 96782 Trout, Patricia 152402 35008. 2 68909 66328 91344 Valentino, Elizabeth 163284 33567 70929. 7 63213 99345 Schuda, Jay 156782 56893 62332 89547 45877 Oliver, Deby 182018 66897 56874 66345 93234 Chu, Johnathon 166324 41889 75892 87445 51678 Shall, Donna 161300 36221. 5 71563 62341 76432 Leatherman, Courtney 136589 34327 37899 64333 67894 Epstein, Lee 159778 33258 65700 65789 44661 Cook, Pamela 157896 42339 45233 58566 45328 In the Total 2001 Actual column calculate each persons actual sales for 2001. In the 2001 Goal column, calculate their sales goal for 2001 (this is a 12 % increase on the 2000 sales). Round to whole numbers.

In the % Goal Reached column calculate the actual percent increase each salesperson achieved from the previous year (2001 sales total 2000 sales / 2000 sales). Format this column as a percent. Create a bar chart that shows the individuals name and the % goal reached. Save the worksheet as 2001 Sales. Print the worksheet. Create a general memo in Word to all the employees.

Congratulate them on their achievements and import the chart from Excel into the memo. Save the memo as Empmemo. Print the memo. In PowerPoint, create a presentation for the President of the company that outlines the sales for each quarter, the total sales for the 2001 compared to 2000, and a slide that introduces each of the employees who met their goal (increased by 12 % or more). In the slide that introduces the employees you must import the chart from Excel. The format of the presentation should include a title slide (with your name on it), table of contents, and at least two other slides.

There should also be a shape or a clipart imported into the presentation. Apply an appropriate background template to the presentation. Save as 2001 Sales Pres. Print the presentation as a handout (4 slides / page ). In Access, create a table with fields for employee number (have this generated by Access using the Auto Number feature), first name, last name, 2000 sales, and 2001 sales. Designate the employee number as the primary key and format the fields appropriately.

Save the table as Emp Sales. Enter data into the table using the above information on the ten employees. Create a query that displays employee first name, last name, and 2001 sales sorted in descending order by sales. Save the query as 2001 Emp Sales.

Print the query. Bibliography:

Research essay sample on Actual Actual Actual Actual Actual Actual Actual Sales