by excel
Problem A corporation plans to build a maximum of 9 computer factories in Saudi Arabia. They will build these factories in one of three locations - Riyadh, Jeddah, and Dammam. The Riyadh factory requires 1250 million SR to build and 90 employees to operate. The Jeddah factory requires 800 million SR to build and 120 employees to operate. The Dammam factory requires 900 million SR to build and 130 employees to operate. The corporation can dedicate a maximum of 10 billion SR in construction capital, and 1000 employees to operate the factories. On the average, the Riyadh factory is expected to net 210 million SR annually, the Jeddah factory nets 200 million SR annually, and the Dammam factory nets 190 million SR annually. The total number factories must be built during three years. You are required to: 1. Build an Excel model to calculate how many factories of each type the corporation should build to maximize revenue. Report your answer as in the following table. Draw the column chart to show the results. Item Number of Riyadh Factories ? Number of Jeddah Factories ? Number of Dammam Factories Profit Original Problem ? 2 Using the constructed model, fill the following table by answering the following WHAT IF questions. In each WHAT IF, use the original data described in original problem and only change the value deseribed in the WHAT IF statement. Draw the column chart to show the results. Changed Item (what it) Number of Riyadh Factories Number of Jeddah Factories Number of Dammam Factories Profit 2 a) Each Riyadh factory requires 800 million SR to be built and 100 employees to operate. b), The Dammam factory net is 250 million SR annually Problem A corporation plans to build a maximum of 9 computer factories in Saudi Arabia. They will build these factories in one of three locations - Riyadh, Jeddah, and Dammam. The Riyadh factory requires 1250 million SR to build and 90 employees to operate. The Jeddah factory requires 800 million SR to build and 120 employees to operate. The Dammam factory requires 900 million SR to build and 130 employees to operate. The corporation can dedicate a maximum of 10 billion SR in construction capital, and 1000 employees to operate the factories. On the average, the Riyadh factory is expected to net 210 million SR annually, the Jeddah factory nets 200 million SR annually, and the Dammam factory nets 190 million SR annually. The total number factories must be built during three years. You are required to: 1. Build an Excel model to calculate how many factories of each type the corporation should build to maximize revenue. Report your answer as in the following table. Draw the column chart to show the results. Item Number of Riyadh Factories ? Number of Jeddah Factories ? Number of Dammam Factories Profit Original Problem ? 2 Using the constructed model, fill the following table by answering the following WHAT IF questions. In each WHAT IF, use the original data described in original problem and only change the value deseribed in the WHAT IF statement. Draw the column chart to show the results. Changed Item (what it) Number of Riyadh Factories Number of Jeddah Factories Number of Dammam Factories Profit 2 a) Each Riyadh factory requires 800 million SR to be built and 100 employees to operate. b), The Dammam factory net is 250 million SR annually
