Wolfie's Computer Store sells computer equipment and software. Most sales are on a cash basis but merchandise is also sold on account. Transaction and balance records are being established in subsidiary records for each customer as of January 1. You are taking over this task. Go to Ron Meyers sheet and examine the layout of the customer subsidiary ledger information. We could consider this first customer worksheet to be the "template layout" for all other/new customer worksheets. Wolfie's Computer Store Balance Sheet March 31, 2022 ASSETS Current Assets Cash 310,100 Accounts Receivable (net) 204,760 13,050 Merchandise Inventory Supplies Other Prepayments 9,420 Total Current Assets 537,330 Property, Plant, & Equipment 27,510 8,900 Store Equipment (net) Office Equipment (net) Total Property, Plant, & Equipment 36,410 %24 In cell F6, create a formula to calculate the balance after a transaction is posted. This formula should include the previous balance, new sale, payment or credit memos. Ron Meyers 801 So. Grand Ave., San Jose, CA 95214 Balance Date Explanation PR Debit Credit Balance 01/01/22 Balance 2,200.00 01/12/22 Sales Slip 1055 S3 190.00 Wolfie's Computer Store sells computer equipment and software. Most sales are on a cash basis but merchandise is also sold on account. Transaction and balance records are being established in subsidiary records for each customer as of January 1. You are taking over this task. Go to Ron Meyers sheet and examine the layout of the customer subsidiary ledger information. We could consider this first customer worksheet to be the "template layout" for all other/new customer worksheets. Wolfie's Computer Store Balance Sheet March 31, 2022 ASSETS Current Assets Cash 310,100 Accounts Receivable (net) 204,760 13,050 Merchandise Inventory Supplies Other Prepayments 9,420 Total Current Assets 537,330 Property, Plant, & Equipment 27,510 8,900 Store Equipment (net) Office Equipment (net) Total Property, Plant, & Equipment 36,410 %24 In cell F6, create a formula to calculate the balance after a transaction is posted. This formula should include the previous balance, new sale, payment or credit memos. Ron Meyers 801 So. Grand Ave., San Jose, CA 95214 Balance Date Explanation PR Debit Credit Balance 01/01/22 Balance 2,200.00 01/12/22 Sales Slip 1055 S3 190.00 Wolfie's Computer Store sells computer equipment and software. Most sales are on a cash basis but merchandise is also sold on account. Transaction and balance records are being established in subsidiary records for each customer as of January 1. You are taking over this task. Go to Ron Meyers sheet and examine the layout of the customer subsidiary ledger information. We could consider this first customer worksheet to be the "template layout" for all other/new customer worksheets. Wolfie's Computer Store Balance Sheet March 31, 2022 ASSETS Current Assets Cash 310,100 Accounts Receivable (net) 204,760 13,050 Merchandise Inventory Supplies Other Prepayments 9,420 Total Current Assets 537,330 Property, Plant, & Equipment 27,510 8,900 Store Equipment (net) Office Equipment (net) Total Property, Plant, & Equipment 36,410 %24 In cell F6, create a formula to calculate the balance after a transaction is posted. This formula should include the previous balance, new sale, payment or credit memos. Ron Meyers 801 So. Grand Ave., San Jose, CA 95214 Balance Date Explanation PR Debit Credit Balance 01/01/22 Balance 2,200.00 01/12/22 Sales Slip 1055 S3 190.00