This document is Spreadsheet Data. It is part of the supporting assessment resources for Assessment Task 2 of BSBITU402. King Edward VII College Pty Ltd ABN 012 444 555 IncomeAnnual budgetJULAUG Certificate III in International Trade$75,000.00 $9,000.00 $7,500.00 Certificate IV in International Trade$125,000.00 $12,500.00 $20,000.00 Diploma of International Trade$150,000.00 $21,000.00 $30,000.00 Expenditure Accounting fees$12,000.00 $4,000.00 $2,000.00 Advertising fees$10,000.00 $1,000.00 $1,500.00 Computer software$1,000.00 $500.00 $- Electricity$1,500.00 $300.00 $300.00 Insurance$4,800.00 $400.00 $400.00 Internet$1,300.00 $150.00 $200.00 Office supplies$2,700.00 $200.00 $400.00 Printing$2,200.00 $270.00 $300.00 Rent$60,000.00 $5,000.00 $5,000.00 Repairs and maintenance$3,200.00 $400.00 $300.00 Salaries$195,000.00 $13,000.00 $13,000.00 Superannuation expenses$20,000.00 $1,500.00 $1,500.00 Telephone$2,500.00 $4,500.00 $500.00 Travel$2,100.00 $-$3,000.00 Profit = Income - Expenditure Total Income$426,000 Total Expenditure$320,550 Profit made$105,450 Annual budget summary for July 2015 to June 2016 Monthly Budget (2015) OctoberNovemberDecember $7,500.00 $10,500.00 $5,000.00 $20,000.00 $16,000.00 $10,000.00 $15,000.00 $18,000.00 $15,000.00 $42,500.00 $44,500.00 $30,000.00 Monthly Budget (2015) OctoberNovemberDecember $1,000.00 $1,000.00 $1,000.00 $1,000.00 $500.00 $1,000.00
$80.00 $80.00 $30.00 $200.00 $100.00 $100.00 $400.00 $400.00 $400.00 $100.00 $120.00 $100.00 $200.00 $200.00 $300.00 $200.00 $200.00 $200.00 $5,000.00 $5,000.00 $5,000.00 $150.00 $200.00 $300.00 $17,000.00 $16,000.00 $16,250.00 $2,000.00 $1,500.00 $2,000.00 $150.00 $200.00 $200.00 $100.00 $100.00 $200.00 $27,580.00 $25,600.00 $27,080.00
Expert's Answer
Chat with our Experts
Want to contact us directly? No Problem. We are always here for you
Your future, our responsibilty submit your task on time.
Order NowGet Online
Assignment Help Services