1、 INTERNET EXERCISESLO1: Explain how budgets facilitate planning and coordination.A1,B1LO2: Anticipate possible human relations problems caused by budgets.2540LO3: Explain potentially dysfunctional incentives in the budget process.2239, 40LO4: Explain the difficulties of sales forecasting.234249LO5:
2、Explain the major features and advantages of a master budget.24,2639LO6: Follow the principal steps in preparing a master budget.2943,45LO7: Prepare the operating budget and the supporting schedules.28,29,30,3143,45,46,48LO8: Prepare the financial budget.27,29,32,33, 34,3536,37,3843,44,47,48LO9: Use
3、 a spreadsheet to develop a budget (Appendix 7).41,42Introduction to Budgets and Preparing the Master Budget 7-A1 (60-90 min.) 1. Exhibit IRAPIDBUY ELECTRONICS, INC.Mall of America StoreBudgeted Income StatementFor the Three Months Ending August 31, 20X8Sales $300,000Cost of goods sold (.62 $300,000
4、) 186,000Gross profit $114,000Operating expenses: Salaries, wages, commissions $60,000 Other expenses 12,000 Depreciation 1,500 Rent, taxes and other fixed expenses 33,000 106,500Income from operations. $ 7,500Interest expense* 1,338Net income $ 6,162 * See schedule g for calculation of interest. Ex
5、hibit IICash Budget June July August Beginning cash balance $ 5,800 $ 5,600 $ 5,079 Minimum cash balance desired 5,000 5,000 5,000(a) Available cash balance $ 800 $ 600 $ 79 Cash receipts & disbursements: Collections from customers (schedule b) $ 75,200 $121,400 $ 90,800 Payments for merchandise (sc
6、hedule d) (86,800) (49,600) (49,600) Fixtures (purchased in May) (11,000) - - Payments for operating expenses (schedule f) (44,600) (30,200) (30,200)(b) Net cash receipts & disbursements $(67,200) $ 41,600 $ 11,000 Excess (deficiency) of cash before financing (a + b) (66,400) 42,200 11,079 Financing
7、: Borrowing, at beginning of period $ 67,000 $ - $ - Repayment, at end of period - (41,000) (10,000) Interest, 10% per annum - (1,121)* (217)*(c) Total cash increase (decrease) from financing $ 67,000 $(42,121) $(10,217)(d) Ending cash balance (beginning balance + b + c) $ 5,600 $ 5,079 $ 5,862* See
8、 schedule gExhibit IIIBudgeted Balance SheetAugust 31, 20X8 Assets Liabilities and Owners Equity Cash (Exhibit II) $ 5,862 Accounts payable $ 37,200Accounts receivable* 86,400 Notes payable 16,000*Merchandise inventory 37,200 Total current liabilities $ 53,200Total current assets $129,462 Net fixed
9、assets: Owners equity: $33,600 less $102,200 plus net depreciation of $1,500 32,100 income of $6,162 108,362Total assets $161,562 Total equities $161,562 *July sales, 20% 90% $80,000 $ 14,400 August sales, 100% $80,000 72,000 Accounts receivable $86,400 * See schedule g June July August TotalSchedul
10、e a: Sales Budget Credit sales (90%) $126,000 $72,000 $72,000 $270,000 Cash sales (10%) 14,000 8,000 8,000 30,000 Total sales (to Exhibit I) $140,000 $80,000 $80,000 $300,000 Schedule b: Cash Collections June July August Cash sales $ 14,000 $ 8,000 $ 8,000 On accounts receivable from: April sales 10
11、,800 - - May sales 50,400 12,600 - June sales - 100,800 25,200 July sales - - 57,600 Total collections (to Exhibit II) $75,200 $121,400 $90,800 Schedule c: Purchases Budget May June July August Desired purchases: 62% next months sales $86,800 $49,600 $49,600 $37,200Schedule d: Disbursements for Purc
12、hases June July AugustLast months purchases (to Exhibit II) $86,800 $49,600 $49,600Other required items related to purchasesAccounts payable, August 31, 2008 (62% September sales - to Exhibit III) $37,200Cost of goods sold (to Exhibit I) $86,800 $49,600 $49,600Schedule e: Operating Expense BudgetSal
13、aries, wages, commissions $28,000 $16,000 $16,000 $60,000Other Variable expenses 5,600 3,200 3,200 12,000Fixed expenses 11,000 11,000 11,000 33,000Depreciation 500 500 500 1,500Total operating expenses $45,100 $30,700 $30,700 $106,500Schedule f: Payments for Operating Expenses June July AugustVariable expenses $33,600 $19,200 $19,200Fixed expenses 11,000 11,000 11,000Total payments for operating expenses $44,600 $
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1