Monthly Sales Report Process On a monthly basis, the Accounting Department prepares the Monthly Sales Report....

Transcribed Image Text:

Monthly Sales Report Process On a monthly basis, the Accounting Department prepares the Monthly Sales Report. Metrics in the Monthly Sales Report include total sales, average order value, average purchase frequency, customer retention rate, and customer lifetime value. Customers create orders on the website by completing the website checkout process. The order information is stored in the e-commerce platform database, and the e- commerce platform sends an order confirmation to the customer's email address. The e-commerce platform also sends the order and shipping details to the company's third- party shipping service. When the shipping service has shipped the order, they log into the logistics portal on the e-commerce platform, input the tracking details, and mark the order as shipped. The customer relationship management (CRM) software uses an automated integration to synchronize the customer contact data, order data, and product data to the CRM database. At the end of every month, an analyst downloads the customer data, order data, and product data from the CRM. The analyst calculates the total sales, the average order value, average purchase frequency, customer retention rate, and customer lifetime value and prepares the Monthly Sales Report, which is reviewed by the Accounting Manager, who adds the information to a draft of the Monthly Investor Update. The CEO provides the Monthly Sales Report to the Bank, where the business has a line of credit. Then the CEO completes the Monthly Investor Update and sends it to Investors by the 3rd business day of each month. Prepare a Context Diagram for the process described above. Submit an Excel workbook as a .xls or xlsx file. Monthly Sales Report Process On a monthly basis, the Accounting Department prepares the Monthly Sales Report. Metrics in the Monthly Sales Report include total sales, average order value, average purchase frequency, customer retention rate, and customer lifetime value. Customers create orders on the website by completing the website checkout process. The order information is stored in the e-commerce platform database, and the e- commerce platform sends an order confirmation to the customer's email address. The e-commerce platform also sends the order and shipping details to the company's third- party shipping service. When the shipping service has shipped the order, they log into the logistics portal on the e-commerce platform, input the tracking details, and mark the order as shipped. The customer relationship management (CRM) software uses an automated integration to synchronize the customer contact data, order data, and product data to the CRM database. At the end of every month, an analyst downloads the customer data, order data, and product data from the CRM. The analyst calculates the total sales, the average order value, average purchase frequency, customer retention rate, and customer lifetime value and prepares the Monthly Sales Report, which is reviewed by the Accounting Manager, who adds the information to a draft of the Monthly Investor Update. The CEO provides the Monthly Sales Report to the Bank, where the business has a line of credit. Then the CEO completes the Monthly Investor Update and sends it to Investors by the 3rd business day of each month. Prepare a Context Diagram for the process described above. Submit an Excel workbook as a .xls or xlsx file.