Question
Jessica Williams, manager of kitchen appliances for the Midtown Department Store, feels that her inventory levels of stoves have been running higher than necessary. Before
Jessica Williams, manager of kitchen appliances for the Midtown Department Store, feels that her inventory levels of stoves have been running higher than necessary. Before revising inventory policy for stoves, she records the number sold each day over a period of 25 days, as summarized below.
Number Sold. 2 3 4 5 6
Number of Days 4 7 8 5 1
D) Use random numbers .4476,.9713 and .0629 to simulate daily sales over three days.
Please solve in Excel and show formulas!!! Thank you.
SHOW FORMULAS!! - Do not answer unless you can solve in Excel and show formulas!
Step by Step Solution
3.38 Rating (157 Votes )
There are 3 Steps involved in it
Step: 1
D 04476 4 stoves 09713 6 stoves 00629 2 stoves The average of these is 4 6 23 4 which exce...
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
Data Analysis And Decision Making
Authors: Christian Albright, Wayne Winston, Christopher Zappe
4th Edition
538476125, 978-0538476126
