This is “Web Exercises”, section 12.7 from the book Beginning Project Management (v. 1.1). For details on it (including licensing), click here.

For more information on the source of this book, or why it is available for free, please see the project's home page. You can browse or download additional books there. To download a .zip file containing this book to use offline, simply click here.

Has this book helped you? Consider passing it on:
Creative Commons supports free culture from music to education. Their licenses helped make this book available to you.
DonorsChoose.org helps people like you help teachers fund their classroom projects, from art supplies to books to calculators.

12.7 Web Exercises

Learning Objectives

  1. Locate commodities in online catalogs.
  2. Use an RFQ template obtained online.
  3. Use an RFP template obtained online.
  4. Describe and interpret D&B financial reports using definitions from the D&B website.

Locate Commodities in Online Catalogs

Commodities can be purchased from online catalogs if the buyer knows exactly what is needed for the task.

Learn More about Using an Online Catalog to Buy Commodities

Complete the exercise by following these instructions:

  1. Open a blank document in a word processing program and then save the document as Ch12CommoditiesStudentName.doc. Leave the document open.
  2. Use your web browser and go to http://www.eastmfg.com. The catalog is provided in PDF format. This format is not easily changed by the viewer.
  3. Click the Parts menu and then click the link to the Hardware Catalog shown in Figure 12.11 "Parts Catalog".

    Figure 12.11 Parts Catalog

  4. In the Search box, type Lynch Pin and then press Enter. Refer to Figure 12.12 "Searching for a Part".

    Figure 12.12 Searching for a Part

  5. Notice the following characteristics:

    • The price is not listed. Separate price lists are often maintained for different classes of customer, and discounts are usually available for large orders.
    • There is a unique catalog number for each type of anchor. This number is used for placing orders.
    • The part's capacity, size, and weight are provided.
    • Some labels require knowledge of the product to understand; for example, Side Swing Pin.
  6. Capture this screen and paste it into Ch12CommoditiesStudentName.doc.

Analysis

  1. At the bottom of Ch12CommoditiesStudentName.doc, write between one hundred and two hundred words to describe how to navigate and interpret an online catalog that is provided in PDF format.
  2. Review your work and use the following rubric to determine its adequacy:

    Element Best Adequate Poor
    File name Ch12CommoditiesStudentName.doc .docx version Student name not included
    Locate commodities in online catalogs Two screen captures; a description of how to navigate an online catalog in PDF format Same as Best Missing screens; inaccurate description
  3. Save the file and submit it as directed by the instructor.

Use an Online RFQ Template

Commodities can be services that are specifically defined and common enough to have standardized descriptions and quality. In this exercise, you download a template for writing an RFQ from the state of Massachusetts for requesting quotes on testing software for accessibility compliance.

Locate and Download an RFQ Template

Complete the exercise by following these instructions:

  1. Open a blank document in a word processing program and then save the document as Ch12RFQStudentName.doc Leave the document open.
  2. Use your web browser to type http://www.mass.gov/dep/recycle/reduce/rmrfq.pdf.
  3. Scroll to the Preface page, as shown in Figure 12.13 "Description of RFQ Template".

    Figure 12.13 Description of RFQ Template

  4. Add this web address to your browser’s bookmarks or favorites list in the Project Management folder.
  5. Capture a screen that shows the address in the Project Management folder in the favorites or bookmarks and then paste it into Ch12RFQStudentName.doc.
  6. Scroll through appendices at the end of the document. Capture a screen from one of these appendices pages and then paste it into Ch12RFQStudentName.doc.

Analysis

  1. At the bottom of Ch12RFQStudentName.doc, write between one hundred and two hundred words to describe the advantages of using a template. Make specific reference to at least two sections of the RFQ template used in the first part of this exercise, including page references.
  2. Review your work and use the following rubric to determine its adequacy:

    Element Best Adequate Poor
    File name Ch12RFQStudentName.doc .docx version Student name not included
    Use an RFQ template obtained online A screen capture that shows a link to the template in the Project Management folder in the bookmarks or favorites; screen capture of one of the first eight pages; reflective essay between one hundred and two hundred words on use of a RFQ template Project Management folder does not show links from previous exercises Missing screens; only one feature discussed; no page references
  3. Save the file and submit it as directed by the instructor.

Use an Online RFP Template

If you need to rely on the vendor’s experience and expertise to solve a problem, you can request companies to submit proposals on how they would go about it. The state of Maryland provides a template for RFPs.

Locate and Download an RFP Template

Complete the exercise by following these instructions:

  1. Open a blank document in a word processing program and then save the document as Ch12RFPStudentName.doc. Leave the document open.
  2. In a browser, type http://energy.maryland.gov/documents/ProcurementConsultingServicesRFPFINAL.pdf. An RFP template used by the Maryland Energy Administration displays as a PDF file, as shown in Figure 12.14 "Source of RFQ Template".

    Figure 12.14 Source of RFQ Template

  3. Add this web address to your browser’s bookmarks or favorites in the Project Management folder.
  4. Capture a screen that shows the address in the Project Management folder in the favorites or bookmarks and then paste it into Ch12RFPStudentName.doc.
  5. Scroll to section 1.7 Pre-Proposal Conference. Observe that many organizations give contractors an opportunity to meet and ask questions before they prepare a proposal.
  6. Scroll back to page ii, Project No. Observe that the state asks the contractors who decide not to bid to explain why.
  7. Capture the screen that shows the list of reasons why the contractor chose not to bid, and then paste it into Ch12RFPStudentName.doc.
  8. Explore the other sections of this RFP template and choose one that is new to you or that you find most interesting.

Analysis

  1. At the bottom of Ch12RFPStudentName.doc, write between one hundred and two hundred words to describe what you learned from each of the three sections: the pre-proposal conference, the refusal to bid, and the third section of your choice. Make specific reference to each of the three sections of the RFP template used in Part I including page references.
  2. Review your work and use the following rubric to determine its adequacy:

    Element Best Adequate Poor
    File name Ch12RFPStudentName.doc .docx version Student name not included
    Use an RFP template obtained online A screen capture that shows a link to the template in the Project Management folder in the bookmarks or favorites; screen capture of the preproposal conference; reflective essay between one hundred and two hundred words on the conference, refusal, and one other section with specific page references Project Management folder does not show links from previous exercises Missing screens; four sections not discussed individually; no page references
  3. Save the file and submit it as directed by the instructor.

Interpret D&B Financial Ratings

The relationship between the project and its suppliers and vendors involves trust that both parties will keep their financial commitments. This trust may be based on past experience, but it can also be based on a third party’s rating of the financial health of the organization and its past behavior. For example, organizations with better credit ratings can negotiate lower prices with suppliers and vendors because there is less risk. One of the most popular rating agencies is D&B. In this exercise, you locate and review the types of financial reports that are available from D&B.

Locate and Review the Financial Reports Available from D&B

Complete the exercise by following these instructions:

  1. Open a blank document in a word processing program and then save the document as Ch12DBStudentName.doc. Leave the document open.
  2. In a browser, type http://www.dnb.com/us/customer_service/scores.html. The D&B web page displays, as shown in Figure 12.15 "D&B Ratings".

    Figure 12.15 D&B Ratings

  3. Add this web address to your browser’s bookmarks or favorites in the Project Management folder.
  4. Capture a screen that shows the address in the Project Management folder in the favorites or bookmarks and then paste it into Ch12DBStudentName.doc.
  5. Scroll down the page to the D&B Rating Interpretation table. The rating in the first column indicates the worth of the company, and the numbers 1 through 4 indicate its general credit worthiness, where 1 is high and 4 is low. For example, a rating of 1A-4 indicates a company with a worth between $500,000 and $749,999 with a low credit worthiness rating.
  6. Capture this screen and paste it into Ch12DBStudentName.doc.
  7. Scroll down to the US Employee Range Designation table. Notice this rating indicates the number of employees, where ER1 is more than 1,000.
  8. Capture this screen and paste it into Ch12DBStudentName.doc.
  9. Scroll down to the D&B PAYDEX Value table. Observe that the PAYDEX score indicates when the company pays its debts. Notice that paying off debts sooner than is contractually required earns a PAYDEX score above 80.
  10. Capture this screen and paste it into Ch12DBStudentName.doc.
  11. Scroll down to the Financial Stress Score table. Notice that companies with a score of 1 are estimated to have a probability of failure of .03 percent (3 per 10,000) of failing in the next twelve months, while a rating of 5 means a probability of failure of 4.7 percent (almost 1 in 20).
  12. Capture this screen and paste it into Ch12DBStudentName.doc.

Analysis

  1. At the bottom of Ch12DBStudentName.doc, write between one hundred and two hundred words to describe the function of these four tables.
  2. Explain what it would mean if a company had the following D&B ratings:

    • BB-1
    • ER3
    • PAYDEX 80
    • Financial stress: 4
  3. Review your work and use the following rubric to determine its adequacy:

    Element Best Adequate Poor
    File name Ch12DBStudentName.doc .docx version Student name not included
    Describe and interpret D&B financial reports using definitions online A screen capture that shows a link to the template in the Project Management folder in the bookmarks or favorites; four screens that show the four tables; reflective essay between one hundred and two hundred words on use of D&B ratings; interpretation of example scores Same as Best Missing screens; incorrect interpretation of table; incorrect interpretation of ratings
  4. Save the file and submit it as directed by the instructor.