Session 24

Decision Support Systems 150:127 -- D. Power

Today's Agenda -- Thursday, April 5, 2007

  • Deliverable #2 feedback
    1. Have a customer information input screen
    2. Design the bid sheet before you finalize the data entry screens
    3. Make sure the bid specialist/DSS user has control of important variables like overhead allocation, markup/markdown percentage
    4. Keep the stored data manageable and focus on historical rates and data that rarely changes
    5. Don't build large data stores unless you know the data is slow to change and bid estimators need access to stored data to improve efficiency, reduce errors or assist in completeness of the estimate
    6. Your goal is to improve the accuracy of the bid AND help insure that if a bid is accepted that it will be profitable for the firm. Provide decision support so the estimator knows how much impact there will be on the final bid from various allocations of overhead and various profit levels
    7. Don't show the customer overhead or profit information on the bid sheet and in most cases don't show the customer estimated labor hours
  • Complete Excel Tutorial 5 "Trouble Shooting Formulas", on p. 250 complete step 11 printing Fig. 5-15, then print the formula sheet (with row/col headings and gridlines) for Fig. 5-15. Print formula sheet (with row/col headings and gridlines) for Fig. 5-23 p. 258. On p. 264 print formulas for both worksheets (with row/col headings and gridlines). On p. 271 step 6 with Atty. On p. 275 step 5. On p. 279 formula sheet (with row/col headings and gridlines) for fig. 5-47. On p. 291 complete step 7. Print and staple in the order listed!! (5 pts.)

To Do and Upcoming

  • Tutorial 10: Sharing Excel Data. The "Employees" data file needed on p. 532 can be found in folder T10 on the data disk. Print Sheet1 worksheet with your name in the left section of the header from workbook Greenfield-10 from figure 10-11 on p. 540. Print entire Investments-10 workbook p. 544. Print the code for the ImportEmployee macro from VBA on p. 551 from figure 10-21. Print the (first page only) of worksheet on p559 from figure 10-28. Print Donations worksheet on p562 from figure 10-31. Print the survey data on p. 568 from figure 10-38, fit to 1 page.