You are responsible for setting production levels for an overseas factory in Shanghai which manufactures three products: Soccer balls, Tennis balls, and Golf balls. You have developed a Profitability model which includes: Individual production capacity limits for each product as well as a Total production capacity limit A marketing model of the selling price of each product (which varies depending on the production level) The production cost of each item in both Chinese Yuan and US Dollars at the current exchange rate of 7 Yuan per Dollar The Fixed Cost to distribute the product in the US. . Determine the most profitable production mix of the three products considering the capacity limitations outlined in the spreadsheet. Complete the Data Table to show how Profit varies with changes in the Fixed Cost and changes in the Yuan/$ exchange rate. PRODUCTION LEVELS REVENUE COST 7.0 Product Line Production Level Production Capacity Market Price per Ball Revenue EXCHANGE RATE (Yuan/$) Unit Production Cost Cost Yuan US $ 63.0 $ 9.00 $ 28.0 $ 4.00 $ \21.0 S 3.00 $ $ 15.00 $ $ 6.00 $ Soccer Balls Tennis Balls Golf Balls TOTAL 500,000 400,000 250,000 1,000,000 $ 4.00 $ $ $ $ FIXED COST 500,000 6.5 7.0 7.5 8.0 8.5 9.0 Fixed Cost OPERATING PROFIT $ (500,000) Operating Profit Sensitivity to Exchange Rate and Fixed Cost: Exhange Rate (Yuan/$) 5.0 5.5 6.0 $ 350,000 $ 400,000 $ 450,000 $ 500,000 $ 550,000 $ 600,000 650,000 700,000