(Solution Download) ABC ALLOCATION PROJECT For the allocation project the student is to create a company (with 4...

ABC ALLOCATION PROJECT For the allocation project the student is to create a company (with 4 products). This company needs to have at least 10 departments and 10 projects (Like the example below). There needs to be a budget for this company. With this information the student is to do a Traditional Overhead allocation and an Activity Based Costing (ABC) Overhead allocation. This portion of the assignment needs to be done on Excel. With no less than 1 page describes the difference between the 2 allocations. This portion of the assignment needs to be completed on Word. Traditional Methodology Chairs Tables Podiums Stools Department Budget 10% 30% 15% 45% 1 HR $1,000,000.00 2 Accounting $500,000.00 3 Marketing $500,000.00 4 Executive $1,000,000.00 5 Janitorial $300,000.00 6 Sales $200,000.00 7 Packing $200,000.00 8 Shipping $100,000.00 9 Design $150,000.00 10 Technology $300,000.00 Total $4,250,000.00 $425,000.00 $1,275,000.00 $637,500.00 $1,912,500.00