Draw Usecase Diagrams and All levels of DFDs (context, 0, ..n) for the following Payroll system of the Salescrop Company:

Current SalesCorp Business Model/Process

• SalesCorp facilitates door to door sales of other companies’ (vendors) products.
• SalesCorp’s main job is to facilitate the following:
  • Recruitment of “Contractors” to sell other companies’ products
  • Payment of commissions to those contractors based on the sales they make/products they sell
    • Salescorp gets paid a set amount by vendors for all the sales that their contractors make. Salescorp keeps some of this as profit, and turns around and pays out the rest in commissions to their contractors

• SalesCorp organizes contractors under “campaigns” for each vendor. A campaign can have multiple different contractors under it selling a vendor’s products

• The contractors that SalesCorp recruits represent an independent business unit. These contractors will recruit “agents” that go door to door and make sales of the vendors’ products.
  • The sales that each agent makes are tracked by the vendor

• SalesCorp pays the contractors commissions based on how many of each product their agents sell. Note that SalesCorp does not pay the agents period. They pay the contractors, and the contractors pay their own agents.
  • Contractors will have multiple “management” types that get commissions paid to them per product. So if there’s Product A and Product B for a given campaign/vendor, Contractor A might have a “Recruiter” and a “VP” who both get paid different amounts of commission for Product A and Product B.

• Every week, the vendor will send a spreadsheet of sales (called an invoice) to SalesCorp notating which agents sold which products that week. Since we only get data about the agents that made sales, SalesCorp needs to keep track of which agent is under which contractor, so that we can correctly attribute the sale’s commission to the right contractor. This sales data will identify the agent by their “Agent ID”.
  • We don’t need to keep track of any other agent data besides their “Agent ID”, first name, last name, and what contractor they’re under.
  • The sales data/invoice spreadsheet can be in a different format per campaign/vendor, and it needs to be able to be processed regardless of what format it’s in. However, each one is guaranteed to have some key information in it that we need – in particular the product that was sold, and the id of the agent that sold it.

• SalesCorp deals with multiple campaigns/vendors at a time, and each campaign can sell many products, have many contractors under it, and those contractors may have dozens of agents under them.

• Contractor’s commission rates are updated often – on a sometimesweekly basis. The payroll specialists at SalesCorp keep track of and enter the commission rates. These people also handle setting up new campaigns, and importing sales/generating paysheets each week.

• Data entry specialists handle entering basic data for new contractors and agents that are onboarded – which happens constantly.

• Each week when the sales data from vendors is sent in, SalesCorp needs to be able to process that data against their contractor’s commission rates and generate a “pay sheet” that details how much commission each contractor makes. That paysheet should then be emailed out each week. A distinct paysheet should go out to each person who makes commissions under a contractor. We’ll know a sale should be attributed to a contractor, because the agent Id from the sale will match one of the agents under them.

• On the paysheets, commissions are calculated for a sale one of three ways:
  • If a sale is payable, commission is paid at whatever the commission rate for the manager on the contractor is
  • If sale is not payable, commission is 0
  • If sale is a “chargeback”, commission is the commission rate of the manager on the contractor x -1 (a refund basically)

General Notes About How Process Should Work Within New System:

New system will be web based. The following assumes that we should be able to do all of these through web-based interfaces:

• Set up campaigns for each vendor as needed
• Set up contractors for each campaign
  • Set up the commission rates for each person within that contractor who will get paid commission by product
• Set up agents associated with each contractor
• For each campaign/vendor that is set up in the system:
  • Load in sales data/invoices each week for campaign, data should be automatically extracted from the sales spreadsheet regardless of format and be saved to the database
  • Generate paysheets and have them emailed out to each person who makes commissions under each contractor.
• It stands to reason that we’d want a way to be able to manage what users can use this system as well, that’s probably something someone in an “admin” role should do

Answer rating: 100% (QA)

Use Case Diagram sql Copy code Administrator Manage User A... View the full answer