T-Accounts 2 - Moving Average Price - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW IG Calibri 11 z Wrap Text General A Cut BB Copy Paste Format Painter BIU- . $ % ) Merge & Center 4.0 .00 .00 0 Insert Delete Fo Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells . N 0 A1 Complete the accounting entries and note how the amount was calculated based on the assumption listed below. B C DEF G H IJK L M Complete the accounting entries and note how the amount was calculated based on the assumption listed below. a. Rocky Mountain Bikes has ordered 250 road helmets (RHMT 1000) from GBI. b. The San Diego plant has 50 road helmets valued at a moving average price of $25.13 each C. The Miami plant has 400 road helmets valued at a moving average price of $25.25. d. GBI has decided to move 100 road helmets from Miami to San Diego and to purchase 300 helmets from Spy Gear at $25.54 each. e. GBI sells road helmets for $50 each. Label each entry with the appropriate process step number: 1. Goods receipt for PO 2. Vendor invoice 3. Vendor payment 4. Gl for delivery 5. Customer invoice 6. Customer payment The entries for step 1 have already been completed for you in the green cells. 1 2 3 GENERAL LEDGER 4 5 Account: Account: Inventory - TG 7,662.00 Account: GR/IR $ 1 $ 7,662.00 6 7 8 9 Account: Account: Account: 10 11 Account Balances Case Study Account: Account 12 13 Account: 14 15 16 17 SUBLEDGERS 18 19 Account 20 21 22 23 AMOUNT CALCULATIONS 24 1 From Spy Gear: 300 units 25.54 = $7662 25 26 3 Account Account: 4 27 28 29 51 61 7 30 31 32 33 34 35 36 37 Account Balances Case Study + READY T-Accounts 2 - Moving Average Price - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW IG Calibri 11 z Wrap Text General A Cut BB Copy Paste Format Painter BIU- . $ % ) Merge & Center 4.0 .00 .00 0 Insert Delete Fo Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells . N 0 A1 Complete the accounting entries and note how the amount was calculated based on the assumption listed below. B C DEF G H IJK L M Complete the accounting entries and note how the amount was calculated based on the assumption listed below. a. Rocky Mountain Bikes has ordered 250 road helmets (RHMT 1000) from GBI. b. The San Diego plant has 50 road helmets valued at a moving average price of $25.13 each C. The Miami plant has 400 road helmets valued at a moving average price of $25.25. d. GBI has decided to move 100 road helmets from Miami to San Diego and to purchase 300 helmets from Spy Gear at $25.54 each. e. GBI sells road helmets for $50 each. Label each entry with the appropriate process step number: 1. Goods receipt for PO 2. Vendor invoice 3. Vendor payment 4. Gl for delivery 5. Customer invoice 6. Customer payment The entries for step 1 have already been completed for you in the green cells. 1 2 3 GENERAL LEDGER 4 5 Account: Account: Inventory - TG 7,662.00 Account: GR/IR $ 1 $ 7,662.00 6 7 8 9 Account: Account: Account: 10 11 Account Balances Case Study Account: Account 12 13 Account: 14 15 16 17 SUBLEDGERS 18 19 Account 20 21 22 23 AMOUNT CALCULATIONS 24 1 From Spy Gear: 300 units 25.54 = $7662 25 26 3 Account Account: 4 27 28 29 51 61 7 30 31 32 33 34 35 36 37 Account Balances Case Study + READY
