3 D E G Name A 1 2 Budicet assumptions 3 4 Volume 5 Sales Revenue Master Budget 20,000 cases $ 50.00 per case Actuals 21,460 $1,080,250 Kelsey's Frozen Confectionaries Budget Performance Report For the month ended lune 30 90% percent of sales MASTER BUDGET FLEXIBLE BUDGET ACTUAL VARIANCE For U Volume (in cases) 6 Percent sold on credit 7 8 Variable Expenses 9 Direct materials 10 Direct labor 11 Sales Commission 12 Shipping Expense 13 Bad Debt Expense $ $ $ 10.00 per case 20.00 per case 2.50 per case 200 per case 100% percent of credit sales 216,350 435,350 53,650 40.213 9,722 $ s $ 15 Fixed Monthly Expenses 16 Salaries 17 lease on Distribution center 18 Depreciation on fleet & Equip 19 Advertising 20 Office rent, phone, internet 21 40.000 17.000 12,000 10,000 11.000 S $ $ Sales Revenue Variable Expenses Direct materials Direct labor Sales Commissions Shipping Expense Bad debt expense Total Variable Costs Contribution Margin Fixed Expenses Salaries Lease on Distcenter Deprec on fleet/equip Advertising Officerent, phone.net Total Fixed Costs Operating income 43,350 15.525 12.000 7,750 12,300 23 R S HINTS on EXCEL: 1) If you get a series of hashmarks (######) it just means your column width is not wide enough to accomodate the number. Increase column width and/or delete extra decimal places. 2. To add numbers, put your cursor on the cell where you want the answer to be. Then keystroke the equal or addition sign and then click on the cell you want add, then keystroke the addition sign and click on the second cell you want to add. Continue in the same fashion for multiple cells. Use the subtraction sign for subtracting cells. If you have an array of cells to add, you can use the AutoSum button. 3. To multiply, use the symbol. To divide, use the / symbol. 4. Make use of copy/paste commands when you want similar forumulas in different cells. 5. Always check the logic of your results after entering formulas to make sure the spreadsheet is doing what you really want it to do