A well renowned Pizza delivery company in Oman wants to introduce the automation process to facilitate the
Question:
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.
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.
Fraud examination
ISBN: 978-0538470841
4th edition
Authors: Steve Albrecht, Chad Albrecht, Conan Albrecht, Mark zimbelma