Docstoc

Exploring e01 Grader EOC xlsx Yola (Excel)

Document Sample
Exploring e01 Grader EOC xlsx Yola (Excel) Powered By Docstoc
					Cecil Kramer                                     Jacobs    355e0c06-c282-4095-89e3-9272b8c9cffa.xlsx

                A                 B             C
 1                    Royalty Statement
 2
 3   Period Ending:         6/30/2011
 4   Author:                Jacobs
 5
 6                              Hardback       Paperback
 7   Units Sold
 8      Gross Units Sold           1,500         12,492
 9      No. of Returns               324            200
10      Percent Returned           21.6%           1.6%
11
12   Pricing
13       Retail Price          $     25.00 $        5.95
14       Standard Discount Rate     55.00%        50.00%
15       Price to Bookstore    $     11.25 $        2.98
16       Net Retail Sales      $ 29,400.00 $   73,137.40
17
18   Royalty Information
19      Royalty Rates             7.25%           10.00%
20      Royalty to Author    $ 2,131.50 $       7,313.74
21      Royalty per Book     $     1.81 $           0.60
Cecil Kramer                      Lopez   355e0c06-c282-4095-89e3-9272b8c9cffa.xlsx

                                      A
 1
 2
 3   Period Ending:
 4   Author:
 5
 6
 7   Units Sold
 8      Gross Units Sold
 9      No. of Returns
10      Percent Returned
11
12   Pricing
13       Retail Price
14       Standard Discount Rate
15       Price to Bookstore
16       Net Retail Sales
17
18   Royalty Information
19      Royalty Rates
20      Royalty to Author
21      Royalty per Book
Cecil Kramer               Lopez   355e0c06-c282-4095-89e3-9272b8c9cffa.xlsx

                               B
 1                    Royalty Statement
 2
 3   40724
 4   Lopez
 5
 6                                                                 Hardback
 7
 8   5000
 9   400
10   =B9/B8
11
12
13   19.95
14   0.55
15   =B13-(B13*B14)
16   =(B8-B9)*B13
17
18
19   0.0725
20   =B16*B19
21   =B13*B19
Cecil Kramer          Lopez   355e0c06-c282-4095-89e3-9272b8c9cffa.xlsx

                          C
 1
 2
 3
 4
 5
 6                                                           Paperback
 7
 8   15000
 9   175
10   =C9/C8
11
12
13   7.95
14   0.5
15   =C13-(C13*C14)
16   =(C8-C9)*C13
17
18
19   0.1
20   =C16*C19
21   =C13*C19

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:282
posted:11/5/2011
language:English
pages:4