学习任务8-1Excel在混合成本费用分解计算中的应用.xlsxVIP免费

维修费用分解计算模型月份机器工时维修费156101258105376111470106571107670105779113886121990123109112411921251295126∑相关系数固定成本变动率变动成本月机器工作时数yxyx2y2rabxbx维修费用分解计算模型月份机器工时维修费15610156563136102012581056090336411025376111843657761232147010674204900112365711077597504111449670105735049001102577911389276241127698861211040673961464199012311070810015129109112411284828115376119212511500846415625129512611970902515876∑934136710770674624156673相关系数0.966990920078861固定成本61.110323361577变动率0.67845408957288656变动成本37.9934290160816月机器工作时数yxyx2y2rabxbx维修费用分解计算模型月份机器工时维修费156101258105376111470106571107670105779113886121990123109112411921251295126∑相关系数0.966990920078861固定成本61.110323361577变动率0.67845408957288656变动成本37.9934290160816月机器工作时数yxyx2y2rabxbx