X AutoSave 6 2 Project 1 Basic Excel Wilhelm 520 2.1 Saved - File Home Insert Draw - Page Layout Formulas Data Review View Help Liberation Sans - 12 AA 2 Number Paste BIU A 2 $ -% 9 438-68 Conditio Formatt Clipboard Font Alignment Number E36 - X f Value AB 1 E4-14 Analyze adiusted data 2 This is a partial adjusted trial balance of Ramon Company RAMON COMPANY Adjusted Trial Balance January 31, 2017 Credit Supplies Prepaid Insurance Salaries and Wages Payable Uneared Service Revenue Debit $700 1,560 $1,060 750 950 Supplies Expense Insurance Expense Salaries and Wages Expense Service Revenue 520 1.800 4.000 19 Instructions 20 Answer these questions, assuming the year begins January 1 21 (a) If the amount in Supplies Expense is the January 31 adjusting entry, and $300 of supplies was purchased in January, what was the balance in Supplies on January 17 24 (b) If the amount in Insurance Expense is the January 31 adjusting entry, and the original insurance premium was for 1 year, what was the total premium and when was the policy purchased? 27 (c) If $2,500 of salaries was paid in January, what was the balance in Salaries and Wages Payable at December 31, 2016? 29 (d) If $1,800 was received in January for services performed in January, what was 30 the balance in Unoamned Service Revenue at December 31, 2016? 31 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 1 t O Pasto BIU A EEEE $ - % 9 Clipboard Font Number Alignment E36 fx Value FFGH 35 (all Supplies expense Add: Supplies (1/31) Less Supplies purchased Supplies (1/1) $950 Value Value 41 (b) $520 Monthly premium Number of months Total premium X 12 $6240 S1.560 520 Prepaid Insurance, 1/31 Monthly premium Number of months remaining, 1/31 Date of Purchase 05/01/16 52 (c) Cash Paid Add: Salaries and wages payable, 1/31/17 Subtotal Less: Salaries and wages expense Salaries and wages payable, 12/31/16 $2,500 1.060 3.560 -1.800 $8.920 59 (d) Value Value Service revenue Add: unearned revenue, 1/31/17 Subtotal Less: Cash received in January Unearned revenue, 12/31/16 Value