Note to Expert; No numeric data was given for this question. the idea is to create a numeric data for a start-up business called(National Security Robotic Servies) that specializes in providing robotic services to prison systems around the nation. this question is part of a business plan, and I have no idea on how to create a numeric data for a business to utilize.

COST OF DOING BUSINESS

What are the costs of doing business? Equipment, supplies, salaries, rent, utilities, and insurance are just some of these expenses. Estimate what it will cost to do business for one year.

Hint: Insert the costs associated with doing business in the table below. The list below provides some hints as to where you can get this information. Note that these are just estimatesjust try your best to include accurate costs for the expenses you think will be a part of doing business.

Hints for each expense in the table:

Rent: Refer to the floor plan. How many square feet is your place of business? What is the going rate per square foot for office space in your community? A real estate agent or a local SBA representative (www.sba.gov) can also be helpful in answering this question.

Salaries: Refer to the organizational chart. How much will each employee earn? How many hours will each employee be needed on a weekly basis? Once youve determined the weekly cost, expand it to a monthly and a yearly cost.

Supplies: Refer to the floor plan. How much will all the computers, equipment, and furniture cost? What kinds of general office supplies will you need? Most prices for this information can be found on an office supply Web site, such as www.staples.com.

Advertising and Other Promotions: Refer to your marketing section. You have described how you wish to reach your customernow you need to decide how much it will cost. If you are using television, contact the sales department at a local station. If you are using newspaper, contact their advertising department. Salespeople are usually happy to answer your questions.

Utilities: These amounts will vary, depending on your business and what utilities you will pay. If your business looks like an office, this cost may be similar to what a homeowner pays. However, if your business involves making a product, then the costs will be significant. An SBA representative can be a good resource.

Insurance: This value will be affected by the nature of the business. More equipment will usually mean higher insurance costs. Again, contact an SBA representative for feedback.

EXPECTED REVENUE

How much will you charge for your product? How many products do you believe you can sell in one year (or how many customers do you think your business can attract)? Multiply the price you will charge by the number of products you hope to sell or the amount you hope each customer will spend. This will give you an estimate of your revenues for one year.

Hint: You will use the amounts you calculate in the costs and revenues questions in this part of the plan in the accounting statements in the next part, so be as realistic as you can.

INCOME STATEMENT AND BALANCE SHEET

Create a balance sheet and an income statement (profit-and-loss statement) for your business.

Hint: You will have two options for creating these reports. The first option is to use the Microsoft Word versions that are found within this Business Plan Student Template (which follow).

The second option is to use the specific templates created for each statement in Microsoft Excel. If you make adjustments, these calculations will be performed automatically for you.

Income Statement (Profit-and-Loss Statement)

June

July

Aug.

Sept.

Oct.

Nov.

Dec.

YEARLY

Revenue (Sales)

Category 1

Category 2

Total Revenue (Sales)

Cost of Goods Sold

Category 1

Category 2

Total Cost of Goods Sold

Gross Profit

Expenses

Rent Expense

Salary/Wage Expenses

Supplies Expense

Advertising Expense

Utilities Expense

Telephone/Internet Expense

Insurance Expense

Interest from Loans (if applicable)

Other Expenses (specify)

Total Expenses

Net Profit

Balance Sheet

Assets
Current Assets
Cash
Cash Value of Inventory
Prepaid Expenses (insurance)
Total Current Assets
Fixed Assets
Machinery and Equipment
Furniture and Fixtures
Real Estate/Buildings
Total Fixed Assets
Total Assets
Liabilities and Net Worth
Current Liabilities
Accounts Payable
Taxes Payable
Notes Payable (due within 12 months)
Total Current Liabilities
Long-Term Liabilities
Bank Loans Payable (greater than 12 months)
Less: Short-Term Portion
Total Long-Term Liabilities
Total Liabilities
Owners Equity (Net Worth)
Total Liabilities and Owners Equity	Question; Please create an Income statement and a Balance sheet for a newly formed company named Maximum Security Robotics(MSRS), that will be specialized in delivering human formed robots to prison systems to help minimize assaults, deaths and law suits.