OLAP EXCEL

Acct # Account Description Jan Feb March April May June

Employee Costs

110 Payroll 27,540 27,540 28,547 27,540 28,547 29,750

120 IRS/FICA/Wk comp/State/SDI 7,435 7,435 7,707 7,435 7,707 8,032

130 Commissions 1,234 9,825 8,875 9,825 8,875 9,520

140 Retirement Plan 3,570 3,304 3,425 3,304 3,425 3,570

150 Insurance 2,345 1,500 1,500 1,500 1,500 1,500

Subcontractors & Services

201 Telecommunication Services 436 436 436 436 436 436

202 Design Consultants 375 0 375 0 375 500

203 Photo/Video Services 45 45 325 45 325 45

250 Graphic Services 856 375 95 375 95 765

251 Photo/Stats 150 0 755 0 755 568

252 Typesetting 55 195 325 195 325 388

253 Printing Services 2,368 325 849 325 849 951

254 Legal & Accounting 130 130 130 130 130 130

Supplies and Materials

301 Office Supplies 215 433 732 433 732 500

302 Office Postage 255 325 255 325 255 45

303 Office Equipment & Furniture 0 21 78 21 78 765

304 Miscellaneous Supplies 71 36 49 36 49 568

Facilities Overhead

405 Plant 1,700 1,700 1,700 1,700 1,700 1,700

410 Office Rental 1,200 1,200 1,200 1,200 1,200 1,200

415 Lab 300 300 300 300 300 300

Jan Feb Mar Qtr 1 Apr May Jun Qtr 2 Jul Aug Sep Qtr 3 Oct Nov Dec Qtr 4 Annual Totals

Compact 31,735 11,566 71,639 114,940 44,132 16,276 65,668 126,076 68,912 52,657 28,477 150,046 58,322 40,165 42,579 141,066 532,128

Midsize 63,074 20,519 12,828 96,421 83,793 16,039 52,379 152,211 29,592 33,388 72,458 135,438 55,347 49,468 58,498 163,313 547,383

Full-size 45,696 77,739 76,476 199,911 22,164 67,842 88,076 178,082 12,602 33,981 43,565 90,148 53,656 62,618 53,618 169,892 638,033

Total Cars 140,505 109,824 160,943 411,272 150,089 100,157 206,123 456,369 111,106 120,026 144,500 375,632 167,325 152,251 154,695 474,271 1,717,544

Minivans 90,196 85,310 24,513 200,019 27,491 70,941 29,808 128,240 60,486 41,903 97,986 200,375 47,878 78,494 55,587 181,959 710,593

Full vans 80,260 18,206 66,115 164,581 62,070 46,504 16,572 125,146 56,350 71,081 21,560 148,991 55,063 71,704 59,976 186,743 625,461

Pickups 63,075 82,701 51,812 197,588 77,758 60,902 29,935 168,595 77,621 43,472 86,897 207,990 19,076 47,278 89,060 155,414 729,587

Total Trucks 233,531 186,217 142,440 562,188 167,319 178,347 76,315 421,981 194,457 156,456 206,443 557,356 122,017 197,476 204,623 524,116 2,065,641

Total Sales 374,036 296,041 303,383 973,460 317,408 278,504 282,438 878,350 305,563 276,482 350,943 932,988 289,342 349,727 359,318 998,387 3,783,185