I need help calculating selling, admin and finance budget, cash budget and income statement based on the below information.

Rice Products Pty. Ltd. is a local rm that produces two moulded plastic products: kickboards and pool buoys. The products are manufactured in a two step process and each process is treated as a separate cost centre. In the rst process, the mixing department, a special resin is combined with a hardener. Moulding occurs in the second process where the output from the mixing department is poured into special shaped moulds. Due to the nature of the chemical compounds contained in the resin and hardener, the manufacturing process occurs very rapidly. Production is therefore scheduled so that no work-in-process inventory is held at the end of each day. The following information has been extracted from the accounting records of Rice Products or obtained through discussions with the senior management team: 1. Balance Sheet (Statement of Financial Position) as at 30 June 2020: Cash 35 9,000 Trade Creditors $ 3,520 Accounts Receivable 35,210 Shareholders' Equity 150,000 Raw Materials Inventory 3,403 Retained Earnings 30,548 Finished Goods Inventory 11,450 (Kickboard $3,496; Pool buoy $2,954) Plant and Equipment (Net) 125,000 TOTAL ASSETS S 239,068 TOTAL LIABILITY & EQUITY S 239,088 2. The following schedule details the recent actual monthly unit sales achieved for each product to 30 June 2020. Additionally, the sales manager has projected sales volume forecasts for each product to November 2020: WEE-\"WHEN?- mum-mil 3. Kickboards sell for $28 each and pool buoys for $24 each. Due to the tight cost control practices Rice Products has been able to maintain selling prices for the last 6 months and, in the absence of policy changes, do not foresee any change in the selling prices in the next 6 month period. 4. All sales are on credit: 15% are collected in the month of sale, 45% in the month following sale and the remaining 40% is collected in the second month following sale. 5. Details of the standard costs to manufacture one unit of each product are provided below: FACTORS OF PRODUCTION KICKBOARDS POOL BUOYS Materials Resin 2 litres @$0.45/litre 3 litres @$0.45/litre Hardenel 6 litres @$0.70/litre 2 litres @$0.70/litre Labour Mixing Department 18 minutes @$20/hour 12 minutes @$20/hour Moulding Department 12 minutes @$30/hour 12 minutes @$30/hour Factory Overhead: Mixing Department $7.00/direct labour hour $7.00/direct labour hour Moulding Department $11.00/direct labour hour $11.00/direct labour hour 6. Depreciation on factory equipment is computed to be $1.00 per labour hour for each department and is included in the factory overhead rates shown above. 7. Materials are purchased on credit. Rice pays 60% of accounts in the month of purchase and the remaining 40% in the following month. Labour costs and all overhead costs (except depreciation) are paid as they are incurred. Monthly differences between applied and actual overhead costs are expected to be negligible. 8. Rice has an inventory policy in place where purchases of raw materials are scheduled to be 60% of the next month's anticipated production needs. Additionally, production is scheduled so that the number of finished units on hand at the end of each month is sufficient to support 30% of the following month's forecast sales. 9. The number of inventory items held as at 30 June 2020 was as follows: MATERIAL/PRODUCT LITRE/UNIT Resin 5040 litres Hardener 8772 litres Kickboards 720 units Pool Buoys 330 units 10. Fixed selling and administration expenses are $25,000 per month (including $1,000 of depreciation on office equipment). Sales commissions are paid at 7% of total sales dollars. Selling and administration expenses are paid in the month incurred. 11. Rice's management has a policy of maintaining a cash balance of $9,000 at the end of each month. This amount represents a buffer that is maintained as a margin of safety against unforeseen events which might cause significant departures from budget estimates. If this requirement cannot be met,Rice has a standby credit arrangement in place with its bank to borrow the exact amount needed to achieve the desired cash balance. If Rice has a cash balance greater than $9,000 at the end of any month and an outstanding loan balance then the cash in excess of $9,000 is repaid to the bank. 12. The interest rate applicable to the bank loan is 12% per annum to be paid on a monthly basis on the outstanding principal at the end of the previous month. 13. Rice uses the FIFO (rst in rst out) method to value ending inventory. PART A (65 Marks) You have been appointed to the position of senior management accountant at Rice Products. It is your responsibility to prepare a master budget for the next quarter (July, August and September 2020). The master budget documents are to consist of the following reports (the budgets should show the gures for each month and a total for the quarter where appropriate and round calculations to the nearest dollar}: 0 Sales Revenue Budget 0 Production Budget (Units) o Direct Material Purchase Budget (Unites and $) 0 Direct Labour Budget (Hours and $) 0 Factory Overhead Budget 0 Selling, Admin and Finance Budget 0 Cash Budget 0 Income Statement (Statement of Financial Perform ance} 0 Balance Sheet (Statement of Financial Position) The budget documents are to be prepared using Excel spreadsheet and the template should consists of three sections: an index section to identify yourself and spreadsheet layout, a data section that contains relevant case study information which will be used to construct the budgets, and a budget reports section. Appendix 1 and Appendix 2 have been attached to provide a suggested format for the design of the data section and the budget reports section. It is important to note that the gures in the report section should be derived from FORMULA ONLY that relates to information in the data section. That is the budget documents should be constructed in such a manner that will enable sensitivity (\"WHAT IF\") analyses to be perform ed. Hint: Check that your budget reports match the key checking gures provided in Appendix 2 and the balance sheet balances. MASTER BUDGET - RICE PTY LTD Schedule 1 Sales Budget Kickboards July Aug Sept Total Oct 67,200 Pool Bouys 72,800 64,400 204,400 81200 26,400 Total Sales Revenue Budget 31,200 24,000 81,600 21600 93,600 104,000 88,400 $ 286,000 102800 Schedule 2 Production Budget (Units) Kickboards July Aug Sept Total Oct Budget Sales 2,400 Target Ending Inventory 2,600 2,300 7,300 2900 780 690 Units Required 870 870 900 3, 180 Beginning Inventory 3,290 3,170 8,170 3800 Total Production Budget 720 780 690 720 2,460 870 2,510 2,480 7,450 2930 Pool Bouys Budget Sales 1,100 Target Ending Inventory 1,300 1,000 3,400 900 390 Units Required 300 270 270 300 1,490 1,600 Beginning Inventory 1,270 3,670 1200 330 390 Total Production Budget 300 330 1,160 270 1,210 970 3,340 930Schedule 3 Direct Materials Purchases Budget July Aug Sept Total Oct Resin {Litres} Budget Use in Production 8,400 8,650 7,870 24,920 8650 Target Ending Inventory 5,190 4,722 5,190 5,190 Units Required 13,590 13,372 13,060 ' 30,110 Beginning Inventory 5,040 5,190 4,722 5,040 Total Litres Purchased 8,550 8,182 8,338 25,070 5 0.45 55 0.45 $ 0.45 $ 0.45 Resin Purchase Costs 55 3,848 55 3,682 $ 3,752 $ 11,281 Hardener {Litres} Budget Use in Production 14,620 14,970 14,340 43,930 16510 Target Ending Inventory 8,982 8,604 9,906 9,906 Units Required 23,602 23,574 24,246 53,836 Beginning Inventory 8,772 8,982 8,604 8,772 Total Litres Purchased 14,830 14,592 15,642 45,064 $ 0.70 $ 0.70 $ 0.70 $ 0.70 Hardener Purchase Costs 95 10,381 $ 10,214 $ 10,949 $ 31,545 Total DM Purchases Budget 5 14,229 $ 13,896 $ 14,702 $ 42,826 Schedule 4 Direct Labour Budget July Aug Sept Total Mixing Department Kickboards Pool Bouys Direct Labour Hours 0.3 0.2 970 995 938 2,903 Direct Labour Costs $20/hour $20/hour $ 19,400 $ 19,900 $ 18,760 $ 58,060 Moulding Department Direct Labour Hours 0.2 0.2 724 744 690 2158 Direct Labour Costs $30/hour $30/hour $ 21,720 $ 22,320 $ 20,700 $ 64,740 Total Direct Labour Budget $ 41, 120 $ 42,220 $ 39,460 $ 122,800 Schedule 5 Factory Overhead Budget July Aug Sept Total Mixing Department 6,790 6,965 6,566 20,321 Moulding Department 7,964 8,184 7,590 23,738 Total Factory Overhead Budget $ 14 754 $ 15,149 $ 14,156 $ 44,059