4 Exercise 20-27A (Algo) Merchandising: Preparing a cash budget LO P4 0.75 points eBook Hint Print...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66596bbc60f69_31566596bbbf0a7a.jpg)
Transcribed Image Text:
4 Exercise 20-27A (Algo) Merchandising: Preparing a cash budget LO P4 0.75 points eBook Hint Print Use the following information to prepare the July cash budget for Acco Company. Ignore the "Loan activity" section of the budget a. Beginning cash balance on July 1: $71,000. b. Budgeted cash receipts from sales: 30% is collected in the month of sale, 50% in the next month, and 20% in the second month after sale. Sales amounts are May (actual), $1,749.000; June (actual), $1,470,000; and July (budgeted), $1,590,000. c. Budgeted cash payments on merchandise purchases: 70% in the month of purchase and 30% in the month following purchase. Purchase amounts are June (actual), $470,000; and July (budgeted), $520,000. d. Budgeted cash payments for salaries in July: $240,000. e. Budgeted cash payments for sales commissions for July: $170,000. f. Budgeted cash payment for income taxes in July: $100,000. g. Budgeted cash payment for loan interest in July: $9,000. Complete this question by entering your answers in the tabs below. References Calculation Cash Budget Calculate the budgeted cash receipts and cash payments. Total Sales May Calculation of Cash Receipts from Sales -Collected in- June July 31 July Accounts Receivable Credit sales from May $ 1,740,000 $ 522,000 $ 870,000 $ 348,000 $ 0 June 1,470,000 441000 735,000 294,000 0 July 1,590,000 477.000 795,000 318,000 0 Totals $ 4,800,000 $ 1,440,000 $ 2,400,000 $ 060,000 $ 4 Exercise 20-27A (Algo) Merchandising: Preparing a cash budget LO P4 0.75 points eBook Hint Print Use the following information to prepare the July cash budget for Acco Company. Ignore the "Loan activity" section of the budget a. Beginning cash balance on July 1: $71,000. b. Budgeted cash receipts from sales: 30% is collected in the month of sale, 50% in the next month, and 20% in the second month after sale. Sales amounts are May (actual), $1,749.000; June (actual), $1,470,000; and July (budgeted), $1,590,000. c. Budgeted cash payments on merchandise purchases: 70% in the month of purchase and 30% in the month following purchase. Purchase amounts are June (actual), $470,000; and July (budgeted), $520,000. d. Budgeted cash payments for salaries in July: $240,000. e. Budgeted cash payments for sales commissions for July: $170,000. f. Budgeted cash payment for income taxes in July: $100,000. g. Budgeted cash payment for loan interest in July: $9,000. Complete this question by entering your answers in the tabs below. References Calculation Cash Budget Calculate the budgeted cash receipts and cash payments. Total Sales May Calculation of Cash Receipts from Sales -Collected in- June July 31 July Accounts Receivable Credit sales from May $ 1,740,000 $ 522,000 $ 870,000 $ 348,000 $ 0 June 1,470,000 441000 735,000 294,000 0 July 1,590,000 477.000 795,000 318,000 0 Totals $ 4,800,000 $ 1,440,000 $ 2,400,000 $ 060,000 $
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
8. Does the BAPCPA establish priorities for holders of unsecured nonpriority claims (i.e., general unsecured claims)?
-
Consider the system shown in Fig. 5.54. Block A weighs 45.0 N and block B weighs 25.0 N. Once block B is set into downward motion, it descends at a constant speed. (a) Calculate the coefficient of...
-
req 2. should they accept the offer? ONE Imperial Jewelers manufactures and sells a gold bracelet for $400.00. The company's accounting system says that the unit product cost for this bracelet is...
-
Star City is considering an investment in the community center that is expected to return the following cash flows. Use Exhibit A.8. Net Cash Flow Year 1 $ 21,000 2 51,000 81,000 4 81,000 101,000...
-
Using the figure below, draw the FBD , ?Shear Force and Bending Moment diagrams and find the maximum internal moment for the beam shown. 10 kNm 10 kN 3 m
-
Suppose the goods market is: Y = 1800 - 100i and the LM curve Y = 500 +591, where x is the last digit of your ID number. Determine the equilibrium income (Y), interest rate (i). Explain the role of...
-
Complete the chart: [1] Length, L (m) Period, T (s) LogL LogT 0.10 0.63 0.20 0.90 0.30 1.00 0.40 1.27 0.50 1.42 0.60 1.55 0.70 1.68 0.80 1.80 0.90 1.90 1.00 2.02 Plot the data T vs L. [4 (title, axes...
-
A solid metal sphere with a diameter of 2 cm and a mass of 8 g is used for the following heat transfer experiments. You can assume the temperature throughout the inside of the metal sphere is...
-
2) A car 1200 kg is in a skid Force of friction 3200N and force of air resistance 1600N. Find the following i) The net force and acceleration of the car ii) The time required to stop from 95 km/hr...
-
Un monopolista asigna Q unidades en dos mercados (mercado uno y mercado dos) en donde E1 = - 4 y E2 = - 5; En cual de los dos mercados sera el precio mas bajo?
-
Use pivot tables to compute the mean years of education for job category by ethnic minority.
-
In Table 11.28 the incidence of crime in a country is displayed. Calculate the row per cents and interpret the table. Is there any association between the crime and the region where the crime was...
-
Using the data in the file employe.xls compare the educational levels of whether or not someone is in a minority.
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App