Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Management

Authors: Lokyie Lomine, Martin Mwenda Muchena, Robert Pierce

1st Edition

1382016832, 978-1382016834

More Books

Students also viewed these General Management questions

Question

Coaching and motivational behavior

Answered: 1 week ago

Question

Does it avoid use of underlining?

Answered: 1 week ago