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 19th. Create the following spreadsheet in Excel: 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Total 2001 2001 % Goal Name Sales Actual Actual Actual Actual Actual Goal Reached Delman, 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 Shalala, 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.
The Essay on Smart Goals 2
I will buy a house in two years and have $10,000 for a down payment. I take my kids camping at least three times before it starts to get cold at the end of August. I will potty train my son by his 3rd birthday in September. I will pay an extra $50 per month toward my debt so I can be completely out of debt by January of 2014. I will earn my college degree by attending college for the next four ...
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 AutoNumber 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 EmpSales. 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 2001EmpSales. Print the query.
