GCO3000: Information Technology in Business Case Study - Management Assignment Help

Assignment Task:

Task:

Assessment Details and Guidelines to Students:

This Scenario based Project comprises 50% of the total assessments’ marks. Make sure you reference (proper Harvard Referencing should be observed) any sources you have used to complete this assessment. Analytical skills. The reflection report enables the students to analyse and evaluate the benefits of the different activities done in the class. This skill will eventually help them evaluate options necessary to make decisions in the workplace.

In addition, the assessment will test the following learning outcomes:

LO 2: Develop and apply current application software to support business objectives. 

Assessment Task Task 1 (Microsoft Excel): (80 marks) Online Pizza Delivery A well renowned Pizza delivery company in Oman wants to introduce the automation process to facilitate the customers. The Director of the company has decided to assign a task to you as a developer to maintain the billing system for the customers. In this regard, you are requested by him to prepare and submit a report in Excel worksheet to keep the complete record of minimum ten (10) customers along-with the calculation of their bill amount for Pizza(s) including Municipality Tax and Home delivery charges.

The task should contain the following:

Task 1 (a): Create a COMPLETE worksheet with appropriate labels for this Scenario. The following should be included in your worksheet:

i. Name of the file (Student ID – Student Name).

ii. Title of the task (table).

iii. Complete contents and headings of the table.

iv. Page orientation to Landscape along-with the professional look of document.

v. Use filter by category.

Task 1 (b)

: i. Calculate the Total amount of ordered Pizza(s) by each customer by using appropriate formula in the respected cells.

ii. Calculate the 3% Municipality Tax on Total amount of ordered Pizza(s) against each customer by using appropriate formula in the respected cells.

iii. Calculate the Grand total after adding the Municipality Tax (3%) along-with the Home delivery charges (RO 1.500) in the Total amount of ordered Pizza(s) against each customer by using appropriate formula in the respected cells.

The above  GCO3000 Management  Assignment has been solved by our  Management Assignment  Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.