Based on your analysis, you will create your own assortment plan in Excel using the data below to determine how many units and retail dollars you plan to purchase this year in each classification and by item in order to achieve the target department markup and to spend the allotted budget for retail purchases.

For this project, imagine you are a new buyer for the Missy Contemporary Knits & Sweaters department at a specialty retailer. The Contemporary Knits & Sweaters department is made up of two classifications: sweaters and knit tops.
As you prepare to buy your assortment for this season, you will first analyze your selling history from last year to determine the comparable styles and colors you will buy this year for the same time period.
You will need to include the size and color breakdown (in units) for each item.
Please note that your assortment plan is unique. There is no one solution to this plan. You will be graded according to your analysis, your attention to detail, your presentation, your rationale and your justification with your buy.
For the purpose of this exercise, assume that sales in Contemporary Knits & Sweaters are planned flat to last year . Based on the sales history, you will decide which styles and colors you will buy in each classification, and determine the retail price and quantity, as well as the color and size breakdown for each style. Be sure to include your unit breakouts by color and by size for each style on your assortment plan.
Also, ensure that your total buy does not go over the total planned retail purchase amount and achieves the overall markup goal (you will be penalized for missing the total department markup or being overbought). Be sure to include formulas that calculate your total buy (including the total retail dollar amounts and markup) as well as subtotals for each item.
After you create your assortment plan, use your plan in order to answer the questions below. Be sure to submit both your assortment plan and answers to all questions in order to complete the assignment.

Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]