Suppose you are building a scatter plot in Excel for a large amount of data. After selecting the scatter plot option, how do you enter the data into your scatter plot?


a. By manually typing each data point into the scatter plot

b. By using the Quick Styles button under the Chart menu

c. By using the Select Data button and the Select Data Source option

Answers

Answer 1

Answer:

c. By using the Select Data button and the Select Data Source option

Explanation:

A scatter plot is a plot which is used to plot the points of the data on the horizontal and the vertical axis also it depicts how one variable is affected by the another.

After preparing the scatter plot to enter the data in the scatter plot we need to use the data button and then data source option so that the data could be entered in the scatter plot

hence, option c is correct


Related Questions

Entries for Investments in Bonds, Interest, and Sale of Bonds Kalyagin Investments acquired $220,000 of Jerris Corp., 7% bonds at their face amount on October 1, 20Y2. The bonds pay interest on October 1 and April 1. On April 1, 20Y3, Kalyagin sold $80,000 of Jerris bonds at 103.

Journalize the entries to record the following:

a. The initial acquisition of the Jerris Corp. bonds on October 1, 20Y2.
b. The adjusting entry for three months of accrued interest earned on the Jems Corp. bonds- or December 11, 20Y2.
c. The receipt of semiannual interest on April 1. 20Y3.
d. The sale of 580,000 of Jerris Corp. bonds on April, 20Y3, at 103.

Answers

Answer:

a. Investments in Jerris Corp. bonds (Dr.) $220,000

Cash (Cr.) $220,000

b. Interest Receivable (Dr.) $3,850

Interest received (Cr.) $3,850

c. Cash (Dr.) $7700

Interest Received (Cr.) $3,850

Interest Receivable (Cr.) $3,850

d. Cash (Dr.) $80,000

Investment in Jerris Corp. bonds (Cr.) $80,000

Explanation:

Interest received is the amount interest that is accrued on the bond over the period of time.

Interest accrued = Amount of investment * Coupon rate * time proportion

Interest accrued = 220,000 * 7% * 3/12

Interest accrued = $3,850.

A mother, aged 60, wishes to withdraw monies from her variable annuity to pay for her son's college education. Which statement is true regarding the taxation of the withdrawal?
A. The withdrawal is 100% taxable
B. Any amount withdrawn above the cost basis is taxable
C. Any amount withdrawn above the cost basis is taxable, and is subject to a 10% penalty tax
D. The withdrawal is not subject to tax

Answers

Answer:

Any amount withdrawn above the cost basis is taxable

Explanation:

This woman is above 59½ years at age 60. If she was least than 60, she would be owing a 10% penalty on the taxable amount of this withdrawal. But since she is above this age she has to pay income taxes on the whole taxable amount of the funds she withdrew. Variable annuities would never be taxed the money is withdrawn. Therefore option B is the best answer for This question.

If the actual quantity of direct materials used in producing a commodity differs from the standard quantity, the variance is a

Answers

Answer:

quantity variance

Explanation:

Quantity variance is a variance that compares standard quantity of materials that should have been used to the actual materials used. This type of variance is used by firms to know the difference between actual usage of materials and it's expected usage.

Where the actual usage is more than the expected usage, it is adverse ; while it is favorable if the expected usage is more than the actual usage.

Instead of a dividend of $1.60 per share, the company has announced a share repurchase of $16,000 worth of stock. How many shares will be outstanding after the repurchase?

Answers

Answer:

9,690 stocks

Explanation:

some information is missing:

Market Value Balance Sheet

Cash            $45,300        Equity $515,300

Fixed assets    $470,000    

Total           $515,300        Total         $515,300

total number of shares outstanding = 10,000

stock's market price = $515,300 / 10,000 = $51.53

stocks repurchased = $16,000 / $51.53 = 310.50, but we must round down to 310 stocks

stocks outstanding after repurchase = 10,000 - 310 = 9,690

Rahman stock just paid a dividend of $3.00 per share. Future dividends are expected to grow at a constant rate of 6% per year. What is the value of the stock if the required return is 12%

Answers

Answer:value of stock for the required return of 12 % =  $53

Explanation:

Given

current dividend just paid = $3.00

dividend to grow at constant rate of 6%

required rate of return =12%

to calculate the value of stock for the requitred return of 12 % , we use the dividend growth model which is  

Current price = dividend ( 1 + growth rate )/ (required rate -growth rate )

                        = 3 x (1+6%) / 12-6 = 3 x 1.06 /6% =3.18/0.06=  $53

Therefore  value of stock for the requitred return of 12 % ,=  $53

Determine which of the following situations describe games and which describe decisions. In each case, indicate what specific features of the situation caused you to classify it as you did. (a) A group of grocery shoppers in the dairy section, with each shopper choosing a flavor of yogurt to purchase (b) A pair of teenage girls choosing dresses for their prom (c) A college student considering what type of postgraduate education to pursue (d) The New York Times and the Wall Street Journal choosing the prices for their online subscriptions this year (e) A presidential candidate picking a running mate

Answers

Answer:

Situation which describes:

1. Game:

(a) A group of grocery shoppers in the dairy section, with each shopper choosing a flavor of yogurt to purchase

(Because of the attribute of each shopper choosing a flavor of yogurt.)

2. Decisions:

(b) A pair of teenage girls choosing dresses for their prom. (The prom which date and time has been fixed already)

(c) A college student considering what type of postgraduate education to pursue. (Because of decision to be educated)

(d) The New York Times and the Wall Street Journal choosing the prices for their online subscriptions this year. (Due to the various financial ability of its reader)

(e) A presidential candidate picking a running mate ( Due to the election that is upcoming)

Explanation:

To determine cash payments for operating expenses for the statement of cash flows using the direct method, a decrease in accrued expenses is added to operating expenses other than depreciation.

a. True
b. False

Answers

Answer:

True

Explanation:

To determine cash payments under direct method the decrease in accrued expenses is added to the operating expenses payable . Accrued expense mean expenses incurred but not yet paid. A decrease in accrued expenses would suggest that accrued expenses have been paid therefore there has been an outflow of cash which will be added to cash paid for operating expenses.

As a result of a decrease in the demand for U.S. dollars, there has been depreciation in the value of the U.S. dollar relative to Jamaican dollars. The depreciation in the U.S. dollar has benefitted some groups but harmed others. Indicate which of the groups are winners and which are losers from the standpoint of the depreciation of the U.S. dollar.
A. Todd, an American, going to visit Jamaica for spring break.
B. An investment bank in Jamaica that is interested in purchasing U.S. government bonds.
C. Goodyear, a U.S. based firm, selling car tires in Jamaica.
D. A family from Jamaica visiting relatives in the U.S. E. A firm from Jamaica selling handbags in the U.S.
F. U.S. based Hewlett-Packard, which is purchasing a high tech company in Jamaica.

Answers

Answer;

A. Todd, an American, going to visit Jamaica for spring break. - Loser

The US dollar depreciating means that it now takes more US dollars to buy Jamaican dollars. Todd will afford less Jamaican dollars when he goes to Jamaica.

B. An investment bank in Jamaica that is interested in purchasing U.S. government bonds. - Winner

The Investment bank will see that their domestic currency is stronger than it was therefore they can buy more US dollars. As a result it will be cheaper for the Investment bank to buy U.S. Government bonds.

C. Goodyear, a U.S. based firm, selling car tires in Jamaica. - Winners.

Goodyear will be winners because when they sell their tires in Jamaican dollars and then convert it to USD, they will.get more dollars from the transaction than before.

D. A family from Jamaica visiting relatives in the U.S. - Winners

As the Jamaican family will be able to buy more US dollars than before, they are winners.

E. A firm from Jamaica selling handbags in the U.S. - Losers.

As the firm sells in the US, they sell in US dollars. When they try to convert their sales to Jamaican dollars, they will get less than before.

F. U.S. based Hewlett-Packard, which is purchasing a high tech company in Jamaica. - Losers.

The depreciation of the US dollar means than HP will have to spend more dollars purchasing the company than before because the purchase price of the company will be stated in Jamaican dollars.

The accounts receivable turnover is computed as __________ divided by __________. sales; accounts receivable sales; average accounts receivable sales; net income accounts receivable; net income

Answers

Answer:

sales ; average accounts receivables

Explanation:

Accounts receivable turnover refers to how a business firm manage its assets. Businesses, companies uses accounts receivables to know and quantify how perfectly goods bought on credit by their customers are being paid back. It also measures how business gives credit and collects back it's debt .It is calculated as net sales divided by average accounts receivables.

A company’s common stock has a market value of $63.18 per share and its next dividend is expected to be $3.26 per share. The stock’s beta is 1.2, the tax rate is 35%, and the market risk premium is 6.1% per year. The yield to maturity for the company’s long-term debt is 6.4% per year. If the riskiness of the company’s equity requires that it provide a risk premium of 3.2% per year over the yield on its long-term debt, what is the company’s annual cost of internal equity financing?

Answers

Answer:

Cost of equity = 9.6%

Explanation:

The cost of equity is the return a firm theoretically pays to its equity investors, In order to calculate the cost of equity here we need to add up the yield to maturity for the company's long term debt and the risk premium per year over the yield on its long term debt.

Solution

Cost of equity = Yield to maturity + Risk premium

Cost of equity = 6.4% + 3.2%

Cost of equity = 9.6%

Jacob Corcoran bought 10,000 shares of Grebe Corporation stock two years ago for $24,000. Last year, Jacob received a nontaxable stock dividend of 2,000 shares in Grebe Corporation. In the current tax year, Jacob sold all of the stock received as a dividend for $18,000.


Required:

a. Complete the letter to Jacob describing the tax consequences of the stock sale.

b. Prepare a memo for the tax research file describing the tax consequences of the stock sale.

c.

Answers

Answer:

Jacob purchased 10000 shares form Grebe corporation two years ago for $24000

last year Jacob received a non taxable stock dividend of 2000 shares from Grebe corporation

In the current year tax year Jacob sold all stock received as dividend that's 2000 shares for $18000

The gain of the sale of 2000 shares can be calculated by subtracting the basis in the shares from the cost price. the cost of shares = ( $24000 / 12000 ) = $2 per share

profit made from the sales of 2000 shares is calculated as follows ; selling price ( $18000 ) - cost price of 2000 shares ( $2 * 2000) , the profit is $14000 and it is in the long term because the original shares bought has been held for at least 1 year

Explanation:

Jacob purchased 10000 shares form Grebe corporation two years ago for $24000

last year Jacob received a non taxable stock dividend of 2000 shares from Grebe corporation

In the current year tax year Jacob sold all stock received as dividend that's 2000 shares for $18000

The gain of the sale of 2000 shares can be calculated by subtracting the basis in the shares from the cost price. the cost of shares = ( $24000 / 12000 ) = $2 per share

profit made from the sales of 2000 shares is calculated as follows ; selling price ( $18000 ) - cost price of 2000 shares ( $2 * 2000) , the profit is $14000 and it is in the long term because the original shares bought has been held for at least 1 year

The failure to record a purchase of mer chandise on account even though the goods are properly included in the physical inven tory results in

Answers

Answer: D. an understatement of expenses and an overstatement of owners' equity

Explanation:

If a purchase of merchandise was not recorded, it would mean that Purchases being an expense that contributes to the Cost of Goods sold would be understated.

This understatement would mean that the the Net income is overstated because the purchase expenses were never deducted from it. Net Income is part of owners' equity so if it is overstated, so is owners' equity .

The required investment cost of a​ new, large shopping center is ​$49 million. The salvage value of the project is estimated to be ​$20 million​ (the value of the​ land). The​ project's life is 15 years and the annual operating expenses are estimated to be ​$14 million. The MARR for such projects is 15​% per year. What must the minimum annual revenue be to make the shopping center a worthwhile​ venture?

Answers

Answer:

The minimum annual revenue is 22.38 million.

Explanation:

Let the minimum annual revenue = X

Therefore,

The present value of cash inflows = Present value of cash outflows

X (P/A,15%,15) + 20 (P/F,15%,15)= 49*1 + 14(P/A,15%,15)

Now look into the annuity table or compound interest factor table and use that values to solve the equation.

X(5.847) + 20 (0.1229) = 49 + 14 (5.847)

X(5.847) = 130.858

X = 130.858 / 5.847

X = 22.38 millions

The minimum annual revenue = 22.38 million.

_____ is a method for determining the estimated annual costs and benefits for a project and the resulting annual cash flow.

Answers

Answer:

Cash flow analysis, is the right answer.

Explanation:

“Cash flow analysis” is the method that determined the actual cash that goes out of the business and the actual cash that comes in the business. Basically this method is used for financial purposes. This method exhibits the actual cost that the business has incurred and the actual benefit it has earned. Moreover, new investors that invest in the company primarily sees the financial report of the company and then take the decision to invest.

Carter Company reported the following financial numbers for one of its divisions for the year; average total assets of $4,100,000; sales of $4,525,000; cost of goods sold of $2,550,000; and operating expenses of $1,372,000. Compute the division's return on investment:

Answers

Answer:

14.7%

Explanation:

The computation of return on investment is shown below:

Return on Investment = Net Income ÷ Average total assets × 100

where,

Net Income is

= Sales - Cost of goods sold - Operating expense  

= $4,525,000 - $2,550,000 - $1,372,000

= $603,000

And,

Average total assets = $4,100,000

So,

Return on Investment is

= $603,000 ÷ $4,100,000 × 100

= 14.7%

Cobe Company has already manufactured 17,000 units of Product A at a cost of $20 per unit. The 17,000 units can be sold at this stage for $410,000. Alternatively, the units can be further processed at a $240,000 total additional cost and be converted into 5, 800 units of Product B and 11, 400 units of Product C. Per unit selling price for Product B is $107 and for Product C is $52.
Prepare an analysis that shows whether the 17,000 units of Product A should be processed further or not.
Sell as is ProcessFurther
Sales
Relevant costs:
Total relevant costs
Income (loss)
Incremental net income (or loss) if processed further
The company should

Answers

Answer:

differential analysis:

                         No further process      Process further         Differential

                                                                                                 amount

Sales revenue            $410,000                $1,213,400             $803,400

Production costs     ($340,000)               ($580,000)           ($240,000)

Operating income       $70,000                  $633,400            $563,400

The company should process further and sell products B and C because its operating income will increase by $563,400.

On January 1, Year 1, St. Clair Corporation issues 7%, 11-year bonds with a face amount of $90,000 for $83,497. The market interest rate is 8%. Interest is paid semiannually on June 30 and December 31. Complete the necessary journal entry for the issuance of the bonds by selecting the account names from the drop-down menus and entering the associated dollar amounts.

Answers

Answer:

Cash $83,497 (debit)

Investment in Bonds $83,497 (credit)

Explanation:

On Issuance of Bond, the Bond Issuer must recognize the Assets of Cash at the amount of consideration paid by the Bond Holder (Investor).

Also, the Financial Liability : Investment in Bonds must also be recognized by the Issuer at the same amount that the cash has been recognized at.

a company bought a piece of equipment for A200 and expects to use it for eight years. The company that plans to

Answers

Answer:

The correct option b. $2,567.

Explanation:

Note: This question is not complete. The complete question is therefore provided before answering the question as follows:

A company bought a piece of equipment for $49,200 and expects to use it for eight years. The company then plans to sell it for $4,000. The company has already recorded depreciation of $42,632.60. Using the double-declining-balance method, what is the company's annual depreciation expense for the upcoming year? (Round your answer to the nearest whole dollar amount.)

a. $11,300.

b. $2,567.

c. $19,200.

d. $1,642.

The explanation to the answer is now given as follows:

Note: See the attached excel file for the calculation of the annual depreciation expenses.

Double declining depreciation method is an accelerated depreciation technique due to the fact the depreciation expenses are charged faster under it than under straight-line depreciation method.

The depreciation of double declining method is calculated by by multiplying the rate of straight-line depreciation method by 2.

From the question, the already recorded depreciation of $42,632.60 is the accumulated depreciation expenses for the 7th year.

Since the upcoming year is the 8th year which is the last year, the depreciation expense for it can be calculated as by adjusting for the residual value of $4,000 follows:

Equipment cost = $49,200

Accumulated Depreciation = $42,632.60

Residual value = $4,000

Estimated useful life = 8 years

Therefore, we have:

Straight line method depreciation rate = 1 / Estimated useful life = 1 / 8 = 0.125, or 12.50%

Double declining depreciation rate = Straight line method depreciation rate * 2 = 12.50% * 2 = 25%

Beginning book value of the equipment in the upcoming year or in the 8th year = Equipment cost - Accumulated Depreciation = $49,200 - $42,632.60 = $6,567.40

Annual depreciation expense for the upcoming year or for the 8th year = Beginning book value of the equipment - Residual value = $6,567.40 - $4,000 = $2,567

Therefore, the correct option b. $2,567.

At the beginning of the school year, Priscilla Wescott decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget:
Cash balance, September 1 (from a summer job) $8,220
Purchase season football tickets in September 110
Additional entertainment for each month 290
Pay fall semester tuition in September 4,400
Pay rent at the beginning of each month 400
Pay for food each month 220
Pay apartment deposit on September 2 (to be returned December 15) 600
Part-time job earnings each month (net of taxes) 1,020
a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign.
b. Are the four monthly budgets that are presented prepared as static budgets or flexible budgets?
c. Priscilla can see that her present plan will not provide sufficient cash. If Priscilla did not budget but went ahead with the original plan, she would be $ short at the end of December, with no time left to adjust.

Answers

Answer:

a) Priscilla Wescott's

Cash budget

                                                                  Months

                                        Sept.            Oct.             Nov.           Dec.

beginning balance          8,220         3,220          3,330          3,340

football tickets                -110

other entertainment       -290            -290            -290            -290

semester tuition             -4,400

rent                                  -400            -400            -400            -400

food                                 -220            -220            -220            -220

apartment deposit          -600                                                     600

part time jobs earnings   1,020          1,020           1,020           1,020

ending balance                3,220         3,330           3,340          4,150

b) This is a static budget because it is being prepared in advance. A flexible budget adjusts a static budget to the real cash outflows and inflows.

c) The spring semester tuition costs $4,400 and she will only have $4,150, that means she will be $250 short.

In a production bottleneck situation, the product with the highest contribution margin per unit should be given priority over a product that has the highest contribution margin per bottleneck hour.

a. True
b. False

Answers

Answer:

b. false

Explanation:

A bottleneck is a point at which there is the stoppage in the system of production. The inefficiencies that are generated through the bottleneck developed the delays and leads to the high cost of production

Here in the given situation, since there is the highest contribution margin per unit that gives more priority as compared with the contribution margin per bottleneck hour i.e. totally wrong as it should give the priority to the contribution margin per bottleneck hour

Therefore the given statement is false

"A customer invests $50,000 in a non-qualified variable annuity. Over the years, it has grown in value to $110,000. The customer’s cost basis in the annuity contract is::"

Answers

Answer:

The customer's cost basis in the annuity contract is $50,000.

Explanation:

The customer's cost basis in the annuity contract is the initial payments or premiums made in an annuity amounting to $50,000.  This amount is usually taxed at the initial point.  This implies that the $110,000 which the annuity has accumulated to will no longer be taxed.  The customer will enjoy her lump sum and withdrawals undisturbed by the Internal Revenue Service.

In this module, you learned about the risks or costs associated with financial goals. What are the risks or costs associated with your goal, and how can you overcome these challenges

Answers

Answer with Explanation:

My goal is to start a business totally based on a new idea with great potential to influence the lives of the people of America. For this I had worked on a startup idea for couple of years and continuously reforming it.

The biggest risks associated with this goal is funding problems, business risks, market research, innovation issues and Software designing issues.

Now these are some risks that I face but I overcome these challenges by:

Risks                        Solution

Funding Risk:           By presenting my startup idea on a international                                                     competition by writing business proposal based on well researched market, product innovation and the financial prospect of the business. There are numerous accelerator programs operated by the state and other organizations that encourage startups and helps with numerous facilities. So I will also present my idea here to secure funding from a wider number of investors.

Business Risks:        Giving special considerations to business risks and their mitigation strategies.

Innovation:               The products will be innovative enough to generate handsome amount of profit and must be capable of giving tough time to its competitors.

Market Research:     The best performing businesses know who their customers are and what they are desiring from them. So market research would capable of identifying my potential customers and that it must be representative of the sample taken.

Software Designing: The software design must be user friendly and must effectively resolve users issues. Furthermore, it must be continuously updated with better features and friendly functioning.

It is March 31, 2014. What is the latest reported number of E-Bay shares beneficially owned by the company’s CEO? Please provide your answer without comma separator or decimal (Ex: 23456326563)

Answers

Answer: 2663844

Explanation:

According to page 22 of eBay's March 2014 Definitive Proxy statement on the SEC's website, the President and CEO Mr John J. Donahoe, beneficially owned 2,663,844 shares in the company. This includes,  2,083,628 shares that he can acquire pursuant to some Options and 35,306 in Restricted stock units.

You are feeling overwhelmed by the number of potential goals you could set for your business unit. You ask your colleague Dan for advice on the process he uses to set goals. Which of the following suggestions from Dan is wrong? He suggests that you

Answers

Answer:

prioritize goals according to their value to the organization

Explanation:

Goal setting is an action plan that is set to motivate someone towards achieving a goal. Individuals, organizations set goals as part of their personal development plans hence must be Specific, Measurable, Action oriented, Realistic and Timely(SMART).

With regards to the above scenario, prioritizing goals according to their value to the organization is wrong. While it is important to prioritize goals, such must however be made to align with the business's strategic objectives.

It is also important to stick to goals already set instead of constantly changing them. Sometimes too, customers put pressure on business owners to consider certain goals which might be beneficial; such should also be looked into after considering their pros and cons.

McCall Corporation has a capital structure consisting of 55 percent common equity, 30 percent debt, and 15 percent preferred stock. Any debt issues would have a pre-tax cost of 9.5%. Preferred stock can be issued for a cost of 11.5%. Common equity can be issued, but flotation costs of $4.25 per share of common stock would be paid. McCall common stock is currently selling in the market at $65 per share. McCall recently paid a dividend of $4 per share and company earnings and dividends are expected to grow at an annual rate of 8% indefinitely. McCall has a marginal tax rate of 35% and the firm wants to keep its current capital structure. If the firm needs to raise additional equity, what will be the firm's cost of capital?

Answers

Answer:

WACC = 12.14%

Explanation:

Cost of debt = 9.5% x (1 - 35%) = 6.175%

Cost of preferred stock = 11.5%

Cost of equity (Re) = {D₁ / [P₀(1 - F)]} + g

Re = {($4.25 x 1.08) / [$65 x (1 - $4.25/$65)]} + 8% = ($4.59 / $60.75) + 8% = 15.56%

WACC = (15.55% x 0.55) + (6.175% x 0.30) + (11.5% x 0.15) = 8.56% + 1.85% + 1.73% = 12.14%

A coworker of Connor​'s recommends that she maximize the shelf space devoted to those drinks with the highest contribution margin per case. Do you agree with this​ recommendation? Explain briefly.

Answers

Answer:

Yes

Explanation:

Ultimately I agree with the recommendation that has been given by Connor's coworker. By maximizing the shelf space specifically devoted to these drinks it will cause two things to happen. First, customers will mostly notice those drinks which will entice them to buy those drinks instead of the ones they cannot see. The second is that since customers are buying more of these drinks, the increase in sales will also increase profits, but since these items contribution margins are significantly higher than the others, it will cause profits to drastically increase.

​Jack, an employee of Desert​ Sky, Inc., has gross salary for May of . The entire amount is under the OASDI limit of​ $118,500 and thus subject to FICA. He is also subject to federal income tax at a rate of ​%. Which of the following is a part of the journal entry for accrual of the employer payroll​ taxes? (Assume a FICAOASDI Tax of ​% and FICAMedicare Tax of ​%.) ​Jack's income to date exceeds the FUTA and SUTA tax income limits

Answers

Answer:

Credit to Cash for $4,995 is correct

Explanation:

here is a complete question

has a gross salary for May of $7,000. The entire amount is under the OASDI limit of $118,500 and thus subject to FICA. He is also subject to federal income tax at a rate of 21%. Which of the following is a part of the journal entry to record the disbursement of his net pay? (Assume a FICA-OASDI Tax of 6.2 % and FICA-Medicare Tax of 1.45%. Round the final answer to the nearest dollar.) A. debit to Cash for $4,995 B. debit to FICA Tax Payable of $4,995 O C. debit to Employee Income Tax Payable of $4,995 D. credit to Cash for $4,995

The computation of the amount that becomes the part for accrual the employer payroll taxes is shown below:

Gross Pay                   $7,000  

Less: Deductions    

Federal Income tax       $1,470            ($7000 × 21%)

FICA-OASDI tax             $434              ($7000 × 6.2%)

FICA-Medicare tax         $102              ($7,000 × 1.45%)

Total Deductions          2006  

Net pay                         $4,995  

During the first month of operations ended August 31, Kodiak Fridgeration Company manufactured 60,000 mini refrigerators, of which 54,000 were sold. Operating data for the month are summarized as follows:
Sales $10,260,000.00
Manufacturing costs:
Direct materials $5,100,000.00
Direct labor 1,800,000.00
Variable manufacturing cost 1,200,000.00
Fixed manufacturing cost 840,000.00 8,940,000.00
Selling and administrative expenses:
Variable $972,000.00 324,000.00
Fixed 1,296,000.00
Required:
1. Prepare an income statement based on the absorption costing concept.
2. Prepare an income statement based on the variable costing concept.
3. Explain the reason for the difference in the amount of operating income reported in (1) and (2). Refer to the list of Labels and Amount Descriptions provided
Labels and Amount Descriptions
Labels
August 31
Cost of goods sold
Fixed costs
For the Month Ended
August 31
Variable cost of goods sold
Amount Descriptions
Contribution margin
Contribution margin ratio
Cost of goods manufactured
Fixed manufacturing costs
Fixed selling and administrative expenses
Gross profit
Operating income
Inventory, August 31
Loss from operations
Manufacturing margin
Planned contribution margin
Sales
Sales mix
Selling and administrative expenses
Total cost of goods sold
Total fixed costs
Total fixed costs
Total variable cost of goods sold
Variable cost of goods manufactured
Variable selling and administrative expenses

Answers

Answer:

Kodiak Fridgeration Company

1. Income Statement for the month ended August 31, absorption costing concept:

Sales                                                            $10,260,000.00

Manufacturing costs:

Direct materials                    $5,100,000.00

Direct labor                             1,800,000.00

Variable manufacturing cost 1,200,000.00

Fixed manufacturing cost        840,000.00

Total manufacturing             8,940,000.00

Less Ending Inventory             894,000.00   8,046,000.00

Gross profit                                                    $2,214,000.00

Selling and administrative expenses:

Variable         $972,000.00

Fixed               324,000.00                              1,296,000.00

Net Income                                                       $918,000.00

2. Income Statement for the month ended August 31, absorption costing concept:

Sales                                                            $10,260,000.00

Manufacturing costs:

Direct materials                    $5,100,000.00

Direct labor                             1,800,000.00

Variable manufacturing cost 1,200,000.00  

Total manufacturing              8,100,000.00

Less Ending Inventory              810,000.00   7,290,000.00

Gross profit                                                    $2,970,000.00

Fixed manufacturing cost        840,000.00

Selling and administrative expenses:

Variable                                    972,000.00

Fixed                                        324,000.00    2,136,000.00

Net Income                                                      $834,000.00

3. The reason for the difference in the amount of operating income reported in (1) and (2) are the cost of products assigned to cost of goods sold and ending inventory  are not the same.  The following reconciliation buttresses this point:

Net operating income as per absorption costing $918,000.00

less Ending inventory, ($149 - $135) x 6,000           84,000.00

Net operating income as per variable costing    $834,000.00

Explanation:

a) Data and Calculations:

Units produced = 60,000

Units sold = 54,000

Ending inventory = 6,000

Sales $10,260,000.00

Manufacturing costs:

Direct materials $5,100,000.00

Direct labor 1,800,000.00

Variable manufacturing cost 1,200,000.00

Fixed manufacturing cost 840,000.00 8,940,000.00

Selling and administrative expenses:

Variable $972,000.00 324,000.00

Fixed 1,296,000.00

Kodiak's absorption costing concept incorporates all production costs into the cost of products.  This means that the cost of production includes all variable and fixed costs associated with production.  Costs that are not related to production are treated as period costs.  Whereas, with variable costing technique, only the variables costs of production are included in the costs of production.  All fixed costs, including factory overheads are treated as period costs.

Longman Company manufactures shirts. During June​, Longman made 1,900 shirts but had budgeted production at 2,150 shirts. Longman gathered the following additional​ data:

Variable overhead cost standard $0.80 per DLHr
Direct labor efficiency standard 4.50 DLHr per shirt
Actual amount of direct labor hours 8,620 DLHr
Actual cost of variable overhead $10,344
Fixed overhead cost standard $0.10 per DLHr
Budgeted fixed overhead $968
Actual cost of fixed overhead $1,033

Required:
a. Calculate the variable overhead cost variance.
b. Calculate the variable overhead efficiency variance.
c. Calculate the total variable overhead variance.
d. Calculate the fixed overhead cost variance.
e. Calculate the fixed overhead volume variance

Answers

Answer:

a.  variable overhead cost variance-   $3,448  Unfavorable

b.  variable overhead efficiency variance-  $ 56 unfavorable

c. total variable overhead variance -   $3,504  Unfavorable

d. fixed overhead cost variance - $65   unfavorable

e. Fixed overhead volume variance -$ 112.5   unfavorable

Explanation:

Variable overhead rate variance                                          $

8,620 hours should have cost (8,620  × $0.80)               6896

but did cost                                                                         10,344

Variable overhead rate variance                                    3,448 Unfavorable

Variable overhead rate variance  =$3,448 unfavorable

Efficiency variance                                                                 Hours

190 units should have taken (1,900 × 4.50 hrs)                  8,550

but did take                                                                            8,620

Efficiency variance in hours                                                    70   unfavorable

Standard rate                                                                    ×   $0.80

Efficiency variance                                                           $ 56 unfavorable

Efficiency variance  =$ 56 unfavorable

Total variable overhead= rate variance +efficiency

Total variable overhead =  $3,448 UF + $ 56 UF =  $3,504  U

Total variable overhead = $3,504  Unfavorable

Fixed overhead cost variance

                                                                      $

Budgeted cost                                           968

Actual cost                                                1,033

Fixed overhead cost Variance           65   unfavorable

Fixed Overhead Volume

                                                                            Units

Budgeted units                                                 2,150                                      

Actual    units                                                       1,900

Variance                                                                  250

Standard fixed cost per unit (Notes)                $0.45

Volume Variance                                             112.5   unfavorable

Standard fixed overhead cost per unit

= standard hours × standard Fixed overhead rate = 4.5 × $0.1= $0.45

a.  variable overhead cost variance-   $3,448 Unfavorable

b.  variable overhead efficiency variance-  $ 56 unfavorable

c. total variable overhead variance -   $3,504  Unfavorable

d. fixed overhead cost variance - $65   unfavorable

e. Fixed overhead volume variance -$ 112.5   unfavorable

Sea Blue manufactures flotation vests in Charleston, South Carolina. Sea Blue's contribution margin income statement for the month ended December 31, 2018, contains the following data:
Sea Blue
Income Statement
For the Month Ended December 31, 2018
Sales in Units 32,000
Net Sales Revenue $608,000
Variable Costs:
Manufacturing 96,000
Selling and Administrative 108,000
Total Variable Costs 204,000
Contribution Margin 404,000
Fixed Costs:
Manufacturing 124,000
Selling and Administrative 94,000
Total Fixed Costs 218,000
Operating Income $186,000
Suppose Overboard wishes to buy 4,600 vests from Sea Blue. Sea Blue will not incur any variable selling and administrative expenses on the special order. The Sea Blue plant has enough unused capacity to manufacture the additional vests. Overboard has offered $15 per vest, which is below the normal sales price of $19.
1. Identify each cost in the income statement as either relevant or irrelevant to Sea Blue's decision.
a. Variable Manufacturing Costs
b. Variable Selling and Administrative Costs
c. Fixed Manufacturing Costs
d. Fixed Selling and Administrative Costs
2. Prepare a differential analysis to determine whether Sea Blue should accept this special sales order.
3. Identify long-term factors Sea Blue should consider in deciding whether to accept the special sales order. In addition to determining the special order's effect on operating profits, Sea Blue's managers also should consider the following:
A. Will Sea Blue's other customers find out about the lower sale price Sea Blue accepted from Overboard? If so, will these other customers demand lower sale prices?
B. Will the special order customer come back again and again, asking for the same reduced price?
C. How will Sea Blue's competitors react? Will they retaliate by cutting their prices and starting a price war?
D. All of the above
E. None of the above

Answers

Answer:

1. Variable Cost

Manufacturing 96,000 ( Relevent )

Selling and administrative 108,000 ( Irrelevent )

Fixed Cost

Manufacturing 124,000 ( Irrelevent )

Selling and administrative 94,000 (Irrelevent )

2. $55,200

3. A. If the regular customer found out about this order and will demand a lower price?

B. Will this order customer come back again and again asking the same reducted price?

C. Will this order price will start a price war with the competitors?

Explanation:

1. Calculation to Identify each cost in the income statement as either relevant or irrelevant to Sea Blue's decision.

Variable Cost

Manufacturing 96,000 ( Relevent )

Selling and administrative 108,000 ( Irrelevent )

Fixed Cost

Manufacturing 124,000 ( Irrelevent )

Selling and administrative 94,000 (Irrelevent )

2. Preparation of a differential analysis to determine whether Sea Blue should accept this special sales order.

Differential analysis

Expected increase in income in revenue

( 4,600 vest * $15 per vest ) 69,000

Less :Expected increase in Variable manufacturing

( 4,600 vest * $3 per vest) (13,800)

=$55,200

Variable manufacturing cost of $96,000 / divide by 32,000 units will give us $3

Based on the above calculation Sea blue should accept this order reason been that the order will increase their operating income by the amount of $55,200.

3. The manager of Sea blue should know that the sale might affect their regular sale in long run.

Therefore In addition to determining the special order's effect on operating profits, Sea Blue's managers also should consider:

A. If the regular customer found out about this order and will demand a lower price?

B. Will this order customer come back again and again asking the same reducted price?

C. Will this order price will start a price war with the competitors?

Other Questions
A team decision which makes a decision situation more familiar and safer is:_______ a. Free riding b. Group hate c. Risky shift A 160-lb man carries a 5-lb can of paint up a helical staircase that encircles a silo with radius 20 ft. If the silo is 90 ft high and the man makes exactly three complete revolutions, how much work is done by the man against gravity in climbing to the top A current of 5 A is flowing in a 20 mH inductor. The energy stored in the magnetic field of this inductor is:_______a. 1J. b. 0.50J. c. 0.25J. d. 0. e. dependent upon the resistance of the inductor. QUESTION 7What is the condition in which the size of figures is determined by social importance rather than observation? A bond is being issued to build a toll road. It has been identified that the state does not own all of the property that the road is going to be built upon. This would most likely be disclosed in y elabora el siguiente cuadro como un ejercicio personal para identificar tus caractersticas, tus capacidades, tus valores, tus fortalezas y tus limitaciones. Public assembly facilities have existed since A. medieval times. B. the early 1900s. C. ancient times. D. the invention of baseball in the Elysian fields of the 1840s. the tarp lies or lays on the ground How much time is required for a P-wave to travel 6,000 kilometers? What happened to make plantation owners decide to use only slave labor for growing crops? inscribed angles. need answers asap , thank u! Given the trinomial, what is the value of the coefficient B in the factored form? 2x2 + 4xy 48y2 = 2(x + By)(x 4y) solve 27 to the power of (2/3) Find the distance between the two points (8, 3) and (0, -3) If there is a positive correlation between salary and education, then based on the table shown, which of the following careers requires the most education? A graph titled Average Salaries of Various Careers, 2008 to 2009. Veterinarian, 56,000 dollars; personal trainer, 18,000 dollars; accountant, 43,000 dollars; paralegal, 34,000 dollars; architect, almost 50,000 dollars; photographer, 19,000 dollars; pharmacist, 44,000 dollars; secretary, 30,000 dollars; surveyor, 36,000 dollars; webmaster, 49,000 dollars. a. accountant b. paralegal c. photographer d. surveyor Which is the simplified form of (StartFraction 2 a b Over a Superscript negative 5 Baseline b squared EndFraction) Superscript negative 3? Assume a not-equals 0, b not-equals 0. StartFraction b cubed Over 8 a Superscript 18 Baseline EndFraction StartFraction b squared Over 8 a Superscript 45 Baseline EndFraction StartFraction a Superscript 6 Baseline Over 4 b EndFraction StartFraction 2 a Superscript 6 Baseline Over b Superscript 5 Baseline EndFraction $10,000 for 20 years at 5% compounded annually A stock had returns of 17.88 percent, 5.16 percent, and 20.39 percent for the past three years. What is the variance of the returns? The word communis comes form Flying against the wind, a jet travels 1650 miles in 3 hours. Flying with the wind, the same jet travels 3480 miles in 4 hours. What is the rate of the jet in still air and what is the rate of the wind?