Case 3 Marvin Co. Marvin Co. manufactures both an automatic and a manual household dehumidifier. Exhibit 1 contains information on the price and cost per unit for both automatic and manual dehumidifiers. Exhibit 1 also contains production time for both products and capacity constraints. 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 companys 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. You will be assigned a number. Download the excel file from Blackboard that matches your number. For example, Student 1 will download Marvin_1.xlsx.

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 Cos 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. All costs will remain the same except that the sales commission of 10% (included in the variable operating expenses in Exhibit 1) will be avoided. (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 Cos 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?

PLEASE PROVIDE THE CELL FORMULA TO UNDERSTAND

Baseline Automatic Manual Exhibit 1: Data Automatic Manual Sales Price $ 350.00 $ 150.00 Per Unit Costs Direct Materials $ 65.00 $ 32.00 Direct Labor $ 35.00 $ 25.00 Variable MOH $ 68.00 $ 16.00 Fixed MOH $ 50.00 $ 18.00 Variable Operating Expenses $ 52.00 $ 21.00 Fixed Operating Expenses $ 30.00 $ 13.00 Sales Price Less: ? Contribution Margin Divided by: ? Contribution Margin per machine hour Strategy 1: Special Order Production Time (in Machine Hours) 2.5 1.0 Revenue from Special Order Less: Variable Cost from Special Order Contribution Margin Less: Additional Fixed Costs Net Change in Ol for Special Order Total Capacity (in Machine Hours) Excess Capacity (in Machine Hours) 50,000 10,000 Manual Exhibit 2: Special Order Request Automatic Manual $ 300.00 $ 125.00 2,000 5,000 Special Price Quantity Additional Fixed Cost $ 85,000 Strategy 2: Foreign Market Automatic CM Calculation Sales Price Less: ? Contribution Margin Divided by: ? Contribution Margin per machine hour Product Mix Quantity Incremental Analysis Net Change in Ol for Foreign Sales RECOMMENDATION. Which strategy do you recommend that Marvin Co. implement? Why? Manual Strategy 3: Promotion Campaigns Automatic Contribution Margin per Unit Mult: Units produced from Excess Capacity Total Contribution Margin from Campaigns Less: Cost of Campaign Net Change in Ol for Promotion Campaign Baseline Automatic Manual Exhibit 1: Data Automatic Manual Sales Price $ 350.00 $ 150.00 Per Unit Costs Direct Materials $ 65.00 $ 32.00 Direct Labor $ 35.00 $ 25.00 Variable MOH $ 68.00 $ 16.00 Fixed MOH $ 50.00 $ 18.00 Variable Operating Expenses $ 52.00 $ 21.00 Fixed Operating Expenses $ 30.00 $ 13.00 Sales Price Less: ? Contribution Margin Divided by: ? Contribution Margin per machine hour Strategy 1: Special Order Production Time (in Machine Hours) 2.5 1.0 Revenue from Special Order Less: Variable Cost from Special Order Contribution Margin Less: Additional Fixed Costs Net Change in Ol for Special Order Total Capacity (in Machine Hours) Excess Capacity (in Machine Hours) 50,000 10,000 Manual Exhibit 2: Special Order Request Automatic Manual $ 300.00 $ 125.00 2,000 5,000 Special Price Quantity Additional Fixed Cost $ 85,000 Strategy 2: Foreign Market Automatic CM Calculation Sales Price Less: ? Contribution Margin Divided by: ? Contribution Margin per machine hour Product Mix Quantity Incremental Analysis Net Change in Ol for Foreign Sales RECOMMENDATION. Which strategy do you recommend that Marvin Co. implement? Why? Manual Strategy 3: Promotion Campaigns Automatic Contribution Margin per Unit Mult: Units produced from Excess Capacity Total Contribution Margin from Campaigns Less: Cost of Campaign Net Change in Ol for Promotion Campaign