Master Budget

In: Business and Management

Submitted By lucea2
Words 343
Pages 2
Background
The production department has been investigating possible ways to trim total production costs. One possibility currently being examined is to make the paint cans instead of purchasing them. The equipment needed would cost $200,000, with a disposal value of $40,000, and it would be able to produce 5,500,000 cans over the life of the machinery. The production department estimates that approximately 1,100,000 cans would be needed for each of the next five years. The company would hire three new employees. These three individuals would be full-time employees working 2,000 hours per year and earning $12.00 per hour. They would also receive the same benefits as other production employees, 18% of wages, in addition to $2,500 of health benefits. It is estimated that the raw materials will cost 25¢ per can and that other variable costs would be 5¢ per can. Since there is currently unused space in the factory, no additional fixed costs would be incurred if this proposal is accepted. It is expected that cans would cost 45¢ each if purchased from the current supplier. The company's minimum rate of return (hurdle rate) has been determined to be 12% for all new projects, and the current tax rate of 35% is anticipated to remain unchanged. The pricing for a gallon of paint, as well as the number of units sold, will not be affected by this decision. The unit-of-production depreciation method would be used if the new equipment is purchased.

Net Present Value and IRR Determination and Conclusion
Under the net present value method, the present value of a project's cash inflows is compared to the present value of the project's cash outflows. The difference between the present values of these cash flows is called "the net present value". This net present value determines whether or not the project is an acceptable investment. According to this analysis, Clark Paints should…...

Similar Documents

Master Budget

...Questions Sales and Production Budgets (8-12): The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 11,000 12,000 14,000 13,000 The selling price of the company's product is $18.00 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be "'uncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in the first quarter, is $70,200. The company expects to start the first quarter with 1,650 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 15% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,850 units. • Prepare the company's sales budget and schedule of expected cash collections. • Prepare the company's production budget for the upcoming fiscal year. Sales Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL Units 11,000 12,000 14,000 13,000 50,000 Selling Price x $18 x $18 x $18 x $18 Total Sales $198,000 $216,000 $252,000 $234,000 $900,000 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL Accounts Receivable $70,200 $70,200 1st Quarter Sales (198kx65%)$128,700 (198 x 30% )$59,400 $188,100 2nd Quarter......

Words: 1226 - Pages: 5

Strategy and the Master Budget

...Chapter 10 Strategy and the Master Budget Cases 10-1 Emerson Electric Company © Joseph San Miguel, reprinted with permission. 10-2 LetsGo Travel Trailers (Source: “LetsGo Travel Trailers: A Case for Incorporating the New Model of the Organization into the Teaching of Budgeting,” by Sally Wright, Cases from Management Accounting Practice, Vol. 14, Montvale, NJ: Institute of Management Accountants, 1998). Note that part 2 of this case requires the use of Excel. 10-3 Building Processes for a Solid Foundation: The Case of Community Health Initiatives (Source: Sandra Richtermeyer, Strategic Finance, August 2007, pp. 52-57. Note: this case was the case used as the 2008 IMA Student Case Competition. The Student Case Competition is sponsored annually by the IMA to provide an opportunity for students to interpret, analyze, evaluate, synthesize, and communicate a solution to a management accounting problem.) 10-4 Academic Advising at Bay State (Source: Janice E. Bell and Shahid L. Ansari, Strategic Finance, September 2008, pp. 44-51. Note: this case was the case used as the 2009 IMA Student Case Competition. The Student Case Competition is sponsored annually by the IMA to provide an opportunity for students to interpret, analyze, evaluate, synthesize, and communicate a solution to a management accounting problem.) Readings 10-1: “How to Set Up a Budgeting and Planning System” by Robert N. West and Amy M. Snyder, Management Accounting (January 1997)...

Words: 28910 - Pages: 116

Master & Flexible Budget

...Master and Flexible Budgets ACC/543 January 28, 2013 Thomas Benscoter MEMORANDOM Date: January 28, 2012 To. Guillermo Furniture Company From: Ashley Lee, Ebony De La Torre, Janelle Durham, Misha Cross ------------------------------------------------- Re: Master and Flexible Budgets Guillermo Furniture: Master and Flexible Budgets A master budget can be a communication tool in which the company’s employees can perceive how their hard work affects the company’s goals. The budget is an outline of a company's plans that sets detailed goals for an organization regarding sales, production, distribution, and financing. This tool can also reveal if employees are meeting their goals set forth by the company in the budget and make corrections to employees. The following memorandum on Guillermo Furniture Store includes a master budget. The explanation of the relationship between fixed and variable cost used in the budget will occur. The difference between static and flexible budgets and how a flexible budget lends itself to a cost-volume profit analysis will be discussed. Fixed and Variable Costs Fixed costs in a budget remain constant even when volumes fluctuate. Fixed......

Words: 877 - Pages: 4

Master Budget Exercise

...Master Budget Exercises Violet A. May Bus. 630-Managerial Accounting [ February 4, 2013 ] Isabel Wan Jessi Corporation Sales Budget Quarter 1 2 3 4 Year Budgeted sales per unit 11,000 12,000 14,000 13,000 50,000 Selling price per unit $ 18.00 $ 18.00 $ 18.00 $ 18.00 $ 18.00 Total sales $198,000 $216,000 $252,000 $234,000 $900,000 Percentage of sales collected in the period of the sale 65% Percentage of sales collected in the period after the sale 30% Schedule of Expected Cash Collections Accounts receivable beginning balance $ 70,200 $ 70,200 First quarter sales $128,700 $59,400 188,000 Second quarter sales 140,400 $64,800 205,200 Third quarter sales $163,800 $75,600 239,400 Fourth quarter sales 152,100 152,100 Total cash collections $198,900 $199,800 $228,600 227,700 $855,000 | ...

Words: 250 - Pages: 1

Master Budget

...A budget is a financial plan of the resources needed to carry out tasks and meet financial goals. A master budget is part of an overall organization plan for the next year, made up of three components: (1) organizational goals, (2) the strategic long-range profit plan, and (3) the master budget (tactical short-range profit plan). Long-range plans are achieved in year-by-year steps. The guidance is more specific for the coming year than it is for more distant years. The plan for the coming year is called the master budget. The master budget is also known as the static budget, the budget plan, or the planning budget. The income statement portion of the master budget is often called the profit plan. The master budget indicates the sales levels, production and cost levels, income, and cash flows anticipated for the coming year. In addition, these budget data are used to construct a budgeted statement of financial position (balance sheet). Budgeting is a dynamic process that ties together goals, plans, decision making, and employee performance evaluation. The master budget and its relationship to other plans, accounting reports, and management decision-making processes are diagrammed in this diagram: Although each organization is unique in the way it puts together its budget, all budgeting processes share some common elements. After organizational goals, strategies, and long-range plans have been developed, work begins on the master budge, a detailed budget for the coming......

Words: 334 - Pages: 2

Acct 434 Week 2 Master Budget Flexible Budgets

...ACCT 434 Week 2 Master Budget Flexible Budgets Purchase here http://devrycourse.com/acct-434-week-2-master-budget-flexible-budgets Product Description 1. Question : (TCO 2) Operating budgets and financial budgets 2. Question : (TCO 2) To gain the benefits of budgeting, ________ must understand and support the budget. 3. Question : (TCO 2) Which budget is not necessary to prepare the budgeted balance sheet? 4. Question : (TCO 2) A feature of a standard-costing system is that the costs of every product or service planned to be worked on during the period can be computed at the start of that period. This feature of standard costing makes it possible to 5. Question : (TCO 2) An unfavorable variance indicates that 6. Question : (TCO 2) Which of the following statements is true about overhead cost variance analysis using activity-based costing? 7. Question : (TCO 2) Overhead costs have been increasing due to all of the following except 8. Question : (TCO 2) Katie Enterprises reports the year-end information from 20X8 as follows: Sales (70,000 units) $560,000; Cost of goods sold 210,000; Gross margin 350,000; Operating expenses 200,000; Operating income $150,000. Katie is developing the 20X9 budget. In 20X9, the company would like to increase selling prices by 4%, and as a result expects a decrease in sales volume of 10%. All other operating expenses are expected to remain constant. Assume that COGS is a variable cost and that operating expenses......

Words: 493 - Pages: 2

Acct 434 Week 2 Master Budget Flexible Budgets

...ACCT 434 Week 2 Master Budget Flexible Budgets Purchase here http://devrycourse.com/acct-434-week-2-master-budget-flexible-budgets Product Description 1. Question : (TCO 2) Operating budgets and financial budgets 2. Question : (TCO 2) To gain the benefits of budgeting, ________ must understand and support the budget. 3. Question : (TCO 2) Which budget is not necessary to prepare the budgeted balance sheet? 4. Question : (TCO 2) A feature of a standard-costing system is that the costs of every product or service planned to be worked on during the period can be computed at the start of that period. This feature of standard costing makes it possible to 5. Question : (TCO 2) An unfavorable variance indicates that 6. Question : (TCO 2) Which of the following statements is true about overhead cost variance analysis using activity-based costing? 7. Question : (TCO 2) Overhead costs have been increasing due to all of the following except 8. Question : (TCO 2) Katie Enterprises reports the year-end information from 20X8 as follows: Sales (70,000 units) $560,000; Cost of goods sold 210,000; Gross margin 350,000; Operating expenses 200,000; Operating income $150,000. Katie is developing the 20X9 budget. In 20X9, the company would like to increase selling prices by 4%, and as a result expects a decrease in sales volume of 10%. All other operating expenses are expected to remain constant. Assume that COGS is a variable cost and that operating expenses......

Words: 493 - Pages: 2

Acct 434 Week 2 Master Budget Flexible Budgets

...ACCT 434 Week 2 Master Budget Flexible Budgets Purchase here http://devrycourse.com/acct-434-week-2-master-budget-flexible-budgets Product Description 1. Question : (TCO 2) Operating budgets and financial budgets 2. Question : (TCO 2) To gain the benefits of budgeting, ________ must understand and support the budget. 3. Question : (TCO 2) Which budget is not necessary to prepare the budgeted balance sheet? 4. Question : (TCO 2) A feature of a standard-costing system is that the costs of every product or service planned to be worked on during the period can be computed at the start of that period. This feature of standard costing makes it possible to 5. Question : (TCO 2) An unfavorable variance indicates that 6. Question : (TCO 2) Which of the following statements is true about overhead cost variance analysis using activity-based costing? 7. Question : (TCO 2) Overhead costs have been increasing due to all of the following except 8. Question : (TCO 2) Katie Enterprises reports the year-end information from 20X8 as follows: Sales (70,000 units) $560,000; Cost of goods sold 210,000; Gross margin 350,000; Operating expenses 200,000; Operating income $150,000. Katie is developing the 20X9 budget. In 20X9, the company would like to increase selling prices by 4%, and as a result expects a decrease in sales volume of 10%. All other operating expenses are expected to remain constant. Assume that COGS is a variable cost and that operating expenses......

Words: 493 - Pages: 2

Acct 434 Week 2 Master Budget Flexible Budgets

...ACCT 434 Week 2 Master Budget Flexible Budgets Purchase here http://chosecourses.com/ACCT%20434/acct-434-week-2-master-budget-flexible-budgets Product Description 1. Question : (TCO 2) Operating budgets and financial budgets 2. Question : (TCO 2) To gain the benefits of budgeting, ________ must understand and support the budget. 3. Question : (TCO 2) Which budget is not necessary to prepare the budgeted balance sheet? 4. Question : (TCO 2) A feature of a standard-costing system is that the costs of every product or service planned to be worked on during the period can be computed at the start of that period. This feature of standard costing makes it possible to 5. Question : (TCO 2) An unfavorable variance indicates that 6. Question : (TCO 2) Which of the following statements is true about overhead cost variance analysis using activity-based costing? 7. Question : (TCO 2) Overhead costs have been increasing due to all of the following except 8. Question : (TCO 2) Katie Enterprises reports the year-end information from 20X8 as follows: Sales (70,000 units) $560,000; Cost of goods sold 210,000; Gross margin 350,000; Operating expenses 200,000; Operating income $150,000. Katie is developing the 20X9 budget. In 20X9, the company would like to increase selling prices by 4%, and as a result expects a decrease in sales volume of 10%. All other operating expenses are expected to remain constant. Assume that COGS is a variable cost and that......

Words: 2475 - Pages: 10

Master Budget of a Small Street Shop

...very experienced and eloquent when it comes to selling his products. There is another reason for choosing the shop. It is the ease of doing the master budget on a shop which primarily sells shirts. His shop does not have many of the expenses a typical manufacturing shop would have. All of his products are bought from whole sellers so there is only an inventory that we must consider while making the master budget. Background of the shop: Mr hasan has been doing business for many years in different places. He used to be a rickshaw puller but when he became old and it became very difficult to pull rickshaw he decided to establish his own shop. Now his son helps him in his business. He cannot employ any sales person due to his limited profit margin. It becomes very difficult for him to run his family with such a trifling amount of money. He primarily sells shirts. That the product we will be focusing on to in our master budget. The location of his dokan is in khilkhet bazar. Its below the over bridge where it remains very crowdie at pick ours. Sales budget: The price per unit of shirt is tk 350. And hasan basraalai does not sell in credit so all the money is collected in their own quarter. hasan basraalai Sales Budget For the year ended December 31,2016 | | | Quarter | | | | | 1 | 2 | 3 | 4 | Year | Budgeted......

Words: 818 - Pages: 4

Acct 434 Week 2 Master Budget Flexible Budgets

...ACCT 434 Week 2 Master Budget Flexible Budgets Purchase here http://devrycourse.com/acct-434-week-2-master-budget-flexible-budgets Product Description 1. Question : (TCO 2) Operating budgets and financial budgets 2. Question : (TCO 2) To gain the benefits of budgeting, ________ must understand and support the budget. 3. Question : (TCO 2) Which budget is not necessary to prepare the budgeted balance sheet? 4. Question : (TCO 2) A feature of a standard-costing system is that the costs of every product or service planned to be worked on during the period can be computed at the start of that period. This feature of standard costing makes it possible to 5. Question : (TCO 2) An unfavorable variance indicates that 6. Question : (TCO 2) Which of the following statements is true about overhead cost variance analysis using activity-based costing? 7. Question : (TCO 2) Overhead costs have been increasing due to all of the following except 8. Question : (TCO 2) Katie Enterprises reports the year-end information from 20X8 as follows: Sales (70,000 units) $560,000; Cost of goods sold 210,000; Gross margin 350,000; Operating expenses 200,000; Operating income $150,000. Katie is developing the 20X9 budget. In 20X9, the company would like to increase selling prices by 4%, and as a result expects a decrease in sales volume of 10%. All other operating expenses are expected to remain constant. Assume that COGS is a variable cost and that operating expenses......

Words: 493 - Pages: 2

Acct 434 Week 2 Master Budget Flexible Budgets

...ACCT 434 WEEK 2 MASTER BUDGET FLEXIBLE BUDGETS To purchase this visit following link: http://www.activitymode.com/product/acct-434-week-2-master-budget-flexible-budgets/ Contact us at: SUPPORT@ACTIVITYMODE.COM ACCT 434 WEEK 2 MASTER BUDGET FLEXIBLE BUDGETS ACCT 434 Week 2 Master Budget Flexible Budgets 1. Question : (TCO 2) Operating budgets and financial budgets 2. Question : (TCO 2) To gain the benefits of budgeting, ________ must understand and support the budget. 3. Question : (TCO 2) Which budget is not necessary to prepare the budgeted balance sheet? 4. Question : (TCO 2) A feature of a standard-costing system is that the costs of every product or service planned to be worked on during the period can be computed at the start of that period. This feature of standard costing makes it possible to 5. Question : (TCO 2) An unfavorable variance indicates that 6. Question : (TCO 2) Which of the following statements is true about overhead cost variance analysis using activity-based costing? 7. ACCT 434 WEEK 2 MASTER BUDGET FLEXIBLE BUDGETS To purchase this visit following link: http://www.activitymode.com/product/acct-434-week-2-master-budget-flexible-budgets/ Contact us at: SUPPORT@ACTIVITYMODE.COM ACCT 434 WEEK 2 MASTER BUDGET FLEXIBLE BUDGETS ACCT 434 Week 2 Master Budget Flexible Budgets 1. Question : (TCO 2) Operating budgets and financial budgets 2. Question : (TCO 2) To gain the benefits of budgeting, ________ must understand and...

Words: 499 - Pages: 2

Acct 434 Week 2 Master Budget Flexible Budgets

...ACCT 434 Week 2 Master Budget Flexible Budgets To Buy This material Click below link http://www.uoptutors.com/acct-434-devry/acct-434-week-2-master-budget-flexible-budgets 1.Question :(TCO 2) Operating budgets and financial budgets 2.Question :(TCO 2) To gain the benefits of budgeting, ________ must understand and support the budget. 3.Question : (TCO 2) Which budget is not necessary to prepare the budgeted balance sheet? 4.Question :(TCO 2) A feature of a standard-costing system is that the costs of every product or service planned to be worked on during the period can be computed at the start of that period. This feature of standard costing makes it possible to 5.Question :(TCO 2) An unfavorable variance indicates that 6.Question :(TCO 2) Which of the following statements is true about overhead cost variance analysis using activity-based costing? 7.Question :(TCO 2) Overhead costs have been increasing due to all of the following except 8.Question :(TCO 2) Katie Enterprises reports the year-end information from 20X8 as follows: Sales (70,000 units) $560,000; Cost of goods sold 210,000; Gross margin 350,000; Operating expenses 200,000; Operating income $150,000. Katie is developing the 20X9 budget. In 20X9, the company would like to increase selling prices by 4%, and as a result expects a decrease in sales volume of 10%. All other operating expenses are expected to remain constant. Assume that COGS is a variable cost and that operating expenses are a fixed......

Words: 508 - Pages: 3

Acct 434 Week 2 Master Budget Flexible Budgets

...ACCT 434 Week 2 Master Budget Flexible Budgets To Buy This material Click below link http://www.uoptutors.com/acct-434-devry/acct-434-week-2-master-budget-flexible-budgets 1.Question :(TCO 2) Operating budgets and financial budgets 2.Question :(TCO 2) To gain the benefits of budgeting, ________ must understand and support the budget. 3.Question : (TCO 2) Which budget is not necessary to prepare the budgeted balance sheet? 4.Question :(TCO 2) A feature of a standard-costing system is that the costs of every product or service planned to be worked on during the period can be computed at the start of that period. This feature of standard costing makes it possible to 5.Question :(TCO 2) An unfavorable variance indicates that 6.Question :(TCO 2) Which of the following statements is true about overhead cost variance analysis using activity-based costing? 7.Question :(TCO 2) Overhead costs have been increasing due to all of the following except 8.Question :(TCO 2) Katie Enterprises reports the year-end information from 20X8 as follows: Sales (70,000 units) $560,000; Cost of goods sold 210,000; Gross margin 350,000; Operating expenses 200,000; Operating income $150,000. Katie is developing the 20X9 budget. In 20X9, the company would like to increase selling prices by 4%, and as a result expects a decrease in sales volume of 10%. All other operating expenses are expected to remain constant. Assume that COGS is a variable cost and that operating expenses are a fixed......

Words: 508 - Pages: 3

Act 220 Ewing Master Budget Project

...ACT 220 Ewing Master Budget Project Click Link Below To Buy: http://hwcampus.com/shop/act-220-ewing-master-budget-project/ Master Budget Project (15 points, Master Budget Quiz is 20 points) Cam’s Bookcases manufactures spirit-oriented bookcases for sale at college bookstores. The company is completing its fifth year of operations and is preparing its master budget for the coming year (2015) based upon the following information: a. Fourth-quarter sales for 2014 are 55,000 units. Third quarter sales were 50,000 units. b. Unit sales by quarter are projected as follows: First quarter 2015 65,000 Second quarter 2015 70,000 Third quarter 2015 75,000 Fourth quarter 2015 90,000 First quarter 2016 80,000 Second quarter 2016 70,000 Each unit sells for $100. Cam’s estimates that 60% of sales will be collected in the quarter of sale. The company also estimates that 30% will be collected in the quarter following the sale and that 10% of each quarter’s sale will be collected in the second quarter following the sale. c. Cam’s tries to maintain at least 20% of next quarter sales forecast in inventory. Beginning inventory in the first quarter of 2015 is 6,500 units. d. Each bookshelf uses one and a half hours of direct labor, five pieces of wood, and two cement moldings. Laborers are paid $10 per hour, one piece of wood costs $8, and cement moldings are $2.50 each. e. At the end of each quarter, Cam’s plans to have 20 percent of the wood needs and...

Words: 625 - Pages: 3