Prepare a brief report for the president and CEO of BAT Car Company.

Description

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 BAT’s 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 year’s operation look to be $10 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 describe how the quantitative analysis approach can be applied to this situation;

BAT’s profit formula results;

BAT’s break-even point; and

Last Completed Projects