class project
Fullborehemiworking on a final project
2 years ago
100
files (3)FinalprojectOverview.docx
Six-MonthPlanWorkbook.xlsx
FinalProjectPresentationTemplate.pptx
FinalprojectOverview.docx
Overview
The final project for this course is the creation of a six-month merchandise plan for the women’s dresses department. The final product represents an authentic demonstration of competency because it provides an authentic experience of completing a buying plan. The final deliverable will be the completion of the Six-Month Plan Workbook and a presentation of the summary using the Final Project Presentation Template, and the final product will be submitted in Module Seven.
In this assignment, you will demonstrate your mastery of the following course outcomes:
· Apply concepts of retail merchandise planning by analyzing relevant data for informing merchandise decisions
· Explain merchandising strategies for addressing real work issues based on results of data analyses
· Design plans for merchandising that maximizes profit
Prompt
When the buyer for the women’s dresses department started to develop the merchandise plan for the spring season, they reviewed the six-month plan in Figure 35 from your textbook. Use the Six-Month Plan Workbook to complete the calculations for this project.
Buyers begin the planning process well in advance of buying for the next season. The Six-Month Plan Workbook spreadsheet represents the dress department’s spring six-month plan. Last year’s results are as follows:
· Net Sales amounted to $4,500 million. (Note that all sales on all reports are in millions of dollars.)
· Cumulative markup percentage was 68.5%, and markdowns for the season were $1,914, representing a journalized markdown percentage of 42.5%, which resulted in a gross margin of 55.1%.
· Turn for the season was 0.96.
The numbers that were achieved represent the department’s performance last year for a fast-selling and up-trending department. The buyer was given the following information to plan for the upcoming spring season:
· Percent increase/decrease average of planned sales: +6.8%
· Planned markdown percentage: 46.1%
· Planned turnover: 0.98
· Cumulative markup percentage: 68.7%
For next spring, the buyer has to take into account a shift in Easter selling. Last year, Easter occurred on the first Sunday in April. Therefore, pre-Easter sales happened the last two weeks in March. This year, Easter falls on the third week of April. Based on the sales success this department has experienced over the last two years, the buyer is concerned about keeping that trend going.
Specifically, you must address the critical elements listed below. Most of the critical elements align with a particular course outcome (shown in brackets).
I. Analysis: Create an Excel spreadsheet. Acting as the buyer for the activewear department and using the spring season’s six-month plan as a template, create a spreadsheet and formulate the plan, markdown percentages, and beginning-of-month (BOM) stock needed . You will want to use the table above to help you do the calculations.
a. Sales Last Year: Calculate each month’s percentage of sales for last year. Note: Your response should be in percentages and rounded to the nearest tenth.
b. Sales Next Year: Calculate the total planned season sales by month for the next year. Note: You will want to account for the Easter shift.
c. Planned Markdown Dollars: Calculate the planned markdown dollars and percentage by month.
d. BOM Stock: Calculate the BOM stock needed by month.
e. Purchase Dollars: Calculate the purchase dollars in retail (also known as receipt dollars needed to achieve the BOM stock).
II. Summary: Summarize the six-month plan and add recommendations for enhancing the department’s overall success in the long run. Include the following:
a. Planned Monthly Sales: Explain the rationale behind the monthly percentages calculated for the planned monthly sales.
b. Planned Markdown Percentages: Explain the rationale behind the planned markdown percentages by month.
c. Inventory: Evaluate whether there is sufficient inventory at the beginning of each month to achieve your sales plan, and explain why or why not.
d. Slowing Down: Explain how the buyer should address their concern regarding sales potentially slowing down. Use data and examples to support your response.
e. Increase in Sales: Explain how the buyer should address inventory levels with an increase in sales. Use data and examples to support your response.
f. Gross Margin: Examine the potential effect of a higher markdown percentage on gross margin.
Milestones
Final Submission: Merchandise Plan In Module Seven, you will submit your final project. It should be a complete, polished artifact containing all of the critical elements of the final product. It should reflect the incorporation of feedback gained throughout the course. This submission will be graded with the Final Project Rubric.
What to Submit
The “Analysis” section of your merchandise plan must be submitted as an Excel document, and the “Summary” section must be submitted as a PowerPoint file and written in APA format. The Excel document should provide the equations you used to complete each calculation. The target audience is a business professional audience. Visit the Software for Students, Faculty, and Staff page for additional information about PowerPoint access.
Six-MonthPlanWorkbook.xlsx
Six-Month Plan Workbook
| Department | Women's Activewear | ||||||||||
| Spring | February | March | April | May | June | July | August | Season Total | Greyed out sections are retained as an exemplar of this document in an authentic setting, but these sections are not to be filled in for this project. | ||
| Sales $ | Sales % to total | ||||||||||
| Last Year | $685.00 | $790.00 | $650.00 | $800.00 | $950.00 | $625.00 | $4,500.00 | ||||
| Plan | |||||||||||
| % Inc/Dec | Student Note: The percentages will vary February through July based on your analysis of the case study, but will need to average to be 6.8 % in the season total. | ||||||||||
| Revised | |||||||||||
| Actual | |||||||||||
| Stock-Sales Ratio | Last Year | 6.1 | 5.8 | 6.7 | 6.3 | 5.7 | 6.9 | ||||
| Plan | 6.1 | 5.8 | 6.7 | 6.3 | 5.7 | 6.9 | |||||
| BOM Stock $ (Retail) | Last Year | $4,200.00 | $4,600.00 | $4,350.00 | $5,000.00 | $5,400.00 | $4,300.00 | $4,800.00 | $4,664.30 | ||
| Plan | |||||||||||
| Revised | |||||||||||
| Actual | |||||||||||
| Markdowns $ | Last Year | $229.00 | $288.00 | $254.00 | $348.00 | $420.00 | $375.00 | $1,914.00 | |||
| Plan | |||||||||||
| % to Sales | |||||||||||
| % by Month | Student Note: The monthly percentages may vary. It is important the average is 46.1. | ||||||||||
| Revised | |||||||||||
| Actual | |||||||||||
| Purchases $ (Retail) | Last Year | $1,478.00 | $828.00 | $1,554.00 | $1,548.00 | $270.00 | $1,500.00 | $7,178.00 | |||
| Plan | |||||||||||
| Revised | |||||||||||
| Actual | |||||||||||
| Season Total | LAST YEAR | PLAN | ACTUAL | ||||||||
| Sales | $4,500.00 | ||||||||||
| CMU % | 68.5% | ||||||||||
| Markdown % | 42.5% | ||||||||||
| Gross Margin % | 55.1% | ||||||||||
| Average Stock | 4664.3 | ||||||||||
| Turnover | 0.96 |
FinalProjectPresentationTemplate.pptx
[Presentation Title]
[Your Name]
FMM 225
[Replace all bracketed content with your own.]
1
Six-Month Spring Plan
Department: Women’s dresses
[Add an image to the right to add visual excitement to your analysis.]
Monthly Sales
Calculate the monthly percentage of sales for last year.
Calculate the total planned season sales. What will the sales be by month taking into account the Easter shift?
| Spring | February | March | April | May | June | July | August | Season Total | |
| Sales $ | Sales % to total | ||||||||
| Last Year | $685.00 | $790.00 | $650.00 | $800.00 | $950.00 | $625.00 | $4,500.00 | ||
| Plan | |||||||||
| % Inc/Dec | |||||||||
| Revised | |||||||||
| Actual |
Planned Markdown
Calculate the planned markdown dollars and percentage by month.
| Spring | February | March | April | May | June | July | August | Season Total | |
| Markdowns $ | Last Year | $229.00 | $288.00 | $254.00 | $348.00 | $420.00 | $375.00 | $1,914.00 | |
| Plan | |||||||||
| % to Sales | |||||||||
| % by Month | |||||||||
| Revised | |||||||||
| Actual |
BOM Stock Needed by Month
HINT: Keeping stock-sales ratio consistent: Multiply the new sales plan by the stock-sales ratio for each month.
Calculate the receipt dollars needed to achieve the BOM stock.
HINT: Take next month BOM + current month sales + current month markdowns - current month BOM for both “Last Year” and “Plan”.
| Spring | February | March | April | May | June | July | August | Season Total | |
| Stock-Sales Ratio | Last Year | 6.1 | 5.8 | 6.7 | 6.3 | 5.7 | 6.9 | ||
| Plan | |||||||||
| BOM Stock $ (Retail) | Last Year | $4,200.00 | $4,600.00 | $4,350.00 | $5,000.00 | $5,400.00 | $4,300.00 | $4,800.00 | $4,664.30 |
| Plan | |||||||||
| Revised | |||||||||
| Actual |
Summary and Recommendations 1
On this slide:
[Explain the rationale behind the monthly percentages calculated for the planned monthly sales.]
[Explain the rationale behind the planned mark down percentages by month.]
Summary and Recommendations
On this slide:
[Evaluate whether there is sufficient inventory at the beginning of each month to achieve your sales plan, and explain why or why not.]
Summary and Recommendations 2
On this slide:
[Explain how the buyer should address their concern regarding sales potentially slowing down. Use data and examples to support your response.]
Summary and Recommendations 3
On this slide:
[Explain how the buyer should address inventory levels with an increase in sales. Use data and examples to support your response.]
Summary and Recommendations 4
On this slide:
[Examine the potential effect of a higher markdown percentage on gross margin.]
image2.png
- Analyze the Case Study
- Manufacturing Overhead
- speech for presentation
- need back in 2 hours
- Prof. Eliud Peterson
- marketing homework
- For Kim woods
- Porter Corporation's capital structure consists of 50,000 shares of common stock. At December 31, 2014 an analysis of the accounts and discussions with company officials revealed the following information: Sales revenue $1,200,000 Earthquake loss (BEFO
- discission
- Societal Marketing
