Please submit as a single Excel and use Excel QM to develop your answers. To receive full credit, appropriate detail needs to be provided including a sophisticated one-paragraph description of your findings. Please provide submission as one document. In addition, a professional presentation of findings is important. #1 Determine the total cost for this plan given the following forecast: Use steady regular output of 400 units per month, use overtime as needed for up to 40 units per month, and use subcontracting to make up any needed output to match the forecast. Unit costs are: Regular output $30 Overtime $40 Subcontract $65 Holding costs $2 Lost sales $10 Please submit as a single Excel and use Excel QM to develop your answers. To receive full credit, appropriate detail needs to be provided including a sophisticated one-paragraph description of your findings. Please provide submission as one document. In addition, a professional presentation of findings is important. #1 Determine the total cost for this plan given the following forecast: Use steady regular output of 400 units per month, use overtime as needed for up to 40 units per month, and use subcontracting to make up any needed output to match the forecast. Unit costs are: Regular output $30 Overtime $40 Subcontract $65 Holding costs $2 Lost sales $10