面包店成本核算表教学文案.xls

9月单品统计合并报表序号 数量品 名加工间出货销售朝贵宾数 商贵宾数 朝阳现数报废1培根芝士吐司105632711402金牌吐司11078331071006613金砖吐司114741816514核桃(吐司）13111378215木糖醇吐司4233712920306椰奶吐司2121554310407鲜奶吐司135981916118提子吐司10688134019丹麦红豆吐司38333922183110紫米蜜豆吐司128902783011紫薯豆沙吐司1391002412312红豆巴布罗1501073265013龙背吐司1168619101014全麦核桃提子15211816151215甘那红豆464350721129216法式奶棒8969884017丹麦麻花1127711150918丹麦菠萝蜜18013912223419塔肠面包2121000020摩卡面包79611250121香蒜芝士条1157520911022雪域圣堡15812914114023玉米热狗17512902202424辣味肉松宝宝1731475200125原味肉松宝宝17013418170126热狗2302064146027三味包172109271119628花生面包1147321317029圆舞曲1851491687530番茄芝士1791211221121331匈牙利培根198149151516332法式香蒜条124101864533软香蒜1251031272134墨西哥1921492499135红豆思语19314921716036豆沙包269207411110037抹茶相思豆2111492412151138丹麦牛角257199222312139杂粮面包114968100040香蒜热狗小面包185147101301541甜甜圈11591009396642342丹麦包17000043树根面包126000644花式面包85000045椰子面包3502990005146椰蓉包5945530004147荞麦列巴4103520205648荞麦无糖列巴2442250201749乳酪吐司9269203050全麦吐司5344801516寸蛋糕12528寸蛋糕115310寸蛋糕25412寸蛋糕2全价总额7折朝数7折金额 商销售额朝现金收入1510.531283.59454201510.51731123.51249569311510.523189111052.51128.4958.8135616.81128.432243.6445225.20107473011550280128.420159.611768.411071391880011072515433902111073018990021096.327151.290018.910737224107035096.320119.77746.301071711211807232.1101151.2105060.9274.91239.248319.6064.21146.24620964.21550.483412.6464.2001260064.21250.43660164.2318445046.2053.5184964514053.50064502453.5517.57350153.518636700153.51014103021053.54694.554566.5653.53873.536559.503.52.452339.2521.517.1554.53.152437.8544.537.8134.53.153147.25670.550.434.53.151225.2454.512.654.53.151437.8463.56.3142.83367.259625.213.52.453751.45521.539.203.52.4551100.45724.524.503.52.453958.8521.536.751132.13446.259725.2185.6844.8768002.51.751017.5367.501542.881109.24036117.631.380.96600001747.233.0400283.2061.2740.89180000850.980.68600293.020511.3720.960400758.716041128.4004224056128.4002700017128.42016882801090440078009360118001298014800296018800376063803.4401668.19月成本核算表序序号号 品品 名名重重量量/个个销销售售总总数数总总重重量量成成本本/个个包包装装成成本本已已售售原原材材料料成成本本单单价价 总总价价朝朝数数 朝朝成成贵贵宾宾卡卡收收入入大大贵贵数数贵贵宾宾卡卡成成本本材材料料成成本本合合计计单单位位人人工工人人工工成成本本成成本本合合计计朝朝收收（卡卡+现现）1培根芝士吐司2金牌吐司3金砖吐司4核桃(吐司）5木糖醇吐司6椰奶吐司7鲜奶吐司8提子吐司9丹麦红豆吐司10紫米蜜豆吐司11 紫薯豆沙吐司12红豆巴布罗13龙背吐司14全麦核桃提子15甘那红豆16法式奶棒17丹麦麻花18丹麦菠萝蜜19塔肠面包20摩卡面包21香蒜芝士条22雪域圣堡23玉米热狗24辣味肉松宝宝25原味肉松宝宝26热狗27三味包28花生面包29圆舞曲30番茄芝士31匈牙利培根32法式香蒜条33软香蒜34墨西哥35红豆思语36豆沙包37抹茶相思豆38丹麦牛角39杂粮面包40香蒜热狗小面包41甜甜圈42丹麦包43树根面包44花式面包45椰子面包46椰蓉包47荞麦列巴48荞麦无糖列巴49乳酪吐司50全麦吐司516寸蛋糕528寸蛋糕5310寸蛋糕5412寸蛋糕报报废废报报废废成成本本收收入入合合计计