You've budgeted for yourself. Great. Now, let's budget for the business . I need a budget with an associated income plan to meet the expenses listed below. List each product/service you will need to provide at what cost in order to meet your annual budget. If you are a non-profit, you may have income from both sales (earned revenue) and fundraising (contributed revenue). Indicate how much of each you will have and be specific. You may have to adjust some of your expenses to make your revenue match. This may include adjusting some of your salaries from last week. Make sure you update your original salary file so that it matches your budget when you upload your completed business plan
Assignment: In Excel, calculate the following expenses for one year :

•Salaries ( from week 6): Include other costs of the employee as well including taxes and benefits •Facilities (from week 7)
•Office Supplies, Software, Products or supplies specific to your industry, etc.
•Taxes
•Marketing
•Fees or subscriptions to industry organizations or publications
•Any other expenses your business may have.

Cash Budget
Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows:

All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of sale. Operating expenses total $41,000 per month and are paid during the month incurred. The cash balance on February 1 is estimated to be $20,000.

Prepare monthly cash budgets for February, March, and April.

Use negative signs only with beginning and ending cash balances, when appropriate. Do not use negative signs with disbursement answers.

Identify the debit or credit for the following transactions. Remember, every single transaction has at least one debit and at least one credit. However, I just want you to identify what is requested.

1,Sold merchandise on account. Identify the sale entry debit

2

3.

4.

5,

6.

7.

8.

9.

10.

11.

12.

13.

14.

15.

Choices are :

Note Payable,Unearned Rent Revenue, Cost of Goods Sold, Cash, Depreciation Expense, Miscellaneous Expense, Sales Revenue, Wages Payable, Fees Earned, Wages Expense, Accounts Receivable, Inventory, Prepaid Expenses, Note Receivable. Office Equipment, Accounts Payable, Supplies Expense. Rent Revenue, Accumulated Depreciation. Supplies

Washington County’s Board of Representatives is considering the construction of a longer runway at the county airport. Currently, the airport can handle only private aircraft and small commuter jets. A new, long runway would enable the airport to handle the midsize jets used on many domestic flights. Data pertinent to the board’s decision appear below.

In addition to the preceding data, two other facts are relevant to the decision. First, a longer runway will require a new snowplow, which will cost $155,000. The old snowplow could be sold now for $15,500. The new, larger plow will cost $13,000 more in annual operating costs. Second, the County Board of Representatives believes that the proposed long runway, and the major jet service it will bring to the county, will increase economic activity in the community. The board projects that the increased economic activity will result in $66,000 per year in additional tax revenue for the county.

In analyzing the runway proposal, the board has decided to use a 10-year time horizon. The county’s hurdle rate for capital projects is 6 percent.

Use Appendix A for your reference. (Use appropriate factor(s) from the tables provided.)

In analyzing the runway proposal, the board has decided to use a 10-year time horizon. The county’s hurdle rate for capital projects is 6 percent. The County Board of Representatives believes that if the county conducts a promotional effort costing $35,500 per year, the proposed long runway will result in substantially greater economic development than was projected originally. However, the board is uncertain about the actual increase in county tax revenue that will result.

Required:

Suppose the board builds the long runway and conducts the promotional campaign. What would the increase in the county’s annual tax revenue need to be in order for the proposed runway’s internal rate of return to equal the county’s hurdle rate of 6 percent? (Round intermediate and final answer to the nearest dollar amount.)

uired increase in tax revenue?

Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several markets in the southern U.S. The owners would like to estimate weekly gross revenue as a function of advertising expenditures. Data for a sample of eight markets for a recent week follow. Market Weekly Gross Revenue ($100s) Television Advertising ($100s) Newspaper Advertising ($100s) Mobile 103.5 4.9 1.7 Shreveport 51.6 3.3 3 Jackson 75.8 4 1.5 Birmingham 127.8 4.2 4 Little Rock 134.8 3.2 4.3 Biloxi 101.4 3.6 2.2 New Orleans 237.8 5 8.5 Baton Rouge 219.6 6.7 5.9 (a) Use the data to develop an estimated regression with the amount of television advertising as the independent variable. Let x represent the amount of television advertising. If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) = -45.432 + 40.064 x Test for a significant relationship between television advertising and weekly gross revenue at the 0.05 level of significance. What is the interpretation of this relationship? The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank (b) How much of the variation in the sample values of weekly gross revenue does the model in part (a) explain? If required, round your answer to two decimal places. 56 % (c) Use the data to develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables. Let x1 represent the amount of television advertising. Let x2 represent the amount of newspaper advertising. If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) = -42.57 + 22.402 x1 + 19.5 x2 Test whether each of the regression parameters β0, β1, and β2 is equal to zero at a 0.05 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank (d) How much of the variation in the sample values of weekly gross revenue does the model in part (c) explain? If required, round your answer to two decimal places. 93.22 %

PacRim Careers provides training to individuals who pay tuition directly to the business. The business also offers extension training to groups in off-site locations. Additional information available at the December 31, 2020, year-end follows:

1. An analysis of the company’s policies shows that $1,330 of insurance coverage has expired.
2. An inventory shows that teaching supplies costing $530 are on hand at the end of the year.
3. The estimated annual depreciation on the equipment is $9,000
4. The estimated annual depreciation on the professional library is $4,860.
5. The school offers off-campus services for specific employers. On November 1, the company agreed to do a special six-month course for a client. The contract calls for a monthly fee of $870, and the client paid the first five months' revenue in advance. When the cash was received, the Unearned Extension Revenue account was credited.
6. On October 15, the school agreed to teach a four-month class for an individual for $1,280 tuition per month payable at the end of the class. The services to date have been provided as agreed, but no payment has been received.
7. The school's two employees are paid weekly. As of the end of the year, three days' wages have accrued at the rate of $130 per day for each employee.
8. The balance in the Prepaid Rent account represents the rent for three months: December, January, and February.

Hawk Homes, Inc., makes one type of birdhouse that it sells for $31.00 each. Its variable cost is $14.50 per house, and its fixed costs total $14,124.00 per year. Hawk currently has the capacity to produce up to 2,100 birdhouses per year, so its relevant range is 0 to 2,100 houses.

Required:
1. Prepare a contribution margin income statement for Hawk assuming it sells 1,180 birdhouses this year.

2. Without any calculations, determine Hawk’s total contribution margin if the company breaks even.

3. Calculate Hawk’s contribution margin per unit and its contribution margin ratio.

4. Calculate Hawk’s break-even point in number of units and in sales revenue.

5. Suppose Hawk wants to earn $27,000 this year. Determine how many birdhouses it must sell to generate this amount of profit.

Using the degree of operating leverage, calculate the change in profit caused by a 5 percent increase in sales revenue. (Round your intermediate values to 2 decimal places. (i.e. 0.1234 should be entered as 12.34%.))

Prepare a contribution margin income statement for Hawk assuming it sells 1,180 birdhouses this year. (Enter your answers rounded to 2 decimal places.)

Without any calculations, determine Hawk’s total contribution margin if the company breaks even. (Enter your answer rounded to 2 decimal places.)

Calculate Hawk’s contribution margin per unit and its contribution margin ratio. (Round your answers to 2 decimal places. (i.e. .1234 should be entered as 12.34%.))

Calculate Hawk’s break-even point in number of units and in sales revenue. (Round your "Sales Revenue" answer to 2 decimal places and "Unit" answer to the nearest whole number.)

Suppose Hawk wants to earn $27,000 this year. Determine how many birdhouses it must sell to generate this amount of profit. (Round your answer to the nearest whole number.)

Required information

[The following information applies to the questions displayed below.]

Washington County’s Board of Representatives is considering the construction of a longer runway at the county airport. Currently, the airport can handle only private aircraft and small commuter jets. A new, long runway would enable the airport to handle the midsize jets used on many domestic flights. Data pertinent to the board’s decision appear below.

In addition to the preceding data, two other facts are relevant to the decision. First, a longer runway will require a new snowplow, which will cost $120,000. The old snowplow could be sold now for $12,000. The new, larger plow will cost $8,000 more in annual operating costs. Second, the County Board of Representatives believes that the proposed long runway, and the major jet service it will bring to the county, will increase economic activity in the community. The board projects that the increased economic activity will result in $80,000 per year in additional tax revenue for the county.

In analyzing the runway proposal, the board has decided to use a 10-year time horizon. The county’s hurdle rate for capital projects is 14 percent.

Use Appendix A for your reference. (Use appropriate factor(s) from the tables provided.)

In analyzing the runway proposal, the board has decided to use a 10-year time horizon. The county’s hurdle rate for capital projects is 14 percent. The County Board of Representatives believes that if the county conducts a promotional effort costing $28,000 per year, the proposed long runway will result in substantially greater economic development than was projected originally. However, the board is uncertain about the actual increase in county tax revenue that will result.

Required:

Suppose the board builds the long runway and conducts the promotional campaign. What would the increase in the county’s annual tax revenue need to be in order for the proposed runway’s internal rate of return to equal the county’s hurdle rate of 14 percent? (Round intermediate and final answer to the nearest dollar amount.)

1. what is the require increase in tax revenue in $

From Ojekunle, A. (Dec 2018), for Pulse: “President Muhammadu Buhari on Wednesday presented $28.80 billion (N8.83 trillion) budget for 2019 to the Nigerian National Assembly for scrutiny. This is President Buhari's fourth and last budget for his first term in office as he is also seeking re-election for the February 2019 presidential poll. The 2019 budget is placed on the following assumption:

a. Oil price benchmark of $60 per barrel;

b. Oil production estimate of 2.3 million barrels per day, including condensates;

c. An exchange rate of N305/$;

d. Real GDP growth of 3.01%; and

e. Inflation Rate of 9.98%.

Nigeria is estimating a total revenue at N6.97 trillion (which is 3% lower than the 2018 estimate of N7.17 trillion), consisting of oil revenue projected at N3.73 trillion while non-oil revenue is estimated at N1.39 trillion. Projected revenue from taxes: Companies Income Tax (CIT) - N799.52 billion Value Added Tax (VAT) - N229.34 billion Customs Duties - N302.55 billion. Independent Revenues to N624.58 billion. By implication, this shows Africa's largest economy with crude oil as its cash cow will still do below average on its diversification policies as oil takes centre stage in government revenue. Fuel subsidy continues and in the 2019 budget proposal, Nigerian government set aside N305 billion ($1 billion) for under-recovery by NNPC on PMS in 2019 (note: this refer to fuel subsidies). The budget deficit is projected to decrease to N1.86 trillion (or 1.3% of GDP) in 2019 from N1.95 trillion projected for 2018. This reduction is in line with plans to progressively reduce deficit and borrowings.” Give all of the above, answer the following questions:

a) Unemployment in Nigeria is now at 23%. Represent the market of goods and services in Nigeria given this figure and the data for growth and inflation above.

b) Assume that the government scraps fuel subsidies. What should happen to the public deficit, economic growth and inflation?

c) Does the data indicate that the government is running a contractionary or expansionary fiscal policy? Explain your reasoning.

d) Given the data above, what would you recommend in terms of monetary policy for the Nigerian Central Bank? Explain your reasoning.