7. From the following forecasts of income and expenditure, prepare a cash budget for threemonths January 2015 to March 2015.(Amount in Rs.)Manufacturing AdministrativeSalesPurchaseMonths|(Credit) (Credit)Wagesexpenses1150expenses1060Nov. 201430000150003000Dec. 20143500020000320010401100115012201225Jan. 201525000150002500990Feb. 2015300002000030001050Mar. 201535000225002500024001100Арг. 201540000260012001180Additional information in follows:(a) The customers are allowed a credit period of two months.(b) A dividend of Rs 10000 in payable March.(c) The creditors are allowing a credit of I month(d) Wages are paid on the Ist of the next months.(e) Lag in payment of other expenses is two months.(f) Balance of cash in hand on 1st Jan. 2015 is Rs. 15000.*****

Cash Budget:-It is a budget or planning of expected cash inflow or outflow from revenue collection…

7. From the following forecasts of income and expenditure, prepare months January 2015 to March 2015. cash budget for three (Amount in Rs.) Administrative Sales Purchase Manufacturing Months Wages (Credit) (Credit) expenses 1150 expenses 1060 Nov. 2014 30000 15000 3000 Dec. 2014 35000 20000 3200 1225 1040 Jan. 2015 25000 15000 2500 990 1100 Feb. 2015 30000 20000 3000 1050 1150 Mar. 2015 35000 22500 2400 1100 1220 Apг. 2015 40000 25000 2600 1200 1180 Additional information in follows: (a) The customers are allowed a credit period of two months. (b) A dividend of Rs 10000 in payable March. (c) The creditors are allowing a credit of I month. (d) Wages are paid on the 1st of the next months. (e) Lag in payment of other expenses is two months. (f) Balance of cash in hand on 1st Jan. 2015 is Rs. 15000. *****

7. From the following forecasts of income and expenditure, prepare months January 2015 to March 2015. cash budget for three (Amount in Rs.) Administrative Sales Purchase Manufacturing Months Wages (Credit) (Credit) expenses 1150 expenses 1060 Nov. 2014 30000 15000 3000 Dec. 2014 35000 20000 3200 1225 1040 Jan. 2015 25000 15000 2500 990 1100 Feb. 2015 30000 20000 3000 1050 1150 Mar. 2015 35000 22500 2400 1100 1220 Apг. 2015 40000 25000 2600 1200 1180 Additional information in follows: (a) The customers are allowed a credit period of two months. (b) A dividend of Rs 10000 in payable March. (c) The creditors are allowing a credit of I month. (d) Wages are paid on the 1st of the next months. (e) Lag in payment of other expenses is two months. (f) Balance of cash in hand on 1st Jan. 2015 is Rs. 15000. *****

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

The following information pertains to Yoyo Projects for the three months ended 31 May 2020: Actual Budgeted March R April R May R Revenue (20% for cash and 80% on credit) 360 000 380 000 400 000 Purchases (10% for cash 90% on credit) 240 000 280 000 320 000 Salaries and wages paid 40 000 60 000 60 000 Cash expenses 24 000 28 000 32 000 Depreciation 2 000 2 000 2 000 Additional Information: It is expected that debtors will settle their accounts as follows: 20 % in the month of invoice 70% in the month after the month of invoice, and 5% in the second month after the month of invoice The remaining 5% is usually written off as bad Trade creditors are paid in the month after purchase at a discount of 5%. 50% of the salaries and wages are weekly wages. Since wages are paid weekly, usually 10% of the wages are paid in the month following the month in which they were Expenses are paid as they The favourable…
Prepare schedules for cash receipts and cash payments, and determine the ending balances for the relevant balance sheet accounts. E10.30 (LO 4, 5) Service Environmental Landscaping Inc. is preparing its budget for the first quarter of 2022. The next step is to prepare a cash receipts schedule and a cash payments schedule. The following information has been collected: 1. Clients usually pay 50% of their fee in the month when the service is provided, 40% the next month, and 10% in the second month after receiving the service. 2. Actual service revenues for 2021 and expected service revenues for 2022 are as follows: November 2021, $90,000; December 2021, $70,000; January 2022, $110,000; February 2022, $120,000; and March 2022, $130,000. 3. The company pays for purchases of landscaping supplies (direct materials) 60% in the month of purchase and 40% the following month. Actual purchases for 2021 and expected purchases for 2022 are: December 2021, $14,000; January 2022, $13,000; February…
0. Swetres Company has the following sales forecast for the selected three-month period in 2018. April, P120,000; May, P70,000; June, P80,000. 70% of sales are collected in the month of sale, and the balance are collected in the following month. Accounts receivable balance in April 1, P100,000. Cash balance in April 1, P60,000. Minimum cash balance required is P50,000. Cash can be borrowed in the multiples of P10,000 from local bank (disregard the interest charges). What is the cash balance at the end of April assuming that cash is received only from customers and that P200,000 is the cash out during April? 11.Selected information from the accounting records of Roleg Co. is as follows: Net accounts receivable at Dec. 31, 2018, P900,000; Net accounts receivable at Dec. 31, 2019, P1,000,000; Inventories at Dec. 31, 2018, P1,100,000; Inventories at Dec. 31, 2019, P1,200,000; Accounts receivable turnover, 5 times; inventory turnover, 4 times. What is Roleg's gross margin for 2019? 12.…
The following information was taken from Pharoah Company cash budget for the month of July: Beginning cash balance $155000 Cash receipts 149000 Cash disbursements 211000 If the company has a policy of maintaining an end of the month cash balance of $155000, the amount the company would have to borrow is
Schedule of Cash Payments Select Physical Therapy Inc. is planning its cash payments for operations for the third quarter (July-September), 2017. The Accrued Expenses Payable balance on July 1 is $31,700. The budgeted expenses for the next three months are as follows: July August September Salaries $72,900 $88,800 $98,300 Utilities 6,000 6,700 7,900 Other operating expenses 55,400 60,400 66,500 Total $134,300 $155,900 $172,700 Other operating expenses include $4,000 of monthly depreciation expense and $900 of monthly insurance expense that was prepaid for the year on March 1 of the current year. Of the remaining expenses, 75% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on July 1 relates to the expenses incurred in June. Prepare a schedule of cash payments for operations for July, August, and September. Select Physical Therapy Inc. Schedule of Cash Payments for Operations For the Three Months…
Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company's costs: Fixed Cost Cost per Car Washed $ 0.70 $ 0.09 $ 0.20 $ 0.30 per Month Cleaning supplies Electricity $ 1,400 Maintenance $ 4,500 $ 8,100 $ 2,100 $ 1,400 Wages and salaries Depreciation Rent Administrative expenses $ 0.03 For example, electricity costs are $1,400 per month plus $0.09 per car washed. The company expects to wash 8,000 cars in August and to collect an average of $6.30 per car washed.
(b) A sales budget is given below for one of the products manufactured by N.Ltd .For six months ended 30th June 2021. Month Units January 60,000 February 105,000 March 180,000 April 120,000 May 90,000 June 75,000 The inventory of finished goods at the end of each month equal 20% at the next month's sales Page 1 of 4 On 1t Jan 2021, finished goods inventory totaled 12,000 units. Each unit of the product requires nine units of a specialized liquid known as HN-2, sometimes this extract is in short supply for this reason, the company has a policy of maintaining an inventory at the end of each month equal to 30%of next month's production needed. This requirement was met on 1st Jan 2021. Required Prepare a budget showing the quantity of NH-2 to be purchased each month from January, February and March and in total for the three months period (ii) What is the significance of budgeting in any business organization
Anderson Manufacturing Inc., aims to prepare a cash budget for September 2020. The cash balance at the beginning of September is $9,000. The actual sales for July and August and expected sales for September are: Information Cah Sales Sales on Accoun 0000 60,00 Tetal Sales July (5 Augut (5) Septemberis 14,300 Sales on account are collected over a three-month period in the following ratio: 10% in the month of sale, 70% in the month following sale 18% in the second month following sale 2% remaining are uncollectible. Additional information includes: (a) Purchases of inventory will total S 50,000 for September; 20% will be paid for in September. Accounts payable from August's inventory purchases is $ 32,000, all of which will be paid in September. (b) Selling and administrative expenses are budgeted at $ 26,000 for September; of which $ 8,000 is for depreciation. (c) Equipment costing $ 36,000 will be purchased for cash during September, and other miscellancous cash expenses of $ 6,000…
Crane Company expects to have a cash balance of $60,350 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $85,350, February $160,350. 2. Payments to suppliers: January $54,350, February $89,350. 3. Wages: January $30,490, February $40,490. Wages are paid in the month they are incurred. 4. Administrative expenses: January $21,490, February $24,490. These costs include depreciation of $1,000 per month. All other costs are paid as incurred. 5. Selling expenses: January $15,490, February $20,490. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize $12,490 in cash. Crane Company has a line of credit at a local bank that enables it to borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $34,350. Prepare a cash budget for January and February.
The following information was taken from Bonita Industries's cash budget for the month of July: Beginning cash balance $440000 Cash receipts 404000 Cash disbursements 558000 If the company's policy is to maintain a minimum end of the month cash balance of $430000, the amount the company would have to borrow in July is $286000. $144000. $10000. $26000.
Month ($) Wages ($) From the following information, prepare a monthly cash budget for the three months ending 31st December 2019. Sales ($) Materials Other Expenses ($) Jun. (A) 3,000 1,800 650 385 Jul. (A) 3,250 2,000 750 385 Aug. (A) 3,500 2,400 750 425 Sep.(A) 3,750 2,250 .750 475 Oct. (E) 4,000 2,300 800 500 Nov. (E) 4,250 2,500 900 550 Dec. (E) 4,500 2,600 1,000 575 (A) Actual; (E) - Estimated. = The credit terms are as follows: • Sales -10% of sales are in cash. On average, 50% of credit sales are paid in the next month, while the other 50% are paid two months after the sale. • Creditors for material are paid 2 months after purchase. • Wages and other expenses are paid the same month. The cash and bank balance on 1st October is expected to be $1,500. Other information is given as follows: • Plant and machinery are to be installed in August at a cost of $24,000. This sum will be paid in monthly installments of $500 each from 1st October. • Dividends from investments amounting to…
Accounting Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 256,167 262,962 282,872 Credit Purchases 97,465 111,565 137,292 Wages, Taxes, and Expenses 26,506 31,621 33,707 Interest 7,239 7,773 8,091 Equipment Purchases 54,832 61,271 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the following month. Credit purchases will be paid in the month following the purchase. In June, credit sales were $138,282, and credit purchases were $102,770 July’s beginning cash is $184,797 If TAP maintains a policy of always keeping a minimum cash balance of $75,000 as a buffer against uncertainty and forecasting errors, what is the cash surplus/deficit at the end of the quarter (i.e., end of…