Decimal Place Difference (I Guess)

[shah0101]

Hi Excel Experts,

Problem is when I calculate the Garment price with Quantity which is: $15.60 x 1,103 = $17,206.80 but when break the contents of the garment the total value changes to $16,684.21 which brings the total difference of $342.59.

The fabric and other accessories has to be calculated with its consumption in meters or kg or pieces.

Here is the link to the file:
Garment Cost Sheet

Thanks in advance.

 

[Alex Blakenburg]

The decimal difference is only about $ 1.76. The rest of the difference is that you have 3 items with a "Net Cons" = 2 (Column F)
In column W "Factory - R.M. QTY REQ" you are factoring that in and have * Column F.
The equivalent column P "Eastern - R.M. QTY REQ does not factor that in so its only using 1 unit instead of 2.

Book4
	A	B	C	D	E
3	Sl No.	Fabric Description	Net Cons ( in kg )	Type	Difference
4	6	POCKET ZIPPER	2	Eastern	-$227.22
5	7	SLEEVE HD PRINT STICKER	2	Factory	$0.00
6	8	neck tape+CF tape	2	Eastern	-$113.61
7
8					-$340.83
9
10		Rounding difference			-$1.76
11
12					-$342.59
Sheet1

Cell Formulas
Range	Formula
E8,E12	E8	=SUM(E4:E7)

 

[shah0101]

The decimal difference is only about $ 1.76. The rest of the difference is that you have 3 items with a "Net Cons" = 2 (Column F)
In column W "Factory - R.M. QTY REQ" you are factoring that in and have * Column F.
The equivalent column P "Eastern - R.M. QTY REQ does not factor that in so its only using 1 unit instead of 2.

Book4
	A	B	C	D	E
3	Sl No.	Fabric Description	Net Cons ( in kg )	Type	Difference
4	6	POCKET ZIPPER	2	Eastern	-$227.22
5	7	SLEEVE HD PRINT STICKER	2	Factory	$0.00
6	8	neck tape+CF tape	2	Eastern	-$113.61
7
8					-$340.83
9
10		Rounding difference			-$1.76
11
12					-$342.59
Sheet1

Cell Formulas
Range	Formula
E8,E12	E8	=SUM(E4:E7)

Thanks

 

[Alex Blakenburg]

No problem.