| Fresh Book | Book in Process | Completed Books | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Month | New Book Received | Book Issued to Sangh | Balance | Issued to Sangh | Received from Sangh | Balance | Paid Books | Sent to PBSJ Office | Balance paid Book to be sent to PBSJ | |
| Opening balance on (mm/dd/yy) | 1000 | |
1000 | |||||||
| Dec | |
500 | |
500 | 500 | 310 | 190 | 310 | 310 | 0 |
| Jan | |
300 | |
200 | 300 | 260 | 230 | 260 | |
260 |
| Book Added on (mm/dd/yy)Jan | 1000 | 1200 | |
|
|
|
||||
| Feb | |
400 | |
800 | 400 | 425 | 205 | 425 | 425 | 260 |
| Book Added on (mm/dd/yy)Feb | 0 | |
|
800 | |
|
|
|
|
|
| Mar | |
600 | |
200 | 600 | 450 | 355 | 450 | 200 | 250 |
| Book Added on (mm/dd/yy)Mar | 0 | |
|
200 | |
|
|
|
|
|
| Total | 2000 | 1800 | 0 | 200 | 1800 | 1445 | 355 | 1445 | 935 | 510 |
| Remainig Book In Stock | 200 | |
|
|
|
|||||
