MA2 Excel Template Sp22.xlsx - Major Assignment 2 Excel...

Rubric Category
(% weighting for
assignment)
Project Budget
(15%)
Budget Summary
and Analysis
(11%)
CPI Values, Slope,
Y-Intercept, and
Cost Projection
(18%)

Funding - Inputs
(5%)
Sponsorship,
Fundraising, and
Loan Payment
Calculations
(15%)

Major Assignment 2 Excel Grading
Requirements for full credit
You have listed at least 8 budget items total with at least 1 item in each category.
Your Subtotal formulas are correct for each of your 4 sections.
Your month and year entries are correct following the first (generated) values.
Your CPI values are correct for the months and years given.
Your slope and y-intercept formulas are correct and use the appropriate Excel functions.
You have entered your full name in the field provided. (Note that entering your name
on this sheet is required in order to complete the assignment.)
You have entered the number of times purchased and purchase amount for each item,
and at least 3 items are purchased more than once.
Your Total Cost for each item is a formula multiplying the number of times purchased
by the purchase amount, using appropriate cell references.
You have explicitly formatted your Cost Per Purchase, Total Cost, and Subtotal cells to
display as Currency with the $ sign and 2 decimal places of precision. (1/2 point each)
You have transferred your Subtotals from the Budget to the Summary and Analysis
section, using formulas with cell references.
Your Budget Total is correctly calculated from your Subtotals as a formula using cell
references.
Your Percentage of Total formulas are correctly calculated from the Subtotals and
Budget Total in the Summary section, using cell references.
Subtotal and Budget Total cells are formatted as Currency showing the $ symbol and
with 2 decimal places of precision, and percentages are formatted as Percentage with 1
decimal place.
The year number to use for your CPI projection is correct, and you have brought your
Budget Total forward using an Excel formula with appropriate cell reference.
Your formulas to calculate the projected CPI value, 5-year inflation rate, and 5-year
budget projection are correct.
Your formatting is correct for all cells: your CPI values are formatted as number with 3
decimals of precision; your 5-year inflation rate is formatted as a percentage with 2
decimal places; and your 5-year budget and budget projection are formatted as currency
with the $ symbol and 2 decimal places.