各部門月銷售收入、成本及毛利分析工具（加權(quán)平均法）

,,,,,,,,,,,,,,,,,,,

,,2024年10月份各部門銷售基礎(chǔ)數(shù)據(jù)及加權(quán)平均單價(jià)計(jì)算表,,,,,,,,,,,,,,,,

,,注：本表格是本分析工具的基礎(chǔ)數(shù)據(jù)表，具體包括產(chǎn)品基本信息、加權(quán)平均單價(jià)計(jì)算以及各部門銷售數(shù)量，除了加權(quán)平均單價(jià)之外，其余的數(shù)據(jù)都需要手工錄入。（公司總計(jì)數(shù)據(jù)為自動(dòng)生成，其數(shù)據(jù)僅供參考）,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,

產(chǎn)品基本信息及加權(quán)平均單價(jià)計(jì)算,,,,,,,,,,,各部門銷售數(shù)量,,,,,,,溫馨提示：如果增添產(chǎn)品品種，請(qǐng)?jiān)?-19行之間插入行，然后需要為新增行設(shè)置自動(dòng)函數(shù)單元格（選中插入行上部單元格向下拖動(dòng)復(fù)制即可），設(shè)置好后就可以正常使用了。此操作目的是為了確保自動(dòng)分析表格中函數(shù)公式查找數(shù)據(jù)范圍有效。如果需要增添部門數(shù)量，請(qǐng)?jiān)贚列右側(cè)任意區(qū)域插入列，然后填入基礎(chǔ)數(shù)據(jù)即可，但是還需要設(shè)置公司總計(jì)行的自動(dòng)計(jì)算單元格（選中插入列左側(cè)帶函數(shù)公式單元格向右拖動(dòng)復(fù)制即可）。

產(chǎn)品編號(hào),產(chǎn)品類別,產(chǎn)品名稱,規(guī)格型號(hào),計(jì)量單位,期初庫存數(shù)量,期初庫存金額,本期進(jìn)貨訂單總數(shù),退貨數(shù)量（退給供應(yīng)商）,本期采購總成本（要求扣除退貨退款）,加權(quán)平均單價(jià),部門1,部門2,部門3,部門4,部門5,部門6,,

201603001,類別1,產(chǎn)品名稱1,1AA,個(gè),1200,"￥48,000.00",680,0,"￥23,200.00",￥37.87,200,679,380,200,300,400,,

201603002,類別1,產(chǎn)品名稱1,1AAA,個(gè),1000,"￥30,000.00",120,0,"￥3,600.00",￥30.00,201,680,381,201,301,401,,

201603003,類別1,產(chǎn)品名稱2,2BB,箱,890,"￥44,500.00",180,5,"￥5,250.00",￥46.71,202,681,382,202,302,402,,

201603004,類別1,產(chǎn)品名稱2,2BBB,件,2200,"￥88,000.00",400,20,"￥10,300.00",￥38.10,203,682,383,203,303,403,,

201603005,類別2,產(chǎn)品名稱3,3CC,個(gè),1520,"￥76,000.00",870,0,"￥23,000.00",￥41.42,204,683,384,204,304,404,,

201603006,類別2,產(chǎn)品名稱3,3CCC,,3000,"￥150,000.00",320,0,"￥12,800.00",￥49.04,205,684,385,120,305,405,,

201603007,類別2,產(chǎn)品名稱4,4DD,,300,"￥12,000.00",0,0,￥0.00,￥40.00,206,685,386,206,306,406,,

201603008,類別2,產(chǎn)品名稱4,4DDD,,400,"￥24,000.00",270,39,"￥8,100.00",￥50.87,207,686,387,180,307,407,,

201603009,類別3,產(chǎn)品名稱5,5EE,,1200,"￥48,000.00",450,0,"￥10,600.00",￥35.52,208,687,388,208,308,408,,

201603010,類別3,產(chǎn)品名稱5,5EEE,,1600,"￥64,000.00",410,0,"￥8,900.00",￥36.27,209,688,389,209,309,409,,

201603011,類別3,產(chǎn)品名稱6,6FF,,700,"￥21,000.00",640,0,"￥22,800.00",￥32.69,210,689,390,210,310,410,,

201603012,類別3,產(chǎn)品名稱6,6FFF,,600,"￥30,000.00",0,0,￥0.00,￥50.00,211,690,391,211,311,411,,

公司總計(jì),,,,,14610,"￥635,500.00",4340,64,"￥128,550.00",￥40.46,2466,8214,4626,2354,3666,4866,,

,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,

,