Spreadsheet Case Study: Applied Business Math Formulas
Click here to access and complete spreadsheet 6.2-a, for this portion of the assignment. (You may open this and the following spreadsheets directly using the links, then save the spreadsheets to your device and open them from there.)
Identify each of the metrics (e.g., Cost Complement, Markup, On Hand, etc.) that you calculated to complete the spreadsheet, including the formulas used to complete the calculations.
Evaluate the results and form conclusions regarding the current state of the business.
Click here to access and complete the spreadsheet 6.2-b, for this portion of the assignment.
Identify each of the metrics that you calculated to complete the spreadsheet, including the formulas used to complete the calculations.
Deduce whether the sales and margin target goals will be met by implementing the new markups.
Identify any errors or problems that might be encountered when implementing the new markups.
Based on the information provided in the spreadsheet, judge whether management’s assumptions regarding projected season unit sales are reasonable. Explain the reasoning used to support your judgment.
Develop an argument for or against the new markups that explains how changes in either of the two metrics (projected season unit sales and new retail pricing) influence the other.
Click here to access and complete the spreadsheet 6.2-c, for this portion of the assignment.
Identify each of the metrics that you calculated to complete the spreadsheet, including the formulas used to complete the calculations.
Distinguish any trends that are indicated by the results of your calculations and make and defend predictions regarding their potential influence on profitability.
Evaluate the usefulness of knowing average sales, average stock, turnover, and average inventory at cost when making decisions regarding inventory planning and open to buy.
Develop your answers and recommendations in a six-page (minimum) paper. Attach your completed spreadsheets in an appendix or appendices to the completed paper. The minimum length does not include the title page, abstract, reference page, or any additional pages containing charts, appendices, etc. A minimum of three outside research sources are required for this assignment, in addition to any internal company sources you may use.
Format Instructions: Your paper must be double-spaced, 12 point Times New Roman font, with 1” margins on all sides. It must consist of a title page, abstract, body of the paper, and a reference page. A running header and page numbers must be included per APA style guidelines. Level I, Level II, and Level III headings must be used in the body of the paper. An appendix (or appendices) must be included after the reference page. The appendix/appendices should contain materials to support your answers to the questions posed in this paper. Since outside sources are required on this assignment, APA style in-text citations must be included in the body of the paper.
