Differential Analysis - Three Scenarios Assignment
xlsx
keyboard_arrow_up
School
Concordia University *
*We aren’t endorsed by this school
Course
230
Subject
Accounting
Date
Apr 3, 2024
Type
xlsx
Pages
3
Uploaded by dogsuga
Current
Dirt
Mountain
Racing
$ 300,000 $ 90,000 $ 150,000 $ 60,000 $ 120,000 $ 27,000 $ 60,000 $ 33,000 $ 180,000 $ 63,000 $ 90,000 $ 27,000 $ 30,000 $ 10,000 $ 14,000 $ 6,000 $ 23,000 $ 6,000 $ 9,000 $ 8,000 $ 35,000 $ 12,000 $ 13,000 $ 10,000 $ 60,000 $ 18,000 $ 30,000 $ 12,000 $ 148,000 $ 46,000 $ 66,000 $ 36,000 $ 32,000 $ 17,000 $ 24,000 $ (9,000)
*Allocated on the basis of sales dollars.
$ (115,000)
Better or worse off?
Worse
Current
Difference
$ 300,000 $ - $ (300,000)
$ 120,000 $ - $ 120,000 $ 180,000 $ - $ (180,000)
$ 30,000 $ - $ 30,000 $ 23,000 $ 23,000 $ - $ 35,000 $ - $ 35,000 $ 60,000 $ 60,000 $ - $ 148,000 $ 83,000 $ 65,000 $ 32,000 $ (83,000)
$ (115,000) $ (115,000)
*Allocated on the basis of sales dollars.
Alternative approach:
Lost Contribution Margin from Racing Bikes
$ (180,000)
Avoidable Costs (Saved Fixed Expenses)
Advertising
$ 30,000 Salaies product line
$ 35,000 Total Avoidable Costs
$ 65,000 Net Difference
$ (115,000)
Differential Analysis - Add or Drop a Segment
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter follow:
Sales
Variable manufacturing and selling expenses
Contribution margin
Fixed expenses:
Advertising, traceable
Depreciation of special equipment
Salaries of product-line managers
Allocated common fixed expenses*
Total fixed expenses
Net operating income (loss)
Management is concerned about the continued losses shown by the racing bikes and wants a recommendation as to whether or not the line should be discontinued. The special equipment used to produce racing bikes has no resale value and does not wear out.
What is the impact on net operating income by discontinuing racing bikes? By how much would the company be better/worse off? Complete the analysis below to determine your answer.
Total if Racing Dropped
Sales
Variable manufacturing and selling expenses
Contribution margin
Fixed expenses:
Advertising, traceable
Depreciation of special equipment
Salaries of product-line managers
Allocated common fixed expenses*
Total fixed expenses
Net operating income (loss)
Per Unit
15,000 units per year
Direct Materials
$ 14 $ 210,000 Direct Labor
$ 10 $ 150,000 Variable Manufacturing Overhead
$ 3 $ 45,000 $ 6 $ 90,000 Fixed Manufacturing Overhead (general)
$ 9 $ 135,000 Total cost
$ 42 $ 630,000 * 1/3 supervisory salary, 2/3 depreciation of special equipment
Total for 15,000 units
15000
MAKE
BUY
MAKE
BUY
Cost of purchasing
$ 35 $ 525,000 Direct materials
$ 14 $ 210,000 Direct labor
$ 10 $ 150,000 VMOH
$ 3 $ 45,000 FMOH, traceable
$ 6 $ 90,000 FMOT, common
$ 9 $ 135,000 Total Costs
$ 42 $ 35 $ 630,000 $ 525,000 Make
Buy
Cost of Product
$ 630,000 $ 525,000 Opportunity Cost (foregone segment margin)
$ 150,000 Total Cost
$ 780,000 $ 525,000 Difference in favor of buying:
$ 255,000 Differential Analysis - Make vs. Buy
Troy Engines manufactures a variety of engines for use in heavy equipment. The company has always produced all the necessary parts for its engines, including the carburetors. An outside supplier has offered to sell Troy a carburetor for a cost of $35 per unit. To evaluate this offer, Troy has gathered the following information regarding its own cost of producing the carburetors internally.
Fixed Manufacturing Overhead (traceable)
*
Assuming that the company has no alternative use for the facilities that are now being used to produce the carburetors, should the outside supplier's offer be accepted? Show all computations.
Per Unit
Differential Costs
Suppose that if the carburetors were purchased, Troy could use the freed capacity to launch a new product. The segment margin of the new product would be $150,000 per year. Should Troy accept the offer to buy the carburetors for $35 per unit? Show all computations. Should the outside offer be accepted, given that there are no alternative uses for the facilities?
$
75
55
30
$
160
Required:
Per Unit
Total for 50 Coins
50
Incremental revenue $ 179 $ 8,950 Incremental costs:
Variable costs:
Direct materials $ 75 $ 3,750 Direct labor $ 55 $ 2,750 $ 30 $ 1,500 Special material
$ 2 $ 100 Total variable cost $ 162 $ 8,100 Fixed costs:
Purchase of special tool $ 350 Total incremental cost $ 8,450 Incremental net operating income $ 500 Sure if they want an extra $500
Differential Analysis - Special Order
Patriots Manufacturing is considering a special order for 50 hand-made gold coins for a customer. The normal selling price of a gold coin is $199 and its unit product cost is $160 as shown below:
Direct materials
Direct labor
Manufacturing overhead
Unit product cost
Most of the manufacturing overhead is fixed and unaffected by variations in how many coins are produced in any given period. However, $5 of the overhead is variable with respect to the number of coins produced. The customer who is interested in the gold coins would like special engraving applied to the coins. This engraving would require additional materials costing $2 per coin and would also require acquisition of a special engraving tool costing $350 that would have no other use once the special order is completed. This order would have no effect on the company’s regular sales and the order could be fulfilled using the company’s existing capacity without affecting any other order.
What effect would accepting this order have on the company’s net operating income if a special selling price of $179 per coin is offered for this order?
Variable manufacturing overhead
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
An engineer invests $10,000 a year for 20 years into a fund. At the end of the 20 years, how much
money is in the fund if the interest rate was 4% ? simple interest
A. $220,000
. B. $300,000
●
C. $240,000
D. $270,000
arrow_forward
e to search
☐
shaikh amir - Easy E...
Texas Department o
Inspectors Depart... A Does an MIS make i...
Question 10
What is the IRR of Project C if the outlay is $225,000 and the after-tax cash inflows for years one through four are: $45,000, $70,000, $80,000, and $105,000?
O 13.21%
O 12.90
11.00
O 11.80
O 13.53.
D
Question 11
What is the NPV of Project C?
$4,274.96
1,138.33
O3.891.33
2,884.34
O2.638.33
Question 12
Based on IRR. ABC should accept
all throe
only A and B
only A and C
only C
a
arrow_forward
An engineer invests $10,000 a year for 20 years into a fund. At the end of the 20 years, how much money is in the fund if the interest rate was 4%? simple interest
A. $220,000
B. $300,000
C. $240,000
D. $270,000
arrow_forward
i will 5 upvotes urgent
A firm wants to sponsor a new engineering lab at a local university. This requires $4.0M to construct the lab, $1.5M to equip it, and $750,000 every 6 years for new equipment. What is the required endowment if the university will earn 8% interest on the funds?
arrow_forward
Answer full question please thanks
arrow_forward
Edwards Center for GNP Accounting, a nonprofit organization, receives a letter from
a donor that includes a promise to donate $100,000 in the next fiscal year provided
the Center raise an equal amount of cash from other donors. What journal entry will
be recorded when the letter is received?
No journal entry would be recorded.
Debit cash $100,000; credit refundable advance $100,000
Debit pledge receivable $100,000; credit contribution revenue with donor
restrictions $100,000
Debit pledge receivable $100,000; credit contribution revenue without donor
restrictions $100,000
Debit pledge receivable $100,000; credit refundable advance $100,000
arrow_forward
Take Home Portion
Wishful Thinking (WT) School of Management is building a new facility on a piece of donated land. It received
a generous cash donation from a local business to support the project, and now needs to borrow additional
$10,000,000 to complete the project. Therefore WT School of Mgmt issued $10,000,000 of 6.00% 10-year
bonds. These bonds were issued on January 1, 20X1, and pay interest annually on each January 1. The bonds
yield 7.00%. WT School of Mgmt incurred $600,000 in bond issue costs related to the bond sale (round up the
calculation to the nearest dollar).
(a) Prepare the journal entry to record the issuance of the bonds and the related bond issue costs
incurred on January 1, 20X1
THE
(b) Prepare a bond amortization schedule up to and including January 1, 20X5, using the effective interest
method (
Date
Jan 1, X1
Interest
Paid
Interest
Expense
Disc/Prem
Amortization
Bond
Carrying
Value
Jan 1, X2
Jan 1, X3
Jan 1, X4
Jan 1, X5
2
(c) Assume that on July 1, 20X4, WT…
arrow_forward
None
arrow_forward
A9
arrow_forward
The City of Matlock issues $20,000,000 face value of general obligation bonds for $19,920,000. The bonds will be used for the construction of new streets and sidewalks to make downtown more walkable. The City incurred $100,000 in bond issue costs. What is the amount of expenditures that the City report in its Capital Projects Fund?
$108,000
$100,000
$8,000
$0
arrow_forward
Question 5 options:
A local Non for Profit had the following activity in October 2022:
Cash Donations $200,000
Unrestricted Pledges made during monthly phone a thon to solicit donations $15,000
Expected uncollectible pledges from monthly phone a thon to solicit donations $3,000
What is the correct amount of Contribution Revenue the non for profit should recognize in October 2022? (do not use $ signs, commas or decimals in your answer)
arrow_forward
Please help me
arrow_forward
Subject : Economy and Engineering Management
arrow_forward
18
Bruce is considering the purchase of a restaurant named Hard Rock Hollywood. With the help of his accountant, Bruce projects the net
cash flows (cash inflows less cash outflows) from the restaurant to be the following amounts over the next 10 years:
Years
1 to 6
7
8
9
10
Amount
$80,000 (each year)
90,000
100,000
110,000
120,000
Bruce expects to sell the restaurant after 10 years for an estimated $1,100,000. (EV of $1. PV of $1. FVA of $1. and PVA of $1) (Use
tables, Excel, or a financial calculator. Round your answer to 2 decimal places.)
Required:
1-a. Calculate the total present value of the net cash flows if Bruce wants to make at least 10% annually on his investment. (Assume all
cash flows occur at the end of each year. Be sure to include the selling price in your calculation.)
1-b. Assuming the restaurant is listed for sale at $1,050,000, should he purchase the restaurant?
Complete this question by entering your answers in the tabs below.
Reg 1A
Req 18
Calculate the total…
arrow_forward
Deakin University wants to establish a trust fund that will provide a perpetual annual scholarship of $15 000. It can invest the money at 11% per annum compounding. How much do they need to invest?
Select one:
a.
$136 363.64
b.
$140 500.50
c.
$125 506.35
d.
$130 340.75
arrow_forward
attached in SS below thanks for help
5kp3oy
35yo5p
5p
y5
5yo5k
arrow_forward
5
arrow_forward
9 Beavis Construction Company was the low bidder on a construction project to build an earthen dam for $1,750,000. The project was begun in 2023 and completed
in 2024. Cost and other data are presented below
2023
2024
cost incurred during the year
469,000 $
1,050,000
estimated cost to complete
871,000 $
billings during the year
480,000 $
1,270,000
cash collections during the year
380,000 $
1,370,000
Year
General Journal
Debit
Credit
Assume that Beavis recognizes revenue on this contract over time according to percentage of completion
Required:
a.
2023
a.
b.
Record the entry for costs incurred during the year 2023.
Record the entry for billings during the year 2023.
b.
2023
c.
d.
e.
f.
g.
Record the entry for cash collections during the year 2023.
Record the entry for revenue from long-term contracts.
Record the entry for costs incurred during the year 2024
Record the entry for billings during the year 2024
Record the entry for cash collections during the year 2024
C.
2023
d.
2023
e.…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- An engineer invests $10,000 a year for 20 years into a fund. At the end of the 20 years, how much money is in the fund if the interest rate was 4% ? simple interest A. $220,000 . B. $300,000 ● C. $240,000 D. $270,000arrow_forwarde to search ☐ shaikh amir - Easy E... Texas Department o Inspectors Depart... A Does an MIS make i... Question 10 What is the IRR of Project C if the outlay is $225,000 and the after-tax cash inflows for years one through four are: $45,000, $70,000, $80,000, and $105,000? O 13.21% O 12.90 11.00 O 11.80 O 13.53. D Question 11 What is the NPV of Project C? $4,274.96 1,138.33 O3.891.33 2,884.34 O2.638.33 Question 12 Based on IRR. ABC should accept all throe only A and B only A and C only C aarrow_forwardAn engineer invests $10,000 a year for 20 years into a fund. At the end of the 20 years, how much money is in the fund if the interest rate was 4%? simple interest A. $220,000 B. $300,000 C. $240,000 D. $270,000arrow_forward
- i will 5 upvotes urgent A firm wants to sponsor a new engineering lab at a local university. This requires $4.0M to construct the lab, $1.5M to equip it, and $750,000 every 6 years for new equipment. What is the required endowment if the university will earn 8% interest on the funds?arrow_forwardAnswer full question please thanksarrow_forwardEdwards Center for GNP Accounting, a nonprofit organization, receives a letter from a donor that includes a promise to donate $100,000 in the next fiscal year provided the Center raise an equal amount of cash from other donors. What journal entry will be recorded when the letter is received? No journal entry would be recorded. Debit cash $100,000; credit refundable advance $100,000 Debit pledge receivable $100,000; credit contribution revenue with donor restrictions $100,000 Debit pledge receivable $100,000; credit contribution revenue without donor restrictions $100,000 Debit pledge receivable $100,000; credit refundable advance $100,000arrow_forward
- Take Home Portion Wishful Thinking (WT) School of Management is building a new facility on a piece of donated land. It received a generous cash donation from a local business to support the project, and now needs to borrow additional $10,000,000 to complete the project. Therefore WT School of Mgmt issued $10,000,000 of 6.00% 10-year bonds. These bonds were issued on January 1, 20X1, and pay interest annually on each January 1. The bonds yield 7.00%. WT School of Mgmt incurred $600,000 in bond issue costs related to the bond sale (round up the calculation to the nearest dollar). (a) Prepare the journal entry to record the issuance of the bonds and the related bond issue costs incurred on January 1, 20X1 THE (b) Prepare a bond amortization schedule up to and including January 1, 20X5, using the effective interest method ( Date Jan 1, X1 Interest Paid Interest Expense Disc/Prem Amortization Bond Carrying Value Jan 1, X2 Jan 1, X3 Jan 1, X4 Jan 1, X5 2 (c) Assume that on July 1, 20X4, WT…arrow_forwardNonearrow_forwardA9arrow_forward
- The City of Matlock issues $20,000,000 face value of general obligation bonds for $19,920,000. The bonds will be used for the construction of new streets and sidewalks to make downtown more walkable. The City incurred $100,000 in bond issue costs. What is the amount of expenditures that the City report in its Capital Projects Fund? $108,000 $100,000 $8,000 $0arrow_forwardQuestion 5 options: A local Non for Profit had the following activity in October 2022: Cash Donations $200,000 Unrestricted Pledges made during monthly phone a thon to solicit donations $15,000 Expected uncollectible pledges from monthly phone a thon to solicit donations $3,000 What is the correct amount of Contribution Revenue the non for profit should recognize in October 2022? (do not use $ signs, commas or decimals in your answer)arrow_forwardPlease help mearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning