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:00

Identify the accounting assumption or principle that is described below. (a) select the accounting assumption or principle is the rationale for why plant assets are not reported at liquidation value. (note: do not use the historical cost principle.) (b) select the accounting assumption or principle indicates that personal and business record-keeping should be separately maintained. (c) select the accounting assumption or principle assumes that the dollar is the "measuring stick" used to report on financial performance. (d) select the accounting assumption or principle separates financial information into time periods for reporting purposes. (e) select the accounting assumption or principle measurement basis used when a reliable estimate of fair value is not available. (f) select the accounting assumption or principle dictates that companies should disclose all circumstances and events that make a difference to financial statement users.

Answers: 3

Answer

Business, 21.06.2019 22:40

Gyou plan to deposit $1,700 per year for 5 years into a money market account with an annual return of 2%. you plan to make your first deposit one year from today. what amount will be in your account at the end of 5 years? round your answer to the nearest cent. do not round intermediate calculations. $ assume that your deposits will begin today. what amount will be in your account after 5 years? round your answer to the nearest cent. do not round intermediate calculations.

Answers: 2

Answer

Business, 22.06.2019 00:00

Exercise 4-6 the following balances were taken from the books of alonzo corp. on december 31, 2017. interest revenue $86,000 accumulated depreciationâ€”equipment $40,000 cash 51,000 accumulated depreciationâ€”buildings 28,000 sales revenue 1,380,000 notes receivable 155,000 accounts receivable 150,000 selling expenses 194,000 prepaid insurance 20,000 accounts payable 170,000 sales returns and allowances 150,000 bonds payable 100,000 allowance for doubtful accounts 7,000 administrative and general expenses 97,000 sales discounts 45,000 accrued liabilities 32,000 land 100,000 interest expense 60,000 equipment 200,000 notes payable 100,000 buildings 140,000 loss from earthquake damage 150,000 cost of goods sold 621,000 common stock 500,000 retained earnings 21,000 assume the total effective tax rate on all items is 34%. prepare a multiple-step income statement; 100,000 shares of common stock were outstanding during the year. (round earnings per share to 2 decimal places, e.g. 1.48.)

Answers: 2

Answer

Business, 22.06.2019 10:40

At cooly cola, we are testing the appeal of our new diet one cola. in a taste test of 250 randomly chosen cola drinkers, 200 consumers preferred diet one cola to the leading brand. assuming that the sample were large enough, the large-sample 95% confidence interval for the population proportion of cola drinkers that prefer diet one cola would be:

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