1 / 67

Profit Planning, Activity-Based Budgeting and e-Budgeting

9. Chapter Nine. Profit Planning, Activity-Based Budgeting and e-Budgeting. Purposes of Budgeting Systems. Budget a detailed plan, expressed in quantitative terms, that specifies how resources will be acquired and used during a specified period of time. Planning

orli
Download Presentation

Profit Planning, Activity-Based Budgeting and e-Budgeting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. 9 Chapter Nine Profit Planning,Activity-Based Budgeting and e-Budgeting

  2. Purposes of Budgeting Systems Budget a detailed plan, expressed in quantitative terms, that specifies how resources will be acquired and used during a specified period of time. • Planning • Facilitating Communication and Coordination • Allocating Resources • Controlling Profit and Operations • Evaluating Performance and Providing Incentives

  3. Activity-BasedCosting (ABC) Activity-BasedBudgeting (ABB) Activity-Based Costing versus Activity-Based Budgeting Resources Resources Activities Activities Cost objects:products and servicesproduced, andcustomers served. Forecast of productsand services to beproduced andcustomers served.

  4. Types of Budgets Detail Budget Detail Budget Detail Budget Materials Master Budget Covering all phases of a company’s operations. Production Sales

  5. Types of Budgets Capital budgets with acquisitions that normally cover several years. L o n g R a n g e B u d g e t s Continuous or Rolling Budget 1999 2000 2001 2002 This budget is usually a twelve-month budget that rolls forward one month as the current month is completed.

  6. Sales of Services or Goods Ending Inventory BudgetWork in Process and Finished Goods Production Budget Direct Materials Budget Direct LaborBudget Overhead Budget Selling and Administrative Budget Ending Inventory BudgetDirect Materials

  7. Sales of Services or Goods Exh. 9-1 Ending Inventory BudgetWork in Process and Finished Goods Production Budget Direct Materials Budget Direct LaborBudget Overhead Budget Selling and Administrative Budget Cash Budget Ending Inventory BudgetDirect Materials Budgeted Financial Statements

  8. Sales Budget • Breakers, Inc. is preparing budgets for the quarter ending June 30. • Budgeted sales for the next five months are: • April 20,000 units • May 50,000 units • June 30,000 units • July 25,000 units • August 15,000 units. • The selling price is $10 per unit.

  9. Sales Budget

  10. Sales Budget Production Budget Production Budget Completed Production must be adequate to meet budgeted sales and provide for sufficient ending inventory.

  11. Production Budget The management of Breakers, Inc. wants ending inventory to be equal to 20% of the following month’s budgeted sales in units. On March 31, 4,000 units were on hand. • Let’s prepare the production budget.

  12. Production Budget From sales budget

  13. Production Budget

  14. Production Budget March 31 ending inventory

  15. Production Budget

  16. Production Budget

  17. Direct-Material Budget • At Breakers, five pounds of material are required per unit of product. • Management wants materials on hand at the end of each month equal to 10% of the following month’s production. • On March 31, 13,000 pounds of material are on hand. Material cost $.40 per pound. • Let’s prepare the direct materials budget.

  18. Direct-Material Budget From ourproduction budget

  19. Direct-Material Budget 10% of the following month’s production

  20. Direct-Material Budget March 31 inventory

  21. Direct-Material Budget

  22. Direct-Material Budget

  23. Direct-Labor Budget • At Breakers, each unit of product requires 0.1 hours of direct labor. • The Company has a “no layoff” policy so all employees will be paid for 40 hours of work each week. • In exchange for the “no layoff” policy, workers agreed to a wage rate of $8 per hour regardless of the hours worked (No overtime pay). • For the next three months, the direct labor workforce will be paid for a minimum of 3,000 hours per month. • Let’s prepare the direct labor budget.

  24. Direct-Labor Budget From our production budget

  25. Direct-Labor Budget

  26. Direct-Labor Budget This is the greater of labor hours required or labor hours guaranteed.

  27. Direct-Labor Budget

  28. Overhead Budget Here is Breakers’ Overhead Budget for the quarter.

  29. Selling and Administrative Expense Budget • At Breakers, variable selling and administrative expenses are $0.50 per unit sold. • Fixed selling and administrative expenses are $70,000 per month. • The $70,000 fixed expenses include $10,000 in depreciation expense that does not require a cash outflows for the month.

  30. Selling and Administrative Expense Budget From our Sales budget

  31. Selling and Administrative Expense Budget

  32. Selling and Administrative Expense Budget

  33. Cash Receipts Budget • At Breakers, all sales are on account. • The company’s collection pattern is: • 70% collected in the month of sale, • 25% collected in the month following sale, • 5% is uncollected. • The March 31 accounts receivable balance of $30,000 will be collected in full.

  34. Cash Receipts Budget

  35. Cash Receipts Budget

  36. Cash Disbursement Budget • Breakers pays $0.40 per pound for its materials. • One-half of a month’s purchases are paid for in the month of purchase; the other half is paid in the following month. • No discounts are available. • The March 31 accounts payable balance is $12,000.

  37. Cash Disbursement Budget 140,000 lbs. × $.40/lb. = $56,000

  38. Cash Disbursement Budget

  39. Cash Disbursement BudgetContinued Breakers: • Maintains a 12% open line of credit for $75,000. • Maintains a minimum cash balance of $30,000. • Borrows and repays loans on the last day of the month. • Pays a cash dividend of $25,000 in April. • Purchases $143,700 of equipment in May and $48,300 in June paid in cash. • Has an April 1 cash balance of $40,000.

  40. Cash Disbursement BudgetContinued From our Cash Receipts Budget

  41. Cash Disbursement BudgetContinued From our Cash Disbursements Budget

  42. Cash Disbursement BudgetContinued From our Direct Labor Budget

  43. Cash Disbursement BudgetContinued From our Overhead Budget

  44. Cash Disbursement BudgetContinued From our Selling and Administrative Expense Budget

  45. Cash Disbursement BudgetContinued To maintain a cash balance of $30,000, Breakers must borrow $35,000 on its line of credit.

  46. Cash Disbursement BudgetFinancing and Repayment Ending cash balance for April is the beginning May balance.

  47. Cash Disbursement BudgetContinued Breakers must borrow an addition $13,800 to maintain a cash balance of $30,000.

  48. Cash Disbursement BudgetFinancing and Repayment

  49. Cash Disbursement BudgetContinued At the end of June, Breakers has enough cash to repay the $48,800 loan plus interest at 12%.

  50. Cash Disbursement BudgetFinancing and Repayment

More Related