Budgeting Case Study

In: Business and Management

Submitted By islbreeze
Words 462
Pages 2
Evaluating a Company’s Budget Procedures

Springfield Corporation operates on a calendar-year basis. It begins the annual budgeting process in late August, when the president establishes targets for the total dollar sales and the net income before taxes for the next year. The sales target is given to the Marketing Department, where the marketing manager formulates a sales budget by product line in both units and dollars. From this budget, sales quotas by product line in units and dollars are established for each of the corporation’s sales districts. The marketing manager also estimates the cost of the marketing activities required to support the target sales volume and prepares a tentative marketing expense budget. The executive vice president uses the sales and profit targets, the sales budget by product line, and the tentative marketing expense budget to determine the dollar amount that can be devoted to manufacturing and corporate expenses, and then forwards to the Production Department the product-line sales budget in units and the total dollar amount that can be devoted to manufacturing. The production manager meets with the factory managers to develop a manufacturing plan that will produce the required units when needed within the cost constraints set by the executive vice president. The budgeting process usually comes to a halt at this point because the Production Department does not consider the financial resources allocated to be adequate. When this standstill occurs, the vice president of finance, the executive vice president, the marketing manager, and the production manager meet to determine the final budgets for each of the areas. This normally results in a modest increase in the total amount available for manufacturing costs, while the marketing expense and corporate office expense budgets are cut. The total sales and net income…...

Similar Documents

Accounting 504 Case Study Budgeting

...ACCT504 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 LBJ Company has budgeted sales revenues as follows: April May June Credit sales $94,000 $89,500 $75,000 Cash sales 48,000 75,000 57,000 Total sales $142,000 $164,500 $132,000 Past experience indicates that 30% of the credit sales will be collected in the month of sale and the remaining 70% will be collected in the following month. Purchases of inventory are all on credit and 40% is paid in the month of purchase and 60% in the month following purchase. Budgeted inventory purchases are $195,000 in April, $135,000 in May, and $63,000 in June. Other budgeted cash receipts: (a) sale of plant assets for $33,000 in May, and (b) sale of new common stock for $50,000 in June. Other budgeted cash disbursements: (a) operating expenses of $15,000 each month, (b) selling and administrative expenses of $10,150 each month, (c) purchase of equipment for $35,000 cash in May, and (d) dividends of $20,000 will be paid in June. The company has a cash balance of $20,000 at......

Words: 563 - Pages: 3

Capital Budgeting Case Study

...Capital Budgeting Case Study Atilano Bonilla QRB/501 October 14, 2013 Vladimir Crk Capital Budgeting Case Study The authors of this paper will analyze and interpret the answers to the Capital Budgeting Case Study presented in Week 6’s material of the Quantitative Reasoning for Business course. The paper presents the rationale behind the Net Present Value (NPV) and Internal Rate of Return (IRR) results, describes the relationship between the two and explains the reasons behind the acquisition recommendation (e) in the Microsoft Excel spreadsheet. Analyzing the Results The case study presents two corporations (A and B) with different revenue values and expenses as well as variable depreciation expenses, tax rates and discount rates. Members of the team computed both corporations’ cash flow, NPV and IRR value using a Microsoft Excel spreadsheet. The net present value (NPV) of an investment proposal is equal to the present value of its annual free cash flows less the investment’s initial outlay. Whenever the project’s NPV is greater than or equal to zero, we will accept the project; whenever the NPV is negative, we will reject the project. (Keown, 2014. p. 310) On the other hand Keown (2014) points out that “the internal rate of return is defined as the discount rate that equates the present value of the project’s free cash flows with the project’s initial cash outlay.” In effect, the NPV method implicitly assumes that cash flows......

Words: 515 - Pages: 3

Acct 504 Case Study 3 Cash Budgeting

...ACCT504 Sample Case Study 3 on Cash Budgeting Solution It is recommended that you share this solution file in Doc Sharing by the end of Week 5 with your students. The Cambridge Company has budgeted sales revenues as follows. Jan Feb Mar Credit sales $45,000 $36,000 $27,000 Cash sales 27,000 76,500 58,500 Total sales $72,000 $112,500 $85,500 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 40% is paid in the month of purchase and 60% in the month following purchase. Budgeted inventory purchases are $97,500 in January, $67,500 in February, and $31,500 in March. Other budgeted cash receipts: (a) sale of plant assets for $18,525 in February, and (b) sale of new common stock for $25,275 in March. Other budgeted cash disbursements: (a) operating expenses of $10,125 each month, (b) selling and administrative expenses of $18,750 each month, (c) dividends of $28,500 will be paid in February, and (d) purchase of equipment for $9,000 cash in March. The company has a cash balance of $15,000 at the beginning of February and wishes to maintain a minimum cash balance of $15,000 at the end of each month. An open line of credit is available at the bank and carries an annual interest rate of 12%. Assume that all borrowing is done on the first day of the month in which......

Words: 557 - Pages: 3

Capital Budgeting Case

...Capital Budgeting Case Shawn P. Oeser QRB/501 October 7, 2013 David Gobeli Capital Budgeting Case For the final week of QRB/501 we were asked to complete a Capital Budgeting Case based on two possible corporations for our company. Based on the 5 year projected income statement, 5 year projected cash flow, Net Present Value (NPV), and Internal Rate of Return (IRR); we were to determine which company would be the wiser acquisition. After completing the analysis it was determined that Corporation B would be the proper choice of the two corporations. According to our text the NPV, “of an investment proposal is equal to the present value of its annual free cash flows less the investment’s initial outlay” (Keown, Martin, & Petty, 2014, p. 310), therefore determining the NPV value of each company is a step needed in determining the whether either company was worth the initial investment. The next step was determining the companies IRR, which is defined in our text as, “the internal rate of return is defined as the discount rate that equates the present value of the project’s free cash flows with the project’s initial cash outlay” (Keown, Martin, & Petty, 2014, p. 310). Yet these were not the only determining factors, we also were required to look at the projected 5-year cash flow and the projected 5-year income statement. When comparing the NPV of both corporations it was clear that the NPV of Corporation B was almost double that of Corporation A at $36,262.58......

Words: 664 - Pages: 3

Acct 504 Case Study 3 Cash Budgeting

...ACCT504 Practice Case Study 3 on Cash Budgeting This is a practice case study to help you become familiar with how to create a comprehensive cash budget. The cash budget relates to TCO D and is discussed in Chapter 7. Your professor will provide the solution by the end of Week 5 in Doc Sharing. The actual case study assignment should be uploaded by 11:59 p.m. mountain time on Sunday at the end of Week 6 to the Week 6 Assignment Dropbox. You are encouraged to use the Excel template file provided in Doc Sharing. The Cambridge Company has budgeted sales revenues as follows. Jan Feb Mar Credit sales $45,000 $36,000 $27,000 Cash sales 27,000 76,500 58,500 Total sales $72,000 $112,500 $85,500 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 40% is paid in the month of purchase and 60% in the month following purchase. Budgeted inventory purchases are $97,500 in January, $67,500 in February, and $31,500 in March. Other budgeted cash receipts: (a) sale of plant assets for $18,525 in February, and (b) sale of new common stock for $25,275 in March. Other budgeted cash disbursements: (a) operating expenses of $10,125 each month, (b) selling and administrative expenses of $18,750 each month, (c) dividends of $28,500 will be paid in February, and (d) purchase of......

Words: 434 - Pages: 2

Budgeting Case

...A Case Method Approach of Teaching how Cost-Volume-Profit Analysis is connected to the Flexible Budgeting Process and Variance Analysis To start a successful business, students need to understand the steps necessary to achieve their desired profits. While Managerial textbooks teach each step independently, we demonstrate how these steps are integrated. We present a Multi-Disciplinary Case-Method approach to teaching Cost-Volume-Profit (CVP) Analysis. Finally, students prepare a Flexible Budget demonstrating the importance of distinguishing between activity and revenue/spending variances. INTRODUCTION “We first present an alternative, more comprehensive teaching approach, for Cost-Volume-Profit (CVP) analysis from the commonly used approach which simply teaches students how to use a series of equations to solve various questions related to CVP analysis, in which unit selling price, total fixed costs, and unit variable costs are assumed to remain constant (Garrison et al., 2010; Choo and Tan, 2010). We use a multi-disciplinary approach in the context of a realistic case-analysis. We believe this approach offers useful insights and provides a useful learning tool for students pursuing an advanced Master’s Degree.” (Machuga, 2012). This case requires students to: (a) make assumptions about cost behavior in a dynamic and interactive way, and (b) research a variety of marketing issues for the proposed business that simulates a real life business situation, and (c) use......

Words: 4672 - Pages: 19

Budgeting Case Study

...Evaluating a Company’s Budget Procedures Springfield Corporation operates on a calendar-year basis. It begins the annual budgeting process in late August, when the president establishes targets for the total dollar sales and the net income before taxes for the next year. The sales target is given to the Marketing Department, where the marketing manager formulates a sales budget by product line in both units and dollars. From this budget, sales quotas by product line in units and dollars are established for each of the corporation’s sales districts. The marketing manager also estimates the cost of the marketing activities required to support the target sales volume and prepares a tentative marketing expense budget. The executive vice president uses the sales and profit targets, the sales budget by product line, and the tentative marketing expense budget to determine the dollar amount that can be devoted to manufacturing and corporate expenses, and then forwards to the Production Department the product-line sales budget in units and the total dollar amount that can be devoted to manufacturing. The production manager meets with the factory managers to develop a manufacturing plan that will produce the required units when needed within the cost constraints set by the executive vice president. The budgeting process usually comes to a halt at this point because the Production Department does not consider the financial resources allocated to be adequate. When this......

Words: 462 - Pages: 2

Acct504 Week 6 Case Study 3 Cash Budgeting Lbj Company

...ACCT504 Week 6 Case Study 3 Cash Budgeting LBJ Company Click Link Below To Buy: http://hwcampus.com/shop/acct-504/acct-504-week-6-case-study-3-cash-budgeting-lbj-company/ Or Visit www.hwcampus.com ACCT504 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 LBJ Company has budgeted sales revenues as follows: April May June Credit sales $94,000 $89,500 $75,000 Cash sales 48,000 75,000 57,000 Total sales $142,000 $164,500 $132,000 Past experience indicates that 30% of the credit sales will be collected in the month of sale and the remaining 70% will be collected in the following month. Purchases of inventory are all on credit and 40% is paid in the month of purchase and 60% in the month following purchase. Budgeted inventory purchases are $195,000 in April, $135,000 in May, and $63,000 in June. Other budgeted cash receipts: (a) sale of plant assets for $33,000 in May, and (b) sale of new common stock for $50,000 in June. Other budgeted cash disbursements: (a) operating expenses of $15,000 each month, (b) selling and administrative expenses of $10,150 each...

Words: 474 - Pages: 2

Acct504 Week 6 Case Study 3 Cash Budgeting Lbj Company

...ACCT504 Week 6 Case Study 3 Cash Budgeting LBJ Company Click Link Below To Buy: http://hwcampus.com/shop/acct-504/acct-504-week-6-case-study-3-cash-budgeting-lbj-company/ Or Visit www.hwcampus.com ACCT504 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 LBJ Company has budgeted sales revenues as follows: April May June Credit sales $94,000 $89,500 $75,000 Cash sales 48,000 75,000 57,000 Total sales $142,000 $164,500 $132,000 Past experience indicates that 30% of the credit sales will be collected in the month of sale and the remaining 70% will be collected in the following month. Purchases of inventory are all on credit and 40% is paid in the month of purchase and 60% in the month following purchase. Budgeted inventory purchases are $195,000 in April, $135,000 in May, and $63,000 in June. Other budgeted cash receipts: (a) sale of plant assets for $33,000 in May, and (b) sale of new common stock for $50,000 in June. Other budgeted cash disbursements: (a) operating expenses of $15,000 each month, (b) selling and administrative expenses of $10,150 each...

Words: 474 - Pages: 2

Acct504 Week 6 Case Study 3 Cash Budgeting Lbj Company

...ACCT504 Week 6 Case Study 3 Cash Budgeting LBJ Company Click Link Below To Buy: http://hwcampus.com/shop/acct-504/acct-504-week-6-case-study-3-cash-budgeting-lbj-company/ Or Visit www.hwcampus.com ACCT504 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 LBJ Company has budgeted sales revenues as follows: April May June Credit sales $94,000 $89,500 $75,000 Cash sales 48,000 75,000 57,000 Total sales $142,000 $164,500 $132,000 Past experience indicates that 30% of the credit sales will be collected in the month of sale and the remaining 70% will be collected in the following month. Purchases of inventory are all on credit and 40% is paid in the month of purchase and 60% in the month following purchase. Budgeted inventory purchases are $195,000 in April, $135,000 in May, and $63,000 in June. Other budgeted cash receipts: (a) sale of plant assets for $33,000 in May, and (b) sale of new common stock for $50,000 in June. Other budgeted cash disbursements: (a) operating expenses of $15,000 each month, (b) selling and administrative expenses of $10,150 each...

Words: 474 - Pages: 2

Acct504 Week 6 Case Study 3 Cash Budgeting Lbj Company

...ACCT504 Week 6 Case Study 3 Cash Budgeting LBJ Company Click Link Below To Buy: http://hwcampus.com/shop/acct-504/acct-504-week-6-case-study-3-cash-budgeting-lbj-company/ Or Visit www.hwcampus.com ACCT504 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 LBJ Company has budgeted sales revenues as follows: April May June Credit sales $94,000 $89,500 $75,000 Cash sales 48,000 75,000 57,000 Total sales $142,000 $164,500 $132,000 Past experience indicates that 30% of the credit sales will be collected in the month of sale and the remaining 70% will be collected in the following month. Purchases of inventory are all on credit and 40% is paid in the month of purchase and 60% in the month following purchase. Budgeted inventory purchases are $195,000 in April, $135,000 in May, and $63,000 in June. Other budgeted cash receipts: (a) sale of plant assets for $33,000 in May, and (b) sale of new common stock for $50,000 in June. Other budgeted cash disbursements: (a) operating expenses of $15,000 each month, (b) selling and administrative expenses of $10,150 each...

Words: 474 - Pages: 2

Capital Budgeting Case Study

...Team B Capital Budgeting Case Study Karissa Hall, M. Paul Mitchell & Augustine Flores QRB 501 November 9, 2015 Dorrell Crittenden Team B Capital Budgeting Case Study INTRODUCTION A Capital budget is defined as, the process of decision making with respect to investments made in fixed assets—that is, allowing for one to determine what course of action to take especially as concern whether a proposed project should be accepted or rejected or whether an investment should be made (Keown, Martin, & Petty, 2014). Team B’s goal this week was to define, analyze, and interpret a Capital Budgeting Case, that included, (a) a five-year projected income statement, (b) a five-year projected cash flow, (c) Net present value (NPV), and (d) Internal rate of return (IRR). The team has attached a spreadsheet detailing the analysis done for each corporation as well as offering a recommendations of which of the two corporation should be acquired. RATIONALE BEHIND NET PRESENT VALUE (NPV): Net present value ************* ****************** ***************** ******* *************** ************** ************* *********** ************** ******** ********** ************ ************ ************ ************* ********** ****** ********* *************** ************** ************* ******* ******* ********** ************** ****** ********** ************ ************ ****** ******* ******* ************* ********** ************* ************* ********** ******** ******** *******......

Words: 250 - Pages: 1

Acct504 Week 6 Case Study 3 Cash Budgeting Lbj Company

...ACCT504 Week 6 Case Study 3 Cash Budgeting LBJ Company Click Link Below To Buy: http://hwcampus.com/shop/acct-504/acct-504-week-6-case-study-3-cash-budgeting-lbj-company/ Or Visit www.hwcampus.com ACCT504 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 LBJ Company has budgeted sales revenues as follows: April May June Credit sales $94,000 $89,500 $75,000 Cash sales 48,000 75,000 57,000 Total sales $142,000 $164,500 $132,000 Past experience indicates that 30% of the credit sales will be collected in the month of sale and the remaining 70% will be collected in the following month. Purchases of inventory are all on credit and 40% is paid in the month of purchase and 60% in the month following purchase. Budgeted inventory purchases are $195,000 in April, $135,000 in May, and $63,000 in June. Other budgeted cash receipts: (a) sale of plant assets for $33,000 in May, and (b) sale of new common stock for $50,000 in June. Other budgeted cash disbursements: (a) operating expenses of $15,000 each month, (b) selling and administrative expenses of $10,150 each...

Words: 474 - Pages: 2

Budgeting and Strateg-Kraft Food Case

...Budgeting and strategy A Kraft Foods UK case study Case study pages • 1: What is a budget? • 2: Kraft´s income and expenses budget • 3: The importance of feedback • 4: Constructing an expense budget • 5: Advantages and disadvantages of expense budgeting • 6: Alternative types of budgeting • 7: Conclusion Read more: http://businesscasestudies.co.uk/kraft-foods-uk/budgeting-and-strategy/conclusion.html#ixzz1nUCFRFJb What is a budget? A budget is a financial plan that sets out, using figures, an organisation's expected future results. For planning purposes, organisations can use many different types of budgets. For example: • Income and expenditure budgets. These show how much an organisation expects to receive and to spend in future periods. • Production budgets. These set out how much an organisation must produce in coming periods of time in order to meet demand. • Profit budgets. These bring together planned sales, costs, and profit figures. By creating budgets, managers can: • set out a clear plan, involving target figures for defined periods of time • communicate their targets clearly • motivate employees to achieve these targets • control performance by monitoring actual outcomes against planned targets • meet the organisation's objectives. This case study illustrates how Kraft Foods uses budgets to enable it to meet business objectives related to financial performance with a view to......

Words: 1762 - Pages: 8

Capital Budgeting Case Question

...Chapter 11 The Basics of Capital Budgeting Integrated Case 11-24 Allied Components Company Basics of Capital Budgeting You recently went to work for Allied Components Company, a supplier of auto repair parts used in the after-market with products from Daimler, Chrysler, Ford, and other automakers. Your boss, the chief financial officer (CFO), has just handed you the estimated cash flows for two proposed projects. Project L involves adding a new item to the firm’s ignition system line; it would take some time to build up the market for this product, so the cash inflows would increase over time. Project S involves an add-on to an existing line, and its cash flows would decrease over time. Both projects have 3-year lives, because Allied is planning to introduce entirely new models after 3 years. Here are the projects’ net cash flows (in thousands of dollars): 0 1 2 3 | | | | Project L -100 10 60 80 Project S -100 70 50 20 Depreciation, salvage values, net working capital requirements, and tax effects are all included in these cash flows. The CFO also made subjective risk assessments of each project, and he concluded that both projects have risk characteristics that are similar to the firm’s average project. Allied’s WACC is 10%. You must determine whether one or both of the projects should be accepted. A. What is capital budgeting? Are there any similarities between a firm’s capital budgeting decisions and an individual’s investment decisions? ...

Words: 3327 - Pages: 14

Regalia – The Three Sacred Stars | Animowane | Coconut Fred's Fruit Salad Island