0% found this document useful (0 votes)
11 views34 pages

Pre Costing

The document outlines a project costing summary for the client MROUND, detailing costs associated with the purchase of NPK 14-0-20 Compacted as Base, totaling MUR 50,010,256.23 with no markup. It includes sections on supplier details, order details, and various charges related to foreign and local costs. The final costing stage indicates a total cost of MUR 1,197,050.00 after accounting for insurance and local charges.

Uploaded by

Vickietende
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
11 views34 pages

Pre Costing

The document outlines a project costing summary for the client MROUND, detailing costs associated with the purchase of NPK 14-0-20 Compacted as Base, totaling MUR 50,010,256.23 with no markup. It includes sections on supplier details, order details, and various charges related to foreign and local costs. The final costing stage indicates a total cost of MUR 1,197,050.00 after accounting for insurance and local charges.

Uploaded by

Vickietende
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 34

PROJECT COSTING SUMMARY

CLIENT NAME:

MROUND
ITEM DESCRIPTION TOTAL COST MARK UP TURNOVER
MUR % MUR
NPK 14-0-20 COMPACTED AS BAS 49,835,638.28 0.00% 49,835,600.00
NPK 14-0-20 COMPACTED AS BAS 174,617.94 0.00% 174,600.00
- - 0.00% -
- - 0.00% -
- - 0.00% -
- - 0.00% -
- - 0.00% -
- - 0.00% -
- - 0.00% -
- - 0.00% -
50,010,256.23 0.00% 50,010,200.00
COROI MAURICE LTEE

DATE OF COSTING

1 DEPARTMENT ORDERING
1.1 DEPT NAME

2 SUPPLIER DETAILS
2.1 SUPPLIER NAME

3 ORDER DETAILS
3.1 COROI ORDER NO
3.2 SUPPLIER DOCUMENT DETAILS
A ORDER DOCUMENT DETAILS
B FINAL ORDER DOCUMENT DETAILS
C AMOUNT
3.3 ORDER CURRENCY
3.4 INCOTERM

3.5 GROUPAGE
3.6 DATE OF ARRIVAL
3.7 DETAILS OF ORDER
A MODE OF SHIPMENT
B COSTS APPORTIONMENT
C % DUTY

3.8 FOREX
A (LOSS)/SAVINGS ON FOREX RATE

B DATE
C SELLING RATE
D RISK COEFF
E COSTED RATE
3.9 CHARGES
A FOREIGN:
A.1 PICK UP CHARGES
A.2 CUSTOMS CLEARANCE
A.3 SOLAS
A.4 FOB CHARGES
A.5 HAZARDOUS CHARGES
A.5 SEA FREIGHT

B1 LOCAL (FCY)
B1.1 TERMINAL HANDLING CHARGE
B1.2 GLOBAL FUEL SURCHARGE(GFS)
B1.3 DOCUMENTATION FEE IMPORT
B1.4 QUAY FEES(MPA)

B2 LOCAL DUTIES(MUR)

B2.1 CUSTOMS DUTY

B3 LOCAL CHARGES(MUR)
B3.1 SHORE CHARGES
IMPORT CARGO COMMUNITY SYSTEM
B3.2 FEE(MACCS/CCS FEE)
B3.3 LANDING CHARGES IMPORT
B3.4 DOCUMENTATION FEE
B3.5 UNSTUFFING CHARGES(CFS)
B3.6 TRANSMISSION FEE
B3.7 COMMUNICATION COST
B3.8 GAF(GENERAL ADMIN FEE)
B3.9 AGENCY FEE
B3.10 PROCESSING FEE
B3.11 CLEARANCE FEE
B3.12 FREIGHT COLLECTION FEE
B3.13 BANK CHARGES
B3.14 TRANSPORT COSTS

B3.16 INSURANCE Additional Cover %


Marine Rate
W&S Rate
FSC CHARGES
INSURANCE AMOUNT
MINIMUM RATE

4 FORWARDER
4.1 FORWARDER

5 PRE COSTING IJR2404


5.1 GLOBAL COSTING
COSTS PAID IN FX
SUPPLIER'S INVOICE
A - FOREIGN FREIGHT

USD USD
PRE
COSTING
20,000.00 3,600.00

20,000.00 3,600.00
- -

MUR Rs919,790.00 Rs165,562.20


5.2 LINE COSTING
PURCHASE ORDER PART
STOCK ITEM CODE ITEM DESCRIPTION

AGFECHNP129 NPK 14-0-20 COMPACTED AS BASED


AGFECHNP130 NPK 14-0-20 COMPACTED AS BASED
PRE
COSTING

TOTAL

6 FINAL COSTING
6.1 FINAL GLOBAL COSTING
COSTS PAID IN FX
SUPPLIER'S INVOICE
A - FOREIGN FREIGHT

USD USD
FINAL
COSTING
20,000.00 0.00

20,000.00 0.00
- -

MUR Rs893,600.00 Rs0.00

6.2 FINAL LINE COSTING


PURCHASE ORDER PART
STOCK ITEM CODE ITEM DESCRIPTION

AGFECHNP129 NPK 14-0-20 COMPACTED AS BASED


AGFECHNP130 NPK 14-0-20 COMPACTED AS BASED
0.00 0.00
FINAL
COSTING 0.00 0.00
0.00 0.00
FINAL
COSTING

0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00

TOTAL
PRE COSTING STAGE

AGR

HEXTAR FERT SDN BHD

12042

PRO FORMA 121240


INVOICE
20,000.00
USD
EXWORKS
NO

SEA FREIGHT
WEIGHT
TO BE INSERTED ON A PER LINE BASIS

USD 45.99
2.85%

44.6500
3.00%
45.9895
USD
USD
USD
USD
USD
USD 3,600.00
USD
USD 3,600.00

USD 408.00
USD 165.00
USD 240.00
USD
USD
USD 813.00

LOCAL DUTY TO BE INSERTED MANUALLY AS P


MUR LINE ITEM. ONLY TOTAL TO RECOGNISE BELO

MUR 1,400.00

MUR
MUR 9,150.00
MUR
MUR
MUR
MUR
MUR
MUR 1,400.00
MUR
MUR
MUR
MUR
MUR 33,000.00

MUR 44,950.00

10.0000% 10.0000%
0.1375% 0.1375%
0.0000% 0.0000%
0.3500%
Rs1,715.57
250.00

SPEEDFREIGHT LTD

COSTS PAID IN MUR


B1 - LOCAL CHARGES
C&F VALUE B2 - LOCAL DUTIES (MUR)
(FCY)
USD USD MUR

813.00

23,600.00 813.00
-

Rs1,085,352.20 Rs37,389.46 Rs0.00


Unit of Measure QUANTITY
Specific Remarks for Line
Notes
UNITS/PACKETS

EACH 3,000.00
EACH 25.00
EACH
EACH
EACH
EACH
EACH
EACH
EACH
EACH
3,025.00

COSTS PAID IN MUR


B1 - LOCAL CHARGES
C&F VALUE B2 - LOCAL DUTIES (MUR)
(FCY)
USD USD MUR

20,000.00 0.00
-

Rs893,600.00 Rs0.00 Rs0.00

Unit of Measure QUANTITY


Specific Remarks for Line
Notes
UNITS/PACKETS

0 EACH 3000
0 EACH 25
0 EACH 0
0 EACH 0
0 EACH 0
0 EACH 0
0 EACH 0
0 EACH 0
0 EACH 0
0 EACH 0

0.00 3,025.00
FINAL COSTING STAGE Drop Down List
08.01.2023
Manually Inserted
Not To Change

AGR

EXTAR FERT SDN BHD

12042

C121515
20,000.00
USD CORRECT
EXWORKS CORRECT
NO

SEA FREIGHT
WEIGHT
SERTED ON A PER LINE BASIS

44.68
2.85% A -VE SIGN = DEPRECIATION OF THE RUPEE TO THE DETRIMENT OF COROI

44.6800 To paste Copy Rate of MCB

44.6800
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
-100.00%
#DIV/0!
- -100.00%

-100.00%
-100.00%
-100.00%
#DIV/0!
#DIV/0!
- -100.00%

O BE INSERTED MANUALLY AS PER


NLY TOTAL TO RECOGNISE BELOW
#DIV/0!

#DIV/0!
-100.00%

650.00 #DIV/0!
9,150.00 0.00%
12,000.00 #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
1,400.00 0.00%
#DIV/0!
60,000.00 #DIV/0!
185,000.00 #DIV/0!
#DIV/0!
33,000.00 0.00%
#DIV/0!
301,200.00 570.08%

2,250.00

SPEEDFREIGHT LTD

COSTS PAID IN MUR


B3 - LOCAL CHARGES SUB TOTAL BEFORE
INSURANCE TOTAL COST
(MUR) INSURANCE
MUR MUR MUR MUR

Rs44,950.00 Rs1,167,691.66 Rs1,715.57 Rs1,169,407.23


Total Checked
Unit Price TOTAL VALUE

VOLUME WEIGHT

LTRS GRAMMS/KGS/TONS USD USD


50.00 360.00 1,080,000.00
25.00 80.00 2,000.00
-
-
-
-
-
-
-
-
0.00 75.00 440.00 1,082,000.00
Error

COSTS PAID IN MUR


B3 - LOCAL CHARGES SUB TOTAL BEFORE
INSURANCE TOTAL COST
(MUR) INSURANCE
MUR MUR MUR MUR

Rs301,200.00 Rs1,194,800.00 Rs2,250.00 Rs1,197,050.00


Total Checked

Unit Price TOTAL


VOLUME WEIGHT

LTRS GRAMMS/KGS/TONS USD USD


0 50 360.00 1,080,000.00
0 25 80.00 2,000.00
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -
0 0 - -

0.00 75.00 440.00 1,082,000.00


Error
IMENT OF COROI
Error
A - FOREIGN FREIGHT TOTAL C&F VALUE
B1 - LOCAL CHARGES
(FCY)

USD USD MUR MUR

2,400.00 1,082,400.00 49,779,034.80 24,926.31


1,200.00 3,200.00 147,166.40 12,463.15
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
3,600.00 1,085,600.00 49,926,201.20 37,389.46
Reconciled Error Error Reconciled

Error

A - FOREIGN FREIGHT TOTAL C&F VALUE


B1 - LOCAL CHARGES
(FCY)

USD USD MUR MUR

- 1,080,000.00 48,254,400.00 -
- 2,000.00 89,360.00 -
- 0.00 0.00 -
- 0.00 0.00 -
- 0.00 0.00 -
- 0.00 0.00 -
- 0.00 0.00 -
- 0.00 0.00 -
- 0.00 0.00 -
- 0.00 0.00 -

0.00 1,082,000.00 48,343,760.00 0.00


Reconciled Error Error Reconciled
SUB TOTAL
B3 - LOCAL
B2 - LOCAL DUTIES BEFORE INSURANCE
CHARGES (MUR)
INSURANCE

% MUR MUR MUR


MUR
0% 29,966.67 49,833,927.78 1,710.51
0% 14,983.33 174,612.89 5.06
0% - 0.00 -
0% - 0.00 -
0% - 0.00 -
0% - 0.00 -
0% - 0.00 -
0% - 0.00 -
0% - 0.00 -
0% - 0.00 -
0.00 44,950.00 50,008,540.66 1,715.57
Reconciled Reconciled Error Reconciled

SUB TOTAL
B3 - LOCAL
B2 - LOCAL DUTIES BEFORE INSURANCE
CHARGES (MUR)
INSURANCE

% MUR MUR MUR


MUR
0% 200,800.00 48,455,200.00 2,245.84
0% 100,400.00 189,760.00 4.16
0% - 0.00 -
0% - 0.00 -
0% - 0.00 -
0% - 0.00 -
0% - 0.00 -
0% - 0.00 -
0% - 0.00 -
0% - 0.00 -

0.00 0.00 301,200.00 48,644,960.00 2,250.00


Reconciled Reconciled Error Reconciled

303,450.00
6791.62936436885
TOTAL COST COST PER UNIT OF SALES VAT TYPE

BASIS OF
MUR MUR
MEASURE
49,835,638.28 QUANTITY 16,611.88 TAXABLE - 15%
174,617.94 QUANTITY 6,984.72 TAXABLE - 15%
0.00 #N/A
0.00 #N/A
0.00 #N/A
0.00 #N/A
0.00 #N/A
0.00 #N/A
0.00 #N/A
0.00 #N/A
50,010,256.23
Error

TOTAL COST COST PER UNIT OF SALES VAT TYPE

BASIS OF
MUR MUR
MEASURE
48,457,445.84 QUANTITY 16,152.48
189,764.16 QUANTITY 7,590.57
0.00 #N/A
0.00 #N/A
0.00 #N/A
0.00 #N/A
0.00 #N/A
0.00 #N/A
0.00 #N/A
0.00 #N/A

48,647,210.00
Error
MARK UP SELLING PRICE PER UNIT OF
MEASURE

%
MUR ROUNDED
24,700.00 24,700.00
6,984.72 7,000.00
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A

MARK UP SELLING PRICE PER UNIT OF MARK UP


MEASURE VAR %

%
MUR
ROUNDED
52.92% 24,700.00 24,700.00 #DIV/0!
-7.98% 6,984.72 7,000.00 #DIV/0!
#N/A #N/A #N/A
#N/A #N/A #N/A
#N/A #N/A #N/A
#N/A #N/A #N/A
#N/A #N/A #N/A
#N/A #N/A #N/A
#N/A #N/A #N/A
#N/A #N/A #N/A
COPY QUOTE.ETC
1 DEPARTMENTS
AGR
CHE
CHR
CLN
PES
SCHR
SGAR
SCLN

2 INCOTERMS
EXWORKS
FCA Rehaz to
FOB insert
CFR definitions
CIF

3 FOREX
USD
SEK
RND
MUR
JPY
EUR

4 % DUTY
0%
5%
10%
15%
30%

5 INVOICE
N/A
QUOTATION
PRO FORMA

6 MODE OF SHIPMENT
SEA FREIGHT
AIR FREIGHT
COURRIER

7 GROUPAGE
YES
NO

8 UNIT OF MEASURE
LTRS
EACH
TONS
GRAMMS
PACKETS
KGS

6 COSTS APPORTIONMENT
VALUE
QUANTITY
VOLUME
WEIGHT

7 BASIS OF UNIT CALCULATION


QUANTITY
VOLUME
WEIGHT

8 VAT TYPE
TAXABLE - 15%
ZERO RATED - 0%
EXEMPT
EXWORKS FCA
Is an international trade The Free Carrier (FCA) Incoterms
term that describes 2020 Rule pushes the responsibility
when a seller makes a of delivering the goods to the buyers
product available at a nominated premises onto the seller,
designated location, and so they have to organise shipping
the buyer of the product and various export documents,
Definition must cover all costs contrary to Ex Works.
from warehouse to
warehouse

All overseas costs from All overseas & local costs, duties &
COSTS TO CONSIDER supplier's warehouse to taxes (except transport from
OVER AND ABOVE buyer's warehouse+all Supplier's warehouse till our
SUPPLIERS local charges including nominated FFWDR)
QUOTE/INVOICE duties & taxes
GROUP 1= Incoterms that apply to any mode of transpo
CPT CIP DAT
Incoterms CPT is In Carriage and Insurance Delivered At Terminal means, that the
short for "Carriage Paid To (CIP), the seller seller of a product delivers it to a previously
Paid To." Under CPT assumes all risk until the specified terminal. Until then he has to
incoterm , the seller goods are delivered to the shoulder the full costs and the risk of
clears the goods and first carrier at the place of transport. The means of transport are not
arranges carriage to shipment—not the place of specified by DAT. "Terminal" describes the
the named place of destination. Once the goods destination that buyer and seller must agree
destination. are delivered to the first upon. That can be not only an airfreight
carrier, the buyer is terminal, but a train terminal, a wharf or a
responsible for all risks. warehouse as well.

Local charges, Local charges, duties & taxes Freight-Local charges, duties & taxes
duties & taxes
ny mode of transport
DAP DDP
Under the Delivered At DDP Incoterms® (or Delivered Duty
Place (DAP) Incoterms rules, Paid shipping) means that the seller
the seller is responsible for bears all the costs and risks involved
delivery of the goods, ready for in bringing the goods to the place of
unloading, at the named place destination and has an obligation to
of destination. The seller clear the goods not only for export
assumes all risks involved up but also for import, to pay any duty
to unloading. Unloading is at for both export and import and to
the buyer's risk and cost. carry out all customs ...

Local charges None


FOB CFR CIF
“Free on board” is what FOB
stands for. It is a designation
which indicated that the liability
and ownership of the goods
have been transferred from a
seller to a buyer. This means
that if the goods get damaged
or destroyed during the
shipping, the seller is not liable.

Freight & local charges

You might also like