Answered step by step
Verified Expert Solution
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:
- What trends (positive/ negative) are showing in the cash flow?
- What are the possible reasons for a decrease in May in the profit and loss (provide research)?
- What is the gross profit % for each month?
- What does the quarter reports tell you about Club Train's profitability?
- 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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started