智能化成本核算与管理 项目8-任务3-操作表格

甲产品2022年产品实际成本表,,,,,,,,,,,,,【案例8-3】

,,,,,,,,,,,单位：元,,

项目,1月,2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,

期初数,"1,136","1,214","1,773","1,189",969,811,"1,089","1,244",990,"1,317",990,760,

直接材料,"6,016","5,611","5,986","4,899","5,839","4,615","4,579","4,561","4,769","5,091","5,089","4,758",

直接人工,"6,875","6,768","5,728","5,776","5,696","6,115","6,632","5,742","5,703","5,767","7,089","7,302",

制造费用,"4,443","3,440","3,872","3,359","3,784","3,468","4,099","4,432","4,145","4,291","4,507","4,154",

生产成本合计,"17,334","15,819","15,586","14,034","15,319","14,198","15,310","14,735","14,617","15,149","16,685","16,214",

本期转出,"17,256","15,260","16,170","14,254","15,477","13,920","15,155","14,989","14,290","15,476","16,915","15,784",

期末数,"1,214","1,773","1,189",969,811,"1,089","1,244",990,"1,317",990,760,"1,190",

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

甲产品2022年产品计划成本表,,,,,,,,,,,,,

,,,,,,,,,,,单位：元,,

项目,1月,2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,

期初数,"1,136","1,436","1,736","1,936","1,636","1,636","2,136","1,636","1,936","1,936","2,936","3,136",

直接材料,"5,500","5,500","5,000","5,500","5,000","5,000","6,000","5,500","6,000","5,000","5,000","6,000",

直接人工,"6,800","6,800","7,200","7,200","6,000","6,500","6,500","6,800","6,000","6,000","7,200","7,200",

制造费用,"4,000","4,000","4,000","4,000","4,000","4,000","4,000","4,000","4,000","4,000","4,000","4,000",

生产成本合计,"16,300","16,300","16,200","16,700","15,000","15,500","16,500","16,300","16,000","15,000","16,200","17,200",

本期转出,"16,000","16,000","16,000","17,000","15,000","15,000","17,000","16,000","16,000","14,000","16,000","17,500",

期末数,"1,436","1,736","1,936","1,636","1,636","2,136","1,636","1,936","1,936","2,936","3,136","2,836",

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

甲产品2021年产品实际成本表,,,,,,,,,,,,,

,,,,,,,,,,,单位：元,,

项目,1月,2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,

期初数,985,"1,157",904,900,"1,257","1,003","1,471","1,044","1,193",441,"1,489","1,270",

直接材料,"5,174","5,575","4,884","5,899","5,182","4,881","6,063","5,438","6,046","4,740","4,813","5,968",

直接人工,"6,871","6,287","7,121","7,234","5,705","6,579","6,395","6,815","5,626","5,961","7,197","6,979",

制造费用,"4,039","4,060","3,875","4,152","4,235","3,790","4,060","3,616","3,687","4,037","3,692","4,222",

生产成本合计,"16,084","15,922","15,880","17,285","15,122","15,250","16,518","15,869","15,359","14,738","15,702","17,169",

本期转出,"15,912","16,175","15,884","16,928","15,376","14,782","16,945","15,720","16,111