Announcement

Collapse

Advertising Inquiries

See more
See less

Question for the math experts (Hotel book keeping)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Question for the math experts (Hotel book keeping)

    This has to do with the month do date revenues at my work. I don't understand how it works and it's driving me crazy. X is the total amount owed for the new day when taking money in versus amount owed from rented rooms. Y is the ending balance still owed from the day before. Z is the total ending balance from X and Y. B is the total amount owed but it's Month to Date and C is the amount still owed when last month was over. Both Z's are suppose to be the same number. That's how we know if we did the math right. I hope I explained this well enough, becuase I just don't understand how this works and it's going to drive me crazy when my Z's don't match up each night and I don't think they should. No one I work with knows how this works, "They just know it always works"
    Attached Files

  • #2
    Shit man you got me stumped and i'm good at this shit.

    Comment


    • #3
      maybe you should pray about it...

      Comment


      • #4
        :wacko:

        Comment


        • #5
          Judging from your description, I don't see how they could match up.

          Comment


          • #6
            Ok, niether do I, but we will see next sunday when I do it again for 3 days.

            Comment


            • #7
              Great GMAT question:

              (X + Y) = (B + C)

              C = X + Y - B

              Since C is constant, then a change in any one variable requires a change in the opposite direction by at least one of the other variables. For instance, if X increases by 2, then Y must decrease by 2 OR C must increase by 2 OR Y must decrease by 1 and C must increase by 1 OR Y must decrease by 1 and X must decrease by 1.

              Does this make sense? Yep.

              Let's say on day 1 of the month:

              X = 0
              Y = 1000
              C = 1000
              B = 0


              On the first day of every new month, Y = C since the amount owed for the last month is equal to the ending balance from the day before.

              Now, someone rents a room for $100. So, both X and B increase by $100 and the equation balances. The person checks out after one day, X decreases by 100, but Y increases by 100 and B stays at 100 and the equation balance. If the person pays the 100, then Y decreases by 100 and B decreases by 100 and the equation balances.

              Comment


              • #8
                Yes that makes sense. Now if my numbers don't come out right at least I know my time taken of fixing it is worth it. Thank you very much.

                Comment


                • #9
                  Originally posted by Curls4dGirls
                  Great GMAT question:

                  (X + Y) = (B + C)

                  C = X + Y - B

                  Since C is constant, then a change in any one variable requires a change in the opposite direction by at least one of the other variables. For instance, if X increases by 2, then Y must decrease by 2 OR C must increase by 2 OR Y must decrease by 1 and C must increase by 1 OR Y must decrease by 1 and X must decrease by 1.

                  Does this make sense? Yep.

                  Let's say on day 1 of the month:

                  X = 0
                  Y = 1000
                  C = 1000
                  B = 0


                  On the first day of every new month, Y = C since the amount owed for the last month is equal to the ending balance from the day before.

                  Now, someone rents a room for $100. So, both X and B increase by $100 and the equation balances. The person checks out after one day, X decreases by 100, but Y increases by 100 and B stays at 100 and the equation balance. If the person pays the 100, then Y decreases by 100 and B decreases by 100 and the equation balances.

                  That's exactly what I was gonna say. :agree:

                  Comment


                  • #10
                    Check out the big brain on brad, thats right your a smart muthafucka.

                    What movie is that from?

                    Comment


                    • #11
                      Originally posted by mcalo4
                      Check out the big brain on brad, thats right your a smart muthafucka.

                      What movie is that from?
                      Pulp Fiction, but the guy's name was actually Brett.

                      Comment


                      • #12
                        Originally posted by Puddles
                        That's exactly what I was gonna say. :agree:
                        Sure it was puddles :bsflag: :bnoser:

                        Comment


                        • #13
                          Originally posted by Curls4dGirls
                          Great GMAT question:

                          (X + Y) = (B + C)

                          C = X + Y - B

                          Since C is constant, then a change in any one variable requires a change in the opposite direction by at least one of the other variables. For instance, if X increases by 2, then Y must decrease by 2 OR C must increase by 2 OR Y must decrease by 1 and C must increase by 1 OR Y must decrease by 1 and X must decrease by 1.

                          Does this make sense? Yep.

                          Let's say on day 1 of the month:

                          X = 0
                          Y = 1000
                          C = 1000
                          B = 0


                          On the first day of every new month, Y = C since the amount owed for the last month is equal to the ending balance from the day before.

                          Now, someone rents a room for $100. So, both X and B increase by $100 and the equation balances. The person checks out after one day, X decreases by 100, but Y increases by 100 and B stays at 100 and the equation balance. If the person pays the 100, then Y decreases by 100 and B decreases by 100 and the equation balances.
                          See I thought that this was too simple. At first I was like set them equal. I guess I look at things too complex.:hang:

                          Comment

                          Working...
                          X