My name is Marcarthur. I am a full time student at Syracuse University. I have no intentions of leaving this damn school until I obtain what I came here to get!

Monday, September 20, 2010

Entrepreneurship Lab 3rd post

When computing annual costs for the Super Screen, the best way to do so would be to use a spread sheet programs like Excel or Numbers. These programs can be useful with looking at long term statistics such as shipping costs, dates, inventory, supplies, customers personal information and many more things. This is a easy way to chart my company's information by myself so I always know exactly what is going on, or if I need access to certain things they're at my disposal.

Using applications like Excel and Numbers can be extremely beneficial just for the sake of organization, but it could also help me save money. For example, one could be reviewing the information and notice that too much money was spent on buying supplies. After realizing this we could look up the different people we buy our raw materials from and try to cut down. After looking this information up we could try to work out some type of deal, where my company could buy a certain amount of parts and receive a lower price based on consistency.

Excel and numbers have many resources within their programing. The most helpful to my product would be the use of the functions. These functions allow anyone to put formulas in cells to do calculations. One function that can be extremely helpful is the conditional formatting. This allows you to set rules for cell formatting. A specific way I could use conditional formatting would be to have one cell represent either positive or negative information regarding my money available versus the calculated expenses.
When my available money is less than my expenses I could have the cell light up in a solid red to draw attention. When the available money is greater I could have the cell light up in a solid green to symbolize everything is ok.







No comments:

Post a Comment