Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[rank_math_breadcrumb]

class project

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.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Order Now

Related Questions

2-1 Discussion: Effective Communications

**** I am looking for someone to help with this class every week***** This is a new assignment   Reflect on your work experience or research recent news articles about organizational communication. Identify a situation where you think an organization or brand may have miscommunicated a message to its employees or

HUM 102 MODULE 4

SEE ATTACHMENTS Unit Resources [Insert Unit Title]8.html Introduction The resources in this module explore how the humanities influence the development of empathy. Required Resources Reading: Catching Feelings for a Triceratops: How Live Theater in Museums Evokes Empathy in Visitors This resource demonstrates how a live performance can transform an audience

IDS -104 MODULE 4

PLEASE SEE ATTACHMENTS Module Four Journal Guidelines and Rubric.html IDS 104 Module Four Journal Guidelines and Rubric Overview In both personal development and professional settings, feedback plays a crucial role in shaping how we perceive ourselves and how we grow. When used effectively, feedback can strengthen a growth mindset, which

Business Finance – Economics HOMEWORK

see attached 7 pages. The questions should be written succinctly, using the proper terminology, appropriate for a graduate level class, and showing all work for questions that call for calculation. And use reference: Brickley, J. A., Smith, C. W., & Zimmerman, J. L. (2021). Managerial economics and organizational architecture (7th

1-1 Discussion: Ethics in Communication

  In Chapter 1 of Business Communication, P. W. Cardon asks a good question that you will want to expand upon in this discussion: “Do you operate from a position of trust or credibility?” That is one of the first questions to ask yourself as you communicate. You will want

Financial

See doc below  Financial Management Budget Monitoring & Variance Analysis in Foodservice Operations In this assignment, you will develop the ability to interpret financial data, identify root causes of budget variances, and propose evidence-based, sustainable solutions. The final version of the assignment will include a variance report with analysis and

DB Walmart case study

  You have chosen a country for the Walmart case study. International Logistics Services (ILS) has acquired a new warehouse and truck fleet in your selected country and within the vicinity of one or more Walmart stores. The newly acquired warehouse has 100 employees. The new director for logistics services

Week 3 discussion operation management

Part 1 Given the following learning objective: Decision Theory and Sensitivity Analysis in Operations Research. Please power point on the attached document sent, and provide a response to the following discussion topic: Part 2 Zipline launches fastest delivery drone in the world Article Link: Read the article above by copying

ACC 5301 Unit III P

1 2 Title of the Paper Goes Here Student Name Institution ACC 5301 Management Applications of Accounting Instructor Date Title of Paper Remember this part of the paper is double spaced in APA format. The Introduction should lead readers into the topic and its importance. Introductions typically include the overall

HRM 6303 Unit IV SA

2 Training and Development HRM 6303 Unit IV SA We learned about various training delivery methods and the categories to which they belong. Which approach suits you best when retaining knowledge—cognitive or behavioral? Explain your choice. Also, how did the COVID-19 pandemic impact how training is delivered? Has it changed?

Lease Financing

  Lewis Securities Inc. has decided to acquire a new market data and quotation system for its Richmond home office. The system receives current market prices and other information from several online data services and then either displays the information on a screen or stores it for later retrieval by

international capital structure

   Describe the importance of international capital structure. What risks can you identify when working with cash, credit, and inventory management? Discuss what risks apply when discussing strategies for financing a foreign operation? Provide your rationale and any supporting data.

international capital structure

   Describe the importance of international capital structure. What risks can you identify when working with cash, credit, and inventory management? Discuss what risks apply when discussing strategies for financing a foreign operation? Provide your rationale and any supporting data.

two types of leases,

   Compare two types of leases, and describe the advantages and disadvantages of each. Which type of lease would produce the lowest risk?

Christian worldview perspective on personal debt

   Consider how a Christian worldview perspective on personal debt may conflict with how a multinational company leverages debt to finance its operations and growth. Refer to Bible Resources and support your position using specific Bible references.

multinational company

   If you were the CFO of a multinational company, what steps could you take to minimize international risk? Describe how cash flows are used to minimize political risk.

Week 5 discussion

   Externalities happen when the costs or benefits of an action spill over to people who aren’t directly involved in it. Sometimes these side effects are positive (like a well-kept garden that boosts neighborhood property values), and sometimes they’re negative (like noise from a factory disturbing nearby residents).