Description The Excel file Science and Engineering Jobs shows the number of jobs in thousands in the year 2000 and projections for 2010 from a government study. Use the Excel file to compute the projected increase from the 2000 baseline and also the percentage increase for each occupational category. The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year.3Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions. 3 Based on Kenneth C. Laudon and Jane P. Laudon, Essentials of Management Information Systems, 9th ed. (Upper Saddle River, NJ: Prentice Hall, 2011). The Excel file President’s Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn during one month.4 Room rates are the same for one or two guests; however, additional guests must pay an additional $20 per person per day for meals. Guests staying for seven days or more receive a 10% discount. Modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay. 4 Based on Kenneth C. Laudon and Jane P. Laudon, Essentials of Management Information Systems. The worksheet Base Data in the Excel file Credit Risk Data provides information about 425 bank customers who had applied for loans.
Recent Comments