Each budget schedule is to be contained on a separate spreadsheet tab. You are to utilize the power of Excel for totaling and referencing amounts contained in other spreadsheets.
Create a "Basic" spreadsheet for your assumptions and raw data which will be used in the other budget spreadsheets. Use Excel referencing to look at these raw data figures.
Only the following budget spreadsheets are to be included: Sales, Collections, and Production. Be sure to use Word Wrapping, Alignment, and Punctuation for readability.
Your grade is based upon the accuracy and formatting of each spreadsheet, 30 points each. The use of the power of Excel is critical to a master budget such as this and, therefore, 20 points will be awarded for the creation of an Assumptions spreadsheet and references to those assumptions by the other spreadsheets.