Docstoc

taxes

Document Sample
taxes Powered By Docstoc
					               A                      B                   C              D       E             F                G                    H               I               J            K               L            M                N                O              P             Q            R   S
1    name
2    sec                                                                                Pizza Delivery Times Contest on a Monday in NE Philly
3    date                                            Close delivery=CD                                                                                        Far Delivery = FD
4                             2 mile Delivery                                                           max points                                            3 Mile Delivery         max points                                            Total and Grades
5    Possible Points                                                                                             100.00                                                                     100.00
6    Restaurant                  C Deliv 1            C Deliv 2 C Deliv 3 C Deliv 4      Total CD times Total CD points     CD Avg W/penalty    CD Average      F Deliv 1 F Deliv 2 Total FD times Total FD Points        FD Average        Total Pts     Grade
7    Dominoes                                19.00        20.00    18.00     18.00                                                                                   23.00   25.00
8    Pizza Hut                               23.00        26.00    25.00     24.00                                                                                   24.00   27.00
9    PapaJons                                33.00        34.00              29.00                                                                                   37.00   33.00
10   Eddies                                  41.00        36.00    40.00     38.00                                                                                   42.00   45.00
11
12   Average                                                                         H7 CD Avg W/penalty       IF statement                               weights
13   Median                                                                          shows a way to use the count function and                  cd                       75.00
14                                                                                   gives a penalty for uncompleted deliveries in              fd                       25.00
15   rewarding lowest time below                                                     the Avg w/penalty field.
16                              Minutes delivered for CD                              =if(count(B7:E7)<4,I7+5,I7)                                                      Minutes delivered for FD                                                    Final Grade
17                       Time range:            points:                                             or                                                                Time range                      Points                                Points       Grade
18          0 to                  20.00                100.00                        =IF(COUNT(B7:E7)<$G$21,I7+$H$21,I7)                                             0 to       25.00                 100.00                  100 to           75.00          A
19         21 to                  30.00                 75.00                                                                                                       26 to       35.00                  75.00                   74 to           50.00          B
20         31 to                  40.00                 50.00                                            penalty count    penalty amount                            36 to       45.00                  50.00                   51 to           25.00          C
21         41 to                  50.00                 25.00                                            4.00             5.00                                      46 to       55.00                  25.00                                  all else        F
22                       all else                        0.00                                                                                                                 all else                  0.00
23
24
25       G7 Total CD points            Nested if statement                               I7 CD Average      formula & function
26       =if(h7<=20,"100",if(h7<=30,"75",if(h7<=40,"50",if(h7<=50,"25","0"))))
                                                                                         =(B7+C7+D7+E7)/COUNT(B7:E7)
                                                                                                                                                         O7 Total Pts        Weighted Average:                            P7 Grade Final Nested if statement
27
         or                                                                              count is used here:
28       =IF(H7<=$B$18,$C$18,IF(H7<=$B$19,$C$19,IF(H7<=$B$20,$C$20,IF(H7<=$                                                                              (% x points) + (% x points)                                      =if(o7>=75,"A",if(o7>=50,"B",if(o7>=25,"C","0"))))
                                                                                         create a formula then insert a function
29       B$21,$C$21,$C$22))))
                                                                                                                                                                                                                          or
30                                                                                                                                                       =(G7/$G$5*$J$13)+(M7/$L$5)                                       =IF(O7>=$O$18,$P$18,IF(O7>=$O$19,$P$19,IF(O7>=$O$20,$P$2
31                                                                                                                                                                                                                        0,$P$21)))
32
33          F7 Total CD times Sum
34          =SUM(B7:E7)
35          or
36          =B7+C7+D7+E7                                                                                                                                 L7 Total FD times SUM
37                                                                                                              N7 FD Average Average
38                                                                                                                                                       =j7+k7
39                                                                                                              =AVERAGE(J7:K7)                                                                                    M7 Total FD Points                 Nested IF Statement
40
41                                                                                                                                                                                                                 =if(n7<=20,"100",if(n7<=30,"75",if(n7<=40,"50",if(n7<=50,"25","0"))))
42                                                                                                                                                                                                                 or
43                                                                                                                                                                                                                 =IF(N7<=$K$18,$L$18,IF(N7<=$K$19,$L$19,IF(N7<=$K$20,$L$20,IF(N7<=$K
44                                                                                                                                                                                                                 $21,$L$21,$L$22))))
45
46
47
48
49
                                       TAxRate Problem

                                      $
 TAxRate for Incomes less than or equal to 150,000.00                   4.5%
 TAxRate for all other Incomes                                          6.0%



Name                 Income          Taxes               NetPay
Zola's Café           $ 120,000.00
                      $ 175,000.00
L'Auberge Country Restaurant
Café Calorie          $    80,000.00
American Café         $ 137,500.00
California Café       $ 150,000.00
Crazy Cats            $    90,000.00
Sullivans             $ 170,000.00
Macaroni's            $ 100,000.00
The Garden            $    56,000.00
Upstairs at Varellis  $ 200,000.00



         1) Create a Nested IF Statement in Cell D11 that shows:
         when an income is larger than $150,000, charge 6.0% and when
         below $150,000 to charge a rate of 4.5%


         2) Complete the NetPay cell Hint: np=i-t

         3)Create a column chart using data Name and Taxes column
D11 Taxes   Nested IF Statement
=IF($D$5>=C11,C11*$H$5,C11*$H$6)

Notice the conditional format I made for Taxes over
$10,000


F11 Net Pay
Income - taxes   or   =C11-D11
             Final Grade:

Restaurant
Dominoes
Pizza Hut
PapaJons
Eddies

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:2/23/2012
language:
pages:7