MIS BUSINESS PROCESS MANAGEMENT

profilesooomamarz

Overview-

In this assignment you will help SSB, Inc. by critically analyze their procurement process and suggest the best solution, 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:

a.  All shipments will now include an additional 10% in shipping costs for orders under $2000

b.  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.[12 marks]

 

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).                                           [23 marks]

3.    Take the necessary data from the documents and put it into a spreadsheet  and do the following:                                                                                    [8 marks]

a.    Create a pie chart showing the quantity of each material purchased.

b.    Create a pie chart showing the value ($) of each material purchased.

c.    Create a bar chart showing the number of times each material is ordered.

d.    Create a bar chart showing the amount ($) purchased from each vendor.

 

4.    Answer the following questions                                                         [12 marks]

 

a.    The average number of days it takes to complete the process.

b.    The average value ($) of an order

c.    Which is the most purchased material, in terms of quantity?  How many were purchased?

d.    Which is the most purchased material, in terms of value ($)? How much did SSB spend on this material

e.    Which is the most frequently purchased material?

f.     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

a.    Course number and section

b.    Date

c.    Names of team members

2.    The process diagram

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 together)

4.    The reports

a.    The various charts specified in the Requirements section

b.    Answers to the questions in the Requirements section on one page

5.    Notes:

a.    Include a footer on each page with course number, section number, , date and page number

b.    Ensure that the submission is professionally prepared.  Sloppy work will be penalized with the deduction of 2 marks.

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


 

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

         

 

 

    • 8 years ago
    • 20
    Answer(5)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      question_1_and_2_1.docx
    • attachment
      q_3__4.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      writing_project_2.docx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      invoices.docx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      invoices.docx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      procurement_process.docx
    Bids(1)