The accounting department needs to forecast the profit for a subsidiary. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is exponential smoothing with trend accounting for seasonality given a smoothing constant (alpha) of 0.69, a trend smoothing constant (delta) of 0.3, a previous trend amount, seasonally adjusted, of 65, and a previous seasonal forecast of 582. Please round your forecast to the nearest whole number.
| Jul 2020: 544 | Jun 2020: 274 | May 2020: -1684 | Apr 2020: 1439 | Mar 2020: 970 | Feb 2020: -1689 |
| Jan 2020: 340 | Dec 2019: 253 | Nov 2019: 1631 | Oct 2019: 257 | Sep 2019: -660 | Aug 2019: 582 |
| Jul 2019: 2258 | Jun 2019: 945 | May 2019: 2580 | Apr 2019: 704 | Mar 2019: -1884 | Feb 2019: 1902 |
| Jan 2019: 1477 | Dec 2018: 2141 | Nov 2018: -778 | Oct 2018: 1609 | Sep 2018: -1625 | Aug 2018: 1187 |
| Jul 2018: 2959 | Jun 2018: -653 | May 2018: -16 | Apr 2018: 2132 | Mar 2018: -979 |
In: Operations Management
As of December 31, 2020 Big USA Company owns a foreign subsidiary (Taco) based in Mexico. Big is in the process of preparing consolidated financial statements and must translate the trial balance of Taco to U.S. Dollars. Selected financial information of Taco in pesos is presented below.
Pesos
Inventory 12/31/20 300,000
Purchases in 2020 2,600,000
Inventory 12/31/19 420,000
Equipment purchased as follows
1/1/18 250,000
Purchases during 2018 150,000
Purchases during 2019 350,000
Purchases during 2020 620,000
All equipment is depreciated over 8 years on a straight-line basis with a full year taken in year of acquisition.
The inventory turnover rate is 90 days.
Relevant Exchange Rates Pesos per dollar
1/1/18 8.0
Average Rates 2018 8.5
Average Rate 2019 9.3
Average Rate 2020 9.8
Rate 4th quarter 2019 8.9
Rate 4th quarter 2020 9.6
Current rate 12/31/18 8.9
Current Rate 12/31/19 9.2
Current Rate 12/31/20 9.9
REQUIRED (In US Dollars)
Cost Goods Sold for 2020
Balance in Equipment 12/31/20
Balance in Accumulated Depreciation 12/31/20
Depreciation Expense – 2020
Cost Goods Sold for 2020
Balance in Equipment 12/31/20
Balance in Accumulated Depreciation 12/31/20
Depreciation Expense – 2020
In: Accounting
Aykroyd Inc. has sponsored a noncontributory, defined benefit pension plan for its employees since 1997. Prior to 2020, cumulative net pension expense recognized equaled cumulative contributions to the plan.Other relevant information about the pension plan on January 1, 2020, is as follows:1.The company has 200 employees. All these employees are expected to receive benefits under the plan. The average remaining service life per employee is 12 years.2.The projected benefit obligation amounted to $5,000,000 and the fair value of pension plan assets was $3,000,000. The market-related asset value was also $3,000,000. Unrecognized prior service cost was $2,000,000. On December 31, 2020, the projected benefit obligation and the accumulated benefit obligation were $4,850,000 and $4,025,000, respectively. The fair value of the pension plan assets amounted to $4,100,000 at the end of the year. A 10% settlement rate and a 10% expected asset return rate were used in the actuarial present value computations in the pension plan. The present value of benefits attributed by the pension benefit formula to employee service in 2020 amounted to $200,000. The employer's contribution to the plan assets amounted to $775,000 in 2020. This problem assumes no payment of pension benefits. Instructions (Round all amounts to the nearest dollar.)
| Compute the amount of the 2020 increase/decrease in net gains or losses and the amount to be amortized in 2020 and 2021. | |||||
| Year | PBO | FV of Plan Assets | Corridor | Accumulate OCI | Amortization |
| 2020 | |||||
| 2021 | |||||
| d. | |||||
| Prepare the journal entries required to report the accounting for the company's pension plan for 2020. | |||||
| Account title and explanation | Debit | Credit | |||
| Pension expense | |||||
| pension asset/liability | |||||
| Other comprehensive income (G/L) | |||||
| Other comprehensive income (PSC) | |||||
| Cash | |||||
In: Accounting
ABC Ltd., has been facing cash shortage problem for many years. You have just joined the company and made the proposal to prepare cash budget for controlling of cash shortage problem. Management has given you the green signal to prepare the cash budget and made the projection for requirement of cash through commercial bank channel in the coming period. The following information were gathered for preparing the cash budget.
November, 2019…………………………. Rs.200,000
December, 2019…………………………… 300,000
January, 2020…………………………….. 400,000
February, 2020…………………………… 500,000
March, 2020……………………………….. 600,000
All sales are made on credit basis and customers follow the following patter to pay;
Required: Prepare a cash budget for the month of January, February, March, 2020.
In: Accounting
Required: Prepare journal entries for each of the following transactions under the Perpetual Inventory method—include recording date and all required revenue, expense and balance sheet accounts. The Widget Company sells only one product (widgets) and uses FIFO. December 31, 2019 inventory is as follows:
|
Date purchased |
Quantity |
Unit cost |
|
December 5, 2019 |
1,500 |
$5.34 |
|
December 20, 2019 |
700 |
$5.48 |
|
December 28, 2019 |
500 |
$5.40 |
In: Accounting
Based on Problem 10-6
Indigo Landscaping began construction of a new plant on December
1, 2020. On this date, the company purchased a parcel of land for
$147,600 in cash. In addition, it paid $3,120 in surveying costs
and $4,080 for a title insurance policy. An old dwelling on the
premises was demolished at a cost of $3,120, with $960 being
received from the sale of materials.
Architectural plans were also formalized on December 1, 2020, when
the architect was paid $34,800. The necessary building permits
costing $3,120 were obtained from the city and paid for on December
1 as well. The excavation work began during the first week in
December with payments made to the contractor in 2021 as
follows.
| Date of Payment | Amount of Payment | |
| March 1 | $248,400 | |
| May 1 | 340,800 | |
| July 1 | 61,200 |
Compute the balance in each of the following accounts at
December 31, 2020, and December 31, 2021.
To finance construction of this plant, Indigo borrowed $602,400
from the bank on December 1, 2020. Indigo had no other borrowings.
The $602,400 was a 10-year loan bearing interest at 9%.
The building was completed on July 1, 2021.
Using Excel calculate the following (show your work and use formulas where appropriate):
In: Accounting
Problem 4
As of December 31, 2020 Big USA Company owns a foreign subsidiary (Taco) based in Mexico. Big is in the process of preparing consolidated financial statements and must translate the trial balance of Taco to U.S. Dollars. Selected financial information of Taco in pesos is presented below.
Pesos
Inventory 12/31/20 300,000
Purchases in 2020 2,600,000
Inventory 12/31/19 420,000
Equipment purchased as follows
1/1/18 250,000
Purchases during 2018 150,000
Purchases during 2019 350,000
Purchases during 2020 620,000
All equipment is depreciated over 8 years on a straight-line basis with a full year taken in year of acquisition.
The inventory turnover rate is 90 days.
Relevant Exchange Rates Pesos per dollar
1/1/18 8.0
Average Rates 2018 8.5
Average Rate 2019 9.3
Average Rate 2020 9.8
Rate 4thquarter 2019 8.9
Rate 4thquarter 2020 9.6
Current rate 12/31/18 8.9
Current Rate 12/31/19 9.2
Current Rate 12/31/20 9.9
REQUIRED (In US Dollars)
Cost Goods Sold for 2020
Balance in Equipment 12/31/20
Balance in Accumulated Depreciation 12/31/20
Depreciation Expense – 2020
Cost Goods Sold for 2020
Balance in Equipment 12/31/20
Balance in Accumulated Depreciation 12/31/20
Depreciation Expense – 2020
In: Accounting
The number of hours per week that the television is turned on is determined for each family in a sample. The mean of the data is 3535 hours and the median is 31.231.2 hours. Twenty-four of the families in the sample turned on the television for 2020 hours or less for the week. The 6th percentile of the data is 2020 hours.
Step 2 of 5:
Approximately how many families are in the sample? Round your answer to the nearest integer.
The number of hours per week that the television is turned on is determined for each family in a sample. The mean of the data is 3535 hours and the median is 31.231.2 hours. Twenty-four of the families in the sample turned on the television for 2020 hours or less for the week. The 6th percentile of the data is 2020 hours.
Step 3 of 5:
Based on the given information, determine if the following statement is true or false.
Approximately 200200 families turned on their televisions for less than 3535 hours.
The number of hours per week that the television is turned on is determined for each family in a sample. The mean of the data is 3535 hours and the median is 31.231.2 hours. Twenty-four of the families in the sample turned on the television for 2020 hours or less for the week. The 6th percentile of the data is 2020 hours.
Step 4 of 5:
What is the value of the 50th percentile?
The number of hours per week that the television is turned on is determined for each family in a sample. The mean of the data is 3535 hours and the median is 31.231.2 hours. Twenty-four of the families in the sample turned on the television for 2020 hours or less for the week. The 6th percentile of the data is 2020 hours.
Step 5 of 5:
Based on the given information, determine if the following statement is true or false.
The first quartile is less than 2020 hours.
In: Statistics and Probability
23-
At a certain temperature, the Kp for the decomposition of H2S is 0.820.
H2S(g)<--->H2(g)+S(g)
Initially, only H2S is present at a pressure of 0.112 atm in a closed container. What is the total pressure in the container at equilibrium?
_____atm
In: Chemistry
A closed, rigid, 0.40 m3 tank is filled with 15 kg of
water. The initial pressure is p1 = 20 bar. The
water is cooled until the pressure is p2= 4
bar.
Determine the initial quality, x1, and the heat
transfer, in kJ.
In: Mechanical Engineering