EQUIPMENT QUESTIONNAIRE CALCULATION

 

 

 

 

DESCRIPTION:  Equipment Questionnaire Calculation is used to compile information for the equipment questionnaire to report to the Michigan Department of Transportation.  Note that you must complete the Fixed Asset Calculation before running the Equipment Questionnaire Calculation.

 

 

 

To access:  Click on the Equipment module  then click the Equipment Questionnaire Calc menu item.   

 

The following window will appear:

 

 

 

Enter your four digit County/City Number and your Council Number, if applicable.  For the Period End Date, enter the end date for your fiscal year by either typing in the date or by using the Calendar button.  Enter the Indirect Cost Percent to be applied.  Enter the percentage as whole numbers.  For example, 25.3% would be entered as 25.3, not .253.

 

Check the box next to Create the Equipment Questionnaire File.  To add the value of added assets and improvements made to equipment to the equipment purchase price, check the box next to Add Value Added to Equipment Purchase Price.  Then click the OK button.  You will be prompted to Name and Save your file.  A confirmation window will appear.  If the information is correct, then click OK.  If an error occurs during the process, a window will appear displaying the Equipment Code and Error Type.  After noting what the error is, click OK to continue the process.  When complete, a results window will appear.  If errors were found, correct them in the Equipment menu item before creating a new questionnaire file.

 

Equipment Questionnaire Calculation can be ran as many times as necessary in order to get the correctly compiled information.  Once the Equipment Questionnaire File has the correct information, you can run the Equipment Questionnaire Report by clicking the View button.  A Report Viewer window will appear.  Enter the year the questionnaire file is for then click the Run Report button at the top of the window.  The equipment questionnaire will be displayed.  If everything looks correct, you can Export or Print the report by clicking those buttons.

 

Click on the X in the upper right corner of the window to close the window.