First Quarter Forecast

First Quarter Forecast - Second Quarter Forecast APR MAY...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Yuliya Dzeravianka Page 1 07/28/2011 Downtown Internet Café First Quarter Forecast JAN FEB MAR TOTAL AVG Proportion Sales Espresso $13,300 $13,600 $14,200 $41,100 $13,700 55.02% Drip Coffee $5,800 $6,000 $6,200 $18,000 $6,000 24.10% Food/Beverages $3,600 $3,800 $3,800 $11,200 $3,733 14.99% Merchandise $1,000 $1,100 $1,100 $3,200 $1,067 4.28% Computer $400 $400 $400 $1,200 $400 1.61% Total Sales $24,100 $24,900 $25,700 $74,700 $24,900 Expenses Cost of Goods $7,225 $7,480 $7,690 $15,875 $7,465 Cost of Merchandise $700 $770 $770 $5,100 $747 Payroll $9,000 $9,000 $9,000 $27,000 $9,000 Internet $325 $325 $325 $975 $325 Building $2,100 $2,100 $2,100 $6,300 $2,100 Advertising $600 $600 $600 $1,800 $600 Capital Assets $1,500 $1,500 $1,500 $4,500 $1,500 Miscellaneous $1,300 $1,300 $1,300 $3,900 $1,300 Total Exp $22,750 $23,075 $23,285 $65,450 $23,037 Income Net Income $1,350 $1,825 $2,415 $9,250 $1,863 Profit Margin 5.60% 7.33% 9.40% 12.38%
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Yuliya Dzeravianka Page 2 07/28/2011 Downtown Internet Café
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Second Quarter Forecast APR MAY JUN TOTAL AVG Proportion Sales Espresso $14,400 $15,200 $15,500 $45,100 $15,033 55.54% Drip Coffee $6,200 $6,200 $6,200 $18,600 $6,200 22.91% Food/Beverages $3,600 $3,800 $3,800 $11,200 $3,733 13.79% Merchandise $1,500 $1,500 $1,500 $4,500 $1,500 5.54% Computer $600 $600 $600 $1,800 $600 2.22% Total Sales $26,300 $27,300 $27,600 $81,200 $27,067 Expenses Cost of Goods $7,620 $7,940 $8,015 $16,875 $7,858 Cost of Merchandise $1,050 $1,050 $1,050 $5,550 $1,050 Payroll $9,000 $9,000 $9,000 $27,000 $9,000 Internet $325 $325 $325 $975 $325 Building $2,100 $2,100 $2,100 $6,300 $2,100 Advertising $600 $600 $600 $1,800 $600 Capital Assets $1,500 $1,500 $1,500 $4,500 $1,500 Miscellaneous $1,300 $1,300 $1,300 $3,900 $1,300 Total Exp $23,495 $23,815 $23,890 $66,900 $23,733 Income Net Income $2,805 $3,485 $3,710 $14,300 $3,333 Profit Margin 10.67% 12.77% 13.44% 17.61% Income Year-to-Date #NAME?...
View Full Document

This note was uploaded on 07/27/2011 for the course ACCT 115 taught by Professor Klavery during the Winter '10 term at Strayer.

Page1 / 2

First Quarter Forecast - Second Quarter Forecast APR MAY...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online