Question: please create a excel sheet to solve this question 50. The Embassy Lodge hotel chain wants to compare its brand efficiency to that of its

please create a excel sheet to solve this question

please create a excel sheet to solve this question 50. The Embassy

50. The Embassy Lodge hotel chain wants to compare its brand efficiency to that of its major competitors using DEA. Embassy collected the following data reported in industry trade publications. Embassy views customers' perceptions of satisfaction and value (scored from 0 to 100 where 100 is best) to be outputs produced as a function of the following inputs: price, convenience, room comfort, climate control, service, and food quality. (All inputs are expressed on scales where less is better.) a. Compute the DEA efficiency for each brand. b. Which brands are efficient? c. Is Embassy Lodge efficient? If not, what input and output values should they aspire to in order to become efficient

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 General Management Questions!