essay
quake
Sp17Flexiblebudgetprojectdataforclasstodownload1.xlsxPerformance Report
| Budget assumptions: | Kelsey's Frozen Confectionaries | |||||||||
| Master Budget Performance Report | ||||||||||
| Volume | 20,000 | cases | For the month ended June 30 | |||||||
| Sales Revenue | $ 50.00 | per case | ||||||||
| Percent sold on credit | 90% | percent of sales | ACTUAL | MASTER BUDGET | VARIANCE | VAR. % | F or U | Investigate? | ||
| Volume (in cases) | 21,460 | |||||||||
| Variable Expenses: | ||||||||||
| CGS | $ 30.00 | per case | Sales Revenue | $ 1,131,020 | ||||||
| Sales Commission | $ 2.50 | per case | Less Variable Expenses: | |||||||
| Shipping Expense | $ 2.00 | per case | Cost of Goods Sold | $ 682,880 | ||||||
| Bad Debt Expense | 1.00% | percent of credit sales | Sales Commissions | $ 58,685 | ||||||
| Shipping Expense | $ 44,213 | |||||||||
| Fixed Monthly Expenses: | Bad debt expense | $ 16,930 | ||||||||
| Salaries | $ 40,000 | Contribution Margin | $ 328,312 | |||||||
| Lease on Distribution center | $ 17,000 | Less Fixed Expenses: | ||||||||
| Depreciation on fleet & Equip | $ 12,000 | Salaries | $ 43,000 | |||||||
| Advertising | $ 10,000 | Lease on Distn center | $ 15,500 | |||||||
| Office rent, phone, internet | $ 11,000 | Deprec. on fleet/equip | $ 12,000 | |||||||
| Advertising | $ 7,750 | |||||||||
| Management by exception | 15% | Investigation rule | Office rent, phone, net | $ 12,300 | ||||||
| Operating Income | $ 237,762 | |||||||||
| Kelsey's Frozen Confectionaries | ||||||||||
| Fexible Budget Performance Report | ||||||||||
| For the month ended June 30 | ||||||||||
| ACTUAL | FLEXIBLE BUDGET | MASTER BUDGET | ||||||||
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 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. 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.
