Question

“I’m not looking forward to breaking the news,” groaned Charlie Wettle, the controller of Miller Paint Company. He and Ron Smith, state liaison for the firm, were returning from a meeting with representatives of the Virginia General Services Administration (GSA), the agency that administers bidding on state contracts. Charlie and Ron 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 Miller’s paint samples had performed poorly on the road test and the firm was not eligible to bid on the contract.

Miller’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 their paint. 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 Miller.

Currently, Miller has the traffic paint contracts for the states of Pennsylvania, North Carolina, Delaware, and Virginia. Of last year’s total production of 380,000 gallons, 90 percent was traffic paint. Of this amount, 88,000 gallons were for the Virginia contract. Each state has unique specifications for color, thickness, texture, drying time, and other characteristics of the paint. For example, paint sold to Pennsylvania must withstand heavy use of salt on roads during the winter. Paint for North Carolina 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, Miller has enjoyed an advantage in bidding on contracts in the eastern states close to Virginia. However, one of their biggest competitors, Heron Paint Company of Houston, Texas, is building a new plant in North Carolina. With lower costs due to their efficient new facility and their proximity, Heron will become a major competitive threat.

Miller’s commercial paint line includes interior and exterior house paints in a wide range of colors formulated to approximate authentic colonial colors. Because of the historical association, the line has been well received in Virginia. 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 they lack the resources to provide such amenities and partly because they have always considered the commercial paint a sideline, Miller has never tried to market their commercial line aggressively. Miller 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 Virginia contract, Charlie wondered whether the firm should consider increasing production of commercial paints to lessen the company’s dependence on traffic paint contracts. Carl Bunch, who manages the day-to-day operation 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 $20 per gallon. For commercial paint, the average price was $24.

Charlie Wettle has 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 as shown below.

		Traffic	Commercial
Raw materials cost/gallon of paint:
Camelcarb		$0.76	$1.08
Silica		$0.74	$1.04
Pigment		$0.24	$0.76
Other ingredients		$0.12	$0.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 $85,000, including an estimated $25,000 of costs directly associated with the Virginia contract; the $25,000 can now be eliminated. Fixed overhead costs attributable to the commercial paint are $13,000. Other manufacturing overhead costs total $110,000. Charlie estimates that $40,000 of this amount is inventory handling costs that will be avoided due to the loss of the Virginia contract. Both the remaining manufacturing overhead and the general and administrative costs of $140,000 are allocated equally to all gallons of paint produced.

Requirements:

Prepare a memo that addresses your responses to the two questions outlined below:

1. Calculate the contribution margin for each type of paint and total firm-contribution under each of the following scenarios:

     Scenario A        Current production, including the Virginia contract

Scenario B        Without either the Virginia contract or the promotion to expand sales of commercial paint

Scenario C        Without the Virginia contract but with the promotion to expand sales of the commercial paint

2. Determine whether scenario B or C (per Part 1 above) should be chosen by Miller and explain why, including a consideration of the strategic context.

Format:

Assume the role of Carl Bunch, a managerial accountant who helps manage the day to day operations of the firm. Carl is writing to Charlie in his memo.

Your response should be in standard memo format and one page at a minimum. Your paper should be single spaced, except for double spaces between paragraphs. You should use an appropriate introduction, develop a body that outlines your recommendations, and use an appropriate conclusion that includes a “call to action” for the reader. Introductions and conclusions do not require the use of headers, but the remaining paragraphs should have bold headers that alert the reader of the subject matter to follow. Please use Times New Roman, 12 point font.

Please submit your final memo assignment via Blackboard by the beginning of class on Friday, May 11^th.

Answer 1

The below mentioned analysis discusses the firms strategy to

a) Either continue with the current sales ratio

b) Exit Virginia contract and do not expend on promotion

c) Exit Virginia contract and expend $120,000 on promotion

Scenario A
	Traffic (A)	Units (B)	(A*B)		Units (B)	(A*B)
Camel carb	0.76	342000	259,920	1.08	38000	41,040
Silica	0.74	342000	253,080	1.04	38000	39,520
Pigment	0.24	342000	82,080	0.76	38000	28,880
Other	0.12	342000	41,040	0.06	38000	2,280
Direct Labour	0.92	342000	314,640	1.7	38000	64,600
Freight Cost	1.56	342000	533,520	0.86	38000	32,680
Latex		(450/1000*342000)	153,900		(325/1000*38000)	12,350
	Variable Cost		1,638,180			221,350
			Traffic (A)			Commercial (A)
Sales		(342000*20)	6,840,000	(38000*24)		912,000
Less : Variable Cost			1,638,180			221,350
Contribution			5,201,820			690,650

Scenario B
	Traffic (A)	Units (B)	(A*B)		Units (B)	(A*B)
Camel carb	0.76	254000	193,040	1.08	38000	41,040
Silica	0.74	254000	187,960	1.04	38000	39,520
Pigment	0.24	254000	60,960	0.76	38000	28,880
Other	0.12	254000	30,480	0.06	38000	2,280
Direct Labour	0.92	254000	233,680	1.7	38000	64,600
Freight Cost	1.56	254000	396,240	0.86	38000	32,680
Latex		(450/1000*254000)	114,300		(325/1000*38000)	12,350
	Variable Cost		1,216,660			221,350
			Traffic (A)			Commercial (A)
Sales		(254000*20)	5,080,000	(38000*24)		912,000
Less : Variable Cost			1,216,660			221,350
Contribution			3,863,340			690,650
Less : savings in fixed cost			25,000
Savings in man. Overhead cost			40,000
Contribution			3,928,340			690,650

Scenario C
	Traffic (A)	Units (B)	(A*B)		Units (B)	(A*B)
Camel carb	0.76	254000	193,040	1.08	76000	82,080
Silica	0.74	254000	187,960	1.04	76000	79,040
Pigment	0.24	254000	60,960	0.76	76000	57,760
Other	0.12	254000	30,480	0.06	76000	4,560
Direct Labour	0.92	254000	233,680	1.7	76000	129,200
Freight Cost	1.56	254000	396,240	0.86	76000	65,360
Latex		(450/1000*254000)	114,300		(325/1000*76000)	24,700
	Variable Cost		1,216,660			442,700
			Traffic (A)			Commercial (A)
Sales		(254000*20)	5,080,000	(76000*24)		1,824,000
Less : Variable Cost			1,216,660			442,700
Contribution			3,863,340			1,381,300
Less : savings in fixed cost			25,000	Promotional Expense		(120,000)
Savings in man. Overhead cost			40,000
Contrinution			3,928,340			1,261,300

2. Out of the above three scenarios, total contribution of the firm is

Scenario A	5,892,470
Scenario B	4,553,990
Scenario C	5,189,640

Ideally, the company should choose Scenario A and continue with the Virginia contract. However, if it loses out the Viginia contract, the company should expend $120,000 on promotion and double the sales of commercial paint.