Alternative 1: Construct a single plant in Indianapolis, Indiana, with a monthly production capacity of 300,000 cases, a monthly fixed cost of $262,500, and a variable cost of $3.25 per case. Alternative 2: Construct three plants, one each in Muncie, Indiana; Normal, Illinois; and Dayton, Ohio, with capacities of 120,000, 100,000, and 80,000, respectively, and monthly fixed costs of $120,000, $110,000, and $95,000 each. Variable costs would be only $3 per case because of lower distribution costs. To achieve these cost savings, sales from each smaller plant would be limited to demand within its home state. The total estimated monthly sales volume of 200,000 cases in these three Midwestern states is distributed as follows: 80,000 cases in Indiana, 70,000 cases in Illinois, and 50,000 cases in Ohio.
Chapter 8, Problem 8P
Problem
Multiplant Operation. Appalachia Beverage Company, Inc. is considering alternative proposals for expansion into the Midwest.
Alternative 1: Construct a single plant in Indianapolis, Indiana, with a monthly production capacity of 300,000 cases, a monthly fixed cost of $262,500, and a variable cost of $3.25 per case.
Alternative 2: Construct three plants, one each in Muncie, Indiana; Normal, Illinois; and Dayton, Ohio, with capacities of 120,000, 100,000, and 80,000, respectively, and monthly fixed costs of $120,000, $110,000, and $95,000 each. Variable costs would be only $3 per case because of lower distribution costs. To achieve these cost savings, sales from each smaller plant would be limited to demand within its home state. The total estimated monthly sales volume of 200,000 cases in these three Midwestern states is distributed as follows: 80,000 cases in Indiana, 70,000 cases in Illinois, and 50,000 cases in Ohio.
A. Assuming a wholesale
B. At a wholesale price of $5 per case in all states, and assuming sales at the projected levels, which alternative expansion scheme provides Appalachia with the highest profit per month?
C. If sales increase to production capacities, which alternative would prove to be more profitable?
use excel
show formula
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images
