Sunshine Valley is a vertically-integrated company which both grows[1] and processes oranges. Their company-grown oranges are canned and then sold wholesale to grocery stores. The company began their operations in Florida in the mid-1990s and the corporate headquarters remain there. Sunsunshine grows a wide variety of organic (non-GMO) oranges in greenhouses, some of which cover more than 200 acres. The oranges are shipped from manufacturing facilities near the greenhouses. This assures the oranges are processed as quickly as possible after being picked which inspired the companys marketing tag line: fresh from the field.

Consumer demand for organically-grown oranges has increased tremendously since Sunshine began operations. Gross revenues increased 500% since they opened 10 years ago. The firm now has five greenhouses and processing plants in multiple locations near the following cities: Sacramento, California; Tampa, Florida; Baton Rouge, Louisiana; Montgomery, Alabama; and Jacksonville, Florida. Their work force totals nearly 600 employees.

Potential Sites: Sunshine is at maximum capacity in all locations and must add another greenhouse and processing plant in order to continue their sales growth to new customers (and to assure they have no out-of-stock issues for existing customers). Both the greenhouse operations for growing the oranges and the canning facility require large volumes of fresh water. It is essential to locate near an interstate highway because all shipments are shipped via semi-trucks.

Two sites are being considered near the towns of Gulfport, Mississippi and Little Rock, Arkansas. Because of the extensive damage caused in Gulfport by Hurricane Katrina in August 2005 (and more recently by Hurricane Harvey), the cost of real estate in that area is significantly lower than in Little Rock.

Estimated Operating Costs: Estimates of operating costs for the two locations are as follows:

Gulfport Little Rock

Life of greenhouse & processing plant 50 years 50 years

Expected annual sales (# cases) 300,000 300,000

Selling price (average per case) $90 $90

Variable costs (average per case) $60.00 $60.00

Fixed Costs (annual):

Salaries & fringe benefits (labor is higher in L.R.) $1,300,000 $1,500,000

Depreciation* $445,000 $475,000

Other fixed costs $655,000 $655,000

Total Fixed Costs $2,400,000 $2,630,000

*Straight-line depreciation over 50 years, calculated based on the initial investment in buildings with -0- salvage. Equipment is depreciated using straight-line over 20 years with -0- salvage value. Land is not depreciated. Calculation has been simplified more than would be in business...only for use in this problem.

Estimated Capital Investment: Sunburst has some used greenhouse equipment which they could transfer from one of their existing locations to either Gulfport or Little Rock. The book value of that equipment is $1,900,000 and requires some modifications up-front (cost of $100,000) to get it ready for use in either location. They already own some used manufacturing equipment that can be transferred to either new location; this has a book value of $1,000,000 (and, does not require any modification). The summary of the estimated initial capital investment in each of the two locations follows:

Gulfport Little Rock

Land $4,000,000 $7,500,000

Greenhouse Buildings $3,500,000 $4,000,000

Manufacturing Building $10,000,000 $11,000,000

Sub-total for Buildings $13,500,000 $15,000,000

Greenhouse Equipment (used):

Book value (transferred) $1,900,000 $1,900,000

Modifications (up-front) $100,000 $100,000

Manufacturing Equipment (used):

Book Value (transferred) $1,000,000 $1,000,000

Other equipment (to be capitalized) $500,000 $500,000

Sub-total for Equipment $3,500,000 $3,500,000

Total $21,000,000 $26,000,000

Depreciation Calculations (as shown in total on previous page):

Gulfport Buildings $13,5000,000 / 50 years = $270,000

Gulfport Equipment $3,500,000 / 20 years = $175,000

Total Depreciation Gulfport = $445,000

Little Rock Buildings $15,000,000 / 50 years = $300,000

Little Rock Equipment $3,500,000 / 20 years = $175,000

Total Depreciation Little Rock = $475,000

Other Relevant Information:

Minimum desired rate of return is 12%.

All current locations are earning an average 14% return on sales.

Payback period for all prior capital investments has been not more than 3.75 years.

For simplicity, assume there are no income taxes.

REQUIRED QUANTITATIVE ANALYSIS (Use formulas/cell references):

_______________________________________________________________________________________

QUESTIONS:

1. Prepare an Income Statement in the Contribution Margin format for both locations.

2. Calculate Breakeven Point (in Sales Dollars) for each location

Template for Answer:

Gulfport 0 years 300,000 $90 $60.00 Little Rock 50 years 300,000 $90 $60.00 Life of greenhouse & processing plant Expected annual sales (# cases) Selling price (average per case) Variable costs (average per case) Fixed Costs (annual) Salaries & fringe benefits (labor is higher in L.R.) Depreciation* Other fixed costs Total Fixed Costs $1,300,000 $445,000 $655,000 $1,500,000 $475,000 $655,000 Gulfport $4,000,000 Little Rock $7,500,000 Land $3,500,000 Greenhouse Buildings Manufacturing Building $4,000,000 $10,000,000 11,000,000 $13,500,000 $15,000,000 Sub-total for Buildings Greenhouse Equipment (used) Book value (transferred) Modifications (up-front) $1,900,000 $100,000 $1,900,000 $100,000 Manufacturing Equipment (used) $1,000,000 500,00 $3,500,000 $1,000,000 $500,000 $3,500,000 Book Value (transferred) Other equipment (to be capitalized) Sub-total for Equipment Total $21 , 000,000