FMM 225 Module Three Basic Markup Equations Buying Decisions 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 markup problems using formulas. Specifically, you must complete the following:
1. Review the pertinent formulas.
2. Read each problem carefully from the “Problems” tab in the Module Three Basic Markup Equations Buying Decisions Excel document.
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 |
|
Retail Price: Pants |
Calculation is correct and the work to arrive at the answer is accurate |
Calculation is partially correct |
Calculation is not accurate |
4 |
|
Retail Price: Televisions |
Calculation is correct and the work to arrive at the answer is accurate |
Calculation is partially correct |
Calculation is not accurate |
4 |
|
Cost Price: Sweater |
Calculation is correct and the work to arrive at the answer is accurate |
Calculation is partially correct |
Calculation is not accurate |
4 |
|
Cost Price: Belt |
Calculation is correct and the work to arrive at the answer is accurate |
Calculation is partially correct |
Calculation is not accurate |
4 |
|
Markup Dollars: Tie |
Calculation is correct and the work to arrive at the answer is accurate |
Calculation is partially correct |
Calculation is not accurate |
4 |
|
Markup: Necklace |
Calculations are correct and the work to arrive at the answers is accurate |
Calculations are partially correct |
Calculations are not accurate |
6.3 |
|
Markup: Boots |
Calculations are correct and the work to arrive at the answers is accurate |
Calculations are partially correct |
Calculations are not accurate |
6.3 |
|
Cost Price: Sneakers |
Calculations are correct and the work to arrive at the answers is accurate |
Calculations are partially correct |
Calculations are not accurate |
6.3 |
|
Maximum Cost: Coat |
Calculations are correct and the work to arrive at the answers is accurate |
Calculations are partially correct |
Calculations are not accurate |
6.3 |
|
Cost Price: Boxed Jewelry |
Calculations are correct and the work to arrive at the answers is accurate |
Calculations are partially correct |
Calculations are not accurate |
6.3 |
|
Critical Elements |
Proficient (100%) |
Needs Improvement (55%) |
Not Evident (0%) |
Value |
|
Department Maximum Costs |
Calculations are correct and the work to arrive at the answers is accurate |
Calculations are partially correct |
Calculations are not accurate |
6.3 |
|
Retail Price: Compact |
Calculation is correct and the work to arrive at the answer is accurate |
Calculation is partially correct |
Calculation is not accurate |
4 |
|
Retail Price: Sweater |
Calculations are correct and the work to arrive at the answers is accurate |
Calculations are partially correct |
Calculations are not accurate |
6.3 |
|
Retail Price: T-Shirt |
Calculations are correct and the work to arrive at the answers is accurate |
Calculations are partially correct |
Calculations are not accurate |
6.3 |
|
Cumulative Markup Percentages: Briefcases |
Calculations are correct and the work to arrive at the answers is accurate |
Calculations are partially correct |
Calculations are not accurate |
6.3 |
|
IMU: Crew Neck |
Calculations are correct and the work to arrive at the answers is accurate |
Calculations are partially correct |
Calculations are not accurate |
6.7 |
|
Jewelry: Adequate Assortment |
Calculations are correct and the work to arrive at the answers is accurate |
Calculations are partially correct |
Calculations are not accurate |
6.3 |
|
T-shirt: Retail Dollars |
Calculations are correct and the work to arrive at the answers is accurate |
Calculations are partially correct |
Calculations are not accurate |
6.3 |
|
Total |
100% |
|||