Quantitative Analysis & Excel
Instructions
Attached Excel Student Workbook below:
Read the case study attached below and complete the following requirements.
Quantitative Analysis:
Chandler Corporation is currently producing several products, including both custom and standard designs. It has received requests for two new products: swimming pool shades and landscape trellises. It is considering whether to produce either or both of these products. Based on the projections in Exhibits 1 to 3 describing the current capacity and required capacity needs for the new products, complete the following requirements:
- Using ABC, compute the Predetermined Overhead Rate for each activity.
- Compute the cost of unused capacity for each activity and in total.
- Compute the TOTAL and UNIT cost of making the full demand of pool shades assuming that Chandler bases its rates on the predetermined overhead rate.
- Compute the TOTAL and UNIT cost of making the full demand of trelli, assuming that Chandler bases its rates on the predetermined overhead rate.
- Compute the TOTAL and UNIT cost of making the full demand of pool shades assuming that Chandler bases its rates on EXPECTED capacity (used capacity plus required capacity for the full demand of pool shades).
- Compute the total and unit cost of making the full demand of trellises assuming that Chandler bases its rates on EXPECTED capacity (used capacity plus required capacity for the full demand of trellises).
Qualitative Analysis:
In a 2 page report, based on your quantitative analysis, discuss the results of what your quantitative analysis means for Chandler. When considering a decision to make the new products, would costs computed using practical capacity (c and d) or expected capacity (e and f) as the denominator provide better information to Chandlers management? Explain your answer. Support your recommendation with a minimum of 3 academic resources in APA format.
Deliverables
- Quantitative Analysis (Excel Required): You are required to use the provided Excel workbook to complete the quantitative analysis for this assignment.
- Qualitative Analysis (Word Required): Prepare a 2-page summary addressing the required qualitative analysis, as noted in the Student Workbook. Your paper is required to be formatted according to APA requirements. Be sure to incorporate key concepts from this unit’s readings and properly cite your references according to APA requirements. Do NOT embed the results of your quantitative analysis in your Word document. You should only reference parts of your quantitative analysis in your written analysis. Your written responses to the qualitative prompts should not be presented in a question and answer format.
