Analyzing Production Costs for Global Electronics' Hawk 5G Smartphone

Garcia | 1 Litzy Garcia Mr. Howell MGMT_3300 Febuary 1, 2024 BUSI 2300 Assignment 1 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 1 Data Tab. The total operating cost of each manufacturing site is given below: Manufacturing Site Direct Labor Cost per Unit Direct Material Cost Overhead Cost per Unit Air Freight In Total Operating Cost Phoenix $1.00 $19.00 $3.00 $2.28 $4,600,461.91

Garcia | 2 Shanghai $0.40 $19.00 $1.00 $1.20 $5,661,890.92 Monterrey $0.50 $19.00 $2.00 $2.46 $8,938,978.40 Brussels $1.20 $19.00 $4.00 $2.31 $9,517,459.48 Things to do: Using Tableau answer the following questions: 1. A. Which manufacturing site (Phoenix/Shanghai/Monterrey/Brussels) incurs the maximum air freight in cost per unit of production? (4 points) Hint: drag and drop manufacturing sites from dimensions to columns and drag and drop air freight cost from the measures to rows. Go to Label > Show Mark Labels. Manufacturing Site Maximum Air Freight Cost Monterrey $2.460 B. Copy and Paste the relevant bar graph from Tableau here (2 points) 1. A.Which manufacturing site (Phoenix/Shanghai/Monterrey/Brussels) incurs the minimum direct labor cost per unit of production? (4 points) Hint: drag and drop manufacturing sites from dimensions to columns and drag and drop direct labor cost from the measures to rows. Go to Label > Show Mark Labels.

Garcia | 3 Manufacturing Site Minimum Direct Labor Cost Shanghai $0.4 B. Copy and Paste the relevant bar graph from Tableau here (2 points) 1. A. Which manufacturing site (Phoenix/Shanghai/Monterrey/Brussels) incurs the maximum overhead cost per unit of production? (4 points) Hint: drag and drop manufacturing sites from dimensions to columns and drag and drop overhead cost from the measures to rows. Go to Label > Show Mark Labels. Manufacturing Site Maximum Overhead Cost Brussels $4 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

Garcia | 4 1. A. Which manufacturing site (Phoenix/Shanghai/Monterrey/Brussels) incurs the maximum total operating cost per unit of production? (5 points) Hint: drag and drop manufacturing sites from dimensions to columns and drag and drop total operating cost from the measures to rows. Go to Label > Show Mark Labels. Manufacturing Site Maximum Total Operating Cost Brussels $9517459 B. Copy and Paste the relevant bar graph from Tableau here (2 points)

Assignment 1

Related Documents