PERFORMANCE REPORT

 

Budgeted or Pro Forma Income Statement - prepare first the operating budgets and once you know the per unit costs for direct materials, direct labor, and manufacturing overhead you can calculate cost of goods sold. To calculate the overhead rate you multiply the predetermined overhead rate times the rate for each hour of both direct and indirect labor hour required for one unit.

 

Budgeted Income Statement

     
 

DATA TABLE

 
 

Costs of goods sold per unit:

 

$20,00

 
 

Sales commissions (as a % of sales)

 

5,00%

 
 

Advertising expense

 

$170.000

 
 

Amortization expense

 

$50.000

 
 

Administrative salaries

 

$80.000

 
 

Shipping expense (fixed)

 

$40.000

 
 

Budgeted sales for 2013 (units)

 

21.000

 
 

Selling price (per unit)

 

$50

 
 

Shipping expense (per unit)

 

$7,50

 
         
 

Comptex Inc.

 
 

Budgeted Income Statement

 
 

For the 1st Quarter , 2013

 
 

Sales

 

$1.050.000

 
 

Less variable expenses:

     
 

Cost of goods sold

$420.000

   
 

Sales commissions

52.500

   
 

Shipping expense

157.500

   
 

Total variable expenses

 

630.000

 
 

Contribution margin

 

420.000

 
 

Less fixed expenses:

     
 

Advertising expense

170.000

   
 

Administrative salaries

80.000

   
 

Shipping expense

40.000

   
 

Amortization expense

50.000

   
 

Total fixed expenses

 

340.000

 
 

Net income

 

$80.000