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. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Prepare a schedule of cash receipts from sales for each of the months of June and July. 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. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Prepare a schedule of cash receipts from sales for each of the months of June and July.
Expert Answer:
Answer rating: 100% (QA)
Required 1 Schedule of Cash Receipts from Sales June Collections from May ... 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
-
Consider the case when the cost function satisfies C xe ( )=0. This can arise for different reasons. Consider the following two possibilities: (a) Suppose production and abatement costs (AC) are...
-
Why are men more likely to start businesses than women? What factors might account for this difference?
-
What is the physical reason for the fact that the chemical potential of a pure substance decreases as the temperatures is raised?
-
One study found that NBA teams with a high shared experience and a low turnover tended to have significantly better winloss records. Why?
-
Portal Corporation produces the same laser printer in two Utah plants, a new plant in Ogden and an older plant in Sandy. The following data are available for the two plants: All fixed costs per unit...
-
Question Industrial Adhesives manufactures and markets commercial grade petroleum-based Adhesives, through wholesalers in most cases, but also directly to several large clients. It is currently...
-
4 . A box contains a total of 1 0 0 CDs that were manufactured on two machines. The following table gives the number of defective and good CDs manufactured on these two machines. Defective Good Total...
-
What do you understand by the term social media marketing? Illustrate with an example.
-
YouGotThis LLC enters into a lease agreement on July 1, 2025, for equipment. YouGotThis LLC is the lessee. The following data are relevant to the lease agreement: 1. 2. 3. 4. The term of the...
-
What does each of these three groups (elected and appointed officials, managers and supervisors, and HR directors and specialists) contribute to public personnel management?
-
An investor has just taken a short position in a six-month forward contract on a dividend-paying stock. The stock price is 132.00, and the risk-free rate of interest is 3 | Page 6% per annum with...
-
Make sure to include your null and alternative hypothesis, your test statistic, your p-value, decision, and conclusion in the context in your response: A baseball team claims that30%of their fans...
-
Respond to the following: How might you use different types of research (focus groups, observation, survey, and experiment) to forecast market reaction to a new kind of disposable baby diaper?...
-
In the circuit shown in Figure 4, a battery supplies a constant voltage of 40 V, the inductance is 2 H, the resistance is 10, and l(0) = 0. (a) Find l(t). (b) Find the current after 0.1s.
-
Which one of the following can completely balance several masses revolving in different planes on a shaft? (a) A single mass in one of the planes of the revolving mass (b) A single mass in any one...
-
The curve traced by a point on the circumference of a circle which rolls along the inside of a fixed circle, is known as (a) epicycloid (b) hypocycloid (c) cardiod (d) involute.
-
Match List I with List II an select the correct answer using the codes given below the lists: List I A. Quadric cycle chain B. Single slider crank chain C. Double slider crank chain D. Crossed slider...
Study smarter with the SolutionInn App