Posted: September 13th, 2017

Quantitative Analysis Paper

Quantitative Analysis Paper

The objective of this assignment is to verify the ability of students to use and analyze spreadsheets as an important quantitative tool when making managerial decisions. Students are asked to build and analyze a simple spreadsheet assigned by the instructor from an example provided in the book (end of chapter spreadsheet problems) or designed by the instructor. Once students have completed the quantitative analysis they will need to interpret the results and finish with the policy implications of their analysis. The analysis can be on topics such as, but not limited to, optimal production and pricing, cost analysis with fixed and variable inputs, competitive market equilibrium in the short and long runs, monopoly practices, identifying superior mutual fund performance, or welfare effects of externalities.

The Quantitative Analysis Paper needs to include:

Cover Page: Course name and number, assignment title, student’s name, date.

Introduction: Establishing in the student’s own words the business situation being analyzed.

Analysis Section: Responding to the questions posed in the problem in a word document format so that the completed Quantitative Analysis paper will be a combination of EXCEL and MSWORD related material.

Conclusions/Recommendations: Once students has completed the quantitative analysis they will need to interpret the results and finish with the policy implications of their analysis.

Graduate Percentage Scale:    0.00 – 68.74%    68.75 – 86.24%    86.25 – 93.74%    93.75 – 100%
Graduate Scaled Score:    0.0 – 1.5    1.6 – 2.9    3.0 – 3.5    3.6 – 4.0
% of Grade    Below Standard    Approaching Standard    At Standard    Exceeds Standard
Appropriate use of Excel    25    Calculated worksheet is not completed using Excel.
Calculated worksheet is completed using Excel; calculations are entered manually without the use of formulas; spreadsheet has many items not labelled; organization is poor.
Calculated worksheet is completed on Excel with adequate formatting; most items are clearly labelled; organization is adequate.
Calculated worksheet is completed using Excel; all items and columns are clearly labelled; organization is clear; solutions are highlighted.

Accuracy of Solution    25    Work is poorly done and does not demonstrate knowledge of course concepts. Steps in the process were not followed.
Student understands course concepts at minimum level of competency. Steps in the process are inconsistent.
Student understands course concepts at an acceptable level of competency. Steps in the process are consistent.
Student presents a clear understanding of the course concepts. Knowledge of steps in the process is precise showing maximum level of competency.

Completeness of Solution    25    Student has failed to follow the instructions which accompany the problem resulting in the wrong soltuion or missing sections of the solution.
At least one portion of the assignment is missing.
Work submitted includes each portion of the assignment, but parts do not flow logically through the process.
Each portion of the assignment has been thoroughly prepared and linked to other parts of the assignment.

Professional Presentation    25    Incorrect grammar, spelling, syntax, and punctuation with many errors. Unprofessional presentation format detracts from information and message.
Some improper grammar, spelling, syntax , or spelling errors. Presentation format is not logical.
Mostly correct use of grammar, spelling, syntax, and punctuation. Most material is logically presented in a profession format.
Writing mechanics are nearly flawless with consistently proper use of grammar, syntax, punctuation, and spelling. All material is logically presented in a profession format.

TOTAL    100%