Francis and Company has planned a cash budget for the third quarter of 2004. Thecash balance on July 1, 2004 is expected to be an overdraft of $s82,000.Extracts from the sales and purchases budgets are as follows:BudgetedBudgetedMonthSalesPurchasesMayJuneJulyAugustSeptember$800,000$900,000$750,000$650,000$800,000$600,000$550,000$450,000$500,000All sales are on credit and an analysis of the records shows that debtors settleaccording to the following pattern, in accordance with the credit terms 5/30,i)n90:50% in the month of sale30% in the month following sale20% the following monthAll purchases are on credit and past experience shows that 80% are settled inthe month of purchase in order to take advantage of a 10% prompt settlementii)discount. The balance will be disbursed in the month after purchase.The credit terms of the suppliers - 10/30, n60.iii) Wages and salaries are expected to be $1,800,000 per annum and are paidmonthly.iv)Fixed operating expenses, which accrue evenly throughout the year, areestimated to be $2,400,000 per annum, (including depreciation on fixed assetsof $60,000 per month) and is settled monthly.v)Taxation of $80,000 has to be settled in August.vijThe company is expected to receive settlement on an insurance claim of$50,000 in September.vii) Interest on investment in other companies of $25,000 is expected in July 2004.viii) A short-term investment in JMMB Ltd. of $80,000 will be liquidated inSeptember 2004.ix)The business has made arrangements with their bankers for a loan of$250,000. The loan will be disbursed in two tranches:July 1, 2004November 1, 2004$150,000$100,000 Required:Prepare a schedule of expected cash collections for sales for each of the monthsJuly to September.Prepare a schedule of expected cash disbursements for purchases for thequarter to September 30, 2004.Prepare a cash budget, with a total column, for the quarter ending September30, 2004, showing the expected receipts and payments for each month.(a)(b)(c)

The question is based on the concept of Cost Accounting.

Francis and Company has planned a cash budget for the third quarter of 2004. The cash balance on July 1, 2004 is expected to be an overdraft of $32,000. Extracts from the sales and purchases budgets are as follows: Budgeted Sales Budgeted Purchases Month May June July |August September $800,000 $900,000 $750,000 $650,000 $800,000 $600,000 $550,000 $450,000 $500,000 All sales are on credit and an analysis of the records shows that debtors settle according to the following pattern, in accordance with the credit terms 5/30, n90: 50% in the month of sale 30% in the month following sale 20% the following month

Francis and Company has planned a cash budget for the third quarter of 2004. The cash balance on July 1, 2004 is expected to be an overdraft of $32,000. Extracts from the sales and purchases budgets are as follows: Budgeted Sales Budgeted Purchases Month May June July |August September $800,000 $900,000 $750,000 $650,000 $800,000 $600,000 $550,000 $450,000 $500,000 All sales are on credit and an analysis of the records shows that debtors settle according to the following pattern, in accordance with the credit terms 5/30, n90: 50% in the month of sale 30% in the month following sale 20% the following 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

Assume the following budgeted information for a merchandising company: Budgeted sales (all on credit) for November, December, and January are $248,000, $218,000, and $209,000, respectively. • Cash collections related to credit sales are expected to be 70% in the month of sale, 30% in the month following the sale. • The cost of goods sold is 70% of sales. • Each month's ending inventory equals 20% of next month's cost of goods sold. • 30% of each month's merchandise purchases are paid in the current month and the remainder is paid in the following month. • Monthly selling and administrative expenses that are paid in cash in the month incurred total $25,000. • Monthly depreciation expense is $9.000. . The budgeted net operating income for December would be: Multiple Choice $40,400 $25,734 $16,734 $31,400
Varughese Incorporated is working on its cash budget for March. The budgeted beginning cash balance is $33,000. Budgeted cash receipts total $182,000 and budgeted cash disbursements total $191,000. The desired ending cash balance is $40,000. The excess (deficiency) of cash available over disbursements for March will be: Multiple Choice O O ($9,000) $24,000 $215,000 $42,000
Edelmar Corp. has prepared a preliminary cash budget for the third quarter as shown below: Cash Budget Beginning cash balance Plus: Cash collections Cash available Less: Cash payments: Purchases of direct materials July $36,000 $56,000 92,000 Operating expenses Capital expenditures Ending cash balance Aug $17,000 $52,000 $69,000 34,000 41,000 0 $17,000 Subsequently, the marketing department revised its figures for cash collections. New data are as follows: $54,000 in July, $55,000 in August, and $44,000 in September. Based on the new data, calculate the new projected cash balance at the end of July Sep $21,500 47,800 $69,300 9,000 30,500 8,000 $21,500 10,000 30,800 7,700 $20,800
Ruiz Company provides the following budgeted sales for the next four months. The company wants to end each month with ending finished goods inventory equal to 30% of next month's budgeted unit sales. Finished goods inventory on April 1 is 153 units. Prepare a production budget for the months of April, May, and June. Budgeted sales units. April 510 Budgeted sales units Add: Desired ending inventory Next period budgeted sales units Ratio of inventory to future sales Budgeted beginning inventory units Total required units Units to produce May 590 RUIZ COMPANY Production Budget April June 540 590 30% July 630 May 540 30% June 630 30%
Francis and Company has planned a cash budget for the third quarter of 2004. Thecash balance on July 1, 2004 is expected to be an overdraft of $82,000.Extracts from the sales and purchases budgets are as follows:MonthBudgetedSalesBudgetedPurchasesMay $800,000June $900,000 $600,000July $750,000 $550,000August $650,000 $450,000September $800,000 $500,000i) All sales are on credit and an analysis of the records shows that debtors settleaccording to the following pattern, in accordance with the credit terms 5/30,n90:50% in the month of sale30% in the month following sale20% the following monthii) All purchases are on credit and past experience shows that 80% are settled inthe month of purchase in order to take advantage of a 10% prompt settlementdiscount. The balance will be disbursed in the month after purchase.The credit terms of the suppliers - 10/30, n60.iii) Wages and salaries are expected to be $1,800,000 per annum and are paidmonthly.iv) Fixed operating expenses, which accrue evenly…
Bustillo Incorporated is working on its cash budget for March. The budgeted beginning cash balance is $36,000. Budgeted cash receipts total $117,000 and budgeted cash disbursements total $111,000. The desired ending cash balance is $53,500. To attain its desired ending cash balance for March, the company needs to borrow: Multiple Choice $95,500 $11,500 $0 $53,500
Singal Inc. is preparing its cash budget. It expects to have sales of $32,500 in January, $50,000 in February, and $47,500 in March. If 20% of sales are for cash, 40% are credit sales paid in the month after the sale, and another 40% are credit sales paid 2 months after the sale, what are the expected cash receipts for March? a. $26,000 b. $47,500 c. $42,500 d. $72,000 e. $46,000
Deschambault Inc. is working on its cash budget for December. The budgeted beginning cash balance is $14,000. Budgeted cash receipts total $127,000 and budgeted cash disbursements total $126,000. The desired ending cash balance is $40,000. To attain its desired ending cash balance for December, the company needs to borrow: A. $40,000 B. $55,000 C. $25,000 D. $0