Docstoc

Cost Projection Template

Document Sample
Cost Projection Template Powered By Docstoc
					                             4c26c97d-9c4c-4ce2-af5d-e386aa120ef2.xls
     A                 B                C         D              E                F         G   H            I
1
2        INSTRUCTIONS:
         This worksheet is for data entry only. Enter in the yellow cells the names of
         cost items, and the relevant parameters for each cost item listed. Add new
         rows as needed, and enter the relevant information. Unnecessary rows can
         be deleted or just ignored. The titles in blue should not be changed. Enter
         data as infrequently as possible. Reference the DATA page when
3        developing formulas in other worksheets in this workbook.
4
5        Problem or case
6        Company name:                           Name of Your Company
7        Statement or schedule          Schedule of Projected Manufacturing Cost
 8       Period                             For the Period Ending Whenever
 9
10
11               Cost Item          Variable Fixed
12
13
14
15
16
17
18                                                         Driver Name         Volume
19       Cost driver volume
20       Cost driver base volume
21
22       Definitions

         *Base volume may be interpreted as the lower end of the relevant range for
         each cost item (e.g., zero or a another base volume for which a total item
         cost is provided). If a total item cost is given for the lower end of a relevant
23       range which is not zero, enter that cost amount in the "Fixed" column).
24
38




                                                                                                    Printed 3/22/2013
     4c26c97d-9c4c-4ce2-af5d-e386aa120ef2.xls
     A                      B                         C
1
2
3                  Name of Your Company
4          Schedule of Projected Manufacturing Cost
5                 For the Period Ending Whenever
6
                                                     Total
7                      Cost Item                     Cost
 8
 9
10
11
12
13
14        Total cost forecast                    $           -
15
16       Driver volume level used for forecast                   0




                                                                     Printed 3/22/2013

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:52
posted:3/21/2013
language:Unknown
pages:2