For this case, review your lecture notes on Relevant Costing Marvin Co. manufactures both an automatic and a manual household dehumidifier. Exhibit 1 Exhibit 1 also contains production time for both products andomatic and manual dehumidifiers, Because of limited demand, for several years, productions hacity constraints, Capacity is constrained by the number of machine hour has been at 80% of estimated capacity. use of the company's current excess capacity. Management available, Management wants to make gement has several independent strategies 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. 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 cither 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 - In the GREEN boxes, determine the profit maximizing abroad. abroad and the net change in operating income if abroad. STRATEGY 3 - Increase domestic market sales with promotion campaign Marvin Co's marketing team believes that a targeted tomers prices. However, the marketing campaign increase demand allowing them to sell units at regular prices. However, the marketing carnpaign 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. \begin{tabular}{|l|rr|rr|} \hline \multicolumn{4}{|c|}{ Exhibit 1: Data } \\ \hline & Automatic & \multicolumn{2}{|c|}{ Manual } \\ \hline Sales Price & $350.00 & $ & 150.00 \\ \hline Per Unit Costs & & & & \\ \hline Direct Materials & $ & 65.00 & 5 & 32.00 \\ \hline Direct Labor & 5 & 35.00 & 5 & 25.00 \\ \hline Variable MOH & 5 & 68.00 & 5 & 16.00 \\ \hline Fixed MOH & 5 & 50.00 & 5 & 18.00 \\ \hline Variable Operating Expenses & $ & 52.00 & 5 & 21.00 \\ \hline Fixed Operating Expenses & 5 & 30.00 & 5 & 13.00 \\ \hline & & & & \\ \hline & & 2.5 & & 1.0 \\ \hline Production Time (in Machine Hours) & & & & \\ \hline & & 50,000 & & \\ \hline Total Capacity (in Machine Hours) & & 10.000 & & \\ \hline Excess Capacity (in Machine Hours) & & \end{tabular} \begin{tabular}{|l|lrrr|} \hline \multicolumn{3}{|c|}{ Baseline } & & \\ \hline & Automatic & \multicolumn{2}{|c|}{ Manual } \\ \hline Sales Price & 5 & 350.00 & 5 & 150.00 \\ \hline Less: Variable Cost & 5 & 220.00 & 5 & 94.00 \\ \hline Contribution Margin & 5 & 130.00 & 5 & 56.00 \\ \hline Divided by: Machine Hour & & 2.5 & & 1.0 \\ \hline Contribution Margin per machine hour & 5 & 52.00 & 5 & 56.00 \\ \hline \end{tabular} \begin{tabular}{|l|r|rr|} \hline \multicolumn{3}{|c|}{ Exhibit 2: Special Order Request } \\ \hline & Automatic & \multicolumn{1}{|c|}{ Manual } \\ \hline Special Price & $300,00 & 5 & 125,00 \\ \hline Quantity & 2,000 & 5,000 \\ \hline & & \\ \hline Additional Fixed Cost & $85,000 & \\ \hline \end{tabular} RECOMMENDATION. Choosing from the three strotegies you investigated, which strategy do you recommend thot Marvin Co. impiement? Why? \begin{tabular}{|l|l|l|} \hline \multicolumn{2}{|c|}{ Strategy 2: Foreign Market } \\ \hline & Automatic & Manual \\ \hline CM Calculation & & \\ \hline Sales Price & & \\ \hline Less: Variabie Cost & & \\ \hline Contribution Marsin & & \\ \hline Divided by. Machine Hour & & \\ \hline Contribution Margin per machine hour & & \\ \hline Product Mix & & \\ \hline Quantity & & \\ \hline Incremental Analysis & & \\ \hline Net Change in Ol for Foreign Sales & & \\ \hline \end{tabular}