Shortage and Overage

FMM 225 Module Six Shortage and Overage Guidelines and Rubric

Overview: The true value of spreadsheets is that the formulas automatically calculate your answers without the need to recalculate data every time an input number changes (which can be daily when selling merchandise). That is, once you set up the spreadsheet formulas, you can use the spreadsheet again and again, build a new tab, or simply save it as a new document. Prompt: For this assignment you will use Excel to calculate a variety of shortage and overage problems. Specifically, you must complete the following:

1. Read each problem carefully from the “Problems” tab in the Module Six Shortage and Overage Excel document. 2. Complete each problem. 3. Complete each problem using formulas.

Rubric

Guidelines for Submission: Submit the completed Excel document. You will need to have the correct formulas in the cells. Number-only responses will not be accepted for full credit.

Critical Elements Proficient (100%) Needs Improvement (55%) Not Evident (0%) Value

Shortage Percentage: Jewelry Department

Calculation is correct and the work to arrive at the answer is accurate

Calculation is partially correct Calculation is not accurate 15

Shoe Department Calculations are correct and the work to arrive at the answers is accurate

Calculations are partially correct Calculations are not accurate 20

Shortage or Overage Percentage

Calculations are correct and the work to arrive at the answers is accurate

Calculations are partially correct Calculations are not accurate 30

Planned Dollar Shortage Calculation is correct and the work to arrive at the answer is accurate

Calculation is partially correct Calculation is not accurate 15

January Calculations are correct and the work to arrive at the answers is accurate

Calculations are partially correct Calculations are not accurate 20

Total 100%