Cash and Stock Control Research Paper Example | Topics and Well Written Essays - 2000 words

Cash and Stock Control - Research Paper Example Product descriptions taken New Item Data entry form for entering New items taken in from suppliers Products table using VLOOKUP function Update Stock Update the stock levels of products procured in the "Product Table" Print Print preview of sheet Deliveries Data base of Main Page Return to Main Page Customers containing their names and addresses Add Customer Data form for entering customer data Sales invoice Table of up to 5 Main Page Return to Main Page products sold to a customer (using VLOOKUP function) Add item Data form for entering products sold (Product ID and Quantity), other data are given by the VLOOKUP function Update Stock Update the stock levels of products procured in the "Product Table" Print Print preview of sheet B. Print outs of various screens and tables 1. Main Page 2. Product Table 2.a. Sort by Product ID 2.b. Sort by Product Type 2.c. Re-Order List 2.d. Print preview of Product Table 2.e. Add new product 3. Order form 4. Goods In 5. Deliveries 6. Sales Invoice 6.a. Sales Invoice Screen before Updating Sock 6. b. Product Table before Updating Stock The second row of data (product ID 0002) is one of the stocks affected by the update from sales invoice table. Before the update its stock is at 23, 2 below the re-order level of 25, re-order stock is 2, invoice is 1, and Re-order value is 190. 6. c. Product Table after Update After the update, the stock volume is reduced by 1, re-order stock is 3 and its re-order value increased to 285. C. User Manual You should have at least MS Excel 2003 installed in your computer with the security level reduced to low level, or else the macros are disabled and cannot operate at higher security levels. You should also have an antivirus program installed in your... You should have at least MS Excel 2003 installed in your computer with the security level reduced to low level, or else the macros are disabled and cannot operate at higher security levels. You should also have an antivirus program installed in your computer. A print button is included in all sheets so you can preview or have hard copy of the transaction made. A VLookup function (vertical look-up function) is used on the product table to help "automate" the entry of product type and descriptions in the other sheets, so the user may not need to re-enter these information. Data can be entered directly on the spreadsheet or by using the data form entry button provided.