Proposed System Objectives
The purpose of this strategic plan is to create and develop an inventory system that will automate their product recording.
Our proposed system will provide the following :
1. monthly, quarterly and annual report
2. easy to handle batteries data
3. less time to find the records/reports
4. handle company report that they can check their profit/loss annually or within the require time with the help of the inventory system
<!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0; mso-font-charset:2; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:0 268435456 0 0 -2147483648 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman";} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} /* List Definitions */ @list l0 {mso-list-id:484396296; mso-list-type:hybrid; mso-list-template-ids:573095124 -220674162 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;} @list l0:level1 {mso-level-start-at:7; mso-level-number-format:bullet; mso-level-text:-; mso-level-tab-stop:1.0in; mso-level-number-position:left; margin-left:1.0in; text-indent:-.5in; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman";} ol {margin-bottom:0in;} ul {margin-bottom:0in;} -->
With only limited time given to this project and due to our tight schedule. The study was only limited to inventory of the batteries in Tres Quintas. Specification of the battery is required to distinguish one from the other. The unit price will be indicated including the serial numbers. The delivery receipt and the invoice on hand will be the basis in tracking the details. This will also generate a report with the total battery on hand including the total sales. The report will varies on the needs of the company. It can be generated monthly, quarterly and annually.
The following are identified details that needed in an inventory system:
- Date delivery
- Type of Batteries
- Serial Number
- Brand of Batteries
- Unit Cost
- Date Sold
- Amount Sold
- Income Earned
- Total Batteries on Hand
<!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman";} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} -->
The following are the needed buttons in the inventory system :
1. NEW (add/create) – Data needed for the delivery items which includes date of delivery, serial number, brand, type and unit cost.
2. UPDATE – Data needed to be corrected including the data needed to be deleted.
3. SEARCH - any given data as mentioned in the above will give hint and will show the details.
4. PRINT(monthly/quarterly/annually) – this will serve as a command if a report needed to be printed depending on the needs.
5. SUMMARY – this will show all the items recorded
6. SOLD – this enables to record all the sold items with all the details, that will automatically deducted on the on hand items.
7. AUTHORIZE – this will require the owner to input his/her password for authentication of the transactions
please give me idea how to i create it using visual basic 2008
- 24 views