I only need #1 completed. This needs to be done on an excel spreadsheet.

Thank you

P24 - 28A Integrating decentralization and performance evaluation systems One subunit of Field Sports Company had the following financial results last month: Requirements Complete the performance evaluation report for this subunit (round to two decimal places). Based on the data presented and your knowledge of the company, what type of responsibility center is this subunit? Which items should be investigated if part of management's decision criteria is to investigate all variances equal to or exceeding $ 4,000 and exceeding 10 % (both criteria must be met)? Should only unfavorable variances be investigated? Explain. Is it possible that the variances are due to a higher-than-expected sales volume? Explain. Will management place equal weight on each of the variances exceeding $ 4,000? Explain. Which balanced scorecard perspective is being addressed through this performance report? In your opinion, is this performance report a lead or a lag indicator? Explain. List one key performance indicator for the three other balanced scorecard perspectives. Make sure to indicate which perspective is being addressed by the indicators you list