Sharp Motor Company has two operating divisions-an Auto Division and a Truck Division. The company has a cafeteria that serves the employees of both divisions. The costs of operating the cafeteria are budgeted at $72,000 per month plus $0.70 per meal served. The company pays all the cost of the meals. The fixed costs of the cafeteria are determined by peak-perlod requirements. The Auto Dision is responsible for 63% of the peak- period requirements, and the Truck DMision is responsible for the other 37%. For June, the Auto Division estimated It would need 97.000 meals served, and the Truck Division estimated it would need 67,000 meals senved. However, due to unexpected layoffs of employees during the month, only 67,000 meals were served to the Auto Division Another 67000 meals were served to the Truck Dvision as planned. The cafeteria's actual fixed costs for June totaled $78,000 and its actual meal costs totaled $110,800. Required: 1. How much cateteria cost should be charged to each division for June? 2. Assume the company follows the practice of allocating all cafeteria costs Incurred each mont to the divisions in proportion to the number one served to each division during the month. On this basis, how much cost would be allocated to each division forume (Round your intermediate calculations to 2 decimal places.) Division Division red credentials are out of a Excellence Corporation is continuing its budget preparations. Excellence had the following static budget and actual overhead costs for March. Excellence CORPORATION Excellence CORPORATION Manufacturing Overhead Budget Manufacturing Overhead Costs (Static) For the Month of March (Actual) For the Month of March Budgeted production in 117,500 Production in units 118,500 units Budgeted costs Costs Indirect materials $5,875 Indirect materials $5,910 Indirect labor 14,100 Indirect labor 14,195 Utilities 11,750 Utilities 11,880 Maintenance 8,225 Maintenance 8,275 Salaries 42,000 Salaries 42,000 Depreciation 16,800 Depreciation 16,800 Property taxes 3,000 Property taxes 3,000 Insurance 1,200 Insurance 1,200 Janitorial 1,500 Janitorial 1,500 Total budgeted costs $104,450 Total costs $104,760 Excellence produced 118,500 units in March rather than the budgeted number of units. Instructions 1. Prepare a flexible overhead budget based on the 118,500 units produced. 2. Prepare a responsibility report (which shows the spending variances and activity variances) for the month of March