Docstoc

ppayrll_cstudy_answ

Document Sample
ppayrll_cstudy_answ Powered By Docstoc
					Payroll / Process payroll / Case study / Answers



                                                              Weekly Time Record

      Farrell’s Furniture          Ph: 9444 5555
      21 Harbour Rd                Fax: 9444 5556
      Newport 5959                 Email: sales@farrells.com.au


                       Employee: Samantha Jones
              Employee phone: -
              Employee E-mail: sjones@farrells.com.au

                    Week ending: 5/13/2012

                                                                                                     Overtime
                             In         Out            In         Out            Regular Hours                    Sick   Holiday   Total
                                                                                                      Hours
         Monday             9:00       13:00          13:30       17:30                   8:00                                             8:00
         Tuesday            9:00       13:00          13:30       17:30                   8:00                                             8:00
       Wednesday            9:00       13:00          13:30       17:30                   8:00                                             8:00
        Thursday            9:00       13:00          13:30       17:30                   8:00                                             8:00
          Friday            9:00       13:00          13:30       17:30                   5:30             2:30                            8:00
         Saturday
         Sunday
                                                                        Total            37:30             2:30                        40:00
      Employee signature:          Date: 13/05/2012                       Rate            $14    $        21.00
                                                                        Total $        525.00    $        52.50




      Manager signature:           Date: 13/05/2012
Payroll / Process payroll / Case study / Answers



                                                               Weekly Time Record

      Farrell’s Furniture           Ph: 9444 5555
      21 Harbour Rd                 Fax: 9444 5556
      Newport 5959                  Email: sales@farrells.com.au


                       Employee: Jim Carter
              Employee phone: -
              Employee E-mail: jcarter@farrells.com.au

                    Week ending: 5/13/2012

                                                                                                  Overtime
                             In          Out            In         Out            Regular Hours              Sick   Holiday   Total
                                                                                                   Hours
         Monday
         Tuesday            10:00       12:30          13:00       16:00                   5:30                                       5:30
       Wednesday            9:00        14:00                                              5:00                                       5:00
        Thursday            8:30        12:30          13:00       17:00                   8:00                                       8:00
          Friday
         Saturday           10:00       13:00                                              3:00                                       3:00
         Sunday
                                                                         Total            21:30                                   21:30
      Employee signature:           Date: 13/05/2012                       Rate            $29
                                                                         Total $        623.50




      Manager signature:            Date: 13/05/2012
Payroll / Process payroll / Case study / Answers



                                                              Weekly Time Record

      Farrell’s Furniture          Ph: 9444 5555
      21 Harbour Rd                Fax: 9444 5556
      Newport 5959                 Email: sales@farrells.com.au


                       Employee: Rebecca Wright
              Employee phone: -
              Employee E-mail: rwright@farrells.com.au

                    Week ending: 5/13/2012

                                                                                                     Overtime
                             In         Out            In         Out            Regular Hours                    Sick   Holiday       Total
                                                                                                      Hours
         Monday             8:30       12:00          13:00       17:00                   7:30                                                 7:30
         Tuesday            8:30       12:00          13:00       17:00                   7:30                                                 7:30
       Wednesday            8:30       12:00          13:00       17:00                   7:30                                                 7:30
        Thursday            8:30       12:00          13:00       17:00                   7:30                                                 7:30
          Friday            8:30       12:00          13:00       17:00                   7:30                                                 7:30
         Saturday           9:00       12:00                                                               3:00                                3:00
         Sunday
                                                                        Total            37:30             0.13                            40:30
      Employee signature:          Date: 13/05/2012                       Rate         $26.50    $        39.75
                                                                        Total $        993.75    $       119.25                    $   1,113.00




      Manager signature:           Date: 13/05/2012
Payroll / Process payroll / Case study / Answers



                                                     Payroll register

                                                     for week ending 13/5/2012
                                                                   Employees
                                     Rebecca               Jim                 Brian
             Earnings                        26.5                   29                    40
      Ordinary                             993.75                 623.5                 1500
      Overtime                             119.25
      Sick Leave                                0
      Holiday Leave                             0
      GROSS PAY                           1113.00                623.50           1500.00
         less Deductions
      Tax                                      237                  53                   358
      Super                                                                            200.00
      HBF                                                                               55.00
      Savings Plan                           5.00                  5.00                  5.00
      Total Deductions                     242.00                 58.00                618.00
      NET PAY                              871.00                565.50                882.00

      SGC
                       0.09             89.44                     56.12                135.00
      Workers compensation
                      0.048             53.42                     29.93                 72.00
      Holiday Leave Accrued hours per week
                      2.885             76.45                                          115.40
      Sick Leave Accrued hours per week
                      1.442             38.21                                           57.68
      Long Service Leave Accrued hours per week
                      0.375              9.94                                           15.00
ister

3/5/2012
oyees
           Samantha          Total
                     14
                   525        3642.25
                   52.5        171.75
                      0             0
                      0             0
                 577.50       3814.00

                       68         716
                                  200
                                   55
                   5.00            20
                  73.00           991
                 504.50          2823



                  47.25      327.8025

                  27.72       183.072

                  40.39      232.2425

                  20.19       116.081

                      5.25    30.1875
Payroll / Process payroll / Case study / Answers




                                                     Cash Payments Journal

                                                                    Cash Purchases
                                                           Cheque
         Date               Particular             Folio                             Wages     Sundries GST Paid   Bank
                                                             No     OF        HF

        5/13/2011 Rebecca Wright                                                      871.00
                  Jim Carter                                                          565.50
                  Brian May                                                           882.00
                  Samantha Jones                                                      504.50                       2823.00
Payroll / Process payroll / Case study / Answers



                                                          General Journal

         Date                               Particulars                       Folio   Debit
        5/13/2011 Wages and Salaries                                                     3814.00
                   PAYG
                   Super Deduction
                     HBF
                     Savings Plan
                     Wages Payable

                   Payroll and liabilites for week ending 13/5/11
                   SGC Expense                                                            327.80
                    SGC Liability
                   SGC for week ending 13/5/11
                   Workers compensation expense                                           183.07
                    Workers compensation payable
                   Workers compensation for week ending 13/5/11
                   Annual Leave Expense                                                   232.24
                     Provision for Annual Leave
                   Provision for Annual Leave for week ending 13/5/11
                   Sick Leave Expense                                                     116.08
                     Provision for Sick Leave
                   Provision for Sick Leave for week ending 13/5/11
                   Long Service Leave Expense                                              30.19
                     Provision for Long Service Leave
                   Provision for Long Service Leave for week ending 13/5/11
Credit

          716.00
          200.00
           55.00
           20.00
         2823.00




          327.80



          183.07



          232.24



          116.08



           30.19
Payroll / Process payroll / Case study / Answers



                                                   Expenses

      Wages Expense
         Date                  Particulars         Folio   Dr             Cr
         13-May Sundries                           GJ           3814.00




      SGC Expense
         Date                  Particulars         Folio   Dr             Cr
         13-May SGC Payable                        GJ            327.80



      Workers Compensation Expense
         Date                  Particulars         Folio   Dr             Cr
         13-May Workers Compensation Payable       GJ            183.07



      Annual Leave Expense
         Date                  Particulars         Folio   Dr             Cr
         13-May Provision for Holiday Leave        GJ            232.24



      Sick Leave Expense
         Date                  Particulars         Folio   Dr             Cr
         13-May Provision for Sick Leave           GJ            116.08




      Long Service Leave
         Date                  Particulars         Folio   Dr             Cr
         13-May Provision for Long Service Leave   GJ             30.19
Balance
     3814.00 DR




Balance
      327.80 DR




Balance
      183.07 DR




Balance
      232.24 DR




Balance
      116.08 DR




Balance
       30.19 DR
Payroll / Process payroll / Case study / Answers




                                                   General Ledger

      Assets
      Cash at Bank
         Date                  Particulars             Folio   Dr         Cr            Balance
                  Balance                                                                  25000.00 DR
      13-May      Payments                                                 2823.00         22177.00 DR



      Liabilities
      Wages Payable
        Date                   Particulars             Folio   Dr         Cr            Balance
      13-May      Sundries                             GJ                  2823.00          2823.00 CR
      13-May      Bank                                 CPJ      2823.00                       0.00


      PAYG Payable
        Date                 Particulars               Folio   Dr         Cr            Balance
      13-May      Wages & Salaries                     GJ                      716.00        716.00 CR

      Superannuation Payable
        Date                 Particulars               Folio   Dr         Cr            Balance
      13-May      Wages & Salaries                     GJ                      200.00        200.00 CR

      HBF
        Date                 Particulars               Folio   Dr         Cr            Balance
      13-May      Wages & Salaries                     GJ                       55.00         55.00 CR

      Savings Plan
        Date                 Particulars               Folio   Dr         Cr            Balance
      13-May      Wages & Salaries                     GJ                       20.00         20.00 CR

      Workers Compensation Payable
        Date                 Particulars               Folio   Dr         Cr            Balance
      13-May      Workers Compensation Expense         GJ                      183.07        180.01 CR

      SGC Payable
        Date                Particulars                Folio   Dr         Cr            Balance
      13-May      SGC Expense                          GJ                      327.80        322.06 CR

      Holiday Leave Accrued
        Date                  Particulars              Folio   Dr         Cr            Balance
      13-May      Balance                                                                   2300.00 CR
      13-May      Holiday Leave Expense                GJ                      232.24       2532.24 CR


      Sick Leave Accrued
        Date                  Particulars              Folio   Dr         Cr            Balance
      13-May      Balance                                                                   1230.00 CR
      13-May      Sick Leave Expense                   GJ                      116.08       1346.08 CR

      Long Service Leave Accrued
        Date                  Particulars              Folio   Dr         Cr            Balance
      13-May      Balance                                                                   2800.00 CR
      13-May      Long Service Leave Expense           GJ                       30.19       2830.19 CR

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:1
posted:1/1/2012
language:
pages:38