Reference no: EM131833462

Question: Requirements: Turn in an electronic copy of your completed lab to the Canvas site. All requirements should be included in one Excel file. Name your file: yourlastname_lab1.

Lab Description: Assume that you 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 just scribble purchase orders on random pieces of paper. Over the past several years, the firm has made many errors when recording its payables, and many bills have not been paid on time.

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 (a program that is currently in use on all of the firm's PCs and is 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 also create some internal controls (general and application controls) for this new system and make it user friendly.

You will need to complete four major steps in order to accomplish this task:

1) Prepare a purchase order form and include internal controls (Part A)

2) Prepare a purchases register (Part B)

3) Create macros that will make the purchase order entry easy for the other employees at your firm (Part C)

4) Respond to the questions (Part D)

Information related to above question is enclosed below:

Attachment:- lab1.rar