These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, December 10, 2015

Capital Needs Analysis Report - Bradley Westwood


Executive Summary

The business that I built my project for has asked not to be named, but it is a large non-profit organization. Each year this business does what it calls a capital needs analysis. Basically there is a schedule of when all of their capital assets should wear out and each year they inspect a portion of their capital assets and determine which ones need to be replaced. Based on that inspection they create different projects for each capital asset that they are going to replace based on that year’s inspection. My program allows them to track the budget and expenditures in each of these projects as well add new projects for assets that need to be replaced, but that were not included in the original budget.

http://files.gove.net/shares/files/15f/bmwpara/writeup.pdf 
http://files.gove.net/shares/files/15f/bmwpara/Westwood_Bradley.xlsm

Note: All project names have been changed and all dollar figures have been replaced by randomly generated numbers.

No comments:

Post a Comment

Blog Archive