Kelsey’s Frozen Confectionaries buys and distributes single-serve
ice cream treats, popsicles, etc., such
as those sold at convenience stores, sporting events and amusement
parks. Download the file containing
Kelsey’s budget assumptions and actual figures for June. The file
also contains a draft for both a 1)
master budget performance report (planning budget vs. actuals and
variances), and 2) a flexible budget
performance report.
- Flexible Budget Performance Report Project Kelsey S Frozen Confectionaries Buys And Distributes Single Serve Ice Cream 1 (92.71 KiB) Viewed 63 times
- Flexible Budget Performance Report Project Kelsey S Frozen Confectionaries Buys And Distributes Single Serve Ice Cream 2 (109.8 KiB) Viewed 63 times
- Flexible Budget Performance Report Project Kelsey S Frozen Confectionaries Buys And Distributes Single Serve Ice Cream 3 (136.84 KiB) Viewed 63 times
- Flexible Budget Performance Report Project Kelsey S Frozen Confectionaries Buys And Distributes Single Serve Ice Cream 4 (82.98 KiB) Viewed 63 times
NUMBERS ARE DIFFERENT****
A B с 1 1 2 Budget assumptions: 3 4 Volume 5 Sales Revenue 20,000 cases 50.00 per case $ 75% percent of sales $ $ 32.00 per case 1.50 per case 3.25 per case 2.00% percent of credit sales $ 6 Percent sold on credit 7 8 Variable Expenses: 9 CGS 10 Sales Commission 11 Shipping Expense 12 Bad Debt Expense 13 14 Fixed Monthly Expenses: 15 Salaries 16 Lease on Distribution center 17 Depreciation on fleet & Equip 18 Advertising 19 Office rent, phone, internet 20 21 Management by exception: 22 $ $ $ 50,000 21,000 12,000 8,000 9,500 $ $ 10% OR $7,500 Investigation rule
A B с HINTS on EXCEL: 23 24 25 26 27 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. 28 29 30 31 32 2. To add numbers, put your cursor on the cell where you want the answer to be. Then keystroke the addition sign (+) and then click on the cell you want add, then keystroke the addition sign again (+) 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. 33 34 3. To multiply, use the * symbol. To divide, use the / symbol. 35 4. Make use of copy/paste commands when you want similar forumulas in different cells. 36 37 38 39 40 41 42 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.
E F G H J K L M N 1 2 оршун 3 Kelsey's Frozen Confectionaries Master Budget Performance Report For the month ended June 30 4 5 Mgnt By Exception: MASTER BUDGET VARIANCE VAR. % For U Invest % Invest $ ACTUAL 19,200 $ 940,800 6 7 Volume (in cases) 8 9 Sales Revenue 10 Less Variable Expenses: 11 Cost of Goods Sold 12. Sales Commissions 13 Shipping Expense 14 Bad debt expense 15 Contribution Margin 16 Less Fixed Expenses: 17 Salaries 18 Lease on Distn center 19 Deprec. on fleet/equip 20 Advertising 21 Office rent, phone, net 22 Operating Income 23 24 $ $ $ $ $ 633,600 38,400 76,800 15,200 176,800 $ $ $ $ $ $ 48,000 20,000 13,000 10,000 10,500 75,300
E F G H K L 29 30 Kelsey's Frozen Confectionaries Fexible Budget Performance Report For the month ended June 30 31 32 For For FLEXIBLE (Put Label here) U BUDGET (Put Label here) 33 ACTUAL U MASTER BUDGET 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51