Problem Set Merchandising for Profit
musicmakers333
FMM225ModuleTwoMerchandisingforaProfitGuidelinesandRubric.pdf
FMM 225 Module Two Merchandising for a Profit 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 basic merchandising problems using formulas. Specifically, you must complete the following:
1. Review the pertinent formulas from your resources. 2. Read each problem carefully from the “Problems” tab in the Module Two Merchandising for a Profit 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
Return Percentages Calculation is correct and the work to arrive at the answer is accurate
Calculation is partially correct Calculation is not accurate 6
Net Sales $ Calculation is correct and the work to arrive at the answer is accurate
Calculation is partially correct Calculation is not accurate 6
Men’s Store Calculations are correct and the work to arrive at the answers is accurate
Calculations are partially correct Calculations are not accurate 9.5
Loungewear Department Calculations are correct and the work to arrive at the answers is accurate
Calculations are partially correct Calculations are not accurate 9.5
Towel Department Net Sales Calculation is correct and the work to arrive at the answer is accurate
Calculation is partially correct Calculation is not accurate 6
Shoes/Sneakers Net Sales Calculations are correct and the work to arrive at the answers is accurate
Calculations are partially correct Calculations are not accurate 9.5
Total Billed Cost Calculations are correct and the work to arrive at the answers is accurate
Calculations are partially correct Calculations are not accurate 9.5
Total Cost of Merchandise Calculation is correct and the work to arrive at the answer is accurate
Calculation is partially correct Calculation is not accurate 6
Gross Margin Calculations are correct and the work to arrive at the answers is accurate
Calculations are partially correct Calculations are not accurate 9.5
Total Expenses Calculations are correct and the work to arrive at the answers is accurate
Calculations are partially correct Calculations are not accurate 9.5
Critical Elements Proficient (100%) Needs Improvement (55%) Not Evident (0%) Value
Comparison of Sales Calculations are correct and the work to arrive at the answers is accurate
Calculations are partially correct Calculations are not accurate 9.5
Skeletal Profit and Loss Statement
Calculations are correct and the work to arrive at the answers is accurate
Calculations are partially correct Calculations are not accurate 9.5
Total 100%
