MMPA513 ACCOUNTING INFORMATION SYSTEMS
Trimester Three 2021
Assignment four: Excel
Marks might be given for passable completion.
Background:
You’re a new employees member in a small retail agency. The opposite staff have very restricted know-how expertise, and the agency has no formal system for creating or recording purchases. Presently, they merely scribble buy orders on random items of paper. Over the previous a number of years, the agency has made many errors in recording its payables and lots of payments haven’t been paid on time.
Being an lively and expert new member of the agency, you supply to develop a Purchases system. You recommend that this method may very well be constructed utilizing Excel, as it is a program presently in use on all of the agency’s PCs and utilized by most staff. The system will enable for straightforward entry of buy orders which could be mailed to distributors. The system may also maintain monitor of payables and point out when every account ought to be paid. You’ll embrace some inside controls (basic and software controls) for this new system and make it user-friendly.
Required:
All necessities are to be included in a single Excel file. Title your file as [yourfamilyname]_excel.xlsx.
1. Full all directions for Labs 2 & three (Excel):
a. Put together a Buy Order type, Legitimate Distributors listing, and Value listing (Elements A-C) and add FOUR controls;
(16 marks)
b. Reply to the questions in Half D (reproduced in abbreviated type under):
1. listing the 4 controls that you just added to the PO type or different sheets on the finish of Lab 2 AND clarify what every added management achieves.
(6 marks)
1
2. determine FOUR further controls that ought to be included on this software. You don’t want to implement these advised controls. Write a short rationalization for every advised management displaying why it could be useful.
(eight marks)
Marks might be posted on Blackboard. This Assessment is price 30 marks in complete (15% of your complete course grade).
—-
ACCOUNTING INFORMATION SYSTEMS (MMPA513)
Trimester three (2021)
4th Assignment: Excel
Passable completion will end in a grade.
Background:
You’re a new worker at a modest retail firm. The opposite employees have extraordinarily restricted technological expertise, and the corporate doesn’t have a proper process for producing or registering purchases. They presently scrawl buy orders on odd scraps of paper. Over the previous a number of years, the agency has made many errors in recording its payables and lots of payments haven’t been paid on time.
Being an lively and expert new member of the agency, you supply to develop a Purchases system. You recommend that this method may very well be constructed utilizing Excel, as it is a program presently in use on all of the agency’s PCs and
