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
-
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...
-
Although EEOC and court decisions have not always clearly defined religious discrimination in the workplace, two principles have evolved. Identify them.
-
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...
-
Are the reasons that nascent entrepreneurs offer for starting businesses different than the reasons that other people give for their career choices?
-
Are individual stocks exposed to currency risk? Does currency risk affect required returns?
-
Gruner Company accumulates the following data concerning a proposed capital investment: cash cost \($280,000\), annual cash inflow \($50,000\), present value factor of cash inflows for 10 years 5.65...
-
Commodity Copper is considering the installation of a $ 1,800,000 production conveyor system that would generate the following labor cost savings over its 10-year life: Years Annual Labor Cost...
-
Sandy Bank, Incorporated, makes one model of wooden canoe. Partial information is given below. Required: Complete the following table. # of Canoes Produced and Sold 400 600. 700 Total Costs: Variable...
-
(a) Show that the standard normal density function (x) is sym- metric about x = 0. That is, show (x) = (x). (b) Show that (x | ,) is maximized in x at x = . That is, the normal mean is also the mode....
-
Explain the significance of the Sabatier principle in guiding the design of catalysts with optimal binding energies for intermediates, and discuss its implications for catalytic efficiency .
-
Ross Plants Wholesalers contracts with Bi-Mart, Inc. for the sale of 24 pallets of fresh herbs and shrubs, to be delivered f.o.b. to Bi-Mart in Emmett, Idaho. The 24 pallets are identified and put on...
-
Explain how a company could: (a) avoid a backlog of orders when sales exceed expectations; (b) avoid product defects on new products; (c) offer more credit to its customers when it already has a bad...
-
How can you determine a firm's cost of equity capital? What is the relationship between the required return on an investment and the cost of capital associated with that investment?
-
The current dividend of Varad Limited is Rs 3.00 . Varad limited is expected to enjoy an above normal growth rate at 10 percent for a period of 3 years . Thereafter the growth rate will fall and...
-
Discuss, from critical perspectives, the extent to which organisational culture shapes employees' attitude and behaviour during organisational change. Please include your references in Harvard format
-
A woman at a point A on the shore of a circular lake with radius 2 mi wants to arrive at the point C diametrically opposite on the other side of the lake in the shortest possible A time. She can walk...
-
Antonio Rossi set up a part-time business on 1 November 2004 buying and selling second-hand sports cars. On 1 November 2004 he commenced business with $66,000 which he immediately used to purchase...
-
Why is it necessary for financial reporting to be subject to (a) mandatory control and (b) statutory control?
-
How is it possible to make shareholders aware of the significance of the exercise of judgement by directors which can turn profits of 6m into losses of 2m?
Study smarter with the SolutionInn App