【某品牌】成本核算公式

1、,項目,銷售預(yù)估,成本（元）,提點(diǎn),運(yùn)費(fèi)成本（元）,坑1,坑2,47700,20000,case1,case2,case3,定價,實(shí)際成本,利潤,定價,實(shí)際成本,利潤,定價,實(shí)際成本,利潤,定價,實(shí)際成本,利潤,定價,實(shí)際成本,利潤,定價,實(shí)際成本,利潤基本預(yù)計,1500,45,8%,9,79.0 ,92.1 ,(19,680),99.0 ,93.7 ,7,920 ,109.0 ,94.5 ,21,720 ,89.0 ,74.5 ,21,820 ,99.0 ,75.3 ,35,620 ,109.0 ,76.1 ,49,420 預(yù)測,2000,45,8%,9,79.0 ,84.2 ,(10,34

2、0),99.0 ,85.8 ,26,460 ,109.0 ,86.6 ,44,860 ,89.0 ,71.1 ,35,760 ,99.0 ,71.9 ,54,160 ,109.0 ,72.7 ,72,560 ,2500,45,8%,9,79.0 ,79.4 ,(1,000),99.0 ,81.0 ,45,000 ,109.0 ,81.8 ,68,000 ,89.0 ,69.1 ,49,700 ,99.0 ,69.9 ,72,700 ,109.0 ,70.7 ,95,700 ,3000,45,8%,9,79.0 ,76.2 ,8,340 ,99.0 ,77.8 ,63,540 ,109.0 ,7

3、8.6 ,91,140 ,89.0 ,67.8 ,63,640 ,99.0 ,68.6 ,91,240 ,109.0 ,69.4 ,118,840 ,3500,45,8%,9,79.0 ,73.9 ,17,680 ,99.0 ,75.5 ,82,080 ,109.0 ,76.3 ,114,280 ,89.0 ,66.8 ,77,580 ,99.0 ,67.6 ,109,780 ,109.0 ,68.4 ,141,980 ,4000,45,8%,9,79.0 ,72.2 ,27,020 ,99.0 ,73.8 ,100,620 ,109.0 ,74.6 ,137,420 ,89.0 ,66.1

4、,91,520 ,99.0 ,66.9 ,128,320 ,109.0 ,67.7 ,165,120 ,5000,45,8%,9,79.0 ,69.9 ,45,700 ,99.0 ,71.5 ,137,700 ,109.0 ,72.3 ,183,700 ,89.0 ,65.1 ,119,400 ,99.0 ,65.9 ,165,400 ,109.0 ,66.7 ,211,400 ,6000,45,8%,9,79.0 ,68.3 ,64,380 ,100.0 ,70.0 ,180,300 ,109.0 ,70.7 ,229,980 ,89.0 ,64.5 ,147,280 ,99.0 ,65.3 ,202,480 ,109.0 ,66.1 ,257,680 ,10000,45,8%,9,79.0 ,65.1 ,139,100 ,99.0 ,66.7 ,323,100 ,109.0 ,67.5 ,415