Objective

The Objective of “Office Solution Development” Report is to answer the assignment question in regards to the case study and based on the knowledge,

·         how application software can support business processes

·         Design and implementation of office solutions

·         Demonstrate that business processes have been enhance\improved.

Design and Implementation office solutions

Solution design for ‘Futuretastic’ 

Solution is designed based using Excel and Macro, as given in Case Study all the requirement is fulfilled. Data-Centric Design Methodology is used for Solutioning of Futuretastic Business Processes

Question 1: Table 3.1 and 3.2 Data is entered in “Data” Sheet in excel 

Net Visitor Flow and Total Visitors in the parks is completed using excel formula and it will be automatically get populated in Table 3.2

Question 2, Visitor Queue Model is created in Separate sheet “Model” and data is populated as per design and solution  

Question 3: As per request of Operation Manager Formatting of data is done as per below logic

•          Areas with excess capacity should have a green background.

•          Areas with 1-49 visitors waiting in a queue should have an orange background.

•          Areas with 50 or more visitors waiting in a queue should have a red background.

•          A key should be provided to explain the significance of the 3 colours 

Question 4: in this interactive Graph is designed and a graph is designed using multiple-choice list. The X-axis should be labelled ‘Time’ and the Y-axis ‘Queue’. Read about Android Assignment Help.

Question 5: Here application is designed to be more interactive with following support of the requirement

On opening the spreadsheet, Welcome Page will appear, using buttons to access the:

•          Data worksheet

•          Model worksheet

•          Graph worksheet.

Detail of each button is provided; Welcome page is designed keeping in mind the requirement mentioned with the title of ‘Futuretastic Visitor Queue Model’.

Auto back option is also provided. 

Implementation of ‘Futuretastic’ Solution 

Implementations are done for this application as per the requirement and below are the screen shot access as per sequence. 

Spreadsheet is attached, double click on icon to see the running ‘Futuretastic Visitor Queue Model’ Application

Logo Designed. 

Double click on Office Solution Development.xlsm to run application

‘Futuretastic’ Solution

 Testing of ‘Futuretastic’ Solution is done used on use cases and the requirement given. Excel formula and Macro is testing properly 

Testing of model data is done using manual calculation of some result to verify if formula used is correct or not

Conclusion

Solution is designed to address a business or user needs of Futuretastic Theme Park. For example end user requirements, systems requirement, application to automate procedures, designing a tool, program or package that can perform a specific task to support problem-solving, advanced tools and techniques is used to implement a solution for Futuretastic Theme Park. Through is done using testing techniques and compared with expected results and requirements.

Programming Assignment Help provides plagiarism free assignments i.e. all our solutions are genuine and written by best technical assignment writers who have years of experience. Get a quote now.