[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference 7.286::digital

Title:The Digital way of working
Moderator:QUARK::LIONELON
Created:Fri Feb 14 1986
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:5321
Total number of notes:139771

881.0. "Fiscal Years" by ASDS::WALSH () Wed Aug 02 1989 18:04

Could someone point me or give the as many fiscal years as is possible or
give me an algorithm that can figure out what the starting date of each fiscal 
month.  Given a day begins that fiscal month.

Dan
T.RTitleUserPersonal
Name
DateLines
881.1Why ask here?CVG::THOMPSONNotes Wars VeteranWed Aug 02 1989 18:314
	This sounds like a question for ANYWAY::ASKENET. Be sure and look
	to see if it's been asked before though.

			Alfred
881.2Data for FY89 &90ARGUS::BISSELLWed Aug 02 1989 18:419
For what it is worth 
Fy 89 started on 3 July 1988
fy 90 started on 2 july 1989

Each "fiscal quarter" contains 13 weeks 
first "fiscal month" is four weeks, second is four weeks and third is 
five weeks long.

You can plot this out, hope it helps
881.3try the phone bookSPGOPS::HSCOTTLynn Hanley-ScottWed Aug 02 1989 19:313
    You can also find it in the DEC phone book -- there's a page that gives
    the fiscal year broken down by fiscal month.
    
881.4NEWS::HAKKARAINENA totally free interruptionWed Aug 02 1989 20:051
    See the discussion in METOO::TOOLSHED, Note 179.
881.5sometimes 4 X 13 + 1CSG002::MAKSINThu Aug 03 1989 16:108
    Re. .2
    
    Let's not forget that some fiscal years have 53 and NOT 52 weeks.
    
    Digital F&A scrambles when that happens, so expect irrational behaviour
    at those times.
    
    Joe
881.6Here's how it's donePOBOX::LEVINMy kind of town, Chicago isTue Aug 15 1989 21:5316
    Instead of sending readers to other places, it seemed simpler to
    post a reply with a simple answer.
    
    Fiscal year begins with first week containing at least 4 days in
    July, then runs 4-4-5 weeks/month to form a quarter. This repeats
    for all 4 quarters of the fiscal year. (Note the the fiscal year
    is always identified by the end date, i.e. FY90 ends around the
    end of June, '90.)
    
    Usually the next week fits the "at least 4 days in July" rule, so it
    starts a new year. Every 6 years or so, the extra day in the year
    causes enough of a shift that the 4-4-5 4-4-5 4-4-5 4-4-5 pattern
    leaves a week that's more June than July. In this case, Q4 becomes
    4-4-6.
    
    	/Marvin 
881.7P.S. to reply .6POBOX::LEVINMy kind of town, Chicago isTue Aug 15 1989 22:0316
    Another way to look at it is to simply say a fiscal year starts
    on whichever Sunday that falls on 
    		June 28
    		June 29
    		June 30
    		July 01
    		July 02
    		July 03
    	  or	July 04
    
    This, of course, is for official corporate fiscal year. If
    you're trying to figure out the field sales year -- which shifted
    a couple of years ago so that not everyone sent their last-minute
    end-of-year orders on the same day -- then Good Luck!
    
    	/M
881.8And anotherCVMS::DOTENRight theory, wrong universe.Mon Aug 21 1989 14:4516
    Maybe .16 works too, but there is a program in the
    METOO::SW_TOOLS_CATALOG conference (note #676) that converts calendar
    dates to fiscal dates. It has this comment in it:
    
    !*************************************************************
    !*                                                           *
    !*  Note: Per the corporate bylaws, Article 6, Section 1,    *
    !*   the fiscal year ends on the Saturday closest to June 30 *
    !*                                                           *
    !*  Kudos to Betsey Cane of the Maynard Library and          *
    !*   Gail Mann of Legal for dredging this fact out of        *
    !*   the corporate arcana                                    *
    !*                                                           *
    !*************************************************************
    
    -Glenn-