The answers go in the excel tables. I would really appreciate it if you could give me the formulas.

Exercise 22-11 Name: Section: Score: 0% Key Code: [Key code here] Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (") will appear to the right of an incorrect entry. SAFETY GRIP COMPANY Direct Materials Purchases Budget For the Year Ending December 31, 20Y8 Rubber Steel Belts Total Pounds required for production: Passenger tires Truck tires Desired ending inventory, Dec. 31, 20YB Total pounds required Estimated inventory, Jan. 1, 20YB Total units (Ibs.) to be purchased Unit price (per pound) Total direct materials to be purchasedExercise 22-15 Name: Section: Score: 0% Key Code: [Key code here] Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (") will appear to the right of an incorrect entry. SWEET TOOTH CANDY COMPANY Factory Overhead Cost Budget For the Month Ending August 31 Variable factory overhead costs: Total variable factory overhead costs Fixed factory overhead costs: Total fixed factory overhead costs Total factory overhead costsExercise 22-16 Name: Section: Score: 0% Key Code: [Key code here] Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (") will appear to the right of an incorrect entry. WILMINGTON CHEMICAL COMPANY Cost of Goods Sold Budget For the Month Ending June 30 Finished goods inventory, June 1 Work in process inventory, June 1 Direct materials: Direct materials (oil) inventory, June 1 Direct materials (oil) purchases Cost of direct materials available for use Direct materials (oil) inventory, June 30 Cost of direct materials placed in production Direct labor Factory overhead Total manufacturing costs Total work in process during the period Work in process inventory, June 30 Cost of goods manufactured Cost of finished goods available for sale Finished goods inventory, June 30 Cost of goods soldExercise 22-6 Name: Section: Score: Key Cade [Key code hone] Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (*) will appear to the right of an incorrect entry. SONIC INC. Sales Budget For the Month Ending June 30 Unit Saks Unit Selling Total Product and Area Volume Price Sakes Model Rumble: East Region West Region Total Model Thunder: East Region West Region Total Total revenue from sales SONIC INC. Production Budget For the Month Ending June 30 Units Model Rumble Model Thunder Expected units to be sold Plus desired inventory, June 30 Total Less estimated inventory June 1 Total units to be producedEX 22-6 Sales and production budgets Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a pro- duction budget: Rumble Thunder Estimated inventory (units), June 1 . . . 750 300 Desired inventory (units), June 30 .. . 500 250 Expected sales volume (units): East Region . . ... . . 12,000 3,500 West Region . . . . . . . 14,000 4,000 Unit sales price. . ... . $160 $200EX 22-1 1 Direct materials purchases budget Anticipated sales for Safety Grip Company 1were 42,000 passenger car tires and 19,000 truck tires. Rubber and steel belts are used in producing passenger car and truck tires as follows: Passenger Car Truck Rubber 35 lb. per unit 3'8 lb. per unit Steel belts 5 lb. per unit 8 lb. per unit The purchase prices of rubber and steel are $1.20 and $0.80 per pound, respectively. The desired ending inventories of rubber and steel belts are 40,000 and 10,000 pounds, respectively. The estimated beginning inventories for rubber and steel belts are 46,000 and 3,000 pounds, respectively. Prepare a direct materials purchases budget for Safety Grip Company for the year ended December 51, 20Y8. EX 22-15 Factory overhead cost budget Sweet Tooth Candy Company budgeted the following costs for anticipated production for August: Advertising expenses $232,000 Production supervisor wages $135,000 Manufacturing supplies 14,000 Production control wages 32,000 Power and light 48,000 Executive officer salaries 310,000 Sales commissions 298,000 Materials management wages 39,000 Factory insurance 30,000 Factory depreciation 22,000 Prepare a factory overhead cost budget, separating variable and fixed costs. Assume that factory insurance and depreciation are the only fixed factory costs.EX 22-16 Cost of goods sold budget Wilmington Chemical Company uses oil to produce two types of plastic products, P1 and P2. Wilmington budgeted 50,000 barrels of oil for purchase in June for $50 per barrel. Direct labor budgeted in the chemical process was $300,000 for June. Factory overhead was budgeted $500,000 during June. The inventories on June 1 were estimated to be: Oil ................................... $15,500 P1 .................................... 25,400 P2 .................................... 22,900 Work in process ....................... 3,400 The desired inventories on June 50 were: Oil .................................... $16,100 P1 ..................................... 23,500 P2 ..................................... 25,000 Work in process ........................ 4,000 Use the preceding information to prepare a cost of goods sold budget for June