Concept explainers
a.
Introduction:
Cash collection schedule:
A cash collection schedule refers to the amount which is receivable for the business enterprise in different time periods.
Given Information: Company G assumes that sales will continue to 20% for cash and 80% on credit, April to June period 25%, 65%, and 10% respectively. Its ending inventory levels from April to June at 15% of the cost of the merchandise and the merchandise inventory in March end is $84,000 with a $126,000 payable amount.
Requirement 1
To prepare: A schedule of expected cash collections for April, May, and June, and the quarter in total.
b.
Introduction:
Merchandise purchases budget:
Given Information: Company G assumes that sales will continue to 20% for cash and 80% on credit, April to June period 25%, 65%, and 10% respectively. Its ending inventory levels from April to June at 15% of the cost of the merchandise and the merchandise inventory in March end is $84,000 with a $126,000 payable amount.
Requirement 2
To prepare: (a) A merchandise purchases budget for April, May, and June and (b) a schedule of expected cash disbursements for merchandise purchases for April, May, June, and Quarters in total.
c.
Introduction:
A cash budget refers to the forecasted cash flow of a business enterprise in a particular time period.
Given Information: Company G assumes that sales will continue to 20% for cash and 80% on credit, April to June period 25%, 65%, and 10% respectively. Its ending inventory levels from April to June at 15% of the cost of the merchandise and the merchandise inventory in March end is $84,000 with a $126,000 payable amount.
Requirement 3
To prepare: A cash budget for April, May, June, and Quarters in total.
d.
Introduction:
Cash budget:
A cash budget refers to the forecasted cash flow of a business enterprise in a particular time period.
Given Information: Company G assumes that sales will continue to 20% for cash and 80% on credit, April to June period 25%, 65%, and 10% respectively. Its ending inventory levels from April to June at 15% of the cost of the merchandise and the merchandise inventory in March end is $84,000 with a $126,000 payable amount.
Requirement 4
To prepare: A brief memorandum for the company’s president that shows how his revised assumptions affect the cash budget.
Want to see the full answer?
Check out a sample textbook solutionChapter 8 Solutions
MANAGERIAL ACCOUNTING F/MGRS.
- Required: glored. 00. nidam aillim olgmoo Using Schedule 1 as your guide, prepare a schedule of expected cash collections from sales, 1. to vilidaliavs b by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? EXERCISE 8–2 Production Budget L08-3 Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the nay four months as follows: qlan nig Unit Sales oism oq April.... May .. June.... 50,000 bo 75,000 lloe be 90,000 .00A88 80,000 lo iben o ao wol July ... The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of-month inventory levels must equal 10% of the following month s unit sales. The inventory at the end of March was 5,000 units. Required: Using Schedule 2 as your guide, prepare a production budget by month and in total, for the second quarter. bottle of Mink Caress, a very popular perfume made eted pro- EXERCISE 8–3 Direct…arrow_forwardThe Chapter 8 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text. Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: a. What are the total expected cash collections for the year under this revised budget? b. What is the total required production for the year under this revised budget? c. What is the total cost of raw materials to be purchased for the year under this revised budget? d. What are the total expected cash disbursements for raw materials for the year under this revised budget? e. After seeing this revised budget, the production manager cautioned that due to the current production constraint, a complex milling machine, the plant can produce no more than 90,000 units in any one quarter. Is this a potential problem?arrow_forwardces A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $10,000 to start each quarter. Required: Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) Cash balance, beginning Add collections from customers Total cash available Less disbursements. Purchase of inventory Selling and administrative expenses Equipment purchases Dividends Total disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments (including interest) * Total financing Cash balance, ending *Interest will total $1,000 for the year. $ 1 9 71 80 50 13 2 (5) Quarter (000 omitted) 2 3 60 45 9 2 116 16 111 30 25 2 12 4 34 2 (30) (000 omitted) Year 389 119 57arrow_forward
- Budgeting-Create a forecasted balance sheet from the following information. I need an explanation on how to get the accounts receivable, ending merchandise inventory, accounts payable, and owner's equity columns for the balance sheet. Data Section: Actual and Budgeted Unit Sales: April 1,500 May 1,000 June 1,600 July 1,400 August 1,500 September 1,200 Balance Sheet, May 31, 19X5 Cash $8,000 Accounts receivable 107,800 Merchandise inventory 52,800 Fixed assets (net) 130,000 -------- Total assets $298,600 ======== Accounts payable (merchandise) $74,800 Owner's equity 223,800 -------- Total liabilities & equity $298,600 ======== Average selling price $98 Average purchase cost per unit $55 Desired ending inventory (% of next…arrow_forwardQuestion 1 The following data is available from the various functional budgets prepared at Nur Ika Enterprise for the year 2022: January RM '000 February RM '000 March RM '000 April RM 000 Cash sales 128 84 72 90 Credit sales 640 1,140 880 760 800 Purchases for resale Salaries and wages Overhead expenses 560 520 320 266 280 238 248 160 150 160 140 Other information is available as follows: (1) 5% of all sales on credit are expected to become bad debts. Receipts from credit customers are due in the following sales. All goods are bought on credit from suppliers who allow 2.5% cash discount for payment in the month following purchase. (ii) (iii) Salaries and wages are paid in the month they are earned. (iv) Payments for overhead expenses are made in the month the expenses are incurred. The above overhead budget includes RM28,000 per month for depreciation. Purchase two new vans, costing RM21,000 each, are to be paid in April. (v) (vi) Rental for new office amounting RM175,000 is to be…arrow_forwardExercise 7 (Cash Budget Analysis) A cash budget, by quarters, is given below for a retail company. (000 omitted). The company requires a minimum cash balance of P5,000 to start each quarter. Quarter 1 2 3 4 Year Cashbalance,beginning.. P9 P ? P ? P? P? Add collectionsfromcustomers.... ? ? 125 ? 391 Totalcash available... 85 ? ? Less disbursements: Purchaseofinventory. 40 58 ? 32 Operatingexpenses. 42 54 ? 180 Equipmentpurchases.. 10 8 8 36 Dividends... 2 2 2 2 ? Totaldisbursement.. 110 ? ? ? Excess (deficiency) of cash available Ordisbursements.... (3) 30 ? ? Financing: Borrowings.. ? 20 Repayments (including interest)*.. (?) (7) (?) Total financing... ? ? (?) (?) Cash balance, ending.... P ? P ? P ? P ? P? *Interest will total P4, 000 for the year. Required: Fill in the missing amounts in the table above.arrow_forward
- All of the accounts payable are for inventory purchases and all inventory items are purchased on account. What are the estimated cash disbursements for inventories for the budget period? * (1 Point) Sample format: 1,111,111 NUBD Co., a merchandising firm, is preparing its master budget and has gathered the following data to help budget cash disbursements: Budgeted data: Cost of goods sold Desired decrease in inventories Desired decrease in accounts payable P1,680,000 P80,000 P150,000arrow_forwardA cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of $8,000 to start each quarter. Required: Fill in the missing amounts. Note: Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign. Cash balance, beginning Add collections from customers Total cash available Less disbursements: Purchase of inventory Selling and administrative expenses Equipment purchases Dividends Total disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments (including interest)" Total financing $ 9 87 38 10 2 (2) Quarter (000 omitted) 2 3 48 30 10 2 90 14 99 30 13 2 16 30 2 (17) (000 omitted) Year 348 121 43arrow_forwardthis is actually a budgeting lesson. Beginning inventory 4.000 unit Ending inventory 3.500 unit The lack will be allocated to the 5 months (Jan, Feb, March, April dan May). Arrange production budget with a policy that accentuate production stability!arrow_forward
- CASH BUDGETING Rework Problem 15-10 using a spreadsheet model. After completing Parts a through d, respond to the following: If Bowers customers began to pay late, collections would slow down, thus increasing the required loan amount. If sales declined, this also would have an effect on the required loan. Do a sensitivity analysis that shows the effects of these two factors on the maximum loan requirement.arrow_forwardCASH BUDGETING Rework problem 15-10 using a spreadsheet model. After completing parts a through d, respond to the following: If Bowers customers began to pay late, collections would slow down, thus increasing the required loan amount. If sales dedined, this also would have an effect on the required loan. Do a sensitivity analysis that shows the effects of these two factors on the maximum loan requirement. 15-10 CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017. May 2016 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale. 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2016 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depredation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2016. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if ail financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain. e. f. g. h.arrow_forward-/1 Question 11 View Policies Current Attempt in Progress A company's past experience indicates that 60% of its credit sales are collected in the month of sale, 30% in the next month, and 5% in the second month after the sale; the remainder is never collected. Budgeted credit sales were: ort $310000 January 166000 February 490000 March The cash inflow in the month of March is expected to be O $294000. O $359300 O $240300. O $343800. hp ho l t 44 12 Su prt sc delete home enc & 7 backspace lock T Y P home K enter 4 M N Iarrow_forward
- Fundamentals of Financial Management, Concise Edi...FinanceISBN:9781285065137Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningFundamentals of Financial Management, Concise Edi...FinanceISBN:9781305635937Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning