Answered step by step
Verified Expert Solution
Link Copied!

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!
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance An Integrated Approach

Authors: Bernard J. Winger

4th Edition

0198520972, 9780132696302

More Books

Students also viewed these Finance questions

Question

=+d) Which mutual fund would you invest in and why?

Answered: 1 week ago

Question

In what ways are you similar to your closest friends?

Answered: 1 week ago