Course Fee Audit Worksheet Fall 2021 - Summer 2022



Course Fee Audit Worksheet Fall 2021 - Summer 2022 Initiated By: FORMTEXT test Date FORMTEXT 6/6/20Chair Approval (print name) FORMTEXT testInitial FORMTEXT TAApproval via Attachment* FORMCHECKBOX Date FORMTEXT 6/6/20Dean Designee Approval FORMTEXT testInitial FORMTEXT TBApproval via Attachment* FORMCHECKBOX Date FORMTEXT 6/6/20Other Dept. Approval FORMTEXT testInitial FORMTEXT TCApproval via Attachment* FORMCHECKBOX Date FORMTEXT 6/6/20*Approvals documented by email must be uploaded with the Course Fee Worksheet. 281178010160Use this worksheet for all three practice submissions. EDIT: select a course in your unit with an existing fee and edit using data highlighted in blue. NEW: select a course in your unit and add a new fee using data highlighted in green. CANCEL: select a course in your unit with an existing fee and cancel using data highlighted in yellow. If a data element is not highlighted, it is the same for each practice submission. 00Use this worksheet for all three practice submissions. EDIT: select a course in your unit with an existing fee and edit using data highlighted in blue. NEW: select a course in your unit and add a new fee using data highlighted in green. CANCEL: select a course in your unit with an existing fee and cancel using data highlighted in yellow. If a data element is not highlighted, it is the same for each practice submission. Course Information – Use the Master Course Fee List for existing fee information Subject Catalog # (Ex. PSY 101) FORMTEXT ????? Course ID (Ex. 006445) FORMTEXT ?????Topic Title if fee is only applied to this title FORMTEXT ?????*Each cross-listed or co-convened course must have its own course fee audit worksheet. Fee Information if changing Proposed Fee Amount after manual cross check, review all fields for possible changes:Effective Term FORMDROPDOWN FORMDROPDOWN Fee TypeFlat FeeCurrent Fee Amount zero if New fee:$ FORMTEXT 0.00 Proposed Fee Amount:$ FORMTEXT 1000Request Type FORMDROPDOWN Edit- Increase CancelNew Fee Reason FORMDROPDOWN Fee Increase Reason FORMDROPDOWN Fee Decrease Reason166751033020For a cancellation, no further data beyond reason is required. The Documentation is hinky for cancel right now- so if you open it up but can’t upload, then Cancel and go on to Validate. We are working on this bug now.00For a cancellation, no further data beyond reason is required. The Documentation is hinky for cancel right now- so if you open it up but can’t upload, then Cancel and go on to Validate. We are working on this bug now. FORMDROPDOWN Edit- Same Reason FORMDROPDOWN Cancellation ReasonExpenses eliminated*If pursuing a per unit fee, email Coursesfees@nau.edu before completing the worksheet. Campuses (Select all applicable) Flagstaff Mountain FORMCHECKBOX Online FORMCHECKBOX *Yuma - if selected see Guide FORMCHECKBOX Statewide CampusesCentral Arizona College FORMCHECKBOX Chandler-Gilbert Cmty Coll FORMCHECKBOX Eastern Arizona College FORMCHECKBOX Estrella Mountain Cmty Coll FORMCHECKBOX Glendale Cmty Coll FORMCHECKBOX Mesa Cmty Coll FORMCHECKBOX Mohave Cmty Coll FORMCHECKBOX NAU - East Valley FORMCHECKBOX NAU - North Valley FORMCHECKBOX NAU - Yavapai FORMCHECKBOX Navajo-Hopi FORMCHECKBOX Northland Pioneer College FORMCHECKBOX Paradise Valley Cmty Coll FORMCHECKBOX Phoenix Biomedical FORMCHECKBOX Phoenix College FORMCHECKBOX Pima Cmty Coll, Downtown FORMCHECKBOX Pima Cmty Coll, West FORMCHECKBOX Scottsdale Cmty Coll FORMCHECKBOX South Mountain Cmty Coll FORMCHECKBOX Yavapai College FORMCHECKBOX *If fee applies to both Yuma and Flagstaff Mountain campuses, separate worksheets are required. …….… Do not check Yuma and Flagstaff Mountain on the same worksheet.Enrollment Information: AY 20-21 estimated annual enrollment is calculated from actual enrollment in 2019 Summer, Fall, Winter and 2020 Spring. Use the Course Fees Enrollment report to determine Est. Annual Enrollment. Est. Annual Enrollment923925108585See Guide for how to override enrollment in PS pages.00See Guide for how to override enrollment in PS pages. FORMTEXT 100Enrollment Data from CF Enrollment Report? FORMDROPDOWN If No, explain how enrollment was calculated FORMTEXT Enrollment based on cohort numbers. General Fee RequirementsThe following apply to all course fees: Fees must be course specific.Fees must benefit all the students paying the fee.Fees are not used for operations expenses.Fees are not used for minimal expectations of services covered by a course’s tuition, e.g., instruction, grading, or standard general classroom fixtures and supplies. Cost Breakdown*Automatic calculations for Per Student Breakdown will not occur if the Est. Annual Enrollment field is empty.Expense CategoriesThe following applies to all Personnel, Travel/Third Party, and Materials/Software expenses.Fees collected must be spent in full each year-- for accrued expenses see Accrual Category.Course fees are for exclusive use. Fees are course specific, benefit only the students paying the fees, and benefit all students enrolled in the course. See Guide for details.Prohibited use of course fee funding: per NAU policy, the listed prohibitions may not be funded with course fees. Please note these items are not discouraged or prohibited from use; however, funding must come from a source other than course fees.See Guide for typical expenses in this category.PersonnelProhibited use of course fees for personnel: Any instructor of record including GA’s and TA’s.Reader-graders, problem set graders, or similar.Guest speakers, presenters, or similar. See Guide for qualifying Specified Guest Instructor.See Guide for typical expenses in this category.In the Description, indicate costs per term (include ERE where applicable) and then record total expense for the year. Example Descriptor: Peer facilitators (3@$300) each Fall, Spring, Summer. Total: $2700Check compliance when this section is complete.DescriptionTotal FORMTEXT Test personnel description$ FORMTEXT 10000.00175647724765Use the same data for new/edit 00Use the same data for new/edit FORMTEXT ?????$ FORMTEXT ????? FORMTEXT ?????$ FORMTEXT ????? FORMTEXT ?????$ FORMTEXT ????? FORMTEXT ?????$ FORMTEXT ?????Subtotal$ FORMTEXT =PersonnelCost1 + PersonnelCost2 + PersonnelCost3 + PersonnelCost4 + PersonnelCost5 1000010000.00Per Student Cost$ FORMTEXT =(PersonnelCost1 + PersonnelCost2 + PersonnelCost3 + PersonnelCost4 + PersonnelCost5)/Enrollment 100100.00 FORMCHECKBOX Checking this box, the person preparing this worksheet confirms compliance in all Personnel costs with (1) expenditure within the academic year, (2) assurance of exclusive use, and (3) prevention of prohibited use.Travel/Third Party [includes Trips, Entry Fees, Rentals] Prohibited use of course fees for Trips, Travel, Facilities, RentalIndividual student travel (eligible travel is for entire class only).Individual conference, professional function attendance-- student or instructor (eligible attendance is for entire class only).Instructor travel outside the function of the course.Specialized training for personnel associated with a course.See Guide for typical expenses in this category.In the Description, indicate costs per term and then record total expense for the year. Example Descriptor: Boat rentals for Fall term Grand Canyon trip (3@$500)Total: $1500Check compliance when section is complete.DescriptionTotal FORMTEXT Test travel description$ FORMTEXT 20000.001589840108652Use the same data for new/edit 00Use the same data for new/edit FORMTEXT ?????$ FORMTEXT ????? FORMTEXT ?????$ FORMTEXT ????? FORMTEXT ?????$ FORMTEXT ????? FORMTEXT ?????$ FORMTEXT ?????Subtotal$ FORMTEXT =TripsTravelCost1 + TripsTravelCost2 + TripsTravelCost3 + TripsTravelCost4 + TripsTravelCost5 2000020000.00Per Student Cost$ FORMTEXT =(TripsTravelCost1 + TripsTravelCost2 + TripsTravelCost3 + TripsTravelCost4 + TripsTravelCost5)/Enrollment 200200.00 FORMCHECKBOX Checking this box, the person preparing this worksheet confirms compliance in all Travel/Third Party costs with (1) expenditure within the academic year, (2) assurance of exclusive use, and (3) prevention of prohibited use.Materials/Software [includes Lab/Studio Supplies, Online access]Prohibited use of course fees for MaterialsAny items intended for general use and not specific to the student’s benefit from enrollment in a course, e.g., office supplies, general printing/copiers, multi-use/classroom furniture or whiteboards.Food for class meetings, parties, or events. See Guide for qualifying food expenses.Printing/copies that violate copyright laws or do not provide cost savings to students.*Note that assessment materials may include scantrons, but please don’t use the term scantrons in your description.See Guide for typical accruals.In the Description, indicate costs per term if applicable and then record total expense for the year. Example Descriptor: Annual resupply of chemicals for lab ($750 per term)Total: $1500Check compliance when section is complete.DescriptionTotal FORMTEXT test material description$ FORMTEXT 30000.001790366156912Use the same data for new/edit 00Use the same data for new/edit FORMTEXT ?????$ FORMTEXT ????? FORMTEXT ?????$ FORMTEXT ????? FORMTEXT ?????$ FORMTEXT ????? FORMTEXT ?????$ FORMTEXT ?????Subtotal$ FORMTEXT =SuppliesCost1 + SuppliesCost2 + SuppliesCost3 + SuppliesCost4 + SuppliesCost5 3000030000.00Per Student Cost$ FORMTEXT =(SuppliesCost1 + SuppliesCost2 + SuppliesCost3 + SuppliesCost4 + SuppliesCost5)/Enrollment 300300.00 FORMCHECKBOX Checking this box, the person preparing this worksheet confirms compliance in all Materials/Software costs with (1) expenditure within the academic year, (2) assurance of exclusive use, and (3) prevention of prohibited use.Accrual Category The following applies to all accruals.Expense must require an accrual of funds for more than one year and have a useful life of more than one year.Exclusive use: course fee accruals must be course specific, benefit only the students paying the fees, and benefit all students enrolled in the course.An accrued expense may be shared across multiple courses (e.g., computers in a lab, special equipment in a clinical classroom). And an accrued expense may be in multiple rooms (e.g. 2 treadmills located in 2 different classrooms). Prohibited use of course fee funding: per NAU policy, listed accruals may not be funded with course fees. Please note these items are not discouraged or prohibited from use; however, funding must come from a source other than course fees.See Guide for explanation on completing data fields below. Specialized EquipmentProhibited use of accrual: Any items intended for general use and not specific to the student’s benefit from enrollment in the course, e.g., items for department/program use, general printing/copiers, multi-use/classroom furniture, whiteboards, or similar.Any items with useful life one year or less. Technology or Audiovisual covered by the IT Central Tech Fee.Software covered by general university licensing. Improvements requiring reconstruction of spaces.Use Shared Accruals entry for accruals funded by and used by more than one class, do not enter individually.3324225220980Use the same data for new/editSelect a room from the room look up.00Use the same data for new/editSelect a room from the room look up.See Guide for explanation on completing data fields below. Check compliance when section is complete. Description 1: FORMTEXT test accrual descriptionComputers or A/V include laptops, tablets, etc.# of UnitsCost per Unit include all taxes, extra feesTotal AmountExpense Date – Enter fiscal year of purchaseUseful Life in yearsPer Student CostPrimary Room? FORMTEXT 5$ FORMTEXT 30000.00$ FORMTEXT =(SpecEquipUnits1 * SpecEquipUnitsCost1) 150000150000.00 FORMTEXT 2025 FORMTEXT 5$ FORMTEXT =(((SpecEquipUnits1*SpecEquipUnitsCost1)/(UsefulLife1))/(Enrollment)) 300300.00 FORMTEXT Room ADescription 2: FORMTEXT ?????Computers or A/V include laptops, tablets, etc.# of UnitsCost per Unit include all taxes, extra feesTotal AmountExpense Date - Enter fiscal year of purchaseUseful Life in yearsPer Student CostPrimary Room? FORMTEXT ?????$ FORMTEXT ?????$ FORMTEXT =(SpecEquipUnits2 * SpecEquipUnitsCost2) 00.00 FORMTEXT ????? FORMTEXT ?????$ FORMTEXT =((SpecEquipUnits2*SpecEquipUnitsCost2)/(UsefulLife2)/(Enrollment)) !Zero Divide????? FORMTEXT ?????Description 3: FORMTEXT ?????Computers or A/V include laptops, tablets, etc.# of UnitsCost per Unit include all taxes, extra feesTotal AmountExpense Date - Enter fiscal year of purchaseUseful Life in yearsPer Student CostPrimary Room? FORMTEXT ?????$ FORMTEXT ?????$ FORMTEXT =(SpecEquipUnits3 * SpecEquipUnitsCost3) 00.00 FORMTEXT ????? FORMTEXT ?????$ FORMTEXT =((SpecEquipUnits3*SpecEquipUnitsCost3))/(UsefulLife3)/(Enrollment) !Zero Divide????? FORMTEXT ?????Description 4: FORMTEXT ?????Computers or A/V include laptops, tablets, etc.# of UnitsCost per Unit include all taxes, extra feesTotal AmountExpense Date - Enter fiscal year of purchaseUseful Life in yearsPer Student CostPrimary Room? FORMTEXT ?????$ FORMTEXT ?????$ FORMTEXT =(SpecEquipUnits4 * SpecEquipUnitsCost4) 00.00 FORMTEXT ????? FORMTEXT ?????-624840131445Use the same data for new/editAdd a row.Select a room from the room look up.00Use the same data for new/editAdd a row.Select a room from the room look up.$ FORMTEXT =((SpecEquipUnits4*SpecEquipUnitsCost4))/(UsefulLife4)/(Enrollment) !Zero Divide????? FORMTEXT ?????Shared Accruals list items with accrual used by multiple courses FORMTEXT test shared accrualsVerify per student cost is the same for each student in all classes listedComputers or A/V include laptops, tablets, etc.Per Student CostPrimary Room??$ FORMTEXT 100.00 FORMTEXT Room BSpecialized Equipment Per Student Cost TotalSpecialized Equipment Per Student Cost Total (This field does not auto-calculate – please add Specialized Equipment per student costs)$ FORMTEXT 400.00 FORMCHECKBOX Checking this box, the person preparing this worksheet confirms compliance in all Accrual costs with (1) necessity to accrue, (2) assurance of exclusive use, and (3) prevention of prohibited use. Manual Cross-CheckEnter the Per Student Cost from each section and compare with Proposed Fee. Is your total fee amount correct? Personnel Per Student Cost$ FORMTEXT 100.00Travel/Third Party Per Student Cost$ FORMTEXT 200.00Materials/Software Per Student Cost$ FORMTEXT 300.00Specialized Equipment Per Student Cost Total$ FORMTEXT 400.00Total Per Student Cost$ FORMTEXT =ManPersonnelPerStd + ManTripsTrvlPerStd + ManSuppliesPerStd + ManSpecEquipPerStd 10001000.00Proposed Fee (If discrepancy, check per student costs or update Proposed Fee Amount)$ FORMTEXT =ProposedFee1 10001000.00Budget Information- consult with a business/financial manager for your department to complete this section.Account InformationDepartment ID191579533020For the edit, the financial data will be populated.00For the edit, the financial data will be populated. FORMTEXT Office of General CouncilDepartment Name FORMTEXT 100010Fund Code FORMTEXT 2200Details Purpose ABOR (1000 characters or less) – will be duplicated in ABOR form.3573780179070Use the same data for new/edit or enter your own00Use the same data for new/edit or enter your ownProvide a general picture of what the course fees will provide and the proposed outcomes that will result in added student benefit. Include the annual cost amount. See Guide for annual cost calculation and tips and examples. FORMTEXT Test purpose text.Justification ABOR (1000 characters or less) – will be duplicated in ABOR form.Provide specific details about itemized costs that support the annual cost and identify if funding will be 100% course fees or augmented by other sources. If space allows include more details about student benefit. See Guide for tips and examples. FORMTEXT Test justification text.Exclusive Use AUDIT (700 characters or less) – required for AuditDescribe the controls used to guarantee that only the students paying the fee benefit from the services or materials purchased with the fee. FORMTEXT Test exclusive use text. If entries above are 250 characters or less, copy and paste into corresponding field below. If entries exceed 250 characters, list critical elements for University Committee consideration below.356616026670Use the same data for new/edit or enter your own00Use the same data for new/edit or enter your ownPurpose Summary for University Committee (250 characters or less) FORMTEXT Test purpose summary.35204404445Upload, Validate, SubmitClick Documentation and upload a copy of this practice worksheet.Click Validate- if there are any issues, they will be listed. If validations is successful, the Submit button will become active- Click to Submit.Click Back button at bottom of page to return to search.00Upload, Validate, SubmitClick Documentation and upload a copy of this practice worksheet.Click Validate- if there are any issues, they will be listed. If validations is successful, the Submit button will become active- Click to Submit.Click Back button at bottom of page to return to search.Justification Summary for University Committee (250 characters or less) FORMTEXT Test justification summary.Exclusive Use Summary for University Committee (250 characters or less) FORMTEXT Test exclusive use summary. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download