Set up a pricing system which will automatically work

Assignment Help Database Management System

Reference no: EM132286547

Database and Advanced Spreadsheet for Business Assignment - Spreadsheet Project

The Problem: Fights Transfers are a Dublin based transportation company providing transport services from Dublin Airport to Dublin and the surrounding counties up to 50KM from the Airport.

They have asked you to use spreadsheet software to set up a pricing system which will automatically work out the cost of a transport service, record quotes and create professional looking receipt.

Specific Requirements -

They want to be able to clear the price calculations at the click of a button and to be able to change prices easily.
They want to be able to change prices easily on any of the three price lists (This project will require four price lists, one for each vehicle type, on the Price Lists page).
They want to be able to print this receipt at the click of a button.
They also want the spreadsheet set up so that you cannot delete formulas and data by mistake or enter data which is unacceptable.
They want a method of recording customer quotes.

Note - Just need to make a receipt on excel using different functions of Excel. Try to work it out on your own and remember: the 'Denton Gazette' assignment shows you how to use these tools.

Attachment:- Assignment Files.rar

Reference no: EM132286547

Questions Cloud

Discuss and share a crisis event from your life : Discuss and share a crisis event from your life. Address the following: What were the precipitating factors? How did you feel? How did the crisis resolve?

Write an effective e-mail message : Read the S cenario below. Decide upon the appropriate content and structure you would use to write an effective e - mail message to your employees.

Effective communication strategies for communicating change : Describe two effective communication strategies for communicating change that are relevant to internal and external stakeholders.

Why is strong leadership imporant : Why is strong leadership imporant to a compney and their succuss?

Set up a pricing system which will automatically work : 6N8383 Database and Advanced Spreadsheet for Business Assignment - Spreadsheet Project, Dublin Institute of Technology, Ireland. Sup a pricing system

Why is it important to clarify organizational mandates : Lastly, why is it important to clarify organizational mandates and mission? Support your thoughts with material taken directly from our text and outside sources

How information technology can be used to assist bureaucrats : Informed decision-making is an important aspect for working in the government. According to Milakovich and Gordon, provide some examples of how information.

International strategies using business strategy : Firms will typically develop their international strategies using business strategy. what is business strategies and what is an example of a firm that has used

Who happens to be a former student of mine : Your boss, who happens to be a former student of mine, says to you "Our new employees seem to be lacking in self-efficacy

Reviews

len2286547

4/17/2019 10:01:48 PM

This is MS Excel Spreadsheet. Please read that document. There is no word limit in this. You just need to make a receipt on excel using different functions of Excel. Please check the pdf file also, This sample will help you in this. You will spend approximately 4 hours on this assignment but you will learn a lot and gain more confidence in your abilities. Try to work it out on your own and remember: the ‘Denton Gazette’ assignment shows you how to use these tools.

len2286547

4/17/2019 10:01:42 PM

Please NOTE Each student must do their own work. Report Presentation – Professional Layout of Spreadsheet. Colours, Fonts, Layout and use of basic Excel Formula’s. You may not need all the tools listed here but give this project some thought and think back on the tools that we used for Denton Gazette. These are the tools that are in your toolbox for this project: Check boxes, If function, Option Button, Combo boxes, Nested IF statements, VLOOKUP’s, Spinners.

Write a Review

Required(*) Message

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages