Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please fill in all grey shaded areas of the grid and let me know the formula for each area. Open-To-Buy Worksheet Fill in all grey
Please fill in all grey shaded areas of the grid and let me know the formula for each area.
| Open-To-Buy Worksheet | |||||||
| Fill in all grey shaded areas of the grid | |||||||
| BOM | Plan Sales | Sales % to total | Markdown $ | Md % | OTB | Stock-To-Sales | |
| February | 35,000 | $9,000 | 11.5% | $1,000 | 3.88 | ||
| March | 41,000 | $15,000 | 19.2% | $2,000 | 13.3% | 20,000 | |
| April | 44,000 | $18,000 | 23.1% | $2,000 | |||
| May | 41,000 | $15,000 | 10.0% | 2.73 | |||
| June | 38,000 | 15.4% | $3,000 | 12,000 | |||
| July | $9,000 | $2,500 | 3.89 | ||||
| EOM July | 39,000 | ||||||
| Total Spring | $78,000 | ||||||
| Average Stock= | |||||||
| Turn= | |||||||
| Stock-to Sales Ratio = BOM Stock / Sales for the month | |||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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
Get Started