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

  Considerations related to current assets and liabilities

Please demonstrate your knowledge of current assets and liabilities by discussing: Dependencies between current assets and current liabilities either through balance creations or balance changes. Are there any special management considerations relate..

  What is the amount of income from continuing operationswhat

selected account balances from the adjusted trial balance for olinda corporation as of its calendar year end december

  Cal farms reported supplies expense of 1600000 this year

cal farms reported supplies expense of 1600000 this year. the supplies account decreased by 280000 during the year to

  Calistoga produce estimates bad debt expense at 030 of

calistoga produce estimates bad debt expense at 0.30 of credit sales. the company reported accounts receivable and

  Jason earned 10,200 while working for brown company

Jason earned 10,200 while working for Brown Company.

  Minor landscaping company is preparing its budget for the

minor landscaping company is preparing its budget for the first quarter of 2013. the next step in the budgeting process

  Depaulis furniture manufacturers makes unfinished furniture

depaulis furniture manufacturers makes unfinished furniture for sale to customers from its own stores. recently the

  Finney co manufactures a product requiring two pounds of

finney co. manufactures a product requiring two pounds of direct material. during 2011 finney purchases 24000 pounds of

  Dane cosmetics is evaluating a new fragrance-mixing machine

dane cosmetics is evaluating a new fragrance-mixing machine. the machine requires an initial investment of 24000 and

  Twenty thousand shares reacquired by sierra land inc for

twenty thousand shares reacquired by sierra land inc. for 153 per share were exchanged for land that has an appraised

  Michael inc uses a process-costing system a newly hired

michael inc. uses a process-costing system. a newly hired accountant has identified the following procedures that must

  Managers in foreign countries for national companies

What individual characteristics and qualifications should a company consider when choosing managerial candidates for foreign assignments?

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