Question 4 (22 marks) Glamping Products Pty Ltd is a supplier of modern camping beds to the retail sector They are currently designing their first forward budgeting reports, and have asked for your assistance in preparing some sample budgets for their internal management use. They have provided you with the following information: Estimated sales units: Month (2019) June July Sales units 1,000 900 Month (2019) August September Sales units 1,000 1,000 The selling price per unit is $80, which will remain constant over the budget period. Inventories of finished goods as at 31 May is 300 units. From June, the company would like to maintain an inventory of finished goods at a level equal to 40% of the following month's sales units. There is no WIP. Inventories of direct material (fabric) used to manufacture the beds as at 31 May is 2000 metres (at $5 per metre). For the reminder of the budget period, the company would like to maintain enough inventory of direct materials at the end of each month to cover 50% of the following month's production needs. Budgeted manufacturing costs are as follows: Direct materials (5 metres per bed at $5 per metre) $25 per unit Direct labour (0.5 hours per bed at $26 per hour) $13 per unit Variable overhead (allocated at $8 per DLH) $4 per unit Fixed overhead (including depreciation of $2000) $10,000 Selling and administrative expenses are expected to be $8750 per month All sales are made on credit, with 50% of customers paying in the month of sale, 45% paying in the following month, and 5% being uncollectable. Purchases are paid 50% in the month of purchase, and 50% the following month. All other relevant manufacturing costs as well as selling and administrative expenses are paid as incurred. The opening cash balance as at 1 July 2019 is $5000. Required: Prepare the following budgets for the company a) Production Budget for the months of June and July. (4 marks) b) Direct Material Purchases Budget for the months of June and July (in both metres and dollars). (9 marks) c) Cash Budget for the month of July only. (9 marks)