Questions
Waterways Continuing Problem 09 Waterways Corporation is preparing its budget for the coming year, 2020. The...

Waterways Continuing Problem 09

Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process.

Sales

Unit sales for November 2019

111,000

Unit sales for December 2019

101,000

Expected unit sales for January 2020

112,000

Expected unit sales for February 2020

112,000

Expected unit sales for March 2020

116,000

Expected unit sales for April 2020

125,000

Expected unit sales for May 2020

138,000

Unit selling price

$12


Waterways likes to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31, 2019, totaled $181,800.

Direct Materials

Direct materials cost 80 cents per pound. Two pounds of direct materials are required to produce each unit.

Waterways likes to keep 5% of the materials needed for the next month in its ending inventory. Raw Materials on December 31, 2019, totaled 11,200 pounds. Payment for materials is made within 15 days. 50% is paid in the month of purchase, and 50% is paid in the month after purchase. Accounts Payable on December 31, 2019, totaled $102,595.

Direct Labor

Labor requires 12 minutes per unit for completion and is paid at a rate of $9 per hour.

Manufacturing Overhead

Indirect materials

30¢

per labor hour

Indirect labor

50¢

per labor hour

Utilities

50¢

per labor hour

Maintenance

30¢

per labor hour

Salaries

$43,000

per month

Depreciation

$17,700

per month

Property taxes

$2,900

per month

Insurance

$1,200

per month

Maintenance

$1,300

per month

Selling and Administrative

Variable selling and administrative cost per unit is $1.50.

   Advertising

$16,000

a month

   Insurance

$1,500

a month

   Salaries

$73,000

a month

   Depreciation

$2,300

a month

   Other fixed costs

$2,800

a month


Other Information

The Cash balance on December 31, 2019, totaled $99,000, but management has decided it would like to maintain a cash balance of at least $700,000 beginning on January 31, 2020. Dividends are paid each month at the rate of $2.30 per share for 4,860 shares outstanding. The company has an open line of credit with Romney’s Bank. The terms of the agreement requires borrowing to be in $1,000 increments at 9% interest. Waterways borrows on the first day of the month and repays on the last day of the month. A $510,000 equipment purchase is planned for February.

For the first quarter of 2020, prepare a sales budget.

For the first quarter of 2020, prepare a production budget.

For the first quarter of 2020, prepare a direct materials budget. (Round cost per pound to 2 decimal places, e.g. 0.25 and all other answers to 0 decimal places, e.g. 2,520.)

For the first quarter of 2020, prepare a direct labor budget. (Round time per unit to nearest hour, e.g. 30 minutes will be rounded to 0.5 hours)

For the first quarter of 2020, prepare a manufacturing overhead budget. (Round overhead rate to 2 decimal places, e.g. 5.25 and all other answers to 0 decimal places, e.g. 2,520. List Variable Costs first.)

For the first quarter of 2020, prepare a selling and administrative budget. (Enter per unit expenses rounded to 2 decimal places. E.g. 1.25)

For the first quarter of 2020, prepare a schedule for expected cash collections from customers.

For the first quarter of 2020, prepare a schedule for expected payments for materials purchases. (Round answers to 0 decimal places, e.g. 2,520.)

For the first quarter of 2020, prepare a cash budget. (Round answers to 0 decimal places, e.g. 2,520.)

In: Accounting

Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...

Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 111,000 Unit sales for December 2019 103,000 Expected unit sales for January 2020 114,000 Expected unit sales for February 2020 114,000 Expected unit sales for March 2020 116,000 Expected unit sales for April 2020 127,000 Expected unit sales for May 2020 139,000 Unit selling price $12 Waterways likes to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31, 2019, totaled $185,400. Direct Materials Direct materials cost 80 cents per pound. Two pounds of direct materials are required to produce each unit. Waterways likes to keep 5% of the materials needed for the next month in its ending inventory. Raw Materials on December 31, 2019, totaled 11,400 pounds. Payment for materials is made within 15 days. 50% is paid in the month of purchase, and 50% is paid in the month after purchase. Accounts Payable on December 31, 2019, totaled $104,595. Direct Labor Labor requires 12 minutes per unit for completion and is paid at a rate of $9 per hour. Manufacturing Overhead Indirect materials 30¢ per labor hour Indirect labor 50¢ per labor hour Utilities 50¢ per labor hour Maintenance 30¢ per labor hour Salaries $41,000 per month Depreciation $18,100 per month Property taxes $2,500 per month Insurance $1,200 per month Maintenance $1,200 per month Selling and Administrative Variable selling and administrative cost per unit is $1.50. Advertising $15,000 a month Insurance $1,500 a month Salaries $71,000 a month Depreciation $2,500 a month Other fixed costs $2,900 a month Other Information The Cash balance on December 31, 2019, totaled $98,000, but management has decided it would like to maintain a cash balance of at least $700,000 beginning on January 31, 2020. Dividends are paid each month at the rate of $2.70 per share for 4,740 shares outstanding. The company has an open line of credit with Romney’s Bank. The terms of the agreement requires borrowing to be in $1,000 increments at 9% interest. Waterways borrows on the first day of the month and repays on the last day of the month. A $530,000 equipment purchase is planned for February.

For the first quarter of 2020, prepare a sales budget.

For the first quarter of 2020, prepare a production budget.

For the first quarter of 2020, prepare a direct materials budget. (Round cost per pound to 2 decimal places, e.g. 0.25 and all other answers to 0 decimal places, e.g. 2,520.)

For the first quarter of 2020, prepare a direct labor budget. (Round time per unit to nearest hour, e.g. 30 minutes will be rounded to 0.5 hours)

For the first quarter of 2020, prepare a manufacturing overhead budget. (Round overhead rate to 2 decimal places, e.g. 5.25 and all other answers to 0 decimal places, e.g. 2,520. List Variable Costs first.)

For the first quarter of 2020, prepare a selling and administrative budget. (Enter per unit expenses rounded to 2 decimal places. E.g. 1.25)

For the first quarter of 2020, prepare a schedule for expected cash collections from customers.

For the first quarter of 2020, prepare a schedule for expected payments for materials purchases. (Round answers to 0 decimal places, e.g. 2,520.)

For the first quarter of 2020, prepare a cash budget. (Round answers to 0 decimal places, e.g. 2,520.)

In: Accounting

Background Information Note the following: Acme Corporation is a publicly listed company ACME’s Fiscal year end...

Background Information Note the following:

  • Acme Corporation is a publicly listed company

  • ACME’s Fiscal year end is December 31

  • In addition to the cash account being reconcile here; ACME has a separate Revolving Credit account.

    This is a revolving credit facility where interest is accrued on the average balance outstanding during the month. The interest amount is required to be paid on a monthly basis. The correct is amount calculated and taken from the account automatically by the bank.

  • The facility has an annual interest rate of 4%

  • Management has set-out in the Financial Statements that the average balance outstanding in this

    revolving credit facility is normally at around $ 150,000.

  • The Audit Committee has also informed the Partner that the CRA audited ACME in the previous year

    and levied a penalty of $50,000 and has informed the Board that they plan continue their audit in the new year.

    Required

    Part 1

  1. a) From the information provided in EXHIBIT A, perform and document a Bank Reconciliation. - 20 marks

  2. b) From the Background info. provided above, identify potential errors and disclosure requirements - 5 marks

Part 2

  1. a) Identify the financial assertions relating to the Cash account addressed by the Bank Reconciliation and explain how. – 5 marks

  2. b) Identify what type of activity the Bank Reconciliation is. – 5 marks

  3. c) Identify the 6 possible characteristics (of the activity above) and which apply to the Bank Rec. – 5 marks

BONUS
How would the Auditor test the identified characteristics. – 4 marks

EXHIBIT A

ABC Bank Statement Exerpt for Acme Corporartion Bank Account

for December 201X

Date

Description

Cash Out

Cash In

Balance

January 7, 2021

Cheque 1415

$ 2,500.00

$ 103,390.00

January 6, 2021

Cheque 1416

$ 3,000.00

$ 105,890.00

January 5, 2021

Cheque 1414

$ 2,000.00

$ 108,890.00

January 4, 2021

$ 110,890.00

January 3, 2021

EFT

$ 7,500.00

$ 110,890.00

January 2, 2021

EFT

$ 6,000.00

$ 118,390.00

January 1, 2021

Foreign Wire

$ 5,250.00

$ 124,390.00

December 31, 2020

Loan Interest - Dec.

$ 1,500.00

$ 119,140.00

December 30, 2020

Bank Charges - Dec.

$ 250.00

$ 120,640.00

December 29, 2020

Returned Cheque 1412

$ 500.00

$ 120,890.00

December 28, 2020

Cheque 1413

$ 1,500.00

$ 120,390.00

December 27, 2020

CRA Appropriation

$ 50,000.00

$ 121,890.00

December 26, 2020

Cheque 1412

$ 500.00

$ 171,890.00

December 25, 2020

$ 172,390.00

December 24, 2020

$ 172,390.00

$ 74,750.00

$ 5,750.00

$ 172,390.00

Acme Corporation

General Ledger Cash Account Excerpt

Date

Transaction Detail

Type

Debit

Credit

GL Acct. Balance

January 7, 2021

$ 103,390.00

January 6, 2021

Payment to Supplier #11

Cheque 1418

$ 103,390.00

January 5, 2021

Payment to Supplier #12

Cheque 1417

$ 103,390.00

January 4, 2021

Loan Interest - Re: Dec.

Taken by Bank

$ 1,500.00

$ 103,390.00

January 3, 2021

CRA Appropriation

Taken by CRA

$ 50,000.00

$ 104,890.00

January 2, 2021

Returned Cheque (Supplier Account Closed)

Cheque 1412

$ 500.00

$ 154,890.00

January 1, 2021

Bank Charges - Re: Dec.

Taken by Bank

$ 250.00

$ 154,390.00

December 31, 2020

Payment to Supplier #4

EFT

$ 6,000.00

$ 154,640.00

December 30, 2020

Payment to Supplier #5

Cheque 1416

$ 3,000.00

$ 160,640.00

December 29, 2020

Payment to Supplier #1

EFT

$ 7,500.00

$ 163,640.00

December 28, 2020

Payment to Supplier #2

Cheque 1415

$ 2,500.00

$ 171,140.00

December 27, 2020

Receipt from Customer B

Foreign Wire

$ 5,250.00

$ 173,640.00

December 26, 2020

Receipt from Customer A

Cheque 1414

$ 2,000.00

$ 168,390.00

December 25, 2020

Payment to Supplier #2

Cheque 1413

$ 1,500.00

$ 170,390.00

December 24, 2020

Payment to Supplier #3

Cheque 1412

$ 500.00

$ 171,890.00

$ 5,750.00

$ 74,750.00

$ 172,390.00

In: Accounting

You’ve Got Mail…and You’re Fired! The Case of RadioShack No one likes to receive bad news,...

You’ve Got Mail…and You’re Fired! The Case of RadioShack No one likes to receive bad news, and few like to give it. In what is heralded as one of the biggest human resources blunders of 2006, one company found a way around the discomfort of firing someone face-to-face. A total of 400 employees at the Fort Worth, Texas, headquarters of RadioShack Corporation (NYSE: RSH) got the ultimate e-mail message early one Tuesday morning. The message simply said, “The work force reduction notification is currently in progress. Unfortunately, your position is one that has been eliminated.” Company officials argued that using electronic notification was faster and allowed more privacy than breaking the news in person, and additionally, those employees who were laid off received generous severance packages. Organizational consultant Ken Siegel disagrees, proclaiming, “The bottom line is this: To almost everyone who observes or reads this, it represents a stupefying new low in the annals of management practice.” It’s unclear what, if any, the longterm effect will be for RadioShack. It isn’t just RadioShack that finds it challenging to deal with letting employees go. Terminating employees can be a painful job for many managers. The communication that takes place requires careful preparation and substantial levels of skill. BusinessWeek ethics columnist Bruce Weinstein suggests MAN 1163_2 (April 4 th, 2020) © 2020 LAMBTON COLLEGE IN TORONTO that anyone who is involved with communicating with downsized employees has an ethical responsibility to do it correctly, which includes doing it in person, doing it privately, giving the person your full attention, being honest but sensitive, and not rushing the person. Some organizations outsource the job of letting someone go to “terminators” who handle this difficult task for them. In fact, Up in the Air, the 2009 movie starring George Clooney that was nominated for six Oscars, chronicles changes at a workforce reduction firm and highlights many of these issues. Downsizing has been referred to using many euphemisms (language that softens the sound of the word) for termination. Here are just a few ways to say you’re about to lose your job without saying you’ve been fired: • Career alternative enhancement program • Career-change opportunity • Dehiring staff • Derecruiting resources • Downsizing employment • Employee reduction activities • Implementing a skills mix adjustment • Negative employee retention • Optimizing outplacement potential • Rectification of a workforce imbalance • Redundancy elimination • Right-sizing employment • Vocation relocation policy Regardless of how it’s done or what it’s called, is downsizing effective for organizations? Jeffrey Pfeffer, a faculty member at Stanford and best-selling author, argues no: “Contrary to popular belief, companies that announce layoffs do not enjoy higher stock prices than peers—either immediately or over time. A study of 141 layoff announcements between 1979 and 1997 found negative stock returns to companies announcing layoffs, with larger and permanent layoffs leading to greater negative effects. An examination of 1,445 downsizing announcements between 1990 and 1998 also reported that downsizing had a negative effect on stock-market returns, and the negative effects were larger the greater the extent of the downsizing. Yet another MAN 1163_2 (April 4 th, 2020) © 2020 LAMBTON COLLEGE IN TORONTO study comparing 300 layoff announcements in the United States and 73 in Japan found that in both countries, there were negative abnormal shareholder returns following the announcement.” He further notes that evidence doesn’t support the idea that layoffs increase individual company productivity either: “A study of productivity changes between 1977 and 1987 in more than 140,000 U.S. companies using Census of Manufacturers data found that companies that enjoyed the greatest increases in productivity were just as likely to have added workers as they were to have downsized.” Please Answer the Following 5 Questions: 1. What communication barriers did RadioShack likely experience as a result of terminating employees via the communication method used? 2. What do you think RadioShack’s underlying motivation was in using this form of communication? 3. What suggestions for the future would you give RadioShack when faced with the need to dismiss a large number of employees? 4. How has technology enhanced our ability to communicate effectively? In what ways has it hindered our ability to communicate effectively? 5. What ethical challenges and concerns do you think individuals involved in downsizing have?

In: Operations Management

Explain glycogenolysis, insulin level, fate of lactate, pyruvate, and alanine during the early and late fasting...

Explain glycogenolysis, insulin level, fate of lactate, pyruvate, and alanine during the early and late fasting states

I NEED JUST EXPLAINATION FOR LATE FASTING STATES

In: Nursing

As a process executes, it changes states. Explain what are ready state, running state, and waiting...

As a process executes, it changes states. Explain what are ready state, running state, and waiting state. Also, describe when a process moves between these three states

In: Computer Science

Sandhill Corp., which uses IFRS, signs non-renewable, non-cancellable lease agreement to lease robotic equipment from Xiu...

Sandhill Corp., which uses IFRS, signs non-renewable, non-cancellable lease agreement to lease robotic equipment from Xiu Inc. The following information concerns the lease agreement.

Inception date January 1, 2020
Lease term 5 years
Fair value of equipment Jan. 1, 2020 $140,000
Economic life of leased equipment 7 years
Annual rental payments starting Jan. 1, 2020 $23,829
Option to purchase at the end of the term none
Depreciation method Straight-line
Residual value none
Sandhill’s incremental borrowing rate 6%

Using (1) factor tables, (2) a financial calculator, or (3) Excel functions, calculate the amount of the right-of-use asset and lease liability.

The amount of the right-of-use asset $


Prepare the initial entry to reflect the signing of the lease agreement. (Credit account titles are automatically indented when the 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.)

Date

Account Titles and Explanation

Debit

Credit

Jan. 1, 2020

Prepare an amortization schedule for the term of the lease to be used by Sandhill. Use Excel. (Round answers to 0 decimal places, e.g. 5,275.)

Sandhill Corp.
Lease Amortization Schedule
(Lessee)
Date Annual
Payment
Interest
on Unpaid
Liability
Reduction
of Lease
Liability
Balance
of Lease
Liability
$
January 1, 2020 $ $
January 1, 2021 $
January 1, 2022
January 1, 2023
January 1, 2024

Prepare the journal entries on Sandhill Corp.’s books to record the payments related to this lease for the years 2020 and 2021 as well as any adjusting journal entries at its fiscal year ends of December 31, 2020 and 2021. (Credit account titles are automatically indented when the 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.)

Date

Account Titles and Explanation

Debit

Credit

                                                          Dec. 31, 2020 Jan. 1, 2021 Dec. 31, 2021

(To record depreciation)

                                                                      Dec. 31, 2020 Jan. 1, 2021 Dec. 31, 2021

(To record interest)

                                                                      Dec. 31, 2020 Jan. 1, 2021 Dec. 31, 2021

                                                                      Dec. 31, 2020Jan. 1, 2021Dec. 31, 2021

(To record depreciation)

                                                                      Dec. 31, 2020Jan. 1, 2021Dec. 31, 2021

(To record interest)

In: Accounting

The Shamrock Pub provides catering services to local businesses. The following information was available for The...

The Shamrock Pub provides catering services to local businesses. The following information was available for The Shamrock Pub for the years ended December 31, 2019 and 2020.

December
31, 2019
December
31, 2020
Cash $ 2,180 $ 1,680
Accounts receivable 46,500 ?
Allowance for doubtful accounts 530 ?
Other current assets 8,230 7,930
Current liabilities 38,300 44,700
Total credit sales 201,000 257,000
Collections on accounts receivable 193,000 230,000

Shamrock management is preparing for a meeting with its bank concerning renewal of a loan and has collected the following information related to the above balances.

1.The cash reported at December 31, 2020, reflects the following items: petty cash $1,560 and postage stamps $120. The other current assets balance at December 31, 2020, includes the checking account balance of $3,900.

2.On November 30, 2020, Shamrock agreed to accept a 6-month, $4,940 note bearing 12% interest, payable at maturity, from a major client in settlement of a $4,940 bill. The above balances do not reflect this transaction.

3.Shamrock factored some accounts receivable at the end of 2020. It transferred accounts totaling $10,000 to Final Factor, Inc. with recourse. Final Factor will receive the collections from Shamrock's customers and will retain 2% of the balances. Final Factor assesses Shamrock a finance charge of 3% on this transfer. The fair value of the recourse liability is $360. However, management has determined that the amount due from the factor and the fair value of the resource obligation have not been recorded, and neither are included in the balances above.

4.Shamrock charged off uncollectible accounts with balances of $1,570. On the basis of the latest available information, the 2020 provision for bad debts is estimated to be 2.5% of accounts receivable.

Based on the above transactions, determine the balance for (1) Accounts Receivable and (2) Allowance for Doubtful Accounts at December 31, 2020. (Round answers to 0 decimal places, e.g. 125.)

Accounts receivable ending balance$

Allowance for doubtful ending balance$

Prepare the current assets section of The Shamrock Pub's balance sheet at December 31, 2020. (Round answers to 0 decimal places, e.g. 125.) and,

Compute Shamrock's current ratio and accounts receivable turnover for December 31, 2020. The accounts receivable turnover in 2019 was 4.37.

In: Accounting

On January 1, 2020, Blossom Inc. agrees to buy 3 kg of gold at $32,000 per...

On January 1, 2020, Blossom Inc. agrees to buy 3 kg of gold at $32,000 per kilogram from Golden Corp on April 1, 2020, but does not intend to take delivery of the gold. On the day that the contract was entered into, the fair value of this futures contract that trades on the Futures Exchange was zero. On January 1, 2020, Blossom is required to deposit $66 with the stockbroker as a margin. The fair value of the futures subsequently fluctuated as follows:

Date Fair Value of Futures Contract

January 20, 2020

$455

February 6, 2020

$130

February 28, 2020

$362

March 14, 2020

$750


On the settlement date, the spot price of gold is $33,000 per kilogram. Assume that Blossom complies with IFRS.

QUESTION:

1) Prepare the journal entry for the day the futures contract was signed.

Date

Account Titles and Explanation

Debit

Credit

January 1, 2020

enter an account title enter a debit amount enter a credit amount
enter an account title enter a debit amount enter a credit amount

2) Prepare the journal entries to recognize the changes in the fair value of the futures contract.

Date

Account Titles and Explanation

Debit

Credit

transaction date enter an account title enter a debit amount enter a credit amount
enter an account title enter a debit amount enter a credit amount
transaction date enter an account title enter a debit amount enter a credit amount
enter an account title enter a debit amount enter a credit amount
transaction date enter an account title enter a debit amount enter a credit amount
enter an account title enter a debit amount enter a credit amount
transaction date enter an account title enter a debit amount enter a credit amount
enter an account title enter a debit amount enter a credit amount

3) Prepare the journal entry that would be required if Blossom settled the contract on a net basis on April 1, 2020.

Date

Account Titles and Explanation

Debit

Credit

April 1, 2020

enter an account title enter a debit amount enter a credit amount
enter an account title enter a debit amount enter a credit amount
enter an account title enter a debit amount enter a credit amount
enter an account title enter a debit amount enter a credit amount

In: Accounting

A 14 yr. old Caucasian female presents at the clinic complaining of ugly patches of skin...

A 14 yr. old Caucasian female presents at the clinic complaining of ugly patches of skin on her elbows and knees. Patient states skin has been this way for years but gets worse with stress. Patient states concern that her Rheumatoid Arthritis has increased her stress level. She has no complaints of itching, or drainage. Patient states she does not have any allergies that she knows of.

Assessment: Bilateral elbows and knees have scaly, erythematous patches. There are silvery scales showing. There is no drainage or broken skin present. Patient states lesions are not painful.

5. What is the possible disease process ?

In: Nursing