这个作业是用Excel和VBA完成商业模型设计

The assessment will give attention to how well you demonstrate your skills to complete the tasks – e.g.
ensure all assignment requirements are met, fulfil the functional requirements of the scenario, the
development is robust and maintainable.

SDR (Simon’s Drones & Robotics) is now expanding their business to include leasing of tech toys.

Tech toys are commonly known for recreation, but they are also useful for educational purposes such
as, research, expeditions, and photography. They lease different types of tech toys to business
customers, e.g. research institutes, schools, party/event organisers. These customers usually rent in
bulk (five or more) and will come back again for rentals. SDR is hoping to maintain a good relationship
with these customers. There are several types of tech toys available, such as Camera Drone, Electric
Gokart, and Coding Robot. For each customer, e.g. a research institute, there is a contact person for
tech toy ordering a.k.a contact person (CP). A CP can make an order by phone or by email. When a
CP place an order, SDR delivers the tech toy to the destinated location (such as schools, event venues,
etc). At the end of the rental period (i.e. when a tech toy is no longer needed), the CP will inform SDR
to collect the tech toy, usually from the same location, but SDR also can collect from another location
if requested by customers. These tech toys will be inspected (check for damages), cleaned, repacked
and stored in SDR’s storeroom, ready for next use.

So far, all orders are recorded using simple Excel sheets. Due to the increases of order, SDR requires
a computer application to help them to manage the product information, customer details, orders placed
by the customers as well as deliveries and collections of the tech toy. This application should be written
in Excel (VBA), so that they can improve their current rental management system. The CEO of SDR,
Simon is now contracting you to develop an Excel application (file can be saved in “.xlsm” extension)
that integrates what they currently have into a more user-friendly interfaces, in order to maintain their
day-to-day business.

The CEO has provided the Excel spreadsheets that they currently used to maintain their daily orders –
“FIT1013 A2_2020.xlsx”. Please note that this file does not contain all their rental data (for business
privacy), but they are enough for you to understand the business scenario. Some of the data in the file
are de-identified due to privacy issue but they maintain the same structure. Some of these data are
imported from the deliver-collect tracking system (the development of the deliver-collect tracking
system is not in the scope of this assignment). Your application should work the same using the
provided actual data. In short, do not change any format or structure of the original data in the
worksheets, unless stated otherwise. Simon reminded you that the application is to be developed in
Microsoft Excel (English version) so that he and his employees can run the application smoothly in
their computer. He would also like you to show him your work progress (milestone) so that he can be
sure that the application is completed on time. Failing to do so may result in reduced payments or
cancellation of the project.

Functionality

1. A User Form named “Main Menu” is presented upon opening the workbook. The user form
will contain buttons to perform the key activities described in the points below (2-5). If the user
closes the form, it should be possible to bring the form back by clicking on the button named
“Show Menu” in the ‘Menu’ worksheet. This form should display the following options:

i. Customer (Add/Delete/Modify)
ii. Rental
iii. Return
iv. Summary