please help w excel and written 12.6. Jessica Williams, manager of kitchen...

80.2K

Verified Solution

Question

Accounting

image
image
please help w excel and written
12.6. 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 the inventory policy for stoves, she records the number sold each day over a period of 25 days, as summarized below. Simulate 10 days of sale long hand. Use the random number table posted on Classes under Data files; use numbers from the column with the letter from your name. Compute the average number of stoves sold per day based on your simulation. Simulate 100 days of sales using Excel. Compute the cumulative sales, and the running average of sales per day as part of your simulation. 3. Based on your simulation: suppose the store inventory never holds more than 4 stoves in inventory and customers shop elsewhere if they stock out, how many sales would be lost

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students