...CASE STUDY 3 - Cash Budget | | | | | | | | | | | | | | | | | | SCHEDULE OF EXPECTED CASH COLLECTIONS FROM CUSTOMERS: | | | Credit Sales | | | May | June | April | | (94,000 * 0.70) = 65,800 | 65,800 | | May | | (89,500 * 0.30) = 26,850, June (89,500 * 0.70) = 62,650 | 26,850 | 62,650 | June | | (75,000 * 0.30) = 22,500 | | 22,500 | Total Cash Collections | | 92,650 | 85,150 | | | | | | | | | | | SCHEDULE FOR EXPECTED PAYMENTS FOR PURCHASE OF INVENTORY | | | Inventory purchases | | May | June | April | | (195,000 * 0.60 ) = 117,000 | 117,000 | | May | | (135,000 * 0.40) = 54,000, June (135,000 * 0.60) = 81,000 | 54,000 | 81,000 | June | | (63,000 * 0.40) = 25,200 | | 25,200 | Total Payments for Inventory Purchases | 171,000 | 106,200 | | | | | | | | | | | | LBJ Company | | | | Cash Budget | | | | For the Two Months of May and June | | | | | | May | June | Cash balance | | | $20,000 | $20,000 | Add: Receipts | | | | Collections from customers | 92,650 | 85,150 | Sale of plant assets | | 33,000 | | Sale of new common stock | | 50,000 | Cash sales | | | 75,000 | 57,000 | Total receipts | | | 200,650 | 192,150 | Total Available Cash | | 220,650 | 212,150 | Less: Disbursements | | | | Purchases of inventory | | 171...
Words: 674 - Pages: 3
...CASE STUDY 3 - Cash Budget Template SCHEDULE OF EXPECTED CASH COLLECTIONS FROM CUSTOMERS: Credit Sales July August September Total Cash Collections August 12,000 14,400 26,400 SCHEDULE FOR EXPECTED PAYMENTS FOR PURCHASE OF INVENTORY Inventory purchases July August September Total Payments for Inventory Purchases August 32,500 22,500 55,000 Oxford Company Cash Budget For the Two Months of August and September Cash balance Add: Receipts Collections from customers Sale of plant assets Sale of new common stock Cash sales Total receipts Total Available Cash Less: Disbursements Purchases of inventory Operating expenses Selling and administrative expenses Dividends Equipment purchase Total disbursements Excess (deficiency of available cash over disbursements) Financing Borrowings Repayments Ending cash balance Please answer the 3 qualitative questions on the next tab called Qualitative Questions. August $10,000 26,400 12,350 51,000 89,750 99,750 55,000 6,750 12,500 19,000 93,250 6,500 3,500 $10,000 September 9,600 10,800 20,400 September 22,500 10,500 33,000 September $10,000 20,400 16,850 39,000 76,250 86,250 33,000 6,750 12,500 6,000 58,250 28,000 (3,570) 24,430 1) 2) 3) What are the three sections of a Cash Budget, and what is included in each section? Cash receipts section: This section includes cash that is expected to be recieved from company activity and customer payments. This includes money coming in from the sale of Cash disbursements...
Words: 550 - Pages: 3
...FI504 Case Study 3 on Cash Budgeting The cash budget was covered during Week 4 when we covered TCO D and you read Chapter 7. There is also a practice case study to work on. Your Professor will provide the solution to the practice case study at the end of Week 5. This case study should be uploaded by 11:59PM Mountain time of the Sunday ending Week 6 to the Week 6 Assignment Dropbox. You are encouraged to use the Excel template file provided in Doc Sharing. The Oxford Company has budgeted sales revenues as follows: July August September Credit sales $30,000 $24,000 $18,000 Cash sales 18,000 51,000 39,000 Total sales $48,000 $75,000 $57,000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Purchases of inventory are all on credit and 50% is paid in the month of purchase and 50% in the month following purchase. Budgeted inventory purchases are $65,000 in July, $45,000 in August, and $21,000 in September. Other budgeted cash receipts: (a) sale of plant assets for $12,350 in August, and (b) sale of new common stock for $16,850 in September. Other budgeted cash disbursements: (a) operating expenses of $6,750 each month, (b) selling and administrative expenses of $12,500 each month, (c) dividends of $19,000 will be paid in August, and (d) purchase of equipment for $6,000 cash in September. The company has a cash balance of $10...
Words: 561 - Pages: 3
...FI504 Case Study 3 on Cash Budgeting The cash budget was covered during Week 4 when we covered TCO D and you read Chapter 7. There is also a practice case study to work on. Your Professor will provide the solution to the practice case study at the end of Week 5. This case study should be uploaded by 11:59PM Mountain time of the Sunday ending Week 6 to the Week 6 Assignment Dropbox. You are encouraged to use the Excel template file provided in Doc Sharing. The Oxford Company has budgeted sales revenues as follows: July August September Credit sales $30,000 $24,000 $18,000 Cash sales 18,000 51,000 39,000 Total sales $48,000 $75,000 $57,000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Purchases of inventory are all on credit and 50% is paid in the month of purchase and 50% in the month following purchase. Budgeted inventory purchases are $65,000 in July, $45,000 in August, and $21,000 in September. Other budgeted cash receipts: (a) sale of plant assets for $12,350 in August, and (b) sale of new common stock for $16,850 in September. Other budgeted cash disbursements: (a) operating expenses of $6,750 each month, (b) selling and administrative expenses of $12,500 each month, (c) dividends of $19,000 will be paid in August, and (d) purchase of equipment for $6,000 cash in September. The company has a cash...
Words: 563 - Pages: 3
...Introduction A budget is an estimation of the revenues and expenses at a given time. It is the amount allocated to certain asset or expense as an exchange for that asset or to the usage that led to that expense. According to an article from entrepreneurship.org, the business planning starts with budgets. Budgeting is not an afterthought. Your budget is a reflection of the goals and strategies you have for each area of business. A one-year budget planning document for the firm that is composed of all other budgets is called a master budget. Usually it is composed of two parts, the operating budget and the financial budget. Under the financial budget is what we call a cash budget. Cash Budget is the inflows and outflows of cash in a firm. It develops a summary of its operating, investing and financing activities. These activities will help us determine and observe how a firm creates their cash budget. This research aims to evaluate the cash budgeting process of JTU Marketing Auto Supply and to develop a recommendation, if necessary, for them to improve the said process. Most, if not all, small organizations do not have plans or budgets but still manages to survive and gain profit. This research could help organizations to realize and see that budgets would help them find out some problems in their organization. Also, the research could be used as a basis for an improved study regarding cash budgeting processes in different industries and larger firms since there are few studies than regarding...
Words: 11881 - Pages: 48
...CASE STUDY 3—Cash Budget Template | | | | | | | | | | | | | | | | | | SCHEDULE OF EXPECTED CASH COLLECTIONS FROM CUSTOMERS May | June | 65,800 | | 26,850 | 62,650 | | 22,500 | 92,650 | 85,150 | | | | | | | May | June | 117,000 | | 54,000 | 81,000 | | 25,200 | 171,000 | 106,200 | | | | | | | | | | | May | June | $20,000 | $20,000 | | | 92,650 | 85,150 | 33,000 | | | 50,000 | 75,000 | 57,000 | 200,650 | 192,150 | 220,650 | 212,150 | | | 171,000 | 106,200 | 15,000 | 15,000 | 10,150 | 10,150 | 35,000 | | | 20,000 | 231,150 | 151,350 | (10,500) | 60,800 | | | | | 30,500 | | | (31,008) | $20,000 | 29,792 | | | To see all the figures look above | | | Credit Sales | | | May | June | (94000 x70%) | | 65,800 | | May(89500 x 30%), Jun (89500 x 70%) | | 26,850 | 62,650 | (75000 x 30%) | | | 22,500 | Total Cash Collections | | 92,650 | 85,150 | | | | | | | | | | | SCHEDULE FOR EXPECTED PAYMENTS FOR PURCHASE OF INVENTORY | | | Inventory purchases | | May | June | April(195000 x60%) | | 117,000 | | (135000 x 40%), Jun (135000 x 60%) | | 54,000 | 81,000 | (63000...
Words: 555 - Pages: 3
...it. This plan is called the budgeting. Budgeting is a plan of an organization, or project that estimates probable income and expenditure of a specific period. We can also see the budgets of the Government that are released for a specific period. The following are the purposes of the budget 1. Budget helps in estimating future income , expenditure and hence the profiatability of the business. 2. It provides a sketch about the future position based on which the managers can make financial decisions. 3. Budgeting also helps the managers and decision makers to compare the budget with the actual performance. Nature of budgeting process adopted: 1. The idea is to estimate the financial environment on the basis of last budget. 2. Estimate the amount of cash that will be generated from sales revenue and other activities. 3. Forecasts the requirement of inputs like raw materials , labors, overheads and advertisements 4. To determine whether the budget is surplus or deficit, the estimated expenses is subtracted from the estimated revenues. 5. After consider reviews and revisions, the final budget is submitted. P3.2- What is the budgeting method used for the case study and reflect its needs. Comment with your advice and suggestions The budgeting method used in the case study is incremental budgeting. Incremental budgeting is the budgeting based on slight changes from the preceding periods budgeted results or actual results. The needs for budgeting...
Words: 942 - Pages: 4
...Case Study 8 Based on the January through June 2010 cash budget, what is the maximum monthly loss during the six-month planning period? What is the maximum cumulative borrowing balance? (For purposes of this question, disregard any interest payments on short-term bank loans or interest received from investing surplus funds.) Maximum monthly loss is in June: -$60,750. The maximum cumulative borrowing balance is $99,000 in February. What does the monthly cash budget reveal that indicates it should probably be extended beyond the original six months’ horizon? The major cash shortfall in June and the seasonality inherent in the firm’s business indicate that a full year’s cash budget should be developed. The monthly cash budget assumes that cash flows occur simultaneously. This is not realistic, of course. Assume, more realistically, that cash outflows occur early in the month and cash inflows occur later in the month. What do you think would happen to the current cash budget’s predictive powers? (NOTE: This question should be answered without preparing a spreadsheet; it is a ‘thought’ question.) The monthly cash budget would understate the need for funds, since outflows would occur before inflows. If you identified any issues in #3 above, what do you think would resolve them? HINT: There is a specific answer I am expecting, short and sweet, and it is in the case study narrative. Use a daily cash budget to predict cash flows. The need for cash could...
Words: 972 - Pages: 4
...ACCT 504 WEEK 6 CASE STUDY 3 – CASH BUDGETING – LBJ COMPANY A+ Graded Tutorial Available At: http://hwsoloutions.com/?product=week-6-case-study-3-cash-budgeting-lbj-company Visit Our website: http://hwsoloutions.com/ Product Description ACCT 504 Week 6 Case Study 3 – Cash Budgeting – LBJ Company, What are the three sections of a Cash Budget, and what is included in each section? 1. The cash receipts section includes expected receipts from the company’s principal source(s) of cash. It also shows anticipated receipts 0f intersest and dividends, and proceeds from planned sales of investments, plant assets, and the company’s capital stock. 2. The cash disbursements section shows expected payments for inventory, labor, overhead, and selling and administative expenses. This section also includes projected payments for income taxes, dividends, investments, and plant assets. 3. The financing section shows expected borrowings and the repayment of the borrowed funds plus interest. The financing entry when there is a deficiency or when the cash balance balance is less than management’s minum required balance. ACCT 504 Week 6 Case Study 3 – Cash Budgeting – LBJ Company, What are the three sections of a Cash Budget, and what is included in each section? 1. The cash receipts section includes expected receipts from the company’s principal source(s) of cash. It also shows anticipated receipts 0f intersest and dividends, and proceeds from planned sales of investments, plant...
Words: 306 - Pages: 2
...Part 2 of Case Study 3 in ACCT504 2. What are the three sections of a cash budget, and what is included in each section? The three major sections of a cash budget are cash receipts, cash disbursement, and financing. A cash receipt includes cash collections from customers; sales to customers, collecting on credit sales, interest made, etc. Cash disbursement is considered anything that is expected to be paid; administrative expenses, inventory purchases, taxes, etc. Financing is the part of the cash budget that is needed in case of a cash deficiency. If a cash budget falls short, the company can borrow money to make up for that amount. Repayment of the financing then also includes the interest that needs to be paid on that amount, (Weygandt, Kieso & Kimmel, 2002). 3. Why is a cash budget so vital to a company? A cash budget is a tool that can be used to manage a company’s cash. This budget will help a company stay focus by determining an appropriate budget, and help the company see if they can or cannot afford a new investment; or if and how much of financing may be needed. 4. What are the five basic principles of cash management that a company can follow in order to improve its chances of having adequate cash? The five principles are: Increase the speed of collection on receivables; which means that the company will be able to use those funds quicker. Next, inventory levels should be kept low, which also keeps the cost of storage lower and prevents from...
Words: 406 - Pages: 2
...virginiaswinery.com Owners: William and Wendy Vine Table of Content Mission Statement of Virginia Winery Ltd……………………………………………………………3 Financial plan ………………………………………………………………………………………….3 Task 1 - Develop financial strategies. 1.1-a Assumptions on which the financial plan has been developed……………………………….5 1.1-b Financial objectives in terms of finance requirements………………………………………..5 1.1-c Funding arrangements………………………………………………………………………...6 1.1-d Financial information requirements…………………………………………………………..9 1.1-e Financial performance targets and indicators………………………………………………..10 1.1-f Income statement projections………………………………………………………………...11 1.1-g Balance sheet projections…………………………………………………………………….12 1.2 Identify the appropriate staff and stakeholders within Virginia’s Wines that this plan should be communicated to, to enable effective implementation……………………………………………….13 Task 2 2.1-a Essential financial systems and records………………………………………………………14 2.1-b Legal and financial control systems…………………………………………………………..14 2.2-a A budget which is consistent with the financial strategies and plans…………………………17 2.2-b Revenue and expense projections for each forward period…………………………………...19 2.2-c Revenue and expense projections for each forward period…………………………………...19 2.2-d Balance sheet projection for the year………………………………………………………….20 Task 3 3.1. In monitoring the business operations explain what actions can be taken to ensure Virginia’s Wines achievement of their...
Words: 7482 - Pages: 30
...Case Three CHEF’S TOOLKIT INC. Cash Budgeting 企业现金需求分析和预算 1 Case Explanation: cash budgeting History: Jefferys, invention of Pasta server Production: data Marketing: data Financial Implication: data Data: Composition of Canadian Households; Balance sheet(July 15, 1994) Jefferys Personal balance sheet (July 15, 1994) Production Schedule in Unit 2 Study Questions Q1：What is the Case? (1)event?(2)Companies?(3)Persons?(4)Time? What is the problem?(5)Why is the problem?(6)Possible Solutions? Q2：Analyses (1) Background of Chef’s Toolkit Inc. ? (2) CV of managers? (3)What is the invention? (4)Company Size-up: production, marketing, and financial status? Q3：Budgeting(monthly sales : 10,000; 5,000; 30,000): production schedule, cash budget, Pro-forma income statement, Pro-forma balance sheet Q4：How can the firm avoid loss? Break –even calculation? Q5: How much money do the firm need for financing? Should Dale Raid invest? What are his risks? 3 Case Summary（案例） M r. P eter Jeffery President of Chef’s Toolkit Inc. M r. Dale Reid Private Investor 风险投资家 Obtain funds to start manufacturing and marketing a new pasta server. 4 Case Summary（案例） Produce Sell Chef’s Toolkit Inc. Pasta Server 意大利通心粉 Chef or Housewife 5 Objectives（目标） Produce projected income statements, balance sheets, and cash flow statement up to July 31, 1995. 预计财务报告 Obtain fund from Dale Reid. 6 Why Budget? 预算 If you know where you are going...
Words: 563 - Pages: 3
...Case Three CHEF’S TOOLKIT INC. Cash Budgeting 企业现金需求分析和预算 1 Case Explanation: cash budgeting History: Jefferys, invention of Pasta server Production: data Marketing: data Financial Implication: data Data: Composition of Canadian Households; Balance sheet(July 15, 1994) Jefferys Personal balance sheet (July 15, 1994) Production Schedule in Unit 2 Study Questions Q1：What is the Case? (1)event?(2)Companies?(3)Persons?(4)Time? What is the problem?(5)Why is the problem?(6)Possible Solutions? Q2：Analyses (1) Background of Chef’s Toolkit Inc. ? (2) CV of managers? (3)What is the invention? (4)Company Size-up: production, marketing, and financial status? Q3：Budgeting(monthly sales : 10,000; 5,000; 30,000): production schedule, cash budget, Pro-forma income statement, Pro-forma balance sheet Q4：How can the firm avoid loss? Break –even calculation? Q5: How much money do the firm need for financing? Should Dale Raid invest? What are his risks? 3 Case Summary（案例） M r. P eter Jeffery M r. Dale Reid Private Investor President of 风险投资家 Chef’s Toolkit Inc. Obtain funds to start manufacturing and marketing a new pasta server. 4 Case Summary（案例） Sell Produce Chef’s Toolkit Inc. Pasta Server Chef or Housewife 意大利通心粉 5 Objectives（目标） Produce projected income statements, balance sheets, and cash flow statement up to July 31, 1995. 预计财务报告 Obtain fund from Dale Reid. 6 Why Budget? 预算 If you know...
Words: 620 - Pages: 3
...ACCT 505 Entire Course For more classes visits www.snaptutorial.com ACCT 505 Week 1-7 All Discussion Questions ACCT 505 Week 1 Case Study ACCT 505 Week 2 Quiz Job Order and Process Costing Systems ACCT 505 Week 3 Case Study II ACCT 505 Week 4 Midterm Exam ACCT 505 Week 5 Measuring Performance - Course Project A ACCT 505 Week 6 Quiz Segment Reporting and Relevant Costs for Decisions ACCT 505 Week 7 Capital Budgeting Course Project ----------------------------------------------------------- ACCT 505 Final Exam For more classes visits www.snaptutorial.com ACCT 505 Final Exam ------------------------------ ACCT 505 Week 1 Case Study For more classes visits www.snaptutorial.com Top Switch Inc. designs and manufactures switches used in telecommunications. Serious flooding throughout the state of Tennessee affected Top Switch’s facilities. Inventory was completely ruined, and the company’s computer system, including all accounting records, was destroyed. Before the unfortunate incident, recovery specialists cleaned the buildings. The company controller is very nervous and anxious to recover whatever records he can to support the insurance claim for the destroyed inventory. After consulting with the cost accountant, they decide to retrieve the previous year’s annual report for the beginning inventory numbers. In addition, they also agreed that they need first quarter cost data. The cost accountant was working on the first quarter results...
Words: 1280 - Pages: 6
...AQA AS Business Studies Unit1 (BUSS1) Course Companion AQA AS Business Studies Unit 1 (BUSS1) Course Companion Publishers Information AQA AS Business Studies Unit 1 Course Companion 1st Edition August 2008 Author: Jim Riley © Tutor2u Limited All Rights Reserved No part of this material may be reproduced in whole or in part without the express written permission of Tutor2u Limited. This publication is not endorsed or approved by AQA. Tutor2u Limited Boston House 214 High Street Boston Spa LS23 6AD Please contact jimriley@tutor2u.net with details of any errors, omissions or suggestions for future editions. © Tutor2u Limited All Rights Reserved www.tutor2u.net AQA AS Business Studies Unit 1 (BUSS1) Course Companion Contents Introduction to AQA AS Business Unit 1 .....................................................................6 Section 1: Starting a Business ......................................................................................7 Enterprise and Entrepreneurs .......................................................................................8 Introduction ......................................................................................................................................... 8 Entrepreneurs ..................................................................................................................................... 9 Motives for starting a business ................................................................
Words: 41888 - Pages: 168
