ta mula: Add Subtract; Cell Referencing 2 3 4 5 BE4.4 Using Excel to Prepare Entries and Post to T- Accounts PROBLEM Sain Advertising Ltd.'s maintains a Supplies account in its trial balance. On January 11, the company purchased additional supplies on account. On January 31, some of the supplies are still on hand. The following cost information is available for the company's Supplies account. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work areas as indicated. 6 7 8 9 10 a. Prepare the journal entry to record the purchase of supplies on January 11. 12 Debit January 1, Supplies on hand January 11, Purchase on account January 31, Supplies on hand Date Jan. 11 Credit 1,500 1,800 1,100 14 15 6 7 b. Calculate the amount of supplies used during the month. 3 3 0 1 2 C. Prepare the adjusting entry required at January 31, assuming adjusting entries are prepared monthly Debit Date Jan. 31 Credit 1 3 cain viruses. Unless you need to edit, it's safer to stay in Protected View. otract; Cell Referencing H K M N O P C. Prepare the adjusting entry required at January 31, assuming adjusting entries are prepared monthly. Debit Credit Date Jan. 31 Using Taccounts, enter the opening balances in the affected accounts, post the journal entries in parts (a) and (c), and indicate the adjusted balance in each account. Supplies Supplies Expense A1 v fi Formula: Add, Subtrac G H ***** w Req math as in C D E F Formula: Add, Subtract; Cell Referencing 2. 3 BE4.4 Using Excel to Prepare Entries and Post to T- Accounts 5 PROBLEM 6 Sain Advertising Ltd.'s maintains a Supplies account in its trial balance. On January 11, the company purchased additional 8_supplies on account. On January 31, some of the supplies 9 are still on hand. The following cost information is available 10 for the company's Supplies account. 11 12 January 1, Supplies on hand $ 1,500 13 January 11, Purchase on account 1,800 14 January 31, Supplies on hand 1,100 7 a. 16 b. 17 18 19 20 21 22 24 25 26 27 28