Calculate the Sales part for this exercise using Excel and drawing the diagram. The Billing department part is done.

Accounting fx B IXX Medina Co. is a seller of electronic equipment used by other companies in their business such as modified iPads to process! customer payments, record and perform services, etc. Customers prepare a Purchase order (1 Copy received) and send it to the Sales Department of the Company. Once the Customer Purchase Order is received the sales team manually prepared a "Sales Order" (5 copies). One copy of the Sales Order is given to the customer, one copy is sent to the Credit department for approval one copy is send to the Shipping Department, one Copy is sent to the billing department (along with the original Customer Purchase order), and one copy is filed away by the Sales Department. The Credit Department receives the Sales Order from the Sales Department and checks the customer Account Receivable Aging Report/File to determine if the customer is in good standing and either approves or rejects the Sales Order. This is performed manually. If the Sales Order is approved the document is Stamped Approved and sent to the Shipping Department (i.e. Copy 3 of the Sales Order are Stamped Approved- and is now called "Approved Sales Orders"). The Shipping Department receive copy of the original Sales order and stores it in a file until the Approved Sales Order is received. The shipping department manually match the Sales order and Approved sales order to verify the amount of goods to be shipped. The Shipping department then manually prepares a "Bill of Lading" (4 copies) and ship the merchandise through FedEx, The Sales Order and one copy of the Bill of Lading is filed away by the Shipping Department. One copy of the Bill of Lading is sent to the customer, one copy of the Bill of Lading is given to FedEx, and the final copy of the bill of Lading is sent to the Billing Department. The Billing Department Receives a copy of the Customer Purchase Order and one copy of the Sales Order from the Sales Department and files them temporarily until the Approved Sales Order and Bill of Lading are received from the Shipping Department. Then the Billing department performs a manual 4 way match of the Customer Purchase Order, Sales Order, Approved Sales Order, and the Bill of Lading. The Billing Department manually records these transactions in the Account Receivable Log and Customer Sales Logs. Finally the Billing Dept creates a customer Sales Invoice (2 Copies) through an Electronic Process and sends one copy to the customer. The second copy of the Sales Invoice is filed away by the Billing Dept. Make a flowchart for the Sales side of this exercise using Excel. hes Mailroom Account Surinary of customer Remittances Paid Directly to Bank nepares Sales Cash Recept Edit and Prepare Data Entry Sales Net Sales Receipt Accounts for Numeri Data Entry Prepares Daily Bank Deposit Entact Batches Checks Prepares Control Ling Reitan Avices Calculate Batch Total and Records in og Relate den Customers Checks S tance A Coil Listing and Sale can Liit Billing Dept. Start Customer's Purchase Order "Bill of Lading Create a Customer Sales Invoice les hem temporary until the Approved Sales Order and Bil of Lading are received from the Shipping Department Sales Invoice Sales invoice Customer Durchase Order Sales Order 2 Manual Operation Accounts Receivable og Approved Sales Order Bill of lading Seres Log Accounting fx B IXX Medina Co. is a seller of electronic equipment used by other companies in their business such as modified iPads to process! customer payments, record and perform services, etc. Customers prepare a Purchase order (1 Copy received) and send it to the Sales Department of the Company. Once the Customer Purchase Order is received the sales team manually prepared a "Sales Order" (5 copies). One copy of the Sales Order is given to the customer, one copy is sent to the Credit department for approval one copy is send to the Shipping Department, one Copy is sent to the billing department (along with the original Customer Purchase order), and one copy is filed away by the Sales Department. The Credit Department receives the Sales Order from the Sales Department and checks the customer Account Receivable Aging Report/File to determine if the customer is in good standing and either approves or rejects the Sales Order. This is performed manually. If the Sales Order is approved the document is Stamped Approved and sent to the Shipping Department (i.e. Copy 3 of the Sales Order are Stamped Approved- and is now called "Approved Sales Orders"). The Shipping Department receive copy of the original Sales order and stores it in a file until the Approved Sales Order is received. The shipping department manually match the Sales order and Approved sales order to verify the amount of goods to be shipped. The Shipping department then manually prepares a "Bill of Lading" (4 copies) and ship the merchandise through FedEx, The Sales Order and one copy of the Bill of Lading is filed away by the Shipping Department. One copy of the Bill of Lading is sent to the customer, one copy of the Bill of Lading is given to FedEx, and the final copy of the bill of Lading is sent to the Billing Department. The Billing Department Receives a copy of the Customer Purchase Order and one copy of the Sales Order from the Sales Department and files them temporarily until the Approved Sales Order and Bill of Lading are received from the Shipping Department. Then the Billing department performs a manual 4 way match of the Customer Purchase Order, Sales Order, Approved Sales Order, and the Bill of Lading. The Billing Department manually records these transactions in the Account Receivable Log and Customer Sales Logs. Finally the Billing Dept creates a customer Sales Invoice (2 Copies) through an Electronic Process and sends one copy to the customer. The second copy of the Sales Invoice is filed away by the Billing Dept. Make a flowchart for the Sales side of this exercise using Excel. hes Mailroom Account Surinary of customer Remittances Paid Directly to Bank nepares Sales Cash Recept Edit and Prepare Data Entry Sales Net Sales Receipt Accounts for Numeri Data Entry Prepares Daily Bank Deposit Entact Batches Checks Prepares Control Ling Reitan Avices Calculate Batch Total and Records in og Relate den Customers Checks S tance A Coil Listing and Sale can Liit Billing Dept. Start Customer's Purchase Order "Bill of Lading Create a Customer Sales Invoice les hem temporary until the Approved Sales Order and Bil of Lading are received from the Shipping Department Sales Invoice Sales invoice Customer Durchase Order Sales Order 2 Manual Operation Accounts Receivable og Approved Sales Order Bill of lading Seres Log