3. The following data are available in a manufacturing company for a yearly period: Particulars Fixed expenses: Wages and Salaries 9,50,000 Rent, Rate & Taxes 6,60,000 Depreciation 7,40,000 Sundry Admin Expenses 6,50,000 Semi Variable Expenses at 50% Capacity: Maintenance & Repairs 3.50.000 Indirect Labor 7,90,000 Sales Dept. Salaries etc. 3,80,00 Sundry Admin Salaries 2,80,000 Variable Expenses Material 21,70,000 Labor 20,40,000 Other Expenses 7.90,000 Total 98,00,000 Sales at various levels are: 50% Capacity 60% Capacity 75% Capacity 90% Capacity 100% Capacity Assume that the fixed expenses remain constant for all levels of production, the semi- variable expenses remain constant between 45% and 65% capacity, increasing by 10% between 65 percent and 80 percent capacity, and by 20 percent between 80% and 100% capacity Required: a) Prepare a flexible Budget for the year at various capacity levels 60%, 75%, 90% and 100% (3 marks) b) Forecast the profit for the year in different levels of production at 60%, 75%, 90% and 100% (2 marks) c) Suggest at which level of production the company earn optimum profit. (1 mark)