Aztec Company sells its product for $170 per unit. Its actual and budgeted sales follow. May...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Aztec Company sells its product for $170 per unit. Its actual and budgeted sales follow. May (Actual) June (Budget) July (Budget) August (Budget) 2,000 6,000 5,000 3,900 $ 340,000 $ 850,000 $ 1,020,000 $ 663,000 Sales units Sales dollars 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 $113,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.5% monthly interest rate. On May 31, the loan balance is $34,000, 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 $308,000. 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.) Aztec Company sells its product for $170 per unit. Its actual and budgeted sales follow. May (Actual) June (Budget) July (Budget) August (Budget) 2,000 6,000 5,000 3,900 $ 340,000 $ 850,000 $ 1,020,000 $ 663,000 Sales units Sales dollars 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 $113,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.5% monthly interest rate. On May 31, the loan balance is $34,000, 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 $308,000. 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.)
Expert Answer:
Related Book For
Accounting Information Systems basic concepts and current issues
ISBN: 978-0078025334
3rd edition
Authors: Robert Hurt
Posted Date:
Students also viewed these accounting questions
-
How did the company reward you for taking on this assignment? What benefits did you gain or lose? Initial post - Since your imaginary boss has relocated you and you negotiated a good deal, how has...
-
Analyze the internal environment of the company you researched to determine that company's strengths and weaknesses. Based on the strengths and weaknesses you discovered, determine what steps the...
-
Determine whether the integral is divergent or convergent. If it is convergent, evaluate it. it diverges to infinity, state your answer as "oo" (without the quotation marks). If it diverges to...
-
Assume Pelican Corp has a current Beta is 0.65 and no debt. Management wants to increase their debt load which will result in a debt/equity ratio of 0.20 Given this change, what is the new,...
-
An Internet survey of 545 Hong Kong residents suggested that close daily monitoring of volatile financial affairs may not be good for your mental health (J. Social and Clinical Psychology 2002: 21:...
-
What is a. A 10-K? b. A 10-Q? c. An 8-Ke
-
What are the differences between judicial and nonjudicial arbitration?
-
Pam Corporation holds 70 percent ownership of Northern Enterprises. On December 31, 20X6, Northern paid Pam $40,000 for a truck that Pam had purchased for $45,000 on January 1, 20X2. The truck was...
-
Assume that a share of common stock has just paid a dividend of $1.50, and that this dividend is expected to grow ata. constant growth rate of 6.0 percent each year. Also assume that the expected...
-
Create a Strategic Plan for a Coastal Medical Center. Include the following components in your strategic plan: Introduction An overview of the organization/system SWOT Analysis Market trends...
-
Suppose you want to borrow $95,000 and you find a bank offering a 20 year loan with an APR of 5%. A. Find your regular payment if you pay n=1, 12, 26, 52 times a year. B. Compute the total payout for...
-
Use a diagram of a competitive labor market to compare the equilibrium effects and incidence of a per-unit tax on earnings when the buyer of the labor services is competitive compared to when it is a...
-
Every few months, The Economist publishes its Big Mac Index. Using the current exchange rates, it compares the U.S.-dollar price of Big Macs in several countries. It then concludes that countries in...
-
The diagram below shows the demand for foreign currency and the supply of foreign currency. The equilibrium exchange rate is e * . a. Suppose the Bank of Canada decides to fix the exchange rate at e...
-
What are the ways to test the difference between the means when the population is not normally distributed?
-
What is Financial Marketing Theory?
-
Part A Billiard ball A of mass m = 0.123 kg moving with speed VA = 2.80 m/s strikes ball B, initially at rest, of mass mB = 0.145 kg. As a result of the collision, ball A is deflected off at an angle...
-
Why do CPA firms sometimes use a combination of positive and negative confirmations on the same audit?
-
In each independent case situation below, construct a REA model and a database structure. a. Toms Trailers. Tom owns a small recreational trailer business in a suburban community located close to the...
-
Indicate whether each of the following statements is (i) Always true, (ii) Sometimes true, or (iii) Never true. For those that are (ii) Sometimes true, explain when the statement is true. a. The...
-
a. In addition to internal audits, what other kinds of audits do accounting professionals commonly perform? b. How are the various types of audits similar to one another? How are they different? c....
-
Suggest a general outline marketing planning strategy for 12 months ahead for Graham Keddie.
-
What part should the sales function play when drawing up a detailed 12 months operational marketing plan for EMA?
-
Explain the differences between marketing strategies and sales strategies.
Study smarter with the SolutionInn App