Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Sales units Sales dollars May (Actual) June (Budget) July (Budget) August (Budget) 2,400 $ 384,000 6,000 $ 960,000 5,000 $ 800,000 3,800 $ 608,000 All sales are on credit. Collections are as follows: 24 % is collected in the month of the sale, and the remaining 76% 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 20% of the next month's unit sales. The May 31 actual inventory level of 1,200 units is consistent with this policy. Selling and administrative expenses of $108,000 per month are paid in cash. The company's minimum cash balance at month-end is $120,000. Loans are obtained at the end of any month when the preliminary cash balance is below $120,000. Any preliminary cash balance above $120,000 is used to repay loans at month-end. This loan has a 0.0% monthly interest rate. On May 31, the loan balance is $39,500, and the company's cash balance is $120,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 May's budgeted merchandise purchases is $343,200. 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. Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Sales units Sales dollars May (Actual) June (Budget) July (Budget) August (Budget) 2,400 $ 384,000 6,000 $ 960,000 5,000 $ 800,000 3,800 $ 608,000 All sales are on credit. Collections are as follows: 24 % is collected in the month of the sale, and the remaining 76% 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 20% of the next month's unit sales. The May 31 actual inventory level of 1,200 units is consistent with this policy. Selling and administrative expenses of $108,000 per month are paid in cash. The company's minimum cash balance at month-end is $120,000. Loans are obtained at the end of any month when the preliminary cash balance is below $120,000. Any preliminary cash balance above $120,000 is used to repay loans at month-end. This loan has a 0.0% monthly interest rate. On May 31, the loan balance is $39,500, and the company's cash balance is $120,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 May's budgeted merchandise purchases is $343,200. 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.
Expert Answer:
Answer rating: 100% (QA)
Aztec Company Cash Budget Analysis 1 Schedule of Cash Receipts from Sales Month Cash Collections fro... View the full answer
Related Book For
Fundamental accounting principle
ISBN: 978-0078025587
21st edition
Authors: John J. Wild, Ken W. Shaw, Barbara Chiappetta
Posted Date:
Students also viewed these accounting questions
-
The two top companies that manufacture processors are Intel and AMD. There are many articles on the web that compare the processors. Choose two compatible processors, one from the Intel I-series (i3,...
-
Aztec Company sells its product for $ 180 per unit. Its actual and projected sales follow. All sales are on credit. Recent experience shows that 20% of credit sales is collected in the month of the...
-
Assume that self-esteem measurements are not affected by an interaction between subject self-esteem and target self-esteem. Is there sufficient evidence to support the claim that the category of the...
-
What is it about the given table that makes it a two-way table?
-
Determine the reactions at A and C when (a) = 0, (b) = 30. 800 mm 300 N 200 mm 300 N 200 mm at
-
What form of representation would you recommend for this new market or would you consider setting up a manufacturing subsidiary? Give reasons for your decision.
-
Uhura Resort opened for business on June 1 with eight air-conditioned units. Its trial balance on August 31 is as follows. Other data:1. The balance in prepaid insurance is a one-year premium paid on...
-
A car travels on a straight line level Road a starting from rest. The car is going 3 0 ft . / s ( 2 0 mi / h ) at the point of 4 . 5 seconds. What is the current average acceleration in foot per...
-
For the BlaBla Car Case study. 1) Has BlaBlaCar remained true to their values and mission, and in doing so have they reinforced their competitive position and sustainability? 2) Being now a scale-up...
-
Write a java program to print below pattern?
-
Was this a violation of the Computer Fraud and Abuse Act? Do you agree with ruling? Please give reasons for your decision. Since eBay granted permission for Bidder's Edge to use a crawler what was...
-
A 1000-ft long, 2-ft long diameter ductile iron pipeline connects two reservoirs. The elevation difference between the water level is 200 feet. The outside diameter of the pipe is 2.25 ft and can...
-
Your client Jessabelle, has two successful businesses. One as an exporter of timber and timber products internationally and the second as a ship owner who transports cargo internationally. Jessabelle...
-
1. What are 3 criteria a CBSA officer at a port of entry will look for to determine if a temporary visitor has the intention to leave Canada at the end of their stay? 2. Claude came to Canada from...
-
Answer the following questions. 1. Factors which influence the main distribution channels from manufacturing to retailers, then to customers 2. Illustrate the cost and service levels for each...
-
What is the shape of the exponential distribution?
-
What are the advantages of using stability approach over direct and analogy approach?
-
Examine Fowlers account pattern on following characteristics: a. Simplicity b. Generality c. Completeness d. Stability e. Visual and graphical model f. Testability
-
What is Fowlers account pattern? Explain with the help of a diagram.
Study smarter with the SolutionInn App