Cash budget-Basic Grenoble Enterprises had sales of $49,600 in March and $60,300 in April. Forecast sales for May, June, and July are $69,900, $79,600, and $99,500, respectively. The firm has a cash balance of $5,500 on May 1 and wishes to maintain a minimum cash balance of $5,500. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 18% of sales for cash, 60% are collected in the next month, and the remaining 22% are collected in the second month following sale. (2) The firm receives other income of $1,700 per month. (3) The firm's actual or expected purchases, all made for cash, are $49,700, $70,200, and $80,400 for the months of May through July, respectively. (4) Rent is $2,500 per month. (5) Wages and salaries are 8% of the previous month's sales. (6) Cash dividends of $2,800 will be paid in June. (7) Payment of principal and interest of $4,300 is due in June. (8) A cash purchase of equipment costing $6,000 is scheduled in July. (9) Taxes of $5,600 are due in June.

Cash budget-Basic Grenoble Enterprises had sales of $49,600 in March and $60,300 in April. Forecast sales for May, June, and July are $69,900, $79,600, and $99,500, respectively. The firm has a cash balance of $5,500 on May 1 and wishes to maintain a minimum cash balance of $5,500. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 18% of sales for cash, 60% are collected in the next month, and the remaining 22% are collected in the second month following sale. (2) The firm receives other income of $1,700 per month. (3) The firm's actual or expected purchases, all made for cash, are $49,700, $70,200, and $80,400 for the months of May through July, respectively. (4) Rent is $2,500 per month. (5) Wages and salaries are 8% of the previous month's sales. (6) Cash dividends of $2,800 will be paid in June. (7) Payment of principal and interest of $4,300 is due in June. (8) A cash purchase of equipment costing $6,000 is scheduled in July. (9) Taxes of $5,600 are due in June.

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter6: Receivables And Inventories

Section: Chapter Questions

Problem 6.6.5MBA

See similar textbooks

Similar questions

Month Cash Sales Sales on Account Purchases August $85,000 $640,000 $420,000 September $70,000 $550,000 $550,000 October $88,550 $600,000 $500,000 November $77,160 $800,000 $600,000 December $174,870 $500,000 $450,000 i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50% in the month of sale30% in the first month following the sale20% in the second month following the sale ii) Expected purchases include monthly cash purchases of 5%. All other purchases are on account. Accounts payable are settled as follows, in accordance with the credit terms –2/30, n60:60% in the month in which the inventory is purchased40% in the following month iii) Fixed operating expenses which accrue evenly throughout the year, are estimated to be $1,680,000 per annum, (including depreciation on non-current assets of $420,000 per annum) and is settled monthly. iv) Wages and salaries are…
MC Qu. 9-80 Rainbow, Inc. began operations on January... Rainbow, Inc. began operations on January 1 of the current year with a $12,800 cash balance. Fifty percent of sales are collected in the month of sale; 50% are collected in the month following sale. Similarly, 10% of purchases are paid in the month of purchase, and 90% are paid in the month following purchase. The following data apply to January and February: January February Sales $ 43,000 $ 63,000 Purchases 34,000 48,000 Operating expenses 7,800 9,800 If operating expenses are paid in the month incurred and include monthly depreciation charges of $3,300, determine the change in Rainbow’s cash balance during February. Multiple Choice $7,800 increase. $11,100 increase. $16,900 increase. $20,200 increase. None of the answers is correct.
Q3: Lovett Company provides this information for the month of November, 2022: sales on credit $140,000; cash sales $50,000; sales discount $2,000; and sales returns and allowances $8,000. Prepare the sales revenues section of the income statement based on this information.
Jan Feb March Purchases on account $260,000 $293,000 $330,000 The vendors have required the following terms of payment: Month of purchase 30% First month after the purchase 35% Second month after the purchase 35% Calculate the total payment on account for the month of March.
H#5 My Aunt’s Closet Store collects 60% of its accounts receivable in the month of sale and 35% in the month after the sale. Given the following sales, how much cash will be collected in March? Feb: $20,000 March: $60,000 April: $70,000
Month Sales Purchases Cash Expenses Paid May $ 97,000 $ 64,000 $ 23,000 June 119,000 92,000 28,000 July 131,000 115,000 33,500 August 125,000 71,000 30,100 The majority of Martin’s sales (70 percent) are cash, but a few of the excursion companies purchase on credit. Of the credit sales, 35 percent are collected in the month of sale and 65 percent are collected in the following month. All of Martin’s purchases are on account with 40 percent paid in the month of purchase and 60 percent paid the following month. Determine budgeted cash collections for July and August. Determine budgeted cash payments for July and August.
Question 7 : MNO Company's credit sales policy is to have: 50% of the sales amount in cash 30% collected after one month 20% after two months. The purchasing policy is to pay 60% in cash and the rest is to be paid after one month. Required: Calculate the net accounting profit for December. Calculate the net cash flow for December. Comment on the difference between the two previous answers. Item October November December Sales 400,000 350,000 450,000 Purchases 350,000 340,000 420,000
4B. 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 2020: (a) Opening cash (including bank) balance on 1 July 2020 OMR 8000 (b) Production in units: Jan Feb March April May June July Aug Sep Oct Nov Dec 600 720 810 900 960 1,050 1,110 1,140 1,020 930 780 750 (c) Raw materials used in production cost OMR 30 per unit. Of this, 60 per cent is paid in the month of production and remaining balance in the month after production (d) Direct labour costs of OMR 15 per unit are payable in the month of production. (e) Variable expenses are OMR 5 per unit, payable 40 per cent in the same month as production and remaining balance in the month after production (f) Sales at OMR 70 per unit: Jan Feb March April May June July Aug Sep Oct Nov Dec 500 600 700 960 870 1,000 900 1,050 1,200 950 850 800 Debtors to pay…
47. Keep Calm Company provided the following information for the current year: Accounts receivable, January 1 2,100,000 Accounts receivable, December 31 2,700,000 Collections of accounts during the year 9,000,000 Inventory, January 1 4,500,000 Purchases during the year 5,800,000 All sales are made on account. The mark up on cost is 20% What is the estimated inventory at December 31?
Age of ReceivablesApril 30, 20X1 (1) (2) (3) (4) Month ofSales Age ofAccount Amounts Percent ofAmount Due April 0–30 $ 131,250 _______ March 31–60 93,750 _______ February 61–90 112,500 _______ January 91–120 37,500 _______ Total receivables $ 375,000 100% a. Calculate the percentage of amount due for each month.
Sales(all credit sales) Purchases(all credit purchases) Wages Manufacturing Expenses Office Expenses Selling Expenses March 60,000 36,000 9,000 4,000 2,000 4,000 April 62,000 38,000 8,000 3,000 1,500 5,000 May 64,000 33,000 10,000 4,500 2,500 4,500 June 58,000 35,000 8,500 3,500 2,000 3,500 July 56,000 39,000 9,500 4,000 1,000 4,500 August 60,000 34,000 8,000 3,000 1,500 4,500 You are given the following further information. Plant costing $16,000 is due for delivery in July payable 10% on delivery and the balance after three months. Advance tax of $8,000 is payable in March and also the same amount of tax is payable in June. Period of credit allowed (i) by suppliers is 2 months and (ii) to customers is one month. Lag in payment of manufacturing expenses is half a month. Lag in payment of all other expenses is one…
What would be the cash disbursements for month 3? Description Month 1 Month 2 Month 3 Month 4 Material Purchases $ 175,000.00 $ 185,000.00 $ 215,000.00 $ 190,000.00 Amount paid in month of purchase 65.00% Amount paid in month after purchase 30.00% Amount paid two months after purchase 5.00% Discounts in month of purchase 3.50% Discount in month after purchase 1.00% Total Cash disbursements in month 3 Show your work below Description Month 1 Month 2 Month 3