Please help. :)

Required:

Using Excel, answer the questions below. Use one tab per question and also include any written response within Excel.

Note that marks are also allocated for professional presentation and the use of formulas within Excel.

Required: Using Excel, answer the questions below. Use one tab per question and also include any written response within Excel. Note that marks are also allocated for professional presentation and the use of formulas within Excel. QUESTION 3 (21 marks) Fussy Hair Ltd has decided to prepare a cash budget for the quarter ending 30st September 2016. Services are provided on 30 day credit terms. As at 1 July 2016, the Cash at bank ledger account had a debit balance of $500,000. The following estimates have been made for the next three months: July August September Sales 200,000 300,000 400,000 Cash purchases 150,000 140,000 160,000 Cash wages 15,000 20,000 28,000 Depreciation on plant 80,000 80,000 80,000 Electricity expenses 10,000 11,000 11,500 Insurance expenses 36,200 36,200 37,000 Loan repayment 0 20,000 20,000 All sales are on credit. It is expected that debtors will pay their accounts as follows: 50 per cent in the month following the sale. * 20 per cent in the second month following the sale. * 30 per cent in the third month following the sale. Actual sales for the previous three months were as follows: $300,000 in April 2016 $290,500 in May 2016 * $320,000 in June 2016 Electricity expenses and insurance expenses are paid the following month after they are incurred. June expenses were as follows: Electricity expenses $8,000 Insurance expenses $35,000 REQUIRED:Part A: Prepare a schedule of cash receipts from debtors for the period ending 30th September 2016. (7 marks) Part B: Prepare a Cash budget for the Quarter ending 30th September 2016. (14 marks) QUESTION 4 (9 marks) Terrific Tables Pty Ltd incurred the following costs to produce job number TB300, which consisted of 500 office desks. Direct material: 1 June Requisition no. 520: 900 metres of timber @ 8.00 per metre 18 June Requisition no. 101: 600 metres of steel @ $0.20 per metre Direct labour: 18 June Timesheet no. 72: 500 hours@$14 per hour Manufacturing overhead: Applied on the basis of direct labour hours @$12 per hour Additional information: Job TB300 was completed on 18 June. REQUIRED: Prepare a job cost sheet and record the information given above and also a cost summary for job TB300