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

  Estimated liability for litigation

The estimated liability for litigation is classified as noncurrent and the installment accounts receivable are classified as $500,000 current and $500,000 noncurrent. The income tax rate is 30% for all years.

  Feng company installs a computerized manufacturing machine

feng company installs a computerized manufacturing machine in its factory at the beginning of the year at a cost of

  Compute the machines internal rate of return round discount

scalias cleaning service is investigating the purchase of an ultrasound machine for cleaning window blinds. the machine

  Jonas lumber company owns a 16660-acre tract of timber

jonas lumber company owns a 16660-acre tract of timber purchased in 2005 at a cost of 3094 per acre. at the time of

  What are the items that should be included as inventory

One of the most important problems in dealing with inventory is the amount at which the inventory should be carried on the books. What are the items that should be included as inventory? Remember to consider purchase returns, purchase discounts, a..

  Comparability of the resulting financial statements

To what extent might companies' useof these different treatments reduce the comparability of the resulting financial statements?

  Finding correct consolidated statements

Giant produces consolidated financial statements to combine the two companies. Which of the following statements is correct about these consolidated statements?

  Fayes adjusted basis for the stock

Fifteen months later, he sells it to Faye for its fair market value of 39,000. Determine Iva's recognized loss, Joshua's recognized gain or loss, and Faye's adjusted basis for the stock.

  A prominent law firm that has more than 30 offices located

a prominent law firm that has more than 30 offices located worldwide is considering going to a cloud service for all of

  How does modified accrual basis of accounting differ acrual

What are the three sections of a comprehensive annual financial report (CAFR) What information is contained in each section How do the minimum requirements for general purpose external financial reporting related in scope to the CAFR

  Computing fair value of lll

The book value of LLL's assets and owners' equity before the acquisition were $50 million and $30 million, respectively. Compute the fair value of LLL's liabilities that Compton incurred in the acquisition.

  Sidman products common stock currently sells for 51 a share

sidman products common stock currently sells for 51 a share. the firm is expected to earn 6.10 per share this year and

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