Here are some important figures from the budget of Nashville Nougats, Inc., for thesecond quarter of 2018:Credit salesCredit purchasesCash disbursementsWages, taxes, andAprilMayJune$322,000 $302,000 $362,000130,000 153,000 178,00044,20011,70063,200expensesInterestEquipment purchases11,200 11,20082,000 154,00011,200The company predicts that 5 percent of its credit sales will never be collected, 40percent of its sales will be collected in the month of the sale, and the remaining 55percent will be collected in the following month. Credit purchases will be paid in themonth following the purchase.In March 2018, credit sales were $192,000 and credit purchases were $132,000. Usingthis information, complete the following cash budget: (Do not round intermediatecalculations. Leave no cells blank - be certain to enter "O" wherever required.)Beginning cash balanceCash receiptsCash collections from credit salesTotal cash availableCash disbursementsPurchasesWages, taxes, and expensesInterestEquipment purchasesTotal cash disbursementsEnding cash balanceAprilMay125,000June

Answered: Image /qna-images/answer/a90dcf30-ab46-470a-8527-0f6cee05dbea.jpg

Answered: Here are some important figures from…

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 13EA: What is the amount of budgeted cash payments if purchases are budgeted for $420,000 and the...

See similar textbooks

Similar questions

Splish Company has accumulated the following budget data for the year 2022: 1. 2. 3. 4. 5. 6. 19 Sales: 27,900 units; unit selling price $82 Cost of one unit of finished goods: direct materials, 2 kg at $5 per kilogram; direct labour, 3 hours at $13 per hour; and manufacturing overhead, $6 per direct labour hour Inventories (raw materials only): beginning, 9,900 kg; ending, 14,100 kg Raw materials cost: $5 per kilogram Selling and administrative expenses: $201,000 Income taxes: 30% of income before income taxes
Here are some important figures from the budget of Crenshaw, Inc., for the second quarter of 2019. April May June Credit sales $ 689,000 $ 598,000 $ 751,000 Credit purchases 302,000 282,000 338,000 Cash disbursements Wages, taxes, and expenses 137,000 129,000 179,000 Interest 15,600 15,600 15,600 Equipment purchases 53,500 6,600 248,000 The company predicts that 5 percent of its credit sales will never be collected, 35 percent of its sales will be collected in the month of the sale, and the remaining 60 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2019, credit sales were $561,000. Using this information, complete the following cash budget: (Do not round intermediate calculations and round your answers to the nearest whole number,…
Please draft a budgeted receipt schedule from debtors for the period of 1 January 2023 to 30 June 2023. Month of 2023 Budgeted total sales: 1. January 140 000 2. February 132 000 3. March 128 000 4. April 115 000 5. May 120 000 6. June 150 000 Additional information: Total sales for September 2022, October 2022, November 2022 and December 2022 were R 120 000, R128 000 and R134 000 and R140 000 respectively. The goods sold on credit were 60% of actual sales. Customers will pay their debt as follows: . ⚫ 0% in the first month after the month of sale • 60% in the second month after the month of sale • 30% in the third month after the month of sale 10% in the fourth month after the month of sale
shown below are the totals from 2018 period budgets. Revenue badget P 100,000 Materials usage from production budget 15,000 Labor cost budget 20,000 Manufacturing overhead budget 20,000 General and administrative budget 30,000 Capital Expenditure budget 20,000 Work in progress inventories Beginning of 2018 10,000 End of 2018 5,000 Finished goods inventory Beginning of 2018 15,000 End of 2018 10,000 Tax Rate 40% 1. prepared a forecasts income statement for the year.
I ne Tollowing information is available from various budgets for the current period: Account Cash Accounts Receivable Merchandise Inventory Insurance Expense (expense incurred during the period) Equipment Depreciation Expense - Equipment (expense incurred during the period) Budget Cash budget Amount $20,000 Schedule of cash receipts from customers 38,000 Inventory, purchases, and cost of goods sold budget 47,000 Selling and administrative expense budget 2,000 Capital expenditures budget 31,000 Selling and administrative expense budget 1,000 The following balances are available from the balance sheet at the end of the previous year: Prepaid Insurance Equipment Accumulated Depreciation Equipment $6,000 22,000 1,000 What would be the amount of total assets on the budgeted balance sheet?
the task of preparing the cash budget for the business for the quarter ending September 30, 2022. Your data collection has yielded the following:i) Extracts from the sales and purchases budgets are as follows:Month CashSales SalesOn Account CashPurchases PurchasesOn AccountMay $75,000 $480,000 $390,000June $135,000 $600,000 $36,000 $360,000July $86,800 $720,000 $61,700 $450,000August $105,600 $640,000 $68,800 $400,000September $112,500 $800,000 $77,250 $500,000ii) An analysis of the records shows that trade receivables (accounts receivable)…
Using a separate columnar worksheet or Excel worksheet, prepare a Cash Budget by month for the quarter ending September 30, 2021, from the following data obtained from the CONSCIOÜNESS Company. Support your solution with schedules of estimated receipts and payments. August P 16,000 150,000 July September Cash Sales P 12,000 P 18,000 Credit Sales Purchases 110,000 120,000 90,000 120,000 110,000 Operating expenses Interest expense 15,000 18,000 16,000 2,000 Credit sales are collected 50% in the month of sales, 40% on the month following, 8% in the second month following and 2% uncollectible. Credit sales for May and June are expected to be P100,000 and P90,000, respectively. Purchases of merchandise, all on account, are paid 60% in the month of purchase and 40% in the month following. Purchases for June are estimated at P80,000. Expenses include depreciation of P2,000 monthly, and are paid in the month incurred. Cash balance on June 30, 2021.
ONLY ANSWER QUESTION (B) the task of preparing the cash budget for the business for the quarter ending September 30, 2022. Your data collection has yielded the following:i) Extracts from the sales and purchases budgets are as follows:Month CashSales SalesOn Account CashPurchases PurchasesOn AccountMay $75,000 $480,000 $390,000June $135,000 $600,000 $36,000 $360,000July $86,800 $720,000 $61,700 $450,000August $105,600 $640,000 $68,800 $400,000September $112,500 $800,000 $77,250 $500,000ii) An analysis of the records shows that trade…
Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2020: April May June Credit sales $ 312,000 $ 292,000 $ 352,000 Credit purchases 120,000 143,000 168,000 Cash disbursements Wages, taxes, and expenses 43,200 10,700 62,200 Interest 10,200 10,200 10,200 Equipment purchases 72,000 134,000 0 The company predicts that 5 percent of its credit sales will never be collected, 40 percent of its sales will be collected in the month of the sale, and the remaining 55 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2020, credit sales were $182,000, and credit purchases were $122,000. Using this information, complete the following cash budget. (Do not round intermediate calculations.)
Your data collection has yielded the following: (i) Extracts from the sales and purchases budgets are as follows: Month November 2023 - March 2024 Cash Sales Sales on Account Purchases November $151,000 $480,000 $375,000 December $145,500 $600,000 $360,000 January $159,025 $700,000 $508,000 February $169,350 $650,000 $400,000 March $176,200 $800,000 $521,000 An analysis of the records shows that trade receivables (accounts receivable) are settledaccording to the following credit pattern, in accordance with the credit terms 2/30, n90:45% in the month of sale30% in the first month following the sale.25% in the second month following the sale. (iii) Expected purchases include cash purchases of $28,000 in January and $21, 000 in March.All other purchases are on account. Accounts payable are settled as follows, in accordancewith the credit terms 4/30, n60:75% in the month in which the inventory is purchased.25% in the following month (iv) The management of Toyota &…
Use the information given below to prepare the following for Altech Limited for July and August 2021:1.1 Debtors Collection Schedule 1.2 Cash Budget Note: Provide separate monetary columns for each month. Where applicable, round off amounts to the nearest Rand.Information:Extract of Statement of Comprehensive Income for the month ended 30 June 2021RSales 200 000Cost of sales 100 000Rent income 8 000Advertising 4 000Salaries and wages 10 000Rates and taxes 1 200Electricity 3 000Other operating expenses 9 000Additional information:1. The business uses a fixed mark-up of 100% on cost.2. Sales are expected to increase by 10% each month.3. Thirty percent (30%) of the sales are for cash and the balance is on credit. Collections from credit sales are as follows: 40% in the month of the sale, and these customers are entitled to a 2% discount; 55% one month after the sale. The balance is usually written off as bad debts.4. Closing Inventories are kept at a constant level. 50% of purchases…
Prepare a Budgeted Statement of Financial Position as at 31 December 2022 using the below information: Statement of comprehensive income for the year ended 31 December 2021Sales 10 000 000Cost of sales (5 750 000)Gross profit 4 250 000Variable selling and administrative expenses (1 500 000)Fixed selling and administrative expenses (500 000)Net profit 2 250 000 Statement of financial position as at 31 December 2021ASSETSNon-current assets 800 000Property, plant and equipment 800 000Current assets 3 400 000Inventories 1 600 000Accounts receivable 600 000Cash 1 200 000 4 200…

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

SEE MORE TEXTBOOKS