S AutoSave OH H File Home Sample Question-2 - Excel Page Layout Formulas Data earch View o X Comments Insert Draw Review Sign in - Share 47 0 4 Help Calih = General A 12 D E - 11 A A BIU - DA E == S Op E alle Wrap Text E Merge & Center - Paste $ -% Insert Delete Format Ideas - Formatting Styles Table Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas N16 A B C D E F G H I J K L M N O P Q R S A Q3) Hyundai Motors is considering three sites-A, B, and C-at which to locate a factory to build its new-model automobile, the Hyundai Sport C150. The goal is to locate at a minimumcost site, where cost is measured by the annual fixed plus variable costs of production. Hyundai Motors has gathered the following data: Site A B Fixed Cost Variable cost 10,000,000 2,500 20,000,000 2,000 25,000,000 1,000 The firm knows it will produce between 0 and 60,000 Sport C150s at the new plant each year, but, thus far, that is the extent of its knowledge about production plans. a) For what values of volume, V, of production, if any, is site Ca recommended site? b) What volume indicates site A is optimal? c) Over what range of volume is site B optimal? Why? - MRP Capacity Planning Location Planning @ -- - + 107% 1:42 PM E 4/29/20202 Type here to search A D C 9