Silver Company makes a product with peak sales in May of each year. Its sales budget for the second quarter is given below: Budgeted sales (all on account) April $410,000 May $ 610,000 June $ 210,000 Total $ 1,230,000 The company estimates 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 $340,000, and March sales totaled $370,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

Silver Company makes a product with peak sales in May of each year. Its sales budget for the second quarter is given below: Budgeted sales (all on account) April $410,000 May $ 610,000 June $ 210,000 Total $ 1,230,000 The company estimates 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 $340,000, and March sales totaled $370,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

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

Sherman has budgeted sales for the upcoming quarter as follows: April: 1, 600 units May: 1,900 units June: 1,750 units The desired ending finished goods inventory for each month is one - half of next month's budgeted sales. Three pounds of direct material are required for each unit produced. If direct material costs $5 per pound, and must be paid for in the month of purchase, the budgeted direct materials purchases (in dollars) for May are: Group of answer choices $1,975 $9, 875 $27, 750 $13, 875
Walker Company prepares monthly budgets. Company policy is to end each month with merchandise inventory equal to 15% of budgeted unit sales for the following month. Budgeted sales and merchandise purchases for the next three months follow. Beginning inventory on July 1 is 27,000 units. The company budgets sales of 200,000 units in October. The merchandise cost per unit is $2. Budgeted sales units. Units to purchase July 180,000 200,250 August 315,000 308,250 September 270,000 259,500 Prepare the merchandise purchases budgets for the months of July, August, and September. WALKER COMPANY Merchandise Purchases Budget July August September Next period budgeted sales units Ratio of inventory to future sales 0 0 0 Total required units Units to purchase Cost per unit Cost of merchandise purchases
Tasty Foods expects to have 20,000 units of finished goods inventory on hand on March 31 and reports the following expected sales (in units) for the months of April through July: April 120,000 May June July 130,000 140,000 120,000 At the end of each month the company desires its ending finished goods inventory to be 20% of the next month's projected sales (in units). The budgeted production (in units) for Tasty Foods for May should be: A. 104,000. B. 128,000. C. 130,000. D. 132,000. E. 138,000. A O B C D E
Dhapa
Multiple Choice Gallonte Inc. began operations in April of this year. It makes all sales on account, subject to the following collection pattern: 20% are collected in the month of sale; 70% are collected in the First month after sale; and 10% are collected in the second month after sale. If sales for April, May, and June were $80,000, $140,000, and $130,000, respectively, what were the firm's budgeted collections for the quarter? $201,000. $220,000. $232,000. $292,000. Help None of the answers is correct. Save & EXIL SUB
Silver Company makes a product with peak sales in May of each year. Its sales budget for the second quarter is given below: April May June Total Budgeted sales (all on account) $300,000 $500,000 $200,000 $1,000,000 The company estimates 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: Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. What is the accounts receivable balance on June 30th?
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…
Harris Inc., has budgeted sales in units for the next five months as follows: June July August September October 9,400 units 7,800 units 7,300 units 5,400 units 4,100 units Past experience has shown that the ending inventory for each month should be equal to 20% of the next month's sales in units. The inventory on May 31 contained 1,880 units. The company needs to prepare a production budget for the next five months.
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?
Moore Wholesalers is preparing its merchandise purchases budget. Budgeted sales are $400,000 for April and $480,000 for May. Cost of goods sold is expected to be 65% of sales. The company’s desired ending inventory is 20% of the following month’s cost of goods sold.Compute the required purchases for April. Moore WholesalersPurchases Budget $ : : $
Bright Minds Toy Company prepared the following sales budget for the second quarter. Projected sales for each of the first three months of operations are as follows: Sales Budget Cash Sales Sales on Account April May June 95,000 69,000 120,000 435,000 484,000 470,000 530,000 553,000 590,000 Bright Minds expects to collect 70% of the sales on account in the month of sale, 20% in the month following the sale, and the remainder in the second month following the sale. What is the ending accounts receivable balance that would be reported on the pro forma balance sheet prepared as of June 30?