Table

Organize

Format

Arrange

View

Window

Help

Project $1-$ CVP Excel K$1$hintpost

$125\%$

$$

O

Zoom

Add Category

Pivot Table

Insert

Table

Chart

Text

Shape

Media

Comment

View

Master Data

Analysis

A

B

C

D

F

$($II$)$

$\backslash$table$[[$Sales Price,,b$1$: Type in Sel$],[1600,,],[,,,,],[$Number of laptops produced and sold,$500,750,1000,],[],[$Variable costs,$322,500\mathrm{.}00,483,750,,$c$5$: Total VC$/$un$],[$Fixed costs per year,$157,500\mathrm{.}00,157,500,,$b$5$: $=$b$3*$c$10],[$Total costs,$480,000\mathrm{.}00,641,250,,$b$6$: $=$c$6],[,,,$b$7$: $=$b$5+$b$6],[$Cost per unit$],[$Variable cost per unit,$645\mathrm{.}00,645\mathrm{.}00,,],[$Fixed cost per unit,$315\mathrm{.}00,,,$b$11$: $=$b$6/$b$3],[$Total cost per unit,$960\mathrm{.}00,,,$b$12$: $=$b$10+$b$11],[],[],[,500,750,1000,],[],[$Sales revenue,$800,000\mathrm{.}00,1,200,000\mathrm{.}00,1,600,000\mathrm{.}00,$b$17$: $b$$1*$b$3],[$Variable costs,$322,500\mathrm{.}00,483,750\mathrm{.}00,1,600,000,,],[$Contribution margin,$477,500\mathrm{.}00,716,250\mathrm{.}00,1,600,000\mathrm{.}00,$b$19$: $=$b$17-$b$18],[$Fixed costs,$157,500\mathrm{.}00,157,500\mathrm{.}00,-,$b$20$: $=$b$6],[$Profits $($loss$),,558,750\mathrm{.}00,1,600,000\mathrm{.}00,]]$