Please help

0 Required information Taylor's is a popular restaurant that offers customers a large dining room and comfortable bar area. Taylor Henry, the owner and manager ofthe restaurant, has seen the number of patrons increase steadily over the last two years and is considering whether and when she will have to expand its available capacity. The restaurant occupies a large home. and all the space in the building is now used for dining. the bar, and kitchen, but space is available on the property to expand the restaurant. The restaurant is open from 6 pm. to 10 pm. each night (except Monday) and, on average, has 24 customers enter the bar and 50 enter the dining room during each of those hours. Taylor has noticed the trends over the last 2 years and expects that within about 4 years, the number of bar customers will increase by 50% and the dining customers will increase by 20%. Taylor is worried that the restaurant will be not be able to handle the increase and has asked you to study its capacity, In your study, you consider four areas of capacity: the parking lot (which has 80 spaces). the bar (54 seats), the dining room (100 seats), and the kitchen. The kitchen is wellstaffed and can prepare any meal on the menu in an average of 12 minutes per meal. The kitchen, when fully staffed, is able to have up to 20 meals in preparation at a time, or 100 meals per hour (60 min/12 min x 20 meals). To assess the capacity ofthe restaurant, you obtain the additional information: . Diners typically come to the restaurant by car, with an average of 3 persons per car, while bar patrons arrive with an average of1.5 persons per car. . Diners, on average, occupy a table for an hour, while bar customers usually stay for an average of 2 hours. . Due to re regulations, all bar customers must be seated. o The bar customer typically orders one drink per hour at an average of $7 per drink; the dining room customer orders a meal with an average price of $22; the restaurant's cost per drink is $1, and the direct costs for meal preparation are $5. Required: 1-a. Given the current number of customers per hour, what is the amount of excess capacity in the bar, dining room. parking lot, and kitchen? 17b. Calculate the expected total throughput margin for the restaurant per day, and month (assuming a 267day month). 2-a. Given the expected increase in the number of customers, determine if there is a constraint for any ofthe four areas of capacity. What is the amount of needed capacity for each constraint? 2-b. lfthere is a constraint, reduce the demand on the constraint so that the restaurant is at full capacity (assume some customers would have to be turned away). Calculate the expected total throughput margin for the restaurant per day, and month (assuming a 26- day month). Complete this question by entering your answers in the tabs below. Req 1A Req lB Req 2A Req ZB Given the current number of customers per hour, what is the amount of excess capacity in the bar, dining room, parking lot, and kitchen? Parking (spaces) Dining (seats) - Kitchen (meals) - Complete this question by entering your answers in the tabs below. Req 1A Req 1B Req 2A Req 2B Calculate the expected total throughput margin for the restaurant per day, and month (assuming a 26-day month). Per Day Per Month Total throughput margin Complete this question by entering your answers in the tabs below. Req 1A Req 1B Req 2A Req 2B Given the expected increase in the number of customers, determine if there is a constraint for any of the four areas of capacity. What is the amount of needed capacity for each constraint? If there is a constraint for any of the four areas of capacity? Needed Capacity Parking (spaces) Bar (seats) Dining (seats) Kitchen (meals) Complete this question by entering your answers in the tabs below. If there is a constraint, reduce the demand on the constraint so that the restaurant is at full capacity (assume some customers would have to be turned away). Calculate the expected total throughput margin for the restaurant per day, and month (assuming a 26-day month). Total throughput margin _ -