Docstoc

Retail Selling Workbook

Document Sample
Retail Selling Workbook Powered By Docstoc
					Monthly PMT    Amount put in
years          Amount taken out
Months         Interest
Annual Rate
Monthly Rate
FV

PV
years
Months
Annual Rate
Monthly Rate
Monthly PMT
Your Name                 b4c18e3e-fa8b-4bd4-a167-bc5f7b94617b.xls - 1st Year Net Income                7/18/2011


                                               JB Smyth Publishers
            Book Title    Net Sales      Royalty Ex.    Manu. Ex.        Adm. Ex.          Net Income
            Book 1          4,123,489.00
            Book 2          2,275,546.50
            Book 3          1,678,925.75
            Total

                            Assumptions
            Royalty Ex.    Manu. Ex.     Adm. Ex.
                    16.25%        23.50%        20.00%




                                                   Page 2 of 6
Your Name                        b4c18e3e-fa8b-4bd4-a167-bc5f7b94617b.xls - Assumption Table Incorrect                              7/18/2011


                                                       Tommy's Auto Sales
                                                      Projected Net Income
                                                     First Six Months of 2005
                                 January      February    March       April       May         June        Totals
            Revenues              $ 50,000.00 $ 45,000.00 $ 52,780.00 $ 49,990.00 $ 57,920.00 $ 61,520.00 $ 317,210.00

            Operating Expenses                                                                                                -
            General Expenses                                                                                                  -
            Bonus                                                                                                             -
            Total Expenses               -             -             -             -             -             -              -
            Net Income           $ 50,000.00   $ 45,000.00   $ 52,780.00   $ 49,990.00   $ 57,920.00   $ 61,520.00   $ 317,210.00

                                  Assumptions Percentages
                                                                   Bonus
                                                        Bonus      Amount if
                                General     Target For Amount if   Target Not
            Operating Expenses Expenses     Bonus       Target Met Met
                            45%         20% $ 50,000.00 $ 5,000.00     $0




                                                               Page 3 of 6
Your Name                        b4c18e3e-fa8b-4bd4-a167-bc5f7b94617b.xls - Assumption Table Correct                                7/18/2011


                                                       Tommy's Auto Sales
                                                      Projected Net Income
                                                     Fisrt Six Months of 2005
                                 January      February    March       April       May         June        Totals
            Revenues              $ 50,000.00 $ 45,000.00 $ 52,780.00 $ 49,990.00 $ 57,920.00 $ 61,520.00 $ 317,210.00

            Opearting Expenses                                                                                                -
            General Expenses                                                                                                  -
            Bonus                                                                                                             -
            Total Expenses               -             -             -             -             -             -              -
            Net Income           $ 50,000.00   $ 45,000.00   $ 52,780.00   $ 49,990.00   $ 57,920.00   $ 61,520.00   $ 317,210.00

                Assumptions Percentages
            Opearting Expenses          45%
            General Expenses            20%
            Target For Bonus    $ 50,000.00
            Bonus Amount if
            Target Met          $ 5,000.00
            Bonus Amount if
            Target Not Met           $0




                                                               Page 4 of 6
             T-Do's Accounting
             Income Statement
      For the Month Ended 2/27/2006
Revenue                    $ 50,000.00
Expenses                   $ 10,000.00
Net Income                 $ 40,000.00
                                         Account (Must Balance)
                                               500            500
                                               100            100
                                                 50             50   In Balance?
Relative Cell References                    b4c18e3e-fa8b-4bd4-a167-bc5f7b94617b.xls, Price Schedule                           Mixed Cell References



                                  Mortimer's Furniture Price Schedule by Margins
                                       Wholesale     Retail Selling Price by Margin      Profit on   Profit on     Profit on
                          Items          Cost           50%            55%         60%     50%         55%           60%
                      Sofa               $275.00     $550.00       $611.11     $687.50     $275.00     $336.11       $412.50
                      Lamp                125.00      250.00        277.78      312.50      125.00      152.78        187.50
                      End Table           225.00      450.00        500.00      562.50      225.00      275.00        337.50
                      Chair               215.00      430.00        477.78      537.50      215.00      262.78        322.50
                      Rug                 425.00      850.00        944.44    1,062.50      425.00      519.44        637.50
                      Picture             100.00      200.00        222.22      250.00      100.00      122.22        150.00

                      Totals            $1,365.00   $2,730.00   $3,033.33   $3,412.50    $1,365.00     $1,668.33   $2,047.50


                               Assumption Table
                      Sofa               $275.00
                      Lamp                125.00
                      End Table           225.00
                      Chair               215.00
                      Rug                 425.00
                      Picture             100.00

                      Retail Selling
                      Price by
                      Margin
                      Starting Point         50%
                      Increment             5.0%




                                                                  Excel is Fun!

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:2
posted:7/18/2011
language:English
pages:6
Description: Retail Selling Workbook document sample