i just need 3 answers

Urban Design Corporation manufactures a variety of indoor and outdoor furniture. It has several manufacturing facilities located in six different states or provinces. Each manufacturing facility makes its own unique products. The company uses just-in-time inventory management, so it has no significant inventory. Urban Design has five sales representatives who can sell products from any of its manufacturing facilities. All transactions in Urban Design's job cost system for the most recent month have been exported to an Excel file (data file). In this transaction file, revenue amounts are shown as positive numbers while all costs shown as negative numbers General instructions: Create pivot tables (link) in separate worksheets to calculate answers for each of the following requirements. Rename each of the pivot table worksheets (link) from the default names to "Pivot table 1," "Pivot table 2," etc. Format dollar amounts in all pivot tables with the Accounting format, zero decimal places (Windows | Mac). 1. Pivot table \#1 a. What is the total revenue? b. What is the total direct material used? c. What is the total direct labor used? d. What is the total manufacturing overhead applied? e. What is the total gross profit? 2. Pivot table \#2 a. What is the total revenue, total direct material, total direct labor, total manufacturing overhead, and total gross profit i. for each country? ii. for each state or province? b. Which manufacturing facility has the most gross profit? Which has the least? c. Which country's manufacturing facilities generate the most gross profit? 3. Pivot table \#3 d. What is the total manufacturing overhead applied? e. What is the total gross profit? 2. Pivot table \#2 a. What is the total revenue, total direct material, total direct labor, total manufacturing overhead, and total gross profit i. for each country? ii. for each state or province? b. Which manufacturing facility has the most gross profit? Which has the least? c. Which country's manufacturing facilities generate the most gross profit? 3. Pivot table \#3 a. What is the revenue generated by each job? b. What are the totals of direct material, direct labor, and manufacturing overhead costs for each job? c. What is the gross profit generated by each job? d. 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 a. What is the revenue generated by each sales rep? b. Which sales rep generates the most revenue? Which generates the least? c. 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 I Mac). d. 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). PivotTable1:PivotTable2:PivotTable3:PivotTable4:CellB7:CellE7:CellF936(aftersorting):CellG5:$442,240$35,444$3,569$1,156,686 Using your Excel worksheet, what is the United States total direct labor for Urban Design Furniture? A. $91,398 B. $258,133 C. $3,410,639 D. $1,219,899 Using your Excel worksheet, what is British Columbia's total revenue for Urban Design Furniture? A. $780,221 B. $376.465 C. $178,338 D. $536,318 Using your Excel worksheet, which sales rep generated the most revenue for Urban Design Fumiture? A. Bella Singh B. Anne Chen C. Martha LeBlanc D. Wayne DeJong Using your Excel worksheet, how much of Bella Singh's revenue was generated from Canada for Urban Design Furnture? A. 51,178,025 B. $879,872 C. $930,806 D. $247,219 Urban Design Corporation manufactures a variety of indoor and outdoor furniture. It has several manufacturing facilities located in six different states or provinces. Each manufacturing facility makes its own unique products. The company uses just-in-time inventory management, so it has no significant inventory. Urban Design has five sales representatives who can sell products from any of its manufacturing facilities. All transactions in Urban Design's job cost system for the most recent month have been exported to an Excel file (data file). In this transaction file, revenue amounts are shown as positive numbers while all costs shown as negative numbers General instructions: Create pivot tables (link) in separate worksheets to calculate answers for each of the following requirements. Rename each of the pivot table worksheets (link) from the default names to "Pivot table 1," "Pivot table 2," etc. Format dollar amounts in all pivot tables with the Accounting format, zero decimal places (Windows | Mac). 1. Pivot table \#1 a. What is the total revenue? b. What is the total direct material used? c. What is the total direct labor used? d. What is the total manufacturing overhead applied? e. What is the total gross profit? 2. Pivot table \#2 a. What is the total revenue, total direct material, total direct labor, total manufacturing overhead, and total gross profit i. for each country? ii. for each state or province? b. Which manufacturing facility has the most gross profit? Which has the least? c. Which country's manufacturing facilities generate the most gross profit? 3. Pivot table \#3 d. What is the total manufacturing overhead applied? e. What is the total gross profit? 2. Pivot table \#2 a. What is the total revenue, total direct material, total direct labor, total manufacturing overhead, and total gross profit i. for each country? ii. for each state or province? b. Which manufacturing facility has the most gross profit? Which has the least? c. Which country's manufacturing facilities generate the most gross profit? 3. Pivot table \#3 a. What is the revenue generated by each job? b. What are the totals of direct material, direct labor, and manufacturing overhead costs for each job? c. What is the gross profit generated by each job? d. 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 a. What is the revenue generated by each sales rep? b. Which sales rep generates the most revenue? Which generates the least? c. 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 I Mac). d. 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). PivotTable1:PivotTable2:PivotTable3:PivotTable4:CellB7:CellE7:CellF936(aftersorting):CellG5:$442,240$35,444$3,569$1,156,686 Using your Excel worksheet, what is the United States total direct labor for Urban Design Furniture? A. $91,398 B. $258,133 C. $3,410,639 D. $1,219,899 Using your Excel worksheet, what is British Columbia's total revenue for Urban Design Furniture? A. $780,221 B. $376.465 C. $178,338 D. $536,318 Using your Excel worksheet, which sales rep generated the most revenue for Urban Design Fumiture? A. Bella Singh B. Anne Chen C. Martha LeBlanc D. Wayne DeJong Using your Excel worksheet, how much of Bella Singh's revenue was generated from Canada for Urban Design Furnture? A. 51,178,025 B. $879,872 C. $930,806 D. $247,219