Prepare it using a table please

Q8.5 XY Led plans to sell the following: Product A (units) June 1200 July 1800 August 2800 September 3200 October 3200 Stock of finished goods at 1 June was 240 units and the company's stockholding policy is for the finished goods stock at the end of each month to represent 20% of the following month's sales requirement. Each unit of product A uses two units of a component X1. On I June there were expected to be 264 units of XI in stock. The desired closing stock of X1 is 10% of the 6 1 .15 1 14 0 13 1 12 11 1 10 1 9 1 8 1 . 7 1 6 . 1 5 . 1 . 4 1 3 1 2 . 1 1 1 next month's production. Each unit of component XI costs $5. Each unit of product A requires $6 of labour. Fixed administration overheads in each month are budgeted to be $5000 (and include a charge of $1000 depreciation). Product A can be sold for $26 each. Labour and fixed overheads are paid in the same month. Trade receivables (trade debtors) take two months to pay and the company pays its trade payables (trade creditors) after one month. The opening cash balance is $10,000. Required: (i) The production budget (in units) for June, July and August. (ii) The production cost budget for June, July and August. (iii) The raw material purchases budget (in units and {'s) for June, July and August