Business, 24.05.2021 14:00 SoccerHalo

Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Units Dollars
April (actual) 5,000 $800,000
May (actual) 2,400 384,000
June (budgeted) 5,500 880,000
July (budgeted) 4,500 879,000
August (budgeted) 3,600 576,000

All sales are on credit. Recent experience shows that 26% of credit sales is collected in the month of the sale, 44% in the month after the sale, 26% in the second month after the sale, and 4% proves to be uncollectible. The product’s purchase price is $110 per unit. 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 24% of the next month’s unit sales plus a safety stock of 95 units. The April 30 and May 31 actual inventory levels are consistent with this policy. Selling and administrative expenses for the year are $1,440,000 and are paid evenly throughout the year in cash. The company’s minimum cash balance at month-end is $110,000. This minimum is maintained, if necessary, by borrowing cash from the bank. If the balance exceeds $110,000, the company repays as much of the loan as it can without going below the minimum. This type of loan carries an annual 11% interest rate. On May 31, the loan balance is $44,500, and the company’s cash balance is $110,000.

Required:
a. Prepare a schedule that shows the computation of cash collections of its credit sales (accounts receivable) in each of the months of June and July.
b. Prepare a cash budget for June and July, including any loan activity and interest expense. Compute the loan balance at the end of each month.

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 21:30

Alandowner entered into a written agreement with a real estate broker whereby the broker would receive a commission of 10% of the sale price if he procured a "ready, willing, and able buyer" for the landowner's property and if the sale actually proceeded through closing. the broker found a buyer who agreed in writing to buy the property from the landowner for $100,000, the landowner's asking price. the buyer put up $6,000 as a down payment. the agreement between the landowner and the buyer contained a liquidated damages clause providing that, if the buyer defaulted by failing to tender the balance due of $94,000 at the closing date, damages would be 10% of the purchase price. the landowner included that clause because she was counting on using the proceeds of the sale for a business venture that would likely net her at least $10,000. the buyer became seriously ill and defaulted. when he recovered, he demanded that the landowner return his $6,000, and the landowner refused. the broker also demanded the $6,000 from the landowner and was refused. the broker and the buyer filed separate suits against the landowner, with the buyer pleading impossibility of performance. the two cases are consolidated into a single case. how should the court rule as to the disposition of the $6,000?

Answers: 3

Answer

Business, 22.06.2019 00:30

Salty sensations snacks company manufactures three types of snack foods: tortilla chips, potato chips, and pretzels. the company has budgeted the following costs for the upcoming period: 1 factory depreciation $33,782.00 2 indirect labor 84,456.00 3 factory electricity 8,446.00 4 indirect materials 40,356.00 5 selling expenses 26,900.00 6 administrative expenses 17,200.00 7 total costs $211,140.00 factory overhead is allocated to the three products on the basis of processing hours. the products had the following production budget and processing hours per case: budgeted volume (cases) processing hours per case tortilla chips 3,600 0.25 potato chips 5,300 0.11 pretzels 2,300 0.49 total 11,200 required: a. determine the single plantwide factory overhead rate.* b. use the factory overhead rate in (a) to determine the amount of total and per-case factory overhead allocated to each of the three products under generally accepted accounting principles. refer to the amount descriptions list provided for the exact wording of the answer choices for text entries.* * if required, round your answers to the nearest cen

Answers: 1

Answer

Business, 22.06.2019 09:00

Your grandmother told you a dollar doesn't go as far as it used to. she says the purchasing power of a dollar is much lesser than it used to be. explain what she means. try and use and explain terms like inflation and deflation in your answer.

Answers: 1

Answer

Business, 22.06.2019 14:20

Anew 2-lane road is needed in a part of town that is growing. at some point the road will need 4 lanes to handle the anticipated traffic. if the city's optimistic estimate of growth is used, the expansion will be needed in 4 years and has a probability of happening of 40%. for the most likely and pessimistic estimates, the expansion will be needed in 8 and 15 years respectively. the probability of the pessimistic estimate happening is 20%. the expansion will cost $ 4.2 million and the interest rate is 8%. what is the expected pw the expansion will cost?

Answers: 1

Answer

You know the right answer?

Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Units Doll...

Questions