On Excel,

$$ Create $3$ revenue forecast scenarios for BCF for the $20242030$ period considering, amongst others: The expected change in stores mix: the opening of small format stores in regional locations, the conversion of traditional stores to the $$superstore$$ format, relocation of weaker performing stores, The number of active members, The impact of a post$-$Covid normalisation in outdoor expenditure as a consequence of increased expenditure on services, entertainment, and offshore travel, The impact of cost$-$of$-$living pressures in customers buying behaviour. Make sure you use best practices and include any inputs and assumptions in the Inputs worksheet.

$$ Create $3$ revenue forecast scenarios for rebel for the $20242030$ period considering, amongst others: The expected change in stores mix: the opening of new regional stores, the conversion of traditional stores to the $$rCX store$$ and $$Homes of sport$$ format, The number of active members and the relaunch of the loyalty program in FY$24,$ The impact of cost$-$of$-$living pressures in customers buying behaviour. Make sure you use best practices and include any inputs and assumptions in the Inputs worksheet.

$$ Create $3$ revenue forecast scenarios for Macpac for the $20242030$ period considering, amongst others: The expected change in stores mix: Macpac Explorer, Macpac Adventurer Hub, The number of active members, The impact of cost$-$of$-$living pressures in customers buying behaviour, The impact of increased international tourism and travel. Make sure you use best practices and include any inputs and assumptions in the Inputs worksheet.

$$ Create $3$ revenue forecast scenarios for Supercheap Auto $($SCA$)$ for the $20242030$ period considering, amongst others: The expected increase in number of stores, Conversion of traditional stores to $$next generation$$ stores, The number of active members, The impact of an ageing carpark and the transition to electric vehicles, The impact of cost$-$of$-$living pressures in customers buying behaviour. Make sure you use best practices and include any inputs and assumptions in the Inputs worksheet.