Allpine Lumber Price Index and Invoice Creator

Kyle Martin

VBA Final Project

Executive Summary

In the early 1940's, Allpine Lumber began as a small lumber mill, focused principally on producing rough-cut dimension lumber for the residents of a small part of southern Colorado. Today, Allpine Lumber is one of the principal suppliers of house logs and other planed materials for log homes, not only for Colorado, but also for most of the Midwest and other parts of the United States.

Allpine Lumber has made a lot of changes since the 1940’s with upgrades to equipment and processes. In the not too distant past, an accidental fire burned down a large portion of the lumber mill. Almost as a blessing in disguise, this allowed Allpine Lumber to make some important changes to their processes that have changed their overall cost structure. The problem that they now face is realigning the prices on their products to match the cost it requires to produce those products. Their prices are currently based on an old cost structure and I created my project to utilize the most recent cost data to determine prices for their products. In addition to determining prices for their products, I have created a system for producing invoices for customers based on the newly determined prices.

 

Project Write-Up

http://files.gove.net/shares/files/14w/kmart8/Allpine-Project_Write-up1.pdf

Project File
http://files.gove.net/shares/files/14w/kmart8/Allpine_Lumber_Project.xlsm

Sample Data Files (needed for project)
http://files.gove.net/shares/files/14w/kmart8/2013_Sales_Summary.xlsx
http://files.gove.net/shares/files/14w/kmart8/2013_Expense_Report.xlsx