(CIS331 -SystmMdlngThry) Figures 10.1 Week07

(CIS331 -SystmMdlngThry) Figures 10.1 Week07 - 89789 109742...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
SGP/KRB 1/1/2006 PARAMETERS Q1 Q2 Q3 Q4 Price $40.00 Cost $25.00 Seasonal 0.9 1.1 0.8 1.2 OHD rate 0.15 Sales Parameters 35 3000 Sales Expense 8000 8000 9000 9000 Ad Budget $40,000 DECISIONS Total Ad Expenditures $10,000 $10,000 $10,000 $10,000 $40,000 OUTPUTS Profit $69,662 Base case $69,662 CALCULATIONS Quarter Q1 Q2 Q3 Q4 Total Seasonal 0.9 1.1 0.8 1.2 Units Sold 3592 4390 3192 4789 15962 Revenue 143662 175587 127700 191549 638498 Cost of Goods
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 89789 109742 79812 119718 399061 Gross Margin 53873 65845 47887 71831 239437 Sales Expense 8000 8000 9000 9000 34000 Advertising 10000 10000 10000 10000 40000 Overhead 21549 26338 19155 28732 95775 Total Fixed Cost 39549 44338 38155 47732 169775 Profit 14324 21507 9732 24099 69662 Profit Margin 9.97% 12.25% 7.62% 12.58% 10.91%...
View Full Document

Ask a homework question - tutors are online