Imagine you are a business analytics employee at BAT Car Company. The president and CEO of BAT have tasked you with providing them with a data plan addressing expansion of BATs production business into Frankfurt, Germany, on a $4 million Model Z plant.

All economic and environmental impact studies have been approved. The size of the plant is predicted to be 420 soccer fields in size (a soccer field is 100 yards wide by 130 yards long). The car sales are expected to be $30,000 per auto. It will create 10,000 jobs for Frankfurt and the surrounding areas.

There have been some issues with protestors regarding the building of an automotive plant that destroys forestland valued at $350 million. There has been some rumbling regarding a group called Save The Forest that could implement a cease all actions lawsuit against BAT. Research has shown that previous lawsuits and environmental impact has led to years of litigation and legal fees.

The variable costs for the first years operation look to be $5 million with increases by 25% each year over the next 5 years after 2020 occupancy. Sales are expected to be 500,000 units.

Prepare a brief report for the president and CEO of BAT Car Company. Your report should include the following elements:

• an introduction section that describes how the quantitative analysis approach can be applied to this situation;
• BATs profit formula results;
• BATs break-even point; and
• your final recommendation on actions to take. (This section should convey to the CEO if the expansion of the production plant is profitable to BAT over the long haul, as well as how to deal with any possible litigation.)