# I’ve got a question and will try to provide as clear an explanation as possible:

<hr />

<center>
<a href="https://upload.wikimedia.org/wikipedia/commons/4/46/Passive-3d-tv-technology.jpg"><img alt="Looking For Help" src="https://upload.wikimedia.org/wikipedia/commons/4/46/Passive-3d-tv-technology.jpg"></a>
[Image Source](https://upload.wikimedia.org/wikipedia/commons/4/46/Passive-3d-tv-technology.jpg)
</center>


<hr />

## I have a set of known targets equaling the total for my sales forecast number for Year 1, Year 2, and Year 3. 

**Given:** 
Y1 = $600,000; 
Y2 = $1,200,000; and 
Y3 = $1,200,000.

**Is there a formula (in Excel or otherwise), calculation, forecasting model, or anything else, that would take the year end total and work backwards into dividing it out over the 12 month period?**

The issue is that the ***assumption is that each month is not the same***, so $600,000 ÷ 12 will not suffice. 

Rather, the sales totals should increase over the 12 month period, resulting in the total at the end of the year. 

### These monthly sales numbers do not have to be linear increases at a set interval and would best be staggered slightly.  

Lastly, a further caveat, is that in Year 1 the Month 1 total sales will be equal to $0.00.

### Any and all suggestions would be appreciated and I would be forever grateful for your help.

<hr/>
 

<center>***As promised, this was something completely different.***</center>

<hr />

<center>![Michael](https://i0.wp.com/strangerarray.files.wordpress.com/2016/08/michael-web-2.jpg?ssl=1&w=450)</center>

<hr />

<center>**Written by [Michael Paine](https://steemit.com/@strangerarray)**</center>
<center>Follow me [@strangerarray](https://steemit.com/@strangerarray) and [donate](https://www.paypal.me/michaelpaine/20) because I could use the cash.</center>

<hr />

# Please check out my other recent fiction:

- [*Operation Overwrite: Part 4*](https://steemit.com/writing/@strangerarray/operation-overwrite-part-4)

- [*Operation Overwrite: Part 3*](https://steemit.com/writing/@strangerarray/operation-overwrite-part-3)

- [*Erosion of an Empire: Part 3*](https://steemit.com/writing/@strangerarray/erosion-of-an-empire-part-3)

<hr />

**P.S.**  Get **$500** to spend how you want where you want on whatever you want when you **use [my link](http://credible.refr.cc/DXNGSMN) now** to refinance your student loans with  [Credible](http://credible.refr.cc/DXNGSMN).

***However***, this is a **Limited time offer** and you need to start the refinancing process between now and 2/15/17 to be eligible for **$500 reward**.