Advanced Auditing Homework

profilebwkincsiv
wk8onthegoexhibitsforwk9_1.xls
Home>Business & Finance homework help>Accounting homework help>Advanced Auditing Homework

Exhibit1

Exhibit 1
On the Go Stores
Sales and Inventory Comparison - Prior Year to Current Year
All Stores
Average
Prior Year Current Year Dollar Percent Current Year Number
Sales Sales Change Change Inventory Square of Full-Time Qn4 QN5
Store Audited ($) ($) ($) (%) ($) Feet Employees
1* N/A 781,793 781,793 N/A 48,725 2,500 11 4,155,386
2 1,165,221 1,146,438 (18,783) (1.16) 44,171 2,500 11.31 31,564,264
3 1,147,430 1,195,004 47,574 4.15 45,714 2,500 12.46
4* N/A 951,784 951,784 N/A 37,218 4,000 11.86
5 2,037,463 1,981,409 (56,054) (2.75) 45,826 4,000 10.06
6 2,257,920 2,300,671 42,751 1.89 53,862 4,000 11.1
7 1,850,354 1,956,481 106,127 5.73 49,883 4,000 10.71
8 1,916,884 1,799,713 (117,171) (6.11) 47,016 4,000 7.5
9 1,833,209 1,820,641 (12,568) (0.69) 59,726 4,000 14
10* N/A 774,954 774,954 N/A 35,882 2,500 11.2
11 980,484 1,159,004 178,520 18.21 37,664 2,500 11.6
12 1,069,652 1,139,475 69,823 6.53 34,662 2,500 12.7
13* N/A 948,522 948,522 N/A 44,782 4,000 11.86
14 1,795,123 1,984,777 189,654 10.56 38,774 4,000 12.2
15 2,119,015 2,293,847 174,832 8.25 55,423 4,000 11.1
16 1,947,303 1,984,722 37,419 1.92 52,884 4,000 10.4
17 1,705,789 1,798,336 92,547 5.42 46,834 4,000 8.84
18 2,396,971 2,484,503 87,532 3.65 53,772 4,000 12.1
19 1,901,631 1,837,400 (64,231) (3.38) 43,982 4,000 9.7
20 1,514,798 1,609,385 94,587 6.24 44,893 4,000 7.2
21 1,886,587 1,874,229 (12,358) (0.65) 37,665 4,000 10.5
22* N/A 698,333 698,333 N/A 33,826 2,500 10.5
23 1,092,908 1,198,229 105,321 9.66 44,857 2,500 10.9
Total 30,618,742 35,719,650 5,100,908 1,038,041 80,000 250.8 3.09%
                                   
* Store opened during current year.

Exhibit2

Exhibit 2
On the Go Stores
Gross Margin Percentage
Current Year Prior Year
All Stores
Total Sales $31,564,264 $30,618,742
COGS 21,463,700 21,987,932
Gross Margin $10,100,564 $8,630,810
Gross Margin % 31.99% 28.19%
Current Year Prior Year
Sells Gasoline
Total Sales $23,905,477 $23,329,838
COGS 16,112,291 16,307,557
Gross Margin $7,793,186 $7,022,281
Gross Margin % 32.60% 30.10%
Current Year Prior Year
Doesn't Sell Gasoline
Total Sales $7,658,787 $7,288,904
COGS 5,351,409 5,680,375
Gross Margin $2,307,378 $1,608,529
Gross Margin % 30.10% 22.10%

Exhibit3

Exhibit 3
On the Go Stores
Sales per Square Foot
Current Year Sales Avg. Sales per Dollar Percent
Sales Square per Sq. Ft. Sq. Ft. per Difference Difference
Store ($) Feet ($) NACS ($) (%)
1 * 781,793 2,500 313 490 177 36.12%
2 1,146,438 2,500 459 490 31 6.33%
3 1,195,004 2,500 478 490 12 2.45%
4 * 951,784 4,000 238 490 252 51.43%
5 1,981,409 4,000 495 490 (5) (1.02%)
6 2,300,671 4,000 575 490 (85) (17.35%)
7 1,956,481 4,000 489 490 1 0.20%
8 1,799,713 4,000 450 490 40 8.16%
9 1,820,641 4,000 455 490 35 7.14%
10 * 774,954 2,500 310 490 180 36.73%
11 1,159,004 2,500 464 490 26 5.31%
12 1,139,475 2,500 456 490 34 6.94%
13 * 948,522 4,000 237 490 253 51.63%
14 1,984,777 4,000 496 490 (6) (1.22%)
15 2,293,847 4,000 573 490 (83) (16.94%)
16 1,984,722 4,000 496 490 (6) (1.22%)
17 1,798,336 4,000 450 490 40 8.16%
18 2,484,503 4,000 621 490 (131) (26.73%)
19 1,837,400 4,000 459 490 31 6.33%
20 1,609,385 4,000 402 490 88 17.96%
21 1,874,229 4,000 469 490 21 4.29%
22 * 698,333 2,500 279 490 211 43.06%
23 1,198,229 2,500 479 490 11 2.24%
Total 35,719,650 80,000 10,144 11,270 1,127 10
                                   
* Store opened during current year.

Exhibit4

Exhibit 4
On the Go Stores
Regression Data
(1-4,000 sq.ft.;
Merchandise Full-Time (1-yes, 0-no) (1-yes, 0-no) 0-2,500 sq.ft.)
Store Inventory Employees New Store Sells Gas Size Sales
1 48,725 11 1 0 0 781,793
2 44,171 11.31 0 0 0 1,146,438
3 45,714 12.46 0 0 0 1,195,004
4 37,218 11.86 1 0 1 951,784
5 45,826 10.06 0 1 1 1,981,409
6 53,862 11.1 0 1 1 2,300,671
7 49,883 10.71 0 1 1 1,956,481
8 47,016 7.5 0 1 1 1,799,713
9 59,726 14 0 0 1 1,820,641
10 35,882 11.2 1 0 0 774,954
11 37,664 11.6 0 0 0 1,159,004
12 34,662 12.7 0 0 0 1,139,475
13 44,782 11.86 1 0 1 948,522
14 38,774 12.2 0 1 1 1,984,777
15 55,423 11.1 0 1 1 2,293,847
16 52,884 10.4 0 1 1 1,984,722
17 46,834 8.84 0 1 1 1,798,336
18 53,772 12.1 0 1 1 2,484,503
19 43,982 9.7 0 1 1 1,837,400
20 44,893 7.2 0 1 1 1,609,385
21 37,665 10.5 0 1 1 1,874,229
22 33,826 10.5 1 0 0 698,333
23 44,857 10.9 0 0 0 1,198,229