1 year financial model with REED supermarket

/in /by

only need you help me calculate the 1 year financial model, I will send you the whole case and data when you take this question.

CHANGES TO & CLARIFICATIONS OF CASE ASSUMPTIONS

For the purpose of this case analysis, the following changes are to be made to the assumptions contained in the case:

Reed Supermarkets

Increase in Same Store Traffic With Dollar Specials Program

5.00%

Dollar Specials – % of Store/Columbus Sales

2.75%

Dollar Specials Products – Average Price Per Item Before Price Reduction

$2.50

Dollar Specials Products – Average Price Per Item After Price Reduction

$1.50

All other facts and aspects of the case are as outlined in the case document.
  • You can assume that the increase in same store traffic with the dollar specials program had the same average sales per transaction as the existing business.