Hand in Question 5 (20 marks) The management of Bright Star Ltd 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 S 31 S 31 S 31 S31 Direct labour per unit $1.75 $1.75 $1.50 $1.50 S1.50 Labour rate per hour S21 $21 S24 $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 ce-month period from August to October (in columnar format): .