Task Assignment Sales Rep Sales Support Staff Accounts Receivable Inventory Clerk Shipping Clerk Billing Clerk 1 A customer sends a purchase order for off road bicycles to a GBI employee 2 A GBI employee compares the customers purchase order to determine if the customers master data is in the system and is correct 3 If the customer master data is not in the system or is incorrect, then the master sales and distribution data for the customer is entered by a GBI employee 4 If the customer master data is not in the system or is incorrect, then the financial data (such as banking information and GBI reconciliation account) for the customer is entered by a GBI employee 5 If the customer master data is not in the system, then a GBI employee checks the credit rating of the customer and assigns a credit limit and credit terms 6 A GBI employee checks inventory availability 7 If the customer can be extended credit and inventory is available, a GBI employee takes the customers purchase order and creates a sales order 8 A GBI employee creates an order acknowledgement and sends it to the customer 9 A GBI employee records the sales order 10 A GBI employee creates a picking ticket to fill the customers order 11 A GBI employee picks the goods (the bicycles) from the picking ticket 12 A GBI employee creates a packing slip and a mailing label 13 A GBI employee puts the packing slip into the reinforced container with the goods, seals the container and adheres the mailing label to the container 14 A GBI employee moves the goods from the inventory control area to the shipping dock 15 A GBI employee creates a shipping manifest 16 A GBI employee places the goods on the truck to be shipped 17 A GBI employee gives the shipping manifest to the truck driver 18 A GBI employee creates a shipping document to show that the goods have been shipped 19 A GBI employee records that the goods have been shipped 20 A GBI employee creates an invoice with a remittance advice and sends it to the customer 21 A GBI employee receives the payment from the customer with the returned remittance advice 22 A GBI employee records the payment from the customer 23 A GBI employee takes all of the payments for that day and makes up a deposit slip for the bank 24 A GBI employee deposits the cash in the bank 25, A GBI employee records the bank deposit 26 A GBI employee reconciles bank deposits with the cash receipts on a daily basis Using the same format as the above matrix, create an Excel spreadsheet to include all the above roles and tasks, and add any of the following roles to your new matrix that you feel are necessary to accomplish appropriate segregation of duties controls Receptionist, Secretary, Mailroom Clerk, Warehouse Assistant, Treasury Clerk, Treasurer, Accounting Manager, Controller, Office Manager, Maintenance Supervisor, and others (TBD) Now reassign tasks, where appropriate, to each of the employees listed in the original matrix or assign tasks to other GBI employees not currently involved in the sales to cash process (the new roles from above that you are adding to your spreadsheet) Hint It would be helpful to reference the risk assessment you completed in part 1 Task Assignment Sales Rep Sales Support Staff Accounts Receivable Inventory Clerk Shipping Clerk Billing Clerk 1 A customer sends a purchase order for off road bicycles to a GBI employee 2 A GBI employee compares the customers purchase order to determine if the customers master data is in the system and is correct 3 If the customer master data is not in the system or is incorrect, then the master sales and distribution data for the customer is entered by a GBI employee 4 If the customer master data is not in the system or is incorrect, then the financial data (such as banking information and GBI reconciliation account) for the customer is entered by a GBI employee 5 If the customer master data is not in the system, then a GBI employee checks the credit rating of the customer and assigns a credit limit and credit terms 6 A GBI employee checks inventory availability 7 If the customer can be extended credit and inventory is available, a GBI employee takes the customers purchase order and creates a sales order 8 A GBI employee creates an order acknowledgement and sends it to the customer 9 A GBI employee records the sales order 10 A GBI employee creates a picking ticket to fill the customers order 11 A GBI employee picks the goods (the bicycles) from the picking ticket 12 A GBI employee creates a packing slip and a mailing label 13 A GBI employee puts the packing slip into the reinforced container with the goods, seals the container and adheres the mailing label to the container 14 A GBI employee moves the goods from the inventory control area to the shipping dock 15 A GBI employee creates a shipping manifest 16 A GBI employee places the goods on the truck to be shipped 17 A GBI employee gives the shipping manifest to the truck driver 18 A GBI employee creates a shipping document to show that the goods have been shipped 19 A GBI employee records that the goods have been shipped 20 A GBI employee creates an invoice with a remittance advice and sends it to the customer 21 A GBI employee receives the payment from the customer with the returned remittance advice 22 A GBI employee records the payment from the customer 23 A GBI employee takes all of the payments for that day and makes up a deposit slip for the bank 24 A GBI employee deposits the cash in the bank 25, A GBI employee records the bank deposit 26 A GBI employee reconciles bank deposits with the cash receipts on a daily basis Using the same format as the above matrix, create an Excel spreadsheet to include all the above roles and tasks, and add any of the following roles to your new matrix that you feel are necessary to accomplish appropriate segregation of duties controls Receptionist, Secretary, Mailroom Clerk, Warehouse Assistant, Treasury Clerk, Treasurer, Accounting Manager, Controller, Office Manager, Maintenance Supervisor, and others (TBD) Now reassign tasks, where appropriate, to each of the employees listed in the original matrix or assign tasks to other GBI employees not currently involved in the sales to cash process (the new roles from above that you are adding to your spreadsheet) Hint It would be helpful to reference the risk assessment you completed in part 1 Task Assignment Sales Rep Sales Support Staff Accounts Receivable Inventory Clerk Shipping Clerk Billing Clerk 1 A customer sends a purchase order for off road bicycles to a GBI employee 2 A GBI employee compares the customers purchase order to determine if the customers master data is in the system and is correct 3 If the customer master data is not in the system or is incorrect, then the master sales and distribution data for the customer is entered by a GBI employee 4 If the customer master data is not in the system or is incorrect, then the financial data (such as banking information and GBI reconciliation account) for the customer is entered by a GBI employee 5 If the customer master data is not in the system, then a GBI employee checks the credit rating of the customer and assigns a credit limit and credit terms 6 A GBI employee checks inventory availability 7 If the customer can be extended credit and inventory is available, a GBI employee takes the customers purchase order and creates a sales order 8 A GBI employee creates an order acknowledgement and sends it to the customer 9 A GBI employee records the sales order 10 A GBI employee creates a picking ticket to fill the customers order 11 A GBI employee picks the goods (the bicycles) from the picking ticket 12 A GBI employee creates a packing slip and a mailing label 13 A GBI employee puts the packing slip into the reinforced container with the goods, seals the container and adheres the mailing label to the container 14 A GBI employee moves the goods from the inventory control area to the shipping dock 15 A GBI employee creates a shipping manifest 16 A GBI employee places the goods on the truck to be shipped 17 A GBI employee gives the shipping manifest to the truck driver 18 A GBI employee creates a shipping document to show that the goods have been shipped 19 A GBI employee records that the goods have been shipped 20 A GBI employee creates an invoice with a remittance advice and sends it to the customer 21 A GBI employee receives the payment from the customer with the returned remittance advice 22 A GBI employee records the payment from the customer 23 A GBI employee takes all of the payments for that day and makes up a deposit slip for the bank 24 A GBI employee deposits the cash in the bank 25, A GBI employee records the bank deposit 26 A GBI employee reconciles bank deposits with the cash receipts on a daily basis Using the same format as the above matrix, create an Excel spreadsheet to include all the above roles and tasks, and add any of the following roles to your new matrix that you feel are necessary to accomplish appropriate segregation of duties controls Receptionist, Secretary, Mailroom Clerk, Warehouse Assistant, Treasury Clerk, Treasurer, Accounting Manager, Controller, Office Manager, Maintenance Supervisor, and others (TBD) Now reassign tasks, where appropriate, to each of the employees listed in the original matrix or assign tasks to other GBI employees not currently involved in the sales to cash process (the new roles from above that you are adding to your spreadsheet) Hint It would be helpful to reference the risk assessment you completed in part 1 Task Assignment Sales Rep Sales Support Staff Accounts Receivable Inventory Clerk Shipping Clerk Billing Clerk 1 A customer sends a purchase order for off road bicycles to a GBI employee 2 A GBI employee compares the customers purchase order to determine if the customers master data is in the system and is correct 3 If the customer master data is not in the system or is incorrect, then the master sales and distribution data for the customer is entered by a GBI employee 4 If the customer master data is not in the system or is incorrect, then the financial data (such as banking information and GBI reconciliation account) for the customer is entered by a GBI employee 5 If the customer master data is not in the system, then a GBI employee checks the credit rating of the customer and assigns a credit limit and credit terms 6 A GBI employee checks inventory availability 7 If the customer can be extended credit and inventory is available, a GBI employee takes the customers purchase order and creates a sales order 8 A GBI employee creates an order acknowledgement and sends it to the customer 9 A GBI employee records the sales order 10 A GBI employee creates a picking ticket to fill the customers order 11 A GBI employee picks the goods (the bicycles) from the picking ticket 12 A GBI employee creates a packing slip and a mailing label 13 A GBI employee puts the packing slip into the reinforced container with the goods, seals the container and adheres the mailing label to the container 14 A GBI employee moves the goods from the inventory control area to the shipping dock 15 A GBI employee creates a shipping manifest 16 A GBI employee places the goods on the truck to be shipped 17 A GBI employee gives the shipping manifest to the truck driver 18 A GBI employee creates a shipping document to show that the goods have been shipped 19 A GBI employee records that the goods have been shipped 20 A GBI employee creates an invoice with a remittance advice and sends it to the customer 21 A GBI employee receives the payment from the customer with the returned remittance advice 22 A GBI employee records the payment from the customer 23 A GBI employee takes all of the payments for that day and makes up a deposit slip for the bank 24 A GBI employee deposits the cash in the bank 25, A GBI employee records the bank deposit 26 A GBI employee reconciles bank deposits with the cash receipts on a daily basis Using the same format as the above matrix, create an Excel spreadsheet to include all the above roles and tasks, and add any of the following roles to your new matrix that you feel are necessary to accomplish appropriate segregation of duties controls Receptionist, Secretary, Mailroom Clerk, Warehouse Assistant, Treasury Clerk, Treasurer, Accounting Manager, Controller, Office Manager, Maintenance Supervisor, and others (TBD) Now reassign tasks, where appropriate, to each of the employees listed in the original matrix or assign tasks to other GBI employees not currently involved in the sales to cash process (the new roles from above that you are adding to your spreadsheet) Hint It would be helpful to reference the risk assessment you completed in part 1

The Answer is in the image, click to view ...

Question: Task Assignment Sales Rep Sales Support Staff Accounts Receivable Inventory Clerk Shipping Clerk Billing Clerk 1. A customer sends a purchase order for off-road bicycles

*Task Assignment*
	Sales Rep	Sales Support Staff	Accounts Receivable	Inventory Clerk	Shipping Clerk	Billing Clerk
1. A customer sends a purchase order for off-road bicycles to a GBI employee
2. A GBI employee compares the customers purchase order to determine if the customers master data is in the system and is correct.
3. If the customer master data is not in the system or is incorrect, then the master sales and distribution data for the customer is entered by a GBI employee.
4. If the customer master data is not in the system or is incorrect, then the financial data (such as banking information and GBI reconciliation account) for the customer is entered by a GBI employee.
5. If the customer master data is not in the system, then a GBI employee checks the credit rating of the customer and assigns a credit limit and credit terms.
6. A GBI employee checks inventory availability.
7. If the customer can be extended credit and inventory is available, a GBI employee takes the customers purchase order and creates a sales order.
8. A GBI employee creates an order acknowledgement and sends it to the customer.
9. A GBI employee records the sales order.
10. A GBI employee creates a picking ticket to fill the customers order.
11. A GBI employee picks the goods (the bicycles) from the picking ticket.
12. A GBI employee creates a packing slip and a mailing label.
13. A GBI employee puts the packing slip into the reinforced container with the goods, seals the container and adheres the mailing label to the container.
14. A GBI employee moves the goods from the inventory control area to the shipping dock
15. A GBI employee creates a shipping manifest
16. A GBI employee places the goods on the truck to be shipped
17. A GBI employee gives the shipping manifest to the truck driver
18. A GBI employee creates a shipping document to show that the goods have been shipped
19. A GBI employee records that the goods have been shipped
20. A GBI employee creates an invoice with a remittance advice and sends it to the customer
21. A GBI employee receives the payment from the customer with the returned remittance advice
22. A GBI employee records the payment from the customer
23. A GBI employee takes all of the payments for that day and makes up a deposit slip for the bank
24. A GBI employee deposits the cash in the bank.
25, A GBI employee records the bank deposit.
26. A GBI employee reconciles bank deposits with the cash receipts on a daily basis.

Using the same format as the above matrix, create an Excel spreadsheet to include all the above roles and tasks, and add any of the following roles to your new matrix that you feel are necessary to accomplish appropriate segregation of duties controls: Receptionist, Secretary, Mailroom Clerk, Warehouse Assistant, Treasury Clerk, Treasurer, Accounting Manager, Controller, Office Manager, Maintenance Supervisor, and others (TBD).

Now reassign tasks, where appropriate, to each of the employees listed in the original matrix or assign tasks to other GBI employees not currently involved in the sales-to-cash process (the new roles from above that you are adding to your spreadsheet). Hint: It would be helpful to reference the risk assessment you completed in part 1.

*Task Assignment*
	Sales Rep	Sales Support Staff	Accounts Receivable	Inventory Clerk	Shipping Clerk	Billing Clerk
1. A customer sends a purchase order for off-road bicycles to a GBI employee
2. A GBI employee compares the customers purchase order to determine if the customers master data is in the system and is correct.
3. If the customer master data is not in the system or is incorrect, then the master sales and distribution data for the customer is entered by a GBI employee.
4. If the customer master data is not in the system or is incorrect, then the financial data (such as banking information and GBI reconciliation account) for the customer is entered by a GBI employee.
5. If the customer master data is not in the system, then a GBI employee checks the credit rating of the customer and assigns a credit limit and credit terms.
6. A GBI employee checks inventory availability.
7. If the customer can be extended credit and inventory is available, a GBI employee takes the customers purchase order and creates a sales order.
8. A GBI employee creates an order acknowledgement and sends it to the customer.
9. A GBI employee records the sales order.
10. A GBI employee creates a picking ticket to fill the customers order.
11. A GBI employee picks the goods (the bicycles) from the picking ticket.
12. A GBI employee creates a packing slip and a mailing label.
13. A GBI employee puts the packing slip into the reinforced container with the goods, seals the container and adheres the mailing label to the container.
14. A GBI employee moves the goods from the inventory control area to the shipping dock
15. A GBI employee creates a shipping manifest
16. A GBI employee places the goods on the truck to be shipped
17. A GBI employee gives the shipping manifest to the truck driver
18. A GBI employee creates a shipping document to show that the goods have been shipped
19. A GBI employee records that the goods have been shipped
20. A GBI employee creates an invoice with a remittance advice and sends it to the customer
21. A GBI employee receives the payment from the customer with the returned remittance advice
22. A GBI employee records the payment from the customer
23. A GBI employee takes all of the payments for that day and makes up a deposit slip for the bank
24. A GBI employee deposits the cash in the bank.
25, A GBI employee records the bank deposit.
26. A GBI employee reconciles bank deposits with the cash receipts on a daily basis.

*Task Assignment*
	Sales Rep	Sales Support Staff	Accounts Receivable	Inventory Clerk	Shipping Clerk	Billing Clerk
1. A customer sends a purchase order for off-road bicycles to a GBI employee
2. A GBI employee compares the customers purchase order to determine if the customers master data is in the system and is correct.
3. If the customer master data is not in the system or is incorrect, then the master sales and distribution data for the customer is entered by a GBI employee.
4. If the customer master data is not in the system or is incorrect, then the financial data (such as banking information and GBI reconciliation account) for the customer is entered by a GBI employee.
5. If the customer master data is not in the system, then a GBI employee checks the credit rating of the customer and assigns a credit limit and credit terms.
6. A GBI employee checks inventory availability.
7. If the customer can be extended credit and inventory is available, a GBI employee takes the customers purchase order and creates a sales order.
8. A GBI employee creates an order acknowledgement and sends it to the customer.
9. A GBI employee records the sales order.
10. A GBI employee creates a picking ticket to fill the customers order.
11. A GBI employee picks the goods (the bicycles) from the picking ticket.
12. A GBI employee creates a packing slip and a mailing label.
13. A GBI employee puts the packing slip into the reinforced container with the goods, seals the container and adheres the mailing label to the container.
14. A GBI employee moves the goods from the inventory control area to the shipping dock
15. A GBI employee creates a shipping manifest
16. A GBI employee places the goods on the truck to be shipped
17. A GBI employee gives the shipping manifest to the truck driver
18. A GBI employee creates a shipping document to show that the goods have been shipped
19. A GBI employee records that the goods have been shipped
20. A GBI employee creates an invoice with a remittance advice and sends it to the customer
21. A GBI employee receives the payment from the customer with the returned remittance advice
22. A GBI employee records the payment from the customer
23. A GBI employee takes all of the payments for that day and makes up a deposit slip for the bank
24. A GBI employee deposits the cash in the bank.
25, A GBI employee records the bank deposit.
26. A GBI employee reconciles bank deposits with the cash receipts on a daily basis.

*Task Assignment*
	Sales Rep	Sales Support Staff	Accounts Receivable	Inventory Clerk	Shipping Clerk	Billing Clerk
1. A customer sends a purchase order for off-road bicycles to a GBI employee
2. A GBI employee compares the customers purchase order to determine if the customers master data is in the system and is correct.
3. If the customer master data is not in the system or is incorrect, then the master sales and distribution data for the customer is entered by a GBI employee.
4. If the customer master data is not in the system or is incorrect, then the financial data (such as banking information and GBI reconciliation account) for the customer is entered by a GBI employee.
5. If the customer master data is not in the system, then a GBI employee checks the credit rating of the customer and assigns a credit limit and credit terms.
6. A GBI employee checks inventory availability.
7. If the customer can be extended credit and inventory is available, a GBI employee takes the customers purchase order and creates a sales order.
8. A GBI employee creates an order acknowledgement and sends it to the customer.
9. A GBI employee records the sales order.
10. A GBI employee creates a picking ticket to fill the customers order.
11. A GBI employee picks the goods (the bicycles) from the picking ticket.
12. A GBI employee creates a packing slip and a mailing label.
13. A GBI employee puts the packing slip into the reinforced container with the goods, seals the container and adheres the mailing label to the container.
14. A GBI employee moves the goods from the inventory control area to the shipping dock
15. A GBI employee creates a shipping manifest
16. A GBI employee places the goods on the truck to be shipped
17. A GBI employee gives the shipping manifest to the truck driver
18. A GBI employee creates a shipping document to show that the goods have been shipped
19. A GBI employee records that the goods have been shipped
20. A GBI employee creates an invoice with a remittance advice and sends it to the customer
21. A GBI employee receives the payment from the customer with the returned remittance advice
22. A GBI employee records the payment from the customer
23. A GBI employee takes all of the payments for that day and makes up a deposit slip for the bank
24. A GBI employee deposits the cash in the bank.
25, A GBI employee records the bank deposit.
26. A GBI employee reconciles bank deposits with the cash receipts on a daily basis.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

A given stock is currently priced at $100. Historically, its annual return has been 12 percent with a standard deviation of 15 percent. Build a spreadsheet simulation model for the stock price, using...

Assign tasks to reflect the separation of duties to each of the employees listed in the original matrix or assign tasks to other GBI employees not currently involved in the sales-to-cash process. Add...

In this part of the assignment you are to determine whether GBI has effectively assigned its employees to each of the 26 sales tasks listed above. That is, you must assess whether GBIs SOD...

Someone please help me with my GBI SAP LAB 04, i have attached a docx file Segregation of Duties Assignment Submission Your Name___________________________________ Your SAP ID# ________________ Part...

Company Background Global Bike Inc., (GBI) is a world class bicycle company serving the professional and prosumer cyclists for touring and off-road racing. GBIs riders demand the highest level of...

I need help with this question. Please refer to the background information included below 1. Create a context diagram of this manual system, create a level 0 and level 1 data flow diagram for this...

Create a context diagram of this manual system, create a level 0 and level 1 data flow diagram for this system, create a document flowchart for this system, create a system flowchart for this system,...

Assume that GBI is currently working with a manual system. The company uses the following 26 steps when they sell standard goods to the customers: 1. A customer sends a purchase order for off-road...

See Project 03-01 Assignment Spring 2015.docx Please Help me on this homework i am having some trouble answering it. Product SAP ERP GBI Release 6.04 Level Undergraduate Graduate Focus...

Estimate a regression equation that adequately estimates the relationship between monthly electrical power usage (Y) and home size (X) using the data in the file P10_13.xlsx. Interpret your results....

Solve the following initial value problem. Write y as an explicit function of x. Show all steps. use Bernoulli 2xy - y = xy, y(1) = -2

Question Evaluate the definite integral given below. 1 4 ( 2 x 3 + 5 x 2 - 4 x 4 ) d x Submit a n exact answer. Provide your answer below: 1 4 ( 2 x 3 + 5 x 2 - 4 x 4 ) d x =

Refer to the surface albedo study of pond ice, Exercise 11.43. Recall that you fit a second-order model for broadband surface albedo level (y) as a function of pond depth (x) to data saved in the...

Prepare a journal entry for the purchase of office supplies on August 7 for $4,000, paying $1,000 cash and the remainder on account.

The proper interpretation of a CI is that for a set of CIs that are all the same width (i.e., the same x% CI) for samples of the same n drawn from the same population, x% of CIs would include the...

Find the wavelength of a photon emitted in the l = 5 to l = 4 transition of a molecule whose rotational inertia is 1.75x10 -47 kgm 2

Suppose you are an astronaut orbiting the earth at an altitude of 200 km. The pupils of your eyes are 3 mm in diameter and the average wavelength of the light reaching you from the earth is 500 nm....

According to a research study investigating the use of personal Facebook pages to predict job performance, what advice should HR managers give to hiring managers concerning the use of Facebook posts...

What does it take to become an intercultural competent communicator?

What are some of the ways you use high-context communication? What are some of the ways you use low-context communication? Which do you prefer?

Is your relationship with your professors indicative of large or small power distance?