INSTRUCTIONAL NOTES
AND SOLUTIONS GUIDE
THE COMPUTERIZED ACCOUNTING
INFORMATION SYSTEM:
The Winery at Chateau Americana
GENERAL CLASSROOM USE
The CAST Computerized Accounting Information System Module is designed to be used in
conjunction with the CAST Manual Accounting Information System Module. We have provided
the instructor with three alternative transaction sets in the Manual Accounting Information System
just the files) must be copied to your Peachtree Company folder intact so that Peachtree can find the
company. Finally, the Database Application (Access) file is contained in its own file.
SPREADSHEET APPLICATIONS
USING MICROSOFT EXCEL 2010:
The Winery at Chateau Americana
LEARNING OBJECTIVES
After completing and discussing this module, you should be able to:
• Recognize the managerial and technological issues and risks associated with designing and utilizing
a spreadsheet application as the primary accounting information system
CLASSROOM USE
Three sets of Unadjusted Trial Balances & Adjustments are provided here. The data was not provided to the
students in the Student files on the Pearson website because it also provides the solution to the worksheet for
INSTRUCTIONAL NOTES
Payroll Journal:
We have included a column in the Payroll Journal for the Subsidiary Posting Reference. If you have had
your students complete the CAST Manual Accounting Information System Module, you may want them to
use the posting reference from the subsidiary journals contained in that Module. Otherwise, you may want
to instruct them to leave this blank for purposes of completing this worksheet.
SOLUTION
Chateau Americana, Inc.
Unadjusted Trial Balance Figures and Adjustments
CHATEAU AMERICANA
YEAR-END WORKSHEET
12/31/20XX
12–31-20XX
ACCOUNT
UNADJUSTED
ADJUSTMENTS
TITLE
TRIAL
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
ASSETS
General checking account
2,171,441.24
Payroll checking account
1,000.00
Money market account
782,546.49
Savings account
51,745.56
LIABILITIES
Accounts payable
4,987,975.79
Federal income tax withheld
67,385.78
FICA withheld
12,681.48
Medicare withheld
2,965.82
FICA payable – employer
12,681.48
Medicare payable – employer
Unemployment taxes payable
Other accrued expenses
599,403.23
Federal income taxes payable
Property taxes payable
Dividends payable
Mortgages payable
7,639,067.73
Notes payable
813,000.00
STOCKHOLDERS’ EQUITY
Common stock
90,000.00
Paid-in capital in excess of par – common
3,567,265.00
Dividends – common
Retained earnings
REVENUE
Petty cash
Accounts receivable
5,366,569.32
Allowance for bad debts
95,401.58
Inventory – production
Inventory – finished goods
3,992,237.27
Prepaid expenses
142,465.96
Land and buildings
Equipment
Accumulated depreciation
Investments
3,095,227.56
Interest income
23,482.56
COST OF GOODS SOLD
Cost of goods sold
11,565,901.15
EXPENSES
Wages and salaries expense
1,972,322.74
Sales commissions expense
771,665.60
FICA tax expense
244,568.36
Medicare tax expense
57,197.43
FUTA expense
SUTA expense
22,176.00
Utilities expense
325,954.67
Irrigation & waste disposal expense
230,910.91
Landscaping expense
142,475.69
Advertising expense
295,944.33
Marketing expense
192,865.67
Festivals & competitions expense
238,654.75
Telephone expense
37,584.73
Internet & computer expense
14,475.00
Postage & shipping expense
35,117.66
Legal & accounting fees
88,425.50
Other consulting fees
12,500.00
Office supplies expense
58,689.68
Data processing expense
Depreciation expense
1,200,849.16
Travel and entertainment expense
169,405.86
Other insurance expense
115,058.55
Medical insurance
192,154.80
Workmen’s compensation insurance
139,750.00
Other employee benefits expense
175,643.90
Dues & subscriptions expense
32,076.00
Federal income tax expense
857,595.76
149,097.05
Property tax expense
19,875.00
Repairs and maintenance
71,974.93
Automobile expense
81,493.45
Lease expense
113,607.56
Bad debt expense
Miscellaneous expense
26,665.63
Interest expense
359,969.78
Sales discounts
348,017.49
Sales returns and allowances
15,684.50
Gain/Loss – Fixed Assets
Dividend income
TRANSACTION SET B
Chateau Americana, Inc.
Unadjusted Trial Balance Figures and Adjustments
CHATEAU AMERICANA
YEAR-END WORKSHEET
12/31/20XX
12–31-20XX
ACCOUNT
UNADJUSTED
ADJUSTMENTS
TITLE
TRIAL BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
ASSETS
General checking account
2,142,990.31
Payroll checking account
1,000.00
Money market account
782,546.49
Investments
3,095,227.56
LIABILITIES
Accounts payable
4,987,975.79
Federal income tax withheld
67,385.78
FICA withheld
12,681.48
Medicare withheld
2,965.82
FICA payable – employer
Medicare payable – employer
2,965.82
Unemployment taxes payable
Other accrued expenses
Federal income taxes payable
154,969.61
Property taxes payable
Dividends payable
Mortgages payable
7,639,067.73
Notes payable
STOCKHOLDERS’ EQUITY
Common stock
90,000.00
Paid-in capital in excess of par – common
3,567,265.00
Dividends – common
Retained earnings
22,064,134.78
REVENUE
Sales
22,353,157.95
Savings account
Petty cash
Accounts receivable
5,366,569.32
Allowance for bad debts
95,401.58
Inventory – production
Inventory – finished goods
Prepaid expenses
Land and buildings
Equipment
Accumulated depreciation
15,342,029.47
COST OF GOODS SOLD
Cost of goods sold
11,569,808.59
EXPENSES
Wages and salaries expense
1,972,322.74
Sales commissions expense
771,665.60
FICA tax expense
244,568.36
Medicare tax expense
57,197.43
FUTA expense
SUTA expense
22,176.00
Utilities expense
325,954.67
Irrigation & waste disposal expense
230,910.91
Landscaping expense
142,475.69
Advertising expense
296,794.33
Marketing expense
Festivals & competitions expense
238,654.75
Telephone expense
37,584.73
Internet & computer expense
14,475.00
Postage & shipping expense
35,117.66
Legal & accounting fees
88,425.50
Other consulting fees
12,500.00
Office supplies expense
58,689.68
Data processing expense
Depreciation expense
1,201,199.16
Travel and entertainment expense
169,405.86
Other insurance expense
115,058.55
Medical insurance
Workmen’s compensation insurance
139,750.00
Other employee benefits expense
175,643.90
Dues & subscriptions expense
32,076.00
Federal income tax expense
857,595.76
Property tax expense
19,875.00
Repairs and maintenance
71,974.93
Automobile expense
81,493.45
Lease expense
113,607.56
Bad debt expense
10,994.50
Miscellaneous expense
26,665.63
Interest expense
359,978.41
77,682,900.67
165,964.11
Sales returns and allowances
15,718.26
Gain/Loss – Fixed Assets
Dividend income
Interest income
TRANSACTION SET C
Chateau Americana, Inc.
Unadjusted Trial Balance Figures and Adjustments
CHATEAU AMERICANA
YEAR-END WORKSHEET
12/31/20XX
12–31-20XX
ACCOUNT
UNADJUSTED
ADJUSTMENTS
TITLE
TRIAL
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
ASSETS
General checking account
2,192,465.94
Payroll checking account
1,000.00
Money market account
782,546.49
Savings account
51,745.56
LIABILITIES
Accounts payable
4,987,975.79
Federal income tax withheld
67,385.78
FICA withheld
12,681.48
Medicare withheld
2,965.82
FICA payable – employer
Medicare payable – employer
2,965.82
Unemployment taxes payable
Other accrued expenses
Federal income taxes payable
Property taxes payable
Dividends payable
Notes payable
STOCKHOLDERS’ EQUITY
Common stock
90,000.00
Paid-in capital in excess of par – common
3,567,265.00
Dividends – common
Retained earnings
Petty cash
Accounts receivable
5,365,981.82
Allowance for bad debts
95,401.58
Inventory – production
Inventory – finished goods
3,976,802.63
Prepaid expenses
Land and buildings
Equipment
Accumulated depreciation
Investments
3,095,227.56
COST OF GOODS SOLD
Cost of goods sold
11,581,335.79
EXPENSES
Wages and salaries expense
1,972,322.74
Sales commissions expense
771,665.60
FICA tax expense
244,568.36
Medicare tax expense
57,197.43
FUTA expense
SUTA expense
22,176.00
Utilities expense
326,338.17
Irrigation & waste disposal expense
230,910.91
Landscaping expense
142,475.69
Advertising expense
Marketing expense
192,865.67
Festivals & competitions expense
238,654.75
Telephone expense
37,584.73
Internet & computer expense
14,475.00
Postage & shipping expense
35,117.66
Legal & accounting fees
88,425.50
Other consulting fees
12,500.00
Office supplies expense
58,689.68
Data processing expense
Depreciation expense
1,200,505.11
Travel and entertainment expense
169,405.86
Other insurance expense
Medical insurance
192,154.80
Workmen’s compensation insurance
139,750.00
Other employee benefits expense
175,643.90
Dues & subscriptions expense
32,076.00
Federal income tax expense
857,595.76
155,901.94
Property tax expense
19,875.00
Repairs and maintenance
71,974.93
Automobile expense
81,493.45
Lease expense
113,607.56
Bad debt expense
Miscellaneous expense
26,665.63
Interest expense
166,902.30
Sales discounts
348,667.11
Sales returns and allowances
15,736.88
Gain/Loss – Fixed Assets
Dividend income
Interest income
24,332.56
GENERAL LEDGER APPLICATIONS
USING PEACHTREE COMPLETE
ACCOUNTING 2012
:
The Winery At Chateau Americana
LEARNING OBJECTIVES
After completing and discussing this assignment, you should be able to:
• Recognize the managerial and technological issues associated with the implementation of a
general ledger package
CLASSROOM USE
As mentioned previously, the CAST Computerized Accounting Information System Module is designed to be
used in conjunction with the CAST Manual Accounting Information System Module. Therefore, there are
three alternative transaction sets provided for the General Ledger Application, consistent with the Manual
Accounting Information System Module to allow rotation of solutions from one semester to another.
Depending upon how much ‘hand–holding’ you want to do, you may want to provide additional hints for
the General Journal Entry function is found under Company.
SOLUTION
There are three General Ledger Application solutions contained in one ZIP file. When you unzip the file,
you will find three folders entitled “thewinaA” for Transaction Set A, “thewinaB” for Transaction Set B, and
NOTE
If you had your students work through the Manual Module, please note that there are no bank reconciliation
in Peachtree. We do apologize for this. However, given the three transaction sets we made the decision that
the complexity involved in trying to provide different amounts on outstanding checks, etc., did not warrant
repeating this exercise in the computerized environment.
DATABASE APPLICATIONS
USING MICROSOFT ACCESS 2010:
The Winery at Chateau Americana
LEARNING OBJECTIVES
After completing and discussing this material, you should be able to:
• Recognize and explain the purpose of the elements of a relational database
• Build selected elements of a database management system
SOLUTION