I got confused on how to do the calculation if you can go over how to calculate the total and any
2:59 PM Sun Sep 19 More Help E Ask a Tutor Get step-by-step explanations, verified by experts. Find Textbook Solutions 9 LTE 9 courseherocom G In E Retailer excel p\". )1 T Q Page: not\") Iomauc Loom v Instructions This assignment is designed for practicing both the retailer/merchandiser accounting cycle and your basic excel sk Below are select sales transactions for Road Runner Racers. You will need to enter the missing pieces of each tran on the journal entry tab. Each missing piece of information is highlighted in yellow. The only cell where an actual I is to be input is on the journal entries worksheet. Please note: not every yellow cell requires input (it could be I: After completing the journal entries, you must then complete the missing pieces of the T accounts, trial balance, a statements highlighted in yellow. Only excel functions may be used to calculate the appropriate cell value on thes DO NOT INPUT THE ACTUAL NUMBER INTO THE T ACCOUNTS, TRIAL BALANCE, OR STATEMENTS. Use excel functions (such as copying the number from the journal entry page, summing numbers together, or usin plus or minus symbols to help you nd the appropriate number). Your balance sheet should balance when you an Tip: After each journal entry, update the appropriate Taccounts. Select RetaiIer/Merchandiser-Related Transactions: 1) Road Runner Racers (RRR) purchased $10,000 of merchandise from Warehouser Plus on January 10' RRR was given terms of 4/15, n/30. FOB shipping point. RRR paid $100 for delivery' 2) RRR paid their invoice to Warehouser Plus on January 25th. 3) On February 2, RRR sold $1,000 of merchandise to Rowdy's Inc' RRR offered Rowdy credit terms of 2/10, n/45. RRR's cost of the merchandise was $500. 4) On February 5, Rowdy contacted RRR because some of the goods were damaged. RRR offered Rowdy a $50 credit allowance. Rowdy agreed to the allowance. 5) Rowdy paid their invoice on February 15. 6) RRR counted inventory on February 28. Their books showed $69,200 in inventory, but the physical inventory count only showed $68,650. 118qu 4:17 PM Sun Sep 19 25% 4. Retailer Exel Homework - Dalhia Garcia Co K AA C Q E coursehero.com + . .. Home Insert Draw Formulas Data Review View 6 E in Zinda Law G.. in Army Nation.. x Course Hero G how do you... B U abe A Ask homework questions Try for free X Easy steps to ask any homework question on over 140 subjects M N O Q R Verified expert tutors provide step-by-step answers in as fast as 15-30 + Equity minutes Sales Revenue Sales Discounts $ 309,392 $4,144 0 1. Enter the question 1First 5 questions on us $4,144 $ 309,392 Sales Returns and Allowances You'll get a faster answer if you only include one question and provide all Common Stock $2,763 po $ 40,050 necessary context for your tutor $2,763 bo $ 40,050 Wages Expense 94,50 BIU X2 X2 Retained Earnings $2,500 $ 22,630 $97,000 Enter your question and any additional information Supplies Expense $ 22,630 $6,980 Dividends $6,980 $765 Depreciation Expense $765 $11,600 $11,600 COGS $45,000 Delivery Expense Next $1,962 39 40 2. Select the best subject structions Journal Entries AT accounts +4:17 PM Sun Sep 19 25% 4. Retailer Exel Homework - Dalhia Garcia Co Q E AA . .. coursehero.com C + Home Insert Draw Formulas Data Review View 6 E in Zinda Law G.. in Army Nation.. x Course Hero G how do you... B I U abe A Ask homework questions Try for free X fa Easy steps to ask any homework question on over 140 subjects B D E K M Verified expert tutors provide step-by-step answers in as fast as 15-30 Assets Liabilities minutes Cash Sales Revenue $43,138 $100 Accounts Payable $ 309, $ 18,000 1. Enter the question #First 5 questions on us $43,038 $ 18,000 $ 309, You'll get a faster answer if you only include one question and provide all Supplies Wages Payable Common Stock $ 16,200 $6,980 $ 2,500 $ 40, necessary context for your tutor $ 9,220 $ $ 40, Equipment Insurance Payable BIU X2 X2 $ 116,100 $ 2,000 Retained Earning $ 22, $ 116,100 $ 2,000 Enter your question and any additional information Accumulated Depreciation - Equipment $ 22. $11,600 Dividends $11,600 $765 Inventory $765 $60,00 $10,000 $70,000 Accounts Receivable $7,500 $1,000 $950 $7,550 Next 38 39 40 2. Select the best subject structions A Journal Entries AT accounts +
