Schedule of Cash Collections of Accounts Receivable
OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows:
| October | $118,000 |
| November | 148,000 |
| December | 216,000 |
The Accounts Receivable balance on September 30 was $79,000.
Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar.
| OfficeMart Inc. | |||
| Schedule of Cash Collections from Sales | |||
| For the Three Months Ending December 31 | |||
| October | November | December | |
| Receipts from cash sales: | |||
| Cash sales | $ | $ | $ |
| September sales on account: | |||
| Collected in October | |||
| October sales on account: | |||
| Collected in October | |||
| Collected in November | |||
| November sales on account: | |||
| Collected in November | |||
| Collected in December | |||
| December sales on account: | |||
| Collected in December | |||
| Total cash receipts | $ | $ | $ |
In: Accounting
The information below was used to prepare a bank reconciliation for Lorena Company at October 31:
∙ According to the bank statement, the bank balance as of October 31 was $8,765. According to the books, the cash balance as of October 31 is $9,557.
∙ Outstanding checks totaled $1,433.
∙ A customer's check for $999 was returned for NSF.
∙ October's service charge was $100.
∙ The bank collected $1,600 from a customer of Lorena Company in payment of a note receivable, including interest of $100.
∙ A new bookkeeper had errors in posting checks and recording cash receipts:
1. Check #930 for Salaries Expense written for $930, recorded as $430.
2. A cash sale for $2,300 on October 15 was not recorded by the bookkeeper since she was in a hurry to go to lunch. Ignore Cost of Goods Sold.
∙ A deposit was made by the company for $900. This was the correct amount, however, the bank made a mistake and recorded the deposit as $890.
∙ Deposits made at month-end totaled $4,516; these were not shown on the bank statement.
Required:
1. Prepare the bank reconciliation at October 31.
2. Prepare the journal entries at October 31.
In: Accounting
Schedule of Cash Collections of Accounts Receivable
OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows:
| October | $124,000 |
| November | 155,000 |
| December | 227,000 |
The Accounts Receivable balance on September 30 was $83,000.
Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar.
| OfficeMart Inc. | |||
| Schedule of Cash Collections from Sales | |||
| For the Three Months Ending December 31 | |||
| October | November | December | |
| Receipts from cash sales: | |||
| Cash sales | $ | $ | $ |
| September sales on account: | |||
| Collected in October | |||
| October sales on account: | |||
| Collected in October | |||
| Collected in November | |||
| November sales on account: | |||
| Collected in November | |||
| Collected in December | |||
| December sales on account: | |||
| Collected in December | |||
| Total cash receipts | $ | $ | $ |
In: Finance
1.) The information below was used to prepare a bank reconciliation for Lorena Company at October 31:
∙ According to the bank statement, the bank balance as of October 31 was $8,765. According to the books, the cash balance as of October 31 is $9,557.
∙ Outstanding checks totaled $1,433.
∙ A customer's check for $999 was returned for NSF.
∙ October's service charge was $100.
∙ The bank collected $1,600 from a customer of Lorena Company in payment of a note receivable, including interest of $100.
∙ A new bookkeeper had errors in posting checks and recording cash receipts:
1. Check #930 for Salaries Expense written for $930, recorded as $430.
2. A cash sale for $2,300 on October 15 was not recorded by the bookkeeper since she was in a hurry to go to lunch. Ignore Cost of Goods Sold.
∙ A deposit was made by the company for $900. This was the correct amount, however, the bank made a mistake and recorded the deposit as $890.
∙ Deposits made at month-end totaled $4,516; these were not shown on the bank statement.
Required:
1. Prepare the bank reconciliation at October 31.
2. Prepare the journal entries at October 31.
In: Accounting
Schedule of Cash Collections of Accounts Receivable
OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows:
| October | $108,000 |
| November | 135,000 |
| December | 198,000 |
The Accounts Receivable balance on September 30 was $72,000.
Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar.
| OfficeMart Inc. | |||
| Schedule of Cash Collections from Sales | |||
| For the Three Months Ending December 31 | |||
| October | November | December | |
| Receipts from cash sales: | |||
| Cash sales | $ | $ | $ |
| September sales on account: | |||
| Collected in October | |||
| October sales on account: | |||
| Collected in October | |||
| Collected in November | |||
| November sales on account: | |||
| Collected in November | |||
| Collected in December | |||
| December sales on account: | |||
| Collected in December | |||
| Total cash receipts | $ | $ | $ |
In: Accounting
Problem 8-1 (Algo) Various inventory transactions; journal entries [LO8-1, 8-2, 8-3]
Skip to question
[The following information applies to the questions
displayed below.]
James Company began the month of October with inventory of $23,000.
The following inventory transactions occurred during the month:
Problem 8-1 (Algo) Part 1
Required:
1. Assuming that the James Company uses a
perpetual inventory system, prepare journal entries for the above
transactions. (If no entry is required for a
transaction/event, select "No journal entry required" in the first
account field.)
In: Accounting
Schedule of Cash Collections of Accounts Receivable
OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 20% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows:
| October | $127,000 |
| November | 159,000 |
| December | 232,000 |
The Accounts Receivable balance on September 30 was $85,000.
Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar.
| OfficeMart Inc. | |||
| Schedule of Cash Collections from Sales | |||
| For the Three Months Ending December 31 | |||
| October | November | December | |
| Receipts from cash sales: | |||
| Cash sales | $ | $ | $ |
| September sales on account: | |||
| Collected in October | |||
| October sales on account: | |||
| Collected in October | |||
| Collected in November | |||
| November sales on account: | |||
| Collected in November | |||
| Collected in December | |||
| December sales on account: | |||
| Collected in December | |||
| Total cash receipts | $ | $ | $ |
In: Accounting
Schedule of Cash Collections of Accounts Receivable
OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows:
| October | $118,000 |
| November | 148,000 |
| December | 216,000 |
The Accounts Receivable balance on September 30 was $79,000.
Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar.
| OfficeMart Inc. | |||
| Schedule of Cash Collections from Sales | |||
| For the Three Months Ending December 31 | |||
| October | November | December | |
| Receipts from cash sales: | |||
| Cash sales | $ | $ | $ |
| September sales on account: | |||
| Collected in October | |||
| October sales on account: | |||
| Collected in October | |||
| Collected in November | |||
| November sales on account: | |||
| Collected in November | |||
| Collected in December | |||
| December sales on account: | |||
| Collected in December | |||
| Total cash receipts | $ | $ | $ |
In: Accounting
Required information
Problem 8-1 (Algo) Various inventory transactions; journal entries [LO8-1, 8-2, 8-3]
Skip to question
[The following information applies to the questions
displayed below.]
James Company began the month of October with inventory of $16,000.
The following inventory transactions occurred during the month:
Problem 8-1 (Algo) Part 1
Required:
1. Assuming that the James Company uses a
perpetual inventory system, prepare journal entries for the above
transactions. (If no entry is required for a
transaction/event, select "No journal entry required" in the first
account field.)
In: Accounting
Schedule of Cash Collections of Accounts Receivable
OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows:
| October | $111,000 |
| November | 139,000 |
| December | 203,000 |
The Accounts Receivable balance on September 30 was $74,000.
Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar.
| OfficeMart Inc. | |||
| Schedule of Cash Collections from Sales | |||
| For the Three Months Ending December 31 | |||
| October | November | December | |
| Receipts from cash sales: | |||
| Cash sales | $ | $ | $ |
| September sales on account: | |||
| Collected in October | |||
| October sales on account: | |||
| Collected in October | |||
| Collected in November | |||
| November sales on account: | |||
| Collected in November | |||
| Collected in December | |||
| December sales on account: | |||
| Collected in December | |||
| Total cash receipts | $ | $ | $ |
In: Accounting