财务与会计课程作业

财务与会计 课程essay  
财务和管理信息系统 课程essay
该essay在课程中占12.5%的比重
Finance and Accounting
Financial and Management Information Systems (FMIS)
Assignment #1
DAUBER LTD
(Weighting in module = 12½%)

场景：

你是一个英国特许公认会计师公会—尼古拉斯·马的见习会计师。

你的客户公司是“多贝有限公司”，要求您的公司帮助他们将会计账户自动化。多贝有限公司是一家商业和零售客户的绘画和装饰用品的供应商。

你的责任是将现行会计记录账目自动化，并对该公司的管理及会计人员进行长期的训练和教学。
The scenario:

You are a trainee accountant employed in the practice of Nicholas Steed (Chartered Accountants).

A client company, “Dauber Ltd,” has requested your firm’s assistance in the computerisation of their business accounting functions. The company is a supplier of painting and decorating supplies to both commercial and retail customers.

You have been charged with the responsibility of transferring current accounting records to the computerised accounts files of Sage and preparing the first month’s transactions with a longer – term view to training / educating the management and accounts staff of company.

Note:
The current rate of VAT applicable to Dauber Ltd is 20%

Assignment requirements：essay要求

1. Explain, to the management of Dauber Ltd, the Sage computerised accounting application from an information systems viewpoint and the potential benefits / drawbacks of computerisation for business accounting systems
Note: Not more than 500 words           http://ukthesis.org/kjzy/                                                                                     15%

2. Practical tasks:

 Initialise a Sage computerised accounts application for Dauber Ltd
Note: Ensure that your name appears in the company name cell of your data files

 Input the business opening balances (as at 1st October 2011) and budget plan data (for October 2011 –See appendices A i to iv)

 Input the following actual transaction data (for October 2011):

 Sales and purchases data (see Appendices B i to iii)
 Payroll data(see Appendix C)
 Banking data(see Appendices D i to iii)
 Month – end accounting adjustment information (see Appendix E)

3. Print out (Hard copy):

 A trial balance as at 31st October 2011 
 A profit and loss account (income statement) for the month ended 31st October 2011  
 A balance sheet as at 31st October 2011 
 A variance report for October 2011 10%

Note:
The backup file name must be your full name only                                                                 30% 
 
5. Explain the term “system changeover” and the steps that you have taken verify the accuracy of your Sage system outputs 
Note: Not more than 200 words                                                                                                25%
(Credit will be given where workings are provided for reconciliation to Sage system outputs)

6. Explain, with reference to your accounting work, what you believe to be the benefits of the monthly accounts reporting and the variance report
Note: Not more than 200 words                                                                                               10%

7. Presentation mark (for effective communication and user – focus)                                         10%#p#分页标题#e#

Total assignment mark                                                                                                           100%

Important:
This assignment is a test of your individual ability to deal with a range of accounting tasks requiring the application of both accounting knowledge and practical problem – solving skills.

Important:

On 31st October 2011 the following bank transfers were made:

 £7,000 was transferred to the bank current account from the bank deposit account

 A transfer was made from the cash account to the bank account sufficient to leave £400 in the cash account

Appendix E

Month end adjustments – Dated 31st October 2011:

Closing shop stocks have been valued as follows:

 Paint - £11,500

 Decorating - £12,000

 Tools - £9,500

 Monthly depreciation should be charged to fixed assets using the following rates and methods:

Fixed asset classification: Depreciation rate Depreciation method
Buildings 4% per year Straight line
Plant and machinery 18% per year Straight line
Motor vehicles 25% per year Reducing balance

Accrued expenses:
Accrued expense amounts should be adjusted to the following values:

 Electricity - £650

 Motor insurance £0 (Nil)

 Motor expenses - £375

Prepaid expenses:
Prepaid expense amounts should be adjusted to the following values:

 General rates - £400

 Advertising £1,200

Specific bad debts write off:
After an aged debtors’ analysis, it has been recognised that the account of Givens and Hope is unlikely to ever be paid. As a prudent, at this time, it has been decided to write the account of to bad debts.#p#分页标题#e#

Provision for doubtful debts:
The provision for doubtful debts should be adjusted to £300

END OF ASSIGNMENT

FAOF Year 2
Financial and Management Information Systems
Assignment #1 – DAUBER LTD - Marking

Student ID: ......................................................................................................................

Task To
Max Mark Remarks
Sage – From an information systems viewpoint 10  
Potential benefits / drawbacks of computerised accounts system  5  
A trial balance as at 31st October 2011 (Accuracy of values and coding) 6  
A profit and loss account (income statement) for the month ended 31st October 2011 (per TB) 1  
A balance sheet as at 31st October 2011 (per TB) 1  
A variance report for October 2011(per TB and budget plan data) 2  
Data backup file (Completeness and accuracy – related to printed reports – See notes) 30  
Explanation of “system changeover” 6  
Steps take to verify accuracy 4  
Verification workings 15  
Benefits of monthly accounts reporting and the variance report 10  
Presentation marks (e.g. front-sheet, contents page, effective communication and user – focus) 10  
Total: 100