Devam Ediyor

assignment

Design guidelines

1. General requirements

The general requirements are:

• a form or multi-forms to illustrate all related activities;

• at least five sets of relevant stock items;

• validation of input data technique.

2. Specified requirements

2.1 Sales

- calculate the total amount of each sales transaction;

- list down the summary of daily sales record;

- collect data from Marketing record to update the selling prices.

2.2 Inventory

- check the quantity of each stock;

- collect data from Sales record to update the inventory record;

- add, edit or delete individual stock item.

2.3 Purchasing

- check the purchasing quantity and price of each stock item;

- collect data from Inventory record to determine when to purchase new stocks;

- add, edit or delete individual purchased item.

2.4 Marketing

- collect data from Sales record to list out the most salable items in ascending order;

- set the selling prices for all stock items;

- collect data from Profit & Loss record and Sales record to list down for each stock item the

actual selling quantity, the predicted selling quantity to achieve 20% profit, and their

differences.

2.5 Wage

- record down the working hours and hourly rate of each employee;

- add, edit or delete individual employee record;

- print out on screen the monthly wage report.

2.6 Profit & Loss

- calculate the monthly profit and loss;

- print out on screen the monthly sales report;

- print out on screen the monthly purchasing report.

M1ET3407 Information Tecirnology for Engineers — Mini Project Brief— Prepared by Vicky Lee

Design guidelines

1. General requirements

The general requirements are:

• a form or multi-forms to illustrate all related activities;

• at least five sets of relevant stock items;

• validation of input data technique.

2. Specified requirements

2.1 Sales

- calculate the total amount of each sales transaction;

- list down the summary of daily sales record;

- collect data from Marketing record to update the selling prices.

2.2 Inventory

- check the quantity of each stock;

- collect data from Sales record to update the nventory record;

- add, edit or delete individual stock item.

2.3 Purchasing

- check the purchasing quantity and price of each stock item;

- collect data from Inventory record to determine when to purchase new stocks;

- add, edit or delete individual purchased item.

2.4 Marketing

- collect data from Sales record to list out the most salable items in ascending order;

- set the selling prices for all stock items;

- collect data from Protit & Loss record and Sales record to list down for each stock item the

actual selling quantity, the predicted selling quantity to achieve 20% profit, and their

differences.

2.5 Wage

- record down the working hours and hourly rate of each employee;

- add, edit or delete individual employee record;

- print out on screen the monthly wage report.

2.6 Profit & Loss

- calculate the monthly profit and loss;

- print out on screen the monthly sales report;

- print out on screen the monthly purchasing report.

Beceriler: Visual Basic

Daha fazlasını görün: new employee forms, item list for marketing price, hourly rate to edit, profit and loss report, vicky, mini marketing project, visual basic 2013 print form, calculate quantity, list ascending, list stocks, stocks list, assignment edit, visual report design, collect stock data, assignment marketing, marketing report assignment, sales report design, check assignment, collect information marketing project, design sales report, input inventory data, mini project report, inventory stock visual basic, input data inventory, daily sales summary report

İşveren Hakkında:
( 1 değerlendirme ) Central District, Hong Kong

Proje NO: #4455287

Seçilen:

paris2785

VB, VBA and databases expert for over a decade. I am seriously interested in your project

3 gün içinde 550$ HKD
(0 Değerlendirme)
0.0

7 freelancers are bidding on average $1593 for this job

dobreiiita

Hi, I can help you with this project.

in 3 gün içinde1999$ HKD
(14 Değerlendirme)
3.8
gpsanjeewa

Hope it's done.

in 7 gün içinde1650$ HKD
(3 Değerlendirme)
2.7
oobretenov

I could help you

in 10 gün içinde2200$ HKD
(1 Değerlendirme)
1.8
spcinc

Hi, I can do it!

in 3 gün içinde1545$ HKD
(1 Değerlendirme)
1.4
pankildesai1988

I can do this and Ready to start. Please check your PM.

in 8 gün içinde2200$ HKD
(0 Değerlendirme)
0.0
piyushrathod09

I have exp on Developing

in 3 gün içinde1232$ HKD
(0 Değerlendirme)
0.0
firefoxred18

Good day. What you need is an inventory and sales monitoring system, If your interested just send me a private message.

1 gün içinde 1318$ HKD
(0 Değerlendirme)
0.0