Answer:
1. MS Excel File is attached for the solution. Please find that.
2. Contribution income statement for the year
$
Sales (45000 x 16 ) 720,000
Less: Variable Cost (45,000 x 6) 270,000
Contribution Margin 450,000
Less: Fixed Cost 300,000
Net Income 150,000