Homework answers / question archive / 15

15

Accounting

Share With

15. Using the following information, please calculate the balances for A/R and A/P control accounts. Hint: Control accounts are the general ledger accounts and you can show them here in "T-account" format. Beg. A/R control account balance $340,000 Beg. A/P control account balance $92,000 Sales Journal had total sales of $161,000 Purchases Journal had purchases of $54,000 Cash Receipts Journal has A/R total of $141,000 Cash Disbursements Journal has A/P total of $47,000 14. Please do the bank reconciliation (bank rec) for your company, as of Nov. 30th. The following information pertains to your company: *Cash balance per bank, Nov. 30, $14,263 *Nov. bank service charge not recorded by the depositor S15

3. Given is a table of revenue and costs for a project to be implemented. a) Please create a forecasted cashflow spreadsheet. Please show clearly i. the Cash In-flow, (8 marks) ii. the Cash outflow, (8 marks) iii. the Net Cashflow, (8 marks) iv. the Cumulative Cash flow. (8 marks) v. Analyze and state the minimum amount of money that should be advanced to the Project Team to ensure that the project team cumulative cashflow remain positive throughout the project? (8 marks) Cost Price Offer Price Cost/Revenue Description Quantity Uni Total Rete Total Preliminaries 1.1 Mobilisation unit 9,000.00 9,000.00 10,000.00 10,000.00 1.2 Total Preliminaries 9,000.00 10,000.00 Z Installation Work 2.1 Project Manager 6 month 7,000.00 42,000.00 10,000.00 50,000.00 35,000.00 2.2 month 24,000.00 5,000.00 Engineer Supervisor 2.3 month 4,000.00 32,000.00 3,000.00 1,500.00 24,000.00 43,000.00 Le bour 4 month 8 2,000.00 54,000.00 2.5 Total Installation Works 12 133,000.00 192,000.00 Materials Sites 1 3,000.00 60,000.00 9,000.00 100,000.00 Testing Tools 20 sites 1 300.00 6,000.00 400.00 8,000.00 3 Miscellaneous 9,000.00 10,000.00 10.000.00 5,000.00 214,000.00 5 TOTAL Cost/Revenue 320,000.00 Conditions for the Cashflow: 1. Payment terms is 45 days after submission of Invoice. 2. Invoicing will be done at end of working month. 3. Project Manager and Engineer will start one month before the installation team and finishes one month after. 4. Total Installation works for the installation team is 4 months 5. There are 20 sites for installation. Each month can complete 5 sites. 6. Testing will be done immediately after installation works is complete.