The Student Room Group

ICT A-Level

Hi everyone, I'm doing A-Level ICT and I need a solution to complete this spreadsheet task:

Captain Cornelius C. Cod has a fish and chip shop and wants to model the effects of increasing his prices.

If he increases his profits. he may sell less but make slightly more money.

If he decreases his profits, he will sell more, but it may also have an effect on income.

Assumptions:
For every 2% increase in price, sales decrease by 1%.
For every 2% decrease in price, sales increase by 1%.
The price increase must not be more than 100% (not double).

Can someone please give me a solution on how to calculate these assumptions with any value with a formula.

Thank you very much.
Reply 1
Original post by Heny1330
Hi everyone, I'm doing A-Level ICT and I need a solution to complete this spreadsheet task:

Captain Cornelius C. Cod has a fish and chip shop and wants to model the effects of increasing his prices.

If he increases his profits. he may sell less but make slightly more money.

If he decreases his profits, he will sell more, but it may also have an effect on income.

Assumptions:
For every 2% increase in price, sales decrease by 1%.
For every 2% decrease in price, sales increase by 1%.
The price increase must not be more than 100% (not double).

Can someone please give me a solution on how to calculate these assumptions with any value with a formula.

Thank you very much.


To increase price: startprice*1.02
To decrease price: startprice*0.98

Can you figure sales out?

Posted from TSR Mobile

Quick Reply