Refer to the case Murphy Shirt Co. (in Blackboard) and produce a report that answers three questions Required: 1. Prepare a spreadsheet in MS Excel showing the customer profitability of Murphy's customers. You can make reasonable assumptions but you need to state them. [10 Marks) 2. On the basis of the above analysis, what action (s) should the management of Murphy Shirt Co. undertake? [4 Marks) 3. Should Murphy Shirt Co. enter the women's sports shirt segment? Prepare an analysis using MS Excel to support your answer. [6 Marks] Instructions: 1. This is an individual assignment. 2. Due date: 26th September 2021. Submit online on BB 3. The assigned marks will be converted to the overall mark of 5%. Marking Guide 1. Evidence of serious reading of the assigned case. 2. Critical thinking (not just reproducing facts/data). 3. Logical analysis of data. 4. Evidence of drawing appropriate conclusions from the data. Refer to the case Murphy Shirt Co. (in Blackboard) and produce a report that answers three questions Required: 1. Prepare a spreadsheet in MS Excel showing the customer profitability of Murphy's customers. You can make reasonable assumptions but you need to state them. [10 Marks) 2. On the basis of the above analysis, what action (s) should the management of Murphy Shirt Co. undertake? [4 Marks) 3. Should Murphy Shirt Co. enter the women's sports shirt segment? Prepare an analysis using MS Excel to support your answer. [6 Marks] Instructions: 1. This is an individual assignment. 2. Due date: 26th September 2021. Submit online on BB 3. The assigned marks will be converted to the overall mark of 5%. Marking Guide 1. Evidence of serious reading of the assigned case. 2. Critical thinking (not just reproducing facts/data). 3. Logical analysis of data. 4. Evidence of drawing appropriate conclusions from the data