Question

In: Operations Management

Options for company XYZ to set up production at different locations are provided below. Location Fixed...

Options for company XYZ to set up production at different locations are provided below.

Location Fixed Costs Variable Costs
A $60,000 $        5.00
B $50,000 $        7.00
C $70,000 $        2.50
Given the fixed and variable costs for different locations above, find the most suitable range of production for each of the following location:
a. What is the most suitable production range for C?
b. What is the most suitable production range for B?
Note: format of answer would use terms such as "greater than" or "less than" or "between" in the context of quantity.

Solutions

Expert Solution

Hi,

Please find answer as below. If you like the answer, please up vote.

Answer

Please find graph of total cost of different locations for different quantity.

Total Cost = Fixed cost + (Variable cost per unit * Qty )

Total Cost Graph -

From Above grapgh, we can say that,Location - A at any quantity does not have low cost.

Hence, Location B or Location C has low cost compare to Location A.

Intersection Quantity of Cost line of location B and Location C

Total cost of Location B = Total Cost of Location C

50,000 + ( 7 * Qty ) = 70,000 + (2.5 * Qty)

4.5 * Qty = 20,000

Qty = 4444.44

Hence For qty less and equal to 4444, Location B has low cost

For Qty greater and equal to 4445, Location C has lowest cost

Hence ,

a. Suitable production range for C

Ans. Productin Qty 4445

B. Suitable production range for B

Ans. Productin Qty 4444



Related Solutions

Fixed and variable costs for four potential plant locations are shown below: Location Fixed Cost Variable...
Fixed and variable costs for four potential plant locations are shown below: Location Fixed Cost Variable Cost per Year per Unit A $200,000 $18 B $120,000 $25 C $150,000 $20 D $250,000 $18 not using excel please. The maximum production volume is 40,000 units. Find the best location based on the maximum production volume. Find the volume range/location recommendations.
4. The following data set represent the percentage of gold from two different locations: Location A...
4. The following data set represent the percentage of gold from two different locations: Location A 23.6 22.4 18.9 29.8 22.7 25.4 17.5 14.2 29.4 26.1 24.1 22.3 Location B 5.0 6.1 2.3 2.1 7.8 9.2 4.1 2.5 4.2 9.9 1.0 1.2 b) Now consider the two locations as a single data set. What are the mean and the standard deviation of the gold percentage for this data set? c) Using the empirical rule, determine what range of values captures...
The Janie Gioffre Drapery Company makes three types of draperies at two different locations. At location...
The Janie Gioffre Drapery Company makes three types of draperies at two different locations. At location I, it can make 10 pairs of deluxe drapes, 20 pairs of better drapes, and 13 pairs of standard drapes per day. At location II, it can make 20 pairs of deluxe, 50 pairs of better, and 6 pairs of standard per day. The company has orders for 3000 pairs of deluxe drapes, 6300 pairs of better drapes, and 1800 pairs of standard drapes....
XYZ Federal Agency has multiple locations in different parts of the United States. It is going...
XYZ Federal Agency has multiple locations in different parts of the United States. It is going to start a BPM project for its Office of Human Resource (OHR/HR) functions. The Human Resource system is currently on a thirty-year old mainframe that is shared by another large user. The other user of the mainframe is in the process of redesigning to another platform. That will leave the huge cost of the legacy system to be paid by the HR function. A...
Company XYZ has two fixed price contracts for two different clients. The company has enough capacity...
Company XYZ has two fixed price contracts for two different clients. The company has enough capacity for both contracts but is uncertain whether they will be profitable. Data as follows: Customer                                  AAA                BBB Component Type                         A999                B999 Contract Value($)                       $27,000            $100,000 Contract Quantity                      1,000 unit          2,000 units Material cost/unit                        $15                  $20 Molding time/batch                     5 hours            7.5 hours          Batch Size                                 100 units          50 units Annual Budgeted overheads as follows: Activity                                    Cost Driver                 Cost driver       Cost                       volume/year   pool Molding                                    Molding hours                2,000                $150,000 Inspection                                 Batches                        150                  $75,000 Production Mgmt                       Contracts                      20                    $125,000    Calculate the activity-based costs and profits for each contract. Company XYZ has two fixed price contracts...
Company XYZ has two fixed price contracts for two different clients. The company has enough capacity...
Company XYZ has two fixed price contracts for two different clients. The company has enough capacity for both contracts but is uncertain whether they will be profitable. Data as follows: Customer                                  AAA                BBB Component Type                         A999                B999 Contract Value($)                       $27,000            $100,000 Contract Quantity                      1,000 unit          2,000 units Material cost/unit                        $15                  $20 Molding time/batch                     5 hours            7.5 hours          Batch Size                                 100 units          50 units Annual Budgeted overheads as follows: Activity                                    Cost Driver                 Cost driver       Cost                       volume/year   pool Molding                                    Molding hours                2,000                $150,000 Inspection                                 Batches                        150                  $75,000 Production Mgmt                       Contracts                      20                    $125,000    Calculate the activity-based costs and profits for each contract.
Company XYZ has two fixed price contracts for two different clients. The company has enough capacity...
Company XYZ has two fixed price contracts for two different clients. The company has enough capacity for both contracts but is uncertain whether they will be profitable. Data as follows: Customer AAA BBB Component Type A999 B999 Contract Value($) $27,000 $100,000 Contract Quantity 1,000 unit 2,000 units Material cost/unit $15 $20 Molding time/batch 5 hours 7.5 hours    Batch Size 100 units 50 units Annual Budgeted overheads as follows: Activity Cost Driver Cost driver Cost volume/year pool Molding Molding hours...
Company XYZ has two fixed price contracts for two different clients. The company has enough capacity...
Company XYZ has two fixed price contracts for two different clients. The company has enough capacity for both contracts but is uncertain whether they will be profitable. Data as follows: Customer                                  AAA                BBB Component Type                         A999                B999 Contract Value($)                       $27,000            $100,000 Contract Quantity                      1,000 unit          2,000 units Material cost/unit                        $15                  $20 Molding time/batch                     5 hours            7.5 hours          Batch Size                                 100 units          50 units Annual Budgeted overheads as follows: Activity                                    Cost Driver                 Cost driver       Cost                       volume/year   pool Molding                                    Molding hours                2,000                $150,000 Inspection                                 Batches                        150                  $75,000 Production Mgmt                       Contracts                      20                    $125,000    Calculate the activity-based costs and profits for each contract.   
A company is evaluating the effectiveness of two different training programs to speed up the production...
A company is evaluating the effectiveness of two different training programs to speed up the production process.   The employees were placed into three groups and their assembly times were recorded in minutes. No Training Training Method 1 Training Method 2 44 48 38 47 52 35 43 43 42 51 39 47 57 49 40 42 41 38 50 37 36 46 40 39 44 45 35 45 41 Test the hypothesis at the .01 level that there is no difference...
An experiment was set up to measure the yield provided by each of the three catalysts...
An experiment was set up to measure the yield provided by each of the three catalysts in a certain reaction. The experiment was repeated three times for each catalyst. The reactor yields, in grams, are below. Catalyst 1: 84.33 90.25 85.62 Catalyst 2: 88.44 89.81 86.53 Catalyst 3: 94.71 91.19 92.81 A) Construct the ANOVA table for this problem. B) Determine if differences exist between the catalysts at alpha = 0.05. If there are differences in the catalysts, perform the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT