BSBMGT517 Manage operational plan
Sk232323
operationalplanbudget.xlsx
Sheet1
| Data | Budgeted 2016 | Actual | variance | variance % |
| Sales | $480,000 | $514,000 | -$34,000 | - 7.08 |
| Cost of goods sold | $215,000 | $200,000 | $15,000 | 6.98 |
| Gross margin | $265,000 | $314,500 | -$49,500 | - 18.68 |
| Gross margin % | 55% | 61% | -$0 | - 10.91 |
| rent | $6,000 | $6,200 | -$200 | - 3.33 |
| wages | $35,000 | $25,000 | $10,000 | 28.57 |
| utilities | $2,000 | $2,500 | -$500 | - 25.00 |
| consumables | $4,000 | $4,800 | -$800 | - 20.00 |
| Misc Exp | $10,000 | $12,000 | -$2,000 | - 20.00 |
| Operational Expenses | $57,000 | $50,500 | $6,500 | 11.40 |
| Operating Profit | $208,000 | $264,000 | -$56,000 | - 26.92 |
