Procurement Process Group Assignment

Overview

In this assignment you will help SSB, Inc. with their procurement process. Specifically you will

  1. Define their procurement process in terms of the physical flow
  2. Execute five instances of the process on paper. That is, you will create the various documents needed and ensure that the correct data is included in each document
  3. Generate reports based on the data in the documents

The business process

The process used by SSB is similar to the one described in Chapter 3. However, there are some differences. These differences are explained below and you must incorporate them in your assignment

  1. After evaluating the current process, it is determined that the process will be more efficient if Tim Jones initiates the process (ie, creates the requisition) instead of David Bloomburg. This is because Tim is more aware of the state of inventory than David as Tim is constantly in the Warehouse. However, David must approve all requisitions.
  2. SSB’s agreements with vendors has changed as follows:
  3. All shipments will now include an additional 10% in shipping costs for orders under $2000
  4. Payment terms are 1% 10/ Net 30

Requirements

  1. Create a process diagram similar to Figure 3.1 to describe SSBs modified procurement process. Use Microsoft Visio to create this diagram
  2. Create the documents needed to execute the process for the data provided in the Order Data Section at the end. Be careful to ensure that the data in the documents (dates, quantities, prices, etc.) are accurate. Clearly state any assumptions made on a separate sheet at the beginning of the submission (It is not typical to have to make assumptions).
  3. Take the necessary data from the documents and put it into a spreadsheet and do the following
  4. Create a pie chart showing the quantity of each material purchased
  5. Create a pie chart showing the value ($) of each material purchased
  6. Create a bar chart showing the number of times each material is ordered
  7. Create a bar chart showing the amount ($) purchased from each vendor
  8. Answer the following questions
  9. The average number of days it takes to complete the process.
  10. The average value ($) of an order
  11. Which is the most purchased material, in terms of quantity? How many were purchased?
  12. Which is the most purchased material, in terms of value ($)? How much did SSB spend on this material
  13. Which is the most frequently purchased material?
  14. Which is the vendor does SSB buy from the most, in terms of value ($)

Deliverables

After completing the assignment, submit the following:

  1. Cover page with
  2. Course number and section
  3. Date
  4. Team number
  5. Names of team members
  6. The process diagram
  7. For TWO process instances (the first two in the order data section)
  8. The documents in the correct order of process steps (keep all documents for one instance together)
  9. The reports
  10. The various charts specified in the Requirements section
  11. Answers to the questions in the Requirements section on one page
  12. Notes:
  13. Include a footer on each page with course number, section number, team number, date and page number
  14. Ensure that the submission is professionally prepared. Sloppy work will be penalized
  15. Submit one word document with all the required material. You will have to figure out how to export data from Visio and Excel into Word.
  16. Submit the word document electronically via the Blackboard system

Order Data.

Requisition # / Requisition date / Vendor / Materials / Quantity
3961 / July 1, 2008 / NutcaseSupplies / ENSB 3000 / 100
HLMT 5000 / 200
SHRT 4000 / 50
FAID 6000 / 25
3962 / July 15, 2008 / Black Widow Skateboards / ENSB 3000 / 200
HLMT 5000 / 200
FAID 6000 / 40
3963 / July 31, 2008 / Black Widow Skateboards / ENSB 3000 / 150
HLMT 5000 / 100
FAID 6000 / 50
3964 / August 14, 2008 / Black Widow Skateboards / ENSB 3000 / 300
HLMT 5000 / 300
3965 / August 28, 2008 / Skatelubbers / ENSB 3000 / 400
P Req # / Requisition date / Approval Date / PO Date / Ship
Date / Goods
Receipt
Date / Invoice
Date / Payment
Date
3961 / July 1 / July 2 / July 7 / July 14 / July 16 / July 23 / July 30
3962 / July 15 / July 16 / July 16 / July 30 / Aug 2 / Aug 11 / Aug 22
3963 / July 31 / Aug 1 / Aug 8 / Aug 25 / Aug 28 / Sep 4 / Sep 12
3964 / Aug 14 / Aug 15 / Aug 19 / Sep 5 / Sep 8 / Sep 15 / Sep 26
3965 / Aug 28 / Aug 29 / Aug 29 / Sep 12 / Sep 17 / Sep 19 / Sep 26

| Procurement Assignment |Page 1 of 2|