Please show workings and calculations to help me understand this question. All materials of the question provided, please help with as much as possible. Thank you
Advantage Manufacturing is preparing a master budget for the quarter ending 30 September 2021,I and has compiled the data shown below. '0' The rm sells a single product at a price of $50 per unit. The sales forecast (in units) prepared by the marketing department for the quarter ending 30 June 2021 and the rst 2 months of the next nancial year is as follows. Number of units April 23 300 Ma}.t 23 300 June 30 000 July 31 200 August 33600 September 33 600 October 3? 200 November 33 400 December 43 200 January 5? 600 a? The ending nished goods inventory should equal 15% of the sales requirements for the next 3 months, and the raw materials ending inventory should equal 20% of the next month's production requirements. '35" Cash sales account for 50% of sales. Credit sales are collected 40% in the month of sale and 60% in the following month. '35" 30% of the materials purchases are paid in the month of purchase and 20% are paid in the following month. '35" The production requirements are below. Direct material: Direct labour Per unit 1.1 kg 0.5 how The direct materials are purchased for $3.00 a kilogram. The direct lahour wage rate is $24 an hour. The budgeted factory overhead per month is as follows: fixed overhead cost Rates 36 400 Insurance 45 000 Maintenance 22 600 Depreciation 28 000 Variable overhead cost: Indirect labour $1.50, per month's direct labour hour Indirect material $2.30, per month's direct material kg The 1 July 2021 cash balance is expected to be $40 320. Selling expenses are budgeted as follows: Advertising expense: $900 per month, paid in the month in which incurred. Depreciation expense: $18 500 per year Sales salaries: $5 000 per month and paid as incurred. * Administrative expenses are budged as follows: Rent on administration premises is $3 000 per month, paid by the last day of the month. Variable administrative expenses per month are 7% of sales. Required (All calculations to be rounded to the nearest dollar value.) (a) Calculate the number of units to be produced in the first quarter of the financial year starting 1 July 2021. (b) Prepare a cash budget for the first quarter of the financial year starting 1 July 2021 including any necessary schedules. (c) Prepare a budgeted income statement for the first quarter of the financial year starting 1 July 2021. (d) Prepare a partial budgeted balance sheet for the first quarter of the financial year starting 1 July 2021, based on the available information