Kindly help me with this questions. It's 4 pages.

You are a management accountant working for nanoblock( ) Australia. Nanoblock is a premium high-quality Japanese brand with every model designed in our Tokyo headquarters by our nanoblock experts with an obsessive attention to detail. In order to compete with LEGO they are working towards converting their products to sustainable, plant-based materials by 2030 . They are planning to create and sell three (3) test sets ready to hit the Australian shelves by the beginning of 2024 . You have been tasked to prepare a master budget for these select three sustainable products for 2024 and to help nanoblock ( to make informed decisions to ensure their business continues to operate successfully into the future. The following information has been gathered: 4 Products: The budget you are to prepare will be for the following three (3) sustainable nanoblock@ Packs that will be trialled in 2023 made out of plant-based materials: - - Operations: nanoblock@ Australia, operate on a financial calendar-year basis July through ta Tune The husinesc runs aut af aumed nremisec in Rrichane Mueencland - Operations: nanoblock( Australia, operate on a financial calendar-year basis July through to June. The business runs out of owned premises in Brisbane, Queensland. Their sales team have provided the expected monthly sales per pack in the excel sheet attached (see BlackBoard) - Plant and Equipment: Depreciation on the production Plant and equipment totals $3,000 per quarter. - Cash collections: nanoblock(B) expects to collect 70% of its credit sales in the month of sale and the remaining 30% of credit sales will be collected in following month. The company's bad debts are negligible. - * Payments: nanoblock ( plans to pay for 20% of its material purchases within the month of purchase and the remaining 80% in the following month. - Ignore both GST and Income Tax. - All of the planning and budgeting assumptions for this test sustainability nanoblock project have been provided to you in a budget template ready for you to use to prepare the Master Budgets. Please find these budget assumptions ACCT2003 Budget.xls file in the Major assignment folder on Black Board. PART ONE: Prepare a Master Budget. Using the information provided, prepare a master budget for nanoblock( for the twelve- month period from July 2023 to June 2024 to produce and sell the three sustainable nanoblock ( packs. Your budget spreadsheet must be submitted in Excel Format (not as an appendix in your WORD document). The first worksheet should contain the budget assumptions. All future worksheets need to be linked to this data. Show all calculations and use Excel functions where possible. While you should use examples in your text as a guide, the key to using spreadsheets is that they are structured so that others can use them and follow the flow of information without difficulty. Include the following: 1. A sales budget and expected cash collections 2. A production budget 3. A direct materials budget and expected cash disbursements for purchases of materials 4. A direct labour budget 5. A manufacturing overhead budget 6. Monthly Operating Cost budget 7. An ending finished goods inventory budget 8. Cost of Sales Budget 9. Budgeted Income Statement 10. Monthly Cash Budget Use the planning and budgeting assumptions for this test sustainability project provided to you in the budget template ACCT2003 Budget.xls file in the Major assignment folder on Black Board. Complete this workbook and submit as this first part of your assignment. Analysis \& Recommendations. Write a report (Maximum 1,500 words, 10%(+/ ) will be accepted with no penalty) for the Head of Sustainability, namobleck(8) Australia. The report should include: - An overview of the expected results for the 2023/24 financial year including total revenue, operating expenses and expected final cash position; * Compare the financial performance of each product and make recommendations about how to improve the individual and overall profitability of the sustainable products range. Where appropriate use industry data (e.g. comparative product comparison, consumer confidence, labour rates) to support your recommendations for change. 2. Identify three major risks for the business in 2023/24, quantify these risks in terms of the potential impact on the profit and loss statement and provide recommendations on how to mitigate them. - Explain how the master budget you have prepared can assist nanoblock( A to plan for different what-if scenarios and help them to pivot according to changes in economic conditions: - Use visual aids such as tables and graphs to enhance your-report presentation. The report should be submitted as a WORD (notPDF) document