項(xiàng)目成本與預(yù)算監(jiān)控表格

項(xiàng)目成本與預(yù)算監(jiān)控表格序號(hào)項(xiàng)目名稱預(yù)算金額（元）實(shí)際發(fā)生金額（元）金額差異（元）預(yù)算占比（%）實(shí)際占比（%）監(jiān)控狀態(tài)12345表格說明：項(xiàng)目名稱：填寫具體項(xiàng)目名稱。預(yù)算金額：填寫該項(xiàng)目預(yù)算金額。實(shí)際發(fā)生金額：填寫該項(xiàng)目實(shí)際發(fā)生金額。金額差異：計(jì)算預(yù)算金額與實(shí)際發(fā)生金額之間的差額。預(yù)算占比：計(jì)算項(xiàng)目預(yù)算金額占項(xiàng)目總預(yù)算的比例。實(shí)際占比：計(jì)算項(xiàng)目實(shí)際發(fā)生金額占項(xiàng)目總預(yù)算的比例。監(jiān)控狀態(tài)：根據(jù)項(xiàng)目預(yù)算與實(shí)際發(fā)生情況，填寫監(jiān)控狀態(tài)，如“正?！?、“預(yù)警”、“超標(biāo)”等。項(xiàng)目編號(hào)項(xiàng)目名稱預(yù)算編制日期預(yù)算金額（元）實(shí)際發(fā)生日期實(shí)際支出（元）差額（元）成本占比監(jiān)控等級(jí)001項(xiàng)目一2023010110000020230115500005000050%綠色002項(xiàng)目二20230101200000202301201200008000060%黃色003項(xiàng)目三20230101300000202301252500005000083%紅色004項(xiàng)目四20230101400000202302013500005000087.5%紅色005項(xiàng)目五20230101500000202302104500005000090%紅色表格說明：項(xiàng)目編號(hào)：項(xiàng)目的唯一標(biāo)識(shí)碼。項(xiàng)目名稱：項(xiàng)目的名稱。預(yù)算編制日期：項(xiàng)目預(yù)算的編制日期。預(yù)算金額：項(xiàng)目預(yù)算的總金額。實(shí)際發(fā)生日期：項(xiàng)目實(shí)際支出的日期。實(shí)際支出：項(xiàng)目實(shí)際支出的金額。差額：預(yù)算金額與實(shí)際支出金額之間的差額。成本占比：實(shí)際支出金額占預(yù)算金額的比例。監(jiān)控等級(jí)：根據(jù)實(shí)際支出與預(yù)算的差異，監(jiān)控項(xiàng)目的風(fēng)險(xiǎn)等級(jí)，分為綠色（正常）、黃色（預(yù)警）、紅色（超標(biāo)）。項(xiàng)目代碼項(xiàng)目名稱預(yù)算總額（元）預(yù)算單價(jià)（元）計(jì)劃數(shù)量實(shí)際數(shù)量金額預(yù)算金額實(shí)際預(yù)算執(zhí)行率P001項(xiàng)目1500001050004000500004000080%P002項(xiàng)目2800001550004500750006750090%P003項(xiàng)目3600001250003500600004200070%P004項(xiàng)目4700008500050004000050000100%P005項(xiàng)目5650001350004600650006020092%表格說明：項(xiàng)目代碼：項(xiàng)目的唯一標(biāo)識(shí)代碼。項(xiàng)目名稱：項(xiàng)目的具體名稱。預(yù)算總額：項(xiàng)目總預(yù)算金額。預(yù)算單價(jià)：每單位產(chǎn)品的預(yù)算價(jià)格。計(jì)劃數(shù)量：計(jì)劃執(zhí)行項(xiàng)目的數(shù)量。實(shí)際數(shù)量：實(shí)際完成項(xiàng)目的數(shù)量。金額預(yù)算：根據(jù)實(shí)際數(shù)量計(jì)算的