Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Aztec Company sells its product for $150 per unit. Its actual and budgeted sales follow. May (Actual) June (Budget) July (Budget) August (Budget) Sales units

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

May (Actual) June (Budget) July (Budget) August (Budget)
Sales units 2,600 6,000 5,000 4,300
Sales dollars $ 390,000 $ 900,000 $ 750,000 $ 645,000

All sales are on credit. Collections are as follows: 28% is collected in the month of the sale, and the remaining 72% is collected in the month following the sale. Merchandise purchases cost $110 per unit. For those purchases, 60% is paid in the month of purchase and the other 40% is paid in the month following purchase. The company has a policy to maintain an ending monthly inventory of 18% of the next months unit sales. The May 31 actual inventory level of 1,080 units is consistent with this policy. Selling and administrative expenses of $160,000 per month are paid in cash. The companys minimum cash balance at month-end is $130,000. Loans are obtained at the end of any month when the preliminary cash balance is below $130,000. Any preliminary cash balance above $130,000 is used to repay loans at month-end. This loan has a 1.0% monthly interest rate. On May 31, the loan balance is $31,500, and the companys cash balance is $130,000. Required: 1. Prepare a schedule of cash receipts from sales for each of the months of June and July. 2. Prepare the merchandise purchases budget for June and July. 3. Prepare a schedule of cash payments for merchandise purchases for June and July. Assume Mays budgeted merchandise purchases is $353,320. 4. 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Successful Fundraising For Arts And Cultural Organizations

Authors: Carolyn S. Friedman, Karen B. Hopkins

2nd Edition

1573560294, 978-1573560290

More Books

Students also viewed these Finance questions