Excel HW 1 (Solution 2) Forecast Summary - Spatula City Forecase Income Statement 201 Q1 2012 Q2 2012 Sales $ 719,939 $ 697,009 Cost of Goods Sold $

Excel HW 1 (Solution 2) Forecast Summary - Spatula City...

  • Homework Help
  • AugustoRamirez
  • 3
  • 100% (1) 1 out of 1 people found this document helpful

This preview shows page 1 out of 3 pages.

You've reached the end of your free preview.

Want to read all 3 pages?

Unformatted text preview: Spatula City Forecase Income Statement 201 Q1 2012 Q2 2012 Sales $ 719,939 $ 697,009 Cost of Goods Sold $ 138,385 $ 127,738 Gross Margin 0.81 0.82 GM % 81% 82% Sales Expense $ 224,909 $ 222,460 Marketing Expense $ 70,000 $ 70,000 G&A Expense $ 102,500 $ 102,500 Total Operating Expense $ 397,409 $ 394,960 Net Income $ 184,146 $ 174,310 Spatula City ase Income Statement 2012 Q3 2012 $ 706,504 $ 134,042 0.81 81% $ 224,020 $ 70,000 $ 102,500 $ 396,520 $ 175,941 Q4 2012 $ 730,078 $ 236,645 0.68 68% $ 379,036 $ 125,000 $ 182,500 $ 686,536 $ (193,104) Pie! 26% 25% 25% 24% $800,000 $600,000 $400,000 $200,000 $-­‐ Q1 2012 $(200,000) $(400,000) Q2 2012 Q3 2012 Q1 2012 Q2 2012 Q3 2012 Q4 2012 Sales Net Income Q4 2012 ...
View Full Document

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes