$*$Projected cost in $2025$: $\backslash$$$175\mathrm{.}00$ Analyze VCC$$s current situation and provide feasible solutions to their current issues that balance the delicate relationships with the OEM, suppliers, shareholders, and customers. $($Estimate $3$ to $5$ paragraphs$)$ Provide an analysis of VCC$$s position within the existing supply chain and the strengths and weaknesses of its current production process flow, some of which may have been exposed through its adoption of Lean principles and a large number of potential product combinations. $($Estimate $3$ to $5$ paragraphs$)($Use the excel file$)$ Prepare VCC$$s pro$-$form income statement, balance sheet, statement of cash flows, and unit cost information for $2025$ integrating the terms of the new contract and your proposed solutions for VCC$.$ When preparing the pro forma statements. You should also assume: $$ There are no planned additional investments in manufacturing equipment, meaning annual deprecation will remain at $2024$ levels. $$ Your calculations should be based on $50$ productive weeks per year. $$ Overtime, if needed, is paid at $150\%$ of labor cost $($current labor costs are $$50$ per hour$).$ Freight costs are expected to increase to $$175$ per unit for all units shipped in $2025.$ There are no changes in research and development costs, general administrative expenses, and interest expense. Compute and compare the following ratios: working capital, current ratio, inventory turnover, debt$-$ to$-$assets ratio, debt$-$to$-$equity ratio, times interest earned, return on sales, asset turnover ratio, return on assets, return on equity, and earnings per share for $2024$ and $2025.$ These ratios should be used to support your proposed solutions. Prepare a horizontal trend analysis comparing the $2024$ and $2025$ income statements. Prepare a vertical trend analysis of the $2025$ pro forma income statement. Include a conclusion of all findings include a reference to ratios and rationale involving the proforma financial statements. $($Estimate $3$ to $5$ paragraphs$)$