Patrick's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month January. February. Sales Revenue $250,000 350,000 Month March.... April All sales are on credit; 75% is collected during the month of sale, and 25% is collected during the next month. Cost of goods sold is 70% of sales. Payments for merchandise sold are made in the month fol- lowing the month of sale. Operating expenses total $125,000 per month and are paid during the month incurred. The cash balance on February 1 is estimated to be $55,000. Required Prepare monthly cash budgets for February, March, and April. Patrick's Retail Company Cash Budgets February, March, and April February March 55,000 $ 262,500 x 175,000 x 125,000 x 205,000 * $ Cash balance, beginning $ Total Cash receipts Cash available Total disbursements Cash balance, ending $ Sales Revenue $400,000 375,000 April 205,000 x $ 222,500 x 387,500✔ 381,250✔ 245,000 * 280,000 x 125,000 x 125,000 x 222,500 x 198,750 x $

Spacely Sprockets' sales budget shows the following expected total sales: Month January February March April Sales $31,700 $41,700 $36,700 $31,700 The company expects 80% of its sales to be on account (credit sales). Credit sales are collected as follows: 30% In the month of sale and 68% In the month following the sale, with the remainder being uncollectible and written off in the month following the sale. Required: a. Calculate budgeted accounts receivable at the end of each month from February through April. b. Calculate budgeted cash Inflows from collection of receivables for each month from February through April. Note: Round your Intermediate calculations and final answers to the nearest whole dollar amount. a. Budgeted accounts receivable Answer is not complete. b. Budgeted cash inflows from collection of receivables February March April S 17,752 S 23,352 $ 20,552

Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the coming year. The income statements for the last four quarters follow: Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income First Quarter Second Quarter Third Quarter Fourth Quarter $ 174,000 $ 264,000 87,000 132,000 87,000 132,000 $ 214,000 107,000 107,000 21,400 17,400 26,400 $ 69,600 $ 85,600 $ 105,600 Historically, cost of goods sold is about 50 percent of sales revenue. Selling and administrative expenses are about 10 percent of sales revenue. Fred Arvada, the chief executive officer, told Mr. Long that he expected sales next year to be 10 percent for each respective quarter above last year's level. However, Rita Banks, the vice president of sales, told Mr. Long that she believed sales growth would be only 5 percent. Required a. Prepare a pro forma income statement including quarterly budgets for the coming year using Mr. Arvada's estimate. b. Prepare…

Lexi Company budgets unit sales of 1,510,000 in April, 1,210,000 in May, 320,000 in June, and 1,940,000 in July. Beginning inventory on April 1 is 604,000 units, and the company wants to have 40% of next month's unit sales in inventory at the end of each month. The merchandise cost per unit is $0.50. Prepare a merchandise purchases budget for the months of April, May, and June. LEXI COMPANY Merchandise Purchases Budget April May June Next period budgeted sales units Ratio of inventory to future sales Total required units Units to purchase Cost per unit Cost of merchandise purchases $ $ $

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 $300,000 May $500,000 June $200,000 Total $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: 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 quarter. Schedule of Expected Cash Collections February sales March sales April sales May sales June…