November 19, 2017

Re accounting exam and hacks into RGP computation


---------- Forwarded message ----------
From: Jorge Saguinsin <holygardens.groupnew@gmail.com>
Date: Sun, Nov 19, 2017 at 8:49 PM
Subject: Re accounting exam
To: Majorem Investor <majorem.lending@gmail.com>


To:    All Accounting staff

These are my comments on your exams;

1.  Thank you for striving to apply xls on your accounting exam

2. It was better if you did the following

      1.  The journal entries were spread out into a trial balance/per account 
           with debit and credit   No no need for T accounts

      2.  E.g.

      Journal Entries                Cash                      She               FFE
                                   DR           CR             DR        CR        DR       CR

1.  Investment              10,000                                   10,000

2   Buy garapon etc                   3,000                                     3,000


You can summarize this trial balance and harvest all the accounts for IS, Cash Flow etc.   Again we are repeating that the cash account is the Cash Flow statement

 You can make this neater by having all the Balance Sheet Accounts together and Income Statement together

3.  We can hack make the short cut the Excel file, by creating a cell or computing quickly:  (For RGP)

      a.  Copy the total of the NLP from your excel

      b.  Create new column

           Enter formula:

          Say row P  x 40%

          Say  row  Q x 50%

      3.  Compute  RGP total

          NLP   x    Developers Share  -  CGS

                         P8,750 for  lawn

                         P35,000 for SSN

                        P105,000 for GE

      4.  Divide by 60

      5.  Subtract from MA the CGS  per month if all the rows are all minimum MA
--
PAGSASANAY SA TAGUMPAY (Training for Success)




















SETTING THE STANDARDS IN INTERMENT SERVICE
Innovation creates more wealth and more customers


  Jorge U. Saguinsin

  Be a BIDDA now

  RRURAC   (Read, Reflect, Understand, Realize Act, Check)

   Please visit the following sites:

   









Notice:   This email address is a private property of Holy Gardens Group and its contents are private and confidential.    Its contents and attachment  may not be copied nor forwarded to parties other than the ones intended to,  nor can the contents be used other than the original intent  You are advised to delete the message you received if in case it may have been wrongly sent to your good office



--
PAGSASANAY SA TAGUMPAY (Training for Success)




















SETTING THE STANDARDS IN INTERMENT SERVICE
Innovation creates more wealth and more customers


  Jorge U. Saguinsin

  Be a BIDDA now

  RRURAC   (Read, Reflect, Understand, Realize Act, Check)

   Please visit the following sites:

   









Notice:   This email address is a private property of Holy Gardens Group and its contents are private and confidential.    Its contents and attachment  may not be copied nor forwarded to parties other than the ones intended to,  nor can the contents be used other than the original intent  You are advised to delete the message you received if in case it may have been wrongly sent to your good office

No comments:

Post a Comment

1. One of our beliefs is learning. It pays that you learn more to do more Just to survive you have to learn how forage in a forest or raise your food, catch prey

2. In order to discharge your job well, you have to learn your admin plan the process flow and standards.

3. To keep up with changes, you have to learn and read. There is no other way

4. signify that you have read by putting your name on this comment box. Every staff must: post the name on this comment box, or like, agree/will do. Your registering on this comment box is being graded under communication. Observe RRURAC: Read, Reflect, Understand, Realize (apply to reality) Apply, and Check (if it works)
You need to make __comments a month to qualify for promotion under our CCD

Read the posts on this site every AM talk. Many problems arise simply because people do not know what to do, because they did not read this site

We are making sure that you improve yourself, engage yourself in self improvement through this site...






Note: Only a member of this blog may post a comment.