201 RENR Test #2 Spring, 2009
Name:__________________________________________ 1. (30 points) Sales Force Tracking ACME Enterprises has a sales force of 26 personnel. They are paid strictly on commission, drawing a salary of .16% (not 16%, but 16/100 of 1%) of sales made. The top ten salespersons also received an annual bonus of .02% of their sales for the year. Complete the Acme Sales.xls spreadsheet to display each salesperson's sales, in dollars, for the year to date, and totals at the base of each column. Rank the sales persons by total sales, the highest at the top of the listing. For the top ten, compute the bonus based on sales to date. Add a picture of a popular ACME product (as seen on Saturday morning television) in use and a second of its packaging. Who has the highest sales amount and how much? Person: _____________________ Sales: _____________________ What is the average amount of sales for all salespersons? _____________________ What is the average of sales for female salespersons? _____________________ What is the average of sales for male salespersons? _____________________ Print a copy of the entire workbook with your name, course and section number, and date of printing in the header of every page. 2. (25 points) Veep Birthdays Spiro Thodore Agnew, Hubert Horatio Humphrey, and Lyndon Baines Johnson were three US Vice Presidents during the last century. Use the internet to find their date of birth and date of death, then develop an Excel spreadsheet to compute the number of days that each one lived. Your spreadsheet cannot be larger than 12 columns by six rows (or six columns by 12 rows) in size. List the president under whom each served, the date of birth and death, and add cells which will automatically display the days lived, each which one lived the longest, and by how many days he outlived each of the other two. Your formulas cannot assume a priori knowledge of the findings (in other words, they must work even if you shift the names and/or dates). Print a copy of the spreadsheet displaying the results and a second displaying the formulas. Your name, class and section number, and date of printing must be in the header of each page.
3. (25 points) Pay Day! As a recent graduate, you have received two job offers starting June 1 of next year. The first, from a Texas Tech graduate, will pay you the sum of $12,000,000.00 to work for one year. The second offer, obviously from a teasip who does not appreciate your true worth, will hire you at a pay of 1 cent for the first day and doubling your rate of pay for each day of the month. You have negotiated to be paid on Saturdays, Sundays and holidays as well as regular week days. Knowing that nothing this good lasts forever, assume that both employers will probably fired you or ask you to resign at the end of one mon...