Dubitsky Canoe Company has several plants located around the United States. The company’s controller has imported its job cost and sales data from the past three years into Excel. The following is a sample of the table of the records in that Excel file. Access the full data set online in the MyLab Accounting exercise.

Using the full data set online, create pivot tables to answer the following questions.

1. What was the total sales revenue for each product group?
2. What was the total sales revenue for each product group by plant?
3. What was the average cost per unit for each canoe model?
4. What was the average cost for each canoe model in each plant?
5. How many units of each model were produced in each plant?
6. What is the average gross profit per unit for each canoe model?
7. What is the average gross profit per unit for each canoe model in each plant?
8. How many jobs were produced in each plant?

Transcribed Image Text:

A Date B с D E Plant Job # Product group Model 1 2 1/14/2019 Cordele 1717 Multi 3 1/20/2019 Eudora 1970 Multi 4 1/25/2019 Kent 5 1/12/2019 Kent 6 1/20/2019 Lincoln 7 1/26/2019 Kent 8 1/21/2019 Eudora 9 1/17/2019 Lincoln 10 1/23/2019 Cordele 2013 River X220 X220 2035 Multi X230 S101 S101 1583 Recreational 1975 Recreational 2040 Recreational S101 1980 Recreational T201 1813 River F340 F340 Units 15 30 20 10 10 50 15 25 30 G DM 750 1,590 1,240 400 400 2,100 735 2,375 2,700 H DL 195 510 300 160 180 650 300 550 630 K M Job cost Cost per unit Sales rev GP per unit 1,335 89 2,250 61 3,120 104 4,500 46 2,140 107 3,500 68 880 88 1,650 77 940 94 1,650 71 4,050 81 8,250 84 1,635 109 3,000 91 1,100 4,025 161 1,260 4,590 153 MOH 390 1,020 600 320 360 1,300 600 5,625 6,750 64 72