DESIGN REQUIREMENTS
PURPOSE
The purpose of the model is to estimate the amount of money the cheese company can make in the
future, being able to change certain factors like the exchange rate between euros and pounds, the
price of the cheeses and the selling price can give quick feedback to the company and lets them
know if it could benefit their business.
USER REQUIREMENTS
Convert Euros into Pounds
Change the exchange rate
Calculate UK sales price
Sales price is 40% more than the price they buy the cheese
Calculate profit
Every 10p rise in cost drops 20 units sold
User friendly
CONSTRAINTS
Spreadsheet Creating Constraints
One constraint I’ll have is time. Like with anything, there is a time constraint on how long you have
to complete it and to make sure that everything is completed in that timeframe, I will set goals for
myself each week to have something to aim for.
The final constraint I’ll face is the hardware I use. If the computer is a few years old, it could slow
down the development of the spreadsheet because the programs used to make spreadsheets
require a more up to date system. If you’re lucky and are able to get the required program working,
then the next problem is how well it functions. If you try and do too much on an old computer it
could freeze it, again halting progress.
User Constraints
A constraint that the user might face is knowing how to use the spreadsheet. The spreadsheet will
have to be very clear on how to use it because if it is not clear enough, the user will get annoyed
with the spreadsheet and might give up on trying to use it. I will make sure that the spreadsheet is
clear enough for users to be able to use it by labelling each aspect of it so they can see clearly what
the numbers represent.
The final constraint that the user might face is the design of the spreadsheet. If the colours are hard
to look at, the user will struggle to use the spreadsheet effectively which could make the predicted
cheese profits inaccurate. This can lead to the business making prices too high or low and could
cause a lot of damage to the business. To prevent this from happening I will use different sheets to
spread parts of the spreadsheet out.
, DESIGNS
PROJECT TIMELINE
Dates Stage Work to be completed Date
Completed
02/03/20-08/03/20 Analysis
Understand the assignment 03/03/20
Work out the calculations needed for spreadsheet 03/03/20
30/03/20-05/04/20 Design
Create the design for the spreadsheet 01/04/20
20/04/20-26/04/20 Develop
Gather Feedback of Design 24/04/20
27/04/20-03/05/20 Develop
Improve the Spreadsheet based on the feedback 28/04/20
04/04/20-10/05/20 Test
Test the Spreadsheets functions 05/05/20
11/05/20-17/05/20 Write up
Justify the design decisions made for the 12/05/20
spreadsheet
18/05/20-24/05/20 Write up
Discuss why the spreadsheet meets the client’s
requirements
SPREADSHEET DESIGN
Displays the overall
Profit/loss
Button to take
users to
Represents another page
the
profit/loss
for the
company
Can change
the cost
PURPOSE
The purpose of the model is to estimate the amount of money the cheese company can make in the
future, being able to change certain factors like the exchange rate between euros and pounds, the
price of the cheeses and the selling price can give quick feedback to the company and lets them
know if it could benefit their business.
USER REQUIREMENTS
Convert Euros into Pounds
Change the exchange rate
Calculate UK sales price
Sales price is 40% more than the price they buy the cheese
Calculate profit
Every 10p rise in cost drops 20 units sold
User friendly
CONSTRAINTS
Spreadsheet Creating Constraints
One constraint I’ll have is time. Like with anything, there is a time constraint on how long you have
to complete it and to make sure that everything is completed in that timeframe, I will set goals for
myself each week to have something to aim for.
The final constraint I’ll face is the hardware I use. If the computer is a few years old, it could slow
down the development of the spreadsheet because the programs used to make spreadsheets
require a more up to date system. If you’re lucky and are able to get the required program working,
then the next problem is how well it functions. If you try and do too much on an old computer it
could freeze it, again halting progress.
User Constraints
A constraint that the user might face is knowing how to use the spreadsheet. The spreadsheet will
have to be very clear on how to use it because if it is not clear enough, the user will get annoyed
with the spreadsheet and might give up on trying to use it. I will make sure that the spreadsheet is
clear enough for users to be able to use it by labelling each aspect of it so they can see clearly what
the numbers represent.
The final constraint that the user might face is the design of the spreadsheet. If the colours are hard
to look at, the user will struggle to use the spreadsheet effectively which could make the predicted
cheese profits inaccurate. This can lead to the business making prices too high or low and could
cause a lot of damage to the business. To prevent this from happening I will use different sheets to
spread parts of the spreadsheet out.
, DESIGNS
PROJECT TIMELINE
Dates Stage Work to be completed Date
Completed
02/03/20-08/03/20 Analysis
Understand the assignment 03/03/20
Work out the calculations needed for spreadsheet 03/03/20
30/03/20-05/04/20 Design
Create the design for the spreadsheet 01/04/20
20/04/20-26/04/20 Develop
Gather Feedback of Design 24/04/20
27/04/20-03/05/20 Develop
Improve the Spreadsheet based on the feedback 28/04/20
04/04/20-10/05/20 Test
Test the Spreadsheets functions 05/05/20
11/05/20-17/05/20 Write up
Justify the design decisions made for the 12/05/20
spreadsheet
18/05/20-24/05/20 Write up
Discuss why the spreadsheet meets the client’s
requirements
SPREADSHEET DESIGN
Displays the overall
Profit/loss
Button to take
users to
Represents another page
the
profit/loss
for the
company
Can change
the cost
