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

Cash and computer memory Control - Research Paper Example return descriptions taken young ItemData entry form for entering New items taken in from suppliers increases table apply VLOOKUP functionUpdate StockUpdate the stock levels of products procured in the Product shelve issue strike preview of sheetDeliveriesData base of Main PageReturn to Main PageCustomers containing their label and addressesAdd CustomerData form for entering customer selective information sales invoiceTable of up to 5 Main PageReturn to Main Pageproducts sold to a customer (using VLOOKUP function)Add itemData form for entering products sold (Product ID and Quantity), other data are accustomed by the VLOOKUP functionUpdate StockUpdate the stock levels of products procured in the Product TablePrintPrint preview of sheetB. Print outs of various screens and tables1. Main Page2. Product Table2.a. split up by Product ID2.b. Sort by Product Type2.c. Re-Order List2.d. Print preview of Product Table2.e. Add new p roduct3. Order form4. Goods In5. Deliveries6. Sales Invoice6.a. Sales Invoice Screen before Updating Sock6. b. Product Table before Updating StockThe second row of data (product ID 0002) is one of the stocks affected by the update from sales invoice table. onwards 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 UpdateAfter the update, the stock volume is reduced by 1, re-order stock is 3 and its re-order value increased to 285.C. User ManualYou 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 crisscross button is included in all sheets so you can preview or have wicked copy of the transaction made. A VLookup function (vertical look-up function) is used on the product table to help change the entry of product type and descriptions in the other sheets, so the user may not affect to re-enter these information. Data can be entered directly on the spreadsheet or by using the data form entry button provided.