Tilson Corporation has projected sales and production in units for the second quarter of the coming year as follows: April 45,000 55,000 May 35,000 45,000 June Sales 55,000 45,000 Production Cash-related production costs are budgeted at $7 per unit produced. Of these production costs, 25% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $70,000 per month. The accounts payable balance on March 31 totals $174,000, which will be paid in April. All units are sold on account for $19 each. Cash collections from sales are budgeted at 50% in the month of sale, 30% in the month following the month of sale, and the remaining 20% in the second month following the month of sale. Accounts receivable on April 1 totaled $433,000 ($93,000 from February's sales and $340,000 from March's sales). Required: a. Prepare a schedule for each month showing budgeted cash disbursements for Tilson Corporation. b. Prepare a schedule for each month showing budgeted cash receipts for Tilson Corporation.

Tilson Corporation has projected sales and production in units for the second quarter of the coming year as follows: April 45,000 55,000 May 35,000 45,000 June Sales 55,000 45,000 Production Cash-related production costs are budgeted at $7 per unit produced. Of these production costs, 25% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $70,000 per month. The accounts payable balance on March 31 totals $174,000, which will be paid in April. All units are sold on account for $19 each. Cash collections from sales are budgeted at 50% in the month of sale, 30% in the month following the month of sale, and the remaining 20% in the second month following the month of sale. Accounts receivable on April 1 totaled $433,000 ($93,000 from February's sales and $340,000 from March's sales). Required: a. Prepare a schedule for each month showing budgeted cash disbursements for Tilson Corporation. b. Prepare a schedule for each month showing budgeted cash receipts for Tilson Corporation.

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

Corporation has projected sales in units for the third quarter of the coming year as follows: July 60,000 August September 50,000 80,000 All units are sold on account for $18 each. Cash collections from sales are budgeted at 75% in the month of sale, and 25% in the month following the month of sale. June sales were $1,500,000 Required: 1. Prepare a schedule for the third quarter, showing budgeted cash receipts for Ehrlich Corporation. 2. What are budgeted accounts receivable?
Schuepfer Incorporated bases its selling and administrative expense budget on budgeted unit sales. The sales budget shows 3,500 units are planned to be sold in March. The variable selling and administrative expense is $4.00 per unit. The budgeted fixed selling and administrative expense is $35,850 per month, which includes depreciation of $5,000 per month. The remainder of the fixed selling and administrative expense represents current cash flows. The cash disbursements for selling and administrative expenses on the March selling and administrative expense budget should be: Multiple Choice $49,850 $44,850 $30,850 $14,000
A company is preparing its cash budget for the upcoming quarter. The company's sales are expected to be $500,000 in January, $600,000 in February, and $700,000 in March. The company's cost of goods sold is 60% of sales. The company's beginning cash balance is $50,000, and the company desires to maintain a minimum cash balance of $25,000. How much financing does the company need in February? $25,000 $60,000 $0 $35,000
The total budgeted sales of Obaapa Ltd for April, the first month of the second quarter in 2021 were GHS950,000. Sales are expected to increase by GHS50,000 in each month. Cash sales for each month are GHS100,000 and the remaining are credit sales. All the products are sold at a mark up of the cost plus 25 per cent. On average, Obaapa Ltd collects 50 per cent of the credit sales in the month of sale and 45 per cent in the month following sales. The remainder is uncollectible. Determine the budgeted total cash receipt for each month of the second quarter of 2021 and the expected account receivables at the end of the quarter.
Manufacturing costs are estimated to be $360,000 and $450,000 for July and August respectively. These amounts include $30,000 of monthly depreciation plant and equipment expense. Cash payments are paid such that 60% are paid in the month incurred and 40% are paid in the following month. What are the budgeted cash payments for August?
Victor Inc. has just received its sales and expense report for December, which follows. Item Amount Sales commissions $250,000 Sales staff salaries 100,000 Telephone and mailing 30,000 Building lease payment 60,000 Heat, light, and water 15,000 Packaging and delivery 30,000 Depreciation 25,000 Marketing consultants 10,000 Sales 600,000 You have been asked to develop budgeted costs for the coming year. Since this month is typical, you decide to prepare an estimated budget for a typical month in the coming year and you uncover the following additional data: • Sales volume is expected to increase by 20 percent. • Sales prices are expected to decrease by 10 percent. • Commissions are based on a percentage of selling price. • Sales staff salaries will increase 8 percent next year regardless of sales volume. • Building rent is based on a five-year lease that expires in three years. • Telephone and mailing costs are scheduled to decrease by 5 percent even with no change in sales volume.…
Primary Co. has budgeted sales of $228,000 in October and $312,000 in November. The company expects it will collect 70% of cash from sales in the month of the sale. The remaining 30% of cash will be collected the next month. What is the expected cash to be collected in November? $68,400 $286,800 $312,000 $253,200
OBUTJX493 Corporation's operational data are below: Sales are budgeted at $ 260,000 for November, $327,000 for December, and $210,000 for January. All sales are credit sales Collections are expected to be 80% in the month of sale, 19% in the month following the sale, and 1% uncollectible. The cost of goods sold is 65% of sales. The OBUTJX493 company desires to have an ending merchandise inventory at the end of each month equal to 60% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase. December cash disbursements for OBUTJX493's merchandise purchases would be:
Wala Incorporated bases its selling and administrative expense budget on the number of units sold. The variable selling and administrative expense is $3.70 per unit. The budgeted fixed selling and administrative expense is $30,360 per month, which includes depreciation of $3,630. The remainder of the fixed selling and administrative expense represents current cash flows. The sales budget shows 3,100 units are planned to be sold in July. Required: Prepare the selling and administrative expense budget for July.
Janus Inc. needs to prepare a cash budget. The following are actual and forecasted sales figures: Actual Forecast November December January February March April $200,000 $220,000 $280,000 $320,000 $340,000 $330,000 Thirty percent of each month's sales are in cash, 50% are paid the month after sale and 20% are paid two months after sale. Materials cost 30% of sales and are purchased one month prior to sale and paid for 30 days later. Labor expense is 40% of sales, selling and administrative expenses are 5% of sales and both are paid in the month of sale. Overhead is $28,000 per month, depreciation expense is $10,000 per month. Taxes of $8,000 will be paid in January and dividends of $2,000 will be paid in March. Cash on hand at the beginning of January is $80,000 and the desired cash balance is $75,000. Prepare the cash budget for January – March.
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,300 13,300 15,300 14,300 The selling price of the company's product is $22 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in the first quarter, is $72,800. The company expects to start the first quarter with 2,460 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 2,660 units.
Lea Company's sales budget shows the following projections for the year ending Dec. 31, 2021: First quarter 40,000 units Third quarter 50,000 units Second quarter 55,000 units Fourth quarter 45,000 units The quantity of finished goods inventory at the end of each quarter is equal to 40% of the next quarter's budgeted unit sales and is constantly being maintained. What is the total production budget in units for one year ending Dec. 31, 2021 assuming that the estimated sales in units on the first quarter of 2022 is 50,000