Reception Division Super Relaxing Hydration Hairstyle

Activity time $[$min$]212,540814$ Overall process

# workers $271666$ Total workers $37$

Capacity $[$cust$/$hr$]6033,6244526$ Process capacity $[$cust$/$hr$]24$

Cycle time $[$min$]2,50$

Day of the week Weight in the week Average demand $[$cust$/$day$]$ Demand rate $[$cust$/$hr$]$ Flow rate $($cust$/$hr$)$ Labor utilization Average labor utilization $76\%$

Reception Division Super Relaxing Hydration Hairstyle Flow rate per week $1588$

Mon$-$Thu $67\%25321,0821,0835\%63\%88\%47\%82\%$

Fri $17\%34228,5024,0040\%71\%100\%53\%93\%$

Sat $17\%44336,9224,0040\%71\%100\%53\%93\%$

Average labor utilization over the week $37\%66\%92\%49\%86\%$ Modify the Excel template that currently has the Madureira locaJon numbers for the Caxias

loca$($on$.$ For Caxias loca$($on:

$3.$ What is the average number of customers served in a week with the current resources?

$4.$ IdenJfy the boNleneck in this process

$5.$ Suggest two ways of for increasing the number of customers served in a week, for each:

a$.$ calculate the increase in revenue

b$.$ calculate the change in cost

If you cannot find a numerical informaJon for the calculaJon of a cost or benefit

component, just use a reasonable assumpJon. But state your assumpJons.

$6.$ Which of your two suggesJons is beNer?