Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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

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

Cornerstones Of Financial Accounting

Authors: Jay Rich, Jefferson Jones, Maryanne Mowen, Don Hansen, Donald Jones, Ralph Tassone

2nd Canadian Edition

0176707123, 978-0176707125

More Books

Students also viewed these Accounting questions