The Kingdom's Profits & Budget Spreadsheet

This is the profits-to-budget, divy-out banking spreadsheet for..:
The Vaux Kingdoms Budget Department:

• including allocations to governing departments, with % to each,
• Chart w/# of reserve years left to the pre-paid wage, based on balance.
• population estimates, & fields for the actual stats.
• estimations & fields for # of properties,
• income from property sales, 
• & other items such as fines,
• historical balances, in which to regain unspent savings into the years budget amount.
• Reserves sheet, for # of yrs. savings supplies the kingdom.

xlsx: Kingdom's Budget to Profits Calculator
google docs: Kingdom's Budget to Profit Calculator

I seems that I am finished with it, there were lastly a few zeros,
that kept turning up in place of text calls,
so I stopped most of the text call equations, how strange,
text box fields to text box fields calls used to work, as a spreadsheet capability.
I left 5 years of data-in, for looks, that needs to be cleared out before the actual starting date begins. 

On the 13th, I added an automated, load of values into the sales, page, for the population stats. & a few more columns ready for bank receives & sends on the properties page.

on the 11th, the new property listing page, is finished.

on the 10th,
consolidations for 20yrs. sections of dept. & savings,
worked out the awkward of the first year to the second issues of payments,
& am adding in the new property listing page, some time today.

On the 9th,
I updated population-add-features with %'s & optional
to the savings increase section.
& added a minimal department & savings spending to the first year.


Each yr listed, on the budget sheet,
pertains to income gathered during that yr.,
which is paid out at the beginning of the next.

On June 7th & 8th, 2014
a few new things, the property sales sheet,
& the 'Savings increase' section,
of 20 yrs, on the index page,
showing population numbers that can be supported with the pre-paid wage.
based on property sales & population increases.

On June 4th, 2014

the yearly tax collection section has been increased to be the monthly or quarterly collection for the certain businesses,
& also a new property sales amount section, as a guide for next years budget.
& The new reserve section on the budget page, holds days left with the pre-paid.

On June 3rd, 2014 all kinds of little code repairs,
& the new index sheet,
which front loads the main parameters for the other pages.

On June 2nd, 2014
the yearly tax collection section has been added, for specific businesses such as utilities companies, to the budget sheet, an index page, a private account withdrawl column for me & my family of the monarchy,
& a few other sheet clean-ups.

For added on May 31, 2014
an exacting mortgage helper for the property allowance sheet.

-----------
I updated it on May 30, 2014 with 5 yrs of data,
population growth & property purchases,
& there is a savings build for the Kingdom.


The added-in 25% income tax rate, & it works with earnings,
including the pre-paid wages, leaving enough for department
spending for most typical governments.

I still prefer the pre-paid only version that demands persons modify their lifes-styles a bit & use only profit shares, enhanced profit shares over having taxation, & there are pre-paid workers for a company. Therefore more initial gains to a company, that are returned as extra profits from profit shares than a taxed system with profit shares, which makes up the yearly wage difference.
& the bulk of the Kingdom's income from property sales. Lastly, implementing taxes only for Banks & Casinos, as they could help out as the balancers of the budget.

With the pre-paid only system, being a mandatory, a couple quick reasons are...
because the Kingdom is also a major purchaser of building supply centers,
for repairs of property, the Kingdom is further enabled at keeping building supply stores offering sustainable products.
& employees have more choices over where to work.

It is possible a Monaco system could be included,
with higher savings interest rates or no income tax on savings,
to lure banking customers in from other countries,
while offering loans,
a bonus income from loans towards the pre-paid wage,
though it is limiting, as it requires others from other countries in participation. & I am seeking a new world government financial system not only one country that is a tax haven.


I am still adding on to it, the program above, increasing pages...
to support more of the individual departments budget to sector data,
&  income lists for the real estate buy & sells and inheritances.
With each major update, I am writing a blog to explain it.
So, return to get the latest updated copies, from the above links.

New to include with the taxation section, 
is the 5% tax, specific to the major department stores,  that are selling food and clothing products. 
The tax is a year-end tax to each store, and therefore not a tax charged to the consumers.
 

Dealing with Crowds

As the days go on,

the people are not leaving,
as they have many requirements they need & want fulfilled:

People will become hungry, and the local shops are going to become empty.

Supplies into these shops may be difficult to re-stock due to crowds blocking the store fronts & roads.

A few vehicles have to be given access,
the food vans, & occasional ambulances.
shuttles back to other regions of the bay area,
to look after pets or persons left behind.

If the bart train stops or the electricty is cut,
we need to go back to possie judicial law.

Where certain persons guard the shops & food stores. 

Maintaining even more calm than before.

If a shop window is broken into,
the reason & the person(s) need to be found out as to the why. 

Other Importants:
large water tanks available for free water. 

free condoms available to young women in the crowd.

Food & Food Helpers:
People who want to make food right their fresh for the passerbys.
There will not be natural gas or ovens unless kitchens
within a few of the houses are used for cooking.
1-2 houses per block should be adequate.

Simple, Cheap & Quick Cooked foods,
Polentas (fine corn), Bulgour, or Couscous,
Cooked with mixtures of raisens or olives & spices, & a little vinagrete.

Crepes & pancakes

Healthy greens,
from the stores such as green beans, spinaches, collards, etc.
If the supplies run low, perhaps there are stinging nettles around, the park regions, that have not been pesticide sprayed.
As they can be used as a spinach replacement.

Baked or slow roasted items such as potatoes,
take longer electricity wise, therefore a luxury item, to go with.

Turnips, Carrots, Beets, Broccoli, Radishes can be handed out
with Fruits also... as they can all be eaten raw.

Please do not bring any meat into the feasting,
as it promotes aggressivity.

If people are selling food, that is their option,
though, I prefer free handouts from the kingdom & workers of the kingdom of the simple cuisines such as couscous & vegetable platters.
-----------------------



Better to separate the men from the women if possible,
back to women in this section of 100 persons, & men in another section of 100 persons, to avoid excesses in promiscuity.


Video speaker podiums available to the people, each 100 person area,
so each person there can have their questions answered formally and available to tv shows & computer rooms around the world.

A speaker podium at the front arena to have discussions with the next heirs to the throne & others workers from the kingdom directly.

At night a few low key bands can play, to help enjoy the Kingdoms begins.
-----------------------
Over a few days & the crowd is content with how the new government system works,  even with melted plastic plates for id,
then it is better to move the podium arena to in-class live video chats
with students of UC Berkeley & other universites, back to normal forum environments, not always be outdoors.

Inviting students from majors and minors in Government, Law, Civics, Economics, Business & the Mathematics Department.
Streaming video such as, Skype & google hangout to reach broader audiences.

The momentum of the Kingdoms budget continuance needs to be kept though,
hopefully with enough buys & sales of real estate already,
The above stated classes, & persons therein,
will be more than supportive of our new beginnings to stop poverty,
while maintaining an economy,on a global scale. 

---------- 

Quickie ID Cards

Back to the crowds in the SF Bay area demanding their 20,000 to the kingdom, before they leave to return to their houses & apartments.


Plastic Plates melted  and poured into shapes with forms.

a small written area on paper detailing:

name
eye color
hair color
body scars
birthmark
an unusual earring, & the other is worn during each sale.

The small piece of paper is then glued to the plastic card,
and a clear varnish is coated over the paper & card for protection.

This method is basic, though does give immediate proof of person quickly.

While, we wait for companies to create,
insert your card into a card reader, for instant 3d hologram views & videos freshly woven from our computer streams & other exotics of technology.

or while we update to the simple,
photo with your yorkie or indoor houseplant photo only version.

Its preferred, to not have to resort to being as a Luxembourg or Leichtenstein,
where you have to buy property to gain citizenship.
Though it brings an instant start to the Kingdom's financial earnestness,
so I can't knock it as a choice.

After a house has been paid for to the Kingdom,
then an ID card can be issued.
The 20,000 can then be deposited into your bank account.
It is better to go with 6 month deposits of 10000 each,
as the limiters to each days spend amount...
of always having 27 vas euro dollars til the end of the year
may not yet be implemented by the bank writers.

I prefer not to have to be force a purchase of a property on the people though,
rather go with the bounty of buys & sells creating a natural state of profit...that then funds businesses also.
& believe opening the market for persons to join the Kingdom immediately will already bring a profit in certain areas, such as the east bay of San Francisco.

Profit that runs the Kingdom & the people of the Kingdom.