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

HRM 6303 VIII

2 Training and Development HRM 6303 Unit VIII Reflection Paper Consider that you want to report to the executive team on how this course could help shape training and development program for leadership and career planning. Be sure to consider major training-related theories. Reflect on the course and thoroughly explain

ACC 5301 VII

1 5 Title of the Paper Goes Here Student Name Institution ACC 5301 Management Applications of Accounting Instructor Date Abstract The abstract is an overview of the paper, written after completion. Other researchers use the abstract to determine if your work will be useful to them. The abstract should include

Prof Double R

DISCUSSION 1 In a conversation with a family member, you are told: “Bad people do bad things. Some people are just bad eggs.” For this discussion, you will incorporate what you have learned about antisocial behavior and its implications for promoting diversity, equity, and inclusion. For your initial post, review

Case Study

answering the case by applying all the digital transformation tools  Chapter 1: The Five Domains of Digital Transformation: Customers, Competition, Data, Innovation, Value This chapter introduces the five domains of digital transformation: customers, competition, data, innovation, and value. It explains how digital technologies are changing strategic assumptions in each domain,

Group project

Background UNLO Kuwait Group Company is currently exploring new business opportunities by identifying and targeting untapped market segments. As part of this initiative, students will engage in a strategic consulting assignment focused on discovering feasible and sustainable market expansion options for the company. Student teams will work on real-world business

Business Finance – Management 2-2 Assignment: Communications Plan Template

  MGT 550 Module Two Assignment Guidelines and Rubric Overview Using the Communications Template, linked in the What to Submit section, identify two overall issues that are present in the final project case study that can be addressed using internal and external communications. For each issue, note the red flags

Calculate the economic value added assuming its cost of capital

At the end of 2011 Home Depot’s total capitalization amounted to $29,031 million. In 2012 debt investors received interest income of $648 million. Net income to shareholders was $4,487 million. (Assume a tax rate of 35%.) Calculate the economic value added assuming its cost of capital is 10%. (Do not

Econ 13

Instructions attached Please answer the following questions 1. Please research ‘forced arbitration” and tell us what you find out about it. What is it and do you think it is a good or a bad thing? Explain. To what extent is forced arbitration legal in California and federally. 2. How

leasing

   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

HRM 6303 VII SA

2 Training and Development HRM 6303 Unit VII SA For this assignment, you will write a report that details the components of an executive leadership development program for a fictitious company. The fictitious company can be within an organization and industry of your choice. Do not use the name of

ACC 5301 VI

2 Management Applications of Accounting ACC 5301 Unit VI Assignment This assignment measures your mastery of ULOs 2.5, 4.1, 5.2, and 6.1. You have been hired at ABC Manufacturing, and you have been asked to work on the budget for the upcoming year regarding labor costs and the number of

Lead 4

Week 4: The KPI Dashboard The KPI Dashboard Review the following video. Transcript attached Instructions After reviewing the Week 4 Reading and Supplemental Materials, create a 2-page Microsoft Word Memo and infographic (instead of a traditional dashboard) for an organization you have been or still are affiliated with.  You do not have

MIS -4

Week 4: Project Paper #2: Jobs to be Done and Value Proposition Hypothesis Introduction You will use the Jobs to Be Done (JTBD) framework to reframe the problem from the customer’s perspective, then define the key value your product or service must deliver to solve it. This is your opportunity

Response

see attached  Informative Presentation Assessment After the final presentations are complete, write a brief (250-word minimum) reflection essay on how things went for you that includes the following: 1. Describe your own process as you prepared to give your presentation. How did you settle on the topic that you chose?

Firm

   Paul Duncan, financial manager of EduSoft Inc., is facing a dilemma. The firm was founded 5 years ago to provide educational software for the rapidly expanding primary and secondary school markets. Although EduSoft has done well, the firm’s founder believes an industry shakeout is imminent. To survive, EduSoft must

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