Peak sales for General Products, Inc. occur in September. The company's sales budget for the third quarter showing these peak sales is given below. July Budgeted sales.... P885,500 August P1,018,000 PI,222,000 P3,125,500 September Total From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, that another 70% is collected in the month following sale, and that the remaining 10% is collected in the second month following sale. Bad debts are negligible and can be ignored. May sales totaled P700,000 and June sales totaled P770,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter. 2. Assume that the company will prepare a budgeted balance sheet of abor 30. Compute the accounts receivable as of the date.

Peak sales for General Products, Inc. occur in September. The company's sales budget for the third quarter showing these peak sales is given below. July Budgeted sales.... P885,500 August P1,018,000 PI,222,000 P3,125,500 September Total From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, that another 70% is collected in the month following sale, and that the remaining 10% is collected in the second month following sale. Bad debts are negligible and can be ignored. May sales totaled P700,000 and June sales totaled P770,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter. 2. Assume that the company will prepare a budgeted balance sheet of abor 30. Compute the accounts receivable as of the 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

Blossom Bakery has budgeted sales revenues as follows: Credit sales Cash sales Total sales April $45,900 12,240 $58,140 April $34,680 May 37,740 Past experience indicates that 40% of the credit sales will be collected in the month of sale, and the remaining 60% will be collected in the following month. Purchases of inventory are all on credit, and 20% will be paid in the month of purchase with the balance paid in the month following purchase. Budgeted inventory purchases are: Other budgeted amounts include: (a) selling and administrative expenses of $25,296 each month and (b) dividends of $8,364 to be paid in May. Included in the selling and administrative expenses is depreciation expense of $1,938. Beginning Cash Balance Add The company wishes to maintain a minimum cash balance of $4,080 at the end of each month. The company borrows money from the bank at 4% interest if necessary to maintain the minimum cash balance. Borrowed money is repaid in months when there is an excess cash…
Cypress Inc. has the following budgeted sales for the next quarter.Month: 1 2 3Units: 10,000 11,000 12,000Inventory of finished goods on hand at the beginning of the quarter is 7,000 units. The company desires to maintain ending inventory equal to beginning inventory plus 5,000 units every month.Calculate the total quantity to be produced during the quarter.
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 May June Total $ 360,000 $ 560,000 $ 220,000 $ 1,140,000 From past experience, the company has learned that 30% of a month's sales are collected in the month of sale, another 60% 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 $290,000, and March sales totaled $320,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? > Answer is not complete. 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…
Kingston budgets total sales for June and July of $330,000 and $408,000, respectively. Cash sales are 65% of total sales. Of the credit sales, 15% are collected in the month of sale, 65% are collected during the first month after the sale, and the remaining 20% are collected in the second month after the sale. Determine the amount of accounts receivable reported on the company's budgeted balance sheet as of July 31. Hint: Determine the percent of June and July sales that are uncollected at July 31. Sales month Total Sales June July Total S 330,000 408,000 Credit Sales As of July 31 Percent Uncollected Amount Uncollected
Sanjay
Weather Change, Co. reports the following information from its sales budget: Budgeted sales (units) July 18,000 August 19,200 September 20,400 October 21,800 November 24,100 December 25,900 The budgeted sales price per unit is $72. The company desires each month’s ending finished goods inventory to equal 15% of the following month’s sales, and the company desires each month’s ending raw materials inventory to equal 25% of the following month’s budgeted production needs. Each unit of output requires 8 grams of materials and each gram of material costs $2.00. The firm budgets that each unit will take 2.5 hours to complete and the labor rate is $14.00 per DL hour. Variable factory overhead is estimated to be $3.00 per DL hour. There is no fixed factory OH. The budgeted variable selling, general, and administrative expenses are $2.00 per unit sold and the budgeted fixed selling, general, and administrative expenses are $89,450 total per…
Vishnu
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. 2. What is the accounts receivable balance on June 30th?
Majan company has budgeted sales in units for the next five months as follows: June 5,400 units July 6,500 units August 7,000 units September 8,200 units October 4,800 units Past experience has shown that the ending inventory for each month should be equal to 10% of the next month's sales in units. The inventory on May 31 is 400 units. The company needs to prepare a Production Budget for the next five months. The total number of units to be produced in August is a. 7,120 units b. 7,420 units c. 7,170 units d. 8,520 units W P
Kingston budgets total sales for June and July of $430,000 and $338,000, respectively. Cash sales are 65% of total sales. Of the credit sales, 25% are collected in the month of sale, 65% are collected during the first month after the sale, and the remaining 10% are collected in the second month after the sale. Determine the amount of accounts receivable reported on the company’s budgeted balance sheet as of July 31. Hint: Determine the percent of June and July sales that are uncollected at July 31. As of July 31 Sales month Total Sales Credit Sales Percent Uncollected Amount Uncollected June $430,000 July 338,000 Total
Elordi Engineers Corp. has the following budgeted sales data (in dollars): June July August September Credit Sales 290,000 300,000 260,000 310,000 Cash Sales 70,000 70,000 70,000 70,000 The regular pattern of collection of credit sales is 30% in the month of sale, 60% in the month following sale, and the remainder in the second month following the month of sale. There are no bad debts. What would the budgeted cash receipts during September be? Round your answer to the nearest whole number.
Atlantic Surf manufactures surfboards. The company’s budgeted sales units for the next three months is shown below. Company policy is to maintain finished goods inventory equal (in units) to 50% of the next month’s unit sales. As of June 30, the company has 1,950 finished surfboards in inventory. July August September Budgeted sales units 3,900 7,400 4,500 Prepare the production budget for the months of July and August.