Answer:
The sales volume variance is $20,000 Unfavorable.
Explanation:
Particular : Actual ; Flexible Budget ; Variance
Sales : 240,000 ; 300,000 ; 60,000 U
Variable Cost : 200,000 ; 192,000 ; 8,000 U
Contribution Margin : 40,000 ; 108,000 ; 68,000 U
Fixed Cost : 25,000 ; 80,000 ; 55,000 U
Operating Income : 15,000 ; 28,000 ; 20,000U
Milford Company sells a motor that carries a three-month unconditional warranty against product failure. Based on a reliable statistical analysis, Milford knows that between the sale and the end of the product warranty period, two percent of the units sold will require repair at an average cost of $50 per unit. The following data reflect Milford's recent experience:
Oct Nov Dec Dec 31 Total
Units unsold 24000 26000 26000 76000
Known products failure from sales in:
October 130 190 170 490
November 130 220 350
December 210 210
Calculate, and prepare a journal entry to record, the estimated liability for product warranties at December 31. Assume that warranty costs of known failures have already been reflected in the records.
Answer: See explanation
Explanation:
Number of units sold = 76000
Percentage repair= 2%
Estimated defective units = Percentage repair × Units sold = 2% × 76000 = 1520
Actual defective units = 490 + 350 + 210 = 1050
Unclaimed warranty = Estimated defective units - Actual defective units = 1520 - 1050 = 470
Repair cost = $50
Warranty expense = 470 × $50 = $23500
The journal entry will then be:
31 December:
Debit: Product warranty expense = $23500
Credit: Estimated liability for product warranty = $23500
Frasquita acquired equipment from the manufacturer on 6/30/2021 and gave a noninterest-bearing note in exchange. Frasquita is obligated to pay $550,000 on 4/30/2022 to satisfy the obligation in full. If Frasquita accrued interest of $15,000 on the note in its 2021 year-end financial statements, what amount would it have recorded the equipment for on 6/30/2021
Answer:
$525,000
Explanation:
Calculation to determine what amount would it have recorded the equipment for on 6/30/2021
First step is to calculate the total interest for 10 months;
Based on the information given since the amount of $15,000 was the interest for 6 months in the year 2021 in which the note lasted for 10 months the total interest will be:
Total Interest = 10months/6months x $15,000 Total Interest=$25,000
Now let calculate 6/30/2021 Equipment
6/30/2021 Equipment=$550,000-$25,000
6/30/2021 Equipment=$525,000
Therefore what amount would it have recorded the equipment for on 6/30/2021 is $525,000
Which of the following positions refers to a functional manager?
A. Chief executive officer
B. Purchasing manager
C. Manager, Office Equipment Division
O D. Vice President, Latin American Operations
The functional manager is the individual with management authority within a business unit or department . Hence Option B is correct .
What is Functional Manager ?who has direct supervision over one or more team members and/or direct accountability for the functions impacted by or affecting project or program deliverables. Hence option B is correct .
Many of the many functions are combined and managed by a manager when an information systems organization grows larger. These functional managers oversee the personnel particular to their role and answer to the CIO.
An organization's functional roles, such as those of a manager, director, or vice president, define a set of abilities and tasks that are normally carried out by a department inside the company. The organizational structure of an organization establishes functional responsibilities. These roles inside that department have resources assigned to them.
A practical A manager is in charge of a specific functional area within an organization, like a team or department. They are in charge of organizing, controlling, and supplying resources for initiatives.
Learn more about Functional manager here
https://brainly.com/question/15351742
# SPJ 2
In previous years, Cox Transport reacquired 2 million treasury shares at $24 per share and, later, 1 million treasury shares at $27 per share. If Cox now sells 2 million treasury shares at $29 per share and determines cost as the weighted-average cost of treasury shares, by what amount will Cox’s paid-in capital - share repurchase increase?
Answer:
the increase in the paid in capital is $4 million
Explanation:
The computation of increase in paid in capital is shown below:
The weighted ratio is 2:1 i.e. 66.67%, 33.33%
Now weighted average price is
= (0.6667 × $24) + (0.3333 × $27)
= $25
Now the increase in paid in capital is
= ($29 - $25) × 1 million
= $4 million
Hence, the increase in the paid in capital is $4 million
PLEASE HELP!! Imagine you are applying for a job as a babysitter or as a grass-cutter. Write a cover letter that tells the family why you are qualified for the job. Use a proper business letter writing format
I am a devoted babysitter. I have plenty of experience with children. I know how to cook, I am great with tools. I am very independent and have plenty of potentials. I hope you can trust me with your kids or your yard.
9. A Japanese car manufacturer built a factory in the United
States, It did so to reduce shipping and other costs. Make a list
of who will benefit and who will not benefit from this factory.
Answer:
Se benefician los estado unidenses porque no tienen que pagar más por el coche, también porque al abrir una fábrica pueden llegar a crear más de 5.000 puestos de trabajo. Y los japoneses no salen beneficiados porque la empresa que lleva los coches de Japón a estados unidos seguramente sea japonesa y también los trabajadores japoneses pierden trabajo
Explanation:
Cherry Valley Lumber's (CVL) lumber mill produces boards of various sizes and quality specifications for the home construction industry. CVL incurs joint costs in the initial phases of processing raw timber, such as transporting the logs to the mill, removing the bark from the logs, and cutting rough-cut boards. After the split-off point, CVL incurs costs in the Planing Department to finalize the finished boards of various grades and sizes. Which of the following statements regarding the costs at CVL is true?
a. The costs to finish the boards after the split-off point will not be traced directly to the finished boards according to the various grades and sizes produced. The costs for transporting the logs, removing bark, and cutting the rough-cut boards before the split-off point will be traced to the final finished boards.
b. The costs for transporting the logs, removing bark, and cutting the rough-cut boards before the split-off point will not be directly traced to the final finished boards. All costs to finish the boards after the split-off point will be traced directly to the finished boards according to the various grades and sizes produced.
c. It will be impossible for CVL to directly trace any costs to the finished boards of various grades and sizes.
d. CVL will be able to directly trace all costs before and after the split-off point to the finished boards of various grades and sizes.
Answer:
Cherry Valley Lumber's (CVL)
The statement regarding the costs at CVL that is true is:
b. The costs for transporting the logs, removing bark, and cutting the rough-cut boards before the split-off point will not be directly traced to the final finished boards. All costs to finish the boards after the split-off point will be traced directly to the finished boards according to the various grades and sizes produced.
Explanation:
This is why the costs at split-off are usually apportioned to the different categories of products based on some chosen criteria, e.g. sales value, size, etc. However, after split-off, costs that are incurred can easily be traced to the various grades and sizes of boards produced. This simply means that after split-off, costs become traceable and direct to each board category.
Woolsey Corporation, a US company, expects to sell gods to a foreign customer at a price of 250,000 FC, with delivery and payment to be made on October 24, 2020. On July 24, 2020, Woolsey purchased a three-month put option for 250,000 FC and designated this option as a cash flow hedge of a forecasted foreign currency transaction expected to be completed in late October 2020. Assume that the transaction occurs on October 24, 2020 as expected. The option cost $4,000 and has a strike price of $2.17 per FC. The following spot exchange rates apply:
Answer:
$10,000 positive.
Explanation:
The computation of the amount that should be included is shown below:
= (Option strike price - spot rate) × purchased put options
= ($2.17 - $2.13) × 250,000
= $10,000
As the spot rate is less than the strike price so automatically there is a gain of $10,000:
Burning one gallon of gasoline in a car releases approximately 20 pounds of CO2 into the atmosphere. One average person drives 60,000 miles in a car that average 30 miles per gallon (mpg), while another person drives 60,000 miles in a car that averages 20 mpg. Over the course of the 60,000 miles, how many fewer punds of CO2 are released by the 30 mpg car than by the 20 mpg car?
Answer: 20,000 pounds of CO₂
Explanation:
30 mpg car.
Number of gallons of gasoline used:
= 60,000 / 30
= 2,000 gallons
CO₂ released = 2,000 * 20
= 40,000 pounds
20 mpg car
Number of gallons used:
= 60,000 / 20
= 3,000 gallons
CO₂ released = 3,000 * 20
= 60,000 pounds
Difference:
= 60,000 - 40,000
= 20,000 pounds of CO₂
The number of fewer pounds should be 20,000 pounds of CO₂
The calculation is as follows:The Number of gallons of gasoline used:
= 60,000 ÷ 30
= 2,000 gallons
and,
CO₂ released = 2,000 × 20
= 40,000 pounds
Now
Number of gallons used:
= 60,000 ÷ 20
= 3,000 gallons
And,
CO₂ released = 3,000 × 20
= 60,000 pounds
So, the Difference is
= 60,000 - 40,000
= 20,000 pounds of CO₂
Learn more: https://brainly.com/question/994316?referrer=searchResults
Ron was vacationing in France, when his camera was stolen. As he walked into a camera store, Ron noticed that camera prices were in euros. If Ron was willing to pay $ for a new digital camera and the exchange rate is $ per euro, how much will Ron be paying in euros? Ron will be paying nothing euros for the camera. (Instructions: Enter your response by rounding two places after the decimal.)
Answer:
130.43 euros
Explanation:
Since Ron willing to Pay is $150
Now we have to convert $150 in euros
As we know that
exchange rate × willing to pay in euro = Willing to pay in Dollar
i.e.
willing to pay in euro = Willing to pay in Dollar ÷ Exchange rate
= 150 ÷ 1.15
= 130.43 euros
Hence, the ron be paying in euros is 130.43
The same would be relevant
Suppose a stock had an initial price of $85 per share, paid a dividend of $1.50 per share during the year, and had an ending share price of $99. a. Compute the percentage total return. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b. What was the dividend yield
Answer:
18.23%
1.76%
Explanation:
The total return of a stock = price return + dividend yield
Price return calculates the change in price of a stock
Price return = (change in price / initial stock price ) x 100
change in price = $99 - $85 = $14
($14 / $85) x 100 = 16.47%
Dividend yield = (dividend paid / initial price of the stock ) x 100
($1.5 / $85) x 100 = 1.76%
Total return = 16.47% + 1.76% = 18.23%
Which of the following statements concerning the use of support department and joint cost allocations for performance evaluations is not true?
A. A manager may not be responsible for the allocation of support department costs if he or she cannot control the square footage of the areas upon which cost allocations are based.
B. A manager may miss a performance target because direct materials costs are too high.
C. A manager may miss a performance target because he or she has no control over the joint processes prior to his or her department which is after the split-off point.
D. It is rare to need further investigation beyond a preliminary analysis when a manager misses a performance target.
Answer:
d.It is rare to need further investigation beyond a preliminary analysis when a manager misses a performance target.
Explanation:
Performance evaluation can be regarded as process whereby manager pass evaluation or examination on employee on the work behavior of employee through comparison with preset standards.
In the use of support department and joint cost allocations for performance evaluations ;
✓A manager may not be responsible for the allocation of support department costs if he or she cannot control the square footage of the areas upon which cost allocations are based.
✓A manager may miss a performance target because direct materials costs are too high.
✓A manager may miss a performance target because he or she has no control over the joint processes prior to his or her department which is after the split-off point.
The Bradford Company issued 12% bonds, dated January 1, with a face amount of $87 million on January 1, 2021. The bonds mature on December 31, 2030 (10 years). For bonds of similar risk and maturity, the market yield is 14%. Interest is paid semiannually on June 30 and December 31. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) Required: 1. Determine the price of the bonds at January 1, 2021. 2. to 4. Prepare the journal entries to record their issuance by The Bradford Company on January 1, 2021, interest on June 30, 2021 and interest on December 31, 2021 (at the effective rate).
Answer:
1. $77,783,220
2. Jan-21
Dr Cash $ $77,783,220
Dr Discount On Bond $9,216,780
Cr Bond Payable $ $87,000,000
Explanation:
1. Calculation to Determine the price of the bonds at January 1, 2021.
First step is to calculate the Present Value Of Annual Interest
a Semi-annual Interest Amount $5,220,000
($87,000,000*12%/2)
b PV Annuity Factor for (20 Years,14%/2=7%) 10.5940
c Present Value Of Annual Interest (a*b) $ $55,300,680
($5,220,000*10.5940)
Second step is to calculate Present Value Of Redemption Amount
a Redemption Value $ $87,000,000
b PV Factor Of (20 Years,7%) 0.25842
c Present Value Of Redemption Amount (a*b) $ $22,482,540
($87,000,000*0.25842 )
Now let Determine the price of the bonds at January 1, 2021.
Intrinsic Value ( Price ) Of The Bond = ($55,300,680+$22,482,540)
Intrinsic Value ( Price ) Of The Bond =$77,783,220
Therefore the price of the bonds at January 1, 2021 is $77,783,220
2. Preparation of the journal entries to record their issuance by The Bradford Company on January 1, 2021,
Jan-21
Dr Cash $ $77,783,220
Dr Discount On Bond $9,216,780
($87,000,000-$77,783,220)
Cr Bond Payable $ $87,000,000
(Being to record issuance of bond)
3. Preparation of the journal entries to record their issuance by The Bradford Company on ion June 30, 2021
Jun-30
Dr Interest expenses $ 53,82,240
Discount On Bond payable $ 2,22,240
Cash $5,220,000
4.Preparation of the journal entries to record their issuance by The Bradford Company on
December 31, 2021
Dec-31 Interest expenses $ 53,97,797
Discount On Bond payable $ 2,37,797
Cash $5,220,000
( to record interest payment)
Pilgrim Industries scheduled its annual sales meeting at Celestial City Resort from January 5-10. In addition to meeting and hotel rooms, the resort was to provide an ice-skating pond for the Pilgrim's annual employee hockey game. In the weeks before the meeting, the resort is hit with its worst heat wave on record. Although hotel and meeting rooms are available, there is no possibility of ice skating at the site. If a court finds that the one of Pilgrim's principal purposes in the agreement was the inclusion of an ice-skating pond, the Pilgrim-Celestial contract could be discharged via the doctrine of:
Answer:
If a court finds that the one of Pilgrim's principal purposes in the agreement was the inclusion of an ice-skating pond, the Pilgrim-Celestial contract could be discharged via the doctrine of:
Frustration of Purpose.
Explanation:
The doctrine of Frustration of Purpose occurs when there is a change of circumstances that is not the fault of either Pilgrim Industries or Celestial City Resort. Since these two parties did not cause the circumstances that made it legally, physically, or commercially impossible to fulfil the contract, the contract can be discharged by the court based on this doctrine. It is also known as Force Majeure.
Black Oil Company considered building a service station in a new location. The owners and their accountants decided that this was the profitable thing to do. However, soon after they made this decision, both the interest rate and the cost of building the station changed. In which case do these changes both make it less likely that they will now build the station?
Answer: An increase in the Interest rates and the cost of building the station
Explanation:
Before setting out to do business, most companies and investors calculate the cost of setting up the business and what they stand to gain when the business does well and when it doesn't. Most of these analysis are done when the business is being put into consideration. When there is a change in cost of any of the items put into consideration, the business would either be carried out or cancelled. What could discourage the Black oil company would be either an increase in interest rates or cost of building the station.
Emilio works in Finance. He collaborates with Real Estate Agents and title companies to help people qualify for home loans. In which career does Emilio work?
Mortgage Brokering
Insurance Sales
Tax Preparation
Financial Management
Answer:
Mortgage Brokering
Answer:
Mortgage Brokering
Explanation:
Whispering Winds Corp. had the following transactions. 1. Sold land (cost $7,200) for $9,000. 2. Issued common stock at par for $22,900. 3. Recorded depreciation on buildings for $16,600. 4. Paid salaries of $7,000. 5. Issued 1,100 shares of $1 par value common stock for equipment worth $9,200. 6. Sold equipment (cost $14,400, accumulated depreciation $10,080) for $1,728. (a) For each transaction above, prepare the journal entry.
Answer and Explanation:
The journal entries are shown below:
1 Cash $9,000
To Land $7,200
To Gain on Disposal $1,800
(Being the land is sold is recorded)
2 Cash $22,900
To Common Stock $22,900
(being the issuance of the common stock is recorded)
3 Depreciation Expense $16,600
To Accumulated Depreciation - Buildings $16,600
(being depreciation expense is recorded)
4 Salaries and Wages Expense $7,000
To Cash $7,000
(being salary paid is recorded)
5 Equipment $9,200
To Common Stock $1,100
To Paid in capital in excess of par-Common stock $8,100
(Being the common stock issued for the equipment)
6 Cash $1,728
Accumulated Depreciation-Equipment $10,080
Loss on Disposal $2,592
To Equipment $14,400
(being equipment sold is recorded)
Crane Company offered detachable 5-year warrants to buy one share of common stock (par value $5) at $20 (at a time when the stock was selling for $30). The price paid for 700, $1,000 bonds with the warrants attached was $810000. The market price of the Crane bonds without the warrants was $710000, and the market price of the warrants without the bonds was $71800. What amount should be allocated to the warrants
Answer:
$ 74,389.87
Explanation:
It is given that :
The cost of 700, $1000 bonds with warrant attached to the bond = $810,000
The cost of Crane bonds with warrant = $710,000
The cost of market price of the warrants without bonds = $71,800
Therefore, the amount should be allocated to the warrants :
[tex]$=\frac{\$71,800}{\$71,800+\$710,000}\times \$ 810,000$[/tex]
[tex]$=\frac{\$71,800}{\$781,800}\times \$ 810,000$[/tex]
= $ 74,389.87
How does implementing change affect strategic relationship management?
A. It upsets the balance between the needs of key positions.
ОО
B. There is very little impact on relationship management.
O C. Change doesn't impact internal relationships.
O D. It makes fewer resources available to satisfy stakeholders.
Answer:
A it upsets the balance
Explanation:
Answer:a
Explanation:
it upsets the balance
ou have just bought a used track-type tractor to add to your production fleet. The initial capitalized value of the tractor is $110,000. The estimated service life remaining on the tractor is 10,000 hours and the anticipated operating conditions across the remainder of its life are normal. The salvage value of the tractor is $12,000. The tractor was purchased on July 1, 1997. a. What amount of depreciation will you claim for each calendar year between 2007 and 2010
Answer: $32,667
Explanation:
The truck's useful life is 3 years because it is 2007 to 2010.
Depreciation = (Cost - Salvage value) / Useful life
= (110,000 - 12,000) / 3
= $32,667 per year
At the denominator activity level, Norland Company's total overhead budget for 35,000 units of production shows variable overhead costs of $40,000 and fixed overhead costs of $28,000. During the most recent period, the company incurred total overhead costs of $48,000 to manufacture 21,000 units. The total factory overhead variance for Norland Co. for the most recent period, to the nearest whole dollar, was:________ (Round your intermediate calculation to 2 decimal places.)
a. $200 favorable.
b. $7,000 unfavorable.
c. $600 unfavorable.
d. $6,600 favorable.
e. $6,000 unfavorable.
Bankruptcy, Chapter 7. Gigantic Furniture is having its annual "Going Out of Business Sale." If Gigantic Furniture is filing under Chapter 7, will it be back next year for another going out of business sale? (Select the best response.) A. No, Chapter 7 bankruptcy is for the selling off of all the assets of the firm and ceasing all business operations. B. No, Chapter 7 bankruptcy is for restructuring the firm's debt and it does not allow to have more than one "Going Out of Business Sale." C. Yes, Chapter 7 bankruptcy is for restructuring the firm's debt and buying new inventory. D. Yes, Chapter 7 bankruptcy is for the selling off of all the assets of the firm and ceasing all business operations.
Answer:
A. No, Chapter 7 bankruptcy is for the selling off of all the assets of the firm and ceasing all business operations.
Explanation:
In the chapter of Bankruptcy, chapter 7, the firm Gigantic Furniture is going to have its annual " Going Out of Business Sale". Now if the Gigantic Furniture is filing under the Chapter 7, it will not be back for the next year for an another going out of the business sale because Gigantic Furniture is selling off all of its assets and ceasing all its business operations.
Windsor, Inc. purchased a delivery truck for $32,000 on January 1, 2022. The truck has an expected salvage value of $4,000, and is expected to be driven 100,000 miles over its estimated useful life of 8 years. Actual miles driven were 16,600 in 2022 and 13,100 in 2023. (a1) Calculate depreciable cost per mile under units-of-activity method. (Round answer to 2 decimal places, e.g. 0.50.) Depreciable cost
Answer:
Depreciable cost per mile= $0.28
Explanation:
Giving the following information:
Purchase price= $32,000
Salvage value= $4,000
Miles= 100,000
To calculate the depreciable cost per mile under the units-of-activity method, we need to use the following formula:
Depreciable cost per mile= (original cost - salvage value)/useful life of production in miles]
Depreciable cost per mile= (32,000 - 4,000) / 100,000
Depreciable cost per mile= $0.28
5 types of challenges in the business environment
Answer:
Uncertainty about the future.
Financial management.
Monitoring performance.
Regulation and compliance.
Competencies and recruiting the right talent.
Explanation:
The taxpayer is a Ph.D. student in accounting at City University. The student is paid $1,500 per month for teaching two classes. The total amount received for the year is $13,500. a.The $13,500 is considered a scholarship and, therefore, is excluded. b.The $13,500 is excluded because the total amount received for the year is less than her standard deduction and personal exemption. c.The $13,500 is taxable compensation. d.The $13,500 is excludible if the money is used to pay for tuition and books.
Answer: c. The $13,500 is taxable compensation.
Explanation:
The $13,500 received is to be considered a taxable compensation because amounts paid for teaching or research, even to students, should be included in the gross income calculation which makes it a taxable compensation.
There are some exceptions to this however such as income from the National Health Service Corps Scholarship Program, the Armed Forces Health Professions Scholarship and Financial Assistance Program but this does not apply here.
Peterson Company's general ledger shows a cash balance of $7,420 on May 31. May cash receipts of $1,290, included in the general ledger balance, are placed in the night depository at the bank on May 31 and processed by the bank on June 1. The bank statement dated May 31 shows an NSF check for $170 and a service fee of $60. The bank processes all checks written by the company by May 31 and lists them on the bank statement, except for one check totaling $1,900. The bank statement shows a balance of $7,800 on May 31. Prepare a bank reconciliation to calculate the correct ending balance of cash on May 31.
Answer:
The correct ending balance of cash on May 31 is $7,190
Explanation:
The bank reconciliation can be prepared as follows:
Peterson Company
Bank Reconciliation
At May 31
Particulars $
Bank statement balance at May 31 yet to be reconciled 7,800
Add:
Cash deposited on May 31 yet to be credited 1,290
Less:
Outstanding check (1,900)
Adjusted bank statement balance at May 31 7,190
Peterson Company
Bank Reconciliation
At May 31
Particulars $
Cash book balance yet to be reconciled 7,420
Less:
NSF check (170)
Service fee (60)
Adjusted cash balance at May 31 7,190
Since in each of the Adjusted bank statement balance at May 31 and the Adjusted cash balance at May 31 is equal to $7,190, it implies that the correct ending balance of cash on May 31 is $7,190.
Mortar Corporation acquired 80 percent of Granite Corporation's voting common stock on January 1, 20X7. On December 31, 20X8, Mortar received $370,000 from Granite for equipment Mortar had purchased on January 1, 20X5, for $400,000 and had been depreciating it over 10 Years and no salvage value. After the sale, the equipment is expected to have a 5-year useful life and no salvage value. Both companies depreciate equipment on a straight-line basis. Based on the preceding information, in the preparation of elimination entries related to the equipment transfer for the 20X8 consolidated financial statements, the debit adjustment to equipment would be: Group of answer choices
Answer:
The debit adjustment to equipment would be $30,000.
Explanation:
Amount received for the equipment by Mortar from Granite - $370,000
Purchase price of the equipment = $400,000
Debit adjustment to equipment = Purchase price of the equipment - Amount received for the equipment by Mortar from Granite = $400,000 - $370,000 = $30,000
Therefore, the debit adjustment to equipment would be $30,000.
On January 1, 2011, The Miller Corporation purchased 300,000 shares of The Mayfair Corporation for $5.7 million. The investment represented 40% of The Mayfair Corporation's outstanding common shares. During 2011, Mayfair reported net earnings of $2.25 million and paid a cash dividend of $0.15 per share. During 2012, Mayfair reported a net loss of $180,000 and again paid a dividend of $0.15 per share. Calculate the book value of Miller's investment in Mayfair as of December 31, 2011, and December 31, 2012
Answer:
2011 Value of investment in Mayfair
= Beginning investment value + Portion of Mayfair net income - Portion of Mayfair dividends
= 5,700,000 + (40% * 2,250,000) - (300,000 shares * 0.15)
= $6,555,000
2012 Value of investment
= Beginning investment value + Portion of Mayfair net income - Portion of Mayfair dividends
= 6,555,000 + (40% * -180,000) - (300,000 * 0.15)
= $6,438,000
A company has two products: Cakes and Cookies. It uses activity-based costing and has prepared the following analysis showing budgeted costs and activities. Use this information to compute (a) the company's overhead rates for each of the three activities and (b) the amount of overhead allocated to Cakes.
Answer and Explanation:
The computation is shown below:
a. Overhead rate for each of the three activities is
For activity 1
= $60,000 ÷1500
= $40
For activity 2
= $75,000 ÷ 3,000
= $25
For activity 3
= $90,000 ÷ 1,700
= $53
b. The amount of overhead allocated is
= 40 ×700 + 25 × 1500 + 800 × 53
= $28,000 + $37,500 + $42,400
= $107,900
Suppose the Kalamazoo Brewing Company (KBC) currently sells its microbrews in a seven-state area: Illinoise, Indiana, Michigan, Minnesota, Mississippi, Ohio, and Wisconsin. The company's marketing department has collected data from its distributers in each state. This data consists of the quantity and price (per case) of microbrews sold in each state, as well as the average income (in thousands of dollars) of consumers living in various regions of each state. The data for each state are available via the link below--please note there are multiple tabs at the bottom of the spreadsheet, each refers to one of the seven states selling the Kalamazoo Brewing Company’s microbrews.
Excel Data File
Quantity Price Income
575 31.26 33.95
674 30.69 35.51
616 31.54 28.78
183 27.41 30.44
501 29.75 31.28
578 29.48 33.77
590 28.94 38.31
445 28.17 34.01
603 28.58 32.53
713 28.57 31.69
337 30.06 32.26
230 29.36 31.57
403 28.81 32.75
383 32.52 29.48
568 32.02 35.91
698 32.91 34.85
826 28.45 34.06
789 26.85 38.92
645 30.49 35.94
601 31.72 38.05
467 31.23 36.48
429 31.28 37.61
552 28.89 38.29
553 31.13 36.9
562 27.52 39.22
352 30.02 34.21
611 31.38 33.97
346 29.08 38.53
354 28.8 34.4
401 27.64 34.01
253 30.47 34.24
524 30.97 38.29
211 32.85 34.66
666 30.11 41.38
468 29.48 32.14
585 28.41 29.16
578 29.96 35.05
656 30.46 37.11
571 32.86 32.94
454 28.49 32.7
510 30.67 33.14
672 31.92 33.73
499 28.44 41.92
560 27.94 35.06
848 29.74 32.71
617 29.54 37.96
530 31.34 37.38
649 30.08 35.55
824 29.13 42.89
626 31.72 37.17
Assuming that the underlying demand relation is a linear function of price and income, use your spreadsheet program to obtain least squares estimates of Ohio’s demand for KBC microbrews. Instruction:
If the estimate is negative, enter a negative number (-) in the equation.
Answer:
The least squares estimates of Ohio’s demand for KBC microbrews is Quantity = 1.57Price + 14.00Income.
Explanation:
Note: See Sheet1 of the attached excel for the replication of the data given in the question and Sheet2 for the regression analysis output.
In the third table in the Sheet2, the second column is for the coefficients where, by rounding to 2 decimal places, we have:
Price = 1.57
Income = 14.00
Note: The intercept is 0 because a zero intercept was chosen in the analysi.
Based on the above, the least squares estimates of Ohio’s demand for KBC microbrews can be written as follows:
Quantity = 1.57Price + 14.00Income
To run the regression from Sheet1 in order to obtain the output in Sheet, follow his process:
Click the “Data” menu, and then the “Data Analysis” tab. From the new window, scroll down to find and click on "Regression" and then click “OK”.
In the new window, click in the box of “Input Y Range”, and then select the column containing the Quantity data as the dependent variable. Also in the new window, click in the box of “Input X Range”, and then select the column containing the both Price and Income data as the independent variables. Also, select "Labels", "Confidence level (95%)", and "Constant is Zero". Then click "OK" to obtain the output in Sheet2.