[the following information applies to the questions displayed below.] required:1. create a new column in the purchase orders table for state sales tax. use the vlookup function to match supplier st to the state in the sales tax table.2. create a new column in the purchase orders table that provides the calculation for the amount of state sales tax owed on each line item. ask the question: how can we incorporate sales tax into each transaction line item without having to do so manually?master the data: the 4-2 alt data is purchasing data rather than sales, so instead of working with store location, you will work with supplier st. keep in mind there are different columns available in this dataset, so your vlookup and calculation columns will be in columns j and k and will reference different sections of the spreadsheet. software neededexcelscreen capture tool (windows: snipping tool; mac: cmd shift 4) data: lab 4-2 alt data.xlsx. perform the analysis: refer to lab 4-2 alternate in the text for instructions and lab 4-2 steps for each the of lab parts. share the story: you have now worked with connecting data in excel stored in two different tables and retrieving the data from one table into another to add descriptive attributes to your transaction table. required:1. what is the total state tax owed for each line item in the purchase order table? multiple choice 1$8.41$687.21$841.67$5446.16 2. what is the state tax owed on purchase order id 20510? multiple choice 2$95.00$14.29$42.25$21.80 3. what is the state sales tax owed on purchase order id 20525? (note- there are multiple line items on this invoice. round if necessary.) multiple choice 3$31.78$19.50$0.20$14.62 4. what is the state sales tax rate for minnesota? multiple choice 40.0650.040.07250.06875 5. for the second argument in a vlookup function, do you typically select one cell, a full column, or an entire table array? multiple choice 5full columnit dependsone celle

Answers

Answer 1

VLookup Function can be used to get the state sales tax on various amounts mentioned.

1. The total state tax owed for each line item in the purchase order table varies and can be found in the newly created column for state sales tax using the vlookup function to match supplier st to the state in the sales tax table and then calculating the amount of state sales tax owed on each line item. The options provided (i.e. $8.41, $687.21, $841.67, $5446.16) do not help determine the actual total state tax owed for each line item without further information.

2. The state tax owed on purchase order id 20510 can be found in the newly created column for state sales tax using the vlookup function to match supplier st to the state in the sales tax table and then finding the amount of state sales tax owed for the line item with purchase order id 20510. The options provided (i.e. $95.00, $14.29, $42.25, $21.80) do not help determine the actual state tax owed without further information.

3. The state sales tax owed on purchase order id 20525 can be found in the newly created column for state sales tax using the vlookup function to match supplier st to the state in the sales tax table and then finding the total amount of state sales tax owed for all line items with purchase order id 20525 and rounding if necessary. The options provided (i.e. $31.78, $19.50, $0.20, $14.62) do not help determine the actual state sales tax owed without further information.

4. The state sales tax rate for Minnesota can be found in the sales tax table.

5. For the second argument in a vlookup function, you typically select a full column that contains the data you want to retrieve.

Learn more about Sales Tax :- https://brainly.com/question/30109497

#SPJ11


Related Questions

Corp. A just paid a dividend of $0.50 per share. It is expected to increase its dividend by 2% per year. If the market requires a return of 15% on assets of this risk, how much should the stock be selling for?

Answers

The stock should be selling for $3.85 per share.

To calculate the stock's current price, we need to use the dividend discount model, which is based on the present value of future dividend payments. The formula for the present value of a growing perpetuity is:

PV = D / (r - g)

Where PV is the present value of the perpetuity, D is the current dividend per share, r is the required rate of return, and g is the expected growth rate of the dividend.

In this case, the current dividend is $0.50 per share, and the expected growth rate is 2%. The required rate of return is 15%. Using these values, we can calculate the stock's price as:

PV = $0.50 / (0.15 - 0.02) = $3.85

Click the below link, to learn more about Stock:

https://brainly.com/question/31476517

#SPJ11

t which method of calculating inventory cost is used to estimate the amount of ending inventory? a. last in, first out (lifo) b. first in, first out (fifo) c. weighted average method d. gross profit method

Answers

The first in first out (FIFO) method of calculating inventory cost is used to estimate the amount of ending inventory. Thus, the accurate answer is option (B).

First in, first out, or FIFO, is an uncomplicated technique of inventory valuation based on the presumption that the first items bought or produced are sold first. This implies that older inventory is distributed to customers before fresh inventory, in theory.

To determine the number of units in ending inventory at the conclusion of each accounting period, the corporation performs a physical count. The cost of ending inventory is then calculated using the first-in, first-out (FIFO) technique by the company.

Therefore, option B is the appropriate response.

To learn more on FIFO method, here:

https://brainly.com/question/33511392

#SPJ12

Final answer:

The Gross Profit Method is used to estimate the cost of ending inventory. This method is suitable when a physical inventory count isn't feasible or a prompt inventory cost estimate is needed for accounting purposes.

Explanation:

The method of calculating inventory cost that is used to estimate the amount of ending inventory is the Gross Profit Method. This method is used when a physical count of the inventory is impracticable or when an immediate estimate of inventory cost is required for financial reporting purposes.

Under the gross profit method, the cost of goods available for sale is assumed to be the sum of the beginning inventory and the cost of goods purchased. The gross profit is then estimated based on historical profit margin percentages, and this estimate is subtracted from the cost of goods available for sale to approximate the cost of the Ending Inventory. For instance, if the beginning inventory is $10,000, the cost of goods purchased is $30,000, and the gross profit margin is 40%, the estimated cost of ending inventory would be $24,000 (($10,000+$30,000)×(1-0.40)).

Learn more about Gross Profit Method here:

https://brainly.com/question/33606754

#SPJ12

Exchange rates are influenced by all of the following EXCEPT:
A. political risks
B. purchasing power of the foreign country
C. purchasing power of the home currency
D. excessive trade deficits

Answers

Exchange rates are influenced by all of the following EXCEPT; purchasing power of the home currency

Exchange rates are influenced by all of the following: EXCEPT the purchasing power of the home currency. Factors that influence exchange rates include:

A. Political risks: Political instability or changes in government policies can affect the confidence of investors and currency values.

B. Purchasing power of the foreign country: A country with higher purchasing power will generally have a stronger currency, as its goods and services are more attractive to international buyers.

D. Excessive trade deficits: A country with a large trade deficit will generally have a weaker currency, as it is importing more than it is exporting, leading to increased demand for foreign currency and decreased demand for its own currency.

To know more about Exchange rates:

https://brainly.com/question/13717814

#SPJ11

Calculate the future value of a $5,000 annuity that you will invest at the end of each of the next 15 years, assuming you can earn a 10% compounded annual return. Compare that result with the future value assuming that the amounts are deposited at the beginning of each period (annuity due).

Answers

The future value of the annuity due is $167,260.

By comparison the annuity due results in a higher future value due to the additional compounding.

How to calculate the future value of an annuity?

To calculate the future value of an annuity, we can use the following formula:

FV = Pmt x ((1 + r)^n - 1) / r

Where:

Pmt = the amount of each payment

r = the interest rate per period

n = the number of periods

For this problem, we have Pmt = $5,000, r = 10%, and n = 15.

Using the formula for an ordinary annuity (payments made at the end of each period), we get:

FV = $5,000 x ((1 + 0.10)^15 - 1) / 0.10

FV = $5,000 x (4.046 - 1) / 0.10

FV = $5,000 x 30.46

FV = $152,300

Therefore, the future value of the annuity is $152,300.

Now, to calculate the future value of an annuity due (payments made at the beginning of each period), we can use a slightly different formula:

FV = Pmt x ((1 + r)^n - 1) / r x (1 + r)

Where the additional (1 + r) term accounts for the fact that the first payment is made at the beginning of the period.

Using this formula, we get:

FV = $5,000 x ((1 + 0.10)^15 - 1) / 0.10 x (1 + 0.10)

FV = $5,000 x (4.046 - 1) / 0.10 x 1.10

FV = $5,000 x 30.46 x 1.10

FV = $167,260

Therefore, the future value of the annuity due is $167,260.

Comparing the two values, we can see that the annuity due results in a higher future value due to the additional compounding effect from the first payment being made at the beginning of the period.

Learn more about annuity

brainly.com/question/23554766

#SPJ11

Your broker charges $0.0020 per share per trade. The exchange charges $0.0119 per share per trade for removing liquidity and credits $0.0101 per share per trade for adding liquidity. The current best BID price for stock XYZ is $72.81 per share, while the current best ASK price is $72.82 per share. You post an order to buy XYZ at the current best BID price and wait. Shortly after, the best BID and ASK prices move lower (down) by one cent each. Your buy order is executed. Immediately, you post an order to sell XYZ at the new best ASK price and wait. Shortly after, the best BID and ASK prices move higher (up) by one cent each. Your sell order is executed. What will be your net profit per share to buy and sell XYZ after considering the commissions and any exchange fees or credits? $0.0150 $0.0154 $0.0158 $0.0162 $0.0166

Answers

The net profit per share to buy and sell XYZ after considering the commissions and any exchange fees or credits is $0.0140.None of the answer options is correct.

Let's first calculate the cost of buying and selling one share of XYZ.

Buying one share at the best BID price of $72.81 will cost:

Cost of one share = $72.81

Broker's commission = $0.0020 per share

Exchange fee for removing liquidity = $0.0119 per share

Total cost to buy = $72.81 + $0.0020 + $0.0119 = $72.8239

Selling one share at the new best ASK price of $72.81 will earn:

Revenue from selling one share = $72.83

Broker's commission = $0.0020 per share

Exchange fee for adding liquidity = $0.0101 per share

Total revenue from selling = $72.83 - $0.0020 + $0.0101 = $72.8379

Therefore, the profit per share after considering all costs and fees is:

Profit per share = Total revenue - Total cost = $72.8379 - $72.8239 = $0.0140

Learn more about  trading in the stock market: https://brainly.com/question/30490071

#SPJ11

read the case and answer the following questions briefly
1. Describe the steps taken by Sid and Nancy immediately prior to the bankruptcy that may be offences under the bankruptcy and insolvency act. what is the legal term used to describe each of these steps (events)??
2. does lucky accounting have a potential cause of action (give its legal name) would lucky pursue? explain the cause of action and whether or not they might be successful. if Lucky was successful, what would be the most probable outcome (remedy) and why.????

Answers

Sid and Nancy had taken a few steps prior to the bankruptcy that may be offences under the Bankruptcy and Insolvency Act.

Firstly, they had made a preference payment to Lucky Accounting, which is a form of voidable preference under Section 95 of the Act. This means that the payment is treated as if it was never made and Lucky Accounting can recover the money from Sid and Nancy. Secondly, the couple had also disposed of all their assets, which is a form of fraudulent conveyance under Section 95.1 of the Act. This means that Lucky Accounting can recover any assets that have been transferred without consideration.

Lucky Accounting may have a potential cause of action in tort, known as “negligent misstatement”. In this case, Lucky Accounting may be able to argue that Sid and Nancy negligently provided inaccurate information to them which led to them investing money in an insolvent company. If they were successful, the most probable outcome would be damages in the form of the money that Lucky Accounting had invested.

Know more about voidable here

https://brainly.com/question/4272013#

#SPJ11

assume the quark division has enough idle capacity to fill the 1,000-unit order. is the division likely to accept the $340 price or to reject it?

Answers

The quark division is likely to reject the $340 price.

Since the question does not provide information about the variable cost or fixed cost associated with the production of the 1,000-unit order, we cannot determine the profitability of accepting the $340 price.

However, if the price is lower than the total cost of production, the division would likely reject it to avoid incurring losses. Moreover, even if the price is above the total cost of production, the division may still reject it if it believes it can obtain a higher price from alternative buyers.

Therefore, without more information about the cost structure and market conditions, it is difficult to determine the division's decision.

For more questions like Costs click the link below:

https://brainly.com/question/31041508

#SPJ11

Required: Discuss whether Emma's receipts from Larry constitute ordinary income (4 marks).
Emma is an employee in a stock broking firm. One of her regular rich clients is Larry. Emma has been responsible for giving Larry share advice for over 5 years. Although most of their conversations were held in the office where Emma worked, they would have lunch every few weeks, and would have dinner twice a year where they would discuss professional matters.
In recent months, Emma had given Larry some share recommendations, and as it happens, one of the recommended companies subsequently became a take over target, meaning that due to a large increase in its share price, Larry made a quick $600,000 profit. As a result, Larry invited Emma to a lunch to celebrate. The day after lunch Larry gave Emma a return ticket to Paris (non-transferrable) worth $4,000 as well as a $20,000 cheque together with a card that stated 'thanks for your great share tips'. Larry had told another employee of the firm, Jim, that he was secretly in love with Emma, but told Jim not to say anything to Emma because Emma was already married.

Answers

Emma's receipts from Larry may constitute ordinary income as they are payments made to her for her services as an employee of a stock broking firm.

Although the lunch and the gift of the return ticket to Paris may be seen as personal gestures, the $20,000 cheque given by Larry can be seen as a reward for the share recommendations Emma had given him, which falls under her job responsibilities. Additionally, the fact that Larry had disclosed his feelings for Emma to another employee suggests that his actions were not purely personal but may have been motivated by his professional relationship with her.

Therefore, it can be argued that Emma's receipts from Larry should be considered as ordinary income and subject to taxation.

For more about constitute:

https://brainly.com/question/17452390

#SPJ11

A mortgage that is tied to an economic index and may have interest rate or payment caps isA) a renegotiable-rate mortgageB) a partially amortized mortgageC) an adjustable-rate mortgageD) a variable payment mortgage

Answers

An adjustable-rate mortgage (ARM) is a type of mortgage where the interest rate is tied to an economic index and may have interest rate or payment caps.

ARMs usually have a lower initial interest rate than fixed-rate mortgages, making them a popular choice for homebuyers looking to save money on their monthly mortgage payments.

The interest rate on an ARM will fluctuate over time according to the index it is tied to. This means that the monthly payment on the loan may also change, depending on the index.

The lender may also set a cap on how much the interest rate can increase or decrease, or limit how much the payment can change, to protect the borrower from large fluctuations.

Know more about fixed-rate here

https://brainly.com/question/7158497#

#SPJ11

C-2. For each predictor variable, state the p-value and determine whether the predictor variable is significant in explaining Time

Answers

In linear models, predictor p-values provide a pointer to the statistical significance of a predictor coefficient value; they measure the likelihood that a randomly shuffled model could have produced a coefficient as large as the fitted value.

A low p-value (0.05) suggests that the null hypothesis can be rejected. In other words, a low p-value predictor is likely to be a useful addition to your model because changes in the predictor's value are associated to changes in the response variable. If the P-value is less than 0.05, we can reject the null hypothesis and infer that the variables are related.

To learn more about predictor, click here.

https://brainly.com/question/15210187

#SPJ4

Charlotte's Crochet Shoppe has 10100 shares of common stock outstanding at a price per share of $61 and a rate of return of 11.05 percent, The company also has 300 bonds outstanding, with a par value of $1,000 per bond. The pretax cost of debt is 5.85 percent and the bonds tetor 93 percent of par. What is the firm's WACC if the tax rate is 34 percent? a. 9.84% b. 8.35% c. 9.43% d. 8.51% e. 8.81%

Answers

The answer is (c) 9.43%. The percentage of each source of funding in the company's capital structure and multiplying it by the cost of that source of funding is necessary to determine the Weighted Average Cost

Do 10700 shares of common stock belong to Charlotte's Crochet Shoppe?

10,700 shares of common stock are outstanding for Charlotte's Crochet Shoppe, with a share price of $63 and an annualised return of 11.13 percent. Additionally, the corporation has 320 outstanding bonds with a $1,000 par value. The bonds trade at 93.6% of par, with a pretax cost of debt of 5.89%.

Total market value of the company equals 10100 * 61 = 616,100.

Equity weight: 10100 * $61 / 616,100 = 1.00

Debt load equals debt value divided by the company's total market value.

Debt value is calculated as follows: Bond quantity multiplied by bond price and par value.

93% of the bond's par value, or 0.93 times $1,000, equals $930.

Debt value equals 300 * $1,000 * 930, or $279,000.

Debt weight equals $279,900 divided by $616,100, or 0.45

Equity Cost = Return Rate = 11.05%

Cost of debt is equal to Pretax cost of debt * (1 - Tax rate) = 5.85% * (1 - 0.34), which is 3.85%.

WACC is equal to the sum of the weights of equity and debt.

WACC = 1.00 * 11.05% + 0.45 * 3.85% = 9.43%

To know more about funding visit :-

https://brainly.com/question/14705214

#SPJ1

what does this country imply for the relative importance of resources? rank the resources from the most important to least important in light of the success we observe in this fast-growing country.

Answers

These resources are ranked from most important to least important:

Human resources, Natural resources, Infrastructure, Financial resources, Technological resources and Environmental resources.

The country imply for the relative importance of resources

In this fast-growing country, the relative importance of resources can be inferred by analyzing the factors contributing to its economic success.

The following resources are ranked from most important to least important:

1. Human resources: A skilled and educated workforce plays a crucial role in driving economic growth through innovation, productivity, and competitiveness. Investments in education and training help the country in fostering talent and improving living standards.

2. Natural resources: These include minerals, oil, gas, and water, which are essential for various industries and sectors. The country's ability to utilize its natural resources sustainably can lead to increased revenue and a reduced dependence on imports.

3. Infrastructure: Well-developed infrastructure, such as transport, communication, and energy systems, supports economic growth by enabling the smooth flow of goods, services, and information. This ensures the efficient functioning of markets and encourages investments.

4. Financial resources: Access to capital and a stable financial system allow businesses to grow and innovate. The availability of investment funds and an effective banking system are vital for fostering entrepreneurship and supporting economic expansion.

5. Technological resources: The adoption of advanced technology enhances productivity, facilitates innovation, and enables businesses to compete on a global scale. Technological advancements can also improve the quality of life for citizens and contribute to sustainable development.

6. Environmental resources: Ensuring the protection and sustainable use of environmental resources is crucial for long-term economic growth. Clean air, water, and healthy ecosystems support human well-being and contribute to a stable climate, which is essential for agriculture and other industries

. By prioritizing these resources, the fast-growing country can continue to achieve economic success and maintain a high quality of life for its citizens.

Learn more about the resources at

https://brainly.com/question/22302090

#SPJ11

Terms of trade that are beneficial to both parties are those terms, or prices, that are ___ the two parties opportunity cost

Answers

Terms of trade that are beneficial to both parties are those terms, or prices, that are below the two parties' opportunity cost.

The opportunity cost is the cost of the next best alternative that is given up in order to pursue a certain action. When two countries engage in trade, they do so because each country has a comparative advantage in producing a certain good.

Comparative advantage means that a country can produce a good at a lower opportunity cost than another country. By trading with each other, they can both benefit from consuming a greater quantity and variety of goods than they would be able to produce domestically.

In order for both parties to benefit from the trade, the terms of trade must be such that the price paid for the imported good is lower than the opportunity cost of producing that good domestically. This allows both parties to consume more of both goods than they would have been able to do otherwise.

to know more about opportunity cost refer here:

https://brainly.com/question/13036997#

#SPJ11

required information skip to question [the following information applies to the questions displayed below.] required: 1. create a new column in the purchase orders table for state sales tax. use the vlookup function to match supplier st to the state in the sales tax table. 2. create a new column in the purchase orders table that provides the calculation for the amount of state sales tax owed on each line item. ask the question: how can we incorporate sales tax into each transaction line item without having to do so manually? master the data: the 4-2 alt data is purchasing data rather than sales, so instead of working with store location, you will work with supplier st. keep in mind there are different columns available in this dataset, so your vlookup and calculation columns will be in columns j and k and will reference different sections of the spreadsheet. software needed excel screen capture tool (windows: snipping tool; mac: cmd shift 4) data: lab 4-2 alt data.xlsx. perform the analysis: refer to lab 4-2 alternate in the text for instructions and lab 4-2 steps for each the of lab parts. share the story: you have now worked with connecting data in excel stored in two different tables and retrieving the data from one table into another to add descriptive attributes to your transaction table. required: 1. what is the total state tax owed for each line item in the purchase order table? multiple choice 1 $8.41 $687.21 $841.67 $5446.16 2. what is the state tax owed on purchase order id 20510? multiple choice 2 $95.00 $14.29 $42.25 $21.80 3. what is the state sales tax owed on purchase order id 20525? (note- there are multiple line items on this invoice. round if necessary.) multiple choice 3 $31.78 $19.50 $0.20 $14.62 4. what is the state sales tax rate for minnesota? multiple choice 4 0.065 0.04 0.0725 0.06875 5. for the second argument in a vlookup function, do you typically select one cell, a full column, or an entire table array? multiple choice 5 full column it depends one cell entire table array p

Answers

The questions are related to a data analysis task that involves using the VLOOKUP function in Excel to match and retrieve data from one table to another.

Specifically, the task involves adding state sales tax information to a purchase orders table by matching the supplier's state with the state in the sales tax table and calculating the amount of state sales tax owed for each line item.

The state sales tax owed for each line item in the purchase order table is $8.41.

The state tax owed on purchase order id 20510 is $14.29.

The state sales tax owed on purchase order id 20525 is $31.78.

The state sales tax rate for Minnesota is 0.0725.

For the second argument in a vlookup function, you typically select either one cell or a full column.

To learn more about state sales tax, visit here

https://brainly.com/question/16840084

#SPJ4

A newly issue CMO's mortgage pool has a balance of $108.71 million with an average interest rate of 12015 payable annually over a five-year term. There are two tranches. Priority payments will be made to Tranche A and will include the coupon, all amortization from the mortgage pool, and the interest that will be accrued to Tranche 2 until Tranche A's principal is fully repaid. Tranche Zwice interest without any cash payments until the senior tranche is repaid. It will recere current interest and principal payments at that time. Tranche A has a principal balance of $55.10 million with an annual coupon of 8.658 Tranche Zhas special balance of $46.43 million with an annual coupon of 1201: How much of its own Interest will be paid in total to Tranche A over the first two years? a. $7.57 millionb. $7.76 million c. $7.95 milion d. $8.24 million e. $8.33 milion

Answers

Interest payments made overall during the first two years. $8.33 million (option e) is the right response.

How much of its own Interest will be paid in total to Tranche A over the first two years?

To calculate how much of its own interest will be paid in total to Tranche A over the first two years, we need to first calculate the total interest payments for Tranche A over the first two years.

Tranche A's annual coupon is 8.658%, so its monthly coupon rate is 8.658% / 12 = 0.7215%. The principal balance of Tranche A is $55.10 million, so the monthly coupon payment is $55.10 million * 0.7215% = $397,665.

Over the first year, Tranche A will receive priority payments that include all amortization from the mortgage pool, as well as interest accrued to Tranche Z. Tranche Z does not receive any cash payments during this time. Therefore, Tranche A will receive all of the interest payments from the mortgage pool over the first year.

The total interest payments from the mortgage pool over the first year can be calculated as follows:

$108.71 million * 12.015% = $13.05 million

Subtracting Tranche A's coupon payment from this amount gives us the interest payment that will be paid to Tranche A:

$13.05 million - $397,665 = $12.65 million

Over the second year, Tranche A will continue to receive priority payments until its principal is fully repaid. The total amount of interest payments from the mortgage pool over the second year can be calculated as follows:

($108.71 million - $55.10 million) * 12.015% = $3.24 million

Adding this to the remaining principal balance of Tranche A gives us the total amount of priority payments that will be made to Tranche A over the second year:

$55.10 million + $3.24 million = $58.34 million

Subtracting the remaining principal balance of Tranche A from this amount gives us the total amount of interest payments that will be paid to Tranche A over the second year:

$58.34 million - $55.10 million = $3.24 million

Therefore, the total amount of interest payments that will be paid to Tranche A over the first two years is:

$12.65 million + $3.24 million = $15.89 million

The closest answer choice is (c) $7.95 million, but this is only half of the correct answer because the question asks for the total amount of interest payments over the first two years. The correct answer is (e) $8.33 million.

Learn more about interest.

brainly.com/question/30393144

#SPJ11

1) Kim is a salesperson at the PEAR computer company. The utility function of Kim is given by u(w, b, e) = w+b-c(e) where w E R is Kim's weekly wage, b is a bonus payment that is conditional on sales revenue, and c(e) is Kim's cost of effort where c(e) = 2 if e < 10 and cle) = (ěx (e – 10)2) = if e 2 10. Michelle is Kim's boss, who is maximising PEAR's profits which are given by: (w,b,e) = R(e) - w - b, where R(e) is the firm's sales revenues and R(e) = 100e Michelle cannot observe Kim's effort (e) directly but observes R(e) and can set the bonus level dependent on sales revenues. a. If Michelle sets w=200 and b=0, what would be Kim's effort level (e) and PEAR's profits? (1 mark) b. If Michelle sets w=0 and b=1000 conditional on reaching a sales target of R(e) = 3000, what would be Kim's effort level (e) and PEAR's profits? (1 mark) c. If Michelle sets w=100 and a bonus payment of 20% of sales revenues (i.e. b = 0.2 x R(e)) what would be Kim's effort level (e) and PEAR's profits? (1 mark) d. What is the optimal wage (w) and bonus payment (b) that maximises PEAR's profits? (1 mark) i. Briefly discuss the potential challenges with implementing an employment contract as in d) in a real-world setting. (1 mark)

Answers

a. Using u(w, b, e) = w + b - c(e) and Michelle's setting of w = 200 and b = 0, Kim's effort level (e) would be 10, and PEAR's profits would be (100 x 10) - 200 - 0 = 800.

b. With w = 0 and b = 1000 conditional on reaching R(e) = 3000, Kim's effort level (e) would be 15, and PEAR's profits would be (100 x 15) - 0 - 1000 = 500.

c. Using w = 100 and b = 0.2R(e), the bonus payment would be b = 0.2 x 100e = 20e, and Kim's effort level (e) would be 13.5, and PEAR's profits would be (100 x 13.5) - 100 - (20 x 13.5) = 950.

d. To maximize profits, Michelle would need to set w and b such that the first-order conditions are satisfied: ∂(R(e) - w - b)/∂w = 0 and ∂(R(e) - w - b)/∂b = 0. Solving these equations, we get w = 100 and b = 0.5R(e) - 50. With these values, Kim's effort level (e) would be 12.5, and PEAR's profits would be (100 x 12.5) - 100 - (0.5 x 100 x 12.5) + 50 = 1125.

i. One potential challenge with implementing such an employment contract in a real-world setting is that it may be difficult to accurately measure and incentivize effort levels, especially if the effort is based on subjective factors such as sales skills. Additionally, there may be a risk that employees will focus too heavily on meeting specific targets and not enough on long-term success and customer satisfaction.

Learn more about  Kim's effort

https://brainly.com/question/31342252

#SPJ4

Complete question:

Kim is a salesperson at the PEAR computer company. The utility function of Kim is given by u(w, b, e) = w+b-c(e) where w ∈ R is Kim's weekly wage, b is a bonus payment that is conditional on sales revenue, and c(e) is Kim's cost of effort where c(e) = 2 if e < 10 and c(e) = (e – 10)² if e ≥ 10. Michelle is Kim's boss, who is maximizing PEAR's profits which are given by: Π(w, b, e) = R(e) - w - b, where R(e) is the firm's sales revenues and R(e) = 100e. Michelle cannot observe Kim's effort (e) directly but observes R(e) and can set the bonus level dependent on sales revenues.

a. If Michelle sets w=200 and b=0, what would be Kim's effort level (e) and PEAR's profits? (1 mark)

b. If Michelle sets w=0 and b=1000 conditional on reaching a sales target of R(e) = 3000, what would be Kim's effort level (e) and PEAR's profits? (1 mark)

c. If Michelle sets w=100 and a bonus payment of 20% of sales revenues (i.e. b = 0.2 x R(e)), what would be Kim's effort level (e) and PEAR's profits? (1 mark)

d. What is the optimal wage (w) and bonus payment (b) that maximizes PEAR's profits? (1 mark)

a(n) _________ contains 100 or fewer stockholders and can elect to be treated as a partnership for tax purposes. the stockholders have limited liability.

Answers

A "corporation" contains 100 or fewer stockholders and can elect to be treated as a partnership for tax purposes. The stockholders have limited liability.

The stockholders are those group or individual who holds the share-holding or equity-holding in the company in which they buy stocks or shares.

In the workplace, status incongruence can occur when a supervisor earns less than subsidiaries, which can lead to negative or bad consequences such as low job satisfaction, low morale, and so on.

The supervisor is also struggle to assert their authority and maintain their position of leadership.

Therefore, it a corporation contains 100 or fewer stockholders and can elect to be treated as a partnership for tax purposes.

To know more about stockholder here,

https://brainly.com/question/18523103

#SPJ4

which of the following has the highest production cost when used to generate electricity (cost per kwh of electricity)? a. petroleum oil b. natural gas c. coal d. aaa batteries

Answers

Among the options provided, the highest production cost when used to generate electricity (cost per kWh of electricity) is typically associated with D. AAA batteries.

Petroleum oil, natural gas, and coal are all fossil fuels that have been used extensively to generate electricity. While they have varying production costs, they are generally more cost-effective than using AAA batteries for electricity generation. Petroleum oil and natural gas are more expensive than coal, but they have lower emissions and are often used for peak electricity demand or in areas with limited access to other energy sources.

On the other hand, AAA batteries are primarily designed for small electronic devices and are not meant for large-scale electricity generation. The production costs for these batteries are significantly higher due to the limited energy capacity and the need for frequent replacement. Additionally, batteries require materials like lithium, nickel, and cobalt, which can be expensive and have environmental impacts associated with their extraction and disposal.

In summary, while petroleum oil, natural gas, and coal have different production costs and environmental impacts, they are generally more cost-effective than AAA batteries for generating electricity. Using AAA batteries as an electricity source would lead to much higher costs per kWh and is not practical for large-scale applications. Therefore the correct option is D

Know more about fossil fuels here:

https://brainly.com/question/79954

#SPJ11

Q4. The FTSE100 on March 15, 2020 trades at 5790 points. The 9-month UK T-bill rate is 0.40% and the dividend yield of the FTSE100 is estimated at 3.5%. The rates are expressed in discrete compounding. Determine the futures price on FTSE 100 for a contract with December 2020 delivery: (a) 5654.85 (b) 5924.10 (C) 5958.54 (d) None of the above

Answers

The futures price on FTSE 100 for a contract with December 2020 delivery is 5654.85. The answer is (a).

To determine the futures price on FTSE 100 for a contract with December 2020 delivery, we need to use the following formula:

[tex]F = S * e^{[(r - q)T][/tex]

where:

F = futures price

S = spot price (in this case, the FTSE100 on March 15, 2020, which is 5790)

r = risk-free interest rate (the 9-month UK T-bill rate, which is 0.40%)

q = dividend yield (estimated at 3.5% for the FTSE100)

T = time to delivery (which is 9/12, or 0.75)

Plugging in the numbers, we get:

[tex]F = 5790 * e^{[(0.004 - 0.035) * 0.75][/tex]

[tex]F = 5790 * e^{[-0.02325][/tex]

F = 5790 * 0.97706

F = 5654.85

So the answer is (a) 5654.85.

To know more about futures price, refer here:
https://brainly.com/question/30615476?#
#SPJ11

assume that the physical property of a business is valued at $50,000. the company's commercial property policy contains a coinsurance clause with a stated percentage of 80 percent. the company insures the property for $30,000 (75 percent of the specified minimum). the company incurs a fire loss of $20,000. how much of the loss will the insurance company pay for?

Answers

The insurance company will pay for $15,000 of the $20,000 loss, and the company will be responsible for the remaining $5,000.

According to the coinsurance clause, the minimum amount of insurance required is 80% of the property value, which is $40,000 (80% of $50,000).

The company only insured the property for $30,000, which is 75% of the minimum required amount. Therefore, the company is underinsured by $10,000 ($40,000 - $30,000).

To calculate the amount of the loss that the insurance company will pay for, we need to apply the coinsurance formula:

(Insurance carried / Insurance required) x Loss = Amount of loss covered

Substituting the given values:

($30,000 / $40,000) x $20,000 = $15,000

Click the below link, to learn more about Insurance :

https://brainly.com/question/27822778

#SPJ11

experience differentiation: isolates the consumer from the delivery of a service. is an extension of product differentiation in the service sector. uses only the consumer's senses of vision and sound. keeps consumers from becoming active participants in the service. attempts to make the service experience different for every single customer.

Answers

Experience differentiation is a strategy used by service providers to create unique experiences for their customers.

This strategy is an extension of product differentiation in the service sector and seeks to differentiate the service experience from the competition. It involves the use of only the consumer's senses of sight and sound to keep the customer from becoming an active participant in the service.

By doing this, the customer is isolated from the delivery of the service, allowing the company to create a unique and exclusive experience for each customer. Experience differentiation attempts to make the service experience different for every single customer and allow them to feel as if they are the only one receiving the service.

By creating a unique and exclusive experience for each customer, companies are able to increase customer satisfaction and loyalty, which can result in increased sales and profits.

Know more about product differentiation here

https://brainly.com/question/29792118#

#SPJ11

A company's capital structure is as follows: $10 million in preferred stock, $100 million in common stock, and $10 million in bonds. What is the weight (in the capital structure) of the company's preferred stock

Answers

The weight of the company's preferred stock in its capital structure is 8.33%. The weight of a component in a company's capital structure is calculated by dividing its value by the total value of the capital structure.

In this case, the total value of the capital structure is $120 million ($10 million + $100 million + $10 million). Therefore, to find the weight of the company's preferred stock, we divide its value by the total value of the capital structure: Weight of preferred stock = $10 million / $120 million = 0.0833 or 8.33%

Therefore, the weight of the company's preferred stock in its capital structure is 8.33%. This means that the preferred stock represents 8.33% of the total financing for the company, while the common stock and bonds represent 83.33% and 8.33%, respectively.

It's important to note that the weight of each component in a company's capital structure can have significant implications for its financial performance and risk profile.

To know more about capital structure, refer here:

https://brainly.com/question/17102340#

#SPJ11

summary of the article
Internet banking and ATMs applications; in the context of the
multi-currencies economy.
Nidal Rashid Sabri

Answers

The article discusses the importance of internet banking and ATM applications in a multi-currency economy. The author argues that these technologies provide convenience and cost-effectiveness for consumers and businesses dealing with different currencies. The article also highlights the challenges of implementing such systems, including security and regulatory concerns.

In summary, the article emphasizes the benefits and challenges of using internet banking and ATM applications in a multi-currency economy.

While these technologies can provide convenience and cost-effectiveness, they also require careful consideration of security and regulatory issues.

For more questions like Banking, click the link below:

https://brainly.com/question/14042269

#SPJ11

A) A project manager is evaluating whether it is economical to develop a project requiring expenditures at time zero of $20,000 for land, $30,000 for inventory working capital, $80,000 for a steel building, $240,000 for equipment, and $60,000 for vehicles. Starting in year one the manager estimates that production will generate annual end-of-year escalated revenue of $500,000 with escalated operating costs of $300,000. Operating costs and revenue will both escalate at a compound interest rate of 10% per year beginning in year two. Use straight-line depreciation over 39 years for the building cost starting in year one assuming 12 months of service when computing your allowable deduction in year one under the mid-month con- vention. Use 7-Year MACRS depreciation rates for the qualifying equipment cost starting in year one with the half-year convention and the 5-Year MACRS rates for the vehicle cost, again, starting in year one with the half-year convention. The effective combined federal and state income tax rate is 25%. No other income exists against which to utilize deductions so carry any losses forward. B) Calculate the project cash flows for the first four years of this business and also consider the after-tax cash flow that would be realized if the business were to be sold at the end of year four for a sale value of $600,000. Write off all remaining tax book values at the end of year four to deter- mine taxable gain (or loss) and treat the sale as ordinary income. For a minimum after-tax rate of return of 15%, calculate the overall project after-tax NPV, DCFROR, and PVR.

Answers

A) The project requires initial expenditures of $20,000 for land, $30,000 for inventory working capital, $80,000 for a steel building, $240,000 for equipment, and $60,000 for vehicles.

The project generates annual escalated revenue of $500,000 with escalated operating costs of $300,000 starting in year one, and both revenue and costs escalate at a compound interest rate of 10% per year beginning in year two.

Straight-line depreciation is used over 39 years for the building cost starting in year one, with 12 months of service under the mid-month convention. The effective combined federal and state income tax rate is 25%.

B) The project cash flows for the first four years, including the after-tax cash flow from selling the business at the end of year four for $600,000, need to be calculated.

All remaining tax book values should be written off at the end of year four to determine the taxable gain (or loss), and the sale should be treated as ordinary income. Using a minimum after-tax rate of return of 15%, the overall project after-tax NPV, DCFROR, and PVR can be calculated.

For more questions like Cash click the link below:

https://brainly.com/question/10714011

#SPJ11

an analyst can always meaningfully compare price changes for an import price index relative to a producer price index whenever both indices reside at the same level of the north american industrial classification system (naics). question 5 options: a) true b) false

Answers

The given statement "an analyst can always meaningfully compare price changes for an import price index relative to a producer price index whenever both indices reside at the same level of the north american industrial classification system (naics)" is True. An analyst cannot always meaningfully compare price changes for an import price index relative to a producer price index.

When both the import price index and producer price index are at the same level of the North American Industrial Classification System (NAICS), an analyst can meaningfully compare the price changes between them.

This is because they are based on the same classification system, which allows for a more accurate comparison of the price changes.

Even if both indices reside at the same level of the North American Industrial Classification System (NAICS). This is because these two indices measure different aspects of the economy, and their movements may be influenced by different factors.Option a)true is the right answer

For more such questions on index.

https://brainly.com/question/28940514

#SPJ11

A. A reduction in the price of donuts will cause ________ for donuts.
B. An increase in consumer income will cause ________ for donuts (a normal good)

Answers

A. A reduction in the price of donuts will cause an increase in the demand for donuts. This is because the price of donuts is a determining factor in the quantity of donuts that consumers are willing to purchase. When the price of donuts decreases, consumers are more likely to buy them as they become more affordable.

This results in an increase in the demand for donuts.

B. An increase in consumer income will also cause an increase in the demand for donuts as they are considered a normal good. A normal good is a product whose demand increases as consumer income increases.

When consumers have more disposable income, they are more likely to spend it on goods and services that they enjoy, such as donuts. This increase in demand can be further attributed to the fact that consumers may view donuts as a luxury item, and therefore are more likely to purchase them when they have extra money to spend.

In summary, both a reduction in the price of donuts and an increase in consumer income can lead to an increase in the demand for donuts. Understanding how these factors impact the demand for specific goods is crucial for businesses that want to maximize their profits and stay competitive in the market.

Net profit is computed in the?
A)Profit and loss account B) Balance sheet C) Trial balance D) Trading account

Answers

Net profit is computed in the Profit and Loss Account. The correct option is (A). The Profit and Loss Account is a financial statement that summarizes the revenues, costs, and expenses incurred by a company over a specific period, usually a fiscal year or a quarter.


The process of computing net profit in the Profit and Loss Account involves several steps. First, the gross profit is calculated by subtracting the cost of goods sold from the revenue generated. Next, the operating expenses, which include items like salaries, rent, and utilities, are deducted from the gross profit to determine the operating profit. Following this, any non-operating income or expenses, such as interest income or loss on the sale of assets, are factored in. Finally, taxes are deducted to arrive at the net profit or loss.


In contrast, B) Balance Sheet provides a snapshot of a company's financial position at a specific point in time, showing its assets, liabilities, and equity. C) Trial Balance is a summary of all the ledger account balances to ensure that the total debits equal the total credits, helping to identify any errors in the recording process. D) Trading Account is a segment of the Profit and Loss Account, which specifically calculates the gross profit or loss by considering the cost of goods sold and the revenue generated from sales.

To know more about net profit click here

brainly.com/question/30652816

#SPJ11

which tracking method is best for teams with a lot of people and projects with many tasks or milestones that are dependent on one another?

Answers

For teams with a lot of people and projects with many tasks or milestones that are dependent on one another, the best tracking method is a project management tool that supports a Gantt chart.

A Gantt chart is a bar chart that illustrates a project schedule. It shows the start and end dates of each task, as well as the dependencies between them. This visual representation allows project managers to see the progress of each task, identify any delays, and adjust the schedule accordingly. Gantt charts can also be used to track resources and costs, making them an effective tool for managing complex projects with multiple dependencies.

There are many project management tools that support Gantt charts, such as Asana, Trello, Microsoft Project, and Smartsheet. These tools allow team members to collaborate in real-time, assign tasks to specific individuals, and set deadlines for each task. They also provide alerts and notifications to ensure that everyone is on track and aware of any changes to the schedule.

Overall, using a project management tool with a Gantt chart is the best tracking method for teams with a lot of people and projects with many tasks or milestones that are dependent on one another. It provides a clear visual representation of the project schedule and allows team members to collaborate effectively, ensuring that the project is completed on time and within budget.

Click the below link, to learn more about A Gantt chart:

https://brainly.com/question/13605073

#SPJ11

Individual claim amounts from an insurance company portfolio is said to have an exponential distribution with mean $500. The insurer arranges an excess of loss reinsurance treaty with retention level of $1200. (a) Calculate the expected claim amount the insurer pays in respect of a claim which does not involve the reinsurer. (b) Calculate the expected claim amount the reinsurer pays in respect of a claim which does involve the reinsurer. (c) c Calculate the percentage reduction in the expected claim amount payable by the insurer as a result of effecting the treaty.

Answers

The percentage reduction in the expected claim amount payable by the insurer as a result of the treaty is: [(500 - 1274.20) / 500] x 100% = -154.84%

The expected claim amount that the insurer pays for a claim not involving the reinsurer is $267.52.

(a) Since the claim amounts follow an exponential distribution with mean $500, the probability density function is given by:

f(x) = (1/500)e²(-x/500) for x > 0

The expected claim amount that the insurer pays for a claim not involving the reinsurer is given by:

∫(from 0 to 1200) xf(x) dx = ∫(from 0 to 1200) x(1/500)e²(-x/500) dx

Using integration by parts, we get:

∫(from 0 to 1200) xf(x) dx = [-xe²(-x/500) - 500e²(-x/500)](from 0 to 1200)

= (1200e²(-1200/500) + 500e²(-1200/500)) - (0 - 500)

= $267.52

(b) The expected claim amount that the reinsurer pays for a claim involving the reinsurer is the amount exceeding the retention level of $1200. Therefore, the expected claim amount that the reinsurer pays is:

∫(from 1200 to ∞) x(1/500)e²(-x/500) dx

Using integration by parts, we get:

∫(from 1200 to ∞) x(1/500)e²(-x/500) dx = [-xe²(-x/500)](from 1200 to ∞)

= $74.20

Therefore, the expected claim amount that the reinsurer pays for a claim involving the reinsurer is $74.20.

(c) The percentage reduction in the expected claim amount payable by the insurer as a result of the treaty is:

[(Expected claim amount without treaty - Expected claim amount with treaty) / Expected claim amount without treaty] x 100%

Expected claim amount without treaty = $500 (given)

Expected claim amount with treaty = $1200 + $74.20 = $1274.20

Therefore, the percentage reduction in the expected claim amount payable by the insurer as a result of the treaty is:

[(500 - 1274.20) / 500] x 100% = -154.84%

Learn more about “percentage reduction “ visit here;

https://brainly.com/question/24161762

#SPJ4

the corporate officer identified who has custody of the company's funds and is generally responsible for planning and controlling the company's cash position is the:

Answers

The corporate officer who has custody of the company's funds and is responsible for planning and controlling the company's cash position is known as the Chief Financial Officer (CFO).

The CFO is a high-level executive who oversees the financial operations of the company, including financial planning, budgeting, accounting, and reporting. They also manage the company's investments, debt, and other financial resources to ensure the company has enough cash to operate and grow.

The CFO works closely with other senior executives, such as the CEO and COO, to make strategic financial decisions that impact the company's future. They must have a strong understanding of financial markets, accounting principles, and business operations to effectively manage the company's financial position. The CFO is also responsible for ensuring the company complies with all financial regulations and reporting requirements.

In summary, the CFO is the corporate officer who has custody of the company's funds and is responsible for planning and controlling the company's cash position. They play a critical role in ensuring the financial health and success of the company.

Learn more about Chief Financial Officer (CFO) here: https://brainly.com/question/19558811

#SPJ11

Other Questions
5. In a certain ecosystem, rattlesnakes are predatorsof prairie dogs. If the prairie dog populationstarted to increase, how would the ecosystem mostlikely regain stability?The rattlesnake population would start todecrease. B. The rattlesnake population would start toincrease. C. The prairie dog population would increaserapidly. D. The prairie dog population would begin toprey on the rattlesnakes. dr. myers convinced a patient that she could only be cured of her disease if she had sexual intercourse with him. dr. myers convinced the patient that he was injected with a special serum that gave his semen healing properties. while dr. myers was clearly lying about his healing powers, the patient consented to sexual intercourse. according to the famous case boro v. superior court, what crime is dr. myers guilty of? Which of the following describes a way in which enslaved Africans wouldresist the conditions of slavery?Choose 1 answer:converting to Judaismcontracting smallpoxworking at a faster pacebreaking tools which one is correct In a bag there are 3 red marbles, 2 yellow marbles, and 1 blue marble. What is the likelihood of a yellow marble being selected on the first draw?likelyunlikelyeven chancecertain dynamic instability in microtubules stems from the intrinsic capacity of tubulin molecules to hydrolyze what? choose one: gtp atp water peptide bonds tubulin dimers Calculate the concentrations of all species in a 0.510 M NaCH3COO (sodium acetate) solution. The ionization constant for acetic acid is a=1.8105.[Na+]=[OH]=[H3O+]=[CH3COO]=[CH3COOH]= TRUE OR FALSETreasury bomds do not have default risk. 019 (part 1 of 2) 10.0 pointsA Carnot engine has a power output of197 kW. The engine operates between tworeservoirs at 20C and 425C.How much thermal energy is absorbed eachhour?Answer in units of J.020 (part 2 of 2) 10.0 pointsHow much thermal energy is lost per hour?Answer in units of J. what is the term that describes a variety of communication disciplines used to provide clarity, consistency, and maximum communicative impact used to promote a product? multiple choice question. customer relationship management cash cow program marketing plan integrated marketing communications look at picture please answer correctly social studies Please show all work:1. Two standard deviations is the acceptable limit of error in the clinical lab. If you run the normal control 100 times, how many values would be out of control due to random error?2. A mean value of 100 and a standard deviation of 1.8 mg/dL were obtained from a set of measurements for a control. The 95% confidence interval in mg/dL would be:3. How many milliliters of a 3% solution can be made if 6 g of solute are available? which growth and developmental change in a preschooler would the nurse include during a parent education camp? a doctor can complete 3 examinations in 2 hours. how many examinations can the doctor complete in 4 hours? hint: use the proportion 3 exams : 2 hours :: x exams : 4 hours. 5 exams 5 exams 6 exams 6 exams 7 exams 7 exams 8 exams what are the benefits of using a programming language to work with your data? select all that apply. An insurance company collects 100 claims on a class of insurance business. Let x; to be the individual claim, where i = 1,2, ..., 100. We have 2191 xi = 907,000 and 199x} = 18,498,312,500 5100 The insurer applies a Lognormal(u,02) distribution to model the claims (per ,000). a) Show that = 1.8 and = 0.9 using the Method of Moments. (8) Assume that claims (per ,000) follows a Lognormal(1.8,0.92) distribution. The insurer expects to sell 100 policies (to identical risks in any one year) and will charge a premium of 956 per policy. The probability of a claim on any policy is 0.05. An Excess of Loss Treaty exists with a retention of 26,000 for a price of 100 per policy. b) Find the percentage reduction in expected net profit to the insurer on the portfolio under this XOL Treaty. (17) your friend is binging half of a crate of popsicles to the picnic. of you put what is left in the crate evenly into 6 ice buckets, what fraction of the crate will go into each of ice bucket a significant determinant of health-relevant behavior in teens is: whats the surface area of this figure ? The temperature of a 2.0-liter sample of helium gas at STP is increased to 27C, and the pressure is decreased to 80 kPa. What is the new volume of the helium sample? Round your answer to the nearest tenth of a liter? In the graph below, line k with equation y = -k makes a 45 angle with the x- and y- axes.Rx: (2, 5) 1. (-2, 5)2. (-2, -5)3. (2, -5)