solution

Calculate the total simulated hours, total waiting time for the customer service team member, and the total wait time for the customer?

$10.00

Using the random number function in excel simulate the arrival of 25 customers

 

SKU: Sol001

Question 1

In order to assist the manager you are compiling a resource which will define the various management accounting terms used in the process of strategic analysis. Provide an explanation of the following terms, with examples specifically relating to Boutique Catering, to include
in a resource file which incorporates a reason why each concept is relevant or not relevant to decision-making:
  • Satisficing model
  • Simulation
  • Opportunity Cost
  • Sunk cost
  • Break -even point

 

Question 2

It’s your second day with Boutique Catering and the general manager has received a report summarising client complaints which she would like you to investigate. There is a consistent theme of clients being unhappy with the service time when receiving their meals. The general manager would like you to establish if additional staff should be employed to improve the service time. Meals are served in a general area and often the clients will stand around talking before placing an order. The following pattern records customer arrivals and the time it takes for the clients to receive their meals
a)Using the random number function in excel simulate the arrival of 25 customers
b)Calculate the total simulated hours, total waiting time for the customer service team member, and the total wait time for the customer?
c)Do you think that enough simulations have been completed to report an outcome to the general manager, explain your answer?

Reviews

There are no reviews yet.

Be the first to review “Calculate the total simulated hours, total waiting time for the customer service team member, and the total wait time for the customer?”

Your email address will not be published. Required fields are marked *