Alice is running a new marketing campaign and expects bookings to rise in February (assume this is
the end of January). Based on the new price calculated in (Q.18) above, Alice wants to see projections
for the month of February, assuming that:
the cottages will be booked the same number of times in February as they were in total before.
cottages that were not booked ever before to be booked once in February.
She wants you to prepare a report that includes the following columns for each cottage that Tourista
owns:
Name of the cottage.
Total number of bookings for that cottage so far.
Total price of all bookings i.e. total income) for that cottage so far.
Average price (i.e. average income) of all bookings for that cottage so far.
New price for February that is 20% more than the average price based on column 4 above and
rounded to the nearest whole number, or 499 if it was not ever booked before.
The expected number of bookings in February based on her assumptions above.
Total price of all bookings for that cottage based on the new price and expected number of bookings
in February
Profit that Tourista stands to make on each cottage (column 7 - column 3) if her assumptions are
correct
A sample output is shown below. (Note that column headings in your output should match those
shown below)
Answers
Answered by
0
Answer:
follow me and mark me as brilliant
Explanation:
Alice is running a new marketing campaign and expects bookings to rise in February (assume this is
the end of January). Based on the new price calculated in (Q.18) above, Alice wants to see projections
for the month of February, assuming that:
the cottages will be booked the same number of times in February as they were in total before.
cottages that were not booked ever before to be booked once in February.
She wants you to prepare a report that includes the following columns for each cottage that Tourista
owns:
Name of the cottage.
Total number of bookings for that cottage so far.
Total price of all bookings i.e. total income) for that cottage so far.
Average price (i.e. average income) of all bookings for that cottage so far.
New price for February that is 20% more than the average price based on column 4 above and
rounded to the nearest whole number, or 499 if it was not ever booked before.
The expected number of bookings in February based on her assumptions above.
Total price of all bookings for that cottage based on the new price and expected number of bookings
in February
Profit that Tourista stands to make on each cottage (column 7 - column 3) if her assumptions are
correct
A sample output is shown below. (Note that column headings in your output should match those
shown below)
Similar questions