Im excellent spread sheet If possible . Profit and loss statement

Problem 6 Several accounts from the Hilltop Motel's general ledger that pertain to the rooms department are listed below. The accounts are in random order as follows: Sales-transient-regular Salaries Commissions Uniforms Linen expense Sales-transient-groups Wages Payroll taxes Operating supplies Contract cleaning Dry cleaning Fringe benefits Other revenues Allowances-rooms Laundry Miscellaneous expenses $100,000 10,000 1,000 500 1,000 50,000 15,000 2,000 1,500 1,800 1,200 3,000 2,000 500 3,000 1,800 Required: Prepare a rooms department schedule following the USALI. Use only classifications as shown on the prescribed schedule. Use Exhibit 5 as a guide