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 ScoreThe 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: ______