Our Services

Get 15% Discount on your First Order

[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

Related Questions

BUSINESS (NO PLAGARISM A+ WORK, ON TIME)

tutor discussion and response CHAPTER 7 Risk Analysis, Real Options, and Capital Budgeting Page 205 Even in the best of times, movies often bomb at the box office. In May 2023, the movie Hypnotic, starring Ben Affleck and Alice Braga, hit theaters with the slogan, “Control is an illusion.” But

Business Finance – Management 3-3 Assignment: Stakeholder Roles and Responsibilities

SEE ATTACHMENT  Module Three Assignment Guidelines and Rubric.html QSO 321 Module Three Assignment Guidelines and Rubric Overview Knowing the expectations involved with maintaining operational sustainability and who is responsible for meeting these expectations is an important part of being an effective practitioner. In this assignment, you will create a guide

Business Finance – Management ACC 202 Module Three Assignment

SEE ATTACHMENT Module Three Assignment Guidelines and Rubric.html ACC 202 Module Three Assignment Guidelines and Rubric Overview Companies choose their costing method based on their business activities and processes, as well as the products and services they offer. A company can be a manufacturing, merchandising, or service organization; this also

Demonstrate Your Key Performance Indicator (KPI) Knowledge. Length: 10-12 slides, including audio for each slide (SEE INSTRUCTIONS). References: Include a minimum of 5 scholarly references.

Assignment 6: Demonstrate Your Key Performance Indicator (KPI) Knowledge Instructions Although there are many key performance indicators, a goal from the lesson is to focus on a few strategies to drive success for your new product. For this assignment, you will identify KPIs for pricing, promotions, and overall success. An important role for marketing managers

Business Case Study

Help with homework. BUS 330 – Final Case Study In the second half of our class, we have been focusing on some key economic forces/variables (e.g., interest rate, exchange rate, price fluctuations, unemployment, trade policies, etc.) that affect organizations in different manners. A primary objective in this class is to

6-1 Final Project Milestone Three: Financial Analysis Listen

 n Milestone Three, you will submit a financial analysis of the sport organization and selected market. You will first provide a financial overview of the organization, including the most up-to-date balance sheet. Then you will estimate capital requirements for the project and predict whether expansion would or would not be

Deliverable 6 – Chronic Diseases and Population Health Management

  Scenario The key to an effective and sustainable population health management program is to understand your chronic disease patients and coach them towards a healthy lifestyle. The success of population health and chronic disease management efforts hinges on a few key elements: Identifying those at risk and the health

Deliverable 5 – Population Health Management Patterns

  Scenario Effective population health management (PHM) requires strategies to reach the individual consumer or patient at all stages of life in the manner most appropriate for each individual. PHM must use a set of patterns of population health strategies that describe people and their preferences. These pattern classifications help

How to Upgrade to QuickBooks Desktop 2026

How do I upgrade to QuickBooks Desktop 2026 from an older version? What are the steps to install QuickBooks Desktop 2026? Can I upgrade QuickBooks Desktop without losing my company data? Do I need to uninstall my old QuickBooks version before upgrading?  

BUSINESS (NO PLAGARISM A+ WORK, ON TIME)

Tutor Discussion 2 MOA ( Respond no more than 150 words) My Career Development Plan follows the SMART goal framework discussed in this week’s lesson by ensuring each objective is specific, measurable, achievable, relevant, and time bound. In the short term, completing my MBA will strengthen my leadership, strategic planning,

Why Are IP Risk Assessment Reports Important for Protecting Business Innovations?

  In today’s innovation-driven business world, intellectual property (IP) plays a major role in building a company’s competitive advantage. Whether it is patents, trademarks, copyrights, or proprietary processes, these assets help businesses protect their ideas and maintain market leadership. However, many organizations overlook the risks associated with intellectual property management.

Financial statements

 How do you plan to use financial statements in your projected financial statement analysis? Include a rationale for your approach and identify what insights each type of statement provides. 

First-year financial performance

   Why is it important to project the first-year financial performance on a monthly basis and the subsequent yearly budgets on a quarterly basis? Explain your responses with cited support.

Total Quality Management 8

 One issue at the Cook County Courthouse that could benefit from quality improvement is invoice processing and how long it takes vendors to get paid. Cook County uses Net 60 payment terms, while many private companies operate under Net 30. Even with the longer payment terms, vendors still agree to

Logistics 8

see attached  BUSI 615 Integrated Learning Project Assignment Instructions Overview The integrated learning assignment is a series of 6 assignments and a final course consolidated submission. All assignments and the compilation of the final consolidated submission is managed as an individual assignment. Purpose The purpose of the ILP is for