Report on Develop and Manage Budget

Running head: DEVELOP & MANAGE A BUDGET
Develop &Manage a Budget
Name of the Student:
Name of the University:
Author’s Note:

1DEVELOP & MANAGE A BUDGET
Table of Contents
Assessment 1:..................................................................................................................................2
TASK 1:.......................................................................................................................................2
TASK 2:.......................................................................................................................................2
TASK 3:.......................................................................................................................................3
TASK 4:.......................................................................................................................................4
TASK 5:.......................................................................................................................................5
TASK 6:.......................................................................................................................................6
Assessment 2:..................................................................................................................................7
Assessment 3:................................................................................................................................10
References list:...............................................................................................................................17

2DEVELOP & MANAGE A BUDGET
Assessment 1:
TASK 1:
SALESBUDGET:
Sydney Melbourne Brisbane GoldCoast Adelaide Perth
Nos. of Sales 740 680 620 710 550 420
Average Price per unit $260 $220 $200 $190 $180 $170
ProjectedSales $192,400 $149,600 $124,000 $134,900 $99,000 $71,400
Formula View:
SALESBUDGET:
Sydney Melbourne Brisbane GoldCoast Adelaide Perth
Nos. of Sales 740 680 620 710 550 420
Average Price per unit 260 220 200 190 180 170
ProjectedSales =B4*B5 =C4*C5 =D4*D5 =E4*E5 =F4*F5 =G4*G5
TASK 2:
PURCHASEBUDGET:
October November December January
BudgetedSales($) $120,000 $140,000 $250,000 $125,000
BudgetedCostof GoodsSold $96,000 $112,000 $200,000 $100,000
Add: ClosingInventory $168,000 $300,000 $150,000
CostofGoodsAvailableforSale $264,000 $412,000 $350,000
Less: OpeningInventory $144,000 $168,000 $300,000
BudgetedPurchase $120,000 $244,000 $50,000
Formula View:
PURCHASEBUDGET:
October November December January
Budgeted Sales($) 120000 140000 250000 125000
BudgetedCostof GoodsSold =B4*(100%/125%) =C4*(100%/125%) =D4*(100%/125%) =E4*(100%/125%)
Add: ClosingInventory =C5*150% =D5*150% =E5*150%
CostofGoodsAvailableforSale =B5+B6 =C5+C6 =D5+D6
Less: OpeningInventory 144000 =B6 =C6
BudgetedPurchase =B7-B8 =C7-C8 =D7-D8

3DEVELOP & MANAGE A BUDGET
TASK 3:
EXPENSEBUDGET:
Particulars Amount
ExpectedSales $95,000FixedExpenses:
Managers' Salary $6,000
Depreciation on DeliverySchedule $1,000
Depreciation of Fixtures& fittings $1,500
Stationery $1,100
Rent $1,000
Interest on Loan $2,500
General Expesnse $800
Total FixedExpenses $13,900VariableExpenses:
Advertising $2,500
Commission $1,900
Cartage $950
Discount Allowed $2,375
Total VariableExpenses $7,725
Total BudgetedExpenses $21,625
Formual View: