Concept explainers
(a)
Interpretation:Best Location needs to be determined using location analysis technique with the help of given data
Concept Introduction: The location analysis method helps in determining the optimal location to run a business efficiently.
(a)
Explanation of Solution
Given Information:
CP Location Analysis Data | Location 1 | Location 2 | Location 3 | Location 4 | Location 5 |
Fixed Costs | $ 75,000 | $ 110,000 | $ 95,000 | $ 125,000 | $110,000 |
Direct Material Cost/Unit | $ 4.14 | $ 4.65 | $ 5.05 | $ 4.50 | $ 4.50 |
Direct Labor Cost /Unit | $ 12.45 | $13.80 | $ 11.80 | $ 15.60 | $ 13.75 |
Overhead/unit | $ 2.25 | $ 2.60 | $ 1.95 | $ 2.75 | $ 2.10 |
Transportation Cost/Unit | $0.5 | $ 0.65 | $ 0.30 | $0.83 | $0.67 |
Estimated Annual Production: 30,000 units
The formula for calculating Direct Material cost, Direct Labor cost, Overhead Cost and
Transportation Cost is as follows:
Direct Material Cost = (Direct Material Cost/unit) x Estimated Annual Production
Direct Labor Cost = (Direct Labor Cost/unit) x Estimated Annual Production
Overhead Cost = (Overhead Cost/unit) x Estimated Annual Production
Transportation Cost = (Transportation Cost/unit) x Estimated Annual Production
Associated Costs | Location 1 | Location 2 | Location 3 | Location 4 | Location 5 |
Fixed Costs | $ 75,000 | $ 110,000 | $ 95,000 | $ 125,000 | $110,000 |
Direct Material Cost | $ 124,200 | $ 139,500 | $ 1,51,500 | $ 135,000 | $ 135,000 |
Direct Labor Cost | $ 373,500 | $ 414,000 | $ 354,000 | $ 468,000 | $ 412,500 |
Overhead | $ 67,500 | $ 78,000 | $ 58,500 | $ 82,500 | $ 63,000 |
Transportation Cost | $ 15,000 | $ 19,500 | $ 9,000 | $ 24,900 | $ 20,100 |
Total | $ 655,200 | $ 761,000 | $ 668,000 | $ 835,400 | $ 740,600 |
As per data calculated above, Location 1 provides the least cost.
(b)
Interpretation:Best Location needs to be determined using location analysis technique with the help of given data
Concept Introduction: The location analysis method helps in determining the optimal location to run a business efficiently.
(b)
Explanation of Solution
Associated Costs | Location 1 | Location 2 | Location 3 | Location 4 | Location 5 |
Fixed Costs | $ 75,000 | $ 110,000 | $ 95,000 | $ 125,000 | $110,000 |
Direct Material Cost | $ 124,200 | $ 139,500 | $ 1,51,500 | $ 135,000 | $ 135,000 |
Direct Labor Cost | $ 373,500 | $ 414,000 | $ 354,000 | $ 468,000 | $ 412,500 |
Overhead | $ 67,500 | $ 78,000 | $ 58,500 | $ 82,500 | $ 63,000 |
Transportation Cost | $ 15,000 | $ 19,500 | $ 9,000 | $ 24,900 | $ 20,100 |
Total | $ 655,200 | $ 761,000 | $ 668,000 | $ 835,400 | $ 740,600 |
As per the data calculated above, it can be clearly seen that the order of locations on basis of the lower to higher cost is Location 1 < Location 3 < Location 5 < Location 2 < Location 4.
The total cost associated with Location 2,4 and 5 is considerably high than location 1 and 3.
An appropriate range will be calculated below by comparing the Location 1 and 3.
Let’s assume the demand rate be x.
Total variable cost associated with Location 1 is = $ 19.34
Total Variable cost associated with Location 3 is = $ 19.10
So, the equation to calculate appropriate quantity will be:
By solving above equation, we get
It means that if demand rate is less than 83,333 units, then location 1 will be preferred and otherwise location 3 is chosen if demand exceeds 83,333 units.
Want to see more full solutions like this?
- An operations manager has narrowed down the search for a new King Kola plant to three locations. Fixed and variable costs follow. Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 Plot the total cost curves in the chart provided above and identify the range over which each location would be best. Use break-even analysis to calculate exactly the break-even quantity that defines each range.arrow_forwardWiebe Trucking, Inc., is planning a new warehouse to servethe western United States. Denver, Santa Fe, and Salt LakeCity are under consideration. For each location, annual fixedcosts (rent, equipment, and insurance) and average variablecosts per shipment (labor, transportation, and utilities) arelisted in the following table. Sales projections range from550,000 to 600,000 shipments per year.a. Plot the total cost curves for all the locations on a singlegraph.b. Which city provides the lowest overall costs?arrow_forwardThe method for determining facility location which involves determining x and y co-ordinates of the proposed new location O a. Factor Rating Method O b. Locational Break-even Analysis O C. Transportation Method Od. Centroid Methodarrow_forward
- Wiebe Trucking, Inc., is planning a new warehouse to servethe western United States. Denver, Santa Fe, and Salt LakeCity are under consideration. For each location, annual fixedcosts (rent, equipment, and insurance) and average variablecosts per shipment (labor, transportation, and utilities) arelisted in the following table. Sales projections range from500,000 to 600,000 shipments per year. a. Plot the total cost curves for all the locations on a singlegraph.b. Which city provides the lowest overall costs?arrow_forwardLocation planning is part of strategic planning, briefly explain why?arrow_forwardFind examples of good and bad location decisionsarrow_forward
- When an organization is determining a location choice, what sustainability issues should it consider? What ethical issues should be considered?arrow_forwardWiebe Trucking, Inc., is planning a new warehouse to serve the western United States. Denver, Santa Fe, and Salt Lake City are under consideration. For each location, annual fixed costs (rent, equipment, and insurance) and average variable costs per shipment (labor, transportation, and utilities) are listed in the following table. Sales projections range from 550,000 to 600,000 shipments per year. Location Annual fixed cost Variable Costs per Shipment Denver $5,000,000 $4.65 Santa Fe $4,200,000 $6.25 Salt Lake City $3,500,000 $7.25 a. Plot the total cost curves for all the locations on a single graph. b. Which city provides the lowest overall costs? Thank you!!!arrow_forwardExplain what is the technique that is being used for screening potential locations for services?arrow_forward
- Select two organizations, one in services and one in manufacturing. What are the key factors that each organization would consider in locating a new facility? What data would you want to collect before evaluating the location options, and how would you collect the data? Explain.arrow_forwardhow to setup an example of a numerical centre of gravity location technique (for production and operations management) that can be used to demonstrate how the technique is used for a distribution centre?arrow_forwardTexas Seasonings is considering three alternative locations for a new plant for producing its seasoning. Below are the associated fixed and variable costs. Assume the revenue is the same regardless of plant location. Which location will never be preferred, and why?arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,