Part - A: Lee Incorporated:Lee Incorporated has the following processes related to purchasing:
When it is determined that an item should be ordered, the purchasing department prepares a three-copy purchase order. The first copy is mailed to the vendor, the second copy is filed by PO number in the purchasing department, and the third copy is forwarded to inventory control. Inventory control updates the inventory ledger with the quantities that were ordered and files the purchase order copy by date.
When ordered items arrive at the receiving dock, the packing slip is inspected and a two-copy receiving report is prepared. The first copy is forwarded to the purchasing department, where it is filed with the purchase order. The second copy is filed in the receiving department by date. The packing slip is forwarded to the accounts payable department.
Vendors mail invoices directly to the accounts payable department. The accounts payable department reviews the invoice and related packing slip, prepares a cash disbursement voucher, updates the accounts payable ledger, and files the invoice by date. The cash disbursement voucher is forwarded to the cash disbursements department. The packing slip is returned to the receiving department. The cash disbursements department prepares a two-copy check, mails the first copy to the vendor, and forwards the second copy to the general ledger department. The cash disbursement voucher is forwarded to the accounts payable department where it is filed with the invoice.
The general ledger department updates the general ledger accounts, using the second copy of the check, and then forwards the check copy to cash disbursements to be filed by check number.
Part- B: Lee Incorporated: Based on total 2015 sales of $4,000,000, management has forecasted the following monthly growth in sales and monthly cash collection measures for 2016:
- Create a 12-month cash flow budget in Excel using the following assumptions:
- Annual 2015 sales of $4,000,000 with forecasted monthly growth of 2%
- 45% of each month's sales for cash; 25% collected the following month; 20% collected 2 months later; 8% collected 3 months later; and 2% never collected
- Initial cash balance of $300,000
Assuming an initial cash balance of $300,000, management has concluded that they will achieve an ending cash balance of $31,000,000.
Required:
Part - A:
1. Draw a document flowchart of the purchase processes of Lee.
2. Identify any weaknesses in internal controls within the purchase processes and indicate the improvements you would suggest.
3. Draw a new document flowchart that include your suggested improvements.
Part- B: In a few sentences, evaluate management's conclusion.
Please do in excel