Sunbusters Ltd is a manufacturer and distributor of sunscreen products. It is approachingthe third quarter of the year, during which its peak monthly sales occur. The company isconcerned that it may experience cash shortages during this quarter and has asked the bankfor an overdraft facility to see it through this period. The bank has in turn asked Sunbustersto prepare a cash forecast for the third quarter. In response the company has collected thefollowing information:1. On 1 July, the beginning of the first quarter, the company expects to have £44,500 inits bank account.2. Actual sales for the past two months, and forecast sales for the third quarter, are asfollows:May (actual)£250,000June (actual)£300,000July (forecast)£400,000August (forecast)£600,000September (forecast)£320,000Past experience shows that 25% of any month's sales are for cash, which is collected inthe month of sale. The remainder of the sales are on credit. 70% of total sales arecollected in the month after sale, and 3% of total sales are collected in the second monthfollowing the sale. The remainder is bad debt and is not collectable.Forecast purchases and expenses for the third quarter are given below. Unless statedotherwise, all relevant expenses are paid in the month shown.JulyAugustSeptemberRaw material purchases£240,000£350,000£175,000Salaries and wages£45,000£50,000£40,000Advertising£130,000£145,000£80,000Factory rental£9,000£9,000£9,000Depreciation£10,000£10,000£10,000Raw material purchases are paid in full in the month following purchase. The amountpayable in July in respect of June purchases is expected to be £180,000.3. Equipment costing £10,000 will be purchased for cash in July.Required:A. Prepare a schedule of cash collections for July, August, and SeptemberB. Prepare a cash forecast, by month, for the third quarter

Depreciation is a non-cash expenses, so need to record the item in cash budget.

Answered: Required: A. Prepare a schedule of cash…

Required: A. Prepare a schedule of cash collections for July, August, and September B. Prepare a cash forecast, by month, for the third quarter

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

Sonoma Housewares Inc. Cash Budget For the Three Months Ending July 31 May June July Estimated cash receipts from: Cash sales $ $ Collection of accounts receivable Total cash receipts $ Estimated cash payments for: Manufacturing costs Selling and administrative expenses Capital expenditures Other purposes: Income tax Dividends Total cash payments Cash increase or (decrease) $ bala at beginning Cash balance at end of month Minimum cash balance Excess (deficiency) $
Assets Cash Minden Company Balance Sheet April 30 Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings Total liabilities and stockholders' equity $ 11, 100 72,500 37,500 238,000 $ 359,100 $ 68,000 19,400 180,000 91,700 $ 359,100 The company is in the process of preparing a budget for May and assembled the following data: a. Sales are budgeted at $255,000 for May. Of these sales, $76,500 will be for cash; the remainder will be credit sales. One-half of a month's credit sales are collected in the month the sales are made, and the remainder are collected in the following month. All of the April 30 accounts receivable will be collected in May. b. Purchases of inventory are expected to total $189,000 during May. These purchases will all be on account. Forty percent of all purchases are paid for in the month of purchase; the remainder are paid in the following…
Explain and give example of the following Management Reports Procedures Activities: Six Week Cash Flow Report
Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense* Total selling and administrative expenses Net operating income *Includes $28,000 of depreciation each month. April May June $ 600,000 $1,100,000 $ 560,000 420,000 770,000 392,000 180,000 330,000 168,000 111,000 48,000 159,000 105,000 46,000 64,800 44,000 169,800 108,600 90,000 $ 21,000 $ 160,200 $ 59,400 $ 48,000 July $460,000 322,000 138,000 67,000 41,600 b. Sales are 20% for cash and 80% on account. c. Sales on account are collected over a three-month period with 10%…
LB Enterprises (LB) is preparing its budget for the first quarter of 2019. LB's balance sheet as of December 31, 2018 is as follows: Assets Liabilities Cash $5,000 Accounts Payable $9500 Accounts Recievable 28,000 Inventories Direct Materials 8,100 Finished Goods (500 Units) 16,870 Stockholders Equity Equipment - gross 45,000 Accumulated depreciation 15.000 Common Stock $15,000 Net Equipment 30,000 Retained Earnings 63,470 Total Assets $87,970 Total Liabilities and $87,960 Equity LB sells one product for $45/unit. The Company forecasts that it will sell 2,000; 1,500; 1,600; and 1,700 units in January, February, March and April, respectively. • Sales to customers are all on credit. 40% of the cash for these sales is collected in the month of the sale and the remaining 60% is collected in the following month. LB wants finished goods inventory equal to 25% of the next month's sales on hand at the end of each month. LB wants direct materials equal to 75% of the current month's production…
1. Calculate the expected cash collections for July. 2. Calculate the expected cash disbursements for merchandise purchases for July. 3. Prepare a cash budget for July.
You are required to prepare the cash budget for the two months of January and February 2021. The following is the projected information: January 2021 February 2021 Cash sales R280,336 R305,132 Receivables collection R69,602 R70,277 Cash purchases R34,997 R36,515 Rent payment R7,545 R7,545 The bank balance on 1 January 2021 is expected to be R201,806 favourable. A fixed deposit for R113,959 is expected to mature on 25 January 2021. Equipment to the value of R142,119 is to be purchased on credit in January 2021 and will be paid in full on 28 February 2021. The expected closing bank balance on 31 January 2021 will be R _________ .
The business needs to have a sense of its future cash flows and therefore requires the preparation of the following: 1. A schedule of budgeted cash collections for trade receivables (sales on account) for each of the months July to September. 2. A schedule of expected cash disbursements for accounts payable (purchases on account) for each of the months July to September. 3.
The budgeted monthly statement of profit or loss is drawn up on the basis of cash received and cash paid while the month-by-month cash budget is drawn up on the accruals basis. True False
The amount of prepaid expense reflected in the disbursement section of the cash budget is the same amount that is found on the monthly operating statement. True False
4C. Draw up a cashbudget for Amal showing the balance at the end of each month, from the following information for the six months from July to December 2019: (a) Opening cash (including bank) balance on 1 July 2019 OMR 3600 (b) Production in units: Jan 500 Feb800 March 700 April 900 May1000 June850 July890 Aug1050 Sep650 Oct750 Nov 900 Dec800 (c) Raw materials used in production cost OMR 25 per unit. Of this, 75 per cent is paid in the month of production and remaining balance in the month after production. (d) Direct labour costs of OMR 20 per unit are payable in the month of production. (e) Variable expenses are OMR 10 per unit, payable 50 per cent in the same month as production and remaining balance in the month after production. (f) Sales at OMR 70 per unit: Jan 450 Feb 600 March 900 April 800 May 850 June 700 July 1,000 Aug 800 Sep 900 Oct 500 Nov 600 Dec 750 Debtors to pay their accounts one month after that in which sales is made (g) Fixed expenses of OMR 1,200 per month…
Determine if the following items can be found on a Balance Sheet, cash flow statement, or a budget. *Current value of your investment account. *Spending patterns for the past few months.