Question: Hi, need help calculating markdowns and such. Please refer to the tables highlighted in yellow to help answer the blank spaces in the other tables.
Hi, need help calculating markdowns and such. Please refer to the tables highlighted in yellow to help answer the blank spaces in the other tables.


Table 1 Style # Description Units Unit Cost Unit Retail Markup % 2000 Sleeveless 300 $8.00 $12.00 33% 3000 Short sleeve 400 $8.00 $15.00 46% 4000 Long sleeve 300 $8.00 $18.00 55% Total 1000 45% 1) Find the initial markup percentage on each style and markup % on the total order. Enter the results in Table 1. Round to nearest tenth percent. After the shirts have been on the selling oor for 3 weeks, Sue reviewed partial inventory and selling data on the group: Table 2. _____E- 193 OH = on hand at the beginning of the week; Sold = units sold for the week 2) Compute the missing 0H and Sold information in the table above, including total OH and Sold. Enter the information in Table 2. 3) Compute the Weeks of supply (W OS) and Sell through (ST%) for each style for each of the three weeks. Enter the results in Table 3. Round percentages to the nearest tenth percent. Round WOS to the nearest tenth. --l At the beginning of Week 4, Sue runs a 25% off promotion on all three styles of the shirts for a one week special. Unit sales for the week are as follows: Table 4 Units sold at 25% Markdown dollars Total Markdown off dollars 2000 3000 4000 _ 4) What were the markdown dollars for this promotion? Enter the dollar amount for each style and the total markdown dollars for the day in Table 4. Round dollar amounts to the nearest penny. At the beginning of Week 5, a permanent markdown is taken on the remaining shirts, as follows: Table 5 5) How many shirts were marked down? What were markdown dollars on the shirts for Week 5? Compute and enter the data in Table 5. Round dollar amounts to the nearest penny. 6) At the end of Week 7, all of the shirts were sold. Calculate the following on this shirt purchase and enter the data in Table 6. Round dollar amount to nearest penny. Round percentages to nearest tenth percent. Table 6 Final net sales generated by the shirt purchase '5 6876.54 Total markdown dollars taken $ 1152.21 WW\" Final Markup percentage on the purchase Hint: usena! net sales in the markup equation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
