MMPA513 ACCOUNTING INFORMATION SYSTEMS
\nTrimester Three 2021
\nAssignment 4: Excel<\/p>\n
Marks will be given for satisfactory completion.<\/p>\n
Background:
\nYou are a new staff member in a small retail firm. The other employees have very limited technology skills, and the firm has no formal system for creating or recording purchases. Currently, they simply scribble purchase orders on random pieces of paper. Over the past several years, the firm has made many errors in recording its payables and many bills have not been paid on time.<\/p>\n
Being an energetic and skilled new member of the firm, you offer to develop a Purchases system. You suggest that this system could be constructed using Excel, as this is a program currently in use on all the firm\u2019s PCs and used by most employees. The system will allow for easy entry of purchase orders which can be mailed to vendors. The system will also keep track of payables and indicate when each account should be paid. You will include some internal controls (general and application controls) for this new system and make it user-friendly.<\/p>\n
Required:<\/p>\n
All requirements are to be included in one Excel file. Name your file as [yourfamilyname]_excel.xlsx.<\/p>\n
1.\tComplete all instructions for Labs 2 & 3 (Excel):
\na.\tPrepare a Purchase Order form, Valid Vendors list, and Price list (Parts A-C) and add FOUR controls;
\n(16 marks)
\nb.\tRespond to the questions in Part D (reproduced in abbreviated form below):
\n1. list the four controls that you added to the PO form or other sheets at the end of Lab 2 AND explain what each added control achieves.
\n(6 marks)
\n1
\n2.\tidentify FOUR additional controls that should be included in this application. You do not need to implement these suggested controls. Write a brief explanation for each suggested control showing why it would be beneficial.
\n(8 marks)<\/p>\n
Marks will be posted on Blackboard. This assessment is worth 30 marks in total (15% of your total course grade).<\/p>\n
—-<\/p>\n
ACCOUNTING INFORMATION SYSTEMS (MMPA513)
\nTrimester 3 (2021)
\n4th Assignment: Excel<\/p>\n
Satisfactory completion will result in a grade.<\/p>\n
Background:
\nYou are a new employee at a modest retail company. The other staff have extremely limited technological skills, and the company does not have a formal procedure for producing or registering purchases. They currently scrawl purchase orders on odd scraps of paper. Over the past several years, the firm has made many errors in recording its payables and many bills have not been paid on time.<\/p>\n
Being an energetic and skilled new member of the firm, you offer to develop a Purchases system. You suggest that this system could be constructed using Excel, as this is a program currently in use on all the firm\u2019s PCs and<\/p>\n","protected":false},"excerpt":{"rendered":"
MMPA513 ACCOUNTING INFORMATION SYSTEMS Trimester Three 2021 Assignment 4: Excel Marks will be given for satisfactory completion. Background: You are a new staff member in\u2026<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8773,8771,8772,8770,8775,8776,7685,8774,8769],"tags":[1400,613,142,7594,1394,7598,7595,7593,7597,7599,7601,7590,7596,133,7655,7656,7591,7592],"class_list":["post-92203","post","type-post","status-publish","format-standard","hentry","category-all-assignment-help","category-assessment-help-online","category-assessment-help-online-in-australia","category-assessments-help","category-australia-assignment-help","category-instant-assignment-help","category-my-assignment-help","category-sample-assignment-help","category-thesis-help","tag-best-custom-essay-writing-services","tag-best-dissertation-writing-services-uk","tag-best-online-essay-writing-services","tag-cheap-custom-essay-writing-services","tag-custom-research-paper-writers","tag-custom-research-papers-writing-service","tag-essay-writer-websites","tag-essay-writing-service-quality-cheap","tag-free-research-paper-writing-service","tag-help-me-write-a-research-paper","tag-i-need-help-with-my-dissertation","tag-professional-dissertation-writing-service","tag-quick-essay-writing-service","tag-research-paper-writing-service-cheap","tag-service-writing-my-essay-write-custom","tag-someone-to-write-my-paper","tag-top-rated-dissertation-writing-services","tag-top-uk-dissertation-writing-services"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/92203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=92203"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/92203\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=92203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=92203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=92203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}