Question: Please help me with this homework question. Data Envelopment Analysis question for Excel QM. (economics). Will be upvoted 100%. 1. Australian firm A is a


Please help me with this homework question. Data Envelopment Analysis question for Excel QM. (economics). Will be upvoted 100%.
1. Australian firm A is a manufacturer of two different types of outputs (Output 1 and Output 2). In order to assess performance at its Brisbane plant, an analyst collects annual data on the quantities of three inputs (capital, labour and materials) and two outputs (Output 1 and Output 2). Data for the last five years are presented in Table 1. Excel QM and material learnt in the lectures and tutorials to answer the following questions: Table 1: Data for the Brisbane Plant b) Suppose inputs and outputs are valuable and can be chosen freely. Develop and report a set of input and output targets for 2020 (round your answers to two decimal places). Should the current manager be reviewing the way the plant was operated in previous years in his/her efforts to make the plant more efficient? If so, what year should the manager look at most closely? (40 marks)Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
