You want to subtract your cost of 250 in cell D6, from your selling price of 400 in cell D5, and have the result in cell D7. How would you do this so you can extend the calculation across your other products
Answers
Answer:
Kindly check explanation
Explanation:
To obtain the result of the subtraction in cell D7:
While user has clicked on cell D7, press =, click on cell D5, -, click on cell D6 and press enter. The formula is in the form '=D5 - D6' ( referencing is omitted).
Once the formula has been entered into cell D7, the formula can be extended to across or beneath or both directions by clicking on cell D7, then around the lower right edge of the cell rectangle, a '+' sign shows up, right click and hold on the '+' sign then drag the mouse in your chosen direction. The calculation will be extended to all cells highlighted.
The process with which you will use to subtract your cost of 250 in cell D6, from your selling price of 400 in cell D5, and have the result in cell D7 is:
= D5 - D6
An Excel application is spreadsheet software that can perform different tasks of mathematical computation from basic arithmetic operation to visualizing or analyzing datasets.
Data and variables are arranged in rows and columns on the Excel Sheet. These rows and columns are called cell references e.g (''A1'', ''B2'', ''C10'' ) etc.From the given information, to subtract cell D6 from cell D5, we have the following process:
we will place 250 in cell D6 and 400 in cell D5Then, in cell D7, the first thing to do is to type the = sign followed by D5 minus D6.= D5 - D6Therefore, we can conclude that the process of subtracting cell D5 from D6 is: = D5 - D6. This calculation can be extended across your other cells by clicking on the result in cell D7 and dragging it across the other cells you want them to be.
Learn more about the Excel file here:
https://brainly.com/question/23567635?referrer=searchResults
Related Questions
For example, if the total cost of producing three units of output is $2,498 and the total cost of producing four units of output is $3,087, then the marginal cost of the fourth unit is
Answers
Answer:The marginal cost of fourth unit is $589
Explanation:The marginal cost of a good is defined as the cost of producing an additional one unit which increases the total cost of such good. Therefore we can say that;
Marginal cost=Total cost at 4 units - total cost at (4-1) units
=total cost of the 4 units - total cost of the three units
=3,087 -2,498
=$589
Also using the formulae;
Marginal cost = Change in cost / change in quantity
= 3,087 -2,498/4-3 =589/1= $589
The marginal cost of fourth unit is $589
Which of the following are the best ways to speak
with or write to a supervisor? Check all of the
boxes that apply
be more formal than you would be with other
coworkers
adjust your writing style to the audience and
avoid the use of technical terms or
abbreviations
be clear, focused, and brief
Answers
Answer:
The correct options are;
Be more formal than you would with most coworkers
Be clear, focused, and brief
Explanation:
When writing or speaking to supervisors, we make use of formal writing and speaking language that is concise, exact, void of repetition, concrete, and well structured and careful placement of adjectives being careful to make use of positive and more mindful analysis such as "evidence suggest" instead of "proof" or "less convincing" in place of "wrong" and avoid exaggerations.
Answer:
Be more formal than you would be with other co-workers and be clear, focused, and brief
Explanation:
The impact of increasing, as opposed to constant, costs is to Multiple Choice expand the limits of the terms of trade. intensify and prolong the comparative advantages that any nation may have initially. cause the bases for further specialization to disappear as nations specialize according to comparative advantage. cause nations to realize economies of scale in those products in which they specialize.
Answers
Answer:
cause the bases for further specialization to disappear as nations specialize according to comparative advantage
Explanation:
Comparative advantage refers to the advantage while producing the goods and services at a lower cost compared with the competition or rivals in order to gain the maximum share in the market place
Now if there is an increased as compared with the constant so the impact would affect the basis for additional specialization to invisible as the nations specialized as per the comparative advantage
Mr. Green purchased a property with the provision in the sale agreement that the seller would provide him with a warranty deed. At closing, the seller refused to provide better than a bargain and sale deed. If Mr. Green insists on buying the property and insists on the seller giving him a warranty deed he can attempt to force the seller to do so by filing a suit for:_________.
Answers
Answer:
specific performance
Explanation:
Specific performance in relation to confidential information is commonly used as a prohibition relief Specific performance is the equivalent compensation in contract law, under which a party issues orders requiring a party to perform a specific action, which is the execution of the contract. It is usually available for sale under the Land Act, but is generally not available if the damage is an appropriate option. If the seller fails to sell or the property is handed over to the seller, the buyer receives a specific performance under the provisions of the Specific Relief Act, 1963. A similar right is available under the seller. The contract requires specific performance from the buyer.Those who make dispositional attributions regarding poverty and unemployment tend to adopt political positions that:________
a. offer more direct support to the poor.
b. are unsympathetic to the poor.
c. tend to blame the poor for their problems.
d. are more neutral regarding poverty and unemployment.
Answers
Answer:
a. offer more direct support to the poor.
Explanation:
Which of these could be an option after high school for a person who wants to further his education but doesn't want to take out student loans?
Answers
Hi there,
I can not find the complete question to help choose an option. I wil list out a variety of answers and you would be able to choose any that suits your question.
Answer/Explanation:
As an high school leaver that wants to further his education but that doesn't want to take student loans to do it, there are a variety of option such high school leaver can choose from.
1. work and study: this simply means that the high school leaver can decide to work alongside college or university as use the money from the job to settle university bills.
2. Scholarships: Am high school leaver can try scholarship opportunities tourther his education. A scholarship can be said to be a philanthropic act by a body or individual to reward or help individuals with tuition and other things as stated in the terms and conditions.
3. Setup a funding site: an high school leaver can set up a funding site in which donations can be made to fund the higher education.
Cheers.
Describe the role of securities markets and of investment bankers: what role do investment bankers playing securities markets
Answers
Answer
Explanation:
investment bankers specialize in the provision of new securities and they
provide helps to those that want their security liquified.
However, investment bankers are known with their role of provision of money at capital market to their customers such as companies or government set up through issuing of money or equity for security market.
While solitary negative reactions or unjustified suggestions for change have the potential to dissipate discourse rather than build it, the pattern analysis shows that the anonymous condition seemed to provide a safe explorative space for learners to try out more reasons for their multiple solutions. teachers will rarely give anonymous feedback, but the experience of giving anonymous feedback may open a social space where learners can try out the reasons for their suggestions?
Answers
Question attached:
Answer:
Paraphrasing plagiarism
Explanation:
Here the student committed paraphrasing plagiarism because even though there was an in-text citation, he failed to give a bibliographic reference as he should. Now although the student paraphrased his source(ie changed or rearranged sentence structure and words and not quoted word-for-word) he would not have been said to have committed plagiarism if he had properly referenced(not only in-text) citation the work
Sue, a secretary goes to the storeroom to get a box of paper for her department. This is a task she's performed without problem hundreds of times. This time however, she slips and hurts her back lifting the box of paper. She requires treatment and cannot sit for long periods of time so she cannot do her job. A. Sue can sue her employer in court for her injuries.B. Sue is entitled to Workers' Compensation even though her employer was not negligent.C. Sue is entitled to Workers' Compensation only if she can show that her employer was negligent.D. Sue is not entitled to anything because she assumed the risk.
Answers
Answer:
B. Sue is entitled to Workers' Compensation even though her employer was not negligent.
Explanation:
Sue is performing her normal duties that is required by her being a secretary when she was injured. So the employer cannot be said to be negligent in allowing her carry paper for her unit.
She will not be able to sue for employer for her injuries.
However when an employee is injured they are entitled to Worker's compensation and paid time off work.
This is given to employees even when the employer is not negligent.
Sue can get the Worker's compensation for her back treatment.
Mike, a minor, buys some real estate as an investment. The contract obligates Mike to make monthly installment payments for 10 years. Mike reaches the age of majority one month after making the contract. After this, Mike makes 25 monthly payments under the contract, but then decides that he wants to rescind the deal. Which of the following is most true?A. Mike can dis-affirm.B. Mike cannot dis-affirm because contracts for the sale of land can only be dis-affirmed before the age of majority.C. Mike cannot dis-affirm because contracts for the sale of land must be dis-affirmed within one year of the age of majority.D. Mike cannot dis-affirm because he has already ratified the contract.
Answers
Answer: d. mike cannot disaffirm because he has already ratified the contract
Explanation:
When signing deals it's important to consider long term, this helps to make the best decision in any and most scenario. Most deals signed too cannot be reversed or change or adjusted because it'll affect the policy of the organization and won't be health for them. Mike has agreed to buy a property through a spread payment plan, changing the deal now after some years will not be possible as it distorts the plan intially agreed and goes against the policy of the organization selling the home.
Capital investment evaluation methods can be grouped into the following two general categories: a.methods that use average rate of return and methods that use differential analysis methods. b.methods that do not use present values and methods that use present values. c.methods that use absorption cost analysis and methods that use incremental analysis. d.methods that do not use variable costing and methods that use variable costing.
Answers
Answer:
Option b (methods that do not use present values and methods that use present values) is the correct choice.
Explanation:
Evaluation of capital expenditure seems to be a budgeting technique used by businesses and government organizations to determine the possible viability of such a long-term project.
The assessment of capital investment initiatives generally follows four techniques:
The back technique average rate. The system of repayment-period. The formula for net cash flows-value. The internal process of transfer.The other options have no relation to a particular circumstance. So the above alternative seems to be the appropriate one.
Manny wants to be involved in a business but is not sure which type of business to join or create. He has capital to invest. He has a good network of potential investors and partners. He has no experience in management.
Answers
Answer: Limited Partner in a Limited Partnership
Explanation:
The best role that Manny can play in business would be to become a limited partner in a limited partnership. Here he could avoid being a General Partner and so will not have to make management decisions which he has no experience in but can just invest and earn returns.
He will also get seat to be able to watch other people manage and learn from them should he choose to and his good network of potential investors and partners can bring even more business for the limited partnership he may decide to join.
At a listing appointment, the seller of a large, expensive home on the water gives specific instruction to the sales associate not to show the home to anyone from a certain protected class. The sales associate tells the seller this is a clear act of discrimination, but the property owner insists. The sales associate should
Answers
Answer:
refuse the listing
Explanation:
In the scenario being described, the sales associate should refuse the listing. This is because such discrimination due to race, color, religion, sex, disability, familial status, or national origin is a violation of the Fair Housing Act. If the realtor is accused of discrimination she can face civil penalties of $16,000 USD if it is the first offense or even up to $65,000 if it has been a repeated violation of the Fair Housing Act.
The weighted average cost of capital for a company: Group of answer choices should be used as the required return when analyzing a potential acquisition in an unrelated business. is unaffected by changes in corporate tax rates. is equivalent to the after-tax cost of the firm's liabilities. is the return investors require on the total assets of the firm. remains constant when the debt-equity ratio changes.
Answers
Answer:
is the return investors require on the total assets of the firm
Explanation:
The weighted average cost of capital (WACC) is the rate of return in which the company predicted to pay for holding the security in order to finance the assets
The formula to compute the WACC is shown below:
= Weightage of debt × cost of debt × ( 1- tax rate) + (Weightage of preferred stock) × (cost of preferred stock) + (Weightage of common stock) × (cost of common stock)
Hence, fourth option is correct
Each fiscal year, Dwayne is allocated an operating budget and then evaluated based on the amount of goods produced by his organization. Dwayne's performance is evaluated on a(n) _______ budget approach.
Answers
Answer: profit
Explanation: Dwayne's performance is being evaluated on a profit budget aoproach as it entails an evaluation or calculation involving the allocated operating budget will contain the revenue accrued from sales and the expenditure, which is the amount of money apportioned to a particular section of a business targeted at catering for the cost involved in production. The net difference between the expenditure and the revenue accused will show the profit generated. This is the profit budget approach.
In light of the facts that many organizations do not pay incentives and many employees discount or take for granted the value of benefits, base wages and salaries are often ____________________________ of the compensation system in the eyes of employees.
Answers
Answer:
In light of the facts that many organizations do not pay incentives and many employees discount or take for granted the value of benefits, base wages and salaries are often the focus of the compensation system in the eyes of employees.
Explanation:
The scenario talks about the base wages and salaries which is significant portion of their salary. If the company doesn't pay incentives then the employee thinks that it doesn't matter how motivated he works because he will be paid base salary or wage. Hence the motivation factor gets affected by the compensation factor and employee thinks the only focus of compensation is their base wage or salary.
John takes $100 of currency from his wallet and deposits it into his checking account. If the bank adds the entire $100 to reserves, the money supply _____, but if the bank lends out some of the $100, the money supply _____.
Answers
Answer:
John takes $100 of currency from his wallet and deposits it into his checking account. If the bank adds the entire $100 to reserves, the money supply WILL NOT CHANGE, but if the bank lends out some of the $100, the money supply WILL INCREASE.
Explanation:
Any monetary injection to the banking system will increase the money supply only if the banking system (the whole set of banks) lends the money. The total effect is calculated by the increase in money x the money multiplier. The money multiplier = 1 / required reserves.
If the bank does not lend the money, then the money supply will not change.
Seneca owns an interior painting service. Seneca promises Fran, a homeowner, that Seneca will paint the outside of Fran’s house. Seneca knows that all of the painter-employees are busy for the next two months and really does not intend to paint Fran’s house. In this case, Seneca’s tortious behavior is known as:
Answers
Answer:
Promissory fraud.
Explanation:
In this scenario, Seneca owns an interior painting service. Seneca promises Fran, a homeowner, that Seneca will paint the outside of Fran’s house. Seneca knows that all of the painter-employees are busy for the next two months and really does not intend to paint Fran’s house. In this case, Seneca’s tortious behavior is known as promissory fraud.
Promissory fraud can be defined as a promise made by an individual or business entity (promisor), when in actual fact they have absolutely no intention to perform the actions or fulfil the promise when it was made the other party.
Hence, Seneca exhibited a promissory fraud because he is aware that all of the painter-employees are busy for the next two months and really does not intend to paint Fran’s house.
Flash City Inc. manufactures small flash drives and is considering raising the price by 75 cents a unit for the coming year. With a 75−cent price increase, demand is expected to fall by 7,000 units. Current Projected Demand 78,000 units 71,000 units Selling price $8.50 $9.25 Incremental cost per unit $5.80 $5.80 Would you recommend the 75−cent price increase?
Answers
Answer:
Flash City Inc is a company manufacturing small flash drives
Current Situation:
Demand = 78,000 Units
Selling price per unit = $8.50
Cost per unit = $5.80
Operating Profit = 78,000 * ($8.50 – $5.80)
Operating Profit = 78,000 * $2.70
Operating Profit = $210,600
Projected Situation:
Demand = 71,000 Units
Selling price per unit = $9.25
Cost per unit = $5.80
Expected Operating Profit = 71,000 * (9.25 – 5.80)
Expected Operating Profit = 71,000 * 3.45
Expected Operating Profit = $244,950
Recommendation: If the selling price price per unit is increase by 0.75 cent, the Operating Profit to realize on manufacturing of the small flash drive will increase by $34,350 ($244,950 - $210,600) although such increment may have an effect of decrease in demand of the Flash drive in market due to increase in price.
Answer:
The $0.75 price increase will result in higher profits.
Explanation:
Current Demand Projected Demand
Units sold 78,000 units 71,000 units
Selling price $8.50 $9.25
Cost per unit $5.80 $5.80
Contribution margin $2.70 $3.45
Gross profit $210,600 $244,950
The price increase will result in gross profit increasing by $34,350. The decrease in the quantity demanded is offset by a larger increase in the contribution margin per unit.
Public education and food stamps are two types of public policy goods that are considered to be an _________ transfer payment in which taxes are redistributed from one income group within the economy to provide a specific good or service to a second group.
Answers
Answer:
In-kind.
Explanation:
Public education and food stamps are two types of public policy goods that are considered to be an in-kind transfer payment in which taxes are redistributed from one income group within the economy to provide a specific good or service to a second group.
An in-kind donation can be defined as a type of contribution in which finished goods and services are given directly to the beneficiaries rather than giving the money (cash) to buy these goods and services.
Hence, it is a non-cash contribution or donation.
Also, an in-kind transfer payment can be defined as the process or act of providing goods and services (redistribution of income and wealth) to various household by non-governmental organizations or governmental agencies. An in-kind transfer payment includes reimbursement, social security benefits, public education, food stamps etc.
7. Problems and Applications Q2 Indicate what happens to the unemployment rate and the labor-force participation rate in each of the following scenarios. Scenario Effect On... Unemployment Rate Labor-Force Participation Rate After a long search, Jon finds a job. Tyrion, a full-time college student, graduates and is immediately employed. After an unsuccessful job search, Arya gives up looking and retires. Daenerys quits her job to become a stay-at-home mom. Sansa has a birthday, becomes an adult, but has no interest in working. Jaime has a birthday, becomes an adult, and starts looking for a job. Cersei dies while enjoying retirement. Jorah dies working long hours at the office.
Answers
Answer:
The Unemployment rate refers to people in the economy who are actively looking for work but are jobless.
The Labor-force participation rate refers to the percentage of the working age population who are active in the workforce. This includes both employed and unemployed people as unemployed people are actively seeking jobs.
1. After a long search, Jon finds a job.
Unemployment rate - Decrease
Labor-force Participation rate - Same
2. Tyrion, a full-time college student, graduates and is immediately employed.
Unemployment rate - Decrease
Labor-force Participation rate - Increase
3. After an unsuccessful job search, Arya gives up looking and retires.
Unemployment rate - Decrease
Labor-force Participation rate - Decrease
4. Daenerys quits her job to become a stay-at-home mom.
Unemployment rate - Increase
Labor-force Participation rate - Decrease
5. Sansa has a birthday, becomes an adult, but has no interest in working.
Unemployment rate - Same
Labor-force Participation rate - Decreases
6. Jaime has a birthday, becomes an adult, and starts looking for a job.
Unemployment rate - Increase
Labor-force Participation rate - Increase
7. Cersei dies while enjoying retirement.
Unemployment rate - Same
Labor-force Participation rate - Increase
8. Jorah dies working long hours at the office.
Unemployment rate - Increases
Labor-force Participation rate - Decrease
The span of control for a manager: a. should never exceed 7 subordinates. b. varies somewhat from manager to manager, but most managers operate best with a span of control of about 9 employees. c. depends on a number of factors, and can vary from one manager, location and type of employees. d. is no longer a relevant issue in this day of computerized offices .
Answers
Answer:
c. depends on a number of factors, and can vary from one manager, location and type of employees.
Explanation:
A manager can be defined as an individual who is saddled with the responsibility of supervising and ensuring his subordinates (employees) are working effectively and efficiently with the organization's goals and objectives.
In Business management or human resource management, span of control can be defined as the number of subordinates or junior level staffs who are directly controlled by a superior (manager).
Basically, the span of control for a manager depends on a number of factors, and can vary from one manager, location and type of employees.
This ultimately implies that, span of control is directly proportional to the organizational structure and any other factor around them.
What is an application letter?
A: An application letter is used to apply for a specific job and includes keywords from the job posting.
B: An application letter describes in detail your schooling, work experience, and any other experience.
C: An application letter summarizes your intern experience for potential employers.
D: An application letter is used to inquire about open positions or positions that may open in the near future
Answers
Answer:
A: An application letter is used to apply for a specific job and includes keywords from the job posting.
Explanation:
The application letter is the letter in which the employee apply for the particular job to the employee for expressing the interest in the position posted by the employer.
Also it is known as cover letter
Therefore according to the given options the first option is appropriate for the application letter
Answer:
A: An application letter is used to apply for a specific job and includes keywords from the job posting. (apex)
Rising prices for raw materials, the increasing availability of recycling facilities, and a move toward increased environmental sustainability have all diminished the importance of reverse channels.
a. True
b. False
Answers
Answer:
the answer would have to be a
i’m guessing the answer is A :)
Is a Truck driving on the highway is one of the sixteen careers taught in Texas. Yes or No
Answers
Racquel deposited $40,000 in an account paying 4.8% annual interest in 2009. She now wants to make four equal annual withdrawals from the account starting with the first withdrawal in 2021. Racquel also wants to have exactly $60,000 left in the account in 2026. How large can each of the annual withdrawals be?
Answers
Answer:
the annual withdrawals must be $2,006.49.
Explanation:
First determine how much the $40,000 would be at the end of 2020 that is 7 years following the investment as follows :
PV = - $40,000
r = 4.8%
Pmt = $0
P/yr = 1
n = 7
Fv = ?
Using a Financial Calculator, the $40,000 will be $55,537.84 in 7 years time.
The next step is to determine the annual withdrawals that will result in $60,000 left in 6 years.
PV = - $55,537.84
r = 4.8%
P/yr = 1
n = 6
Fv = $60,000
Pmt = ?
Using a financial calculator, the annual withdrawals must be $2,006.49 for Racquel to achieve her goals.
Which of the following companies should have the highest beta? Multiple Choice Orange Company that has low operating and financial leverage. Yellow Company that has highly cyclical revenues and uses high levels of fixed costs. Blue Company that has low cyclical business activity and high operating leverage. Black Company that has highly cyclical business activity and low operating leverage. Red Company that has low cyclical business activity and low fixed costs.
Answers
Answer: Yellow Company that has highly cyclical revenues and uses high levels of fixed costs
Explanation:
Beta is used to measure how risky a firm is. A high beta means the risk that is involved is high while a low beta means that the risk that is involved is low.
From the options given, the from with the highest beta will be Yellow Company that has highly cyclical revenues and uses high levels of fixed costs. It has cyclical revenues that are high and also a high fixed cost.
Swifty Corporation purchased a machine for $66000 on July 1, 2020. The company intends to depreciate it over 8 years using the double-declining balance method. Salvage value is $5100. Depreciation for 2020 to the closest dollar is
Answers
Answer:
Depreciation expense= $7,612.5
Explanation:
Giving the following information:
Purchase price= $66,000
Salvage value= $5,100
Useful life= 8 years
First, we need to determine the depreciation expense for the whole year. We will use the following formula:
Annual depreciation= 2*[(book value)/estimated life (years)]
Annual depreciation= 2*[(66,000 - 5,100) / 8]
Annual depreciation= $15,225
For 2020:
Depreciation expense= (15,225/12)*6= $7,612.5
A perfectly competitive small organic farm that produces 1,000 cauliflower heads in the short run has an ATC = $6 and AFC = $2. The market price is $3 per head and is equal to MC. In order to maximize profits (or minimize losses), this farm should:
Answers
Answer:
the firm should shut down, at least temporarily until the marginal revenue increases or definitely if the marginal revenue doesn't increase
Explanation:
if average total costs = $6 and average fixed costs = $2, then average variable costs = $6 - $2 = $4
since the average variable costs are higher than marginal revenue: $4 > $3, then the company is losing money (-$1) every time it sells its products.
Mika has borrowed $5,000 from her cousin Jun and not repaid it. Now, Mika is selling her house to Jun’s nephew, Cheong. As Mika writes up the contract, Jun tells her that if she doesn’t sell the house at a steeply discounted price, Jun will take the matter of the $5,000 to court. What is true about this situation?
Answers
Answer:
Jun's pressure and influence has invalidated Mika's consent.
Explanation:
By threatening Mika with prosecution if she doesn't set a discount for the sale of her house on the grounds of her debt to her, she has influenced Jun's consent or rather coerced it and therefore Mika's consent is invalidated in the agreement. Consent is free under law if contract and should be given under undue influence, duress or any other vitiating factor that will render the contract null and void such as the example above
