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

Unit 3 spreadsheet

  Purpose The goal of the Excel template assignments weeks 1-4 is to build a working Excel spreadsheet model with built-in formulas and circular references using provided Excel template for Walmart company for 2010-2017, following detailed instructions in the textbook. The chapters of the textbook present a comprehensive guide on

HRM 6304 Unit III PP

2 Labor Relations and Collective Bargaining HRM 6304 Unit III PowerPoint Presentation Create a PowerPoint presentation that outlines the advantages and disadvantages of union representation, mandatory benefits in a bargaining package, how market factors may drive the bargaining process, and how these factors increase or decrease employee motivation or morale.

ITC 5301 Unit IIDB

2 Management Information Systems ITC 5301 Unit II Discussion Board Your initial post should be at least 300 words in length. Your initial post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or quoted material. There has been

4-1 Journal: Criminal Responsibility

Need help Module Four Journal Guidelines and Rubric.html BUS 206 Module Four Journal Guidelines and Rubric Overview Approach this journal assignment as an opportunity to reflect upon and apply what you learned from the assigned readings, discussions, and activities. It is also an opportunity to share your knowledge and expertise

business

Part A paper You will write a paper no less than 300 words, double-spaced, academic style, in APA format (in-text citations, references, correct grammar and spacing, etc.).  In Chapter 5, Locker (2025) discusses power distance. You will write a paper no less than 300 words, double-spaced, academic style, in APA

BUSINESS( NO PLAGARISM A+ WORK, ON TIME)

Tutor Discussion  1 Week 4 Discussion ( No more than 300 words) Pregnancy Discrimination Part of the Title VII of the Civil Rights Act is the Pregnancy Discrimination Act (PDA). The focus of a PDA claim is whether an employer’s policy treats pregnant workers less favorably than it treats non-pregnant

YL A2

Please use template provided  Assignment 2 Description and Deliverable After our last assignment, we discussed modern payment flow in the US, new opportunities in payments, risks in payment systems, as well as blockchain and payments. In this assignment, you will be asked to review and revisit some of the concepts

Feedbet Login: A Smarter Way to Access Digital Platforms

Feedbet Login is a streamlined authentication approach designed to improve how users enter and  interact with digital platforms. It focuses on simplicity, security, and user experience, ensuring that  access feels smooth rather than complicated. 

Business Finance – Management Week 10 Assignment- Managerial Finance

Module 3 Assignment: Capital Budget Decision Making for an Organization Report prepared by: Replace this text with your name. Date: Replace this text with the submission date. Walden University MBAX 6070: Managerial Finance 1 Executive Summary Replace this text with your executive summary. Part 1: Short-Term Working Capital Considerations Replace

Business Finance – Management homework

see attacked David, F. R., David, F. R. & David, M.E. (2023). Strategic management: a competitive advantage approach, concepts and cases (18th ed.). Upper Saddle River: Pearson. HOMEWORK 1. 8 pages, Company is the Cardinal Health Phase 1 includes your revisions on the tasks you completed in Modules 1 and

Total Quality Management

BUSI 616 Contrasting Quality Philosophies Assignment Instructions You will review the assigned readings and choose two of the quality theorists to compare and contrast their concepts and discuss each of the quality philosophies to business competitiveness as well as the application of biblical integration. The final submission should be approximately

HRM 6304 DB1R2

2 Labor Relations and Collective Bargaining HRM 6304 Unit I Discussion Board Reply 2 Posts to others should be a minimum of 250 words. You should also include at least two references. Reply to the below Top of Form Hello! Introduction My name is Meghan, and I have been a

ITC 5301 DB1R2

2 Management Information Systems ITC 5301 Unit I Discussion Board reply 2 Posts to others should be a minimum of 250 words. You should also include at least two references. Reply to the below Top of Form Good evening, or morning depending on where you are living and reading this! My

Quarantine

Please respond to the following. Remember to use a respectful tone and language appropriate for a learning environment in your post and replies when discussing this potentially controversial topic: In the event of a viral outbreak in a U.S. state, such as the COVID-19 pandemic, do you think it would

Digital Business

You will develop a forward-looking strategic plan that addresses key threats, challenges, and opportunities identified in Part I.