smtazulislam
Member
- Local time
- Today, 23:56
- Joined
- Mar 27, 2020
- Messages
- 808
Good Day !
I want to create project cost and Balance Model design for Cost and Balance Control Database. want to someone help basic thing and how to design this database tables and relationship for easily to calculate my below of field.
How we work progressing :
each project give Bill of quantity (BID) and approve by Purchase Order (PO)
Eg. Project No: 01 (Roco WareHouse) has been approval with in 2.4M USD.
Project No: 02 (CC7 New Building Centre) has been approval with 2.5M USD.
Example of BID : Project No : 1 ( Roco WareHouse) as mentioned.
1. Civil work- (PO- 140,000 USD) ,
2. FireFighting (PO- 160,000 USD),
3. Plumbing (PO- 180,000 USD),
4. Electrical (PO- 260,000 USD),
5. Paint (PO- 120,000 USD),
6. Decore (PO- 1540,000 USD),
Total 2.4 m USD.
Now Start work:
Cash Money (Example):
Cashier give money to Site Engineer or Site Foreman.
Site Engineer give money to Site Foreman or buy materialor give to an employee Cash Advance .
Site Foreman buy any material for project no: 1 OR 2 OR 3 etc. sometime give to an employee Cash Advance (if need)
Invoice (example) :
Site Foreman give Sales invoice to cashier.
Site Engineer give Sales Invoice to cashier.
Employee Cash Advance Form Sign get money receipt and send to cashier.
I looking to-
each project how much cost and and profit ?
each site engineer how much money took and How much money invoice he send to me and How much money balance with him ?
each site foreman how much money took and How much money invoice he send to me and How much money balance with him ?
Which employee took money as cash advance and How much ?
I want to create project cost and Balance Model design for Cost and Balance Control Database. want to someone help basic thing and how to design this database tables and relationship for easily to calculate my below of field.
How we work progressing :
each project give Bill of quantity (BID) and approve by Purchase Order (PO)
Eg. Project No: 01 (Roco WareHouse) has been approval with in 2.4M USD.
Project No: 02 (CC7 New Building Centre) has been approval with 2.5M USD.
Example of BID : Project No : 1 ( Roco WareHouse) as mentioned.
1. Civil work- (PO- 140,000 USD) ,
2. FireFighting (PO- 160,000 USD),
3. Plumbing (PO- 180,000 USD),
4. Electrical (PO- 260,000 USD),
5. Paint (PO- 120,000 USD),
6. Decore (PO- 1540,000 USD),
Total 2.4 m USD.
Now Start work:
Cash Money (Example):
Cashier give money to Site Engineer or Site Foreman.
Site Engineer give money to Site Foreman or buy material
Site Foreman buy any material for project no: 1 OR 2 OR 3 etc. sometime give to an employee Cash Advance (if need)
Invoice (example) :
Site Foreman give Sales invoice to cashier.
Site Engineer give Sales Invoice to cashier.
Employee Cash Advance Form Sign get money receipt and send to cashier.
I looking to-
each project how much cost and and profit ?
each site engineer how much money took and How much money invoice he send to me and How much money balance with him ?
each site foreman how much money took and How much money invoice he send to me and How much money balance with him ?
Which employee took money as cash advance and How much ?