Shows the computation of cash collections

Assignment Help Accounting Basics
Reference no: EM13673326

Aztec Company sells its product for $170 per unit. Its actual and projected sales follow.

Units Dollars
April (actual) 5,500 $935,000
May (actual) 2,600 442,000
June (budgeted) 6,000 1,020,000
July (budgeted) 5,500 935,000
August (budgeted) 4,200 714,000


All sales are on credit. Recent experience shows that 28% of credit sales is collected in the month of the sale, 42% in the month after the sale, 27% in the second month after the sale, and 3% proves to be uncollectible. The product's purchase price is $110 per unit. All purchases are payable within 12 days. Thus, 60% of purchases made in a month is paid in that month and the other 40% is paid in the next month. The company has a policy to maintain an ending monthly inventory of 21% of the next month's unit sales plus a safety stock of 75 units. The April 30 and May 31 actual inventory levels are consistent with this policy. Selling and administrative expenses for the year are $1,824,000 and are paid evenly throughout the year in cash. The company's minimum cash balance at month-end is $150,000. This minimum is maintained, if necessary, by borrowing cash from the bank. If the balance exceeds $150,000, the company repays as much of the loan as it can without going below the minimum. This type of loan carries an annual 10% interest rate. On May 31, the loan balance is $35,000, and the company's cash balance is $150,000. (Round final answers to the nearest whole dollar.)

Prepare a table that shows the computation of cash collections of its credit sales (accounts receivable) in each of the months of June and July.

Reference no: EM13673326

Questions Cloud

Jump out of a stationary balloon : Two stunt men are going to jump out of a stationary balloon 457 meters off the ground, jumper A will jump first, pulling his parachute at 4 seconds after the jump. Jumper B will jump precisely 20 seconds after jumper A. Jumper B is slightly heavier t..
Angular speed of record immediately after putty sticks to it : A horizontal vinyl record of radius 0.0786 m rotates freely about a vertical axis during its center with an angular speed of 4.59 rad/s. The rotational inertia of the record about its axis of rotation is 2.54 x 10-4 kg·m2. A wad of wet putty of mass ..
What then is the angular velocity of cockroach-disk system : A cockroach of mass m lies on the rim of a uniform disk of mass 3.28m that can rotate freely about its center like a merry-go-round. Initially the cockroach and disk rotate together with an angular velocity of 0.268 rad/s.
How much time elapses while the turbine is speeding up : A wind turbine is initially spinning at a constant angular speed. As the wind's strength gradually increases, the turbine experiences a constant angular acceleration 0.128 rad/s2. After making 2680 revolutions, its angular speed is 124 rad/s.
Shows the computation of cash collections : Prepare a table that shows the computation of cash collections of its credit sales (accounts receivable) in each of the months of June and July.
Alcohol-filled shell starts to rise toward surface of water : A thin spherical shell of mass 0.450kg and diameter 0.150 m is filled with alcohol (ρ = 806 kg/m  3). It is then released from rest at the bottom of a pool of water. Discover the acceleration of the alcohol-filled shell as it starts to rise toward th..
Strolling through woods and crosses small horizontal bridge : A hiker, who weighs 642 N, is strolling through the woods and crosses a small horizontal bridge. The bridge is uniform, weighs 3710 N, and rests on two concrete supports, one on each end. He stops 1/3 of the way along the bridge.
What is the childs speed at the bottom of the slide : A 70.5-kilogram child starts from rest from the top of a frictionless slide that is 5.6 meters tall. The bottom of the slide is 25.0 centimetres above the ground. What is the child's speed at the bottom of the slide?
How much time does it take for the bike to come to rest : A person is riding a bicycle, and its wheels have an angular velocity of 15.8 rad/s. Then, the brakes are applied and the bike is brought to a uniform stop. Through braking, the angular displacement of each wheel is 14.2 revolutions.

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