Per Unit:
Selling Price		$ 100.00
Variable Costs		$ 75.00
Total Fixed Costs		$ 800,000	per Quarter	NOTE: Fixed Costs Include $150,000 for Advertising (before increase)
Investment in Assets		$ 20,000,000	Total for the Year
		Q1	Q2	Q3	Q4
# of units produced and sold		50,000	55,000	57,000	60,000
NOTE: Return on Investment (ROI) is calculated as follows:
ROI = Operating Income/Investment in Assets (2 decimals)

2) Spreadsheet Engineering (20 marks)

Create a decision support spreadsheet (DSS) based on the information above and the Influence Chart created in Requirement 1. While constructing the spreadsheet ensure that you follow the guidelines isolate inputs and calculations, organize data clearly, and make the results clear. Your sheet can be structured as you please, as long as it is clear, user friendly, and effective. (20 marks)