{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Comp. Contribution Analysis"],"not_rendered":{"defined_names":21,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Comp. Contribution Analysis","index":0,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[17,1,17,8]]}
[]
[]
[null,"Comparative Contribution Income Statement"]
[null,"For the Years 2005 through 2009"]
[]
[{"$nulls":4},2005,{"$f":"IF(E6,E6+1,\"\")","v":2006},{"$f":"IF(SUM(F6),F6+1,\"\")","v":2007},{"$f":"IF(SUM(G6),G6+1,\"\")","v":2008},{"$f":"IF(SUM(H6),H6+1,\"\")","v":2009}]
[null,"Total Sales",null,null,{"v":726000,"d":"$726,000"},{"v":726000,"d":"$726,000"},{"v":726000,"d":"$726,000"},{"v":726000,"d":"$726,000"},{"v":726000,"d":"$726,000"}]
[null,"Less: Variable Production Costs",null,null,{"v":290400,"d":"$290,400"},{"v":290400,"d":"$290,400"},{"v":290400,"d":"$290,400"},{"v":290400,"d":"$290,400"},{"v":290400,"d":"$290,400"}]
[null,"Less: Variable Selling Costs",null,null,{"v":184800,"d":"184,800 "},{"v":184800,"d":"184,800 "},{"v":184800,"d":"184,800 "},{"v":184800,"d":"184,800 "},{"v":184800,"d":"184,800 "}]
[null,"Total Variable Costs",null,null,{"$f":"IF(SUM(E8:E9),SUM(E8:E9),\"\")","v":{"v":475200,"d":"475,200 "}},{"$f":"IF(SUM(F8:F9),SUM(F8:F9),\"\")","v":{"v":475200,"d":"475,200 "}},{"$f":"IF(SUM(G8:G9),SUM(G8:G9),\"\")","v":{"v":475200,"d":"475,200 "}},{"$f":"IF(SUM(H8:H9),SUM(H8:H9),\"\")","v":{"v":475200,"d":"475,200 "}},{"$f":"IF(SUM(I8:I9),SUM(I8:I9),\"\")","v":{"v":475200,"d":"475,200 "}}]
[null,"Contribution Margin",null,null,{"$f":"IF(SUM(E7,E10),E7-E10,\"\")","v":{"v":250800,"d":"$250,800"}},{"$f":"IF(SUM(F7,F10),F7-F10,\"\")","v":{"v":250800,"d":"$250,800"}},{"$f":"IF(SUM(G7,G10),G7-G10,\"\")","v":{"v":250800,"d":"$250,800"}},{"$f":"IF(SUM(H7,H10),H7-H10,\"\")","v":{"v":250800,"d":"$250,800"}},{"$f":"IF(SUM(I7,I10),I7-I10,\"\")","v":{"v":250800,"d":"$250,800"}}]
[null,"Less: Fixed Production Costs",null,null,{"v":130500,"d":"$130,500"},{"v":130500,"d":"$130,500"},{"v":130500,"d":"$130,500"},{"v":130500,"d":"$130,500"},{"v":130500,"d":"$130,500"}]
[null,"Less: Fixed Selling and Administrative Costs",null,null,{"v":48200,"d":"48,200 "},{"v":48200,"d":"48,200 "},{"v":48200,"d":"48,200 "},{"v":48200,"d":"48,200 "},{"v":48200,"d":"48,200 "}]
[null,"Total Fixed Costs",null,null,{"$f":"IF(SUM(E12:E13),SUM(E12:E13),\"\")","v":{"v":178700,"d":"178,700 "}},{"$f":"IF(SUM(F12:F13),SUM(F12:F13),\"\")","v":{"v":178700,"d":"178,700 "}},{"$f":"IF(SUM(G12:G13),SUM(G12:G13),\"\")","v":{"v":178700,"d":"178,700 "}},{"$f":"IF(SUM(H12:H13),SUM(H12:H13),\"\")","v":{"v":178700,"d":"178,700 "}},{"$f":"IF(SUM(I12:I13),SUM(I12:I13),\"\")","v":{"v":178700,"d":"178,700 "}}]
[null,"Income Before Taxes",null,null,{"$f":"IF(SUM(E14),E11-E14,\"\")","v":{"v":72100,"d":"$72,100"}},{"$f":"IF(SUM(F14),F11-F14,\"\")","v":{"v":72100,"d":"$72,100"}},{"$f":"IF(SUM(G14),G11-G14,\"\")","v":{"v":72100,"d":"$72,100"}},{"$f":"IF(SUM(H14),H11-H14,\"\")","v":{"v":72100,"d":"$72,100"}},{"$f":"IF(SUM(I14),I11-I14,\"\")","v":{"v":72100,"d":"$72,100"}}]