Retail Merchandising and Buying
Amelia17002
NegotiationScenarioworksheet.xlsxSheet1
| Vendor | Big L Jeans | KC Denim | Mouse Experience | Sweetheart Clothing | ||||
| 2018 Actual | 2018 Plan | 2018 Actual | 2018 Plan | 2018 Actual | 2018 Plan | 2018 Actual | 2018 Plan | |
| Sales | $2,480,000 | $2,360,000 | $1,640,000 | $1,925,000 | $2,742,000 | $2,355,000 | $2,365,000 | $2,300,000 |
| MU % | 60.2% | 60.2% | 59.4% | 60.2% | 62.8% | 62.2% | 64.4% | 64.2% |
| MD % | 42.3% | 42.5% | 48.8% | 42.0% | 44.5% | 46.3% | 46.1% | 43.9% |
| GM % | 43.4% | 43.3% | 39.6% | 43.4% | 46.2% | 44.7% | 48.0% | 48.4% |
| Late Shipment % | 10.0% | 14.5% | 8.0% | 10.0% | ||||
| Sales increase/decrease to plan | ||||||||
| GM $ | ||||||||
| The late shipment plan for all vendors is under 10% | ||||||||
