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 5,000 $ 800,000 4,000 $ 640,000 4,400 $ 704,000 All sales are on credit. Collections are as follows: 26% is collected in the month of the sale, and the remaining 74% 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 24% 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 $127,000 per month are paid in cash. The company's minimum cash balance at month-end is $110,000. Loans are obtained at the end of any month when the preliminary cash balance is below $110,000. Any preliminary cash balance above $110,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 $110,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 $332,640. 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 cash budget for June and July, including any loan activity and interest expense. Compute the loan balance at the end of each month. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your answers to the nearest whole dollars.) Beginning cash balance Add: Cash receipts from sales Total cash available Less: Cash payments for: AZTEC COMPANY Cash Budget June and July June July $ 110,000 $ 110,000 492,160 758,400 602,160 868,400 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 5,000 $ 800,000 4,000 $ 640,000 4,400 $ 704,000 All sales are on credit. Collections are as follows: 26% is collected in the month of the sale, and the remaining 74% 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 24% 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 $127,000 per month are paid in cash. The company's minimum cash balance at month-end is $110,000. Loans are obtained at the end of any month when the preliminary cash balance is below $110,000. Any preliminary cash balance above $110,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 $110,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 $332,640. 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 cash budget for June and July, including any loan activity and interest expense. Compute the loan balance at the end of each month. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your answers to the nearest whole dollars.) Beginning cash balance Add: Cash receipts from sales Total cash available Less: Cash payments for: AZTEC COMPANY Cash Budget June and July June July $ 110,000 $ 110,000 492,160 758,400 602,160 868,400
Expert Answer:
Answer rating: 100% (QA)
To prepare the cash budget for June and July we need to consider the cash receipts from sales cash payments for merchandise purchases and other cash p... 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
-
Calligraphy Pens is deciding when to replace its old machine. The machine's current salvage value is $ 3 , 0 0 0 , 0 0 0 . Its current book value is $ 1 , 7 7 5 , 0 0 0 . If not sold, the old machine...
-
Cher bought a home 30 years ago and lived in it up until December 21, 2021. At that time, she rented the house out until she sold it on January 15, 2023. She took no depreciation on the home during...
-
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,...
-
How can staff review the effectiveness of their work, the services they provide and the social and cultural factors impacting on clients, groups or communities?
-
Explain the combined effects of these events on Canadian real GDP and the price level, starting from a position of long-run equilibrium. The following events have occurred in the history of Canada: ...
-
A manufacturer of integrated circuits is planning production for the next four months. The forecast demand for the circuits is shown in the following table. At the beginning of September, the...
-
Assume the following information: Given this information, is triangular arbitrage possible? If so, explain the steps that would reflect triangular arbitrage, and compute the profit from this strategy...
-
One mechanic services 5 drilling machines for a steel plate manufacturer. Machines break down on an average of once every 6 working days, and breakdowns tend to follow a Poisson distribution. The...
-
Evaluate the dethite integral 2 $ C5 x-4x+8) dx C E
-
Plz answer with the same table format PA13-6 (Algo) Using Ratlos to Compare Loan Requests from Two Companles [LO 13-4, LO 13-5, LO 13-6] The financial statements for Royale and Cavaller companles are...
-
What is the tactical or strategic purpose of: (a) short-term forecasts; (b) medium-term forecasts; (c) long-term forecasts?
-
What are some other important differences between manual and computer accounting systems?
-
Nova Land Development Corporation is a closely held corporation engaged in purchasing large tracts of land, subdividing the tracts, and installing paved streets and utilities. The corporation does...
-
Describe how to print a report in QuickBooks Accountant.
-
If a company loses a potential major order, what should sales management do to alleviate the risk of this happening again?
-
An acquaintance offers you an investment opportunity. If you invest $27,000 right now, you will enjoy annual cash flows for the next four years, followed by your share of the proceeds--$30,000--when...
-
Assume today is the 21st of February. Using the information below, FT Extract, answer the following questions (parts i and ii). You work for a US company that is due to receive 250 million in June...
-
What difference has the introduction of a comprehensive income statement made to U.S. accounting for foreign exchange?
-
Why do you think it has been so difficult for accounting regulators to deal with accounting for foreign exchange over the last twenty-five years?
-
Choose a country and prepare a report on its foreign exchange risk. How do you think accountants should deal with this?
Study smarter with the SolutionInn App