What is the total direct labor used? . What is the total manufacturing overhead applied? What is the total gross profit? 2. Pivot table #2 . What is the total revenue, total direct material, total direct labor, total manufacturing overhead, and total gross profit . for each country? . for each state or province? Which manufacturing facility has the most gross profit? Which has the least? . Which country's manufacturing facilities generate the most gross profit? 3. Pivot table #3 What is the revenue generated by each job? . What are the totals of direct material, direct labor, and manufacturing overhead costs for each job? What is the gross profit generated by each job? Which job generated the most gross profit? Which generated the least gross profit? Hint: Sort the pivot table by gross profit (link). 4. Pivot table #4 What is the revenue generated by each sales rep? . Which sales rep generates the most revenue? Which generates the least? How much of each sales rep's revenue is generated from facilities in Canada? From facilities in the United States? Hint: Use a filter in the pivot table (Windows | Mac) How much of each sales rep's revenue is generated by each of the facilities within each country? Hint: Use a filter in the pivot table (Windows | Mac)