Two files are attached. One is in microsoft word, and the other is excel. This is a project. The details of how to do this project is in the word document. According to the word document, requirement 1 and 3 are done in excel. And requirement 2 are done in word document. Thank You

Revenues Cost of goods sold Variable Fixed Gross Margin Marketing Costs Commissions Fixed Costs Operating Income Jaguar Corporation Income Statement For the Year Ended December 31, 2012 Using Sales Agents Using Own Sales Force $26,000,000 $26,000,000 $11,700,000 2,870,000 $ 4,680,000 3,420,000 14,570,000 11,430,000 8,100,000 $ 3,330,000 $11,700,000 2,870,000 $ 2,600,000 5,500,000 14,570,000 11,430,000 8,100,000 $ 3,330,000