Exercise 8-14 Sales and Production Budgets [LO8-2, LO8-3]
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 | 12,500 | 13,500 | 15,500 | 14,500 |
The selling price of the company’s product is $24 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 $73,200.
The company expects to start the first quarter with 2,500 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter’s budgeted sales. The desired ending finished goods inventory for the fourth quarter is 2,700 units.
Required:
1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole.
2. Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole.
3. Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole.
Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole.
|
Requirement 2
|
Requirement 3
|
In: Accounting
Technoid Inc. sells computer systems. Technoid leases computers to Lone Star Company on January 1, 2018. The manufacturing cost of the computers was $19 million.
This non-cancelable lease had the following terms:
1.) Lease payments: 3,287,947 semiannually, first payment at January 1, 2018; remaining payments at June 30 and December 31 each year through June 30, 2022
2.) Lease term: 5 years (10 semi-annual payments)
3.) No residual value; no purchase option
4.) Economic Life of equipment: 5 years
5.) Implicit interest rate and lessee's incremental borrowing rate: 9% semiannually
6.) Fair Value of the computers at January 1, 2018: $23 million
What is the interest revenue that Technoid would report for this lease in its 2018 income statement?
In: Accounting
_______5.
Happy Days, Inc.
Comparative Balance Sheet
June 30, 2019 and 2018
|
Assets |
Increase (Decrease) |
|||
|
2018 |
2017 |
Amount |
Percent |
|
|
Current assets |
$256,000 |
$190,000 |
||
|
Property, plant, and equipment |
428,000 |
405,000 |
||
|
Intangible assets |
24,000 |
32,000 |
||
|
Total Assets |
$708,000 |
$81,000 |
12.9% |
|
|
Liabilities |
||||
|
Current liabilities |
$81,000 |
$89,000 |
||
|
Long-term liabilities |
235,000 |
275,000 |
||
|
Total Liabilities |
$316,000 |
$(48,000) |
(13.2%) |
|
|
Stockholders’ Equity |
||||
|
Common stock |
$276,000 |
$210,000 |
||
|
Retained earnings |
116,000 |
53,000 |
||
|
Total Stockholders’ Equity |
$392,000 |
$129,000 |
49.0% |
|
|
Total Liabilities & Stockholders’ Equity |
$708,000 |
$81,000 |
12.9% |
|
In: Accounting
Prepare journal entries to record the following merchandising transactions of Lowe’s, which uses the perpetual inventory system and the gross method. (Hint: It will help to identify each receivable and payable; for example, record the purchase on August 1 in Accounts Payable—Aron.) Aug. 1 Purchased merchandise from Aron Company for $4,000 under credit terms of 1/10, n/30, FOB destination, invoice dated August 1. 5 Sold merchandise to Baird Corp. for $2,800 under credit terms of 2/10, n/60, FOB destination, invoice dated August 5. The merchandise had cost $2,000. 8 Purchased merchandise from Waters Corporation for $3,000 under credit terms of 1/10, n/45, FOB shipping point, invoice dated August 8. 9 Paid $140 cash for shipping charges related to the August 5 sale to Baird Corp. 10 Baird returned merchandise from the August 5 sale that had cost Lowe’s $500 and was sold for $1,000. The merchandise was restored to inventory. 12 After negotiations with Waters Corporation concerning problems with the purchases on August 8, Lowe’s received a credit memorandum from Waters granting a price reduction of $300 off the $3,000 of goods purchased. 14 At Aron’s request, Lowe’s paid $380 cash for freight charges on the August 1 purchase, reducing the amount owed to Aron. 15 Received balance due from Baird Corp. for the August 5 sale less the return on August 10. 18 Paid the amount due Waters Corporation for the August 8 purchase less the price allowance from August 12. 19 Sold merchandise to Tux Co. for $2,400 under credit terms of n/10, FOB shipping point, invoice dated August 19. The merchandise had cost $1,200. 22 Tux requested a price reduction on the August 19 sale because the merchandise did not meet specifications. Lowe’s sent Tux a $400 credit memorandum toward the $2,400 invoice to resolve the issue. 29 Received Tux’s cash payment for the amount due from the August 19 sale less the price allowance from August 22. 30 Paid Aron Company the amount due from the August 1 purchase.
In: Accounting
Going forward, how do you see 'sustainability' play into the big picture of how businesses are operated and viewed? Please back up your perspective with a decent explanation and rationale. Also, not overly brief or generic
In: Accounting
Assume that on December 31, 2019, Kimberly-Clark Corp. signs a 10-year, non-cancelable lease agreement to lease a storage building from Sheffield Storage Company. The following information pertains to this lease agreement.
| 1. | The agreement requires equal rental payments of $66,199 beginning on December 31, 2019. | |
| 2. | The fair value of the building on December 31, 2019 is $484,368. | |
| 3. | The building has an estimated economic life of 12 years, a guaranteed residual value of $10,000, and an expected residual value of $7,900. Kimberly-Clark depreciates similar buildings on the straight-line method. | |
| 4. | The lease is nonrenewable. At the termination of the lease, the building reverts to the lessor. | |
| 5. | Kimberly-Clark’s incremental borrowing rate is 8% per year. The lessor’s implicit rate is not known by Kimberly-Clark. |
Prepare the journal entries on the lessee’s books to reflect the signing of the lease agreement and to record the payments and expenses related to this lease for the years 2019, 2020, and 2021. Kimberly-Clark’s fiscal year-end is December 31.
In: Accounting
Brenda has been asked to observe how junior management are using new accounting software at a leading city accounting firm. As part of informed consent, staff are informed that they will remain anonymous. During her observations, Brenda notices that many of the junior management staff are making a particular data entry error when using the software. These errors are causing the accounting firm to lose profit. Company policy dictates clearly that worker salaries will be docked for clear mistakes leading to the loss of company profit. How does Brenda handle this situation?
Briefly discuss the dilemma for Brenda. Show your utilisation by using Chris MacDonald's methodology to demonstrate how Brenda might analyse and resolve the dilemma. Provide a recommendation of what actions Brenda should initiate and to whom she needs to communicate throughout the process.
In: Accounting
In 2018, Nina contributes 11 percent of her $119,000 annual salary to her 401(k) account. She expects to earn a 5 percent before-tax rate of return. Assuming she leaves this (and any employer contributions) in the account until she retires in 25 years, what is Nina’s after-tax accumulation from her 2018 contributions to her 401(k) account?
a.) Assume Nina’s marginal tax rate at retirement is 30 percent.
b.) Assume Nina’s marginal tax rate at retirement is 20 percent.
c.) Assume Nina’s marginal tax rate at retirement is 40 percent.
In: Accounting
On the first day of the fiscal year, a company issues a $8,400,000, 12%, 10-year bond that pays semiannual interest of $504,000 ($8,400,000 × 12% × ½), receiving cash of $7,115,493. Journalize the first interest payment and the amortization of the related bond discount. Round to the nearest dollar. If an amount box does not require an entry, leave it blank.
In: Accounting
When CQ University’s computers began acting sluggishly, computer operators were relieved when a software trouble-shooter from DELL called. When he offered to correct the problem they were having, he was given a login ID and password. The next morning, the computers were worse. A call to DELL confirmed the university’s suspicion: someone had impersonated a DELL repairman to gain unauthorized access to the system and destroy the database. CQ University was also concerned that the intruder had devised a program that would let him get back into the system even after all the passwords were changed. a) What techniques could the imposter have implemented to breach the university’s internal security? ____________________
In: Accounting
In: Accounting
On May 1, 2017, Bramble Company issued 1,400 $1,000 bonds at
102. Each bond was issued with one detachable stock warrant.
Shortly after issuance, the bonds were selling at 97, but the fair
value of the warrants cannot be determined.
(a) Prepare the entry to record the issuance of
the bonds and warrants. (Credit account titles are
automatically indented when amount is entered. Do not indent
manually. If no entry is required, select "No Entry" for the
account titles and enter 0 for the
amounts.)
|
Account Titles and Explanation |
Debit |
Credit |
(b) Assume the same facts as part (a), except that
the warrants had a fair value of $37. Prepare the entry to record
the issuance of the bonds and warrants. (Credit account
titles are automatically indented when amount is entered. Do not
indent manually. If no entry is required, select "No Entry" for the
account titles and enter 0 for the amounts. Round intermediate
calculations to 5 decimal places, e.g. 1.24687 and final answers to
0 decimal places, e.g. 5,125.)
|
Account Titles and Explanation |
Debit |
Credit |
In: Accounting
BONDS :
Huskies Corp. issued 9-year $750,000 bond on January 1, 2006 with coupon rate of 10%. The bond pays interest semiannually every June 30 and December 31, with the principal to be paid at the end of year 9. The effective market interest rate at the issuance date is 8%.
a. Calculate the proceeds and show clearly what you use for RATE, NPER, PMT, FV ?
b. What journal entry was recorded at issuance?
c. What annual coupon rate would Huskies have to offer in order to obtain total proceeds of $750,000 on the issuance of these bonds
d. UNRELATED to above. Labradors Inc. repurchased the bond which has been issued several years ago and which has a Face Value of $800,000 and unamortized premium of $42,000. The bond was repurchased at 106. Record the journal entry that the company made when it repurchased the bond.
In: Accounting
How much cash do I have at the end of period 2, 3, and 4?
Please add calculations for each period.
| Period | Debit or Credit | Value | Type | Account |
|---|---|---|---|---|
| 0 | Credit(+) | $1,500,000 | Equity | Startup Capital |
| 0 | Debit(+) | $1,500,000 | Asset | Cash |
| 0 | Debit(+) | $300,000 | Asset | Property, Plant & Equipment |
| 1 | Debit(+) | $26,000 | Expense | Operating Costs |
| 1 | Credit(-) | $26,000 | Asset | Cash |
| 1 | Credit(+) | $126,114 | Revenue | Revenue |
| 1 | Debit(+) | $126,114 | Asset | Cash |
| 1 | Debit(+) | $240,000 | Asset | Inventory |
| 1 | Credit(+) | $240,000 | Asset | Cash |
| 1 | Debit(+) | $67,261 | Expense | Cost of Goods Sold |
| 1 | Credit(-) | $67,261 | Asset | Inventory |
| 2 | Debit(+) | $26,000 | Expense | Operating Costs |
| 2 | Credit(-) | $26,000 | Asset | Cash |
| 2 | Credit(+) | $473,886 | Revenue | Revenue |
| 2 | Debit(+) | $473,886 | Asset | Cash |
| 2 | Debit(+) | $90,000 | Asset | Inventory |
| 2 | Credit(+) | $90,000 | Asset | Cash |
| 2 | Debit(+) | $284,332 | Expense | Cost of Goods Sold |
| 2 | Credit(-) | $284,332 | Asset | Inventory |
| 2 | Debit(+) | $37,500 | Expense | Loan Payment - Interest |
| 2 | Credit(-) | $37,500 | Asset | Cash |
| 2 | Debit(+) | $250,000 | Liability | Loan Payment - Principal |
| 2 | Credit(-) | $250,000 | Asset | Cash |
| 2 | Debit(+) | $40,000 | Expense | Other Costs |
| 2 | Credit(-) | $40,000 | Asset | Cash |
| 2 | Debit(+) | $6,000 | Expense | Market Research Costs |
| 2 | Credit(-) | $6,000 | Asset | Cash |
| 2 | Debit(+) | $2,500 | Expense | Sales Promotion - OKC |
| 2 | Credit(-) | $2,500 | Asset | Cash |
| 2 | Debit(+) | $2,500 | Expense | Sales Promotion - Tulsa |
| 2 | Credit(-) | $2,500 | Asset | Cash |
| 2 | Debit(+) | $2,500 | Expense | Sales Promotion - Stillwater |
| 2 | Credit(-) | $2,500 | Asset | Cash |
| 2 | Debit(+) | $2,500 | Expense | Product Line Brand - OKC |
| 2 | Credit(-) | $2,500 | Asset | Cash |
| 2 | Debit(+) | $2,500 | Expense | Product Line Brand - Tulsa |
| 2 | Credit(-) | $2,500 | Asset | Cash |
| 2 | Debit(+) | $2,500 | Expense | Product Line Brand - Stillwater |
| 2 | Credit(-) | $2,500 | Asset | Cash |
| 3 | Debit(+) | $26,000 | Expense | Operating Costs |
| 3 | Credit(-) | $26,000 | Asset | Cash |
| 3 | Credit(+) | $799,731 | Revenue | Revenue |
| 3 | Debit(+) | $799,731 | Asset | Cash |
| 3 | Debit(+) | $682,500 | Asset | Inventory |
| 3 | Credit(+) | $682,500 | Asset | Cash |
| 3 | Debit(+) | $559,812 | Expense | Cost of Goods Sold |
| 3 | Credit(-) | $559,812 | Asset | Inventory |
| 3 | Debit(+) | $1,500 | Expense | Market Research Costs |
| 3 | Credit(-) | $1,500 | Asset | Cash |
| 3 | Debit(+) | $2,500 | Expense | Research & Development - Flavor Varieties |
| 3 | Credit(-) | $2,500 | Asset | Cash |
| 3 | Debit(+) | $5,000 | Expense | Research & Development - Ingredient Quality |
| 3 | Credit(-) | $5,000 | Asset | Cash |
| 3 | Debit(+) | $15,000 | Expense | Research & Development - Update Equipment |
| 3 | Credit(-) | $15,000 | Asset | Cash |
| 3 | Debit(+) | $3,750 | Expense | Sales Promotion - OKC |
| 3 | Credit(-) | $3,750 | Asset | Cash |
| 3 | Debit(+) | $2,500 | Expense | Sales Promotion - Tulsa |
| 3 | Credit(-) | $2,500 | Asset | Cash |
| 3 | Debit(+) | $5,000 | Expense | Sales Promotion - Stillwater |
| 3 | Credit(-) | $5,000 | Asset | Cash |
| 3 | Debit(+) | $3,750 | Expense | Product Line Brand - OKC |
| 3 | Credit(-) | $3,750 | Asset | Cash |
| 3 | Debit(+) | $2,500 | Expense | Product Line Brand - Tulsa |
| 3 | Credit(-) | $2,500 | Asset | Cash |
| 3 | Debit(+) | $5,000 | Expense | Product Line Brand - Stillwater |
| 3 | Credit(-) | $5,000 | Asset | Cash |
| 4 | Debit(+) | $26,000 | Expense | Operating Costs |
| 4 | Credit(-) | $26,000 | Asset | Cash |
| 4 | Credit(+) | $723,876 | Revenue | Revenue |
| 4 | Debit(+) | $723,876 | Asset | Cash |
| 4 | Debit(+) | $315,000 | Asset | Inventory |
| 4 | Credit(+) | $315,000 | Asset | Cash |
| 4 | Debit(+) | $381,945 | Expense | Cost of Goods Sold |
| 4 | Credit(-) | $381,945 | Asset | Inventory |
| 4 | Debit(+) | $1,500 | Expense | Market Research Costs |
| 4 | Credit(-) | $1,500 | Asset | Cash |
| 4 | Debit(+) | $2,500 | Expense | Research & Development - Flavor Varieties |
| 4 | Credit(-) | $2,500 | Asset | Cash |
| 4 | Debit(+) | $5,000 | Expense | Research & Development - Ingredient Quality |
| 4 | Credit(-) | $5,000 | Asset | Cash |
| 4 | Debit(+) | $5,000 | Expense | Sales Promotion - OKC |
| 4 | Credit(-) | $5,000 | Asset | Cash |
| 4 | Debit(+) | $5,000 | Expense | Sales Promotion - Tulsa |
| 4 | Credit(-) | $5,000 | Asset | Cash |
| 4 | Debit(+) | $5,000 | Expense | Sales Promotion - Stillwater |
| 4 | Credit(-) | $5,000 | Asset | Cash |
| 4 | Debit(+) | $5,000 | Expense | Product Line Brand - OKC |
| 4 | Credit(-) | $5,000 | Asset | Cash |
| 4 | Debit(+) | $5,000 | Expense | Product Line Brand - Tulsa |
| 4 | Credit(-) | $5,000 | Asset | Cash |
| 4 | Debit(+) | $5,000 | Expense | Product Line Brand - Stillwater |
| 4 | Credit(-) | $5,000 | Asset | Cash |
In: Accounting
Daosta Inc. uses the FIFO method in its process costing system. The following data concern the op... Daosta Inc. uses the FIFO method in its process costing system. The following data concern the operations of the company's first processing department for a recent month. Work in process, beginning: Units in process 900 Percent complete with respect to materials 40 % Percent complete with respect to conversion 20 % Costs in the beginning inventory: Materials cost $ 530 Conversion cost $ 2108 Units started into production during the month 16,000 Units completed and transferred out 16,000 Costs added to production during the month: Materials cost $ 32,180 Conversion cost $ 416,512 Work in process, ending: Units in process 900 Percent complete with respect to materials 50 % Percent complete with respect to conversion 70 %
Using the FIFO method:
Equivalent Units of production for direct materials:
Equivalent units of production for conversion costs:
Cost per equivalent unit- direct materials:$
cost per equivalent unit- conversion costs:$
Total value of ending Work in process:$
Total value of units transferred out:$
In: Accounting