Assignment 3

.pdf

School

Lamar University *

*We aren’t endorsed by this school

Course

3300

Subject

Management

Date

Feb 20, 2024

Type

pdf

Pages

4

Uploaded by litzyg2004

Report
Garcia | 1 Litzy Garcia Mr. Howell MGMT_3300 February 1, 2024 BUSI 2300 Assignment 3 Dr. Kakoli Bandyopadhyay Total Points: 25 Submit a word document with answers (fill in the tables with data) and relevant screenshots to the questions asked in pages 2-3 of the assignment . Global Electronics is a multinational manufacturer and distributor of portable electronic devices, such as cell phones, tablet computers, and game consoles. Global recently introduced its newest product, the Hawk 5G smartphone. The product rollout has been a huge international success, largely because the Hawk has a unique feature – it can automatically translate text messages from other Hawk phones into any language the user wants. The Hawk has been rolled out on five continents from distribution centers in Atlanta, Nigeria, Brazil, Japan, and Germany. The smartphone is being manufactured at four different facilities in Phoenix, China, Mexico, and Belgium. Tommy Wong, the president and the CEO of Global Electronics, is pleased with the success of the Hawk’s introduction, but is concerned that Global might not be optimizing the assignment of production from the manufacturing sites to the distribution centers. Currently, his planners are assigning production manually based on the distances between manufacturing and distribution. He thinks that transportation costs from the part suppliers and the manufacturing costs at each site are not being taken into account using the current method. We will use the Tableau software to work on this assignment. Tableau is used to perform visual analysis for spreadsheets and databases. We will connect to the spreadsheet Global manufacturer given below (An excel file: Global Electronics Updated will be made available). Use the Assignment 3 Data Tab. The total operating cost of each distribution center for the production assigned is given below: To: Distribution Center: Phoeni x Shanghai Monterre y Brussels Total Operating Cost($) Atlanta, U.S. 41225 56600 100000 28165 22072024.79 Lagos, Nigeria 768 8776 50000 121454 17670389.09 Rio De Janeiro, Brazil 643 76658 50000 88788 21171856.21 Osaka, Japan 76000 100000 67000 84000 31954701.78 Frankfurt, Germany 59225 11655 100000 29765 19648784.38 Total 112517756.30 Things to do: Using Tableau answer the following questions: 1. A. Which distribution center (Atlanta/Lagos/Rio/Osaka/Frankfurt) gets the maximum finished products from Shanghai ? (4 points) Hint: drag and drop distribution centers from dimensions to columns and drag and drop Shanghai from the measures to rows. Go to Label > Show Mark Labels.
Garcia | 2 Distribution Center Maximum Unit of Product Assigned Osaka, Japan 100,000 B. Copy and Paste the relevant bar graph from Tableau here (2 points) 2. A. Which distribution center (Atlanta/Lagos/Rio/Osaka/Frankfurt) gets the minimum finished products from Phoenix? (4 points) Hint: drag and drop distribution centers from dimensions to columns and drag and drop Phoenix from the measures to rows. Go to Label > Show Mark Labels. Distribution Center Minimum Unit of Production Assigned Rio De Janeiro, Brazil 643 B. Copy and Paste the relevant bar graph from Tableau here (2 points)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help