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.

Authors Avatar

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

Problem identification

Task 1a, b:

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.

Tasks c:

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.

Tasks d:

The advantages and disadvantages:

  • Backup files
  • Formula checked automatically
  • More accurate.

Task c:

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

Join now!

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

      Business rates;

                > £400 for June

                > £400 for September

     Local Advertising;

     

               > £2, 00 in May      

b)

Data capture form:

...

This is a preview of the whole essay