Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help as much as you can! Imagine that Kelly Daniels, the owner of Kay Day's Boutique, has asked you to give her some merchandising
please help as much as you can!
Imagine that Kelly Daniels, the owner of Kay Day's Boutique, has asked you to give her some merchandising advice. Kay Day's is a boutique that sells clothing and accessories for young women. Kelly feels that she has a good understanding of the accessory part of her business. However, she thinks that she needs some help with the clothing part of her business. Knowing that you are an expert on apparel merchandising, she approaches you for some friendly advice. Kelly agrees to provide you with the following information about the clothing part of her business: Last Year's Sales by Month were as follows: February $140,000 The Percent of Sales by Month for TY are as follows: February 15% March - 19\% April 21% May - 18\% June - 15\% July 12% The Stock-to-Sales ratio for each month last year was as follows (Kelly will continue to use these ratios for this year's plan): February - 2.1 March - 2.5 April - 3.0 May - 2.5 June 2.1 July - 1.8 Here are the percentage markdowns by month for LY (please note LY's season MD\% is 20% of LY's season total sales): February 12% March 12.5% April - 14.5\% May - 18\% June - 20\% July 23% Kelly will use LY's monthly markdown percent to sales for this year's plan. Kelly would like to have a 5% increase in sales for this year as compared to last year. She believes, that with your help, she can achieve her goal. She is planning to have an EOM on July 31 of $300,000. To help Kelly, you must create a six-month merchandise plan with the figures she has given to you. You can use the Excel template provided (which is based on the one you created for Part 1). You have all of the figures you need to create the six-month merchandise plan. You can leave the Revised and Actual cells blank. All of the other cells can be filled in using the figures given and the formulas in Excel Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started