Please fill in the yelllow and green cells.

SUMMARY from Part 1 Direct material Direct labor Collection Facility Overhead Division Overhead Cost per Bin Total bins processed Production Mix Overhead Allocation Base = Output Collection Facility Total Overhead Collection Facility Overhead Allocation Division Overhead Total Division Overhead Students Enter Formulas HERE in yellow cells YEAR 5 SUMMARY R 6 SUMMARY 4,181,299.20 $ 15,347,299.20 127.89 Year 5 $ 4,355,520.00 200,000.00 174,220.80 164,000.00 1,753,220.80 1,215,000.00 3,669,907.50 3,266,217.68 $ 12,414,172.22 137.94 $ 611,604.00 $ 710,452.95 $ 544,327.56 $6,118,884.51 Summary of Costs using Output as Overhead Allocation Base YEAR 5 SUMMARY Year 6 $ 3,810,545.00 R 6 SUMMARY Direct material Direct labor Collection Facility Overhead Division Overhead Cost per Bin GREEN CELLS: Students use a formula to $ 1,215,000.00 $ 3,669,907.50 200,000.00 your calculations $ 611,604.00 $4,864,104.00 so that this area automatically brings in the NEW totals from your calculations