Answered You can hire a professional tutor to get the answer.
Hi, need to submit a 2000 words essay on the topic Cash and Stock Control.Download file to see previous pages... Product descriptions takenNew ItemData entry form for entering New items taken in from
Hi, need to submit a 2000 words essay on the topic Cash and Stock Control.
Download file to see previous pages...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 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 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.
