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

{"sheet":"Comparative Contribution Income","index":0,"n_rows":17,"n_cols":10,"rows_kept":17,"merged":[[18,2,18,9]]}
[]
[]
[]
[null,null,"Comparative Contribution Income Statement"]
[null,null,"For the Years 2005 through 2009"]
[]
[{"$nulls":5},2005,{"$f":"IF(F7,F7+1,\"\")","v":2006},{"$f":"IF(SUM(G7),G7+1,\"\")","v":2007},{"$f":"IF(SUM(H7),H7+1,\"\")","v":2008},{"$f":"IF(SUM(I7),I7+1,\"\")","v":2009}]
[null,null,"Total Sales",null,null,{"v":726000,"d":"$726,000"},{"v":826000,"d":"$826,000"},{"v":926000,"d":"$926,000"},{"v":1726000,"d":"$1,726,000"},{"v":1926000,"d":"$1,926,000"}]
[null,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,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,null,"Total Variable Costs",null,null,{"$f":"IF(SUM(F9:F10),SUM(F9:F10),\"\")","v":{"v":475200,"d":"$475,200"}},{"$f":"IF(SUM(G9:G10),SUM(G9:G10),\"\")","v":{"v":475200,"d":"$475,200"}},{"$f":"IF(SUM(H9:H10),SUM(H9:H10),\"\")","v":{"v":475200,"d":"$475,200"}},{"$f":"IF(SUM(I9:I10),SUM(I9:I10),\"\")","v":{"v":475200,"d":"$475,200"}},{"$f":"IF(SUM(J9:J10),SUM(J9:J10),\"\")","v":{"v":475200,"d":"$475,200"}}]
[null,null,"Contribution Margin",null,null,{"$f":"IF(SUM(F8,F11),F8-F11,\"\")","v":{"v":250800,"d":"$250,800"}},{"$f":"IF(SUM(G8,G11),G8-G11,\"\")","v":{"v":350800,"d":"$350,800"}},{"$f":"IF(SUM(H8,H11),H8-H11,\"\")","v":{"v":450800,"d":"$450,800"}},{"$f":"IF(SUM(I8,I11),I8-I11,\"\")","v":{"v":1250800,"d":"$1,250,800"}},{"$f":"IF(SUM(J8,J11),J8-J11,\"\")","v":{"v":1450800,"d":"$1,450,800"}}]
[null,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,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,null,"Total Fixed Costs",null,null,{"$f":"IF(SUM(F13:F14),SUM(F13:F14),\"\")","v":{"v":178700,"d":"$178,700"}},{"$f":"IF(SUM(G13:G14),SUM(G13:G14),\"\")","v":{"v":178700,"d":"$178,700"}},{"$f":"IF(SUM(H13:H14),SUM(H13:H14),\"\")","v":{"v":178700,"d":"$178,700"}},{"$f":"IF(SUM(I13:I14),SUM(I13:I14),\"\")","v":{"v":178700,"d":"$178,700"}},{"$f":"IF(SUM(J13:J14),SUM(J13:J14),\"\")","v":{"v":178700,"d":"$178,700"}}]
[null,null,"Income Before Taxes",null,null,{"$f":"IF(SUM(F15),F12-F15,\"\")","v":{"v":72100,"d":"$72,100"}},{"$f":"IF(SUM(G15),G12-G15,\"\")","v":{"v":172100,"d":"$172,100"}},{"$f":"IF(SUM(H15),H12-H15,\"\")","v":{"v":272100,"d":"$272,100"}},{"$f":"IF(SUM(I15),I12-I15,\"\")","v":{"v":1072100,"d":"$1,072,100"}},{"$f":"IF(SUM(J15),J12-J15,\"\")","v":{"v":1272100,"d":"$1,272,100"}}]
[null,null,"Break-Even",null,null,{"$f":"(F15/(F15+F16))*F8","v":{"v":517289.47368421056,"d":"$517,289"}},{"$f":"(G15/(G15+G16))*G8","v":{"v":420770.2394526796,"d":"$420,770"}},{"$f":"(H15/(H15+H16))*H8","v":{"v":367072.3158828749,"d":"$367,072"}},{"$f":"(I15/(I15+I16))*I8","v":{"v":246591.14166933164,"d":"$246,591"}},{"$f":"(J15/(J15+J16))*J8","v":{"v":237232.00992555832,"d":"$237,232"}}]