Hi, can you solve and explain what is the production budget

Question 5 (20 marks) The management of Bright Star Lid is planning to prepare various operating budgets for the next three months from August to November. The following estimated financial data is available from the budgeting department: Aug. Sep. Oct. Nov. Dec. Estimated sales (units) 25.000 25,000 27,000 27,500 28,000 Sales price per unit $31 $ 31 $ 31 $ 31 $ 31 Direct labour per unit $1.75 $1.75 $1.50 $1.50 $1.50 Labour rate per hour $21 $21 $24 $24 $24 New machinery will be added in October. This machine will reduce the labour required per unit and increase the labour rate for those employees qualified to operate the machinery. Other relevant information for the preparation of budgets are available as follows: The beginning inventory in August is 3,750 units of finished goods and 13,125 pounds of materials. Finished goods inventory is required to be 20% of the next month's requirements. Direct material requires 2.5 pounds per unit at a cost of $5 per pound. The ending inventory required for direct materials is 20% of the next month's needs. Required: Prepare the following operating budgets for the three-month period from August to October in columnar format)