Project answer sheet (2)

.xlsx

School

Rutgers University, Newark *

*We aren’t endorsed by this school

Course

Subject

Accounting

Date

Jan 9, 2024

Type

xlsx

Pages

Uploaded by urvibrahmbhatt6

Balance sheet analysis Income statement analysis Monthly account activity analysis Dimension analysis Date analysis Gross margin analysis Relationship analysis General ledger statistics Journal entry summary and details

Question What general ledger accounts are listed? What is the amount of the beginning balance for cash? What is the amount of the ending value for cash? What is the total amount of assets for the hotel in the current year? Which liability account class shows a decrease from the prior year? How many specific general ledger accounts combine to make the total plant, property and equipment account classification sho What is the value of the Buildings and Building Improvements account (GL Acct # 16200) in the current year? Which colored bar shows the inventory ending balance amount in the balance sheet composition view? What was the percentage increase in travel expenses (excluding mileage)? Did the total revenue increase or decrease from the previous year and by how much? How much did the company pay for overtime expenses in the current year? Which colored bar represents Sales – Hotel? Which month shows the largest difference in net revenue (all revenue accounts) between FY15 and FY16? In FY16, which month had the highest revenue (all revenue accounts)? In FY16, which month had the lowest revenue (all revenue accounts)? Which month for each FY shows the largest amount of cash activity and how much was it? What was the net cash receipts amount related to dining sales for FY16? What was the total cash receipts amount related to dining sales for February 2016? What was the total cash receipts amount for both dining sales and hotel sales for February 2016? What color is assigned to transactions prepared by the property management system, GuestSYS? What was the total amount of hotel sales revenue from GuestSYS in March 2016? For the Revenue – Sales-Dining account, which day of the week reflected the highest total credit amounts entered in FY2016? During FY16, what specific date had the most revenue entered for the Revenue – Sales- Dining account? For all revenue accounts in FY15, which day of the year had the highest dollar amount of debit entries and what is the dollar am What was the average gross margin percentage for Revenue – Sales-Dining for FY15? What was the average gross margin percentage for Revenue – Sales-Dining for FY16? In FY 2016, in which month did the gross margin percentage for Revenue – Sales-Dining deviate most from the average? For FY15, what was the relationship percentage between payroll taxes and payroll expense for April 2015? In FY15, for which month or months was the relationship percentage between payroll taxes and payroll expense the lowest? W For FY15, what was the total amount for the payroll tax account, FICA-HI, for August 2014? How many liability accounts does PSU Hotel have? Which account type had the largest number of journal entries posted in FY16 and how many were posted? How many journal entries were posted directly from the PMS (GuestSYS) in FY16? Which individual preparer generated the most journal entries in FY16? What is their title? How many journal entries did they po What is the offsetting account class for journal entry #20169203?

Answer

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version