Because of limited demand, for several years, production has been at 80% of estimated capacity. Capacity is constrained by the number of machine hours available. Management wants to make use of the company's current excess capacity. Management has several independent strategies to utilize this excess capacity. For each independent strategy, conduct an incremental analysis to determine the net impact the strategy will have on operating income. Unless noted, all cells should only contain cell references. Then, make a suggestion to management on which strategy they should implement. Required: BASELINE Before analyzing the three strategies, in the ORANGE boxes: - Calculate the contribution margin per unit for both products. - Calculate the contribution margin per unit of machine hours for both products. STRATEGY 1 - Fulfill a special order Marvin Co is in communications with a Local construction company that develops subdivisions across the Midwest. The construction company is interested in a special order to purchase a combination of manual and automatic dehumidifiers for every home in the build project, but they would require a reduction on price for the bulk order. Marvin Co's production manager believes that the special order would require some additional fixed costs. The details of the special order are summarized in Exhibit 2. - In the YELLOW boxes, determine the net change in operating income if Marvin Co accepts the special order. STRATEGY 2 - Market extra units in foreign market Marvin Co. has not yet sold their product abroad. If they enter the foreign market, sales price must be reduced by 20% and no more than 6,000 units of either model can be sold. The sales commissions of 10% (included in the variable operating expenses in Exhibit 1) will be avoided if this strategy is selected. All other costs will remain the same. (You may hard code-not cell reference - the three numbers contained in this paragraph.) - In the BLUE boxes, complete the formulas, calculate the contribution margin per unit and the contribution margin per machine hour for units sold abroad. - In the GREEN. boxes, determine the profit maximizing product mix that could be sold abroad and the net change in operating income if Marvin Co sells this product mix abroad. STRATEGY 3 - Increase domestic market sales with promotion campaign Marvin Co's marketing team believes that a targeted domestic marketing campaign could increase demand allowing them to sell units at regular prices. However, the marketing campaign would need to target EITHER manual units OR automatic units (not both). So, Marvin Co would need to decide whether to use all of its excess capacity to produce and sell manual units or to produce and sell automatic units. The promotion campaign would cost $235,000 to promote the manual model, but would only cost $225,000 to promote the automatic model. (You may hard code - not cell reference - the two numbers contained in this paragraph.) - In the PURPLE boxes, determine the net change in operating income if Marvin Co. adopts a domestic marketing campaign for automatic units. - In the PINK boxes, determine the net change in operating income if Marvin Co. adopts a domestic marketing campaign for manual units. RECOMMENDATION - In the TEXTBOX provide a recommendation: Which strategy do you recommend Marvin Co. implement? Why? \begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ Baseline } & \\ \hline & Automatic & Manual \\ \hline Sales Price & & \\ \hline Less: Variable Cost & & \\ \hline Contribution Margin & & \\ \hline Divided by: Machine Hour & & \\ \hline Contribution Margin per machine hour & & \\ \hline \end{tabular} RECOMMENDATION. Choosing from the three strotegies you investigated, which strategy do you recommend that Marvin Co. impiement? Why? \begin{tabular}{|l|l|} \hline \multicolumn{1}{|c|}{ Strategy 1: Special Order } \\ \hline & \\ \hline Revenue from Special Order \\ \hline Less: Variable Cost from Special Order & \\ \hline Contribution Margin & \\ \hline Less: Additional Fixed Costs & \\ \hline Net change in OI for Special Order & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline \multicolumn{2}{|c|}{ Strategy 2: Foreign Market } \\ \hline CM Calculation & Automatic & Manual \\ \hline Sales Price & & \\ \hline Less: Variable Cost & & \\ \hline Contribution Margin & & \\ \hline Divided by: Machine Hour & & \\ \hline Contribution Margin per machine hour: & & \\ \hline Product Mix & & \\ \hline Quantity & & \\ \hline Incremental Analysis & & \\ \hline Net Change in Oi for Foreign Sales & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline \multicolumn{2}{|c|}{ Strategy 3: Promotion Campaigns } \\ \hline & Automatic & Manual \\ \hline Contribution Margin per Unit & & \\ \hline Mult: Units produced from Excess Capacity & & \\ \hline Total Contribution Margin from Campaigns & & \\ \hline Less: Cost of Campaign & & \\ \hline Net Change in Or for Promotion Campaign & & \\ \hline \end{tabular}