xercise 8 - 1 (Algo) Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $ 330, 000 $ 530,000 $ 210,000 $1,070, 000 From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $260, 000, and March sales totaled $290, 000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?

xercise 8 - 1 (Algo) Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $ 330, 000 $ 530,000 $ 210,000 $1,070, 000 From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $260, 000, and March sales totaled $290, 000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

2. Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,620,000 Quarter 2 5,610,000 Quarter 3 1,190,000 Quarter 4 7,840,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,640,000 and for the fourth quarter of the current year are $7,320,000. Required: Question Content Area 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year $fill in the blank 0b62a1fb700f07d_1 $fill in the blank…
sales. om. Jada Mcheon Jound CASH BUDGET The MoBay Corporation`s projected sales for the first eight months of 2014 are as follows: January February 120,000 April May 240,000 300,000 June 270,000 July August 225,000 150,000 Of MoBay's sales, 10 percent is for cash, another 60 percent is collected in the month following sale, and 30 percent is collected in the second month following sale. November and December sales for 2003 were $220,000 and $175,000, respectively. MoBay purchases its raw materials two months in advance of its sales equal to 60 percent of their final sales price. The supplier is paid one month after it makes delivery. For example, purchases for April sales are made in February and payment is made in March. In addition, MoBay pays $10,000 per month for rent and $20,000 each month for other expenditures. Tax prepayments of $22,500 are made each quarter, beginning in March. The company's cash balance at December 31, 2003, was $22,000; a minimum balance of $15,000 must be…
Exercise 8-1 (Algo) Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak sales occur in May of each year, as shown in the company’s sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $ 430,000 $ 630,000 $ 200,000 $ 1,260,000 From past experience, the company has learned that 25% of a month’s sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $360,000, and March sales totaled $390,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?
Kk9. Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak sales occur in May of each year, as shown in the company’s sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $420,000 $620,000 $240,000 $1,280,000 From past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, another 65% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $350,000, and March sales totaled $380,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter.
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,690,000 Quarter 2 5,410,000 Quarter 3 4,890,000 Quarter 4 7,920,000 In Shalimar's experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,160,000 and for the fourth quarter of the current year are $7,430,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year $_______ $______ 4, current year ________ _______ 1, next year _______ _______ 2,…
QUESTION 1 Ginobili has forecast sales to be $120100 in February, $151200 in March, $162700 in April, and $174000 in May. 24% of sales are on made on credit, the rest are for cash. The sales on credit are collected 40% in the month of sale, and 60% the month following. What are the total budgeted cash receipts in April?
Yu 28.
1
Expected cash collections in December are: P54,400 P256,000 P320,000 P310,400
answer in text form please (without image)
Please dont give image based answers... thank you
Question 9