Excel HW 1 (Solution 2) 2012 Sales Forecast - Spatula City Salesperson Tim T Tom B Alex S Joe F Drew B Aaron R Eli M Taylor Y Base Salary Commission

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

This preview shows page 1 out of 1 page.

You've reached the end of your free preview.

Want to read the whole page?

Unformatted text preview: Spatula City Salesperson Tim T. Tom B. Alex S. Joe F. Drew B. Aaron R. Eli M. Taylor Y. Base Salary Commission Rate Year-­‐end bonus $ 50,000 10% $ 5,000 $ 85,000 15% $ 50,000 $ 55,000 9% $ 8,000 $ 65,000 9% $ 15,000 $ 90,000 12% $ 15,000 $ 87,500 15% $ 25,000 $ 75,000 12% $ 30,000 $ 50,000 9% $ 5,000 Unit Price Jan-­‐12 850 1870 1235 1250 1595 1860 1313 765 Feb-­‐12 999 1760 1045 1200 1815 2040 1523 1190 Mar-­‐12 1063 1870 1330 1600 1870 1800 1628 1020 Apr-­‐12 638 1980 1378 1000 1595 1920 998 1020 Forecasted Spatula Sales (Units) May-­‐12 Jun-­‐12 Jul-­‐12 850 850 797 1760 1870 1760 1330 1235 1140 1200 1300 1250 1760 1760 1650 1680 2040 1680 1313 1313 1208 1148 935 850 Aug-­‐12 850 1980 1045 1150 1650 1920 1313 808 Sep-­‐12 956 1870 1330 1400 1980 2280 1523 935 Oct-­‐12 1275 1870 1378 1200 2310 1920 1628 1020 Nov-­‐12 1381 1760 1140 1200 1760 2160 1785 1020 Dec-­‐12 1488 1760 1188 1500 1980 2400 1838 1105 $ 20.40 $ 21.60 $ 20.60 $ 20.90 $ 21.70 $ 21.00 $ 22.80 $ 19.20 $ 21.60 $ 20.40 $ 19.20 $ 18.00 Total Sales Cost of Sales Total Profit Year Profit Q1 $ 719,939.00 $ 224,908.60 $ 495,030.40 $ 1,803,103.18 Q2 $ 697,008.80 $ 222,460.49 $ 474,548.31 Q3 $ 706,503.60 $ 224,020.36 $ 482,483.24 Q4 $ 730,077.60 $ 379,036.37 $ 351,041.23 ...
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