QSO Milestone 2
QSO 320 Milestone Two Guidelines and Rubric Overview: Once youve uncovered inefficiencies in sales, you can take a look at average costs and profits to determine where inefficiencies lie in these areas. Again, it is important to know what data to analyze and what tools can be used to do so. It is also important to know how to describe the organizational impacts of the inefficiencies. Prompt: In this assignment, you will use your findings and raw data from Milestone One to dive deeper into types of wine and distribution centers. You will need to analyze these factors to determine average costs and profits. All of your analyses need to be submitted in an annotated Excel file, and each analysis needs to include a rationale. Specifically, the following critical elements must be addressed:
A. Calculate costs of shipping to Portland and Riverside by pallets and frequency. Illustrate your results in a table. Use the bin sizes from Milestone One, Part E.
B. Calculate the cost of production for the wine varieties sold in Portland and Riverside. Illustrate your results in a table. C. Generate a labeled table that illustrates gross profit for each variety of wine for each distribution center. Explain why this information is important for
informing operation efficiencies. D. Generate a labeled table that shows the profit after state taxes. For Portland, use a tax rate of 6.6% and for Riverside, use 8.8%. E. Provide a summary statement that describes the inefficiencies in the organizational cost and profit analysis, and explain why this information is
important for influencing management decisions.
Rubric Guidelines for Submission: Your assignment must be submitted using the Case Study Data Set Microsoft Excel document. Use 11-point Calibri font.
Critical Elements Exemplary Proficient Needs Improvement Not Evident Value
Costs of Shipping Meets Proficient criteria and demonstrates an insightful rationale for appropriately employed Excel functions (100%)
Calculates costs of shipping to Portland and Riverside by pallets and frequency and illustrates results in a table (85%)
Calculates costs of shipping to Portland and Riverside by pallets and frequency, but does not illustrate results in a table, or results contain inaccuracies or rationale is not provided (55%)
Does not calculate costs of shipping (0%)
20
https://learn.snhu.edu/d2l/lor/viewer/view.d2l?ou=6606&loIdentId=21606
Critical Elements Exemplary Proficient Needs Improvement Not Evident Value
Cost of Production Meets Proficient criteria and demonstrates an insightful rationale for appropriately employed Excel functions (100%)
Calculates the cost of production for the wine varieties sold in Portland and Riverside and illustrates results in a table (85%)
Calculates the cost of production for the wine varieties sold in Portland and Riverside, but does not illustrate results in a table, or results contain inaccuracies or a rationale is not provided (55%)
Does not calculate the cost of production (0%)
20
Gross Profit Meets Proficient criteria and explanation is detailed and well-conceived (100%)
Generates a labeled table that illustrates gross profit for each variety of wine for each distribution center, explaining why this information is important for informing operation efficiencies (85%)
Generates a labeled table that illustrates gross profit for each variety of wine for each distribution center, but does not provide an explanation, or explanation is cursory, contains inaccuracies, or lacks justification (55%)
Does not illustrate gross profit through the use of a labeled table (0%)
20
State Taxes Generates a labeled table that shows the profit after state taxes (100%)
Generates a labeled table, but table contains inaccuracies (55%)
Does not generate a labeled table (0%)
20
Cost and Profit Analysis
Meets Proficient criteria and demonstrates a complex grasp of how cost and profit analyses influence managerial decisions (100%)
Provides a summary statement that describes the inefficiencies in the organizational cost and profit analysis and explains why this information is important for influencing decisions (85%)
Provides a summary statement, but the statement description is cursory, contains inaccuracies, or lacks justification (55%)
Does not provide a summary statement that describes the inefficiencies in the organizational cost and profit analysis (0%)
15
Articulation of response
Submission is free of errors related to citations, grammar, spelling, syntax, and organization and is presented in a professional and easy-to- read format (100%)
Submission has no major errors related to citations, grammar, spelling, syntax, or organization (85%)
Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas (55%)
Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas (0%)
5
