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 describes how the quantitative analysis approach can be applied to this situation;
BAT’s profit formula results;
BAT’s 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.)
Your final report must be at least two pages in length, and you must show all of your computations
You can also view a PDF of the Unit I Practice Problem Activity.
You should use at least two academic sources in your report, one of which may be your textbook. Adhere to APA Style when constructing this assignment, including in-text citations and references for all sources that are used. Please note that no abstract is needed.
Textbook attached Render, B., Stair, R. M., Jr., Hanna, M. E., & Hale, T. S. (2018). Quantitative analysis for management (13th ed.). Pearson.