Prepare a cash collection schedule for the bank account

Assignment Help Accounting Basics
Reference no: EM131731708

Question - A sales budget is given below for one the products manufactured by the Key Co.

January 21,000

February 36,000

March 61,000

April 41,000

May 31,000

June 25,000

The inventory of finished goods at the end of each month should equal 20% of the next month's sales. However, on December 31, the finished goods inventory totalled only 4,000 units.

Each unit of product requires three specialized electrical switches. Since the production of these specialized switches by Key's suppliers is sometimes irregular, the company has a policy of maintaining an ending inventory at the end of each month equal to 30% of the next month's production needs. This requirement had been met on January 1 of the current year.

The cost of each electrical switch is $5. The company maintains a separate bank account to recover cost of switches and to pay for the switches. Cash is deposited in this bank account at second last day of every month equivalent to cost of switches related to that's month sales. Example: in November previous year, Key Co sold 20,000 units cost of switches for November was $300,000 (20,000 x 3 switch/unit x $5/switch) and it was deposited in the account on nov 29.

The company pays for the switches in the month of purchase. All payments are made on the last day of the month. If there is any shortage of fund in the account, the company borrows it from the bank. The company policy is to maintain a minimum balance of $100,000 in the bank account at the end of each month, but it is expected that on Jan 1, the balance in this account will be $85,000. Repayment of the loan on this account is made from a separate bank account of the company.

REQUIRED:

Prepare a cash collection schedule for the bank account related to switches for January, February and March.

Prepare a cash disbursement schedule for the switch purchases for January, February and March.

Prepare a cash budget showing Excess/Deficiency and Borrowing (if any) related to the switch purchase for the bank account.

Reference no: EM131731708

Questions Cloud

Differentiate between short-run and long-run rent adjustment : If demand for built space is declining, does this imply that real rents (that is, rents measured net of inflation) will fall in the market? Why or why not?
Difference between a private and a public asset market : What is the difference between a private and a public asset market? Why do public asset markets tend to be more informationally efficient than private asset.
Prepare the statement of retained earnings for the year : Required: Prepare the statement of retained earnings for the year ended 2014, prepare any note disclosures separately
Discuss about the mortgage-backed securities : Create a four-quadrant table showing on one dimension the two major types of capital asset products and on the other dimension the two major types of capital.
Prepare a cash collection schedule for the bank account : Prepare a cash collection schedule for the bank account related to switches for January, February and March
What are main perceived benefits of investing in reit shares : Go to the Web site of the National Association of Real Estate Investment Trusts (NAREIT) at http://www.nareit.org. Click on ‘‘Investing in REITs''.
Should cognitive performance-enhancing drugs be used : Should cognitive performance-enhancing drugs be used by healthy people? Why or why not? What could be the benefits/downsides/risks?
What are the differences between debt and equity securities : How does the accounting for investments vary depending on the type of investment. What are the differences between debt and equity securities
Communication systems with the interconnectedness of mediums : Both Moran and the authors in Crowley and Heyer posit the growth of communication systems with the interconnectedness of mediums,

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd