Using Formulas to Find Missing Information GST Mr Men are not very good at keeping reliable records. Many of them have been trying to work out some figures which covered a few months. Most only had parts of information in Q 6 Mr Lazy had been shown, many times, how to calculate GST by using relevant information from each case. By using the formulas, could you help them by finding the missing figures for the journals, and balances at the beginning of the reporting period. He managed to each calculation. find the following information on various pieces of paper in his office. At 1 January 2009 Accounts Payable were $31.010. The Cash Payments Journal for January ACCOUNTS RECEIVABLE showed he had paid Accounts Payable $25,000, while his Accounts Payable Schedule Q 1. At September 30, Mr Forgetful knew that his Credit sales, including GST, were $8.000, his receipts from Accounts Receivable were $9,000, and Accounts Receivable at end were $13,000. He showed that Mr Lazy owed Accounts Payable $38,900 at 31 January. Calculate GST charged on Credit Purchakes. wants to know what the balance of Accounts Receivable was at September 1. ACCOUNTS PAYABLE Q 2. Mr Untidy wanted to know how much he had paid Accounts Payable in October. In his Accounts Payable' schedule he knew that the balance at end was $17.600. His balance at start was $24,000 which, when added to credit purchases, including GST, was $28,400. GST Q 3. Mr Clean had received $2,600 in GST from cash sales, and had charged $3,100 for GST on credit sales. His total GST on purchases was $6,800 of which $4,900 was incurred on credit purchases. GST at 31 July was $2,600. Calculate GST figure for cash purchases. GST Q 4. Mr Clumsy was owed $430 GST by the tax office at 1 July. He paid $220 for cash purchases and incurred a further $360 on credit purchases. His total GST on sales was $1200, of which $640 had been received on cash sales. Calculate the final GST figure. ACCOUNTS RECEIVABLE Q 5. a) Mr Perfect showed Mr Impossible how to calculate his Accounts Receivable formula, but Mr Impossible did not write down the credit sales figure. The other figures were: Accounts Receivable balance at start $9,500, receipts were $12,200 and the balance at end $13,800. GST Mr Impossible knew how to calculate his GST debt (or refund) when he had all necessary information available to him. However, he did not know how much tax he had charged on credit sales although he knew he had received $180 GST from cash sales. His balance at the beginning of the reporting period was $890 owing to the tax office. He had paid $500 on cash purchases and incurred $330 on credit purchases. Mr Perfect had explained to him that his final debt to the tax office was