Our Services

Get 15% Discount on your First Order

working on a final project Overview The final project for this course is the creation of a six-month merchandise plan for the women’s dresses

August 14, 2024

working on a final project

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.

>Business & Finance homework help

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Week 3: Order ID 581251 Instructions: The Test Plan for each project includes the Pseudocode, Flowchart, Goals and Objectives, Functional Requirements, and

Week 3: Order ID 581251 Instructions: The Test Plan for each project includes the Pseudocode, Flowchart, Goals and Objectives, Functional Requirements, and Test Matrix including Actual Output column. Below the table are screenshots verifying the actual output for each case. How is your first Test Plan going? You’ll be creating

Video Assessment Watch one of the following movies/plays in its entirety: Just Mercy, 12 Angry Men (play can be found on YouTube), Remember the Titans, or

Video Assessment Watch one of the following movies/plays in its entirety: Just Mercy, 12 Angry Men (play can be found on YouTube), Remember the Titans, or Legally Blond. Choose THREE topics and write a 2-page analysis on how these topics are applicable to the movie. Not every topic will be

Exhibit 13.I: Sample Marketing Campaign Plans Example 1 Example 2 Name, type of program, date, and number of people expected to attend Preparing and

Exhibit 13.I: Sample Marketing Campaign Plans Example 1 Example 2 Name, type of program, date, and number of people expected to attend Preparing and Implementing Transfer of Learning Plans A one-day invitation only workshop for selected members of state-level health care professional associations and organizations November 1 40 participants Conducting

Questions At a high level, please explain how psychologists conduct research from beginning to end. A good response would include where researchers get ideas

Questions At a high level, please explain how psychologists conduct research from beginning to end. A good response would include where researchers get ideas from, the characteristics of “good science

Ship Shape Case study, instructions attached ● Answer all parts of questions 2 and 4 from Case 15.3: Ship Shape. ● Your response should be at

Ship Shape Case study, instructions attached ● Answer all parts of questions 2 and 4 from Case 15.3: Ship Shape. ● Your response should be at least 500 words. ● Your response should cite each of the following references at least once. ● 2. The chapter outlines three different approaches

Discussion 5: Elaborate on Your Impressions of La Tomatina Festival Must post first. Subscribe Discussion Board Guidelines

Discussion 5: Elaborate on Your Impressions of La Tomatina Festival Must post first. Subscribe Discussion Board Guidelines Participate in the discussion by responding to the prompt below in an initial post, then by responding to the posts of your classmates. Your initial response post is due by Thursday at

1- Why do we use market weights instead of book-value-based weights when computing WACC? 2- Would you ever adjust the cost of capital when analyzing a

1- Why do we use market weights instead of book-value-based weights when computing WACC? 2- Would you ever adjust the cost of capital when analyzing a project? Why or why not?

Imagine you have been asked by your school principal, along with your colleagues, to prepare a summary statement that represents your educational

Imagine you have been asked by your school principal, along with your colleagues, to prepare a summary statement that represents your educational philosophy which you will share at the next in-service. Create a 325-word summary of your educational philosophy. Include the following in your summary: · 3 key elements of your educational philosophy

1. The current context in the economic influence on how adults in their middle life make the choices that they transition into their second half of

1. The current context in the economic influence on how adults in their middle life make the choices that they transition into their second half of their lives. The economic factors in such as the income level as well as job stability can all play as a pivital role for

exclude Mexico, Chinese (Hmong), Ghana (Ashanti tribe ),Tibetan death, CT State Community College Gateway Nur 125 Spring 2024 Written

exclude Mexico, Chinese (Hmong), Ghana (Ashanti tribe ),Tibetan death, CT State Community College Gateway Nur 125 Spring 2024 Written Assignment Cultural Impact on Nursing Care Objectives: At the assignment’s completion, the student will: 1. Demonstrate understanding of how major life transitions are impacted by a client’s culture 2. Identify ways

Create a 10min Powerpoint presentation for the Business Consultancy Project with speech notes under each slide. This file is too large to

Create a 10min Powerpoint presentation for the Business Consultancy Project with speech notes under each slide. This file is too large to display.View in new window

Watch the video about MD Anderson’s Oncology Expert Advisor at www.youtube.com/watch?v=CtyYI7ou2B0. What are the benefits of such an expert system to

Watch the video about MD Anderson’s Oncology Expert Advisor at www.youtube.com/watch?v=CtyYI7ou2B0. What are the benefits of such an expert system to oncology doctors? Are there anydisadvantages? What benefits of expert systems are highlighted in this example? GUIDELINES: On the title page, clearly state the Title of the organization mentioned in

You are the athletic director at a college or university (you choose the institution) and have been told by the president that he is thinking of dropping

You are the athletic director at a college or university (you choose the institution) and have been told by the president that he is thinking of dropping the softball team. The team has been finishing below .500 for the past five years, and the president doesn’t see the value of

I really want someone to explain me that I’m going to start a business that is about real estate so, I want your advice should I hire [url= estate

I really want someone to explain me that I’m going to start a business that is about real estate so, I want your advice should I hire [url= estate business plan writer[/url] in UK or just start the business anyway?

Chapter 1-Discussion 1: Chapter 2-Discussion 2: Outsmarting the Liars (see attached) This should be no longer than two paragraphs per discussion and

Chapter 1-Discussion 1: Chapter 2-Discussion 2: Outsmarting the Liars (see attached) This should be no longer than two paragraphs per discussion and should show your understanding of the week’s readings. Assignment has to demonstrate a meaningful synthesis of the material posted (typically a research article) and the corresponding chapter assigned

topic: health psychology link: https://bpspsychub.onlinelibrary.wiley.com/doi/pdfdirect/10.1111/bjhp.12669 the reviews/summary should be limited to a

topic: health psychology link: the reviews/summary should be limited to a maximum of 1.5 pages. Use only this link(no other link) to complete the review/summary. Make sure to add the source at the end.