Question 1 a. Describe how Management Information System (MIS) has transformed or affected transportation business industry. Be sure to show some figures and data to support your answer. (10 MARKS) b. You are consulting for Benny's, a chain of petrol stations. Discuss what types of e- commerce opportunities are relevant to Benny's. Suggest any suitable Internet business models for this opportunity. (15 MARKS) Question 2 a. 99 Speed Mart - One of Malaysia's groceries company, sells a wide range of goods. The retail outlets are independently owned and operated. The company was using daily mailings and thick product catalogs to inform its dealers about new products, merchandise setups, best practices, product ordering, and problem resolution. It is looking for a better way to provide employees with human resources and administrative documents. Describe the problems created by doing business this way and how knowledge management systems might help. (10 MARKS) b. In your opinion, should all businesses use virtual reality? What kinds of organizations will benefit most from this technology? Justify your answer (15 MARKS)Question 3 a. Referring to the attached question 3.accdb or question 3.xls, you are required to get the data to excel and do the followings: i. Prepare a report that identifies the five most expensive bicycles. The report should list the bicycles in descending order from most expensive to lease expensive, the quantity on hand for each, and the markup percentage for each. (4 MARKS) ii. Prepare a report that lists each supplier, its products, their quantities on hand, and associated reorder levels. The report should be sorted alphabetically by supplier. Within each supplier category, the products should be sorted alphabetically. (4 MARKS) iii. Prepare a report listing only the bicycles that are low in stock and need to be reordered. The report should provide supplier information for the items identified. (4 MARKS) b. Based on your observations, suggest TWO (2) decisions that the management should take. (5 MARKS) c. Write a brief description of how the database could be enhanced to further improve management of the business. What tables or fields should be added? What additional reports would be useful? (8 MARKS)Question 4 Agro chemicals corporation Management corporation has been dissatised with production planning. Production plans are created using best guesses of demand for each productr which are based on how much of each product has been ordered in the past. If a customer places an unexpected order or requests a change to an existing order after it has been placed, there is no way to adjust production plans. The company may have to tell customers it can't fill their orders. or it may run up extra costs maintaining additional inventory to prevent stock outs. At the end of each month, orders are totaled and manually keyed into the company's production planning system. Data from the past month's production and inventory systems are manually entered into the rm's order management system. hnalysts from the sales department and from the production department analyze the data from their respective systems to determine what the sales targets and production targets should be for the next month. These estimates are usually different. The analysts then get together at a highlevel planning meeting to revise the production and sales targets to considersenior management's goals for market share. revenues, and profits. The outcome of the meeting is a finalized production master schedule. The entire production planning process takes \"I? business days to complete. Nine of these days are required to enter and validate the data. The remaining days are spent developing and reconciling the production and sales targets and finalizing the production master schedule. a. Draw a diagram ofthe existing production planning process. [3 MARKS} b. Analyze the problems this process creates for the company. {B MARKS} c. How could an enterprise system solve these problems? In what ways could its lower costs? Diagram what the production planning process might look like ifthe company implemented enterprise software. [9 MARKS]