Fort Woods curs comment. The common Store.com Sweder, por e comente form. Fontand what we things and to cut Sprched for formand wwwrong the wewe tour stedes verwe The word Themes the whole tower Maintenance Administration Le Yard Miting Brying Packaging 11.00 10 2.70 210 20 . . 81, 30, 42,000 3314 Your next step is to determine the proportional usage of each support department's cost driver by the other departments to which its costs are to be allocated. Complete the following tables. Maintenance Department Hours Worked Usage Percent Administration 8,100 10 % Log Yard 9,720 12 Milling 21,060 Drying 16,200 20 26 Packaging 25,920 32 Totals 81,000 100 Administration of Employees Department Maintenance Log Yard Usage Percent 15 4 10 Milling 10 25 Drying 12 30 Packaging 20 Totals 40 100 % Using the cells below, create the formulas that will simultaneously allocate support department costs among the departments. "M" represents Maintenance and "A represents Administration, 176,000 - 15 A 10 M 216,275 - Solve the equations, tf required round any decimal to three places in your computations. For example, 0183 would be rounded to 018. Round your final answer to the nearest dollar. M Use the following table to allocate the support cost departments. Round allocated amounts to the nearest whole dollar. If an amount is zero, enter "o". Support Departments Production Departments Maintenance Administration Log Yard Milling Drying Packaging Hours worked 11,000 8,100 9,720 21,060 16,200 25,920 Number of employees 12 Department cost 176,000 216,275 309,940 747,000 433,160 224,000 Maintenance 2 Administration o 27,624 27,624 Final department costs 0 10 0 Using the rounded mounts from the support contattocation table previous task, complete the following table to allocate the production department costs to each product int Round allocated amounts to the nearest whole dotat Thousand Weight Weighted Weighted of Final Department Cost Allocation Board Feet Factor Thous, Bd. FL. Board Feet Costs to Product Line Log Yard Hardwood Softwood Total Log Yard Hardwood Softwood Total Ming Drying Hardwood Softwood Total Drying Packaging Hardwood Softwood Total Packaging Forest Land earns revenue of $100,000 from selling its by products, wood shavings and saw dust. Allocate the revenue to each product line in the following table and determine the final cost per product line. Thousand Percentage of By-product Portion of By Board Feet Board Feet Revenue product Revenue Hardwood $100,000 Softwood 100,000 Cost per Product Line Hardwood Softwood Log Yard Miling Drying Packaging Subtotal Portion of By product revenue Total cost per product line Administration 8,100 Log Yard Milling 9,720 21,060 Maintenance 11,000 6 $176,000 Hours worked Number of employees Department costs Drying Packaging 16,200 25,920 12 8 $433,160 $224,000 4 10 $216,275 $309,940 $747,000 Fort Woods curs comment. The common Store.com Sweder, por e comente form. Fontand what we things and to cut Sprched for formand wwwrong the wewe tour stedes verwe The word Themes the whole tower Maintenance Administration Le Yard Miting Brying Packaging 11.00 10 2.70 210 20 . . 81, 30, 42,000 3314 Your next step is to determine the proportional usage of each support department's cost driver by the other departments to which its costs are to be allocated. Complete the following tables. Maintenance Department Hours Worked Usage Percent Administration 8,100 10 % Log Yard 9,720 12 Milling 21,060 Drying 16,200 20 26 Packaging 25,920 32 Totals 81,000 100 Administration of Employees Department Maintenance Log Yard Usage Percent 15 4 10 Milling 10 25 Drying 12 30 Packaging 20 Totals 40 100 % Using the cells below, create the formulas that will simultaneously allocate support department costs among the departments. "M" represents Maintenance and "A represents Administration, 176,000 - 15 A 10 M 216,275 - Solve the equations, tf required round any decimal to three places in your computations. For example, 0183 would be rounded to 018. Round your final answer to the nearest dollar. M Use the following table to allocate the support cost departments. Round allocated amounts to the nearest whole dollar. If an amount is zero, enter "o". Support Departments Production Departments Maintenance Administration Log Yard Milling Drying Packaging Hours worked 11,000 8,100 9,720 21,060 16,200 25,920 Number of employees 12 Department cost 176,000 216,275 309,940 747,000 433,160 224,000 Maintenance 2 Administration o 27,624 27,624 Final department costs 0 10 0 Using the rounded mounts from the support contattocation table previous task, complete the following table to allocate the production department costs to each product int Round allocated amounts to the nearest whole dotat Thousand Weight Weighted Weighted of Final Department Cost Allocation Board Feet Factor Thous, Bd. FL. Board Feet Costs to Product Line Log Yard Hardwood Softwood Total Log Yard Hardwood Softwood Total Ming Drying Hardwood Softwood Total Drying Packaging Hardwood Softwood Total Packaging Forest Land earns revenue of $100,000 from selling its by products, wood shavings and saw dust. Allocate the revenue to each product line in the following table and determine the final cost per product line. Thousand Percentage of By-product Portion of By Board Feet Board Feet Revenue product Revenue Hardwood $100,000 Softwood 100,000 Cost per Product Line Hardwood Softwood Log Yard Miling Drying Packaging Subtotal Portion of By product revenue Total cost per product line Administration 8,100 Log Yard Milling 9,720 21,060 Maintenance 11,000 6 $176,000 Hours worked Number of employees Department costs Drying Packaging 16,200 25,920 12 8 $433,160 $224,000 4 10 $216,275 $309,940 $747,000