Could you fill out table 2 or part of it based on the information given above?

Kiewit does not expect to change the mode of the operation for the next year. However, subcontract costs will decrease and the expected decrease in relationship to revenue is 1%. Salaries will increase for the budget period by $20,000. Other cost increases include $500 to contribution, $5,000 to rent, $15,000 to auto and truck insurance, and $31,000 to other fixed cost. Suppose three profit centers are identified by Kiewit's management - new work (NW), service (S), and over- counter sales (OCS). An analysis of past history reveals that a ratio of earnings among profit centers is relatively constant. Here are the allocation bases that Kiewit decides to use for the different accounts of operating expense: Auto and Truck, Depreciation (Auto and Truck), Insurance (Auto and Truck), Interest (Auto and Truck) will need to use the truck number to allocate the expense. And there were five trucks used by new work (NW), fourteen trucks used by service (S), and six trucks used by over- counter sales (OCS). Insurance (Work-in-progress) and Interest (Work-in-progress) should use the total direct cost as the allocation base. Contributions should use the direct labor as the allocation base. Other Variable Expense, Communications, Depreciation (Building), Rent, Salaries, and Other Fixed Expense should use default base as the allocation base. Table 1 below shows income statements for the company and for each profit center in the previous year. Other Fixed Expense should use default base as the allocation base. Table 1 below shows income statements for the company and for each profit center in the previous year. Table 1 Previous year's income statements of company and three profit centers NW S OCS Account Company $ 8,300,00 0 % 100.0 0 $ 6,225,00 0 % 100.0 0 $ 830,00 0 % 100.0 0 $ 1,245,00 0 % 100.0 0 Earnings (revenue) Cost of Construction Labor 1,162,000 14.00 641,424 10.30 520,576 62.72 0 0.00 Material 3,071,000 37.00 2,011,505 32.31 0 0.00 1,059,495 85.10 Subcontracts 2,822,000 34.00 2,822,000 45.33 0 0.00 0 0.00 Other Direct Cost (JOH) 2.00 2.67 0.00 0.00 166,000 7,221,00 0 1,079,00 0 166,000 5,640,92 9 Total Direct Cost 0 1,059,49 5 87.00 0 520,57 6 309,42 4 90.62 62.72 85.10 13.00 584,071 9.38 37.28 185,505 14.90 Gross Profit Operating Expense Variable Operating Expense Auto and Truck 103,750 1.25 0.33 58,100 24,900 2.00 20,750 59,138 Communications 78,850 0.95 0.95 7,885 11,828 0.95 103,750 1.25 1.30 7,480 15,223 1.22 81,048 158,854 2.45 2.55 14,660 29,836 2.40 203,350 29,050 518,750 0.35 21,788 0.35 2,905 4,358 0.35 6.25 341,577 5.49 91,029 86,144 6.92 Insurance (Work-in-progress) Interest (Work-in-progress) Other Variable Expense Total Variable Expense Fixed Operating Expense Contributions Depreciation (Auto and Truck) Depreciation (Building) Insurance Auto and Truck) Interest (Auto and Truck) 3,200 0.04 1,766 0.03 1,434 0 0.00 45,000 0.54 9,000 0.14 25,200 10,800 0.87 4,200 0.05 3,150 0.05 420 630 0.05 21,000 0.25 4,200 0.07 11,760 5,040 0.40 20,000 0.24 4,000 0.06 11,200 4,800 0.39 Rent 33,000 0.40 24,750 0.40 3,300 4,950 0.40 Salaries 3.98 247,500 3.98 33,000 49,500 3.98 330,000 12,000 468,400 0.14 9,000 0.14 1,200 1,800 Other Fixed Expense Total Fixed Expense 0.14 5.64 303,366 4.87 77,520 6.23 Total Operating Expense 987,150 11.89 644,943 10.36 87,514 178,54 3 130,88 1 163,664 13.15 1.11 -60,872 -0.98 21,841 1.75 Net Profit (before tax) Tax (28%) 91,850 25,718 0.31 Net Profit (after tax) 66,132 0.80 Table 2. Budgets of company and profit centers NW S OCS Company $ % $ % $ % $ % Account Earnings (revenue) Cost of Construction Labor Material Subcontracts Other Direct Cost (JOH) Total Direct Cost Gross Profit Operating Expense Variable Operating Expense Auto and Truck Communications Insurance (Work-in-progress) Interest (Work-in-progress) Other Variable Expense Total Variable Expense Fixed Operating Expense Contributions Depreciation (Auto and Truck) Depreciation (Building) Insurance (Auto and Truck) Interest (Auto and Truck) Rent Salaries Other Fixed Expense Total Fixed Expense Total Operating Expense Net Profit (before tax) Tax (28%) Net Profit (after tax) 1. Forecast the cost structure of the Kiewit company for the budget period, with the actual income statement in previous year and the case data above. (5 points) (Hint: Check Budgeting Example of Study Guide 5 in the textbook between Pages 126-127) 2. Calculate the earning required to generate net profit after tax of $113,472 with the cost structure found in Problem #1. (5 points) 3. Complete the column of company budget in Table 2. (6 points) 4. Prepare a budget for each profit center and fill the rest of Table 2. (12 points) (Hint: Check PREPARING THE BUDGET FOR PROFIT CENTERS of Study Guide 5 in the textbook between Pages 127-129) Kiewit does not expect to change the mode of the operation for the next year. However, subcontract costs will decrease and the expected decrease in relationship to revenue is 1%. Salaries will increase for the budget period by $20,000. Other cost increases include $500 to contribution, $5,000 to rent, $15,000 to auto and truck insurance, and $31,000 to other fixed cost. Suppose three profit centers are identified by Kiewit's management - new work (NW), service (S), and over- counter sales (OCS). An analysis of past history reveals that a ratio of earnings among profit centers is relatively constant. Here are the allocation bases that Kiewit decides to use for the different accounts of operating expense: Auto and Truck, Depreciation (Auto and Truck), Insurance (Auto and Truck), Interest (Auto and Truck) will need to use the truck number to allocate the expense. And there were five trucks used by new work (NW), fourteen trucks used by service (S), and six trucks used by over- counter sales (OCS). Insurance (Work-in-progress) and Interest (Work-in-progress) should use the total direct cost as the allocation base. Contributions should use the direct labor as the allocation base. Other Variable Expense, Communications, Depreciation (Building), Rent, Salaries, and Other Fixed Expense should use default base as the allocation base. Table 1 below shows income statements for the company and for each profit center in the previous year. Other Fixed Expense should use default base as the allocation base. Table 1 below shows income statements for the company and for each profit center in the previous year. Table 1 Previous year's income statements of company and three profit centers NW S OCS Account Company $ 8,300,00 0 % 100.0 0 $ 6,225,00 0 % 100.0 0 $ 830,00 0 % 100.0 0 $ 1,245,00 0 % 100.0 0 Earnings (revenue) Cost of Construction Labor 1,162,000 14.00 641,424 10.30 520,576 62.72 0 0.00 Material 3,071,000 37.00 2,011,505 32.31 0 0.00 1,059,495 85.10 Subcontracts 2,822,000 34.00 2,822,000 45.33 0 0.00 0 0.00 Other Direct Cost (JOH) 2.00 2.67 0.00 0.00 166,000 7,221,00 0 1,079,00 0 166,000 5,640,92 9 Total Direct Cost 0 1,059,49 5 87.00 0 520,57 6 309,42 4 90.62 62.72 85.10 13.00 584,071 9.38 37.28 185,505 14.90 Gross Profit Operating Expense Variable Operating Expense Auto and Truck 103,750 1.25 0.33 58,100 24,900 2.00 20,750 59,138 Communications 78,850 0.95 0.95 7,885 11,828 0.95 103,750 1.25 1.30 7,480 15,223 1.22 81,048 158,854 2.45 2.55 14,660 29,836 2.40 203,350 29,050 518,750 0.35 21,788 0.35 2,905 4,358 0.35 6.25 341,577 5.49 91,029 86,144 6.92 Insurance (Work-in-progress) Interest (Work-in-progress) Other Variable Expense Total Variable Expense Fixed Operating Expense Contributions Depreciation (Auto and Truck) Depreciation (Building) Insurance Auto and Truck) Interest (Auto and Truck) 3,200 0.04 1,766 0.03 1,434 0 0.00 45,000 0.54 9,000 0.14 25,200 10,800 0.87 4,200 0.05 3,150 0.05 420 630 0.05 21,000 0.25 4,200 0.07 11,760 5,040 0.40 20,000 0.24 4,000 0.06 11,200 4,800 0.39 Rent 33,000 0.40 24,750 0.40 3,300 4,950 0.40 Salaries 3.98 247,500 3.98 33,000 49,500 3.98 330,000 12,000 468,400 0.14 9,000 0.14 1,200 1,800 Other Fixed Expense Total Fixed Expense 0.14 5.64 303,366 4.87 77,520 6.23 Total Operating Expense 987,150 11.89 644,943 10.36 87,514 178,54 3 130,88 1 163,664 13.15 1.11 -60,872 -0.98 21,841 1.75 Net Profit (before tax) Tax (28%) 91,850 25,718 0.31 Net Profit (after tax) 66,132 0.80 Table 2. Budgets of company and profit centers NW S OCS Company $ % $ % $ % $ % Account Earnings (revenue) Cost of Construction Labor Material Subcontracts Other Direct Cost (JOH) Total Direct Cost Gross Profit Operating Expense Variable Operating Expense Auto and Truck Communications Insurance (Work-in-progress) Interest (Work-in-progress) Other Variable Expense Total Variable Expense Fixed Operating Expense Contributions Depreciation (Auto and Truck) Depreciation (Building) Insurance (Auto and Truck) Interest (Auto and Truck) Rent Salaries Other Fixed Expense Total Fixed Expense Total Operating Expense Net Profit (before tax) Tax (28%) Net Profit (after tax) 1. Forecast the cost structure of the Kiewit company for the budget period, with the actual income statement in previous year and the case data above. (5 points) (Hint: Check Budgeting Example of Study Guide 5 in the textbook between Pages 126-127) 2. Calculate the earning required to generate net profit after tax of $113,472 with the cost structure found in Problem #1. (5 points) 3. Complete the column of company budget in Table 2. (6 points) 4. Prepare a budget for each profit center and fill the rest of Table 2. (12 points) (Hint: Check PREPARING THE BUDGET FOR PROFIT CENTERS of Study Guide 5 in the textbook between Pages 127-129)