Question: Hi! I am having some hard time trying to do Prof Juran Case of the Queen of Diamonds.... I am trying to do by myself

Hi! I am having some hard time trying to do Prof Juran Case of the Queen of Diamonds....

I am trying to do by myself the Excel spreadsheet, but I am not being able to succeed on it....

It is a case of a restaurant that needs to verify the optimal number of seats reservations.

More information in the case attached

I need some help in order to run the simulations to prove what is the optimal number of reservations to maximize the revenue (is a number that will make the chances of >143 people and chances of

I know that a binomial simulation is needed, but still I am not able to do it.

Attached you will find the case + excel + presentation and I need guidance on how to do it

Thanks!

Hi! I am having some hard time trying to do Prof Juran

Case of the Queen of Diamonds....I am trying to do by myself

the Excel spreadsheet, but I am not being able to succeed on

Day Monday Tuesday Wednesday Thursday Friday Saturday Total Result Average - Capacity Effective 114.75 127 138.5 136.75 128.5 127.333333333333 128.869565217391 Average of Effective Meals per Day 115 Monday 127 Tuesday 139 137 129 127 129 Wednesday Thursday Friday Saturday Total Result Day - multiple - Categoria 143 people) Objectives (b)Minimize chances of empty seats (143 people and

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

answer all parts111 Your second essay assignment requires you to critically examine the American Psychological Association code of ethics. But does the code of ethics from your own profession...

From the case study of Week # 5 please answer the question Who is responsible for this costly oversight? Who should take responsibility? Who is most likely to be blamed for the error? 11:33 1 5G+ 0 a...

I got this big assignmnet for Quantitative methods for business i really need help Azimi, Hamida - azihy004 AH Share Comments Delete this page before submission Q-Constructions - building your future...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

Business Event Analysis: Complete the following table based on the specified NBD event. Receive Shipment (From Supplier) Trigger(s) (also indicate type) Collected Data (originates as input for event)...

Chapter Five: Understanding Women and Work I Equality is difficult, but superiority is painful. erere proverb Managing Workplace Diversity Chapter Five: Understanding Women and Work 1 Chapter Five...

please help me develop a strong and convincing character letter for Jennifer based off of the information given and the texts as she was very accommodating with me when I had my back injury and...

This is an individual assignment requiring you to analyze the data presented in the TruEarth Healthy Foods case (4065-PDF-ENG). You will likely find the Student Spreadsheet that accompanies the case...

hi. I'm stuck with a report whose Chic Paints Ltd. and I am finding difficulty to answer some questions such as the organisations accounting system requirements including hardware and software...

LEAN QUIZ This quiz is based upon: Staats, B. R., & Upton, D. M. (2011). Lean knowledge work. Harvard Business Review, (October), Complete 5 of 7 questions correctly for maximum of 5 points. Which is...

A payment of $3000 on a $6000 invoice qualified for the larger cash discount in 3/10, 1/20, n/30. What additional payment 18 days after the invoice date will settle the invoice?

The Undergraduate Advising office in a small university has one advisor who works eight hours a day. Throughout the day students arrive at an average of one every 12 minutes, and their requests take...

In general, securities with _ _ _ _ credit risk and _ _ _ _ _ _ _ liquidity will offer higher yields. a . higher; lowerb. higher; higher.c . lower; lowerd. lower; higher

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...