Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your task is to review the last 3 months of financial data (Profit and Loss, Cash Flow and the Aging Summary) of the centre (of

 Your task is to review the last 3 months of financial data (Profit and Loss, Cash Flow and the Aging Summary) of the centre (of your choice)and provide an analysis of the data including:

  1. What trends (positive/ negative) are showing in the cash flow?
  2. What are the possible reasons for a decrease in May in the profit and loss (provide research)?
  3. What is the gross profit % for each month?
  4. What does the quarter reports tell you about Club Train's profitability?
  5. How can you minimise or eliminate aging summary amounts?
Carindale Profit and loss
Apr-19 Budget Apr-19 Actual Variance $ Variance % May-19 Budget May-19 Actual Variance $ Variance % Jun-19 Budget Jun-19 Actual Variance $ Variance %
Revenue
Membership $57,280.00 $57,817.00 $537.00 1% $57,280.00 $57,996.00 $716.00 1% $57,280.00 $58,031.80 $751.80 1%
less Cost of Goods sold $572.80 $578.17 $5.37 1% $572.80 $579.96 $7.16 1% $572.80 $580.32 $7.52 1%
Retail $5,550.00 $5,750.00 $200.00 3% $5,550.00 $5,650.00 $100.00 2% $5,550.00 $5,555.00 $5.00 0%
less Cost of Goods sold $3,885.00 $4,025.00 $140.00 3% $3,885.00 $3,955.00 $70.00 2% $3,885.00 $3,888.50 $3.50 0%
Coffee Shop $11,259.00 $12,009.00 $750.00 6% $11,259.00 $12,159.00 $900.00 7% $11,259.00 $12,369.00 $1,110.00 9%
less Cost of Goods sold $3,377.70 $3,602.70 $225.00 6% $3,377.70 $3,647.70 $270.00 7% $3,377.70 $3,710.70 $333.00 9%
Total Sales $74,089.00 $75,576.00 $1,487.00 11% $74,089.00 $75,805.00 $1,716.00 10% $74,089.00 $75,955.80 $1,866.80 10%
less Cost of Goods sold $7,835.50 $8,205.87 $370.37 11% $7,835.50 $8,182.66 $347.16 10% $7,835.50 $8,179.52 $344.02 10%
Gross Profit $66,253.50 $67,370.13 $1,116.63 2% $66,253.50 $67,622.34 $1,368.84 2% $66,253.50 $67,776.28 $1,522.78 2%
Plus Lease Income $10,000.00 $9,500.00 -$500.00 -5% $10,000.00 $7,500.00 -$2,500.00 -33% $10,000.00 $5,000.00 -$5,000.00 -100%
Net Income $76,253.50 $76,870.13 $616.63 1% $76,253.50 $75,122.34 -$1,131.16 -2% $76,253.50 $72,776.28 -$3,477.22 -5%
Expenses
Accounting fees 200 200 $0.00 0% 200 200 $0.00 0% 200 200 $0.00 0%
Bank charges 50 50 $0.00 0% 50 50 $0.00 0% 50 50 $0.00 0%
Cleaning 400 400 $0.00 0% 400 400 $0.00 0% 400 400 $0.00 0%
Credit card fees 50 50 $0.00 0% 50 50 $0.00 0% 50 50 $0.00 0%
CRM Software 200 200 $0.00 0% 200 200 $0.00 0% 200 200 $0.00 0%
Depreciation 2,000 2,000 $0.00 0% 2,000 2,000 $0.00 0% 2,000 2,000 $0.00 0%
Equipment purchase 1,000 800 -$200.00 -25% 1,000 750 -$250.00 -33% 1,000 750 -$250.00 -33%
Insurance 200 200 $0.00 0% 200 200 $0.00 0% 200 200 $0.00 0%
Interest 100 100 $0.00 0% 100 100 $0.00 0% 100 100 $0.00 0%
Licences, permits, registrations etc. 200 200 $0.00 0% 200 200 $0.00 0% 200 200 $0.00 0%
Marketing 500 512 $12.00 2% 500 590 $90.00 15% 500 590 $90.00 15%
Music & Foxtel 200 200 $0.00 0% 200 200 $0.00 0% 200 200 $0.00 0%
Pool Supplies 2,000 2,420 $420.00 17% 2,000 2,390 $390.00 16% 2,000 1,890 -$110.00 -6%
Printing, postage, and stationery 500 499 -$1.00 0% 500 589 $89.00 15% 500 589 $89.00 15%
Rent 0 0 $0.00 0% 0 0 $0.00 0% 0 0 $0.00 0%
Repairs and maintenance 1,500 1,110 -$390.00 -35% 1,500 1,180 -$320.00 -27% 1,500 1,180 -$320.00 -27%
Security 1,000 1,000 $0.00 0% 1,000 1,000 $0.00 0% 1,000 1,000 $0.00 0%
Staff amenities 200 185 -$15.00 -8% 200 230 $30.00 13% 200 230 $30.00 13%
Sundries 500 605 $105.00 17% 500 680 $180.00 26% 500 680 $180.00 26%
Superannuation 3,325 3,325 $0.00 0% 3,325 3,325 $0.00 0% 3,325 3,325 $0.00 0%
Telephone, fax, internet 300 300 $0.00 0% 300 300 $0.00 0% 300 300 $0.00 0%
Training 500 420 -$80.00 -19% 500 420 -$80.00 -19% 500 420 -$80.00 -19%
Utilities (water, gas, electricity) 1,500 1,515 $15.00 1% 1,500 1,515 $15.00 1% 1,500 1,515 $15.00 1%
Wages (gross) 35,000 35,000 $0.00 0% 35,000 35,000 $0.00 0% 35,000 35,000 $0.00 0%
Workers compensation 200 192 -$8.00 -4% 200 202 $2.00 1% 200 202 $2.00 1%
Total expenses $51,625 $51,483 -$142 -2% $51,625 $51,771 $146 0% $51,625 $51,271 -$354 -1%
Net profit before tax $24,629 $25,387 $758.63 3% $24,629 $23,351 -$1,277.16 -5% $24,629 $21,505 -$3,123.22 -15%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To analyze the financial data provided for Carindale lets address each question 1 Trends in Cash Flow Positive trend The cash flow from operations see... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Dynamic Business Law

Authors: Nancy Kubasek, M. Neil Browne, Daniel Herron, Lucien Dhooge, Linda Barkacs

6th Edition

1260733971, 978-1260733976

More Books

Students also viewed these Finance questions

Question

=+b) Find the standard deviations.

Answered: 1 week ago