I'm stumped-Please help. I've already posted once and did not get a clear explanation on the calculations. Thank you!!!

For this Case Study, wed like to introduce you to Jimmy. Jimmy is a new buyer at a Supply Company, which serves multiple large hardware chains in the Midwest. Jimmys buyer category is Lighting, specifically Compact Fluorescent lightbulbs. Each year, Dennigees 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 Dennigees 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 fluorescent lighting (CFL) products that will be included. Jimmy knows that these 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. However, buyers at Dennigees 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. Jimmys 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: Maximize sales while minimizing price reductions (markdowns), and Get 100% sell-through by the end of the promotional period Additionally, Jimmys 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: 30% after one week by 50% after two weeks and by 70% after 17 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 Jimmys calculations regarding full-price sales and what he expects sales to be at the 30%, 50%, and 70% 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.

Research different strategies for determining markdowns in various industries in the U.S. Based on course 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): 1. What are the total projected sales for the upcoming promotional event? 2. What are the total projected price reduction (markdown) dollars for the event? 3. What is the price reduction (markdown) percentage for the event? 4. What is the margin percentage for all of the items being sold during the event? Identify another price reduction (markdown) strategy Jimmy could have used, and explain how its use could influence the results in the case study. Choose a retail product or product category that you believe has particular appeal to retail customer groups. Recommend one price reduction (markdown) strategy and explain how it would appeal to those customers and drive the product's or product category's performance.

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{10}{|c|}{ Pertinent Information and Sales Results at Full Price } & \multicolumn{4}{|c|}{\begin{tabular}{l} Jimmy Expects to sell 40% of the units to be \\ marked down at the 30% markdown rate \end{tabular}} & \multicolumn{4}{|c|}{\begin{tabular}{l} Jimmy expects to sell 45% of the balance on \\ hand at the 50% markdown rate \end{tabular}} & \multicolumn{3}{|c|}{\begin{tabular}{l} Jimmy expects to sell all of the \\ remaining balance on hand at the \\ 70% markdown rate \end{tabular}} \\ \hline SKU & Cost & Retail & Margin \% & \begin{tabular}{c} Initial Unit \\ Buy \end{tabular} & \begin{tabular}{c} Initial Buy \\ at cost \end{tabular} & \begin{tabular}{c} Initial Buy \\ at Retail \end{tabular} & \begin{tabular}{c} Unit Sales \\ at Full \\ Price \end{tabular} & \begin{tabular}{|c|} Dollar \\ Sales at \\ Full Price \end{tabular} & Sell-Thru \% & \begin{tabular}{|c|} Units to be \\ Marked \\ Down \end{tabular} & \begin{tabular}{l} Unit Sales \\ at 30\% off \end{tabular} & \begin{tabular}{|l|l|} Dollar \\ Sales at \\ 30% off \end{tabular} & \begin{tabular}{c} Markdown \\ Dollars \end{tabular} & \begin{tabular}{c} Balance on \\ Hand \end{tabular} & \begin{tabular}{c} Unit Sales \\ at 50\% off \end{tabular} & \begin{tabular}{l} Dollar \\ Sales at \\ 50% off \end{tabular} & \begin{tabular}{c} Markdown \\ Dollars \end{tabular} & \begin{tabular}{c} Balance on \\ Hand \end{tabular} & \begin{tabular}{l} Dollar \\ Sales at \\ 70% Off \end{tabular} & \begin{tabular}{c} Markdown \\ Dollars \end{tabular} \\ \hline 2-pk 75W CFL & $15.95 & $41.00 & 61.1% & 1000 & $15,950 & $41,000 & 750 & $30,750 & 75.0% & 250 & 100 & $2,870 & $1,230 & 150 & 68 & $1,394 & $1,394 & 82 & $1,009 & $2,353 \\ \hline \begin{tabular}{|c|} 2-pk Dimmable \\ 75W CFL \end{tabular} & $29.33 & $88.00 & 66.7% & 1200 & $35,196 & $105,600 & 360 & $31,680 & 30.0% & 840 & 336 & $20,698 & $8,870 & 504 & 227 & $9,988 & $9,988 & 277 & $7,313 & $17,063 \\ \hline \begin{tabular}{|c|} \begin{tabular}{c} 2pk \\ 6immable \\ 60W CFL \end{tabular} \\ \end{tabular} & $25.34 & $90.00 & 71.8% & 1200 & $30,408 & $108,000 & 502 & $45,180 & 41.8% & 698 & 279 & $17,577 & $7,533 & 419 & 189 & $8,505 & $8,505 & 230 & $6,210 & $14,490 \\ \hline \begin{tabular}{|c|} Dimmable 100W \\ CFL \end{tabular} & $23.55 & $71.00 & 66.8% & 500 & $11,775 & $35,500 & 343 & $24,353 & 68.6% & 157 & 63 & $3,131 & $1,342 & 94 & 42 & $1,491 & $1,491 & 52 & $1,108 & $2,584 \\ \hline \begin{tabular}{|c|} 2-pk 100W CFL \\ \end{tabular} & $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,052 & 89 & $1,522 & $3,551 \\ \hline 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 & $2,808 & 144 & $2,074 & $4,838 \\ \hline & & & & 5,400 & $115,544 & \begin{tabular}{|l|} $368,850 \\ \end{tabular} & 2,752 & \begin{tabular}{|l|} $174,557 \\ \end{tabular} & 51.0% & 2,648 & 1,059 & $54,391 & $23,311 & 1,589 & 715 & $26,238 & $26,238 & 874 & $19,235 & $44,881 \\ \hline \end{tabular} Total Projected Sales Mark Dollars Average Margin \%