1c) The alternative solutions for the problems with The Pizza Palace are:
- Continue using a manual method
- Hire an accountant to take care of the details.
1d) I have not chosen any of the above methods but have decided to use the ICT method as it is much more reliable, dependable and has a lot less chance of losing or damaging work. Hiring an accountant is an expensive method and because the company is already losing money, this isn’t a good idea. Also, using a manual method is messy and can be lost or contain mistakes. Therefore, using ICT is the best solution.
1e) The new system is:
- Automatic - Macros and formulae
- Secure - Password protected
-
Reliable -
Task 2
2a) The input data / raw data necessary for the business and to complete the tasks is as follows:
- The receipts – These are the predicted sales figures for each month (from April to September):
April - £6000
May - £7000
June - £8000
July - £7000
August - £5000
September - £6000
-
The costs – These are payments that the business must pay by taking money out of the business. These costs are as follows:
→Supplies – 50% of the predicted sales figures for the same month e.g.April - £3000
May - £3500
June - £4000
July - £3500
August - £2500
September - £3000
→Wages - £2500 per month
→Loan repayments - £300 per month
→Rent - £250 per month
→Quarterly Bills :- Gas and Electricity - £500 for May and £400 for August
:- Business Rates - £400 for June and £400 for September
→Local advertising - £2000 in May
2c) The software that I will need is the following:
Microsoft Word
Microsoft Excel
2d) I need the following hardware for the system to function properly:
- CPU – To save and backup the work (storage)
- Mouse – To move the cursor around on the screen to open, close, modify work and send commands..
- Keyboard – To type in numbers and letters and send commands.
- Monitor – To view what I am doing.
- Printer – To look at the system (printout).
- Floppy drive – To back up, save and load up the work on a floppy disk.
- CD-ROM drive – To back up, save and load up work on a CD-ROM.
2e)
2f) I will use the following backup measures in case the system is deleted from the Hard Disk:
- Floppy Disk
- CD-ROM
- USB Memory Stick
- Flash Memory
2g) I will apply the following security measures:
- Apply a password so that only those who know the password may enter and modify the work.
- Use a Firewall to prevent hackers and viruses from invading the system.
- Use an Anti-virus program such as Norton Anti-Virus to prevent hackers and viruses from invading the system.
3a) Test Plan:
Here is a Test Plan which will be used to see if the system will work the way I want it to.
(include data capture sheet which is cash flow without figures)
3b) Here is an example of my spreadsheet. I have used the guidelines and have managed to end up with this. It shows that all of the months are ‘OK’ meaning the company is not in any deep losses.
Task 4:
I will now complete the Test Plan that I made earlier in Task 3:
Task 5:
Evaluation:
In my opinion the outcome meets the objectives in the identify section because I have managed to follow all the guidelines which has led me to create the near perfect spreadsheet for the Pizza Palace. It has everything they asked for and includes formulae to make it easy for the management team of the Pizza Palace. I have also created macros which also make it easy to use the program. All these put together with the rest of the coursework has allowed me to meet the need of the restaurant owner.
There are alternative methods such as hiring an accountant but I think that creating a spreadsheet with formulae is a lot more efficient and cost-effective.
My ‘What If’ queries were very appropriate because they allow the users to think ahead and forecast the account of the Pizza Palace.
I could have improved the macros if I had another chance to do it. Plus, I could have also improved some implementation.
Shehryar Raja 11.4