Sell-Through and Markdown Planner.

Build a sell-through and markdown planner for the buyer at Meridian Thread Co., a womenswear boutique working through its 40 piece spring assortment in week 8 of a 14 week season. Layout. Top strip: four stats plus a small donut. Stats: Season sell-through (58 percent), SKUs flagged for markdown (9 of 40), Units at risk (about 1,240), Leftover value at current pace (about $71,000 at ticket price). The donut shows the status mix: green On pace (19), amber Watch (12), red Markdown (9). Main region: a sortable table of all 40 SKUs with columns product, category, units received, units sold, on hand, sell-through percent, weekly rate (average of the last two weeks), weeks of supply, current price, suggested markdown, and a status badge. Default sort is sell-through ascending so the stragglers lead. Filters: a category select and a status select. Second region: a weekly pace chart, cumulative sell-through percent by week for weeks 1 through 8, one line per category plus a total line, against a dashed target pace line that reaches 80 percent by week 14. Third region: a markdown log listing decisions taken (product, old price, new price, effective week) with a member-only side panel form for recording a new one. Data. Seed 40 SKUs across five categories, Dresses, Tees, Denim, Swim, and Occasion, with receipts of 60 to 240 units, units sold to date, units sold in each of the last two weeks (these drive weekly rate and weeks of supply), and prices from $24 to $128, plus eight weeks of category-level weekly unit sales powering the pace chart. Encode these rules: status is red when sell-through is under 30 percent and weeks of supply is over 10, amber when sell-through trails the target pace by more than 10 points, green otherwise; suggested markdown is 30 percent for red, 15 percent for amber, none for green. The story: sundresses and graphic tees are nearly sold out at 85 to 95 percent, Swim was marked down in week 5 and its line visibly bends upward afterward, while the Occasion category of linen blazers and midi skirts flatlines near 26 percent with 11 weeks of supply. Seed 3 past markdowns in the log, including the Swim one. Behavior. Sell-through, weekly rate, weeks of supply, status, and suggested depth are computed; members record markdown decisions through the panel form; visitors see everything fully populated and read-only. Visual identity: use a royal purple accent for primary actions, the total pace line, and active states, on a clean light neutral base.