$$ Click the icon to view the newsvendor example spreadsheet.

The demand must be at least copies for the gasoline mini$-$mart to break even.

$($Type a whole number.$)$

Newsvendor model spreadsheet

The formula for the quantity sold is $=$MIN$($B$11,$B$12).$

The formula for the surplus quantity is $=$MAx$(0,B12-B11).$

The formula for the profit is $=B{14}^{**}B5-B{12}^{**}B6.$