on the journal entry tab. Each missing piece of information is highlighted in yellow. The only cell where an actual number is to be input is on the journal entries worksheet. Please note: not every yellow cell requires input (it could be left Hank if appropriate). After completing the journal entries, you must then complete the missing pieces of the Taccounts, trial balance, and statements highlighted in yellow. Only excel functions may be used to calculate the appropriate cell value on these pages. DO NOT INPUT THE ACTUAL NUMBER INTO THE TACCOUNTS, TRIAL BALANCE, OR STATEMENTS. Use excel functions (such as copying the number from the joumal entry page, summing numbers together, or using the plus or minus symbols to help you find the appropriate number). Your balance sheet should balance when you are complete. Tip: After each journal entry, update the appropriate accounts Select Retailer/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, 8/30. FOB shipping point, RRR paid $100 for delivery 2) RRR paid their invoice to Warchouser 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,6/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 poid their invoice on February 15, 6) RRR counted inventory on February 28. Their books showed 569,200 in inventory, but the physical inventory count only showed 568,650, Sales related journal entries Account Credit Transaction 10-Jan Inventory Debit $10,000 Purchased merchandise with terms 4/15. n/30 10-Jan Cash Paid delivery costs $100 25-Jan Inventory Cash Paid for merchandise within discount period 2-Feb $1,000 Sold merchandise 2-Feb Cost of Sales 5-Feb Credit allowance 15-Feb Cash $950 Received payment from Rowdy's within discount period 28-Feb Adjustment for inventory shrinkage Assets Liabilities Equity Cash 549.13 Sales Revenue 309,192 Sales Discounts 54.147 $100 Accounts Payable 18.000 54.14 543,03 18.000 309,193 Sales Returns and Allowances 32 Supplies 16.00 S9NO Wages Payable 2.500 Common Stock 40,050 $2,763 9.30 2.500 4070501 Equipment 116.00 Insurance Payable 2, Retained Earnings 2200 Wages Expense 594,500 $2.500 397.000 TO Supplies Expo 56,90 22,010 Accumulated Depreciation Equipment 511,600 Dhidents 5765 56,90 $11.600 Depreciation Expense SITO 3765 Inventory 560,000 $10,000 SI1.600 SUTURO COCS 545.000 Accounts Rechable $7,500 $1,000 1950 57.550 Delivery Expo ON Road Runner Racers Income Statement For Period ending February 28, 2025 Revenue Sales Revenue Sales Discounts Sales Returns and Allowances Net Sales Cost of Goods Sold 309,392 -4,144 -2,763 302,485 0 302,485 Expenses Wages Expense Depreciation Expense Delivery Expense Supplies Expense Total Expenses 97,000 11,600 0 6,980 -115,580 186,905 on the journal entry tab. Each missing piece of information is highlighted in yellow. The only cell where an actual number is to be input is on the journal entries worksheet. Please note: not every yellow cell requires input (it could be left blank if appropriate). After completing the journal entries, you must then complete the missing pieces of the Taccounts, trial balance, and statements highlighted in yellow. Only excel functions may be used to calculate the appropriate cell value on these pages. 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 using the plus or minus symbols to help you find the appropriate number). Your balance sheet should balance when you are complete. Tip: After each journal entry, update the appropriate accounts. Select Retailer/ 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,1/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 S1,000 of merchandise to Rowdy's Inc. RRR offered Rowdy credit terms of 2/10, 1/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 550 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 568,650