CHATEAU AMERICANA
YEAR-END WORKSHEET
31-Dec-03
12-31-2002 12-31-2003
ACCT ACCOUNT POST CLOSING UNADJUSTED ADJUSTMENTS ADJUSTED INCOME BALANCE
NO. TITLE TRIAL BALANCE TRIAL BALANCE TRIAL BALANCE STATEMENT SHEET
DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT
ASSETS
111000 General checking account 2,138,784.99 0.00 0.00
112000 Payroll checking account 28,726.39 0.00 0.00
113000 Money market account 775,549.73 0.00 0.00
114000 Savings account 48,576.82 0.00 0.00
119000 Petty cash 500.00 0.00 0.00
121000 Accounts receivable 4,913,697.13 0.00 0.00
129000 Allowance for bad debts 97,459.89 0.00 0.00
141000 Inventory - production 10,407,164.74 0.00 0.00
145000 Inventory - finished goods 3,902,457.04 0.00 0.00
150000 Prepaid expenses 84,636.54 0.00 0.00
160000 Land and buildings 15,329,765.29 0.00 0.00
170000 Equipment 12,805,599.06 0.00 0.00
180000 Accumulated depreciation 14,096,349.37 0.00 0.00
191000 Investments 2,080,764.31 0.00 0.00
LIABILITIES
210000 Accounts payable 3,682,954.12 0.00 0.00
222100 Federal income tax withheld 64,442.36 0.00 0.00
222200 FICA withheld 12,107.35 0.00 0.00
222300 Medicare withheld 2,831.56 0.00 0.00
223100 FICA payable - employer 12,107.35 0.00 0.00
223200 Medicare payable - employer 2,831.56 0.00 0.00
223300 Unemployment taxes payable 846.39 0.00 0.00
230000 Other accrued expenses 568,998.06 0.00 0.00
235000 Federal income taxes payable 157,448.31 0.00 0.00
236000 Property taxes payable 0.00 0.00 0.00
240000 Mortgages payable 7,442,445.94 0.00 0.00
261000 Notes payable 654,000.00 0.00 0.00
STOCKHOLDERS' EQUITY
310000 Common stock 90,000.00 0.00 0.00
311000 Paid-in capital in excess of par - common 3,567,265.00 0.00 0.00
312000 Dividends - common 0.00 0.00 0.00
390000 Retained earnings 22,064,134.78 0.00 0.00
REVENUE
410000 Sales 0.00 0.00
420000 Sales discounts 0.00 0.00
430000 Sales returns and allowances 0.00 0.00
491000 Dividend income 0.00 0.00
492000 Interest income 0.00 0.00
COST OF GOODS SOLD
510000 Cost of goods sold 0.00 0.00
EXPENSES
601000 Wages and salaries expense 0.00 0.00
601500 Sales commissions expense 0.00 0.00
602100 FICA tax expense 0.00 0.00
602200 Medicare tax expense 0.00 0.00
602300 FUTA expense 0.00 0.00
602400 SUTA expense 0.00 0.00
611000 Utilities expense 0.00 0.00
611300 Irrigation & waste disposal expense 0.00 0.00
612000 Landscaping expense 0.00 0.00
621000 Advertising expense 0.00 0.00
623000 Marketing expense 0.00 0.00
624000 Festivals & competitions expense 0.00 0.00
631000 Telephone expense 0.00 0.00
632000 Internet & computer expense 0.00 0.00
633000 Postage & shipping expense 0.00 0.00
641000 Legal & accounting fees 0.00 0.00
643000 Other consulting fees 0.00 0.00
651000 Office supplies expense 0.00 0.00
660000 Data processing expense 0.00 0.00
670000 Depreciation expense 0.00 0.00
680000 Travel and entertainment expense 0.00 0.00
691000 Other insurance expense 0.00 0.00
692000 Medical insurance 0.00 0.00
693000 Workmen's compensation insurance 0.00 0.00
699000 Other employee benefits expense 0.00 0.00
700000 Dues & subscriptions expense 0.00 0.00
711000 Federal income tax expense 0.00 0.00
712000 Property tax expense 0.00 0.00
721000 Repairs and maintenance 0.00 0.00
731000 Automobile expense 0.00 0.00
740000 Lease expense 0.00 0.00
791000 Bad debt expense 0.00 0.00
792000 Miscellaneous expense 0.00 0.00
793000 Interest expense 0.00 0.00
Sub-totals 0.00 0.00 0.00 0.00
Net Income (Loss) 0.00 0.00
TOTALS 52,516,222.04 52,516,222.04 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Chateau Americana
For the year ended December 31, 2003
Bottles sold in thousand of units
AL GA NC SC
White wines
Sauvignon Blanc 2645 4358 4658 2568
Chardonnay 2478 4251 4257 2355
Riesling 3014 4875 4658 2388
Chenin Blanc 3557 4701 4089 2014
Pinot Gris 3783 4117 4558 2211
15477 22302 22220 11536
Red wines
Cabernet Sauvignon 5689 5887 4875 3254
Merlot 5440 5696 4904 3254
Pinto Noir 5899 5024 5612 3897
Syrah 5336 5147 5120 3999
22364 21754 20511 14404
Sparkling wines
Brut 2214 3254 2564 2654
Blanc de blanc 2356 3022 2457 2548
4570 6276 5021 5202
Total bottles sold 42411 50332 47752 31142
Commissions
Sauvignon Blanc 7935.00 13074.00 13974.00 7704.00
Chardonnay 10531.50 18066.75 18092.25 10008.75
Riesling 6781.50 10968.75 10480.50 5373.00
Chenin Blanc 11560.25 15278.25 13289.25 6545.50
Pinot Gris 13240.50 14409.50 15953.00 7738.50
Cabernet Sauvignon 17920.35 18544.05 15356.25 10250.10
Merlot 20400.00 21360.00 18390.00 #NAME?
Pinto Noir 25070.75 21352.00 23851.00 16562.25
Syrah 24012.00 23161.50 23040.00 17995.50
Brut 11070.00 16270.00 12820.00 13270.00
Blanc de blanc 11191.00 14354.50 11670.75 12103.00
Total Commissions 159712.85 186839.30 176917.00 #NAME?
Average commission per bottle sold
Requirement Responses to Formula Auditing Questions
#2
#4
#5
#7
#8
#9
VA
2214
2277
2456
2557
2080
11584 83119
4879
4545
4655
4050
18129 97162
2014
2214
4228 25297
33941 205578
6642.00
#VALUE!
5526.00
8310.25
7280.00
15368.85
17043.75
19783.75
18225.00
10070.00
10516.50
#VALUE! #NAME?
#NAME?
EARNINGS
EMPLOYEE PAY REGULAR PAY REGULAR OVERTIME
DATE ID EMPLOYEE NAME TYPE HOURS RATE PAY HOURS
NINGS DEDUCTIONS PAYMENT
FICA & SUBS
OVERTIME GROSS PAY MEDICARE FED. INC. TAX NET PAY POST
PAY G/L 40500 G/L 20600 G/L 20300 G/L 10100 CK. NO. REF
ACCT_TYPE ACCT_CODE ACCT_TITLE DEPT COST_CENTER YR MON
601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR 03 Jan
601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR 03 Feb
601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR 03 Mar
601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR 03 Apr
601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR 03 May
601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR 03 Jun
601 - SALARIES 601000 Wages and Salaries MKTG DANIEL 03 Jan
601 - SALARIES 601000 Wages and Salaries MKTG DANIEL 03 Feb
601 - SALARIES 601000 Wages and Salaries MKTG DANIEL 03 Mar
601 - SALARIES 601000 Wages and Salaries MKTG DANIEL 03 Apr
601 - SALARIES 601000 Wages and Salaries MKTG DANIEL 03 May
601 - SALARIES 601000 Wages and Salaries MKTG DANIEL 03 Jun
601 - SALARIES 601000 Wages and Salaries MKTG CAMERON 03 Jan
601 - SALARIES 601000 Wages and Salaries MKTG CAMERON 03 Feb
601 - SALARIES 601000 Wages and Salaries MKTG CAMERON 03 Mar
601 - SALARIES 601000 Wages and Salaries MKTG CAMERON 03 Apr
601 - SALARIES 601000 Wages and Salaries MKTG CAMERON 03 May
601 - SALARIES 601000 Wages and Salaries MKTG CAMERON 03 Jun
601 - SALARIES 601000 Wages and Salaries OPS JACQUES 03 Jan
601 - SALARIES 601000 Wages and Salaries OPS JACQUES 03 Feb
601 - SALARIES 601000 Wages and Salaries OPS JACQUES 03 Mar
601 - SALARIES 601000 Wages and Salaries OPS JACQUES 03 Apr
601 - SALARIES 601000 Wages and Salaries OPS JACQUES 03 May
601 - SALARIES 601000 Wages and Salaries OPS JACQUES 03 Jun
601 - SALARIES 601000 Wages and Salaries OPS PAUL 03 Jan
601 - SALARIES 601000 Wages and Salaries OPS PAUL 03 Feb
601 - SALARIES 601000 Wages and Salaries OPS PAUL 03 Mar
601 - SALARIES 601000 Wages and Salaries OPS PAUL 03 Apr
601 - SALARIES 601000 Wages and Salaries OPS PAUL 03 May
601 - SALARIES 601000 Wages and Salaries OPS PAUL 03 Jun
601 - SALARIES 601000 Wages and Salaries ADMIN ROB 03 Jan
601 - SALARIES 601000 Wages and Salaries ADMIN ROB 03 Feb
601 - SALARIES 601000 Wages and Salaries ADMIN ROB 03 Mar
601 - SALARIES 601000 Wages and Salaries ADMIN ROB 03 Apr
601 - SALARIES 601000 Wages and Salaries ADMIN ROB 03 May
601 - SALARIES 601000 Wages and Salaries ADMIN ROB 03 Jun
601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD 03 Jan
601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD 03 Feb
601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD 03 Mar
601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD 03 Apr
601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD 03 May
601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD 03 Jun
602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN 03 Jan
602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN 03 Feb
602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN 03 Mar
602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN 03 Apr
602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN 03 May
602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN 03 Jun
602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG 03 Jan
602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG 03 Feb
602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG 03 Mar
602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG 03 Apr
602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG 03 May
602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG 03 Jun
602 - PAYROLL TAXES 602100 FICA Tax Expense OPS 03 Jan
602 - PAYROLL TAXES 602100 FICA Tax Expense OPS 03 Feb
602 - PAYROLL TAXES 602100 FICA Tax Expense OPS 03 Mar
602 - PAYROLL TAXES 602100 FICA Tax Expense OPS 03 Apr
602 - PAYROLL TAXES 602100 FICA Tax Expense OPS 03 May
602 - PAYROLL TAXES 602100 FICA Tax Expense OPS 03 Jun
610 - OCCUPANCY 611000 Utilities ADMIN 03 Jan
610 - OCCUPANCY 611000 Utilities ADMIN 03 Feb
610 - OCCUPANCY 611000 Utilities ADMIN 03 Mar
610 - OCCUPANCY 611000 Utilities ADMIN 03 Apr
610 - OCCUPANCY 611000 Utilities ADMIN 03 May
610 - OCCUPANCY 611000 Utilities ADMIN 03 Jun
610 - OCCUPANCY 612000 Landscaping ADMIN 03 Jan
610 - OCCUPANCY 612000 Landscaping ADMIN 03 Feb
610 - OCCUPANCY 612000 Landscaping ADMIN 03 Mar
610 - OCCUPANCY 612000 Landscaping ADMIN 03 Apr
610 - OCCUPANCY 612000 Landscaping ADMIN 03 May
610 - OCCUPANCY 612000 Landscaping ADMIN 03 Jun
620 - MARKETING 621000 Advertising MKTG 03 Jan
620 - MARKETING 621000 Advertising MKTG 03 Feb
620 - MARKETING 621000 Advertising MKTG 03 Mar
620 - MARKETING 621000 Advertising MKTG 03 Apr
620 - MARKETING 621000 Advertising MKTG 03 May
620 - MARKETING 621000 Advertising MKTG 03 Jun
620 - MARKETING 624000 Festivals & Competitions MKTG 03 Jan
620 - MARKETING 624000 Festivals & Competitions MKTG 03 Feb
620 - MARKETING 624000 Festivals & Competitions MKTG 03 Mar
620 - MARKETING 624000 Festivals & Competitions MKTG 03 Apr
620 - MARKETING 624000 Festivals & Competitions MKTG 03 May
620 - MARKETING 624000 Festivals & Competitions MKTG 03 Jun
630 - COMMUNICATIONS 631000 Telephone Expense ADMIN 03 Jan
630 - COMMUNICATIONS 631000 Telephone Expense ADMIN 03 Feb
630 - COMMUNICATIONS 631000 Telephone Expense ADMIN 03 Mar
630 - COMMUNICATIONS 631000 Telephone Expense ADMIN 03 Apr
630 - COMMUNICATIONS 631000 Telephone Expense ADMIN 03 May
630 - COMMUNICATIONS 631000 Telephone Expense ADMIN 03 Jun
630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG 03 Jan
630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG 03 Feb
630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG 03 Mar
630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG 03 Apr
630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG 03 May
630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG 03 Jun
630 - COMMUNICATIONS 633000 Postage Expense ADMIN 03 Jan
630 - COMMUNICATIONS 633000 Postage Expense ADMIN 03 Feb
630 - COMMUNICATIONS 633000 Postage Expense ADMIN 03 Mar
630 - COMMUNICATIONS 633000 Postage Expense ADMIN 03 Apr
630 - COMMUNICATIONS 633000 Postage Expense ADMIN 03 May
630 - COMMUNICATIONS 633000 Postage Expense ADMIN 03 Jun
650 - SUPPLIES 651000 Office Supplies ADMIN 03 Jan
650 - SUPPLIES 651000 Office Supplies ADMIN 03 Feb
650 - SUPPLIES 651000 Office Supplies ADMIN 03 Mar
650 - SUPPLIES 651000 Office Supplies ADMIN 03 Apr
650 - SUPPLIES 651000 Office Supplies ADMIN 03 May
650 - SUPPLIES 651000 Office Supplies ADMIN 03 Jun
670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN 03 Jan
670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN 03 Feb
670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN 03 Mar
670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN 03 Apr
670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN 03 May
670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN 03 Jun
690 - INSURANCE 691000 Insurance ADMIN 03 Jan
690 - INSURANCE 691000 Insurance ADMIN 03 Feb
690 - INSURANCE 691000 Insurance ADMIN 03 Mar
690 - INSURANCE 691000 Insurance ADMIN 03 Apr
690 - INSURANCE 691000 Insurance ADMIN 03 May
690 - INSURANCE 691000 Insurance ADMIN 03 Jun
710 - TAXES 711000 Federal Income Tax ADMIN 03 Jan
710 - TAXES 711000 Federal Income Tax ADMIN 03 Feb
710 - TAXES 711000 Federal Income Tax ADMIN 03 Mar
710 - TAXES 711000 Federal Income Tax ADMIN 03 Apr
710 - TAXES 711000 Federal Income Tax ADMIN 03 May
710 - TAXES 711000 Federal Income Tax ADMIN 03 Jun
720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN 03 Jan
720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN 03 Feb
720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN 03 Mar
720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN 03 Apr
720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN 03 May
720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN 03 Jun
790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN 03 Jan
790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN 03 Feb
790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN 03 Mar
790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN 03 Apr
790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN 03 May
790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN 03 Jun
790 - OTHER OPERATING 792000 Miscellaneous Expense ADMIN 03 Jan
790 - OTHER OPERATING 792000 Bank Charges ADMIN 03 Feb
790 - OTHER OPERATING 792000 Bank Charges ADMIN 03 Mar
790 - OTHER OPERATING 792000 Bank Charges ADMIN 03 Apr
790 - OTHER OPERATING 792000 Bank Charges ADMIN 03 May
790 - OTHER OPERATING 792000 Bank Charges ADMIN 03 Jun
790 - OTHER OPERATING 793000 Interest ADMIN 03 Jan
790 - OTHER OPERATING 793000 Interest ADMIN 03 Feb
790 - OTHER OPERATING 793000 Interest ADMIN 03 Mar
790 - OTHER OPERATING 793000 Interest ADMIN 03 Apr
790 - OTHER OPERATING 793000 Interest ADMIN 03 May
790 - OTHER OPERATING 793000 Interest ADMIN 03 Jun
BUDGET EXPLANATIONS
18000
18000
18000
18000
18000
18000
14000
14000
14000
14000
14000
14000
14000
14000
14000
14000
14000
14000
17000
17000
17000
17000
17000
17000
9000
9000
9000
9000
9000
9000
20000
20000
20000
20000
20000
20000
25000
25000
25000
25000
25000
25000
3443
3443
3443
2448
536
0
3519
3519
3519
3519
2372
2142
1989
1989
1989
1989
1989
842
29980
29980
29980
29980
29980
29980
13540
13540
13540
13540
13540
13540
20731
20731
20731
20731
20731
20731
6000 Chateau Open House
15450 Riverside Int'l Wine Competition
57500 Provence Wine Fest
18750 Napa Extravganza
75500 Continental Festival
15600 Springfest Wine Festival
3125
3125
3125
3125
3125
3125
1750
1750
1750
1750
1750
11500 Set up b2b site
650
650
650
650
650
650
1800
1800
1800
1800
1800
1800
48350
48350
48350
48350
48350
48350
38460
38460
38460
38460
38460
38460
23120
23120
23120
23120
23120
23120
4995
4995
4995
4995
4995
4995
920
920
920
920
920
920
3050
3050
3050
3050
3050
3050
30000
30000
30000
30000
30000
30000