TII Consider the following problem regarding to cars production: A company produces two types of cars, Pickup trucks and buses at two locations: Unaizah and Khoper. Unaizah factory can have a daily operating budget up to $ 10,000,000 and can produce at most 200 cars daily in any combination. It costs $ 40,000 to make a Pickup trucks and $60,000 to make a buses Khoper factory can have a daily operating budget up to $ 16,000,000, can produce at most 220 cars daily in any combination and makes a Pickup truck for $50,000 and a buses for $ 70,000. The company wants to limit production to a maximum of 200 Pickup trucks and 150 buses each day. Also, the total daily budget for both plants cannot exceed than $ 22,000,000. The company makes a profit of $ 3000 on each Pickup trucks and S 4000 on each buses. You are required to: 1- Build an Excel model to a) calculate the number of each type of cars that should be made at each factory in order to maximize the profit and calculate the maximum profit in the form of the following table. Unaizah Khoper Pickup buses Pickup buses trucks Profit trucks ? ? ? ? ? b) draw a column chart to show the number of Pickup trucks and buses made at each factory 2. Using the constructed model, fill the following table by answering the following WHAT IF questions. In each WHAT IF, use the main data described in external problem and only change the value described in the WHAT IF statement. Unaizah Khoper Changed Item Pickup buses Pickup buses Profit trucks trucks a) What if the daily operating budget at Khoper decreases to ? ? ? ? ? $8,000,000 b) What if the daily operating budget at Unaizah decreases to s ? 2 ? 7,000,000 c) What if the cost of Pickup trucks at Unaizah increases to $ 52,000 ? ? ? ? ? 3. Use the constructed model to draw a bar/column chart to compares the profits in questionl-a, 2-a.2-b and 2-e? TII Consider the following problem regarding to cars production: A company produces two types of cars, Pickup trucks and buses at two locations: Unaizah and Khoper. Unaizah factory can have a daily operating budget up to $ 10,000,000 and can produce at most 200 cars daily in any combination. It costs $ 40,000 to make a Pickup trucks and $60,000 to make a buses Khoper factory can have a daily operating budget up to $ 16,000,000, can produce at most 220 cars daily in any combination and makes a Pickup truck for $50,000 and a buses for $ 70,000. The company wants to limit production to a maximum of 200 Pickup trucks and 150 buses each day. Also, the total daily budget for both plants cannot exceed than $ 22,000,000. The company makes a profit of $ 3000 on each Pickup trucks and S 4000 on each buses. You are required to: 1- Build an Excel model to a) calculate the number of each type of cars that should be made at each factory in order to maximize the profit and calculate the maximum profit in the form of the following table. Unaizah Khoper Pickup buses Pickup buses trucks Profit trucks ? ? ? ? ? b) draw a column chart to show the number of Pickup trucks and buses made at each factory 2. Using the constructed model, fill the following table by answering the following WHAT IF questions. In each WHAT IF, use the main data described in external problem and only change the value described in the WHAT IF statement. Unaizah Khoper Changed Item Pickup buses Pickup buses Profit trucks trucks a) What if the daily operating budget at Khoper decreases to ? ? ? ? ? $8,000,000 b) What if the daily operating budget at Unaizah decreases to s ? 2 ? 7,000,000 c) What if the cost of Pickup trucks at Unaizah increases to $ 52,000 ? ? ? ? ? 3. Use the constructed model to draw a bar/column chart to compares the profits in questionl-a, 2-a.2-b and 2-e
