**Instruction:**1. Prepare a cash receipts budget for July, August, and September.---**Table: Cash Receipts Budget**Title: BUILT-TIGHT**For July, August, and September**| | July | August | September ||--------------------------|------|--------|-----------|| Less: Ending accounts receivable | | | || Cash receipts from: | | | || | | | || | | | || **Total cash receipts** | | | |---**Explanation:**This table is designed to track the cash receipts for the company "BUILT-TIGHT" over three months: July, August, and September. It helps in planning and monitoring cash inflow, excluding ending accounts receivable, and lists the sources of cash receipts. The bottom of the table calculates the total cash received each month. **Master Budget Preparation for Built-Tight****Quarter Ending September 30**Built-Tight is preparing its master budget for the quarter ending September 30. Below are the budgeted sales and cash payments for product costs for the quarter:**Budgeted Sales and Cash Payments**- **July** - Sales: $64,000 - Cash Payments for Direct Materials: $16,160 - Direct Labor: $4,040 - Factory Overhead: $20,200 - **August** - Sales: $80,000 - Cash Payments for Direct Materials: $13,440 - Direct Labor: $3,360 - Factory Overhead: $16,800 - **September** - Sales: $48,000 - Cash Payments for Direct Materials: $13,760 - Direct Labor: $3,440 - Factory Overhead: $17,200**Sales Information**- 20% of sales are made in cash.- 80% of sales are made on credit, collected in the month following the sale.**Financial Policy**- Minimum cash balance required: $15,000.- Loans are obtained at the end of each month when cash shortages occur.- Interest on loans is 1% per month, calculated on the beginning-of-the-month balance.- Excess cash is used to repay loans each month.**Operating Expenses**- Operating expenses are paid in the month they are incurred.- Components include: - Sales Commissions: 10% of sales - Office Salaries: $4,000 per month - Rent: $6,500 per month**Initial Financial Balances as of June 30**- Cash Balance: $15,000- Accounts Receivable: $45,000- Loans Payable: $5,000**Task**1. Prepare a cash receipts budget for July, August, and September.This detailed breakdown aids in understanding the financial planning and cash flow management necessary for Built-Tight to operate smoothly over the specified quarter.

Budgeting: It is a process of planning the work to be performed. Under this process a formal plan is…

Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for product costs for the quarter follow: July $64,000 $80,000 August September $ 48,000 Budgeted sales Budgeted cash payments for Direct materials 16,160 4,040 20,200 13,440 3,360 16,800 13,760 3,440 17,200 Direct labor Factory overhead Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $45,000 in accounts receivable; and a $5,000 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month- end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($4,000 per month), and rent ($6,500 per month).

Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for product costs for the quarter follow: July $64,000 $80,000 August September $ 48,000 Budgeted sales Budgeted cash payments for Direct materials 16,160 4,040 20,200 13,440 3,360 16,800 13,760 3,440 17,200 Direct labor Factory overhead Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $45,000 in accounts receivable; and a $5,000 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month- end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($4,000 per month), and rent ($6,500 per month).

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

Elroy Corporation bases its manufacturing overhead budget on budgeted direct labor-hours. The variable overhead rate is $2.90 per direct labor-hour. The company's budgeted fixed manufacturing overhead is $198,560 per month, which includes depreciation of $28,970. All other fixed manufacturing overhead costs represent current cash flows. The July direct labor budget indicates that 9,800 direct labor-hours will be required in that month. Required: SHOW YOUR WORK in budget format a. Determine the cash disbursements for manufacturing overhead in good form, including heading, for January 2024b. Determine the predetermined overhead rate for July. (Round your answer to 2 decimal places.)
Lemon, Inc. has prepared the following budgets for March. In March, budgeted production is 1,000 units, budgeted sales is 1,200 units, and direct materials inventory and unit costs will stay constant. Direct materials $ 12,750 Direct labor $ 19,150 Manufacturing overhead $ 24,750 Selling and administrative expense $ 20,750 What is budgeted cost of goods sold for March? Multiple Choice $65,980 $56,650 $54,424 $67,980
ABC Company's budgeted sales for June, July, and August are 13,000, 17,000, and 14,700 units respectively. The following cost behavior patterns are budgeted for ABC Company's operating expenses each month: Fixed costs: salaries, $2,500; rent, $5,500; depreciation, $2,900; advertising, $3,700 Mixed costs: utilities, $3,500 + $0.40 per unit Variable costs per unit sold: sales commissions, $2.50; marketing promotions, $1.50; supplies, $0.45; bad debt expense, $0.20 Required: Prepare ABC Company's operating expense budget for June, July, and August. Note: Enter all values as positive value.
Prepare a flexible production budget for the year ending December 31 for Cedar Jeans Company using production levels of 16,000, 18,000, and 20,000 units produced. The following additional information is necessary to complete the budget: Variable costs: Direct labor ($6.00 per unit) Direct materials ($8.00 per unit) Variable manufacturing costs ($2.50 per unit) Fixed costs: Supervisor's salaries $80,000 Rent 12,000 Depreciation on equipment 24,000
Required information [The following information applies to the questions displayed below.] Morganton Company makes one product and it provided the following information to help prepare the master budget: a. The budgeted selling price per unit is $65. Budgeted unit sales for June, July, August, and September are 9,000, 21,000, 23,000, and 24,000 units, respectively. All sales are on credit. b. Thirty percent of credit sales are collected in the month of the sale and 70% in the following month. c. The ending finished goods inventory equals 30% of the following month's unit sales. d. The ending raw materials inventory equals 20% of the following month's raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. The raw materials cost $2.70 per pound. e. Twenty percent of raw materials purchases are paid for in the month of purchase and 80% in the following month. f. The direct labor wage rate is $14 per hour. Each unit of finished goods requires two…
ABC Company’s budgeted sales for June, July, and August are 13,000, 17,000, and 14,700 units respectively. The following cost behavior patterns are budgeted for ABC Company’s operating expenses each month: Fixed costs: salaries, $2,500; rent, $5,500; depreciation, $2,900; advertising, $3,700 Mixed costs: utilities, $3,500 + $0.40 per unit Variable costs per unit sold: sales commissions, $2.50; marketing promotions, $1.50; supplies, $0.45; bad debt expense, $0.20 Required: Prepare ABC Company’s operating expense budget for June, July, and August. Note: Enter all values as positive value.
Bonkowski Corporation makes one product and has provided the following information to help prepare the master budget for the next four months of operations: Budgeted selling price per unit Budgeted unit sales (all on credit): January February March April Raw materials requirement per unit of output Raw materials cost Direct labor requirement per unit of output Direct labor wage rate Predetermined overhead rate (all variable) Variable selling and administrative expense Fixed selling and administrative expense Credit sales are collected: 30% in the month of the sale 70% in the following month Raw materials purchases are paid: 30% in the month of purchase 70% in the following month $ 97 10,000. 12,000 13,300 15,200 4 pounds $ 1.00 per pound 2.5 direct labor-hours $ 23.00 per direct labor- hour per direct labor- hour $9.00 $ 3.10 per unit sold. $70,000 per month. The ending finished goods inventory should equal 30% of the following month's sales. The ending raw materials inventory should…
Phoenix Company reports the following fixed budget. It is based on an expected production and sales volume of 15,200 units. Sales Costs Direct materials Direct labor PHOENIX COMPANY Fixed Budget For Year Ended December 31 Sales staff commissions Depreciation-Machinery. Supervisory salaries Shipping Sales staff salaries (fixed annual amount) Administrative salaries Depreciation-office equipment Income $ 3,040,000 1,003, 200 212,800 45,600 295,000 202,000 228,000 246,000 457,400 198,000 $ 152,000 Problem 8-1A (Algo) Preparing and analyzing a flexible budget LO P1 Required: 1&2. Prepare flexible budgets at sales volumes of 14,200 and 16,200 units. 3. The company's business conditions are improving. One possible result is a sales volume of 18,200 units. Prepare a simple budgeted income statement if 18,200 units are sold. Complete this question by entering your answers in the tabs below.
he manufacturing overhead budget at Rost Corporation is based on budgeted direct labor-hours. The direct labor budget indicates that ,300 direct labor-hours will be required in September. The variable overhead rate is $8.5 per direct labor-hour. The company's budgeted ixed manufacturing overhead is $58,120 per month, which includes depreciation of $5,140. All óther fixed manufacturing overhead costs represent current cash flows. The September cash disbursements for manufacturing overhead on the manufacturing overhead budget should be: Multiple Choice $89,530. O $94,670. $36,550.
Vinall Corporation makes one product and has provided the following information to help prepare the master budget for the next four months of operations: Budgeted selling price per unit $ 86 Budgeted unit sales (all on credit): July 9, 550 August 11, 800 September 10, 450 October 11,400 Raw materials requirement per unit of output 2.1 pounds Raw materials cost $ 2.1 per pound Direct labor requirement per unit of output 2.3 direct labor-hours Direct labor wage rate $ 25.5 per direct labor-hour Credit sales are collected: 30% in the month of the sale 70% in the following month Raw materials purchases are paid: 20% in the month of purchase 80% in the following month The ending finished goods inventory should equal 20% of the following month's sales. The ending raw materials inventory should equal 20% of the following month's raw materials production needs. PLEASE SHOW ALL EQUATIONS IN EXCEL FORMAT! Required: What are the budgeted sales for August? What are the expected cash collections…
Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Cost Formulas Direct labor $16.40q Indirect labor $4,000 + $1.40q Utilities $5,300 + $0.30q Supplies $1,600 + $0.10q Equipment depreciation $18,500 + $3.00q Factory rent $8,200 Property taxes $2,500 Factory administration $13,600 + $0.60q The Production Department planned to work 4,400 labor-hours in March; however, it actually worked 4,200 labor-hours during the month. Its actual costs incurred in March are listed below: Actual Cost Incurred in March Direct labor $ 70,480 Indirect labor $ 9,340 Utilities $ 7,010 Supplies $ 2,250 Equipment depreciation $ 31,100 Factory rent $ 8,600 Property taxes $ 2,500 Factory…
Marst Corporation's budgeted production in units and budgeted raw materials purchases over the next three months are given below: January February March Budgeted production (in units) Budgeted raw materials purchases (in pounds) 71,600 88,000 201,633 175,600 166,800 Three pounds of raw materials are required to produce one unit of product. The company wants raw materials on hand at the end of each month equal to 21% of the fol production needs. The company is expected to have 45,108 pounds of raw materials on hand on January 1. Budgeted production for February should be: Multiple Choice 119,960 units 88,600 units 88,000 units 50,700 units