Find different strategies for determining markdowns in various industries in the U.S. Based on resources, research, and the case study & spreadsheet, answer the following
Find different strategies for determining markdowns in various industries in the U.S.
Based on resources, research, and the case study & spreadsheet, answer the following questions (be sure to show your calculations for questions a. through d. to support your answers):
Jimmy Expects to sell 40% of the units to be Jimmy expects to sell 45% of the Pertinent Information and Sales Results at Full Price marked down at the 30% markdown rate hand at the 50% markdown Unit Sales Dollar Initial Unit Units to be Dollar Dollar Initial Buy | Initial Buy at Full Buy Sales at Marked Unit Sales Sales at Markdown| Balance on | Unit Sales Sales at SKU Cost Retail Margin % at Cost at Retail Price Full Price Sell-Thru % Down at 30% Off 30% Off Dollars Hand at 50% Off 50% Off 2-pk 75W CFL $15.95 $41.00 51.1% 1000 $15,950 $41,000 750 $30,750 75.0% 250 100 $2,870 $1,230 150 68 $1,394 2-pk Dimmable 1200 75W CFL $29.33 $88.00 66.7% $35,196 $105,600 360 $31,680 30.0% 840 336 $20,698 $8,870 504 227 $9,988 2-pk Dimmable 60W CFL $25.34 $90.00 1200 71.8% $30,408 $108,000 502 $45,180 41.8% 698 279 $17,577 $7,533 419 189 $8,505 Dimmable 100W CFL $23.55 500 $71.00 66.8% $11,775 $35,500 343 $24,353 68.6% 157 53 $3,131 $1,342 94 42 $1,491 2-pk 100W CFL $16.93 $57.00 70.3% 750 $12,698 $42,750 482 $27,474 64.3% 268 107 $4,269 $1,830 161 72 $2,052 2-pk 60W CFL $12.69 $48.00 73.6% 750 $9,518 $36,000 315 $15,120 42.0% 435 174 $5,846 $2,506 261 117 $2,808 5,400 $115,544 $368,850 2,752 $174,557 51.0% 2,648 1,059 $54,391 $23,311 1,589 715 $26,238Jimmy expects to sell all of the alance on remaining balance on hand at the ate 70% markdown rate Dollar Markdown Balance on Sales at Markdown Dollars Hand 70% Off Dollars $1,394 82 $1,009 $2,353 $9,988 277 $7,313 $17,063 $8,505 230 $6,210 $14,490 $1,491 52 $1,108 $2,584 $2,052 89 $1,522 $3,551 $2,808 144 $2,074 $4,838 $26,238 874 $19,235 $44,881Jimmy is a new buyer at a Supply Company, which serves multiple large hardware chains in the Midwmt. Jimmy's buyer category is Lighting, specifically Compact Fluorescent lightbulbs. Each year, Dennigee's Supply holds two promotional events: one \"summer sale\" and one \"winter sale". During each of these events, selected products are marked down for three weeks. Generally, buyers at Dennigee's Supply Company use the strategy of permanent price reductions (markdowns) to determine the promotional prices for the products on sale during these events. For the upcoming "summer sale", Jimmy has six compact uorescent lighting (CPL) products that will be included. Jimmy knows that thse products have the ability to generate good gross margins. The demand for these products allows Jimmy to purchase in larger quantities, which means he is able to take advantage of quantity discounts to get the products at a lower cost. Howeverr buyers at Dennigee's Supply Company are discouraged from buying products in large quantities if they anticipate that the products will have to be marked down at a later date. Jimmy's goals for the upcoming promotional event are, for the most part, the same goals that any other buyer would have in a similar situation. He needs to: - Niax imize sales while minimizing price reductions (rnarkdowns), and I- Get 100% sellrthrough by the end of the promotional period :- Additionally, Jimmy's manager has tasked him to achieve a 60% maintained margin on the promotional products. After analyzing several price reduction and markdown strategies, Jimmy decides to stick with the permanent price reduction markdown strategy to achieve his goals. He decides to mark the six products down by: n 30% after one week I by 50% after two weeks n and by 70% after 1? days, which is where the pricing will remain for the remaining 4 days of the promotional event. When preparing this plan, Jimmy also assumes that all of the products he promotes will be sold by the end of the event. The spreadsheet included with this case study contains some of Jimmy's calculations regarding fullprice sales and what he expects sales to be at the 30 '96, 50%, and F095 markdown levels, using the permanent price reduction markdown strategy. You will need to complete the spreadsheet and analyze the data to answer the Case Study questions
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