Grading Rubric – Excel 2010

Case 3-3 Notable Web Site Design Operating Income Projection

Class: Computer Applications

Instructor: Thomas Russell

Solution Filename: Case 3-3 Notable Web Site Design Operating Income Projection.xlsx

Description / Pts / Your Score
The worksheet is created based on Table 3–20 / 4
The worksheet is similar to Figure 3–87 on Page EX 210 / 2
The worksheet shows total net revenues, total expenditures, and operating income for each quarterly period / 4
A 3-D Pie chart that shows the quarterly income contributions to the annual operating income is included on a separate sheet / 4
The worksheet and chart are formatted appropriately / 4
What-if analysis is performed to reflect a reduction in marketing expenditures by 1.25% and payroll costs by 2.75% / 2
Using the original assumptions shown in Table 3–20, what-if analysis is performed to find out to what extent marketing would have to be reduced to generate an annual operating income of $21,000,000 / 2
The workbook and results of the what-if analysis are submitted as specified by the instructor / 2
TOTAL POSSIBLE POINTS: / 24 / 0

YOUR SCORE: ______