Campus Expense Analysis and Solutions
Added on 2020-05-16
14 Pages2792 Words53 Views
|
|
|
Running head: PROFIT AND LOSS STATEMENT ANALYSISProfit and Loss Statement AnalysisName of the Student: Jamal-ud-dinName of the University:Student ID: 201404606Assessment Task no: 4
1PROFIT AND LOSS STATEMENT ANALYSISTable of ContentsProfit and loss Statement of Naja Group of Colleges......................................................................2Report on the Profit and loss Statement of all Campus...................................................................8Comparison Among Campuses for 3th Quarter..............................................................................10Recommended Solutions for reducing the Expenses.....................................................................11Reference.......................................................................................................................................13
2PROFIT AND LOSS STATEMENT ANALYSISProfit and loss Statement of Naja Group of CollegesNaja Group of CollegesCampus 1- North SydneyProfit and loss Account 2015/16Quarter 3Quarter 4ParticularsBudget ($)Actual ($)Difference(%)Budget ($)Actual ($)Difference(%)RevenueSales $2,10,000.00 $1,98,200.00 -6% $2,20,000.00 $2,09,327.00 -5% - Cost of goods sold $73,500.00 $69,370.00 -6% $77,000.00 $73,264.45 -5%Gross Profit $1,36,500.00 $1,28,830.00 -6% $1,43,000.00 $1,36,062.55 -5%Gross Profit %65%65%65%65%Expense - Accounting Fees $500.00 $500.00 0% $500.00 $500.00 0% - Interest Expenses $150.00 $150.00 0% $148.00 $148.00 0% - Bank Charges $250.00 $245.00 -2% $255.00 $259.00 2% - Depreciation $3,500.00 $3,500.00 0% $3,500.00 $3,500.00 0% - Insurance $1,800.00 $1,800.00 0% $1,800.00 $1,800.00 0% - Store Supplies $550.00 $590.00 7% $560.00 $624.00 11% -Advertising $6,250.00 $6,000.00 -4% $6,250.00 $6,750.00 8% - Cleaning $250.00 $255.00 2% $260.00 $289.00 11% - Repairs & Maintenance $750.00 $600.00 -20% $775.00 $900.00 16% - Rent $9,000.00 $9,000.00 0% $9,000.00 $9,000.00 0% - Telephone $800.00 $824.00 3% $875.00 $927.00 6% - Electricity $1,500.00 $1,700.00 13% $1,600.00 $1,750.00 9% - Wages & $ $2% $ $8%
3PROFIT AND LOSS STATEMENT ANALYSISSalaries11,450.00 11,624.00 12,000.00 12,950.00 - Superannuation $1,087.75 $1,104.28 2% $1,140.00 $1,230.25 8% - Payroll Tax $624.03 $633.51 2% $654.00 $705.78 8%Total Expenses $38,461.78 $38,525.79 0% $39,317.00 $41,333.03 5%Net Profit (BeforeTax) $98,038.22 $90,304.21 -8% $1,03,683.00 $94,729.52 -9%Income Tax $29,411.47 $27,091.26 -8% $31,104.90 $28,418.86 -9%Net Profit $68,626.75 $63,212.95 -8% $72,578.10 $66,310.66 -9%Naja Group of CollegesCampus 2- Norwest Business ParkProfit and loss Account 2015/16Quarter 3Quarter 4ParticularsBudget ($)Actual ($)Difference(%)Budget ($)Actual ($)Difference(%)RevenueSales $ 3,50,000.00 $ 3,63,327.00 4% $ 3,65,000.00 $ 3,37,643.00 -7% - Cost of goods sold $ 1,22,500.00 $ 1,27,164.45 4% $ 1,27,750.00 $ 1,18,175.05 -7%Gross Profit $ 2,27,500.00 $ 2,36,162.55 4% $ 2,37,250.00 $ 2,19,467.95 -7%Gross Profit %65%65%65%65%Expense - Accounting Fees $ 750.00 $ 750.00 0% $ 750.00 $ 750.00 0% - Interest Expenses $ 225.00 $ 225.00 0% $ 240.00 $ 231.00 -4% - Bank Charges $ 310.00 $ 300.00 -3% $ 330.00 $ 320.00 -3% - Depreciation $ 4,500.00 $ 4,500.00 0% $ 4,500.00 $ 4,500.00 0% - Insurance $ 1,800.00 $ 1,800.00 0% $ 1,800.00 $ 1,800.00 0% - Store Supplies $ 750.00 $ 875.00 17% $ 850.00 $ 976.00 15%
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents