Care Clinic is preparing a worksheet for their staff. Their average starting salary is $60,000. Benefits are 25% this year. They expect them to go up to 27% next year. They are expecting to give a raise of 5% next year. Care Clinic has 20 employees. Prepare a formatted Excel Spreadsheet for Care Clinic. How much is the Total Staff Expense

Answers

Answer 1

Answer:

$1,600,200

Explanation:

The total staff expense can be calculated by using the following formula:

Total Staff Expense = (Salary For coming year with increment (STEP1)       +     Benefits In-Kind)  * Total Employees

Here

Salary for Coming Year with Increment is $63,000 (Step1)

Total employees are 20 in Number

Benefits In-Kind per employee is 27% of salary which is $17,010 ($63,000 * 27%)

By putting values, we have:

Total Staff Expense = ($63,000 + $17,010) * 20 Employees

Total Staff Expense = $1,600,200

STEP 1: Find Salary for Coming Year with Increment

Salary for Coming Year with Increment = Average Salary Now * (1 + Increment)

Here

Average Salary is $60,000

Increment is 5%

Salary for Coming Year with Increment = $60,000 *(1 + 5%) = $63,000

EXCEL Formatted Spreadsheet For Care Clinic

                                  Increment       Avg.        BIK     T. Employees  Total

                                              5%          Salary    at 27%        

Total Salary       60000     105%     63000 -            20               1,260,000

Benefits In-Kind 60000      105%     63000 27%            20        340200

                                                                                                             1,600,200


Related Questions

nother similar question, reattempt last question below, or select another question. Start of Questions A company makes greeting cards and their research shows that that price and demand are related linearly: p = m x + b . They know that for every additional card they wish to sell they need to drop the price by $0.05. They also know that in order to sell 320 cards they need to set the price at $7. Find the linear equation relating price to demand.

Answers

Answer:

p = (-0.05)x + 23

Explanation:

The linear equation relating price to demand. can be calculated by finding the value of b first and then putting the value of b in the equation

Data

Equation: p = m x + b

m = -0.05

x = 320

p = $7

Solution

p = m x + b

7 = (-0.05 x320)+b

7 = -16 + b

7+16 = b

b = 23

So the linear equation relating price to demand after putting the value of b will be

Equation: p = (-0.05)x + 23

McKerley Corp. has preferred stock outstanding that will pay an annual dividend of $4.00 per share with the first dividend exactly 10 years from today. If the required return is 3.66 percent, what is the current price of the stock?

Answers

Answer: $79.08

Explanation:

From the question, we are informed that McKerley Corp. has preferred stock outstanding that will pay an annual dividend of $4.00 per share with the first dividend exactly 10 years from today and that the required return is 3.66 percent.

The current price of the stock will be calculated thus:

At the end of year 9, the price will be:

= 4/3.66%

= 4/0.0366

= 109.29

The Price Today will be:

= 109.29/1.0366^9

= 79.08

On January 1, 2012, Uncle Company purchased 80 percent of Nephew Company’s capital stock for $672,000 in cash and other assets. Nephew had a book value of $806,000 and the 20 percent noncontrolling interest fair value was $168,000 on that date. On January 1, 2011, Nephew had acquired 30 percent of Uncle for $325,750. Uncle’s appropriately adjusted book value as of that date was $1,052,500.
Separate operating income figures (not including investment income) for these two companies follow. In addition, Uncle declares and pays $30,000 in dividends to shareholders each year and Nephew distributes $4,000 annually. Any excess fair-value allocations are amortized over a 10-year period.
Uncle Nephew
Year Company Company
2012 $131,000 $44,600
2013 174,000 55,000
2014 213,000 68,200
A. Assume that Uncle applies the equity method to account for this investment in Nephew. What is the subsidiary’s income recognized by Uncle in 2014?
B. What is the noncontrolling interest’s share of 2014 consolidated net income?

Answers

Answer:

a. $51,840

b. $15,440

Explanation;

a. First find the excess fair-value allocation;

= Fair value of Nephew - Book Value

Fair Value = Uncle ownership + Non-controlling interest

= 672,000 + 168,000

= $840,000

Excess fair value = 840,000 - 806,000

= $34,000

Any excess fair-value allocations are amortized over a 10-year period;

= 34,000/10

= $3,400

The Income to be recognized will be reduced by this yearly amotization so the 2014 income recognized by Uncle would be;

= (Nephew income - Amortization) * Uncle ownership stake

= ( 68,200 - 3,400) * 0.8

= $51,840‬

b. Nephew Company also owns 30% of Uncle which means that they will receive 30% of Uncle dividends.

= 0.3 * 30,000

= $9,000

Added to their own income;

= 9,000 + 68,200

= $77,200

The Non-controlling interest owns 20% so the income they will recognise is;

= 0.2 * 132,100

= $15,440‬

What does it mean for a product to have inelastic demand? A small change in the price has very little effect on the quantity of that product demanded. There is particularly high competition with the product, and an increase in price has a big impact on demand. The price for the product will increase as demand for the product increases. More of the product will be demanded at a lower price than for a higher price.

Answers

Answer:

I believe your answer will be (A price increase does not have a significant impact on buying habits)

Explanation:

A small change in the price has very little effect on the quantity of that product demanded, is it mean for a product to have inelastic demand. Hence, option A is correct.

What is the effect of a change in price on quantity?

When non-price variables are eliminated, it follows that higher prices lead to lower volumes demanded and lower prices lead to higher quantities demanded. As a result, according to the rule of demand, there is an inverse relationship between a product's price and the quantity that is demanded for it.

An increase in price has a relatively slight influence on quantity demanded; the equilibrium quantity percentage growth is less than the price change percentage change, and the resulting price elasticity has an absolute value below 1.

Thus, option A is correct.

For more details about effect of a change in price on quantity, click here:

https://brainly.com/question/15735983

#SPJ5

Not all buyers of an industry's product have equal degrees of bargaining power with sellers, because

Answers

Answer:

some sellers may be less sensitive than others to price, quality, or service differences.

Explanation:

Bargaining power is defined as the ability of a buyer to demand for better quality product, better service, or lower prices for goods.

Buyer bargaining power is higher in markets where products are undifferentiated from one another. So no single buyer has ability to determine price and quantity because buyer has other choices.

However where products are differentiated buyers have less bargaining power. This is because they may have no choice when a particular firm produces what they want.

Differentiated markets leads to some sellers having less sensitivelity than others to price, quality, or service differences.

Answer:

There are several reasons why this can happen and they depend on whether the market is a sellers' or buyers' market. A sellers' market is generally one where the number of buyers is very large and they tend to make small transactions. On the other hand, sellers are less sensitive to price or product differentiation because demand is higher than the supply. This results in a shortage of goods which in turn gives the sellers higher pricing power.

A firm that uses ___________ segmentation divides a market into groups based on age, income, or level of education.

Answers

Answer:

Demographic

Explanation:

Demographic segmentation is when a business divides its market according to characteristics like race, age, gender, income, religion and level of education to have a better understanding of the customer's preferences and needs to be able to design strategies that reach the target market more effectively. According to this, the answer is that a firm that uses demographic segmentation divides a market into groups based on age, income, or level of education.

The holder of a $1,000 face value bond can exchange the bond any time for 25 shares of stock. Then the conversion ratio:

Answers

Answer:

Conversion ratio is 25:1

Explanation:

Conversion ratio explains the number of shares that you can get for one bond. Here the number of shares that you are getting for 1 $1000 face value bond is 25 shares. Therefore, the conversion ratio is 25:1

The conversation ratio can also be calculated by dividing the par value of a bond for a share's price. As we do not have the price of 1 share, we will use the quantity to decide the conversion ratio.

Bramble Corp. is planning to sell 1300 boxes of ceramic tile, with production estimated at 1270 boxes during May. Each box of tile requires 44 pounds of clay mix and a 0.50 hour of direct labor. Clay mix costs $0.40 per pound and employees of the company are paid $18 per hour. Manufacturing overhead is applied at a rate of 110% of direct labor costs. Bramble has 4600 pounds of clay mix in beginning inventory and wants to have 4500 pounds in ending inventory. What is the total amount to be budgeted in pounds for direct materials to be purchased for the month?

Answers

Answer:

Purchases= 55,780 pounds

Explanation:

Giving the following information:

Production= 1270 boxes

Each box of tile requires 44 pounds of clay mix

Bramble has 4,600 pounds of clay mix in beginning inventory and wants to have 4500 pounds in ending inventory.

To calculate the purchase required, we need to use the following formula:

Purchases= production + desired ending inventory - beginning inventory

Purchases= 1,270*44 + 4,500 - 4,600

Purchases= 55,780 pounds

"can charge a different price for each customer based on that buyers willingness to pay, they would:"

Answers

Answer: b. Producer surplus is maxmized

Explanation:

As a result of inefficiency in a monopoly market, there exists a deadweight losses that arises because customers lose surplus due to not getting the optimal price. As a result, they are unwilling to spend at a certain amount to buy goods and services which leads to a loss for the monopoly as well.

If a monopoly is able to charge a different price for each customer based on that buyers willingness to pay they would be able to capture all the consumer surplus and make it producer surplus so that the producer surplus is maximized.

Store Travel Time Each Way Price of a Dress
(Minutes) (Dollars per dress)
Local Department Store 15 104
Across Town 30 87
Neighboring City 60 80
Juanita makes $36 an hour at work. She has to take time off work to purchase her skirt, so each hour away from work costs her $36 in lost income. Assume that returning to work takes Juanita the same amount of time as getting to a store and that it takes her 30 minutes to shop.
Assume that Juanita takes opportunity costs and the price of the dress into consideration when she shops. Juanita will minimize the cost of the dress if she buys it from the_______.

Answers

Answer and Explanation:

For the local departmental store

As the person travels 30 minutes but the person sacrificed $36 for an hour at work so here the opportunity cost of the time is $36

For the across town

The person J travel time is 60 minutes ( 30 + 30) and her shopping time is 30 minutes but sacrificed $36

So the opportunity cost is

= 60 minutes + 30 minutes

= 90 minutes

= $54

For the neighbor city

The person J travel time is 120 minutes (120 + 120) and her shopping time is 30 minutes but sacrificed $36

So the opportunity cost is

= 120 minutes + 30 minutes

= 150 minutes

= $90

Now the table is

Store    Opportunity Cost            Price of a Dress      Total Cost

             of Time  

              (Dollars)                          (Dollars per dress)   (Dollars)

Local

Department

Store            36                                   104                         140

Across Town 54                                  87                          141

Neighboring City  90                          80                          170

So she should buy from the local department cost as it contains the minimum cost

Which of the following are examples of long-run fixed costs:_______a. Mortgage payments b. Hourly wage costs c. Payments for production inputsd. None of the above

Answers

Answer:

a. Mortgage payments

Explanation:

Fixed costs are costs that do not vary with output. e,g, rent, mortgage payments

If production is zero or if production is  a million, Mortgage payments do not change - it remains the same no matter the level of output.

Hourly wage costs and payments for production inputs are variable costs

Variable costs are costs that vary with production

If a producer decides not to produce any output, there would be no need to hire labour and thus no need to pay hourly wages.

44. What's the present value of a perpetuity that pays $250 per year if the appropriate interest rate is 5%?

Answers

Answer:

$5,000

Explanation:

A perpetuity pays $250 every year

The appropriate interest rate is 5%

= 5/100

= 0.05

Therefore the present value of the perpetuity can be calculated as follows

= 250/0.05

= $5,000

Hence the present value of the perpetuity is $5,000

Which one of the following would not be considered an advantage of the corporate form of organization?a. Limited liability of ownersb. Separate legal existencec. Continuous lifed. Government regulation

Answers

Answer:

Disadvantage of Corporate Form of Organization:

d. Government regulation

Explanation:

In recent times, government regulation of businesses appears to be regarded as a disadvantage of the corporate form of organizations.  Governments intervene and regulate corporate entities whenever they fail to be self-regulatory.  But, the regulations may appear to be so much that the corporate form of organization now looks like a disadvantage.  Given the many corporate scandals, collapses, and misapplications of resources by corporate entities that have become the order of the day, government regulation is very important.  Without government regulation, many corporate bodies will not be acting in the public interest.  This is more so with public entity corporate organizations with diverse stakeholders and corporate managers who act as if they were running their own autonomous governments.

Research from the 1970s to the 1990s found that over 90 percent of a fund's returns over time is explained by

Answers

Answer: Asset allocation

Explanation:

Research from the 1970s to the 1990s found that over 90 percent of a fund's returns over time is explained by asset allocation.

It should be noted that asset allocation is simply referred to as an investment portfolio technique which balance risk through the division of assets among major categories like stocks, bonds, cash, real estate, and derivatives.

A _____ is an alternative method to cash dividends that is used to distribute a firm's earnings to shareholders.

Answers

Answer:

"Share Repurchase " would be the correct one.

Explanation:

Application whereby a company is buying back one's free-market stock. Typically it occurs whenever the shares are oversold or overvalued. Even though repurchase decreases the number of common shares and therefore also raises the return on equity, it helps in enhancing the equity value of the investment investors and shareholders kept.

At the start of 2071 Cowboy Corp. purchased 25% of Bebop Tech Inc. for $45 million. At the time of purchase, the carrying value of Bebop Tech's net assets was $75 million. The fair value of Bebop Tech's depreciable assets (5 year useful life remaining) was $25 million in excess of their book value. For this year, Bebop Tech reported a net income of $50 million and declared and paid $25 million in dividends. What amount will Cowboy Corp. recognize as additional depreciation at the end of 2071?
A. $6.25 Million
B. $5 Million
C. $1 Million
D. $125 Million

Answers

Answer:

B. $5 Million

Explanation:

The amount of  additional depreciation that Cowboy Corp. would recognize in the year 2071 is the excess of Bebop Tech Inc.'s fair value of assets over the book value divided by the useful life remaining which is 5 years

The excess of fair value of assets over book value was $25 million

The remaining useful in respect of the assets was 5 years

The additional depreciation recognizable=$25 milion

The additional depreciation =$25 million/5

The additional depreciation=$5 million

The price that the writer of a call option receives for the underlying asset if the buyer executes her option is called the

Answers

Answer:

D. strike price or exercise price.

Explanation:

The strike price is the price at which the price is defined at the time when the option holder could purchase in case of the call option and sell in case of put option, also the option is exercised when the security is underlying

Plus, the strike price another name is the exercise price

Therefore the given situation is known as strike price or exercise price.

What is the effect on the financial statements of recording a $15,000 repair expense as a debit to Machinery and a credit to Cash?

Answers

Answer:

The net income and assets for the year will be overstated by $15,000.

Explanation:

A repair expense of $15,000 is a period cost that should be expensed in the period in which it is incurred and not carried forward to the next accounting period or capitalized.  By capitalizing this repair expense, the net income and assets for the period are overstated.  The concept of accrual is also not followed.  Repair expense can only be capitalized when it adds to the value of an asset, which it does not possess before the repair.  But ordinarily, repairs restore an asset to its former value and does not add to the value.

Why is it difficult for most small business owners to raise the capital needed to start, operate, or expand their ventures?

Answers

Answer:

1. It is not easy to get funds for a start up, as many banks do not consider it as a successful decision to provide loan to a start up, as the feasibility of recovery of loan cannot be identified and guaranteed.

2. Venture capitalists also faces the same issue as of bank, also they are large equity investors and tend to invest in even larger project.

3. Private investors do not blindly invest and rather are more cautious then banks or venture capitalists, as because they do not huge funds to invest, and with less amount of investment they need even higher assurance.

4. Public stock is never available for a start up as for public stock issue you need great credibility, and good previous record.

_____________ are sunk costs because the company will have to pay the cost no matter production or other variables in operations.

Answers

Answer:

E. Fixed Costs

Explanation:

Here are the options to this question :

A. Variable Costs

B. Labor Costs

C. Total Costs

D. Raw material Costs

E. Fixed Costs

Sunk costs are costs that have already been incurred and cannot be recovered. They should not be considered when making future economic decisions.

Fixed cost is cost that do not vary with production. e.g. rent

Most companies pay rent per year. if due to unforeseen contingencies, sales and profit of the company declines and the company decides to shut down production, the company has already paid for rent, this amount cannot be recovered even though the company would not be using the space for sometime. So, rent is an example of sunk cost

When a municipal bond has a net revenue pledge, what is the first item that gets paid from the revenue received

Answers

Answer: Operations and maintenance

Explanation:

A municipal bond, is simply a bond that is issued by a either a territory, its agency or the local government, to help finance public projects like infrastructure, airports, roads, schools, and seaports.

Therefore, when a municipal bond has a net revenue pledge, the first item that gets paid from the revenue received will be for Operations and maintenance.

Opportunity costs are an important consideration for managers when deciding whether to accept special orders.
a) true
b) false

Answers

Answer:

True

Explanation:

When deciding whether to accept special orders, it is important that opportunity costs is considered by managers.

It helps managers to make a good choice and not regret later.

When deciding whether to accept special orders, it is important to compare and calculate what extra revenues that will be made against the extra costs that will be incurred.

Opportunity costs is actually a hypothetical cost which is incurred due to going for an alternative over the other available.

Answer:

True got you man

Explanation:

True

When a seller allows a buyer an amount for old equipment traded in for new equipment having a similar use, this amount is called boot. the trade-in allowance. commercial substance. None of these choices are correct.

Answers

Answer: the trade in allowance

Explanation:

Trade alliances is an offer made by marketers to the distribution line channels like the wholesalers, retailers etc over a specific period of time particular in order to boost sales and encourage reduction in retail price.

When a seller allows a buyer an amount for old equipment traded in for new equipment having a similar use, this amount is referred to as the trade in allowance.

According to the technical approach, what matters in exchange rate determination is:____________.
A. the past behavior of exchange rates.
B. the velocity of money.
C. the future behavior of exchange rates.
D. the beta.

Answers

the future behavior

Which of the following are advantages that firms could gain by working together as if were a monopoly?
A. Firms can charge a higher price.
B. Firms can increase industry productivity.
C. Firms can hold down industry output.

Answers

Answer:

A. Firms can charge a higher price.

C. Firms can hold down industry output.

Explanation:

As we know that

There is only one seller in the monopoly market which determinant of the overall market. The vendor demanded the heavy price and there's no competition because of this. This market contains free to enter and exit

so the first option satisfy this condition also it hold down the output of an industry

Therefore the option A and C is correct

Hence, the option B is incorrect

What is the present value of a 3-year annuity of $150 if the discount rate is 7%? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

Answers

Answer:

PV= $393.65

Explanation:

Giving the following information:

Cash flow= $150

Number of periods= 3 years

Interest rate= 7%

To calculate the present value of the annuity, first, we need to determine the future value:

FV= {A*[(1+i)^n-1]}/i

A= annual cash flow

FV= {150*[(1.07^3) - 1]} / 0.07

FV= $482.24

Now, the present value:

PV= FV/(1+i)^n

PV= 482.24/1.07^3

PV= $393.65

The tax basis for an investor in a limited partnership that establishes the maximum loss deduction is:

Answers

Answer: . I, II, III, IV

Explanation:

Here is the completed question:

The tax basis for an investor in a limited partnership that establishes the maximum loss deduction includes:

I original investment

II partnership debt assumed

III distributive share of partnership gains

IV distributive share of partnership losses

A. I only

B. I and II only

C. III and IV only

D. I, II, III, IV

It should be noted that an investor that is in a limited partnership will out forward a "tax basis" whereby there's limit limit for tax deductions that are allowed.

Therefore, the tax basis for an investor in a limited partnership that establishes the maximum loss deduction is original investment, partnership debt assumed, distributive share of partnership gains and the distributive share of partnership losses.

_____________ is calculated by taking the quantity of everything that is sold and multiplying it by the sale price.

Answers

Answer:

A) Total revenue

Explanation:

The total revenue could be computed by taking the sale price with the quantity to be sold

Here is the formula to determine the total revenue which is shown below:

Total revenue is

= Sale price × quantity

= P × Q

Hence, for the given situation, the total revenue is the answer and the same is to be considered

___________ not only involves thinking through what it is that the negotiator wants to achieve but also how she is going to achieve it.

Answers

Answer:

B. Preparation

Explanation:

A. Assertiveness

B. Preparation

C. Self-confidence

D. End-states

Preparation not only involves thinking through what it is that the negotiator wants to achieve but also how she is going to achieve it.

It is a management principle which allows consumers get ready on how to purchase a product.

Preparation helps consumers to think about the effective way of negotiating price with the seller and ensuring a successful negotiation.

strategic trade-offs that are different between Walmart and Nordstrom even though they are in the same industry. Think of another industry that you know fairly well and select two firms there that also have made very different choices for these trade-offs. Describe some of the differences between these firms. What type of trade-off decisions have these firms made

Answers

Answer: The answer is given below

Explanation:

Another industry that I know fairly well that also have made very different choices for these strategic trade-offs is a restaurant such as McDonald’s and the Michelin-starred. Even though they are in food industry, it should be noted that their approach is not thesame.

McDonald’s sells cheap, fast foods and typically employs workers who have low skills while Michelin-starred restaurant sells food that are of high quality and also has excellent service. It should also be noted that McDonald's doesn't really place much focus on the experience and the atmosphere while Michelin does.

Other Questions
Which structure is covered by a fatty layer of insulation? Which is the most likely reason that Jackson orders his men to not hurt Barbara? He is worried that Barbara will retaliate against them. He wants Barbara to continue spreading her message. He realizes that Barbara is an innocent woman. He wants to move through the town without distraction. Which Texas ecoregion experiences that largest change in temperature in a day? * Jane Had 3777 apples she added 3997 apples How can computers contribute toward creating a "paperless society"? (check all that apply)A.by making it easier to print copies for archival purposesB.by using LMS online programs in primary and secondary educationC. by increasing the scope and type of input devicesD. by making information available online to a larger number of people How does the antenna work to detect the electromagnetic signal produced when radio stations broadcast A cylindrical Benzene tank is 12ft high and 32in in diameter. How many kilograms of benzene can the tank store? help please make it good 6w + 9wy + 6 + 2wy 4y A story that end with statement: I had never felt so embarrassed in my life Simplify the expression 9/(-3)+4/(-8) A shoppers discount club charges a monthly fee of $15 and sells gasoline for $2.05 per gallon. The gas station across the street sells gasoline for $2.35 per gallon and charges no fee. Write and equation to model how many gallons of gasoline would you have to buy in one month to spend the same amount at either store Sodium only has one naturally occuring isotope, Na23 , with a relative atomic mass of 22.9898 u. A synthetic, radioactive isotope of sodium, Na22 , is used in positron emission tomography. Na22 has a relative atomic mass of 21.9944 u. A 1.5909 g sample of sodium containing a mixture of Na23 and Na22 has an apparent "atomic mass" of 22.9785 u . Find the mass of Na22 contained in this sample reaction container holds 5.77g of P4 and 5.77g of O2. The following reaction occurs: P4 + O2 P4O6. If enough oxygen is available then the P4O6 reacts further: P4O6 + O2 P4O10. (P=31, O =16)a. What is the limiting reagent for the formation of P4O10? (1mk)b. What mass of P4O10 is produced? (3mks)c. What mass of excess reactant is left in the reaction container? (1reaction container holds 5.77g of P4 and 5.77g of O2. The following reaction occurs: P4 + O2 P4O6. If enough oxygen is available then the P4O6 reacts further: P4O6 + O2 P4O10. (P=31, O =16)a. What is the limiting reagent for the formation of P4O10? (1mk)b. What mass of P4O10 is produced? (3mks)c. What mass of excess reactant is left in the reaction container? (1 Use the diagram below to find the value of x {NO} =17 {NP} =5x-6 Professionalism in nursing requires that a nurse "Referring to the order to buy 100 shares for DW at $50.02, if a trade is not effected on this day, which statement is TRUE?" in a science fiction movie, a woman proceeds through nine months of pregnancy in minutes. she takes in no nutrients during this time. she dies during labor, and an emergency c-section is performed to save the child. the child lives for only a matter of hours, rapidly aging, and dies a withered old man. a classmate claims that the movie is based on a government-documented but secret alien encounter. Anoche ustedes _____________________ regalos a m. (dar) Group of answer choicesA)daronB)deronC)dieronD)dio In digital forensics, all investigations follow the same basic methodology once permission for search and seizure has been obtained. Which is one of the elements of that process? What did the Sherman Anti-trust Act of 1890 intend to limit? (10 points) a corporate monopolies b trading with Central America c fur-seal extinction d tariffs on agriculture