Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a: Use Excel formulas to calculate the Actual Sell-thru for each department. Then select whether the departments are Above Plan, On Target, or Below Plan,
a: Use Excel formulas to calculate the Actual Sell-thru for each department. Then select whether the departments are Above Plan, On Target, or Below Plan, or New Arrivals (items just delivered with not have Sell-Thru data yet). (6 points) | ||||||||||
Department | Product Delivery Date | # of Units Received | Current # of Units On-Hand | First Month Planned Sell-Thru % | Actual Sell-Thru | Above Plan On Target Below Plan | ||||
Health & Beauty | 3/1/2019 | 1,350 | 1,105 | 22% | ||||||
Paper Goods | 1/1/2019 | 2,725 | 1,650 | 40% | ||||||
Media & Gaming | 4/1/2019 | 350 | 350 | 25% | ||||||
Jewelry | 2/1/2019 | 220 | 115 | 60% | ||||||
Furniture | 1/1/2019 | 80 | 13 | 10% | ||||||
Paint | 3/1/2019 | 125 | 96 | 30% | ||||||
Toys | 1/1/2019 | 375 | 210 | 55% | ||||||
Seasonal | 3/1/2019 | 1,640 | 1,245 | 20% |
What is the formula to figure out the Actual Sell-thru %? ( What would be your answer to the 1st line for an example?)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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