Traffic Paint Currently, Welle

Traffic Paint

Currently, Wellesley has the traffic paint contracts for thestates of Pennsylvania, North Carolina,

Delaware, and Virginia. Of last year’s total production of380,000 gallons, 90% was traffic

paint. Of this amount, 88,000 gallons were for the Virginiacontract. Each state has unique specifications

for color, thickness, texture, drying time, and othercharacteristics of the paint. For example,

paint sold to Pennsylvania must withstand heavy use of salt onroads during the winter.

Paint for North Carolina highways must tolerate extended periodsof intense heat during summer

months.

The process of bidding on a traffic paint contract begins with aroad test under the supervision

of the National Association of Highway Paints (NAHP), anindependent organization supported

by state funds. NAHP designates a certain stretch of highway toserve as the road test site.

Any paint manufacturer may apply stripes of their paint at thetest site. NAHP monitors the test

site and reports the results to the state highway department.State personnel review the reports

and invite the manufacturers of the best-performing paints tosubmit bids. The firm that submits

the lowest bid wins the contract.

Contracts, which normally cover a five-year period, specify onlythe price per gallon and

quality requirements such as drying time and road-life. Thetiming of deliveries is determined

later based on state work schedules and weather constraints.Demand is highly seasonal, as states

do most of their highway painting in June, July, and August. Thetotal amount of paint a state will

order is not determined until spring, when the states know howmuch of their highway budget

remains after winter snow removal costs have been paid.

After the paint is produced, the state must test the paintbefore approving it for shipment. A

sample is sent to the state laboratory, which may take up to twomonths to perform the testing. In

the meantime, Wellesley must store all the manufactured paint inits warehouse. At times, the

warehouse has been filled to capacity, and drums of paint arestored in the aisles, production

areas, and any available inch of space.

Due to the high cost of shipping paint, most paint producers canbe competitive on price

only in locations fairly close to their production facilities.Accordingly, Wellesley has enjoyed an

advantage in bidding on contracts in the eastern states close toVirginia. However, one of their

biggest competitors, Heron Paint Company of Houston, Texas, isbuilding a new plant in North

Carolina. With lower costs due to their efficient new facilityand their proximity, Heron will become

a major competitive threat.

Commercial Paint

Wellesley’s commercial paint line includes interior and exteriorhouse 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 thesepaints 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 paintretailers such as computerized color matching equipment. Partlybecause they lack the resources to provide such amenities

and partly because they have always considered the commercialpaint a sideline, Wellesley has

never tried to market their commercial line aggressively.

Mrs. W. is worried about the future of the company. The firm’sstrategic goal is to provide a

quality product at the lowest possible cost and in a timelyfashion. After absorbing the shock of

losing the Virginia contract, Mrs. W. wondered whether the firmshould consider increasing production

of commercial paints to lessen the company’s dependence ontraffic paint contracts. Her

son, who manages the day-to-day operation of the firm, believesthey can double their sales of

commercial paint if they undertake a promotional campaignestimated to cost $15,000. The average

price of traffic paint sold last year was $9 per gallon. Forcommercial paint, the average price

was $11.

Cost Data

Charlie Oliver has assembled the following data to evaluate thefinancial performance of the

two lines of paint. The primary raw material used in paintproduction is latex. The list price for

latex is $13.50 per pound. If the firm uses more than 150,000pounds annually they qualify for a

10% discount; 450 pounds of latex are needed to produce 1,000gallons 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.

Raw materials cost per gallon of paint: Traffic Commercial

Camelcarb (limestone) 0.38 0.54

Silica 0.37 0.52

Pigment 0.12 0.38

Other ingredients 0.06 0.03

Direct labor cost per gallon 0.46 0.85

Freight cost per gallon 0.78 0.43

Last year, overhead costs attributable to the traffic painttotaled $85,000, including an estimated

$25,000 of costs directly associated with the Virginia contract.Overhead costs attributable

to the commercial paint are $13,000. Other manufacturingoverhead costs total $110,000. Charlie

estimates that $9,000 of this amount is inventory handling coststhat will be avoided due to the

loss of the Virginia contract. Both the remaining manufacturingoverhead and the general and

administrative costs of $140,000 are allocated equally to allgallons of paint produced.

Question:. Calculate the contribution margin(selling price minus variable costs) and gross margin

(selling price minus all manufacturing costs) per gallon foreach type of paint and total firm-wide

profit under each of the following scenarios:

Scenario A Current production, including the Virginiacontract

Scenario B Without either the Virginia contract or the promotionto expand sales of commercial

paint

Scenario C Without the Virginia contract but assuming thepromotional campaign is undertaken

and sales of commercial paint do in fact double

What insight is provided by a comparison of Scenarios A and B?What insight is provided by

a comparison of Scenarios B and C?

Answer:

Scenario A
Traffic Commercial Total
Production                       342,000                       38,000             380,000
Latex needed to produce 1000 gallons ofpaint                               450                             325
Latex needed                       153,900                       12,350             166,250
(342000/1000*450) (38000/1000*325)
Cost per pound of latex (10% discountapplicable)                            12.15                         12.15
Latex needed per gallon                              0.45                           0.33
Cost per gallon of paint                              5.47                           3.95
Camel carb                              0.38                           0.54
Silica                              0.37                           0.52
Pigment                              0.12                           0.38
Other Ingredients                              0.06                           0.03
Direct Labor per gallon                              0.46                           0.85
Freight cost per gallon                              0.78                           0.43
Total cost per gallon                              7.64                           6.70
Total Variable cost                   2,612,025                    254,553          2,866,578
Sales per gallon                              9.00                         11.00
Sales                   3,078,000                    418,000          3,496,000
Variable cost                   2,612,025                    254,553          2,866,578
Contribution                       465,975                    163,448             629,423
Contribution per gallon                              1.36                           4.30                    1.66
Overhead cost                         85,000                       13,000               98,000
Other Manufacturing cost for virginiacontract                            9,000                                –                   9,000
Other Manufacturing allocated                         90,900                       10,100             101,000
Gross Margin                       281,075                    140,348             421,423
Gross Margin per gallon                              0.82                           3.69                    1.11
General and Administrative Costs                       126,000                       14,000             140,000
Net Income                       155,075                    126,348             281,423
Scenario B
Traffic Commercial Total
Production                          254,000                          38,000       292,000
Latex needed to produce 1000 gallons ofpaint                                  450                                325
Latex needed                          114,300                          12,350       126,650
(254000/1000*450) (38000/1000*325)
Cost per pound of latex                               13.50                            13.50
Latex needed per gallon                                 0.45                               0.33
Cost per gallon of paint                                 6.08                               4.39
Camel carb                                 0.38                               0.54
Silica                                 0.37                               0.52
Pigment                                 0.12                               0.38
Other Ingredients                                 0.06                               0.03
Direct Labor per gallon                                 0.46                               0.85
Freight cost per gallon                                 0.78                               0.43
Total cost per gallon                                 8.25                               7.14
Total Variable cost                      2,094,230                        271,225    2,365,455
Sales per gallon                                 9.00                            11.00
Sales                      2,286,000                        418,000    2,704,000
Variable cost                      2,094,230                        271,225    2,365,455
Contribution                          191,770                        146,775       338,545
Contribution per gallon                                 0.76                               3.86             1.16
Overhead cost                            60,000                          13,000          73,000
Other Manufacturing cost for virginiacontract                                      –                                     –                    –  
Other Manufacturing allocated                            87,856                          13,144       101,000
Gross Margin                            43,914                        120,631       164,545
Gross Margin per gallon                                 0.17                               3.17             0.56
General and Administrative Costs                          121,781                          18,219       140,000
Net Income –                          77,867                        102,412          24,545
Scenario C
Traffic Commercial Total
Production                          254,000                          76,000       330,000
Latex needed to produce 1000 gallons ofpaint                                  450                                325
Latex needed                          114,300                          24,700       139,000
(254000/1000*450) (76000/1000*325)
Cost per pound of latex                               13.50                            13.50
Latex needed per gallon                                 0.45                               0.33
Cost per gallon of paint                                 6.08                               4.39
Camel carb                                 0.38                               0.54
Silica                                 0.37                               0.52
Pigment                                 0.12                               0.38
Other Ingredients                                 0.06                               0.03
Direct Labor per gallon                                 0.46                               0.85
Freight cost per gallon                                 0.78                               0.43
Total cost per gallon                                 8.25                               7.14
Total Variable cost                      2,094,230                        542,450    2,636,680
Sales per gallon                                 9.00                            11.00
Sales                      2,286,000                        836,000    3,122,000
Variable cost                      2,094,230                        542,450    2,636,680
Contribution                          191,770                        293,550       485,320
Contribution per gallon                                 0.76                               3.86             1.47
Overhead cost                            60,000                          13,000          73,000
Other Manufacturing cost for virginiacontract                                      –                                     –                    –  
Other Manufacturing allocated                            77,739                          23,261       101,000
Gross Margin                            54,031                        257,289       311,320
Gross Margin per gallon                                 0.21                               3.39             0.94
General and Administrative Costs                          107,758                          32,242       140,000
Prmotional Campaign cost                                      –   15000          15,000
Net Income –                          53,727                        210,047       171,320

Sceanrio A & B comparison

Due to less use of latex, since the Virginia contract is lost,the firm lost the discount on latex. this added to cost of pergallon of latex. Without the virginia contract, the traffic paintdivision is operating at a loss. Commercial paint department isclearly more profitable than traffic paint. However the volume oftraffic paint sale is more than commercial paint. For traffic paintdepatmet to operate at aprofit they need to increase the sales.this will make them elgible for discount on latex.

Scenarios B& C

Even though the sale of commercial paint has doubled, the firmis still not eligible for latex discount. Theres is no change incontriibution per unit fromScenaio B to C. There was not enoughincrease in sales units to bring down the per unit variablecost.


 
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.