draw a flowchart and document in excel!!

12.24. The Beridge Company (Document Flowcharts) The Berridge Company is a discount tire dealer that operates 25 retail stores in a metropoltan area The company maintains a centralized purchasing and warehousing facility and employs a perpetual imventory system. All purchases of tres and related supplies are placed through the company's central purchasing department to take advantage of if quantity discounts oftered by its suppliers. The tires and supplies are recerved at the central warehouse and distributed to the retail stores as needed The perpetual inventory system at the central tacility maintains current inventory records, which include designated reorder points, optimum order quantitios, and balance-on-hand information for each type of tire or related supply. The participants involved in Berridge's inventory system include (1) retail stores, (2) the imventory control department (3) the warehouse, (4) the purchasing department, (5) accounts plyable, and (6) outside vendors. The inventory control department is fesponsible for maintenance of the perpetual inventory records for each item carried in invertor The warehouse department maintains the physical inventory of all ifers carried by the company's retal stores. All deliveries of tres and related supplies from vendors are received by rocewing clerks in the warehouse department, and all distributions to retai stores are filled by shippeng clerks in this department. The purchasing department places every order for Aems needed by the company. The accounts payable department maintains the subsidiary ledper with vendors and other creditors. All payments are processed by this department. The documents used by these various departments are as follows: Retail Store Requistion (Form RSR) The retail stores submit this document to the central warehouse whenever tres or supples are needed The shipping clerks in the warehouse department fill the orders from irventory and have them delivered to the stores. Thee copies of the document are prepared, two of which are sent to the warehouse and the third copy is filed for reference Purchase Requisition (Form PR). An inventory control clerk in the inventory control dopartment prepares this document when the quantity on hand for an item falls below the designatod reorder poent Two copes of the document are prepared One copy is forwarded to the purchasing department, and the other is filed Purchase Order (Form PO). The purchasing department prepares this docurnent bused on the informatoon found in the purchase requisition. Five copies of the purchase order are prepared The disposition of these copies is as follows copy 1 to vendor, copy 2 to accounts payable department, copy 3 to inventory control department, copy 4 th warehouse, and copy 5 filed for retorence Receiving Report (Form RR). The warehouse department propares this document when ordered items ate received from vendors A receving clerk completes the docume by indicating the vondor's narne, the date the shipment is receved, and the quartity of each itern received Four copies of the report are propared Copy 1 is sent to the accounts payable department, copy 2 to the purchasing department, and copy 3 to the inventory control dopartment Copy 4 is retained by the warehouse department. compared with the purchase order form in its Ales, and flod together with this purchase ordet form for future reforence Invoices. Invoices received from vendors are bills for payment. The vendor prepares several copies of each iwoice, but only two copies are of conceen to the Berridge Company the copy that is received by the congany's accounts payable department and the copy that is retained by the vondor for reference. The accounts payable departmont cornpares the vendor invoice with is fie copy of the ofiginal purchase order and its file copy of the wasehouse rocewing report Based on this information. adjustrents to the bill amount on the invoice are made (o g, for damaped goods, for trade discounts, or for cash discounts), a check is prepared; and the payment is mailed to the vendor