CONTROL OF ACCOUNTING INFORMATION SYSTEMS din 13.3 Excel Problem The Scorpion Railroad provides rides on diesel and steam trains through the scenic Arizona desert. It owns 32 engines , each with a unique serial number consisting of 6 digits. Printed below are data for trips on September 10. Each trip lasts a minimum of 1.5 hours. Engine Departure Serial # Return Trip Date Type Time 173954 09/10 09:15 11:46 624974 09/01 S 10:25 10:23 130856 09/10 E 12:30 16:42 442751 09/11 13:45 17:43 820451 09/10 DD 15:00 18:32 003876 09/10 15:30 15:45 Valid train cortes (engine type column):D - Diesel, S = Steam Time D S REQUIS a les describe any errors in the data. b. For each of the five data fields, suggest one or more input edit controls that could be used to detect input errors. c. Enter the data in a spreadsheet, and create appropriate controls to prevent or at least detect the input errors. d. Suggest other controls to minimize the risk of input errors. CONTROL OF ACCOUNTING INFORMATION SYSTEMS din 13.3 Excel Problem The Scorpion Railroad provides rides on diesel and steam trains through the scenic Arizona desert. It owns 32 engines , each with a unique serial number consisting of 6 digits. Printed below are data for trips on September 10. Each trip lasts a minimum of 1.5 hours. Engine Departure Serial # Return Trip Date Type Time 173954 09/10 09:15 11:46 624974 09/01 S 10:25 10:23 130856 09/10 E 12:30 16:42 442751 09/11 13:45 17:43 820451 09/10 DD 15:00 18:32 003876 09/10 15:30 15:45 Valid train cortes (engine type column):D - Diesel, S = Steam Time D S REQUIS a les describe any errors in the data. b. For each of the five data fields, suggest one or more input edit controls that could be used to detect input errors. c. Enter the data in a spreadsheet, and create appropriate controls to prevent or at least detect the input errors. d. Suggest other controls to minimize the risk of input errors