Data source is the range of cells which contain the data you want displayed in the chart. Thus, the correct answer is option A.
What is range of cells?In an Excel file, a cell range is a collection of selected cells. This range is usually symmetrical (square), but it can also consist of separate cells. A cell range can also be referenced in a formula.
Click Change Data Source on the Options tab, then Change Data Source in the Data group. The dialogue box Change Pivot Table Data source appears. Perform one of the following: Select a table or range, then enter the first cell in the Table/Range text box, to use a different Excel table or cell range.
Therefore, data source is the range of cells which contain the data you want displayed in the chart.
To learn more about cell range, click here:
https://brainly.com/question/30133869
#SPJ2
Penny Arcades, Inc., is trying to decide between the following two alternatives to finance its new $28 million gaming center: a. Issue $28 million of 6% bonds at face amount. b. Issue 1 million shares of common stock for $28 per share. 2. Which alternative results in the highest earnings per share
Answer:
Penny Arcades, |nc.
a. Issue $28 million of 6% bonds at face amount.
Explanation:
Alternative A will surely result in higher earnings per share than Alternative B. It has been established that some financial leverage enables the stockholders to earn more per share. This is not a debatable issue. The hard work lies with the corporation's ability to find the debtholders that can finance its activities and assets. This means that the stockholders of Penny Arcades, Inc. will be at a much more financial advantage if they can find creditors to lend it the $28 million for the gaming center than making the finance available themselves.
Blues Inc. manufactures jeans in the cutting and sewing process. Jeans are manufactured in 40-jean batch sizes. The cutting time is 5 minutes per jean. The sewing time is 20 minutes per jean. It takes 2 minutes to move a batch of jeans from cutting to sewing.
a. Compute the value-added, non-value-added, and total lead time of this process. Value-added lead time minutes Non-value-added lead time minutes Total lead time minutes
b. Compute the value-added ratio. Round to one decimal place. %
Answer:
1. Value added time = Cutting + Sewing time
Value added time = 5 min + 20 min
Value added time = 25 minutes
Non-value added time = Total within batch wait time + Move time
Non-value added time = (25 minutes*(40-1)) + 2 minutes
Non-value added time = 977 minutes
Total lead time = Value added time + Non-value added time
Total lead time = 25 minutes + 977 minutes
Total lead time = 1,002 minutes
2. Value added ratio = Value added time / Total lead time
Value added ratio = 25 minutes / 1,002 minutes
Value added ratio = 0.02495
Value added ratio = 2.5%
Analyze the overall financial situation from a cross-sectional viewpoint. Compare each company’s ratios with the industry average. What are the strengths and weaknesses of each company? Which company is best to invest in and why?
Answer:
Cross-sectional analysis is a type of analysis where an investor, analyst or portfolio manager compares a particular company to its industry peers. Cross-sectional analysis may focus on a single company for head-to-head analysis with its biggest competitors or it may approach it from an industry-wide lens to identify companies with a particular strength. Cross-sectional analysis is often deployed in an attempt to assess performance and investment opportunities using data points that are beyond the usual balance sheet numbers.
The company has budgeted to produce 28,000 units of Product T in June. The finished goods inventories on June 1 and June 30 were budgeted at 800 and 600 units, respectively. Budgeted direct labor costs for June would be:
Answer:
Results are below.
Explanation:
We weren't provided with the number of hours per unit or the hourly rate. But, let's suppose that each unit requires 0.1 hours and the hourly rate is $10.
Production= 28,000 units
Direct labor hours required= 28,000*0.1= 2,800 hours
Total direct labor cost= 2,800*10= $28,000
market:blue Jean market . event :the dye in blue jeans is proven not fade easily .Name the market
DontBuyFromUs
For a particular maximization problem, the payoff for the best decision alternative is $15.7 million while the payoff for one of the other alternatives is $12.9 million. The regret associated with the alternate decision would be
Answer: $2.8million
Explanation:
The regret associated with the alternate decision would be calculated as the difference between the payoff for the best decision alternative which is $15.7 million and the payoff for one of the other alternatives which is $12.9 million. This will be:
= $15.7million - $12.9million
= $2.8million
The regret associated with the alternate decision is $2.8million.
Capital budgeting is the process of making capital expenditure decisions. used in sell or process further decisions. of determining how much capital stock to issue. of eliminating unprofitable product lines.
Answer:
The correct answer is the first option: of making capital expenditure decisions.
Explanation:
To begin with, the term known as "Capital Budgeting", in the field of business management, refers to the method a company's manager use in order to see how profitable it is to start some new inversions or projects, therefore that the main purpose of this process is to involve the elaboration of a budget that will help the superiors of the organization to make capital expenditure decisions when they are looking for a new inversion or project to start with. It is very helpful in the situations where there is a need for evaluation of future prospects.
Ember Company purchased a building with a market value of $280,000 and land with a market value of $55,000 on January 1, 2018. Ember Company paid $15,000 cash and signed a 25-year, 12% mortgage payable for the balance.
Requirements
1. JournalizetheJanuary1,2018,purchase.
2. Journalize the first monthly payment of $3,370 on January 31, 2018.
(Round to the nearest dollar.)
Answer:
A. Jan,1
Dr Building $280,000
Dr Land $55,000
Cr Mortgages payable $320,000
Cr Cash $15,000
B. Dr Mortgages payable $170
Dr Interest expense $3,200
Cr Cash $3,370
Explanation:
A. Preparation of the journal entry for January 1,2018 purchase
Jan,1
Dr Building $280,000
Dr Land $55,000
Cr Mortgages payable $320,000
($280,000+$55,000-$15,000)
Cr Cash $15,000
(To record Purchased building and land with a mortgage payable)
B. Preparation of the journal entry for the first monthly payment of $3,370 on January 31, 2018
Dr Mortgages payable $170
($3,370-$3,200)
Dr Interest expense $3,200
($320,000*12%*1month/12)
Cr Cash $3,370
(To pay the interest and annual installment)
A business is considering a cash outlay of $250,000 for the purchase of land, which it could lease for $36,000 per year. If alternative investments are available which yield an 18% return, the opportunity cost of the purchase of the land is:
Answer: $45000
Explanation:
The opportunity cost refers to the cost of what an economic entity forgoes when an alternative choice is taken. Based on the information given in the question, the opportunity cost will be the loss on Interest on investment and this will be:
= 18% × $250,000
= 0.18 × $250,000
= $45000
The opportunity cost of the purchase of the land is $45000
What's your real rate of return if your savings account pays 2.5% interest and
inflation is at 1%?
OA. 1.5%
OB. 2.5%.
O c. 3.5%
OD. Can't calculate.
Perform a horizontal analysis providing both the amount and percentage change. (Round Percentage answers to 1 decimal place. Decreases should be indicated by a minus sign.)
Year
2021 2020
Cash $322,960 $880,000
Accounts receivable 702,240 280,000
Inventory 897,780 780,000
Long-term assets 3,536,680 2,380,000
Total assets $5,459,660 $4,320,000
Answer:
Find attached
Explanation:
Horizontal or trend analysis involves is a financial statement analysis technique that shows the percentage change or dollar change in a corresponding financial statement's item.
For example, the change in the fixed assets by a way of increase or decrease compared to last year's financial statements.
Formula:
change in a particular line item=(current year amount/previous year)-1
Several critics of the drug companies have claimed that the companies' practice of testing drugs on poor people in developing countries violates principles of justice. Why would they say this
Answer:
Because people in developing countries are less educated and don't understand the implications of being used for drug trials
Explanation:
Drug trials are carried out to test new drugs that companies want to introduce to the market.
The drugs are usually first tested on animals and in the final testing phase human trials are used to gauge how the drug will affect people.
In 1980 the FDA gave approval for testing in other countries. A lot of companies now started using developing countries for their drug trials.
This practice violates the principles of justice because the people in developing countries are mostly illiterates that don't the potential risks drug trials have.
The subjects of the trials are usually given some cash to participate in the trials. They consider it easy money.
Explain how negative externalities and, more specifically, pollution often result from a lack of clear property rights.
Answer:
An externality exists if a financial transaction affects the benefit to third parties. Externalities can be both positive and negative, depending if these affect the benefit to third parties on a positive or negative way.
An example of a negative external effect is air pollution; a factory owner may lack the incentive to limit air pollutant emissions because the damage mainly affects someone else, that is, it doesn't affect his property, but someone else's property or common property (such as the case of the environment).
Therefore, if there were more specific regulations regarding property and the effects of the misuse of this right, contamination could be avoided.
Oceania is a small open economy. Suppose that a large number of foreign countries begin to subsidize investment by instituting an investment tax credit (while adjusting other taxes to hold their tax revenue constant), but Oceania does not institute such an investment subsidy.
a. What happens to world investment demand as a function of the world interest rate?
b. What happens to the world interest rate?
c. What happens to investment in Oceania?
d. What happens to Oceania
he revenue cycle's primary objective is to Group of answer choices lower expenses. provide the right product in the right place at the right time for the right price. provide quality product in order to maximize market share. maximize the company's profit.
Answer: provide the right product in the right place at the right time for the right price.
Explanation:
Revenue cycle refers to the process involving the completion of an accounting process from the sale of a product till receipts are gotten for payment made.
The primary objective of the revenue cycle is to provide the right product in the right place at the right time for the right price.
The profits of the follower in a Stackelberg duopoly a. are less than those of the leader. b. equal those of the leader. c. are greater than those of the leader. d. all the statements associated with this question are correct.
Answer: a. are less than those of the leader.
Explanation:
The Stackelberg leadership model simoky refers to a strategic game whereby the leader firm will make the first moves before the follower firms will later move.
While the firms make their moves during the same time in Cournot duopoly, in Stackelberg duopoly, the leader moves first and hence the profit of the leader are greater than the profit of the follower.
Therefore, the correct option is A
10 points whoever comes.
Answer:
im here
Explanation:
what to do and thank you
Taggart informs Anderson that the satellite television system Anderson installed does not include the PAC-12 network that was promised under their contract and thus disputes the $1000 per the contract he (Taggart) is supposed to pay. Anderson agrees to accept $800 and Taggart is pleased. If Taggart does not pay the $800 Anderson may sue Taggart for $1000.
A. True
B. False
Answer:
False
Explanation:
The contract was renegotiated and the new consideration is now $800, not $1,000. Assuming that one party breaches the contract, the other party can sue for the value of the contract. In this case, if Taggart does not pay Anderson, Anderson may sue for $800. That number will probably increase due to associate costs and other damages, but the original breach was for $800.
Celestial Artistry Company is developing departmental overhead rates based on direct-labor hours for its two production Department. Etching and Finishing. The Etching, Department employs 20 people and the Finishing Department employs 80 people. Each person in these two departments works 2,000hours per year. The production-related overhead costs for the Etching Department are budgeted at $200.000, and the Finishing Department costs are budgeted at $320.000. Two service departments. Maintenance and Computing directly support the two production departments. These service department, have budgeted costs of $48,000 and $250,000 respectively. The production department’s overhead rates cannot be determined until the service department’s costs are allocated. The following schedule reflects the use of the Maintenance Departments and Computing Department’s output by the various departments.
Using Department
Service Department Maintenance Computing Etching Finishing
Maintenance(maintenance hours) 0 1,000 1,000 8,000
Computing (minutes) 240,000 0 840,000 120,000
Required:
1. Use the direct method to allocate service department costs. Calculate the overhead rates per direct labor hour for the Etching Department and the Finishing Department.
2. Use the step–down method to allocate service department costs. Allocate the Computing Department’s costs first. Calculate the overhead rates per direct-labor hour for the Etching Department and the Finishing Department.
Answer:
Celestial Artistry Company
1. Allocation of Service departments costs (direct method):
Service Dept Production Dept.
Maintenance Computing Etching Finishing Total
Overheads $48,000 $250,000 $200,000 $320,000 $818,000
Maintenance (48,000) 5,333 42,667 0
Computing (250,000) 218,750 31,250 0
Total costs $0 $0 $424,083 $393,917 $818,000
Direct labor hours 40,000 160,000
Overhead rate per direct labor hour $10.602 $2.462
2. Allocation of Service departments costs (step-down method):
Service Dept Production Dept.
Maintenance Computing Etching Finishing Total
Overheads $48,000 $250,000 $200,000 $320,000 $818,000
Computing 50,000 (250,000) 175,000 25,000 0
Maintenance (98,000) 0 10,889 87,111 0
Total costs $0 $0 $385,889 $432,111 $818,000
Direct labor hours 40,000 160,000
Overhead rate per direct labor hour $9.647 $2.701
Explanation:
a) Data and Calculations:
Etching Finishing Total
Employees 20 80 100
Direct labor hours per year 2,000 2,000
(per employee)
Total direct labor hours/year 40,000 160,000 200,000
Production-related overhead $200,000 $320,000 $520,000
Service Dept Production Dept.
Maintenance Computing Etching Finishing Total
Overheads $48,000 $250,000 $200,000 $320,000 $818,000
Maintenance
(maintenance hours) 0 1,000 1,000 8,000 10,000
Computing (minutes) 240,000 0 840,000 120,000 1,200,000
Direct Allocation of Service Departments Overheads:
Maintenance Overhead:
Etching = $5,333 ($48,000 * 1,000/9,000)
Finishing = $42,667 ($48,000 * 8,000/9,000)
Computing Overhead:
Etching = $218,750 ($250,000 * 840,000/960,000)
Finishing = $31,250 ($250,000 * 120,000/960,000)
Step-down Allocation of Service Departments Overheads
Computing Overhead:
Maintenance = $50,000 ($250,00 * 240,000/1,200,000)
Etching = $175,000 ($250,00 * 840,000/1,200,000)
Finishing = $25,000 ($250,00 * 120,000/1,200,000)
Maintenance Overhead of $98,000:
Etching = $10,889 ($98,000 * 1,000/9,000)
Finishing = $87,111 ($98,000 * 8,000/9,000)
Heuser Industries recently projected the following data (in thousands) for a coming year. The dividend payout is expected to be 40% of net income. What is the dollar amount of expected dividends (in thousands)
Answer:
$84.00
Explanation:
Note that the below projected income statement is missing from the question:
Sales $ 6,000.00
Operating costs $ 4,900.00
EBITDA $ 1,100.00
Depreciation $ 500.00
EBIT $ 600.00
Interest $ 250.00
EBT $ 350.00
Taxes (40%) $ 140.00
Net income $ 210.00
Also, it should be noted that dividends are paid out of the net income such that the balance of the net earnings after payment of dividends is added to the balance of the retained earnings
Dividends=dividend payout ratio*net income
projected net income=$210.00
dividend payout ratio=40%
Dividends=40%*$210.00
Dividends=$84.00
Marco started the shop by investing $40,400 cash and equipment valued at $18,400 in exchange for common stock.
Purchased $110 of office supplies on credit.
Paid $1,600 cash for the receptionist's salary.
Sold a custom frame service and collected $4,900 cash on the sale.
Completed framing services and billed the client $240.
What was the balance of the cash account after these transactions were posted?
a. $11,790
b. $12,030
c. $43,700
d. $43,830
e. $43.940.
Answer:
$43,700
Explanation:
The simplest way to determine the balance of the cash account is to prepare the cash account and see the side with a shortfall well as the amount. A cash account accounts for only cash related transactions.
Marco`s Cash Account
Debit :
Capital $40,400
Cash Sales $4,900
Total $45,300
Credit :
Receptionist's salary $1,600
Balance c/d (missing amount) $43,700
Total $45,300
thus,
the balance of the cash account after these transactions is $43,700.
NeverEver Corporation is choosing between a taxable bond at the yield of 7% and a municipal bond at the yield of 5.75%. Calculate the NeverEver Corporation's break-even tax rate. g
Answer:
18%
Explanation:
Calculation to determine the NeverEver Corporation's break-even tax rate.
Using this formula
Break-even tax rate=1- ( Municipal / Corporate )
Let plug in the formula
Break-even tax rate=1- (0.0575-0.07)=0.821429
Break-even tax rate=1-0.821429=0.178571
Break-even tax rate=0.178571 *100
Break-even tax rate= 17.8%
Break-even tax rate=18% Approximatel
Therefore the NeverEver Corporation's break-even tax rate is 18%
STEP 1: After reviewing the chapters in the module, propose how a U.S. company is applying an Integrated Marketing Communications strategy to deliver its message. Describe which channels the company is using, and how the channels are integrated. Your proposal must include at least one advertisement and one public relations example, with discussion of their objectives and message. Examples already discussed in the text are not acceptable.
Answer:
us
Explanation:
STEP 1: After reviewing the chapters in the module, propose how a U.S. company is applying an Integrated Marketing Communications strategy to deliver its message. Describe which channels the company is using, and how the channels are integrated. Your proposal must include at least one advertisement and one public relations example, with discussion of their objectives and message. Examples already discussed in the text are not acceptable.
Which one has the objective of "long-term financial success"?
A. Plotting
B. Spending
C. Saving
D. Investing
Answer:
C saving
MARK ME BRAINLIEST THANKS MY ANSWER PLEASE
Parth and Brittany have been your best friends since grade school. You have decided to quit your respective jobs and start up a bakery together since you all love cupcakes. Parth insists he wants to start the business as a partnership. Amber says that she wants to start the business as a corporation. You want to weigh in and give your opinion as to the best form of business. 1. What are the options for business form
Answer: Business as a partnership and business as a corporation
Explanation: they are both types of business or jobs that can be done by anyone. a partnership is when two people help each in one business, but if you are talking about corporation is more people than to friend that want to start a business
Which organization compiles data on individuals and businesses to report on their credit?
TransUnion
The Bureau of Consumer Protection
The National Credit Union Administration
Vantage Scores
Answer:
Option A
Explanation:
There are primarily three credit bureaus to which the Lenders go namely -
a) TransUnion
b) Equifax
c) Experian
These three agencies are interested in reviewing credit reports before lending any financial aid.
Hence, option A is correct
Answer:
TransUnion
Explanation:
The following data refer to Brompton Company’s ending inventory:
Item Code
Quantity
Unit Cost
Unit NRV
Small
100
$250
$246
Medium
400
150
145
Large
600
170
162
Extra-Large
250
265
270
What is the ending inventory balance if the lower of cost or net realizable value rule is applied to each item of inventory?
Answer:
Unit cost
Explanation:
They ending inventory
Identify whether each of the following examples belongs in M1 or M2. If an example belongs in both, be sure to check both boxes. Example M1 M2 Eileen has $7,000 in a two-year certificate of deposit (CD). Clancy has $25,000 in a money market account. Alex has $1,200 in a checking account.
Answer and Explanation:
The classification is as follows;
The first two examples comes in only M2 i.e. Eileen example and Clancy example as M1 denotes M1 + liquid assets
while on the other hand, the third example comes in M1 and M2 i..e Alex example as M1 denotes thenotes, coins & checking deposits and M2 described above
Hence, in this way it should be belong
Phishing:_______
a) A con executed using technology, typically targeted at acquiring sensitive information, or tricking someone into installing malicious software.
b) A term that, depending upon the context, may be applied to either, 1) someone who breaks into a computer system, or 2) a particularly clever solution.
c) When someone uncovers computer weaknesses, without exploiting them.
d) When a protester seeks to make a political point by leveraging technology tools, often via system integration, defacement, or damage.
Answer:
a)
Explanation:
Phishing is a type of deception in which an intruder disguises himself in email or other means of communication as a reputable individual or person. Attackers would normally use phishing e-mails to spread a range of malicious links or attachments. Some people will gather login credentials or victims' account details.
So as per above definition only option A seems the correct alternative among al the other option when discussing about Phishing.
A con executed using technology, typically targeted at acquiring sensitive information, or tricking someone into installing malicious software.
This year Randy paid $29,800 of interest on his residence. (Randy borrowed $474,000 to buy his residence, and it is currently worth $524,000.) Randy also paid $3,100 of interest on his car loan and $5,100 of margin interest to his stockbroker (investment interest expense). How much of this interest expense can Randy deduct as an itemized deduction under the following circumstances
Answer:
Randy can deduct $33,900 interest expense as an itemized deduction.
Explanation:
a) Data and Calculations:
Mortgage interest on residence = $29,800
Mortgage loan = $74,000
Current price of house = $524,000
Car loan interest = $3,100
Investment (margin) interest = $4,100
Deductible interest expenses:
Mortgage interest on residence = $29,800
Investment (margin) interest = 4,100
Total deductible interest = $33,900
b) The car loan interest that Randy incurred is not tax-deductible unless the car is used for his business. Otherwise, only the portion used for business is deductible. It is assumed that the car loan interest was incurred for private use and not business use. Therefore, it is not deductible.