PRODUCT PER COUNTRY
14000 Date
12000 2016
10000
2016
8000
JAN FEB
6000
4000
2000
0
Fruit Fruit Vegetables Vegetables Vegetables Fruit Fruit
Apple Banana Beans Broccoli Carrots Mango Orange
Australia Canada France Germany New Zealand United Kingdom United States
Metrics PERCENTAGE OF SALES
Sum of Total Sum of Units 250000
1,029,734 102,594
200000
Australia
13%
26% Canada 150000
9%
France
Germany 100000
Row Labels Sum of Total
14%
United States 267,133 New Zealand
17% 50000
United Kingdom 173,137 United Kingdom
Germany 155,168 6% 15%
United States 0
Grand Total 595,438 Jan Feb
Qtr1
MONTHS
FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Months... Country
TOTAL OF SALES Mar Canada
Apr France
May Germany
Jun New Zeal...
Product
Apple
Banana
Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Beans
Qtr1 Qtr2 Qtr3 Qtr4 Broccoli
Row Labels Sum of Total
Qtr1 256991
Jan 89663
Feb 62762
Mar 104566
Qtr2 304413
Apr 49474
May 203339
Jun 51600
Qtr3 252162
Jul 80735
Aug 68994
Sep 102433
Qtr4 216168
Oct 52615
Nov 73740
Dec 89813
Grand Total 1029734
Row Labels Sum of Total
Australia 131,713
Canada 94,745
France 141,056
Germany 155,168
New Zealand 66,782
United Kingdom 173,137
United States 267,133
Grand Total 1,029,734
Sum of Units Column Labels
Row Labels Australia Canada France Germany New Zealand
Apple 1474.91065 1777.483917 5732.165833 649.1779843 738.5275197
Fruit 1474.91065 1777.483917 5732.165833 649.1779843 738.5275197
Banana 7029.466667 4503.333333 4812.533333 5291.466667 5340
Fruit 7029.466667 4503.333333 4812.533333 5291.466667 5340
Beans 2220.461538 104.6153846 4600.769231
Vegetables 2220.461538 104.6153846 4600.769231
Broccoli 1497.331109 1034.778982 445.4545455 3102.335279 366.1384487
Vegetables 1497.331109 1034.778982 445.4545455 3102.335279 366.1384487
Carrots 775.6937799 871.1961722 2070.430622
Vegetables 775.6937799 871.1961722 2070.430622
Mango 158.4066218 64.95947577 127.4012761 151.319193
Fruit 158.4066218 64.95947577 127.4012761 151.319193
Orange 728.7993283 1673.299748 189.4206549 746.1796809 1008.396306
Fruit 728.7993283 1673.299748 189.4206549 746.1796809 1008.396306
Grand Total 13885.06969 9053.855457 12282.7872 16611.67866 7453.062274
United Kingdom United States Grand Total
1253.323803 2045.389564 13670.97927
1253.323803 2045.389564 13670.97927
5721.066667 12674.8 45372.66667
5721.066667 12674.8 45372.66667
784.6153846 1102 8812.461538
784.6153846 1102 8812.461538
3205.671393 2228.106756 11879.81651
3205.671393 2228.106756 11879.81651
4001.435407 5386.028708 13104.78469
4001.435407 5386.028708 13104.78469
96.56837386 385.6354544 984.2903949
96.56837386 385.6354544 984.2903949
1825.692695 2597.145256 8768.933669
1825.692695 2597.145256 8768.933669
16888.37372 26419.10574 102593.9327
Date Country Product Category Units Unit Cost/box Total
6/1/2016 United States Carrots Vegetables 409 $10.45 $4,270.00
7/1/2016 United Kingdom Broccoli Vegetables 687 $11.99 $8,239.00
8/1/2016 United States Banana Fruit 82 $7.50 $617.00
10/1/2016 Canada Banana Fruit 1118 $7.50 $8,384.00
10/1/2016 Germany Beans Vegetables 404 $6.50 $2,626.00
11/1/2016 United States Orange Fruit 303 $11.91 $3,610.00
11/1/2016 Australia Broccoli Vegetables 756 $11.99 $9,062.00
16/1/2016 New Zealand Banana Fruit 921 $7.50 $6,906.00
16/1/2016 France Apple Fruit 173 $13.99 $2,417.00
16/1/2016 Canada Apple Fruit 531 $13.99 $7,431.00
16/1/2016 Germany Banana Fruit 1100 $7.50 $8,250.00
18/1/2016 United States Broccoli Vegetables 585 $11.99 $7,012.00
20/1/2016 Germany Carrots Vegetables 182 $10.45 $1,903.00
22/1/2016 Canada Broccoli Vegetables 236 $11.99 $2,824.00
24/1/2016 France Apple Fruit 496 $13.99 $6,946.00
27/1/2016 United Kingdom Banana Fruit 309 $7.50 $2,320.00
28/1/2016 United States Banana Fruit 282 $7.50 $2,116.00
30/1/2016 United Kingdom Banana Fruit 151 $7.50 $1,135.00
30/1/2016 United Kingdom Broccoli Vegetables 300 $11.99 $3,595.00
2/2/2016 United States Apple Fruit 83 $13.99 $1,161.00
4/2/2016 France Orange Fruit 189 $11.91 $2,256.00
11/2/2016 New Zealand Banana Fruit 134 $7.50 $1,004.00
14/2/2016 Canada Banana Fruit 486 $7.50 $3,642.00
17/2/2016 United States Banana Fruit 611 $7.50 $4,582.00
17/2/2016 United Kingdom Beans Vegetables 548 $6.50 $3,559.00
17/2/2016 Australia Carrots Vegetables 493 $10.45 $5,154.00
18/2/2016 France Mango Fruit 127 $57.99 $7,388.00
18/2/2016 United States Beans Vegetables 1102 $6.50 $7,163.00
20/2/2016 Germany Beans Vegetables 785 $6.50 $5,101.00
21/2/2016 France Apple Fruit 543 $13.99 $7,602.00
22/2/2016 United States Mango Fruit 28 $57.99 $1,641.00
23/2/2016 Australia Apple Fruit 636 $13.99 $8,892.00
29/2/2016 France Apple Fruit 147 $13.99 $2,060.00
29/2/2016 Germany Broccoli Vegetables 130 $11.99 $1,557.00
1/3/2016 France Apple Fruit 465 $13.99 $6,509.00
4/3/2016 Australia Apple Fruit 409 $13.99 $5,718.00
5/3/2016 United States Apple Fruit 547 $13.99 $7,655.00
5/3/2016 United Kingdom Carrots Vegetables 872 $10.45 $9,116.00
15/3/2016 United States Banana Fruit 373 $7.50 $2,795.00
15/3/2016 United States Banana Fruit 678 $7.50 $5,084.00
15/3/2016 United Kingdom Carrots Vegetables 856 $10.45 $8,941.00
16/3/2016 France Broccoli Vegetables 445 $11.99 $5,341.00
19/3/2016 Canada Banana Fruit 18 $7.50 $135.00
19/3/2016 Australia Banana Fruit 1253 $7.50 $9,400.00
21/3/2016 Germany Beans Vegetables 930 $6.50 $6,045.00
22/3/2016 New Zealand Apple Fruit 416 $13.99 $5,820.00
23/3/2016 Germany Orange Fruit 746 $11.91 $8,887.00
24/3/2016 United States Orange Fruit 586 $11.91 $6,982.00
26/3/2016 Australia Banana Fruit 537 $7.50 $4,029.00
26/3/2016 Germany Carrots Vegetables 351 $10.45 $3,665.00
29/3/2016 France Banana Fruit 637 $7.50 $4,781.00
30/3/2016 Australia Mango Fruit 63 $57.99 $3,663.00
1/4/2016 France Apple Fruit 453 $13.99 $6,331.00
1/4/2016 Canada Apple Fruit 312 $13.99 $4,364.00
3/4/2016 United Kingdom Carrots Vegetables 58 $10.45 $607.00
6/4/2016 New Zealand Banana Fruit 141 $7.50 $1,054.00
6/4/2016 United States Carrots Vegetables 733 $10.45 $7,659.00
12/4/2016 Germany Broccoli Vegetables 23 $11.99 $277.00
17/4/2016 United States Banana Fruit 31 $7.50 $235.00
18/4/2016 Australia Orange Fruit 93 $11.91 $1,113.00
21/4/2016 United States Apple Fruit 81 $13.99 $1,128.00
22/4/2016 Canada Broccoli Vegetables 770 $11.99 $9,231.00
23/4/2016 United States Banana Fruit 585 $7.50 $4,387.00
25/4/2016 Canada Apple Fruit 197 $13.99 $2,763.00
27/4/2016 United Kingdom Banana Fruit 1053 $7.50 $7,898.00
30/4/2016 France Banana Fruit 324 $7.50 $2,427.00
1/5/2016 New Zealand Banana Fruit 1155 $7.50 $8,663.00
1/5/2016 Germany Carrots Vegetables 267 $10.45 $2,789.00
2/5/2016 United States Banana Fruit 541 $7.50 $4,054.00
2/5/2016 United States Mango Fruit 39 $57.99 $2,262.00
2/5/2016 United Kingdom Mango Fruit 97 $57.99 $5,600.00
3/5/2016 United States Banana Fruit 772 $7.50 $5,787.00
3/5/2016 Canada Orange Fruit 529 $11.91 $6,295.00
5/5/2016 Germany Banana Fruit 63 $7.50 $474.00
5/5/2016 France Apple Fruit 309 $13.99 $4,325.00
6/5/2016 United States Banana Fruit 79 $7.50 $592.00
8/5/2016 United States Orange Fruit 364 $11.91 $4,330.00
8/5/2016 United Kingdom Banana Fruit 1254 $7.50 $9,405.00
8/5/2016 France Apple Fruit 548 $13.99 $7,671.00
8/5/2016 United Kingdom Carrots Vegetables 554 $10.45 $5,791.00
12/5/2016 Canada Banana Fruit 801 $7.50 $6,007.00
14/5/2016 Germany Banana Fruit 671 $7.50 $5,030.00
14/5/2016 United Kingdom Carrots Vegetables 647 $10.45 $6,763.00
15/5/2016 Australia Banana Fruit 566 $7.50 $4,248.00
16/5/2016 France Banana Fruit 1272 $7.50 $9,543.00
16/5/2016 United Kingdom Broccoli Vegetables 171 $11.99 $2,054.00
16/5/2016 Germany Beans Vegetables 1091 $6.50 $7,094.00
18/5/2016 United States Carrots Vegetables 582 $10.45 $6,087.00
19/5/2016 Australia Apple Fruit 305 $13.99 $4,264.00
20/5/2016 United States Mango Fruit 161 $57.99 $9,333.00
22/5/2016 Germany Mango Fruit 151 $57.99 $8,775.00
23/5/2016 United Kingdom Broccoli Vegetables 168 $11.99 $2,011.00
25/5/2016 United States Banana Fruit 751 $7.50 $5,632.00
25/5/2016 New Zealand Banana Fruit 654 $7.50 $4,904.00
25/5/2016 Australia Beans Vegetables 154 $6.50 $1,002.00
26/5/2016 United Kingdom Orange Fruit 684 $11.91 $8,141.00
26/5/2016 Canada Orange Fruit 306 $11.91 $3,644.00
26/5/2016 Australia Orange Fruit 116 $11.91 $1,380.00
26/5/2016 Germany Broccoli Vegetables 697 $11.99 $8,354.00
27/5/2016 United States Banana Fruit 691 $7.50 $5,182.00
27/5/2016 France Apple Fruit 157 $13.99 $2,193.00
28/5/2016 United States Mango Fruit 63 $57.99 $3,647.00
28/5/2016 United States Apple Fruit 293 $13.99 $4,104.00
28/5/2016 United States Carrots Vegetables 714 $10.45 $7,457.00
29/5/2016 Canada Mango Fruit 65 $57.99 $3,767.00
30/5/2016 Germany Broccoli Vegetables 391 $11.99 $4,685.00
4/6/2016 United States Banana Fruit 522 $7.50 $3,917.00
4/6/2016 Canada Apple Fruit 37 $13.99 $521.00
10/6/2016 France Apple Fruit 401 $13.99 $5,605.00
11/6/2016 Germany Broccoli Vegetables 803 $11.99 $9,630.00
20/6/2016 Canada Banana Fruit 925 $7.50 $6,941.00
20/6/2016 United Kingdom Broccoli Vegetables 603 $11.99 $7,231.00
23/6/2016 Australia Broccoli Vegetables 742 $11.99 $8,891.00
25/6/2016 France Banana Fruit 14 $7.50 $107.00
26/6/2016 United States Banana Fruit 566 $7.50 $4,243.00
27/6/2016 United States Orange Fruit 379 $11.91 $4,514.00
2/7/2016 United States Mango Fruit 94 $57.99 $5,480.00
2/7/2016 France Banana Fruit 667 $7.50 $5,002.00
5/7/2016 Canada Banana Fruit 1137 $7.50 $8,530.00
7/7/2016 New Zealand Orange Fruit 405 $11.91 $4,819.00
11/7/2016 United Kingdom Broccoli Vegetables 529 $11.99 $6,343.00
13/7/2016 United Kingdom Orange Fruit 195 $11.91 $2,318.00
20/7/2016 United Kingdom Orange Fruit 18 $11.91 $220.00
20/7/2016 New Zealand Orange Fruit 532 $11.91 $6,341.00
20/7/2016 Germany Apple Fruit 24 $13.99 $330.00
20/7/2016 United Kingdom Broccoli Vegetables 252 $11.99 $3,027.00
22/7/2016 New Zealand Orange Fruit 71 $11.91 $850.00
23/7/2016 United Kingdom Banana Fruit 1198 $7.50 $8,986.00
25/7/2016 United States Broccoli Vegetables 317 $11.99 $3,800.00
28/7/2016 United Kingdom Carrots Vegetables 550 $10.45 $5,751.00
29/7/2016 United Kingdom Apple Fruit 122 $13.99 $1,704.00
30/7/2016 Australia Banana Fruit 1062 $7.50 $7,966.00
31/7/2016 United States Banana Fruit 114 $7.50 $852.00
31/7/2016 Australia Beans Vegetables 1295 $6.50 $8,416.00
1/8/2016 France Banana Fruit 953 $7.50 $7,144.00
1/8/2016 United States Broccoli Vegetables 655 $11.99 $7,854.00
3/8/2016 United States Orange Fruit 72 $11.91 $859.00
12/8/2016 United States Broccoli Vegetables 671 $11.99 $8,049.00
13/8/2016 Germany Banana Fruit 378 $7.50 $2,836.00
19/8/2016 United States Carrots Vegetables 167 $10.45 $1,743.00
23/8/2016 France Apple Fruit 275 $13.99 $3,844.00
24/8/2016 France Apple Fruit 535 $13.99 $7,490.00
25/8/2016 Germany Broccoli Vegetables 374 $11.99 $4,483.00
27/8/2016 Canada Apple Fruit 524 $13.99 $7,333.00
28/8/2016 United States Carrots Vegetables 732 $10.45 $7,654.00
29/8/2016 United Kingdom Apple Fruit 282 $13.99 $3,944.00
29/8/2016 Germany Beans Vegetables 886 $6.50 $5,761.00
1/9/2016 New Zealand Banana Fruit 915 $7.50 $6,864.00
1/9/2016 Germany Banana Fruit 535 $7.50 $4,016.00
2/9/2016 United States Banana Fruit 245 $7.50 $1,841.00
5/9/2016 Australia Banana Fruit 57 $7.50 $424.00
7/9/2016 United Kingdom Banana Fruit 1169 $7.50 $8,765.00
8/9/2016 United States Banana Fruit 744 $7.50 $5,583.00
9/9/2016 New Zealand Broccoli Vegetables 366 $11.99 $4,390.00
9/9/2016 Canada Broccoli Vegetables 29 $11.99 $352.00
11/9/2016 United States Apple Fruit 607 $13.99 $8,489.00
11/9/2016 France Banana Fruit 945 $7.50 $7,090.00
15/9/2016 United States Banana Fruit 1051 $7.50 $7,880.00
18/9/2016 United States Orange Fruit 324 $11.91 $3,861.00
19/9/2016 Germany Broccoli Vegetables 661 $11.99 $7,927.00
20/9/2016 United States Banana Fruit 822 $7.50 $6,162.00
25/9/2016 Australia Mango Fruit 95 $57.99 $5,523.00
25/9/2016 United Kingdom Broccoli Vegetables 495 $11.99 $5,936.00
26/9/2016 Germany Carrots Vegetables 694 $10.45 $7,251.00
27/9/2016 Australia Orange Fruit 519 $11.91 $6,187.00
29/9/2016 Germany Banana Fruit 428 $7.50 $3,210.00
29/9/2016 Germany Carrots Vegetables 65 $10.45 $682.00
3/10/2016 Australia Banana Fruit 106 $7.50 $793.00
4/10/2016 Germany Carrots Vegetables 512 $10.45 $5,346.00
7/10/2016 New Zealand Banana Fruit 947 $7.50 $7,103.00
10/10/2016 United States Carrots Vegetables 440 $10.45 $4,603.00
16/10/2016 France Apple Fruit 583 $13.99 $8,160.00
23/10/2016 United Kingdom Apple Fruit 513 $13.99 $7,171.00
23/10/2016 New Zealand Banana Fruit 474 $7.50 $3,552.00
25/10/2016 Australia Banana Fruit 970 $7.50 $7,273.00
26/10/2016 Germany Banana Fruit 320 $7.50 $2,402.00
26/10/2016 Australia Banana Fruit 160 $7.50 $1,197.00
26/10/2016 Australia Beans Vegetables 772 $6.50 $5,015.00
2/11/2016 United States Orange Fruit 488 $11.91 $5,818.00
3/11/2016 United Kingdom Banana Fruit 587 $7.50 $4,399.00
3/11/2016 United States Carrots Vegetables 288 $10.45 $3,011.00
9/11/2016 United Kingdom Apple Fruit 337 $13.99 $4,715.00
12/11/2016 France Apple Fruit 380 $13.99 $5,321.00
15/11/2016 United States Banana Fruit 1186 $7.50 $8,894.00
25/11/2016 United Kingdom Carrots Vegetables 464 $10.45 $4,846.00
25/11/2016 Germany Broccoli Vegetables 24 $11.99 $284.00
26/11/2016 United Kingdom Orange Fruit 695 $11.91 $8,283.00
28/11/2016 Canada Orange Fruit 839 $11.91 $9,990.00
28/11/2016 Australia Banana Fruit 1202 $7.50 $9,014.00
29/11/2016 France Apple Fruit 139 $13.99 $1,942.00
30/11/2016 United States Banana Fruit 963 $7.50 $7,223.00
2/12/2016 United States Carrots Vegetables 447 $10.45 $4,673.00
4/12/2016 France Carrots Vegetables 871 $10.45 $9,104.00
5/12/2016 United States Apple Fruit 434 $13.99 $6,078.00
6/12/2016 Germany Beans Vegetables 504 $6.50 $3,278.00
12/12/2016 Canada Banana Fruit 18 $7.50 $136.00
12/12/2016 Australia Banana Fruit 1117 $7.50 $8,377.00
12/12/2016 United States Banana Fruit 318 $7.50 $2,382.00
15/12/2016 Germany Banana Fruit 1160 $7.50 $8,702.00
16/12/2016 United States Banana Fruit 669 $7.50 $5,021.00
16/12/2016 Australia Apple Fruit 126 $13.99 $1,760.00
18/12/2016 Germany Banana Fruit 635 $7.50 $4,766.00
19/12/2016 United Kingdom Beans Vegetables 237 $6.50 $1,541.00
20/12/2016 United Kingdom Orange Fruit 234 $11.91 $2,782.00
20/12/2016 Canada Apple Fruit 175 $13.99 $2,455.00
22/12/2016 New Zealand Apple Fruit 323 $13.99 $4,512.00
22/12/2016 Germany Apple Fruit 626 $13.99 $8,752.00
25/12/2016 United States Carrots Vegetables 873 $10.45 $9,127.00
28/12/2016 France Apple Fruit 127 $13.99 $1,777.00
28/12/2016 France Beans Vegetables 105 $6.50 $680.00
29/12/2016 United States Orange Fruit 80 $11.91 $958.00
29/12/2016 Australia Carrots Vegetables 250 $10.45 $2,613.00
30/12/2016 Australia Carrots Vegetables 32 $10.45 $339.00