Furniture Factory material supply program
It must work the following way:
It has to have a manager menu, where materials/items can be added
The materials should be added this way:
Material Code - Material name
MIR1 - Mirror 116x33,4
SCR1 - Screw size 3x16
SCR2 - Screw size 2x11
GLA1 - Glass 136x33
GLA1 - Glass 100x50
Then after, there need to be a way in the manager menu to add ITEMS
for all the items, the manager can choose any materials (one or MORE) which the item needs
Item Name 1 (small furniture): needs the following materials:
- 1 MIR1
- 51 SCR1
Item name 2 (big furniture):
- 31 SCR2
- 2 GLA2
When adding the items, the materials can be selected by name.
After adding all items (there are around 150-200 items), there should be a user feature, where the users chooses
some items, and sets amount.
eg: user selects:
name | amount
Item 1 | 5
Item 2 | 2
Then the program generates a list which materials are needed for the selected items and multiplies it by the amount
Needs 5 Mirror 116x33,4
Needs 204 Screw size 3x16
Needs 62 Screw size 2x11
Needs 2 Glass 100x50
Then it should print or export to XLS / doc so it can be printed later.
The program should also use a Language file, which I can translate to Hungarian myself later. All messages / etc should be grabbed from there.
Pre-made program is OK too.