Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Revenue Recognition and Billing Calculations for CP/FP

Revenue Recognition and Billing Calculations for CP/FP

View products that this article applies to.

TechKnowledge Content

Question:
How is Revenue Recognition and Billing calculated for Fixed Price and Cost Plus projects?

Answer:

 

 
 		 Forecast
 
 
 
 
 		 Actual
 
 
 
 

 
 		 unit cost
 		 Qty
 		 total cost
 		 baseline rev
 		 baseline actual
 		 unit cost
 		 Overhead
 		 Qty
 		 total cost
 
Project 1
 
 
 
 
 
 
 
 
 
 
 

 		 Cost Cat 1
 		 100
 		 10
 		 1000
 		 100
 		 2000
 		 43.27
 		 30
 		 1
 		 73.27
 

 		 Cost Cat 2
 		 100
 		 10
 		 1000
 		 100
 		 2000
 		 43.27
 		 30
 		 1
 		 73.27
 

 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 
 
Project 2
 
 
 
 
 
 
 
 
 
 
 

 		 Cost Cat 1
 		 100
 		 10
 		 1000
 		 100
 		 2000
 		 43.27
 		 30
 		 1
 		 73.27
 

 		 Cost Cat 2
 		 100
 		 10
 		 1000
 		 100
 		 2000
 		 43.27
 		 30
 		 1
 		 73.27
 

 
 
 
 
 
 
 
 
 
 
 
For an uncombined Cost to Cost Project:

Actual Total Cost/ Forecast Total Cost = Cost % Completed

73.27/1000=7.33%

**7.33%*2000=$146.60

For a combined Cost to Cost Project:

Actual Total Cost for this budget item/ Forecast Total Cost for all Cost Categories on the project = Cost % Completed

73.27/4000=1.83%

**1.83%*8000=$146.60

For a combined Cost to Cost Project and Contract:

Actual Total Cost for this budget item/ Forecast total cost for all Cost Categories on the contract =Cost % Completed

73.27/4000=1.83%

**1.83%*8000 =$146.60

For an Uncombined Effort Expended Project:

Actual Total Quantity/Forecast Total Quantity= % Quantity Completed

1/10 =10%

** 10% *2000=$200

For a Combined Effort Expended Project:

Actual Total Quantity for this budget item/ Forecast Total Quantity for all Cost Categories = % Quantity Completed

1/20= 5%

** 5%*4000=$200

For a Combined Effort Expended Project and Contract:

Actual Total Quantity for this Budget Item/ Forecast Total Quantity for all Cost Categories on the Contract

1/40=2.5%

**2.5%*8000=$200

** Once the percentages are determined they are then multiplied by the forecast billing amount to determine a ‘recommended’ billing amount or revenue recognition amount.





This article was TechKnowledge Document ID: 24694

↑ Back to the top

Keywords: kb, kbinfo, kbnoloc, kbnomt, kbMBSMigrate, kbMBSPartner, BemisKB872169, kbnosurvey

↑ Back to the top

Article Info
Article ID : 872169
Revision : 1
Created on : 3/11/2017
Published on : 3/11/2017
Exists online : False
Views : 265