week 4assign Acc
gbabriell23
Week4assignmentAcc543excel.xlsxFlexible budget
| Master Budget | FlexibleBudget for Actual data | ||||
| Variable costs | Variable costs | Variable costs | |||
| Meals | 20,300.00 | Meals | 23,490.00 | Meals | 25,110.00 |
| Postage | 1,470.00 | Postage | 1,960.00 | Postage | 1,960.00 |
| 21,770.00 | 25,450.00 | 27,070.00 | |||
| Fixed Costs | Fixed Costs | Fixed Costs | |||
| Facilty | 1,000.00 | Facilty | 1,500.00 | Facilty | 1,500.00 |
| Printing | 950.00 | Printing | 950.00 | Printing | 950.00 |
| Decorations | 840.00 | Decorations | 840.00 | Decorations | 840.00 |
| Speakers Gifts | 130.00 | Speakers Gifts | 130.00 | Speakers Gifts | 130.00 |
| Publicity | 600.00 | Publicity | 600.00 | Publicity | 600.00 |
| Total cost | 25290.00 | 29470.00 | 31090.00 | ||
| Variable costs | |||||
| Meals (1400 x $14.5) | 20,300.00 | ||||
| Postage (3000 x $0.49) | 1,470.00 | ||||
| Variable costs | |||||
| Meals (1620 x$14.5) | 23,490.00 | ||||
| Postage (4000 x $0.49) | 1,960.00 | ||||
| Variable costs | |||||
| Meals (1620 x $15.5) | 25,110.00 | ||||
| Postage (4000 x $0.49) | 1,960.00 |
Comparison
| Master and Flexible Budget | |
| Total cost Variance | $ 25,290 - $ 29,470 = $ 4,180 (UF) |
| Variable cost Variance | $21,770 - $ 25,450 = $3,680 (UF) |
| Flexible Budget and actual data | |
| Total cost Variance | $ 29,470 - $31,090 = $ 1,620 (UF) |
| Variable cost Variance | $ 25,450 - $ 27,070 = $ 1,620 (UF) |
