Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year. These peak sales are shown in the company's sales budget for the second quarter given below: April $300,000 May June Total eted Sales $500,000 $200,000 $1,000,000 From past experience, the company has learned that 15% of the company's sales are for cash. Credit sales are collected as follows: 20% are collected in the month of sale, another 70% are collected in the month following the sale, and the remaining 10% are collected in the second month following the sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,000. A. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. B. Assume that the company will prepare a budgeted balance sheet as of June 30. Compute the accounts receivable as of that date.

Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year. These peak sales are shown in the company's sales budget for the second quarter given below: April $300,000 May June Total eted Sales $500,000 $200,000 $1,000,000 From past experience, the company has learned that 15% of the company's sales are for cash. Credit sales are collected as follows: 20% are collected in the month of sale, another 70% are collected in the month following the sale, and the remaining 10% are collected in the second month following the sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,000. A. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. B. Assume that the company will prepare a budgeted balance sheet as of June 30. Compute the accounts receivable as of that date.

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

Jasper Company has 65% of its sales on credit and 35% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $527,000 for April, $537,000 for May, and $562,000 for June. Total sales for March are $300,100. Prepare a schedule of cash receipts from sales for April, May, and June.
Peach Corporation's only cash receipts are those derived from customer sales. Peach makes both cash sales and sales on account. For its credit sales, Peach collects 50% in the month of the sale, 40% in the month following the sale, and 10% in the second month following the sale. Peach is preparing its cash budget for the upcoming year. Sales on account for the month of March are budgeted at $150,000. The budgeted accounts receivable balance on March 1 is $113,000, of which $90,000 represents uncollected sales made in February and $23,000 represents uncollected sales made in January. If Peach's total cash receipts for the month of March are budgeted at $205,000, what are Peach's budgeted cash sales during March? O $17,000 O $35,000 $53,000 $71,000 O None of the above
Jasper Company has 57% of its sales on credit and 43% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $524,000 for April, $534,000 for May, and $559,000 for June. Total sales for March are $307,500. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Cash sales JASPER COMPANY Schedule of Cash Receipts from Sales April May Collections of prior period sales Total cash receipts 524,000 ***** 534,000 June 559,000
Jasper Company has 56% of its sales on credit and 44% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $523,000 for April, $533,000 for May, and $558,000 for June. Total sales for March are $305,700. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Cash sales JASPER COMPANY Schedule of Cash Receipts from Sales April May Collections of prior period sales Total cash receipts S S $ $ $ $ June
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 $ 430,000 Мay $ 630,000 June Total Budgeted sales (all on account) $ 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? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of expected cash collections from sales, by month and in total, for the…
Treasure Service anticipates the following sales revenue over a five-month period: Its collection history indicates that credit sales are collected as follows: E (Click the icon to view the sales data.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Done
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
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: May April $ 490,000 $ 690,000 June $ 220,000 Total $1,400,000 Budgeted sales (all on account) 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 $420,000, and March sales totaled $450,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?
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 $75,000 in June, $65,000 in July, and $90,000 in August? NOTE: Enter amounts rounded to the nearest whole dollar. Cash sales Cash for collections the month of sale Cash for collections the month after sale Cash for collections two months after sale TOTAL cash receipts S S LA
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: Budgeted sales (all on account) From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 20% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $430,000, and March sales totaled $460,000. April May June $ 500,000 $ 700,000 $ 240,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? Complete this question by entering your answers in the tabs below. February sales March sales April sales May sales June sales Total cash collections Required 1 Required 2 Prepare a schedule of expected…
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: Budgeted sales (all on account) April $300,000 May $500,000 June $200,000 Total $1,000,000 From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,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? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of expected cash collections from sales, by month and in total, for the second…