E4-14 Analyze adjusted data This is a partial adjusted trial balance of Ramon Company RAMON COMPANY Adjusted Trial Balance January 31, 2017 Debit $700 1,560 Credit Supplies Prepaid Insurance Salaries and vwages Payable Unearned Service Revenue $1,060 750 Supplies Expense Insurance Expense Salaries and Wages Expense Service Revenue 950 520 1,800 4,000 Instructions Answer these questions, assuming the year begins January 1 (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 1? 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? (b) (c) If $2,500 of salaries was paid in January, what was the balance in Salaries and (d) If $1,800 was received in January for services performed in January, what was NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a"?" Wages Payable at December 31, 2016'? the balance in Unearned Service Revenue at December 31, 2016? (a)Supplies expense Add: Supplies (1/31) Less: Supplies purchased Supplies (1/1) Value Value (b) Value Monthly premium Number of months otal premium X 12 Value Value Prepaid Insurance, 1/31 Monthly premium Number of months remaining, 1/31 Date of Purchase Date Value Value Cash Paid Add: Salaries and wages payable, 1/31/17 Subtotal Less: Salaries and wages expense Salaries and wages payable, 12/31/16 Value Value Value (d Service revenue Add: unearned revenue, 1/31/17 Subtotal Less: Cash received in January Unearned revenue, 12/31/16 Value