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

Cash and Stock Control - Research Paper Example crossing descriptions takenNew Item entropy entry form for entering New items taken in from suppliersProducts table using VLOOKUP escapeUpdate StockUpdate the line of merchandise levels of mathematical products procured in the Product gameboardPrintPrint drone of sheetDeliveriesData base of Main summonReturn to Main scallywag guests containing their names and addresses extend CustomerData form for entering customer dataSales 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 given 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. Sort by Product ID2.b. Sort by Product Type2.c. Re-Order List2.d. Print preview of Product Table2.e. Add new produ ct3. 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. 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 UpdateAfter the update, the stock volume is decreased by 1, re-order stock is 3 and its re-order value increased to 285.C. User ManualYou should be possessed of at least MS Excel 2003 installed in your computer with the protective cover 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 sec urity 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.