3 - Financial Management 1_Assessment 1 - Part B.xlsx -...

Current Year
Actual Sales No. of units Price/unit Year
Meals 54,600.00 $10.50 $573,300.00
Drinks 20,000.00 $2.50 $50,000.00
TOTAL $623,300.00
Current Year
Actual Costs (CGOS No. of units Price/unit Year
Meals 54,600.00 $4.60 $251,160.00
Drinks 20,000.00 $0.80 $16,000.00
TOTAL $267,160.00

Quarter Month
$143,325.00 $47,775.00
$12,500.00 $4,166.67
$155,825.00 $51,941.67
Quarter Month
$62,790.00 $20,930.00
$4,000.00 $1,333.33
$66,790.00 $22,263.33

Budget Forec
Actual Sales No. of units Price/unit
Meals 60,060.00 $13.00
Drinks 30,000.00 $1.50
TOTAL
Budget Forec
Actual Costs (CGOS) No. of units Price/unit
Meals 60,060.00 $4.60
Drinks 30,000.00 $0.50
TOTAL
- Yearly Quarterly
Sales $825,780.00 $206,445.00
COGS $291,276.00 $72,819.00
Gross Profit $534,504.00 $133,626.00
Expenses
Rent $24,000.00 $6,000.00
Utilities $10,000.00 $2,500.00
Wages $60,000.00 $15,000.00
Miscellaneous $6,000.00 $1,500.00
Net Profit $434,504.00 $108,626.00

cast next year
Year Quarter Month
$780,780.00 $195,195.00 $65,065.00
$45,000.00 $11,250.00 $3,750.00
$825,780.00 $206,445.00 $68,815.00
cast next year
Year Quarter Month
$276,276.00 $69,069.00 $23,023.00
$15,000.00 $3,750.00 $1,250.00
$291,276.00 $72,819.00 $24,273.00
Monthly
$68,815.00
$24,273.00
$44,542.00
$2,000.00
$833.33
$5,000.00
$500.00
$36,208.67

Adjust Budget Forecast
Sales No. of units Price/unit Year
Meals 72072 $13.00 $936,936.00
Drinks 60000 $1.50 $90,000.00
Total $1,026,936.00
Adjust Budget Forecast
Costs (CGOS) No. of units Price/unit Year
Meals 72072 $4.60 $331,531.20
Drinks 60000 $0.50 $30,000.00
Total $361,531.20
- Yearly