IPO Chart Lim's Limos provides a professional hire service for limousines in Melbourne. The business is owned and managed by Leonard Lim. His fleet of classic and stretch limousines is available for hire. The limousines he hires fall into a number of categories (classic, stretch, super stretch). He charges an hourly rate which is dependent on both the category of vehicle (see Hourly Charge table) and the time of week it is hired. There is a surcharge which is added to the hourly rate if the vehicle is hired on the weekend. For each booking Leonard has indicated in the input sheet whether the booking date falls on a weekend or weekday. Leonard keeps a record of the hire details each time a booking is made. He realises that there is a lot of valuable information in these records that could be used to run the business more effectively and has decided to record relevant data in a simple spreadsheet model. In the spreadsheet which Leonard plans to develop he needs to record: The hourly charge of the vehicle booked Booking charge % surcharge to be applied to a booking Hourly Charge Category Rate Super stretch $ 390.00 stretch $ 220.00 Classic $ 150.00 Total charge for each booking Total $ surcharge to be applied to a booking Complete the following IPO chart using the numbers 1, 2 and 3 to show which cell you are referring to: INPUT PROCESSING OUTPUT For each booking: Category of car 1 Hourly charge Hourly Charge Table For each booking: Hourly charge Hourly charge out rate multiplied by number of hours booked 2 Number of hours booked For each booking: Weekend booking (Yes/No) 3 Surcharge % Surcharge Rate