In: Accounting
1. The Revenue Operations team (RevOps) provides system requirements to the Finance Engineering team (FinEng) when any change to the revenue accounting systems is needed. Examples of these changes include launching new products and features, modifications, and/or accounting policy changes. FinEng's role is to deploy the requirements within the revenue accounting systems. Once FinEng deploys the requirements in the systems, RevOps completes User Acceptance Testing (UAT) to ensure the changes to the system are performing as expected. When performing UAT, what factors would you consider?
In: Accounting
Below are purchases and sales for Hector retail company for the year 2020.
January 1 purchased 10 UNITS at $20 each
January 2 purchased 20 UNITS at $25 each
January 3 purchased 20 UNITS at $ 30 each
January 4 Sold 25 UNITS at $ 50 each
(A)
USING FIRST IN FIRST OUT METHOD (FIFO) DETERMINE THE FOLLOWING:
A,.COST OF GOOS SOLD
B. COST OF ENDING INVENTORY
C. GROSS PROFIT
(B)
USING LAST IN FIRST OUT METHOD (LIFO)
In: Accounting
1)
Teddy Bear company sold a total of 30,000 stuffed tigers and lions. During August the following information
Tigers Lions
Actual Sell price 7.50 10.50
Budget Sell Price 5.50 10.50
Actual Sales Mix 69% 31%
Budget Sale Mix 75% 25%
Actual Variable costs 5.00 6.50
Budget Variable Cost 4.75 7.25
Budget unit sales 30,00 10,000
What is the total Sales mix Variance?
a) 21,600 favourable
b) 13,750 favourable
c) 4,500 favourable
d) 13,750 unfavourable
e) 4,500 unfavourable
2)
Teddy Bear company sold a total of 30,000 stuffed tigers and lions. During August the following information
Tigers Lions
Actual Sell price 7.50 10.50
Budget Sell Price 5.50 10.50
Actual Sales Mix 69% 31%
Budget Sale Mix 75% 25%
Actual Variable costs 5.00 6.50
Budget Variable Cost 4.75 7.25
Budget unit sales 30,00 10,000
What is the total sales quantity variance?
a) 21,600 favourable
b) 13,750 favourable
c) 4,500 favourable
d) 13,750 unfavourable
e) 4,500 unfavourable
In: Accounting
General Fabricators assembles its product in two departments. It has two departments that process all units: Cutting and Finishing. During October, Cutting department allocated a total cost of $75,000 to units that were finished in the cutting process and transferred to the finishing process.
In October, beginning work in process in the finishing department was 75% complete as to conversion. Direct materials are added at the end of the finishing process. Conversion costs are added evenly in the finishing process. Beginning inventories in finishing department included $9,000 for transferred-in costs and $20,000 for conversion costs. Ending inventory in finishing department was 30% complete. Additional information about the departments in October follows:
Finishing |
|
Beginning WIP units |
20,000 |
Units started this period |
50,000 |
Units transferred this period |
50,000 |
Ending WIP units |
20,000 |
Materials costs added |
$28,000 |
Direct Manufacturing Labor added |
$40,000 |
Other Conversion costs added |
$24,000 |
Required:
1. Determine a) the amount of ending WIP, b) the amount of transferred- out cost (credit amount), usingWeighted Averagefor the finishing department.
In: Accounting
Question 2 (Total: 26 marks)
Cavendish Cheese Company
makes three products within their single facility. Data concerning these products follow:
Products |
|||
A |
B |
C |
|
Selling price per unit |
$67.90 |
$57.70 |
$43.90 |
Direct materials |
$12.10 |
$10.30 |
$8.60 |
Direct labour |
$14.10 |
$8.00 |
$6.80 |
Variable manufacturing overhead |
$2.60 |
$2.20 |
$1.80 |
Variable selling cost per unit |
$2.50 |
$2.20 |
$2.50 |
Mixing minutes per unit |
2.70 |
3.30 |
4.70 |
Monthly demand in units |
1,000 |
3,000 |
3,000 |
The mixing machines are potentially a constraint in the production facility. A total of 25,800 minutes are available per month on these machines.
Direct labour is a variable cost in this company.
Required:
In: Accounting
Pittman Company is a small but growing manufacturer of telecommunications equipment. The company has no sales force of its own; rather, it relies completely on independent sales agents to market its products. These agents are paid a sales commission of 15% for all items sold. Barbara Cheney, Pittman’s controller, has just prepared the company’s budgeted income statement for next year as follows: Pittman Company Budgeted Income Statement For the Year Ended December 31 Sales $ 25,000,000 Manufacturing expenses: Variable $ 11,250,000 Fixed overhead 3,500,000 14,750,000 Gross margin 10,250,000 Selling and administrative expenses: Commissions to agents 3,750,000 Fixed marketing expenses 175,000 * Fixed administrative expenses 2,160,000 6,085,000 Net operating income 4,165,000 Fixed interest expenses 875,000 Income before income taxes 3,290,000 Income taxes (30%) 987,000 Net income $ 2,303,000 *Primarily depreciation on storage facilities. As Barbara handed the statement to Karl Vecci, Pittman’s president, she commented, “I went ahead and used the agents’ 15% commission rate in completing these statements, but we’ve just learned that they refuse to handle our products next year unless we increase the commission rate to 20%.” “That’s the last straw,” Karl replied angrily. “Those agents have been demanding more and more, and this time they’ve gone too far. How can they possibly defend a 20% commission rate?” “They claim that after paying for advertising, travel, and the other costs of promotion, there’s nothing left over for profit,” replied Barbara. “I say it’s just plain robbery,” retorted Karl. “And I also say it’s time we dumped those guys and got our own sales force. Can you get your people to work up some cost figures for us to look at?” “We’ve already worked them up,” said Barbara. “Several companies we know about pay a 7.5% commission to their own salespeople, along with a small salary. Of course, we would have to handle all promotion costs, too. We figure our fixed expenses would increase by $3,750,000 per year, but that would be more than offset by the $5,000,000 (20% × $25,000,000) that we would avoid on agents’ commissions.” The breakdown of the $3,750,000 cost follows: Salaries: Sales manager $ 156,250 Salespersons 937,500 Travel and entertainment 625,000 Advertising 2,031,250 Total $ 3,750,000 “Super,” replied Karl. “And I noticed that the $3,750,000 equals what we’re paying the agents under the old 15% commission rate.” “It’s even better than that,” explained Barbara. “We can actually save $115,000 a year because that’s what we’re paying our auditors to check out the agents’ reports. So our overall administrative expenses would be less.” “Pull all of these numbers together and we’ll show them to the executive committee tomorrow,” said Karl. “With the approval of the committee, we can move on the matter immediately.” Required: 1. Compute Pittman Company’s break-even point in dollar sales for next year assuming: a. The agents’ commission rate remains unchanged at 15%. b. The agents’ commission rate is increased to 20%. c. The company employs its own sales force. 2. Assume that Pittman Company decides to continue selling through agents and pays the 20% commission rate. Determine the dollar sales that would be required to generate the same net income as contained in the budgeted income statement for next year. 3. Determine the dollar sales at which net income would be equal regardless of whether Pittman Company sells through agents (at a 20% commission rate) or employs its own sales force. 4. Compute the degree of operating leverage that the company would expect to have at the end of next year assuming: a. The agents’ commission rate remains unchanged at 15%. b. The agents’ commission rate is increased to 20%. c. The company employs its own sales force. Use income before income taxes in your operating leverage computation. Determine the dollar sales at which net income would be equal regardless of whether Pittman Company sells through agents (at a 20% commission rate) or employs its own sales force. (Do not round intermediate calculations.)
In: Accounting
24. Taylor Trucking is considering purchasing a new truck. It is expected the truck will increase annual revenues by $31,000 and increase annual expenses by $19,800 including depreciation. The truck will cost $110,000 and will have a $2,000 salvage value at the end of its useful life. Compute the annual rate of return.
20%
20.7%
10%
10.2%
23. Evergreen Co. is contemplating the purchase of a new machine that has expected annual net cash inflows of $25,000 over its 3 year life. The net present value of the investment is $3,275; assuming a 9% discount rate. The present value factors from the present value of 1 table and the present value of an annuity table are .772 and 2.531, respectively. Compute the profitability index.
1.15
1.05
0.77
1.19
18. If an asset costs $250000 and is expected to have a $50000 salvage value at the end of its 10-year life, and generates annual net cash inflows of $50000 each year, the cash payback period is
6 years.
5 years.
3 years.
4 years.
11. SwiftyCompany is considering two capital investment
proposals. Estimates regarding each project are provided
below:
Project Soup | Project Nuts | |
Initial investment | $400000 | $600000 |
Annual net income | 12000 | 28000 |
Net annual cash inflow | 90000 | 113000 |
Estimated useful life | 5 years | 6 years |
Salvage value | 0 | 0 |
The company requires a 10% rate of return on all new
investments.
Present Value of an Annuity of 1 | ||||
Periods | 9% | 10% | 11% | 12% |
5 | 3.89 | 3.791 | 3.696 | 3.605 |
6 | 4.486 | 4.355 | 4.231 | 4.111 |
The annual rate of return for Project Soup is
3.0%.
22.5%.
45%.
6%.
12. Use the following table,
Present Value of an Annuity of 1 | |||
Period | 8% | 9% | 10% |
1 | 0.926 | 0.917 | 0.909 |
2 | 1.783 | 1.759 | 1.736 |
3 | 2.577 | 2.531 | 2.487 |
A company has a minimum required rate of return of 8%. It is
considering investing in a project that costs $349278 and is
expected to generate cash inflows of $138000 each year for three
years. The approximate internal rate of return on this project
is
9%.
10%.
8%.
the IRR on this project cannot be approximated.
In: Accounting
Financial Analysis Project
Requirements:
You will use the Financial Statements for
Coke
and
Pepsi
as provided on their websites to
complete the following analysis:
1.
Calculate the current ratio and quick ratio for both companies for 2016 and 2017. Write
a paragraph describing what these ratios indicate about the liquidity of Pepsi and Coke
in 2016 compared to 2017. Write a paragraph describing what these ratios indicate
about the liquidity of Pepsi compared to Coke for both years. Which company seems to
be more liquid? What are the advantages and disadvantages of liquidity?
2.
Calculate the accounts receivable turnover and days sales in receivables for both
companies for 2016 and 2017. Write a paragraph comparing 2016 with 2017 and Coke
with Pepsi using these two ratios to indicate the effectiveness of their accounts
receivable collection. Which of the two seems to be doing a better job with receivables?
How does this collection process affect the overall success of the company.
3.
Calculate inventory turnover and days in inventory for both companies for 2016 and
2017. Write a paragraph comparing 2016 with 2017 and Coke with Pepsi using these
two ratios to indicate how they manage their inventory. Which one of the two companies
has a better approach to inventory management? Why? What are the problems that
come with poor inventory management?
4.
Calculate the gross margin, profit margin and return on investment for both companies
for 2016 and 2017. Explain in a paragraph what these ratios show about each
company’s profitability compared to the year before and compared to each other.
Indicate which company shows the best prospects for future profits and explain in detail
why you think the ratios support your observation.
5.
Prepare a vertical analysis or same size income statement and balance sheet for Pepsi
and Coca Cola for 2016 and 2017. Write a paragraph highlighting what you learn from
the percentages of sales or total assets calculated from the financial statements. Write
also about the comparison between 2016 and 2017 and between Coke and Pepsi.
6.
Compare Pepsi’s income statement for 2016 with their income statement for 2017 –
calculate the change in dollars and percent for all of the revenues and expenses. What
do the changes indicate about Pepsi’s success in 2016 relative to 2017? Do the same
comparison for Coke’s income statement. What do the changes indicate about Coke’s
improvement or lack thereof between 2016 and 2017? With this comparison of both
companies over time now compare Coke vs. Pepsi and explain why one company is
better than the other.
7.
Based on all of your calculations and observations described above, make a
recommendation as to which company would be a better investment. Give the reasons
for your conclusion.
In: Accounting
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account):
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
Budgeted unit sales | 11,700 | 12,700 | 14,700 | 13,700 |
The selling price of the company’s product is $16 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in the first quarter, is $71,600.
The company expects to start the first quarter with 1,755 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 15% of the next quarter’s budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,955 units.
Required:
1. a.Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole.
b. Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole.
c. Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole.
In: Accounting
U.S. GAAP and International Financial Reporting Standards have largely similar guidance for accounting for business combinations. Under IFRS, the guidance is established in IFRS 3R, Business Combinations. One topic on which U.S. and IFRS differ is with respect to reporting noncontrolling interest for noncontrolling interest in consolidated financial statements.
Required
Briefly, i.e. no more than 3 paragraphs, explain the difference between IFRS and U.S. GAAP regarding valuation of noncontrolling interest in a consolidated financial statement.
In: Accounting
Cho Co. includes one coupon in each box of cereal it sells. In return for 5 coupons and $1, customers receive a Cho branded spoon that the company purchases for $2 each. Cho's experience indicates that 40 percent of the coupons will be redeemed. During 2019, 200,000 boxes of cereal were sold, 20,000 spoons were purchased, and 55,000 coupons were redeemed. During 2020, 280,000 boxes of cereal were sold, 25,000 spoons were purchased, and 90,000 coupons were redeemed. The premium payable account balance at the beginning of the 2019 fiscal year was $8,000. Determine the premium expense reported in the income statement and the ending premium liability balance reported in the balance sheet for 2019 and 2020.
2019 Premium Expense: $
2019 Ending Premium Liability: $
2020 Premium Expense: $
2020 Ending Premium Liability: $
In: Accounting
Activity-Based Costing for a Service Company
Crosswinds Hospital plans to use activity-based costing to
assign hospital indirect costs to the care of patients. The
hospital has identified the following activities and activity rates
for the hospital indirect costs:
Activity | Activity Rate | |
Room and meals | $240 | per day |
Radiology | $215 | per image |
Pharmacy | $50 | per physician order |
Chemistry lab | $80 | per test |
Operating room | $1,000 | per operating room hour |
The activity usage information associated with the two patients
is as follows:
Abel Putin | Cheryl Umit | |||
Number of days | 6 days | 4 days | ||
Number of images | 4 images | 3 images | ||
Number of physician orders | 6 orders | 2 orders | ||
Number of tests | 5 tests | 4 tests | ||
Number of operating room hours | 8 hours | 4 hours |
a. Determine the activity cost associated with each patient.
Abel Putin | $ |
Cheryl Umit | $ |
b. Why is the total activity cost different for the two patients?
Abel Putin apparently had a different condition that required more extensive treatment. Thus, the activity cost to Abel Putin is nearly two times that of other patient.
In: Accounting
Can someone please explain to me the steps in journalizing events in accounting and then turning them into income statements. Like which assets and liabilities are credits and which are debits?
In: Accounting
Required information
Problem 9-1B Record and analyze installment notes (LO9-2)
Skip to question
[The following information applies to the questions
displayed below.]
On January 1, 2021, Stoops Entertainment purchases a building for $610,000, paying $110,000 down and borrowing the remaining $500,000, signing a 9%, 15-year mortgage. Installment payments of $5,071.33 are due at the end of each month, with the first payment due on January 31, 2021.
Problem 9-1B Part 3
3-a. Record the first monthly mortgage payment on January 31, 2021. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field. Do not round intermediate calculations. Round your final answers to 2 decimal places.)
Journal entry worksheet
Note: Enter debits before credits.
|
3-b. How much of the first payment goes to interest expense and how much goes to reducing the carrying value of the loan? (Round your answers to 2 decimal places.)
|
4. Total payments over the 15 years are $912,839 ($5,071.33 × 180 monthly payments). How much of this is interest expense and how much is actual payment of the loan?
|
In: Accounting