Q9. Software Design - A bike repair shop called North Beach Bike Repair has asked for help from you to improve and digitalize the way they handle their operations using a new information system software. Therefore, you are tasked with developing and proposing a new information system software for the Bike Repair Shop.

Q9 Supplementary Information about North Beach Bike Repair mini-case

This is a case-based assignment (see North Beach Bike Repair mini-case below). The question is very general and an appropriate structure of the answer with subchapters is needed for a good answer. Students are free choose the structure/sub-chapters for the answer.

Introduction to North Beach Bike Repair (Minicase about a Bike Repair Shop)

The North Beach Bike Repair Shop is one separate facility which is owned by an owner that also runs an adjacent Bike Showroom Shop. However, this assignment is JUST about the repair shop and no the adjacent Showroom Shop which sells bikes, assessories, clothing, etc. The North Beach Bike Repair shop setup is similar to Cycleology (Dana Point) and other bike shops with a separate repair service facility. The repair shop has 6 fulltime employees where one of them is a Senior Repair Mechanic who has the overall responsibility for the facility. They also employ a couple of temporary/part time helpers that are brought in to help during demand peaks. They service 120+ bikes per month which includes smaller repairs (tire/tube changes, mounting of new break pads), larger repairs (Brake change, gear change, suspension change, wheel truing), and bike building (wheels, full bikes, custom bikes). In the adjacent Bike Showroom Shop new bikes, accessories, and spare parts are sold. The Bike Repair Shop only deals with bike repairs and bike building, and the students needs to design an information system for the Bike Repair Shop only. The existing operational process starts with a call from a customer, followed by a bike drop-off and a brief initial discussion of repair needs. Then a bike mechanic starts on the bike repair and does the initial diagnostics. If spare parts are needed, an inventory check is done whether the needed spare parts are in the spare parts inventory or not. If not, the relevant spare parts are ordered online and the bike is placed in temporary storage room. When new spare parts arrive, the bike is retrieved, the repair is completed, the cost of the repair is calculated, and the customer is notified by phone that the bike is ready and the price. The customer then shows up, pay for the bike by Card/Cash/Check/Venmo/Zelle, and the bike leaves the shop. Once per month the Senior Mechanic summarize the sales, purchases/cost and calculates the operating profit. Students are welcome to make assumptions about the business, customers, and situation to complete the assignment as long as important assumptions are stated in the paper.

Minimum Requirements

Student should develop an Information System and Software proposal which as minimum is able to keep track of:

• Incoming and outgoing bikes - Bike name/brand, what work is needed on the bike, etc.),
• Customer information - Name, Phone number, etc.
• Repair description - What repairs are needed, comments/notes, etc.
• Costs - Bike repair related costs/purchases including spare parts, materials, time spend, etc.
• Customer payments
• Operating income overview - Key financials including Sales, Costs, Operating profit

Excel mock-up of system software

Besides the main text-based answer, the group must design and attach a standard Excel file as a supplementary illustration of how the information system software could be setup. The Excel document shold function as an example (mock-up) of the information system software setup that shows what the software consist of and how it funtions. Students are welcome to make up sample data to use in the mock-up of the software.