收入成本分析模型
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
#######¥1.55in D8:=$E$3+$E$4*C 8in C9:=E9/$E$5¥3.10#in E9:=D8in D9:=$E$3+$E$4*C9 Q C R
0270,000087,097405,000270,000130,645472,500405,000152,419506,250472,500163,306523,125506,250168,750531,563523,125171,472535,781531,563172,833537,891535,781173,513538,945537,891173,853539,473538,945174,023539,736539,473174,108539,868539,736174,151539,934539,868174,172539,967539,934174,183539,984539,967174,188539,992539,984174,191539,996539,992174,192539,998539,996174,193539,999539,998174,193539,999539,999 固定成本 单位可变成本
单位售价单位售价0100,000200,000300,000400,000500,000600,000700,000050,000100,000150,000200,000250,000C R
Q C' R'
500,0001,045,000
337,097792,5001,045,000 255,645666,250792,500
214,919603,125666,250
194,556571,563603,125
184,375555,781571,563
179,284547,891555,781
176,739543,945547,891
¥3.10
位售价=