Example of a Startup Budget w/ Six Month's Operating Expense

MS Excel - Create a Start up Budget and first 6 months operating expenses for your new Business using MS Excel. The Excel spreadsheet must include at a minimum the specifications listed below:
a. Create two worksheets. The first worksheet should contain your expected expenses for start-up cost. The second worksheet, what you expect it to cost to run your new business for the first 6 months.
b. Name the two worksheets on the tab. The first worksheet should be named "Startup Costs" and the second "6 Month Expenses."
c. Include the following information on the first worksheet:

1. Start up costs you might incur to start your business, such as equipment, supplies, deposits for electric, water, phone, etc. You may make up items and values based on your business.

Must have at a minimum 5 items.
Example: You need 10 laptops and each cost $1,599. Your total would be $15,990 for the computers. Fees to have water turned on might be $250 for a deposit.

2. Formulas for totals of the Startup cost.
3. Appropriate labels to identify all categories, columns, row, totals and other computed values.
4. A multi-row title section at the top of the first worksheet, merging cells as needed. Title should include a title for the worksheet, your name, course and section, and the date.

d. Include the following format for the first worksheet:
1. Column heading cells should have a background color and the text should be in Arial 12 point and bold.
2. Totals should be clearly labeled and the values formatted with dollar signs ($).
3. Title section at top of page should be in Font of choice 14 point, bold and a background color of choice.

e. Include the following information on the second worksheet:
1. Estimated monthly expenses for the first 6 months, such as salaries (don't forget your own salary), electric, water, phone, Internet connection, supplies and anything else you may need.

Must have at a minimum 5 expenses.

Example: You have talked to other business owners in the area and know they spend approximately $275 per month for electricity except in the winter months when it increases to roughly $350 per month. You need to hire 5 employees and you will start them out with different monthly salaries and they range from $2500 to $4600 per month (remember months with 31 days should be a little higher than those with 30 days).

2. Formulas for totals for each month and categories and an overall total for the 6 months.
3. Appropriate labels to identify all categories, columns, rows, totals and other computed values.

f. Include the following format for the second worksheet
1. Column heading cells should have a background color and the text should be in Arial 12 point and bold.
2. Totals should be clearly labeled and the values formatted with dollar signs ($).

g. Ensure your workbook has an appropriate layout that reflects the use of Excel concepts and techniques covered in class.

h. Ensure all choices made add to the creation of a professional, well-designed document and that spelling and grammar are correct.

Solution Preview

Attached, for your review, is a formatted MS Excel spreadsheet ...

Solution Summary

The attached MS Excel spreadsheet a detailed examples for the creation of a Business Startup Budget along with calculations for the determination of a Six Month Operating Expense budget.

$2.19

Purchase Solution

$2.19

Related Solutions

1. The production budget uses all of the following except:
a. the beginning inventory quantity.
b. the inventory policy.
c. the sales forecast.
d. the cash receipts budget.
2. Operatingexpenses are best budgeted on the basis of knowledge about:
a. relevant range.
b. cost behavior patterns.
c. current period bud

The scenario is in an acute care hospital setting:
- What is an operatingbudget?
- What is a capital budget?
- Why is a capital budget developed separately from the operatingbudget?
- What is the definition of a capital budget item in a organization?
- An example of a possible capital request in an organization?
Refere

Prepare merchandise purchase in columnar form:
The budget committee of Deaeon company collects the following data for its San Miguel Store in preparing budgeted income statements for May and June 2009.
1) sales for May are expected to be $800,000. Sales in June and July are expected to be 10% higher than the proceeding m

Why would the vice president of a company who receives an annual bonus based on profitability of the company want you to create a income statement that classified startup costs, research costs and development costs as a product costs?
What are the ethical considerations of reporting startup costs as product costs?
As a cor

I desperately need help with this problem. Can someone help me please?
Borders Manufacturing is developing a sales and production plan as part of its master budgeting process. Following are the projected monthly sales, which occur uniformly during each month for the upcoming year (see attached)
Production for each month eq

See attach files.
See attach excel file for spreadsheet example.
A Speedy-Mart Store in Northcenter Mall has the following budgeted sales, which are uniform throughout the month:
May $450,000
June 375,000
July 330,000
August 420,000
Cost of goods sold averages 70% of sales, and merchandise is purchased essentia

Black & Decker (B&D) manufactures a wide variety of tools and accessories. One of its more popular items is a cordless power handisaw. Use the following fictitious information about this product line to complete the problem requirements. Each handisaw sells for $50. B&D expects the following unit sales.
January 2,100