Tommy's Tomatoes July August September October November December Total Sales budget $28,000 iner/dec Sales Actual $33,000 \begin{tabular}{l|l|l} $28,750 & $34,750 & $27,650 \end{tabular} Variance (\$) Variance (%) Cash collection 20% Cash, 80% in 30 days FORMULAS: Sales Budget incr/dec = (Previous Month Sales Budget x Percent inc/dec )+ Previous Month Sales Budget "note if percentage is positive or negative 18 Variance $ = Sales Actual - Sales Budget 19 Variance \% = (Actual Sales - Sales Budget)/Sales Budget 20 Cash Collection on Actual Sales= (Current Month x.20) + (Previous Month .80) Krissy's Katering May June August September October November December Total Sales budget $135,000 incr/dec Sales Actual Variance ($) Variance (%) Cash collection $36,000 30% cash 70% in 30 days FORMULAS: Sales Budget incr/dec = (Previous Month 5 ales Budget x Percent inc/dec) + Previous Month Sales Budget 'irote it percentage is positive or negative Varlance S = Sales Actual - Sales Budget Variance % = (Actual Sales - Sales Budget)/Sales Budget 20 Cash Collection on Actual Sales (Current Month x,30)+( Previous Month x,70 ) 21 22 Saler Actual (2017) Variance (5) for 2017 variaece (N) for 2017 Cah eallection 10\% eath 700 in 30 dove 20N in 60 dip (New Butinetu No Sales in Dectmber) fOhMuLAS Variance 5 - Sales Actual - swles budeet Sales Actual 2017 $114.000 $98.000 Varience (\$) for 2017 Variance (X) for 2017 Cash collection 205 cash sos in 30 doys 301 in 60 days (New Eusinesi No soles in December) FOAMULAS: Sales Budret 2017 incr/de - (Previous Year's Same Moeah Sales Budget x Percent inc/dec) + Fevilas Year's Same Month Sales Bouldet "netr if peremtane in palike of nrative Variance 5 = Sales Actial - 5ales tlodiget Variance $ - (Atrual Sales - 5ales Budget)/Sales Budget Cash Collection en Actual 5ales- (Current Month .20). (Previous Month .50)+(2 months ago .30) Tommy's Tomatoes July August September October November December Total Sales budget $28,000 iner/dec Sales Actual $33,000 \begin{tabular}{l|l|l} $28,750 & $34,750 & $27,650 \end{tabular} Variance (\$) Variance (%) Cash collection 20% Cash, 80% in 30 days FORMULAS: Sales Budget incr/dec = (Previous Month Sales Budget x Percent inc/dec )+ Previous Month Sales Budget "note if percentage is positive or negative 18 Variance $ = Sales Actual - Sales Budget 19 Variance \% = (Actual Sales - Sales Budget)/Sales Budget 20 Cash Collection on Actual Sales= (Current Month x.20) + (Previous Month .80) Krissy's Katering May June August September October November December Total Sales budget $135,000 incr/dec Sales Actual Variance ($) Variance (%) Cash collection $36,000 30% cash 70% in 30 days FORMULAS: Sales Budget incr/dec = (Previous Month 5 ales Budget x Percent inc/dec) + Previous Month Sales Budget 'irote it percentage is positive or negative Varlance S = Sales Actual - Sales Budget Variance % = (Actual Sales - Sales Budget)/Sales Budget 20 Cash Collection on Actual Sales (Current Month x,30)+( Previous Month x,70 ) 21 22 Saler Actual (2017) Variance (5) for 2017 variaece (N) for 2017 Cah eallection 10\% eath 700 in 30 dove 20N in 60 dip (New Butinetu No Sales in Dectmber) fOhMuLAS Variance 5 - Sales Actual - swles budeet Sales Actual 2017 $114.000 $98.000 Varience (\$) for 2017 Variance (X) for 2017 Cash collection 205 cash sos in 30 doys 301 in 60 days (New Eusinesi No soles in December) FOAMULAS: Sales Budret 2017 incr/de - (Previous Year's Same Moeah Sales Budget x Percent inc/dec) + Fevilas Year's Same Month Sales Bouldet "netr if peremtane in palike of nrative Variance 5 = Sales Actial - 5ales tlodiget Variance $ - (Atrual Sales - 5ales Budget)/Sales Budget Cash Collection en Actual 5ales- (Current Month .20). (Previous Month .50)+(2 months ago .30)
