total by cost category:

labour =$ 772,891

hardware = $567400

software = $ 38000

testing = $76400

reserves = $144169 (10% of total estimate)

total project cost estimate = $1598860

Q: prepare a quarterly cash budget

The consultant will bill BBCC quarterly using the following completion rates. The amount is considered due at the end of each quarter for the year. Note that hardware and software costs are billed in total at the beginning of the phase they are implemented. All other costs are based on percentage completion of the phase. YTD % completion Analysis Design Implementation January 25% 0 0 February 35% 10% 0 March 50% 20% April 60% 25% 0 May 75% 30% 0 June 85% 40% 10% July 85% 45% 20% August 85% 50% 25% September 90% 60% 40% October 95% 70% 50% November 100% 80% 60% December 100% 75% The cash budget should account for these costs as billed by the consultant. The consultant will bill BBCC quarterly using the following completion rates. The amount is considered due at the end of each quarter for the year. Note that hardware and software costs are billed in total at the beginning of the phase they are implemented. All other costs are based on percentage completion of the phase. YTD % completion Analysis Design Implementation January 25% 0 0 February 35% 10% 0 March 50% 20% April 60% 25% 0 May 75% 30% 0 June 85% 40% 10% July 85% 45% 20% August 85% 50% 25% September 90% 60% 40% October 95% 70% 50% November 100% 80% 60% December 100% 75% The cash budget should account for these costs as billed by the consultant