Graham Potato Company has projected sales of $12,000 in September, $15,000 in October, $22,000 in November, and $18,000 in December. Of the company's sales, 30 percent are paid for by cash and 70 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December. Also assume Graham's cash payments for November and December are $18,500 and $11,000, respectively. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. Graham Potato Company Cash Receipts Schedule Sales Credit sales Cash sales One month after sale Two months after sale Total cash receipts September October November December

Halifax Shoes has 39% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $61,125 in June, $88,627 in July, and $70,376 in August? Round to the nearest penny, two decimal places.

Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $73,000 in June, $63,000 in July, and $95,000 in August?

Assume receivables of $20,000 at the start of the January are all collected during the month; if sales for January and February are $400,000 and $300,000 respectively; the company typically receives payment from 20% of its customers within the same month, 60% the following month, and the remaining 20% by the end of the second following month, how much would accounts receivable be at the end of February?

Neon Inc.’s forecast sales for July is $72,000. It has $15,000 in accounts receivable at the end of June. 30% of its total sales are expected to be cash sales. Of the remaining 70%, 80% are expected to be collected in the month of the sale and the remaining 20% in the month following the sale. Determine the amount of accounts receivable at the end of July. Group of answer choices $79,200 $61,920 $10,080 $40,320

Millen’s managers have made the following additional assumptions and estimates Estimated sales for July and August are $310,000 and $330,000, respectively. Each month’s sales are 20% cash sales and 80% credit sales. Each month’s credit sales are collected 30% in the month of sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. Each month’s ending inventory must equal 20% of the cost of next month’s sales. The cost of goods sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July. Monthly selling and administrative expenses are always $70,000. Each month $10,000 of this total amount is depreciation expense and the remaining $60,000 relates to expenses that are paid in the month they are incurred. The company does not plan to buy or sell any plant and equipment…

Office World Inc. has “cash and carry” customers and credit customers. Office World estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 40% pay their accounts in the month of sale, while the remaining 60% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $700,000 November 650,000 December 500,000 The Accounts Receivable balance on September 30 was $290,000. Prepare a schedule of cash collections from sales for October, November, and December. Enter all amounts as positive numbers. Office World Inc.Schedule of Collections from SalesFor the Three Months Ending December 31   October November December Receipts from cash sales:       Cash sales $fill in the blank 1 $fill in the blank 2 $fill in the blank 3 September sales on account:       Collected in October fill in the blank 4     October sales on…

Prince Charles Island Company has expected sales of $6,000 in September, $10,000 in October, $16,000 in November, and $12,000 in December. Cash sales are 20 percent and credit sales are 80 percent of total sales. Historically, 40 percent of receivables are collected in the month after the sale, and the remaining 60 percent collected two months after. Assume that the company's cash payments for November are $13,000, and December $6,000. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. Sales Credit sales Cash sales Collections in the month after credit sales Collections two months after credit sales Total cash receipts Prince Charles Island Company Cash Receipts Schedule September S Cash receipts Cash payments Net cash flow Prince Charles Island Company Cash Budget November Beginning cash balance Cumulative cash balance. Monthly loan or (repayment). Cumulative loan balance. Ending cash…

Valley's managers have made the following additional assumptions and estimates: Estimated sales for July and August are $345,000 and $315,000 respectively Each month's sales are 20% cash sales and 80% credit sales.  Each month's credit sales are collected 30% in the month of the sale and 70% in the month following the sale.  All of the accounts receivable at June 30 will be collected in July Each month's ending inventory must equal 20% of the cost of the next month's sales.  The Cost of Goods Sold is 60% of sales.  The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase.  All of the accounts payable at June 30 will be paid in July Monthly selling and administrative expenses are always $75,000.  Each month $10,000 of this total amount is depreciation expense and the remaining $65,000 relates to expenses that are paid in the month they are incurred The company does not plan to buy or…

Manisha