05%9.98%22.01%8%-49.05%-36.79%-24.53%-12.27%-0.01%12.25%24.51%9%-47.91%-35.42%-22.94%-10.45%2.04%14.52%27.01%10%-46.77%-34.06%-21.35%-8.63%4.08%16.80%29.51%说明:当销量、单价、单位变动成本、固定成本变动时,利润会发生如何变化本案例应用到了模拟运算、条件格式、窗体等excel基本功能。学员可就此案例举一反三,应用到实际的成本核算、价格谈判等工作领域20%30%40%50%-12.32%-4.15%4.01%12.18%-9.60%-1.20%7.20%15.59%-6.87%1.75%10.38%19.00%说明:-4.14%4.71%13.56%22.41%灰色区域代表销量变化百分比-1.41%7.66%16.74%25.82%绿色区域代表单价变化百分比1.31%10.62%19.92%29.23%黄色区域代表利润增长率4.04%13.57%23.10%32.64%6.77%16.53%26.29%36.05%9.50%19.48%29.47%39.45%12.22%22.44%32.65%42.86%14.95%25.39%35.83%46.27%17.68%28.35%39.01%49.68%20.40%31.30%42.20%53.09%23.13%34.25%45.38%56.50%25.86%37.21%48.56%59.91%28.59%40.16%51.74%63.32%31.31%43.12%54.92%66.73%34.04%46.07%58.10%70.14%36.77%49.03%61.29%73.55%39.50%51.98%64.47%76.95%42.22%54.94%67.65%80.36%
全文预览
