Better Finance (previously BillFloat), based in San Francisco, California, provides leasing and credit solutions to consumers and small businesses. If Better Finance wants to distribute $45,000 worth of overhead by sales, calculate the overhead expense for each department: Required: Using the information above complete the highlighted cells in the chart: 1. Total sales 2. Cost ratio for (NCS) 3. Cost ratio for (CCNS) 4. Cost ratio for (CCLES) 5. Overhead expense for (NCS) 6. Overhead expense for (CCNS) 7. Overhead expense for (CCLES) Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When flnished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. Better Finance (previously BillFloat), based in San Francisco, California, provides leasing and credit solutions to consumers and small businesses. If Better Finance wants to distribute $45,000 worth of overhead by sales, calculate the overhead expense for each department: Required: Using the information above complete the highlighted cells in the chart: 1. Total sales 2. Cost ratio for (NCS) 3. Cost ratio for (CCNS) 4. Cost ratio for (CCLES) 5. Overhead expense for (NCS) 6. Overhead expense for (CCNS) 7. Overhead expense for (CCLES) Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When flnished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect