Preparing an Accounts Payable Schedule Wight Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: April $374,400 May 411,100 June 416,700 Wight typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?

Preparing an Accounts Payable Schedule Wight Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: April $374,400 May 411,100 June 416,700 Wight typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?

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

Schedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March). The Accrued Expenses Payable balance on January 1 is $15,000. The budgeted expenses for the next three months are as follows: January February March Salaries $56,900 $ 68,100 $ 72,200 Utilities 2,400 2,600 2,500 Other operating expenses 32,300 41,500 44,700 Total $91,600 $112,200 $119,400 Other operating expenses include $3,000 of monthly depreciation expense and $500 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 70% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical…
Cash disbursements schedule Maris Brothers, Inc., needs a cash disbursement schedule for the months of April, May, and June. Use the format given here and the following information in its preparation. Sales: February $493,000; March $517,000; April $539,000; May $627,000; June $660,000; July $651,000 Purchases: Purchases are calculated as 65% of the next month's sales, 12% of purchases are made in cash, 55% of purchases are paid for 1 month after purchase, and the remaining 33% of purchases are paid for 2 months after purchase. Rent: The firm pays rent of $8,020 per month. Wages and salaries: Base wage and salary costs are fixed at $5,700 per month plus a variable cost of 7.3% of the current month's sales. Taxes: A tax payment of $54,700 is due in June. Fixed asset outlays: New equipment costing $74,900 will be bought and paid for in April. Interest payments: An interest payment of $30,100 is due in June. Cash dividends: Dividends of $13,000 will be paid in April. Principal repayments…
Using the following data for for Rodriguez Art Studio to prepare a cash follow forecast. - Sales revenue: $10,000 March, $10,000 April, $9,000 May, $11,000 June. - Payment from customers is 50% paid in cash, 50% paid on one months credit - Direct Costs $5,500 April, $4,950 May, $6,060 June. - Opening Cash Balance in April $1,200 - Indirect Costs are $5,100 per month. What is the Total Cash inflow in May? Options -$4,500 -$11,200 -$10,000 -$9,500 What is the Net Cash flow in April? Options -$-600 -$660 -$-610 $600
Preparing a Sales Budget Patrick Inc. sells industrial solvents in 5-gallon drums. Patrick expects the following units to be sold in the first 3 months of the coming year: January 41,000 February 38,000 March 50,000 The average price for a drum is $37. Required: Prepare a sales budget for the first 3 months of the coming year, showing units and sales revenue by month and in total for the quarter. Do not include a multiplication symbol as part of your answer. Patrick Inc. Sales Budget For the Coming Quarter January February March 1st Quarter Total Units Price 2$ Sales
Assume a merchandising company provides the following information from its master budget for the month of May: Sales Cost of goods sold Selling and administrative expenses Accounts receivable, May 1st Accounts receivable, May 31st If all of the company's sales are on account, what is the amount of cash collections from customers included in the cash budget for May? Multiple Choice $109,000 $106,000 $129,000 $ 125,000 $ 90,000 $ 24,000 $ 16,000 $ 35,000 $125,000
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $127,000 November 159,000 December 232,000 The Accounts Receivable balance on September 30 was $85,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. OfficeMart Inc.Schedule of Cash Collections from SalesFor the Three Months Ending December 31 October November December Receipts from cash sales: Cash sales $fill in the blank 1 $fill in the blank 2 $fill in the blank 3 September sales on account:…
Schedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accrued Expenses Payable balance on January 1 is $25,600. The budgeted expenses for the next three months are as follows: January February $58,900 $71,700 $79,400 4,900 5,400 6,400 45,400 49,500 54,500 $109,200 $126,600 $140,300 Other operating expenses include $3,200 of monthly depreciation expense and $700 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 80% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Salaries Utilities Other operating expenses Total Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for Operations…
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customer while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remainim 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October November December $109,000 136,000 199,000 The Accounts Receivable balance on September 30 was $73,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dolla OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 November Receipts from cash sales: Cash sales September sales on account: Collected in October October sales on account: Collected in October Collected in November November sales on account: October…
Schedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March). The Accrued Expenses Payable balance on January 1 is $25,600. The budgeted expenses for the next three months are as follows: January February March Salaries $58,900 $71,700 $79,400 Utilities 4,900 5,400 6,400 Other operating expenses 44,800 48,800 53,800 Total $108,600 $125,900 $139,600 Other operating expenses include $3,200 of monthly depreciation expense and $700 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 70% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December.
X-Tel budgets sales of $55,000 for April, $110,000 for May, and $70,000 for June. Sales are 50% cash and 50% on credit. All credit sales are collected in the month following the sale. Total sales for March were $13,000. Prepare a schedule of cash receipts from sales for April, May, and June Sales Cash receipts from: Total cash receipts X-TEL Schedule of Cash Receipts from Sales April $ $ 55,000 $ 0 $ May 110,000 $ 0 $ June 70,000 0
Schedule of cash payments for a service company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accrued Expenses Payable balance on January 1 is $26,200. The budgeted expenses for the next three months are as follows: January February March Salaries $60,300 $73,400 $81,200 Utilities 5,000 5,500 6,600 Other operating expenses 46,400 50,600 $5,700 Total $111,700 $129,500 $143,500 Other operating expenses include $3,300 of monthly depreciation expense and $800 of monthly insurance expense that was prepaid for the year on May 1 of the previous year of the remaining expenses, 80% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for…
Schedule of cash collections of accounts receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 30% pay their accounts in the month of sale, while the remaining 70% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $58,000 November 65,000 December 72,000 The Accounts Receivable balance on September 30 was $35,000. Prepare a schedule of cash collections from sales for October, November, and December. Enter all amounts as positive numbers. OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 Line Item Description Receipts from cash sales: Cash sales September sales on account: Collected in October October sales on account: Collected in October Collected in November November sales on account: Collected…