Prepare a monthly flexible
selling expense budget for Podism Company for sales volumes of
$270,000, $350,000, and $480,000, based on the following
data:
Sales commissions |
7% of sales |
Sales manager's salary |
$62,000 per month |
Advertising expense |
$70,000 per month |
Shipping expense |
2% of sales |
Miscellaneous selling expense |
$2,500 per month plus 1/2% of sales |
--Ignore the columns/rows not required by you
Budgeted sales | $270,000 | $350,000 | $480,000 |
Variable costs: | |||
Sales commission 7% of sales | $18,900 | $24,500 | $33,600 |
Shipping expense 2% of sales | $5,400 | $7,000 | $9,600 |
Miscellaneous selling expense 0.5% of sales | $1,350 | $1,750 | $2,400 |
Total Variable cost | $25,650 | $33,250 | $45,600 |
Contribution margin | $244,350 | $316,750 | $434,400 |
Fixed Costs: | |||
Sales manager's salry | $62,000 | $62,000 | $62,000 |
Advertising expense | $70,000 | $70,000 | $70,000 |
Miscellaneous selling expense 0.5% of sales | $2,500 | $2,500 | $2,500 |
Total Fixed cost | $134,500 | $134,500 | $134,500 |
Net Operating Income | $109,850 | $182,250 | $299,900 |
Get Answers For Free
Most questions answered within 1 hours.