帐面库存金额根据资金占用推算的库实际库存占用资金（万）市内库52861255135286125513供配库8722422287224222分公司库存1340345763224411155合计7498634311938274089010月11日帐面库存量成车金额成车数量应收帐款固定投资银行存款促销收入经销商预收嘉陵股份曲靖7,071,182.3116421488397.063528714792900长春3,332,887.5014311026621.3416651878750205102035271哈尔滨3,881,075.201416630645109359.929577711259921938050.3兰州4,601,401.5613269385418.150000辽宁4,371,112.7813170263037212691.20601885.77合肥4,317,300.0010683706313.180000昆明3,839,136.72923582065009111000杭州1,175,159.00526109897.54947860630661655299.21301016.4南昌1,546,241.20515920629.18178639692211419822130怀来1,303,567.9136750361.09012896030608780.7新疆1,270,265.543491231461.0870818514353900山东829,986.303302166220884019.96082481518914.8太原1,194,537.502493445460151848125914.50重庆846,387.342471378478.050129849817879490西安826,974.19228815426.630390391533393.20石家庄320,333.3610400000湘潭164,777.78351138708164821416461529.90川西996,160.913286247355.432109913514810669696南海224,177.7910000000常州3,648,634.389026540190111097.7522047.40成都1069635.5371596000武汉0268289.60155691.63合计45,761,299.271340329971761.2320081314098106107647056829306.6111550000库存金额81873332库存单车价格3414.258平均单价3414.25794747445由库存金额推23982根据流动资32244帐面库存量13404两者差18841差额10578分公司资金结构资金来源分公司促销收入经销商预收嘉陵股份固定投资银行存款应收帐款武汉0155691.60268289.62000.12000.22000.32000.42000.52000.62000.72000.8总结存8622480177760658516572540654678271265319计划依据的库存要货计划6470087500456504310040500437505950049050各月实际销5181739682453943418944101501325288751121赵预测的销90924107677617156826553040492178221254369按照目标制7268065000650006600050000620006470061900赵预测销量75%171%36%100%20%-2%55%6%官预测销量40%64%43%93%13%24%22%21%销售预测标43%提高销售预测准确率可以降低安全库存水平销售预测标安全库存0.21.97平均0.2629680.32.95标准误差0.1612880.434.23中值0.202694模式#N/A标准偏差0.426729样本方差0.182098峰值0.494558偏斜度0.583369区域1.314616最小值-0.31792最大值0.996695求和1.840776计数70.394659求和1.840776计数70.394659假设赵预测下月的销售量为X，X=总库存+生产计划-60000行1置信度(95.0%)置信度(95.0%)销售单价销量销售收入销售毛利变动后毛利推算成本JH50QT-94703.2866640757931.22%4.62%4609.1362108.83JH70I(146)2408.061310331552810.1812%14.35%2119.0931299.39JH70I(134)2702.461815449060458.8416%18.25%2270.0661318.05JH70I.II2451.1364291157585598.8312%14.27%2156.9941336.25JH90A2830.91211234287860.810%12.41%2547.811495.233417.0961138208914048.4211%13.38%3041.211503.953145.442097665978749.4412%14.18%2767.9871872.02JH1253615.232279782416398.317%9.49%3362.1641907.683948.053942015563213112%14.32%3474.2842060.383796.321517457605359.687%9.49%3530.5781853.96JH125G5346.33301016092453.32%4.63%5239.4032248.264271.51376016060877.617%19.22%3545.3531840.46282601915944677.6136956275商品销售利润表3474.284数据来源：嘉陵集团股份有限公司销售分公司1.68654563型号销售单价销售公司成本毛利销量调整后成本JH125DB-12945831813.4628.06%35833297.2JH125T-313674549526.93%20049990.90909JH125G5346.332284.2622.32%30104153.2JH150(111)4271.511840.4621.66%37603346.29091JL125DA-130C4222.851866.8619.62%81823394.29091JH70III(134)2753.951243.1617.93%88922260.29091JH125F4246.091957.0716.20%34653558.309093417.091639.3212.77%611382980.581823796.321853.9611.21%151743370.83636JH70III2545.381261.04...
