All Collections
Merchandise Planning
Workflows
Projecting from Retail Calendar to Gregorian
Projecting from Retail Calendar to Gregorian

Toolio supports projecting your Plans in Retail Calendar into Gregorian Calendar.

Updated over a week ago

Summary

While it is best practice to build retail plans using the Retail Calendar for reasons described here, there will be many cases where you will want to project out your plans on the Retail Calendar to the Gregorian Calendar, which is the financial calendar most organizations use.

The main reason for projecting out to the Gregorian Calendar is because the Finance team or external stakeholders will expect projections in the Gregorian Calendar. Thankfully Toolio supports projecting your Retail Calendar to the Gregorian Calendar with the click of a button.

To project your plans, simply click Time Groups > Show Gregorian Projection, and you will be able to see your plans in Gregorian. You can see it in action on the screenshot below.

The desired behavior here is to be able to generate a report based on existing plans and translate them to Gregorian calendar.

Specifically, let’s take an example below where we use the weight average to calculate June Gross Sales Units. June = 1000/35x30 = 857.14

Source - NRF 4-5-4

Month

Start

End

Number of Days

Gross Sales Units

Jun

5/31/2020

7/4/2020

35

1000

Jul

7/5/2020

8/1/2020

28

1000

Destination - Gregorian

Month

Start

End

Number of Days

Gross Sales Units - Estimate

Jun

6/1/2020

6/30/2020

30

857.1428571

Jul

7/1/2020

7/31/2020

31

1107.142857

FAQs

Can I edit my plans in Gregorian Calendar?

Currently Gregorian Projection is only for reporting purposes, so once you enable Gregorian Projection your plan will become uneditable. If you want to plan in Gregorian instead, you can instead configure your Merchandise Plan to be on the Gregorian Calendar.

What is the accuracy of projections?

Just as it is the case with any projection, the accuracy of Retail Calendar projection to Gregorian Projection will not be 100% accurate, since Toolio only knows your week level plans. However, based on our studies of Actuals data, projections should be within +/- 2% accuracy.

Did this answer your question?