Question: Fixed and variable costs for four potential plant locations are shown below: Location-------------------Fixed Cost------------------------Variable cost A----------------------------------50000-------------------------------------95 B----------------------------------80000-------------------------------------65 C----------------------------------130000-------------------------------------45 a) Find the most economical location for

Fixed and variable costs for four potential plant locations are shown below:

Location-------------------Fixed Cost------------------------Variable cost

A----------------------------------50000-------------------------------------95

B----------------------------------80000-------------------------------------65

C----------------------------------130000-------------------------------------45

a) Find the most economical location for an expected volume of 2000 units per year. ( attach the answer in the field ) (1 Mark )

b) Using Excel, find the volume range/location recommendations. ( 2 Marks)

( Attach the locational cost volume chart and excel solutions)

Fixed and variable costs for four potential plant

Fixed and variable costs for four potential plant locations are shown below: Location -- --Variable cost -95 -Fixed Cost- ---50000-- --80000-- - 130000-- B- --65 --45 a) Find the most economical location for an expected volume of 2000 units per year. (attach the answer in the field ) (1 mark) b) Using Excel, find the volume range/location recommendations. ( 2 Marks) (Attach the locational cost volume chart and excel solutions)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!