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