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

X Corp has budgeted sales (in units) for the upcoming quarter as follows: Jan is 15,000; Feb is 18,000 and March is 16,500 units. The ending FG inventory for each month equals 50% of the next months budgeted sales. Additionally, 3 pounds of DM (Direct Materials) are required to produce each FG (Finished Goods) unit processed. The ending DM inventory for each month equals 200% of next month's production requirements. If DM cost P4.00 per kilos and must be paid for in the month of purchased, the budgeted DM purchases (in pesos) for January are? choices: 96,584 102,346 98,182 None of the above
LB Hardware is a company in the retail industry. Assume it is the end of the year and they are preparing their budgets for the upcoming year. The following information is available: Expected sales are: January 280 000€; February 220 000€. The company's Cost of Sales is 30% of sales. The company's purchasing policy is to buy 80% in the month of sale and 20% in the month before sale. Variable selling and administrative expenses are budgeted at 10% of sales except for a provision of bad debts which came to 2 000€ in January. Also bad debts expected to be actually written off during January come to 1 000€. Fixed selling and administrative expenses are budgeted at 30 000€ every month which excludes depreciation of 5 000€. The company is paying a 15 000€ instalment per month in order to pay back a long-term loan. Of this amount 5 000€ represents interest payment and 10 000€ payment on the principal amount. The company's tax rate is 20% and tax is paid at the end of the year. Required:…
The marketing department of Jessi Corporation submitted the following sales forecast for next year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11,800 12,800 14,800 13,800 Budgeted unit sales The selling price of the company's product is $17 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made and 30% in the following quarter; 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 $71,800. The company expects to start the first quarter with 1,770 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 15% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,970 units. Required: 1. Calculate the estimated sales for each quarter and for the year as a whole. 2. Calculate the expected cash collections…
Omega DB Company has a sales budget for next month of P150,000. Cost of goods sold is expected to be 40 percent of sales. All goods are purchased in the month used and paid for in the month following purchase. The beginning inventory of merchandise is P5,000, and an ending inventory of P6,000 is desired. Beginning accounts payable is P38,000.For Omega DB Company, the ending accounts payable should be
The sales budget of a company for November and December is 46,000 units and 48,000 units, respectively. its production budget for the same two months is 43,000 units and 44,000 units, respectively. Each unit of finished goods requires 4 pounds of raw materials. The company always maintains raw materials inventory equal to 20% of the following months production needs. Assume the company pays $2.75 per pound of raw material. It alvways pays for 50% of its raw material purchases in the month of purchase and the remainder in the following month. The accounts payable balance on October 31 is $146,000. What amount would the company show in their November cash budget for cash disbursements for raw material purchases? Multiple Choice $391,600 $382,850 $388,600 $383,600 ( Prev 4 of 23 MacBook Ain
Blue Wave Co. predicts the following unit sales for the coming four months: September, 3,300 units; October, 4,900 units; November, 6,700 units; and December, 7,900 units. The company's policy is to maintain finished goods inventory equal to 50% of the next month's sales. At the end of August, the company had 2,800 finished units on hand. Prepare a production budget for each of the months of September, October, and November. Blue Wave Co. Production Budget September, October and November September Next month's budgeted sales (units) Units to be produced % October % November %
The marketing department of Jessi Corporation submitted the following sales forecast for next year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12,900 13,900 15,900 14,900 Budgeted unit sales The selling price of the company's product is $28 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made and 20% in the following quarter; 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 $74,000. The company expects to start the first quarter with 2,580 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,780 units. Required: 1. alculate the estimated sales for each quarter and for the year as a whole. 2. Calculate the expected cash collections…
Riverbed Company expects to produce 1,272,000 units of Product XX in 2022. Monthly production is expected to range from 84,800 to 127,200 units. Budgeted variable manufacturing costs per unit are direct materials $5, direct labor $6, and overhead $8. Budgeted fixed manufacturing costs per unit for depreciation are $2 and for supervision are $1. Prepare a flexible manufacturing budget for the relevant range value using 21,200 unit increments. (List variable costs before fixed costs. Activity Level Finished Units RIVERBED COMPANY Monthly Flexible Manufacturing Budget For the Year 2022 84800 106000 127200 Variable Costs Direct Materials $ 424000 530000 636000 Direct Labor Overhead 508800 636000 763200 678400 848000 1017600 Total Variable Costs 1611200 2014000 2416800 Fixed Costs Depreciation Supervision Total Fixed Costs Total Costs +A 424000 424000 424000 424000 636000 2247200 $ 212000 636000 2650000 EA 212000 636000 3052800
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
Pouch Corporation is working on its direct labor budget for the next two months. Each unit of output requires 0.90 direct labor-hours. The direct labor rate is $9.90 per direct labor-hour. The production budget calls for producing 2,600 units in June and 2,400 units in July. If the direct labor work force is fully adjusted to the total direct labor-hours needed each month, what would be the total combined direct labor cost for the two months? $44,550.00 $22,275.00 $21,384.00 $23,166.00
Vaughan company estimates that unit sales will be 10,500 in quarter 1; 11,400 in quarter 2; 13,400 in quarter 3; and 18600 in quarter 4. management wnta to have an ending finished goods inventory equal to 21% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first six months of 2022