Thursday, 2 August 2012

The budgeted unit sales of Haerve Company for the upcoming fiscal year are provided below

The budgeted unit sales of Haerve Company for the upcoming fiscal year are provided below:

1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
  Budgeted unit sales 12,000 14,000 11,000 10,000


The company’s variable selling and administrative expenses per unit are $2.75. Fixed selling and administrative expenses include advertising expenses of $12,000 per quarter, executive salaries of $40,000 per quarter, and depreciation of $16,000 per quarter. In addition, the company will make insurance payments of $6,000 in the 2nd Quarter and $6,000 in the 4th Quarter. Finally, property taxes of $6,000 will be paid in the 3rd Quarter.

Required:
Prepare the company’s selling and administrative expense budget for the upcoming fiscal year. (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)

Haerve Company
Selling and Administrative Expense Budget
    1st
   Quarter
    2nd
   Quarter
    3rd
   Quarter
    4th
   Quarter
    Year
  Variable selling and administrative expenses correct $ 33,000 correct   $ 38,500 correct   $ 30,250 correct   $ 27,500 correct   $ 129,250 correct  





  Fixed selling and administrative expenses:
       Advertising correct 12,000 correct   12,000 correct   12,000 correct   12,000 correct   48,000 correct  
       Executive salaries correct 40,000 correct   40,000 correct   40,000 correct   40,000 correct   160,000 correct  
       Insurance correct 0 correct   6,000 correct   0 correct   6,000 correct   12,000 correct  
       Property taxes correct 0 correct   0 correct   6,000 correct   0 correct   6,000 correct  
       Depreciation correct 16,000 correct   16,000 correct   16,000 correct   16,000 correct   64,000 correct  





  Total fixed selling and administrative expenses 68,000 correct   74,000 correct   74,000 correct   74,000 correct   290,000 correct  





  Total selling and administrative expenses n/r incorrect   n/r incorrect   n/r incorrect   n/r incorrect   n/r incorrect  
       Less depreciation correct n/r incorrect   n/r incorrect   n/r incorrect   n/r incorrect   n/r incorrect  





  Cash disbursements for selling and administrative expenses $ n/r incorrect   $ n/r incorrect   $ n/r incorrect   $ n/r incorrect   $ n/r incorrect  










No comments:

Post a Comment