Advanced Database Technologies. Advanced Database Technologies. Online Ordering Process for Active Bicycle Company:
The process begins when a customer submits an online order form to Active Bicycle via the Web. The customer supplies his or her name, address, email address, model number of the bicycle they desire, and credit card number.
When the customer clicks on the submit button on the Web page, Active Bicycle’s system gets approval for the transaction from the credit card company. If the credit charge is approved, the system assigns a number to the sales order, displays an order summary for the customer to print, and sends a confirmation email to the customer. If the credit charge is denied, the customer is asked to provide a different form of payment.
The system then generates a two-part invoice, a stock release form, and a two-part packing slip form. The stock release form is sent to the warehouse department, and the two-part packing slip and one copy of the invoice are sent to the shipping department. The other copy of the invoice is maintained in a holding file in the accounting department to be filled later with the shipping certificate.
In the warehouse, employees use the stock release form to pull the appropriate inventory to fill the order. Assuming there is enough stock (for the purposes of this exercise you can assume there is enough stock), the bicycle is packed into a special box for shipping, with added protection so it will not be damaged in transit. Using the stock release form, the warehouse clerk also must take the information from the stock release form and manually fill out a shipping certificate, which is set to the accounting department for a further check that the items are being released from the warehouse. The boxed inventory, along with the packaging lip, is then sent to the shipping department.
In the shipping department, one copy of the two-part packing slip is placed in the shipping department’s file cabinet, and one is included with the goods to be sent to the customer.
Back in the Accounting Department, the shipping certificate is matched with the copy of the invoice, and the accounting database is updated to record the completion of the order. The accounting program then submits a payment request to the credit card company and both the shipping certificate and the invoice are filed in the accounting office,
Task A
Option A: Use a process modeling notation like UML Activity Diagrams to model the process previously described. It is important to provide an accurate model of the process. This model will be used for further analysis.
Option B: Alternatively you can provide a real process model from your work environment or industry. However before you committing any time analyzing the process you must OBTAIN APPROVAL from your instructor.
Task B
Use the process designed in Task A. Design a process behavior chart to measure the performance of the process for any variable you think is suitable. For example one variable that might be necessary to monitor in the above case could be “on time product deliveries”. The following items are required:
- You need to provide data for a period of at least six months.
- Based on the data provided design a process behavior chart.
- Based on the chart you have designed provide a detailed interpretation of the data presented to you by the process behavior chart.
Task C
You are working as the senior BI Analyst for the Active Bicycle Company (or for another company if a different process model has been adapted). You have been assigned to produce accurate estimations of the process time and process cost. It is important that you make rational and realistic assumptions about the time required for each activity to complete and the salaries an organization needs to pay for supporting these activities. As part of this endeavor you need to produce the following estimations:
- Process activity & Cycle time
- Annual volume of awards
- FTE for all the employes envolved in the process
- Total Labor cost
Task D
Study carefully the process described in the script. Identify at least 2 important Key performance Indicators. For each indicator identified:
- Identify the Balance Scorecard Perspective
- Identify the type of KPI (lagging, leading)
- Provide data for a period of six months.
- Design and implement a suitable dashboard that includes charts, indicators and gauges to facilitate management decision-making. You can use the online system to do dashboard this is website: (https://app.clicdata.com/v/Cwv7ycCDiwn).
You should have all of these criteria:
| TASK A | Use a process-modeling notation like UML Activity Diagrams to model the process previously described. It is important to provide an accurate model of the process. This model will be used for further analysis. | ||||||
| TASK B | Use any part of the process designed in Task A. Design a process behavior chart to measure the performance of the process for any variable you think is suitable. For example one variable that might be necessary to monitor in the above case could be “on time product deliveries”. The following items are required:
d) You need to provide data for a period of at least six months. e) Based on the data provided design a process behavior chart. f) Based on the chart you have designed provide a detailed interpretation of the data presented to you by the process behavior chart. |
||||||
|
|
|||||||
| TASK C | You are working as the senior BI Analyst for the Active Bicycle Company. You have been assigned to produce accurate estimations of the process time and process cost. It is important that you make rational and realistic assumptions about the time required for each activity to complete and the salaries an organization needs to pay for supporting these activities. As part of this endeavor you need to produce the following estimations:
5. Process activity & Cycle time 6. Annual volume of awards 7. FTE for all the employes envolved in the process 8. Total Labor cost |
||||||
| TASK D | Study carefully the process described in the script. Identify at least 2 important Key performance Indicators. For each indicator identified:
5. Identify the Balance Scorecard Perspective 6. Identify the type of KPI (lagging, leading) 7. Provide data for a period of six months. 8. Design and implement a suitable dashboard that includes charts, indicators and gauges to facilitate management decision-making. |
||||||
p(5)
Place your order now to enjoy great discounts on this or a similar topic.
People choose us because we provide:
Essays written from scratch, 100% original,
Delivery within deadlines,
Competitive prices and excellent quality,
24/7 customer support,
Priority on their privacy,
Unlimited free revisions upon request, and
Plagiarism free work,
Advanced Database Technologies
Advanced Database Technologies
For a custom paper on the above or a related topic or instructions, place your order now!
What We Offer:
• Affordable Rates – (15 – 30% Discount on all orders above $50)
• 100% Free from Plagiarism
• Masters & Ph.D. Level Writers
• Money Back Guarantee
• 100% Privacy and Confidentiality
• Unlimited Revisions at no Extra Charges
• Guaranteed High-Quality Content
