The purchasing and supply department needs to forecast the number of tubes of adhesive being ordered. 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 accounting for seasonality with a smoothing constant of 0.35 and a previous forecast (with seasonality) of 635. Please round your forecast to the nearest whole number.
| Jul 2020: 588 | Jun 2020: 508 | May 2020: 689 | Apr 2020: 500 | Mar 2020: 689 | Feb 2020: 540 |
| Jan 2020: 568 | Dec 2019: 680 | Nov 2019: 695 | Oct 2019: 565 | Sep 2019: 680 | Aug 2019: 514 |
| Jul 2019: 696 | Jun 2019: 516 | May 2019: 629 | Apr 2019: 671 | Mar 2019: 686 | Feb 2019: 506 |
| Jan 2019: 589 | Dec 2018: 555 | Nov 2018: 605 | Oct 2018: 538 | Sep 2018: 607 | Aug 2018: 540 |
| Jul 2018: 650 | Jun 2018: 599 | May 2018: 528 | Apr 2018: 681 | Mar 2018: 679 | Feb 2018: 535 |
| Jan 2018: 587 | Dec 2017: 566 |
In: Statistics and Probability
On January 1, 2020, Lawrence Co. began construction of
a building to be used as its office headquarters. The building is
expected to be completed on December 31, 2020. Expenditures on this
project during 2020 were as follows:
January 1st $
160,000
March
1st
420,000
June
1st
270,000
October
31st
165,000
On Jan. 1, 2020, the company obtained a $600,000 specific
construction loan with a 7% interest rate. The loan was outstanding
during the entire construction period. The company’s other
interest-bearing debts included two long-term notes of $480,000 and
$900,000 with interest rates of 10% and 11%, respectively. Both
notes were outstanding during the entire construction period.
Instruction:
(a) Determine the amount of interest capitalized for 2020. Please
show your work (i.e. the weighted average accumulated expenditure,
the actual interest, the weighted average interest rate, and the
avoidable interest) to support your final answer. Please round the
WA interest rate to four decimal places when
necessary.
Answer: The amount of interest
capitalized for 2020
is
.
(b) Regardless your answer in (a), determine the amount of
avoidable interest for 2020 assuming that the weighted average
accumulated expenditure is $534,000 (other things being
equal).
In: Accounting
The Eserine Wood Corporation manufactures desks. Most of the company’s desks are standard models that are sold at catalogue prices. At December 31, 2020, the following finished desks appear in the company’s inventory:
| Finished Desks | Type A | Type B | Type C | Type D | |||||||||
| 2020 catalogue selling price | $460 | $490 | $890 | $1,040 | |||||||||
| FIFO cost per inventory list, Dec. 31, 2020 | 410 | 450 | 830 | 960 | |||||||||
| Estimated current cost to manufacture (at Dec. 31, 2020, and early 2021) |
460 | 440 | 790 | 1,000 | |||||||||
| Sales commissions and estimated other costs of disposal | 40 | 65 | 95 | 130 | |||||||||
| 2021 catalogue selling price | 575 | 650 | 780 | 1,420 | |||||||||
| Quantity on hand | 15 | 117 | 113 | 110 | |||||||||
The 2020 catalogue was in effect through November 2020, and the
2021 catalogue is effective as of December 1, 2020. All catalogue
prices are net of the usual discounts. Generally, the company tries
to obtain a 20% gross margin on the selling price and it has
usually been successful in achieving this.
a) Explain the rationale for using the lower of cost and net realizable rule for inventories.
b) Explain the impact if inventory was valued at lower of cost and net realizable value on a total basis.
In: Accounting
David Wong, the product manager of KiKi Company, was reviewing the production schedule for the last quarter of 2020. He noted that the company planned to sell 4,000 units during the year and keep a minimum closing inventory level at 100 units on 31 December 2020. As at 30 September 2020, the following data was reported.
Units
Inventory, 1 January 2020 0
Production 3,000
Sales 2,700
Inventory, 30 September 2020 300
At the beginning of the year, the company rented a warehouse that could store its inventory up to 1,250 units. The company had a maximum production capacity of 2,300 units per quarter.
Required:
(a) Assume that KiKi Company adopted marginal costing,
(i) what is the minimum units that the company should produce
during the last quarter of 2020?
(ii) will the number of units produced affect the company’s profit or loss for the year? Explain.
(b) Assume that the company adopted absorption costing and David was given an annual bonus based on the company’s reported profit. If David wanted to maximize his bonus in 2020, how many units would he produce? Explain.
(c) Advise the management of the company on the costing method that should be chosen to determine David’s bonus?
In: Accounting
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
Use the data in the following table for the next seven questions. Note that "%∆" is shorthand for "percentage change." If the answer is a percentage, please just enter the number. Thus, say an answer of yours is 3.5%, then below you would enter "3.5" (without the quotes) in the box below. Be careful not to include the percent symbol. Also, please use just one decimal place.
| year | real GDP (trillions) | nominal GDP (trillions) | CPI | %∆CPI from the previous year | nominal price of 1 apple | mortgage interest rate |
| 1990 | $14.80 | $12.10 | 130 | 4.0% | $0.50 | 8% |
| 2000 | $16.60 | $16.40 | 205 | 1.5% | $0.60 | 5% |
| 2010 | $18.20 | $19.75 | 230 | 2.0% | $0.75 | 6% |
| 2019 | $20.00 | $22.00 | 250 | 3.5% | $0.95 | 7% |
| 2020 | $20.40 | $22.85 | 260 | 4.0% | $1.00 | 6% |
Q1: Is the rate of inflation for consumers from 2019 to 2020 correct? Yes or NO
What was the rate of economic growth from 2019 to 2020? (As in the directions above, just enter the percent number, such as 3.5 for 3.5%).
What was the inflation rate for the entire economy from 2019 to 2020?
Q2: What was the real interest rate for a consumer purchasing a house in 2020? They'll be taking out a home loan, often called a mortgage.
Please convert the nominal price for an apple from 1990 to the prices of 2020. Assume that a consumer purchases it.
What was the percentage change in the real price of apples from 2019 to 2020 for consumers?
Deflate the nominal price of apples from 2020 for consumers (that is, convert the 2020 nominal price to the base year of the CPI). Please use two decimal place for this answer.
In: Economics
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