Question

Prepare a monthly flexible selling expense budget for Podism Company for sales volumes of $270,000, $350,000,...

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

Homework Answers

Answer #1

--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
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Question 2 (27 marks) Prepare a monthly flexible selling expense budget for PineTree Company for sales...
Question 2 Prepare a monthly flexible selling expense budget for PineTree Company for sales volumes of $300,000 and $350,000, based on the following data: Sales commissions 6% of sales Sales manager's salary $120,000 per month Advertising expense $90,000 per month Shipping expense 1% of sales Miscellaneous selling expense $4,000 per month plus 1.5% of sales
Prepare June’s flexible selling expense budget for PineTree Company for sales volumes of $275,000, $300,000, $325,000,...
Prepare June’s flexible selling expense budget for PineTree Company for sales volumes of $275,000, $300,000, $325,000, and $350,000, based on the following data: Sales commissions 6% of sales plus $10 for every $10,000 sales Sales manager's salary $120,000 per month Advertising expense $90,000 per month plus $15 per day Shipping expense 1% of sales Miscellaneous selling expense $4,000 per month plus 1.5% of sales
Flexible Budget for Selling and Administrative Expenses Agent Blaze uses flexible budgets that are based on...
Flexible Budget for Selling and Administrative Expenses Agent Blaze uses flexible budgets that are based on the following data: Sales commissions 9% of sales Advertising expense 25% of sales Miscellaneous selling expense $2,500 plus 3% of sales Office salaries expense $17,000 per month Office supplies expense 4% of sales Miscellaneous administrative expense $1,750 per month plus 2% of sales Prepare a flexible selling and administrative expenses budget for January 2016, for sales volumes of $110,000, $140,000, and $165,000. (Use Exhibit...
Flexible Budget for Selling and Administrative Expenses for a Service Company Morningside Technologies Inc. uses flexible...
Flexible Budget for Selling and Administrative Expenses for a Service Company Morningside Technologies Inc. uses flexible budgets that are based on the following data: Sales commissions 8% of sales Advertising expense 20% of sales Miscellaneous administrative expense $1,700 per month plus 1% of sales Office salaries expense $16,000 per month Customer support expenses $2,350 plus 2% of sales Research and development expense 3,150 per month Prepare a flexible selling and administrative expenses budget for April for sales volumes of $105,000,...
Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions Inc. uses flexible...
Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales commissions 14% of sales Advertising expense 20% of sales Miscellaneous administrative expense $8,000 per month plus 12% of sales Office salaries expense $29,000 per month Customer support expenses $13,000 per month plus 20% of sales Research and development expense $30,000 per month Prepare a flexible selling and administrative expenses budget for October for sales volumes...
Flexible Budget for Selling and Administrative Expenses for a Service Company Cloud Productivity Inc. uses flexible...
Flexible Budget for Selling and Administrative Expenses for a Service Company Cloud Productivity Inc. uses flexible budgets that are based on the following data: Sales commissions 15% of sales Advertising expense 20% of sales Miscellaneous administrative expense $7,500 per month plus 12% of sales Office salaries expense $30,000 per month Customer support expenses $14,000 per month plus 20% of sales Research and development expense $31,000 per month Prepare a flexible selling and administrative expenses budget for March for sales volumes...
Flexible Budget for Selling and Administrative Expenses for a Service Company Cloud Productivity Inc. uses flexible...
Flexible Budget for Selling and Administrative Expenses for a Service Company Cloud Productivity Inc. uses flexible budgets that are based on the following data: Sales commissions 14% of sales Advertising expense 18% of sales Miscellaneous administrative expense $6,500 per month plus 12% of sales Office salaries expense $30,000 per month Customer support expenses $12,000 per month plus 20% of sales Research and development expense $32,000 per month Prepare a flexible selling and administrative expenses budget for March for sales volumes...
Flexible Budget for Selling and Administrative Expenses for a Service Company Cloud Productivity Inc. uses flexible...
Flexible Budget for Selling and Administrative Expenses for a Service Company Cloud Productivity Inc. uses flexible budgets that are based on the following data: Sales commissions 15% of sales Advertising expense 18% of sales Miscellaneous administrative expense $6,000 per month plus 12% of sales Office salaries expense $30,000 per month Customer support expenses $13,000 per month plus 20% of sales Research and development expense $32,000 per month Prepare a flexible selling and administrative expenses budget for March for sales volumes...
Flexible Budget for Selling and Administrative Expenses for a Service Company Morningside Technologies Inc. uses flexible...
Flexible Budget for Selling and Administrative Expenses for a Service Company Morningside Technologies Inc. uses flexible budgets that are based on the following data: Sales commissions 6% of sales Advertising expense 24% of sales Miscellaneous administrative expense $1,300 per month plus 3% of sales Office salaries expense $12,000 per month Customer support expenses $1,800 plus 4% of sales Research and development expense 4,000 per month Prepare a flexible selling and administrative expenses budget for April for sales volumes of $80,000,...
Flexible budget for selling and administrative expenses for a service company Digital Solutions Inc. uses flexible...
Flexible budget for selling and administrative expenses for a service company Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales commissions 8% of sales Advertising expense 13% of sales Miscellaneous administrative expense $8,000 per month plus 4% of sales Office salaries expense $45,000 per month Customer support expenses $15,000 per month plus 31% of sales Research and development expense $79,000 per month Prepare a flexible selling and administrative expenses budget for October for sales volumes...