Discussion board question (to be completed by 10/28)

Give a real-world example of a business whose success depends primarily on its location.

Case study (to be completed by 10/29)

Using the following web-sites as resources, answer the following questions:

 

1. What are the dominant location factors considered by Hyundai? 

2. What are the location alternatives for Hyundai's manufacturing plant?

3. To what extent did the Glendale, Kentucky site satisfy the selected factors?

4. To what extent did the Montgomery, Alabama site satisfy the selected factors? 

  • Prepare and save your answer in word.
  • Name your word document using the convention: YourFirstInitial_YourLastName_CASE7
  • Submit your answer via the digital dropbox.

Practice problem 1 (to be completed by 10/30)

Solve problem #16 pg. 279 of your text

  • Prepare and save your answer in word or excel.
  • Name your document using the convention: YourFirstInitial_YourLastName_PRACTICE7a
  • Submit your answer via the digital dropbox.
  • Compare your answers with those shown in Appendix A.
  • Prepare a word document called YourFirstInitial_YourLastName_COMMENT3a  to explain:
    • why your answers are different?
    • how will you reconcile these differences?
  • Submit your comment via the digital dropbox.

Practice problem 2 (to be completed by 10/30)

C&A Corporation is a wholesaler with two existing warehouses. It has received orders for a product from four different customers. The per unit cost of supplying each customer from each warehouse is given here, along with the demand of each customer and the available product supply at the two warehouses.

From/To

Customer 1

Customer 2

Customer 3

Customer 4

Supply

Warehouse A

12

13

4

6

500

Warehouse B

6

4

10

11

700

Demand

400

900

200

500

 

C&A realizes that in order to meet customer demand, an additional warehouse is needed. The per unit cost of supplying each customer from the two warehouses under consideration is:

From/To

Customer 1

Customer 2

Customer 3

Customer 4

Warehouse C

10

9

12

4

Warehouse D

20

8

6

15

 

Question 1.

What is the minimum amount to be supplied from the new warehouse in order to satisfy all four customers’ demand?

Question 2.

Is C or D a better location for C&A’s new warehouse?

Question 3.

If the numbers in the given tables represent the per unit profit (instead of cost) of supplying each customer from each warehouse, is C or D a better location for C&A’s new warehouse?

  • Prepare and save your answer in excel.
  • Name your excel spreadsheet using the convention: YourFirstInitial_YourLastName_PRACTICE7b
  • Submit your excel spreadsheet via the digital dropbox.
  • Compare your answers with those shown in
    Answer One Tutorial
    Answer Two (Warehouse C) Tutorial and
    Answer Two (Warehouse D) & Answer Three Tutorial
  • Prepare a word document called YourFirstInitial_YourLastName_COMMENT7 to explain:
    • why your answers are different?
    • how will you reconcile these differences?
  • Submit your comment via the digital dropbox.

Assignment problems (to be completed by 10/31)

Assignment problem #1

The main post office in Orlando, Florida, is due to be replaced with a much larger, more modern facility than can handle the tremendous flow of mail that has followed the city's growth since 1970.  Since all mail, incoming or outgoing, travels from the seven regional post offices in Tampa through the main post office.  Its site selection can mean a big difference in overall delivery and movement efficiency.  Using the data in the following table, determine the map coordinates for the proposed new facility.

 

Regional Post Office

Map Coordinates (x,y)

Truck Round Trips per Day

Ybor City

(10,5)

3

Davis Island

(3,8)

3

Dale-Mabry

(4,7)

2

Palma Cela

(15,10)

6

Bayshore

(13,3)

5

Temple Terrace

(1,12)

3

Hyde Park

(5,5)

10

 

Assignment problem #2

Refer to the situation described in Supplement C, problem #1, use Excel Solver to determine the amount of product to produce and send from each plant to each distribution center to minimize costs.

 

Assignment problem #3

Refer to the situation described in Supplement C, problem #7, use Excel Solver to determine the production and distribution plan that will maximize Wexford’s profit (including finding which customer(s) does not receive all it wants).

  • Prepare and save your answer in excel.
  • Name your document using the convention: YourFirstInitial_YourLastName_ASSIGNMENT7
  • Submit your answer via the digital dropbox.