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

Excel spreadsheet

Need this project completed Sheet1 Key Check Figures Schedules Schedule B July August September Sched E15 Total collections $2,274,993 $2,572,479 $2,858,704 $929,200 Schedule D COGS $1,692,384 $1,909,842 $2,156,968 Schedule E Total Payments $2,076,010 $1,985,264 $2,177,350 Projected Income statements Net Income before Taxes $125,877 $161,323 $203,086 Projected Balance Seet September Accounts

Business

PSYC 320 Behavior Modification Project: Treatment Phase Report Assignment Instructions Overview The treatment phase is like the baseline phase with the exception of the treatment being added to determine if there is a change in the data. Treat your target behavior, using the treatment method(s) that you have researched in

HUM 102 Module Five Project Draft

SEE ATTACHMENT Module Five Project Draft Guidelines and Rubric.html HUM 102 Module Five Project Draft Guidelines and Rubric Overview At this stage, you have learned how creative works are components of the humanities, how diverse perspectives add value to works, how bias and assumptions can influence how you view creative

int 6

topic:   World Financial Markets and Institutions BUSI 606 Discussion Assignment Instructions The Discussions allow you the opportunity to apply what you have learned from the Module: Week’s readings. There are 2 parts to each Discussion: thread and replies. Both parts must be posted and written in a substantive manner,

CASE STUDY 20 nov

Follow all instruction. Work will be checked no plagarism. strategic management case study based on Case 12: Electronic Arts (EA) from the Thompson, A. (2024). Crafting & Executing Strategy: Concepts and Readings for Competitive Advantage (Custom 24th ed.) McGraw-Hill. textbook.

Your Trusted Source for BMW Replacement Parts

 Whether you need headlights, interior trims, steering wheels, or electrical modules, MT Auto Parts delivers genuine BMW components at competitive prices. Our dismantled parts come from 2012+ models and undergo strict quality checks. Reliable solutions for every BMW owner.  

Case Study

See attachment  BUSI 690 Case Study: Matrices Assignment Instructions Overview Complete a case study of ABC Corporation (your instructor will assign the specific company for the case study at the beginning of Module 2: Week 2) . You will find the case in the case section of the text. A

theory question

theory question accounting RS-14 Resilience Scale The RS-14 (Resilience Scale – 14 items) is a widely used tool to measure individual resilience. Participants rate how well each statement applies to them on a 7-point Likert scale: 1 = Strongly Disagree to 7 = Strongly Agree. No Resilience Statement Score (from

D4

Course Project: Request for Proposal (RFP) Instructions This week, you are required to produce your project Request for Proposal (RFP) deliverable. The RFP is a formal invitation issued by the University of Prosperity requesting interested PPM vendors to submit written proposals meeting a set of requirements. If interested in bidding

Business Finance – Accounting homework

see attached 2 Use this reference for below questions. Brickley, J.A., Smith, C.W., & Zimmerman, J.L. (2021). Managerial economics and organizational architecture (7th ed.). New York: McGraw Hill/Irwin. #1. 1 page with 2 references. Should decision management and decision control be separated? As part of your discussion, provide a real-world

Ch 10

Read Chapter 10 and answer the questions below. 1. What is Frederick Taylor known for? 2. What led to the more human-based managerial styles? 3. What did Abraham Maslow find human motivation to be based on? 4. What levels of need did Maslow identify? 5. Can mangers use Maslow’s theory?

ch 10 & 11

Read Chapter 10 and answer the questions below. 1. What is Frederick Taylor known for? 2. What led to the more human-based managerial styles? 3. What did Abraham Maslow find human motivation to be based on? 4. What levels of need did Maslow identify? 5. Can mangers use Maslow’s theory?

week 4 discussion operation management

 2. Using the exact Sample Article Review format on file attatched , write a review on 3 articles relating to your final research topic. Use the Library database or http://scholar.google.com to find the 3 peer reviewed journal articles relating to your final research topic. 

Business

BUSI 301 Discussion Assignment Instructions Overview Discussions bring dialogue and communication into our learning experience. Unlike so much of the unsubstantiated opinion we see in the public square and social media, these discussions provide a space for in-depth analysis and application of the topics in our Learn readings and presentations.

Financial worksheet

See doc below Applying CQI Principles in Foodservice Management In this assignment, you will evaluate real-world foodservice operations through the lens of Continuous Quality Improvement (CQI), applying models like PDCA and FOCUS, while developing systems-thinking, problem-solving, and leadership skills aligned with RD exam content. The final version of the assignment