Reference no: EM132814258
A manufacturing firm is planning to open a new factory. There are four countries under consideration: USA, Canada, Mexico, and Panama. The table below lists the fixed costs and variable costs for each site. The product is mainly sold in the U.S. for $495 per unit.
Location Fixed cost variable cost
Canada 5,000,000 210
Mexico 1,500,000 250
USA 3,000,000 230
Panama 500,000 300
a- Using cross-over analysis, find the range of production that makes each location optimal with lowest total cost.
b- Using Excel, construct total production cost linear graph for all 4 locations and verify cross-over points obtained in part (a). In your graph, use quantity values from 0 to 250,000 at increment of 10,000.
c- If the company forecasts that market demand will be around 150,000 per year, which country
is the best choice and what is the yearly profit?
d- Construct Total cost, Total revenue, and Total profit graphs for the optimal location in part (C).
|
Minimum total annual cost for managing inventory item
: What is the minimum total annual cost (ordering + holding + purchase) for managing this inventory item?
|
|
Describe network attacks and suggest countermeasures
: Describe network attacks and suggest countermeasures - Describe the five social norms of hacker subculture and provide an example of each
|
|
Determine the optimal order quantity of planters for hg
: The Home and Garden (HG) chain of superstores imports decorative planters from Italy. Weekly demand for planters averages 1,500 with a standard deviation of 800
|
|
Compute the total annual cost of ordering
: Victor sells a line of upscale evening dresses in his boutique. He charges $300 per dress, and sales average 30 dresses per week.
|
|
Find the range of production
: A manufacturing firm is planning to open a new factory. There are four countries under consideration: USA, Canada, Mexico, and Panama. The table below lists the
|
|
Examine an emerging or current issue in health care
: Examine the influence of political, economic, and social factors and the impact of the U.S. health-care system on an emerging or current health care issue
|
|
What percentage of time is judy idle
: Students arrive at the Administrative Services Office at an average of one every 6 minutes, and their requests take, on average, 4 minutes to be processed
|
|
Monitor managers decision-making
: For Southwest Airlines, What internal governance mechanisms would you propose to monitor managers' decision-making?
|
|
Marketing mix in relation to the scope of the project
: Marketing mix in relation to the scope of the project listed below. Detail must be provided on the existing product, price, place and promotion strategies
|