固定成本#######=$E$3+$E$4*C 单位可变成本¥1.55 单位售价¥3.10# Q C R0270,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,999in D8:8in C9:=E9/$E$5in E9:=D8in D9:=$E$3+$E$4*C9700,000C600,000R500,000400,000300,000200,000100,0000单位售价050,000100,000150,000200,000250,000确定Qe方法图1,200,000 C1,000,000 R800,000600,000400,000200,00000100,000200,000300,000400,000500,000 Q C' R'500,0001,045,000337,097792,5001,045,000255,645666,250792,500214,919603,125666,250194,556571,563603,125184,375555,781571,563179,284547,891555,781176,739543,945547,891位售价=¥3.10 销量,000600,000