Fulfillment Process Group Assignment
In this assignment you will help SSB, Inc. with their fulfillment process. Specifically you will
1. Define their fulfillment process in terms of the physical flow
2. Execute TWO 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 FIVE instances of the data.
The business process
The process used by SSB is similar to the one described in Chapter 4. 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 an additional
step to check the status of inventory is included. This is to ensure that the needed quantities of the
materials are available. This steps is to be completed by someone in the warehouse prior to “prepare
shipment” step in the process described in the book.
2. SSB’s agreements with customers has changed as follows:
a. All shipments will now include an additional 10% in shipping costs for orders under $2000
b. Payment terms are 2% 15/ Net 30
1. Create a process diagram similar to Figure 4.1 to describe SSBs modified procurement process. Use
Microsoft Visio, MS powerpoint or another application 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
a. Create a pie chart showing the quantity of each material sold
b. Create a pie chart showing the value ($) of each material sold
c. Create a bar chart showing the number of times each material is ordered
d. Create a bar chart showing the amount ($) purchased by each customer
e. Answer the following questions
i. The average number of days it takes to complete the process.
ii. The average value ($) of an order
iii. Which is SSB’s best selling material in terms of quantity? How many were sold?
iv. Which is the best selling material in terms of value ($)?
v. Which is the most frequently sold material?
vi. Who is SBBs best customer, in terms of value ($)
| Fulfillment Assignment | Page 1 of 2 |
After completing the assignment, submit the following:
1. Cover page with
a. Course number and section
c. Team number
d. Names of team members
2. The process diagram showing the modified process
3. For TWO process instances (the first two in the order data section)
a. The documents in the correct order of process steps (keep all documents for one instance
4. The reports
a. The various charts specified in the Requirements section
b. Answers to the questions in the Requirements section on one page
a. Include a footer on each page with course number, section number, team number, date and page
b. Ensure that the submission is professionally prepared. Sloppy work will be penalized
c. 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.
d. Submit the word document electronically via the Blackboard system
Inquiry # Customer Materials Quantity
10045 MI Sporting Company ENSB 3000 500
HLMT 5000 200
SHRT 4000 50
FAID 6000 200
10046 Extreme Skateboard Sports, Inc. ENSB 3000 20
HLMT 5000 10
10047 MI Sporting Company ENSB 3000 150
HLMT 5000 100
FAID 6000 50
10048 MI Sporting Company ENSB 3000 300
HLMT 5000 300
10049 World Wide Skateboard Distributors ENSB 3000 400
Inquiry # Inquiry Quotation PO Date Sales Picking Packing Invoice Payment
date Date Order date (and Ship) Date Date
10045 July 1 July 2 July 9 July 11 July 14 July 15 July 21 July 30
10046 July 15 July 18 July 25 July 30 Aug 4 Aug 5 Aug 12 Aug 28
10047 July 16 July 18 July 25 July 30 Aug 4 Aug 6 Aug 12 Aug 25
10048 July 28 July 31 Aug 11 Aug 14 Aug 19 Aug 19 Aug 25 Sep 5
10049 Aug 4 Aug 8 Aug 14 Aug 18 Aug 19 Aug 20 Aug 25 Sep 12
| Fulfillment Assignment | Page 2 of 2 |