dt = New Table( "Sales Model" );
dt << New Column( "Unit Sales", Values( {1000, 2000} ) );
dt << New Column( "Unit Price", Values( {2, 4} ) );
dt << New Column( "Unit Cost", Values( {2, 2.5} ) );
dt << New Column( "Revenue",
Formula( :Unit Sales * :Unit Price )
);
dt << New Column( "Total Cost",
Formula( :Unit Sales * :Unit Cost + 1200 )
);
dt << New Column( "Profit",
Formula( :Revenue - :Total Cost ),
Set Property( "Spec Limits", {LSL( 0 )} )
);
Profiler(
Y( :Revenue, :Total Cost, :Profit ),
Objective Formula( Profit )
);
它显示我们不太可能盈利。通过对利润设置为零的下规格限,缺陷报表显示不盈利的概率为 62%。
因此,我们将单价提高到 3.25 美元并重新运行模拟。现在不盈利的概率下降到约为 20%。