Scribd
Upload
2 views4 pages

Customer Batch Quantity Analysis Report

The document contains sales data for 4 customers including quantities, currencies, prices, means, and standard deviations. It also includes calculations of total means, standard deviations, variances, expected profits, and percentages. Formulas for variances and their additive property are also presented.

Uploaded by

Aniket Sabale
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
2 views4 pages

Customer Batch Quantity Analysis Report

The document contains sales data for 4 customers including quantities, currencies, prices, means, and standard deviations. It also includes calculations of total means, standard deviations, variances, expected profits, and percentages. Formulas for variances and their additive property are also presented.

Uploaded by

Aniket Sabale
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

Customer Batch Quantity Currency Selling Price/Unit Mean Standard Deviation

1 12 P 57810 $1.41000 $0.04100


2 8Y 8640540 $0.00904 $0.00045
3 5E 97800 $0.82400 $0.03420
4 2R 4015000 $0.02110 $0.00083
Average
Total

Mean $2,175,398.05 2250000


SD 45832.99 2150000
VR 2100663074.53154

z 1.6276910013 z

94.82% 5.18% 28.97%

($2,100,002.78) 2150000 $49,997.22

Expected Profit $25,398.05

1.9685453045
Mean Revenue Variances Square of Quantity SP^2 Total Variance
$978,145.20 $0.001681 $144 3341996100 808976943.95
$624,883.85 $0.000000 $64 74658931491600 967579752.131
$402,936.00 $0.001170 $25 9564840000 279685486.44
$169,433.00 $0.000001 $4 1.6120225E+13 44420892.01
$543,849.51
$2,175,398.05 VR 2100663074.53
SD 45832.99

-0.5541434714

71.03%
Learn: Additive Property of
Variances
X2-X1<=0

You might also like