I need help with QUESTION 4 and would like my answers for Questions 1-3 checked!

"I'm not looking forward to breaking the news," groaned Charlie Wettle, the controller of Meyer Paint Company. He and Don Smith, state liaison for the firm, were returning from a meeting with representatives of the Kansas General Services Administration (GSA), the agency that administers bidding on state contracts. Charlie and Don had expected to get the specifications to bid on the traffic paint contract, soon to be renewed. Instead of picking up the bid sheets and renewing old friendships at the GSA, however, they were stunned to learn that Meyer's paint samples had performed poorly on the road test and the firm was not eligible to bid on the contract Meyer's two main product lines are traffic paint, used for painting yellow and white lines on highways, and commercial paints, sold through local retail outlets. The paint-production process is fairly simple. Raw materials are kept in the storage area that occupies approximately half of the plant space. Large tanks that resemble silos are used to store the latex that is the main ingredient in its paints. These tanks are located on the loading dock just outside the plant so that when a shipment of latex arrives, it can be pumped directly from the tank truck into these storage tanks. Latex is extremely sensitive to cold. It cannot be stored outside or even shipped in the winter without heated trucks, which are very expensive for a small firm such as Meyer. Currently, Meyer has the traffic paint contracts for the states of Texas, Nebraska, Iowa, and Kansas. Of last year's total production of 380,000 gallons, 90% was traffic paint. Of this amount, 88,000 gallons were for the Kansas contract. Each state has unique specifications for color, thickness, texture, drying time, and other characteristics of the paint. For example, paint sold to Nebraska must withstand heavy use of salt on roads during the winter. Paint for Texas highways must tolerate extended periods of intense heat during summer months. Due to the high cost of shipping paint, most paint producers can be competitive on price only in locations fairly close to their production facilities. Accordingly, Meyer has enjoyed an advantage in bidding on contracts in the Midwestern states close to Kansas. However, one of its biggest competitors, Heron Paint Company of California is building a new plant in Colorado. With lower costs due to its efficient new facility and its proximity, Heron will become a major competitive threat. Meyer's commercial paint line includes interior and exterior house paints in a wide range of colors formulated to approximate authentic farm barn colors. Because of the country association, the line has been well received in Kansas. Most of these paints are sold through paint and hardware stores as the stores second or third line of paint. The large national firms such as Benjamin Moore or Sherwin-Williams provide extensive services to paint retailers such as computerized color matching equipment. Partly because it lacks the resources to provide such amenities and partly because it has always considered the commercial paint a sideline, Meyer has never tried to market the commercial line aggressively. Meyer sells 38,000 gallons of commercial paint per year. Charlie is worried about the future of the company. The firm's strategic goal is to provide a quality product at the lowest possible cost and in a timely fashion. After absorbing the shock of losing the Kansas contract, Charlie wondered whether the firm should consider increasing production of commercial paints to lessen the company's dependence on traffic paint contracts. Carly Bunch, who manages the day-to-day operations of the firm, believes the company can double its sales of commercial paint if it undertakes a promotional campaign estimated to cost $120,000. The average price of traffic paint sold last year was $25 per gallon. For commercial paint, the average price was $29 per gallon. Charlie assembled the following data to evaluate the financial performance of the two lines of paint. The primary raw material used in paint production is latex. The list price for latex is $32 per pound; 450 pounds of latex are needed to produce 1,000 gallons of traffic paint. Commercial paint requires 325 pounds of latex per 1,000 gallons of paint. In addition to the cost of the latex, other variable costs are shown below: Traffic Commercial Raw materials cost per 1 gallon of paint: Camelcarb (limestone) $1.76 $2.08 Silica 1.74 2.04 Pigment 1.24 1.76 Other ingredients 1.12 1.06 Direct labor cost per gallon 0.92 1.70 Freight cost per gallon 1.56 0.86 Last year, fixed overhead costs attributable to the traffic paint totaled $170,000, including an estimated $50,000 of costs directly associated with the Kansas contract; the $50,000 can be eliminated. Fixed overhead costs attributable to the commercial paint are $26,000. Other fixed manufacturing overhead costs totaled $220,000. Charlie estimates that $100,000 of this amount is inventory handling costs that will be avoided due to the loss of the Kansas contract. Both the remaining fixed manufacturing overhead ($120,000) and the general and administrative costs ($280,000) are allocated equally to all gallons of paint produced. For the assignment, you must answer the four questions. I suggest working in Excel and then copying your tables into a Word document. Some of the points will be based on table formatting. You can email me your answers to Part 1, Scenario A and B before the end of the day on 4/23 and I will let you know how it looks. 1. Answer the following questions. Please note that each of the following is an independent scenario: Scenario A: Current production, including the Kansas contract: (a) What is the contribution margin per unit (to 2 decimal places) for each of the two product lines? (b) What is the total contribution margin for the company (rounded to the nearest whole dollar)? Scenario B: Without either the Kansas contract or the promotion to expand sales of commercial paint: What is the total contribution margin for the company, after considering the savings on inventory-handling costs? Scenario C: Without the Kansas contract, but with the promotion to expand sales of the commercial paint: What is the total contribution margin for the company, after considering the savings on inventory handling costs and the cost of the special promotion? 2. Based solely on the financial analysis performed in part 1, state whether scenario B or C should be chosen by Meyer since scenario A will not happen with the loss of the Kansas contract. 3. What are the primary strategic considerations associated with the decision addressed in part 2? 4. Prepare a sensitivity analysis in which the sales of commercial paint are projected to increase by only 30% rather than 100%. Recalculate the estimated total contribution margin associated with scenario C. Which of the scenario B and C has the higher projected total contribution margin (to the nearest whole dollar)? What does this suggest about scenario C? 1. Scenario A: Scenario A: Quantity Sales Traffic 342,000 $25.00 Commercial 38,000 $29.00 Total 380,000 Raw Materials Latex Camelcarb Silica Pigment Other Ingredients Direct Labor Freight Cost Variable Costs Contribution Margin per unit Total Contribution Margin $14.40 $1.76 $1.74 $1.24 $1.12 $0.92 $1.56 $22.74 $2.26 $772,920 $10.40 $2.08 $2.04 $1.76 $1.06 $1.70 $0.86 $19.90 $9.10 $345,800 $1,118,720 Scenario B: Scenario B: Quantity Sales Traffic 254,000 $25.00 Commercial 38,000 $29.00 Total 292,000 Raw Materials Latex Camelcarb Silica Pigment Other Ingredients Direct Labor Freight Cost Variable costs Contribution Margin per unit Total Contribution Margin $14.40 $1.76 $1.74 $1.24 $1.12 $0.92 $1.56 $22.74 $2.26 $574,040 $10.40 $2.08 $2.04 $1.76 $1.06 $1.70 $0.86 $19.90 $9.10 $345,800 $919,840 Scenario C: Scenario Quantity Sales Traffic 254,000 $25.00 Commercial 76,000 $29.00 Total 330,000 Raw Materials Latex Camelcarb Silica Pigment Other Ingredients Direct Labor Freight Cost Variable costs Contribution Margin per unit Total Contribution Margin $14.40 $1.76 $1.74 $1.24 $1.12 $0.92 $1.56 $22.74 $2.26 $574,040 $10.40 $2.08 $2.04 $1.76 $1.06 $1.70 $0.86 $19.90 $9.10 $691,600 $1,265,640 2. Scenario C should be chosen 3. Scenario C has a higher profit and lower risk due to market diversification. There is also expansion in the Commercial paint market and less reliance on the Traffic paint market. "I'm not looking forward to breaking the news," groaned Charlie Wettle, the controller of Meyer Paint Company. He and Don Smith, state liaison for the firm, were returning from a meeting with representatives of the Kansas General Services Administration (GSA), the agency that administers bidding on state contracts. Charlie and Don had expected to get the specifications to bid on the traffic paint contract, soon to be renewed. Instead of picking up the bid sheets and renewing old friendships at the GSA, however, they were stunned to learn that Meyer's paint samples had performed poorly on the road test and the firm was not eligible to bid on the contract Meyer's two main product lines are traffic paint, used for painting yellow and white lines on highways, and commercial paints, sold through local retail outlets. The paint-production process is fairly simple. Raw materials are kept in the storage area that occupies approximately half of the plant space. Large tanks that resemble silos are used to store the latex that is the main ingredient in its paints. These tanks are located on the loading dock just outside the plant so that when a shipment of latex arrives, it can be pumped directly from the tank truck into these storage tanks. Latex is extremely sensitive to cold. It cannot be stored outside or even shipped in the winter without heated trucks, which are very expensive for a small firm such as Meyer. Currently, Meyer has the traffic paint contracts for the states of Texas, Nebraska, Iowa, and Kansas. Of last year's total production of 380,000 gallons, 90% was traffic paint. Of this amount, 88,000 gallons were for the Kansas contract. Each state has unique specifications for color, thickness, texture, drying time, and other characteristics of the paint. For example, paint sold to Nebraska must withstand heavy use of salt on roads during the winter. Paint for Texas highways must tolerate extended periods of intense heat during summer months. Due to the high cost of shipping paint, most paint producers can be competitive on price only in locations fairly close to their production facilities. Accordingly, Meyer has enjoyed an advantage in bidding on contracts in the Midwestern states close to Kansas. However, one of its biggest competitors, Heron Paint Company of California is building a new plant in Colorado. With lower costs due to its efficient new facility and its proximity, Heron will become a major competitive threat. Meyer's commercial paint line includes interior and exterior house paints in a wide range of colors formulated to approximate authentic farm barn colors. Because of the country association, the line has been well received in Kansas. Most of these paints are sold through paint and hardware stores as the stores second or third line of paint. The large national firms such as Benjamin Moore or Sherwin-Williams provide extensive services to paint retailers such as computerized color matching equipment. Partly because it lacks the resources to provide such amenities and partly because it has always considered the commercial paint a sideline, Meyer has never tried to market the commercial line aggressively. Meyer sells 38,000 gallons of commercial paint per year. Charlie is worried about the future of the company. The firm's strategic goal is to provide a quality product at the lowest possible cost and in a timely fashion. After absorbing the shock of losing the Kansas contract, Charlie wondered whether the firm should consider increasing production of commercial paints to lessen the company's dependence on traffic paint contracts. Carly Bunch, who manages the day-to-day operations of the firm, believes the company can double its sales of commercial paint if it undertakes a promotional campaign estimated to cost $120,000. The average price of traffic paint sold last year was $25 per gallon. For commercial paint, the average price was $29 per gallon. Charlie assembled the following data to evaluate the financial performance of the two lines of paint. The primary raw material used in paint production is latex. The list price for latex is $32 per pound; 450 pounds of latex are needed to produce 1,000 gallons of traffic paint. Commercial paint requires 325 pounds of latex per 1,000 gallons of paint. In addition to the cost of the latex, other variable costs are shown below: Traffic Commercial Raw materials cost per 1 gallon of paint: Camelcarb (limestone) $1.76 $2.08 Silica 1.74 2.04 Pigment 1.24 1.76 Other ingredients 1.12 1.06 Direct labor cost per gallon 0.92 1.70 Freight cost per gallon 1.56 0.86 Last year, fixed overhead costs attributable to the traffic paint totaled $170,000, including an estimated $50,000 of costs directly associated with the Kansas contract; the $50,000 can be eliminated. Fixed overhead costs attributable to the commercial paint are $26,000. Other fixed manufacturing overhead costs totaled $220,000. Charlie estimates that $100,000 of this amount is inventory handling costs that will be avoided due to the loss of the Kansas contract. Both the remaining fixed manufacturing overhead ($120,000) and the general and administrative costs ($280,000) are allocated equally to all gallons of paint produced. For the assignment, you must answer the four questions. I suggest working in Excel and then copying your tables into a Word document. Some of the points will be based on table formatting. You can email me your answers to Part 1, Scenario A and B before the end of the day on 4/23 and I will let you know how it looks. 1. Answer the following questions. Please note that each of the following is an independent scenario: Scenario A: Current production, including the Kansas contract: (a) What is the contribution margin per unit (to 2 decimal places) for each of the two product lines? (b) What is the total contribution margin for the company (rounded to the nearest whole dollar)? Scenario B: Without either the Kansas contract or the promotion to expand sales of commercial paint: What is the total contribution margin for the company, after considering the savings on inventory-handling costs? Scenario C: Without the Kansas contract, but with the promotion to expand sales of the commercial paint: What is the total contribution margin for the company, after considering the savings on inventory handling costs and the cost of the special promotion? 2. Based solely on the financial analysis performed in part 1, state whether scenario B or C should be chosen by Meyer since scenario A will not happen with the loss of the Kansas contract. 3. What are the primary strategic considerations associated with the decision addressed in part 2? 4. Prepare a sensitivity analysis in which the sales of commercial paint are projected to increase by only 30% rather than 100%. Recalculate the estimated total contribution margin associated with scenario C. Which of the scenario B and C has the higher projected total contribution margin (to the nearest whole dollar)? What does this suggest about scenario C? 1. Scenario A: Scenario A: Quantity Sales Traffic 342,000 $25.00 Commercial 38,000 $29.00 Total 380,000 Raw Materials Latex Camelcarb Silica Pigment Other Ingredients Direct Labor Freight Cost Variable Costs Contribution Margin per unit Total Contribution Margin $14.40 $1.76 $1.74 $1.24 $1.12 $0.92 $1.56 $22.74 $2.26 $772,920 $10.40 $2.08 $2.04 $1.76 $1.06 $1.70 $0.86 $19.90 $9.10 $345,800 $1,118,720 Scenario B: Scenario B: Quantity Sales Traffic 254,000 $25.00 Commercial 38,000 $29.00 Total 292,000 Raw Materials Latex Camelcarb Silica Pigment Other Ingredients Direct Labor Freight Cost Variable costs Contribution Margin per unit Total Contribution Margin $14.40 $1.76 $1.74 $1.24 $1.12 $0.92 $1.56 $22.74 $2.26 $574,040 $10.40 $2.08 $2.04 $1.76 $1.06 $1.70 $0.86 $19.90 $9.10 $345,800 $919,840 Scenario C: Scenario Quantity Sales Traffic 254,000 $25.00 Commercial 76,000 $29.00 Total 330,000 Raw Materials Latex Camelcarb Silica Pigment Other Ingredients Direct Labor Freight Cost Variable costs Contribution Margin per unit Total Contribution Margin $14.40 $1.76 $1.74 $1.24 $1.12 $0.92 $1.56 $22.74 $2.26 $574,040 $10.40 $2.08 $2.04 $1.76 $1.06 $1.70 $0.86 $19.90 $9.10 $691,600 $1,265,640 2. Scenario C should be chosen 3. Scenario C has a higher profit and lower risk due to market diversification. There is also expansion in the Commercial paint market and less reliance on the Traffic paint market