# Design a new computer system that will be used by the Manager of Pizza palace's restaurant. Because the system that he is using now is hard to do and it's also time consuming.

G.C.S.E IT (PIZZA PALACE)                Abdal Mohamed (11.4)

Problem identification

The pizza palace is an Italian restaurant that has been in business for two years. It made a small profit last year, but things are not looking good for this financial year. It is suffering from cash flow problems, where money coming into the business each month (receipts0 is less then the money coming going out of the business each month.

The owner is particularly worried since a new Italian restaurant is about to open nearby.

The owner needs to know how much cash is coming in and going out of the business but has no experience in computer modeling and asks me to help out.

I must produce a cash-flow for next six months and suggest ways to in which cash flow can be improved.

The system that I am going to create will be used by Manager of Pizza palace’s restaurant. Because the system that he is using now is hard to do and it’s also time consuming.

The problem is, Pizza Palace owner doesn’t know how to use this system and he has to know how to use this system because he has to solve those problems like, calculate the profit, tax, finance etc.

The alternative solution to this problem would be;

• Calculate a cash flow in spread sheet and know how to update.
• Using a choice of a software package to set up a spread sheet ‘computer model.
• To know how to solve formulas in Microsoft excel.

• Backup files
• Formula checked automatically
• More accurate.

The objectives of the new system are:

• To be able to avoid the plan ahead for negative cash flow.
• To be able to take advantages of positive cash flow.
• To be able to update the cash flow easily using the Microsoft excel and formulas.

Analysis

a)

Predictive sales figure:

April                £6,000

May                £7,000

June                £8,000

July                £7,000

August                £5,000

September                £6,000

Payments for the supplies;

50% of the predicted sale.

Quarterly bills;

Electricity and gas bills

> £500 for May

> £400 for August

> £400 for June

> £400 for September