Data regarding a company's operations follow: Sales are budgeted at $330,000 for November, $340,000 for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Data regarding a company's operations follow: • Sales are budgeted at $330,000 for November, $340,000 for December, and $320,000 for January. • Collections are expected to be 60% in the month of sale and 40% in the month following the sale. • The cost of goods sold is 80% of sales. • The company desires an ending merchandise inventory equal to 40% of the cost of goods sold in the following month. Payment for merchandise is made in the month following the purchase. The November beginning balance in the accounts receivable account is $68,000. • The November beginning balance in the accounts payable account is $255,000. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. Show each month individually. b. Prepare a Merchandise Purchases Budget for November and December. Show each month individually. Data regarding a company's operations follow: • Sales are budgeted at $330,000 for November, $340,000 for December, and $320,000 for January. • Collections are expected to be 60% in the month of sale and 40% in the month following the sale. • The cost of goods sold is 80% of sales. • The company desires an ending merchandise inventory equal to 40% of the cost of goods sold in the following month. Payment for merchandise is made in the month following the purchase. The November beginning balance in the accounts receivable account is $68,000. • The November beginning balance in the accounts payable account is $255,000. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. Show each month individually. b. Prepare a Merchandise Purchases Budget for November and December. Show each month individually.
Expert Answer:
Related Book For
Financial Accounting Tools for business decision making
ISBN: 978-0470534779
6th Edition
Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso
Posted Date:
Students also viewed these accounting questions
-
The expected sales for Uptown Clothing in the month of May are shown in the table below. Chelsea Rogers, the owner, gives credit to a select group of customers (20 percent of sales), but all others...
-
The expected sales for Uptown Clothing in the month of May are shown in the table below. Chelsea Rogers, the owner, gives credit to a select group of customers (20 percent of sales), but all others...
-
Consider the market for petrol. Which of the following changes would most likely lead to a decrease in supply? Group of answer choices (a) An increase in the price of petrol cars. (b) The cost of oil...
-
A car manufacturer designs a fuel-efficient car for 1993. The company argues that the car can attain an average of 45 miles per gallon. The miles per gallon of the car follows a normal distribution...
-
Fierce storms in October 2004 caused TomatoFest Organic Heirlooms Farm to end its tomato harvest two weeks early. According to Gary Ibsen, a partner in this small business (Carolyn Said, Tomatoes in...
-
1. Explain the objective of the capital asset pricing model 2. Explain the objective of the calculation of the break-even level per units/ revenues 3. When would you use the divisional WACC instead...
-
Which of the following financial statement assertions are addressed by testing the cutoff for plant asset additions? a. Existence and rights. b. Valuation or allocation. c. Completeness and...
-
Record in T accounts the following stock transactions of Pigua Corporation, which represent all the companys treasury stock transactions during 2011: May 5Purchased 1,600 shares of its own $2 par...
-
A machine costing $207,800 with a four-year life and an estimated $17,000 salvage value is installed in Luther Company's factory on January 1. The factory manager estimates the machine will produce...
-
The results below are based on data collected as part of a student project for an introductory statistics class at UF. If there is more than one group/treatment, the first group mentioned is group 1....
-
The Chuma Ngumu Company needs to finance a seasonal rise in inventories of Sh.4 million. The funds are needed for six months. The company is considering using the following possibilities to finance...
-
A cylinder fitted with a movable piston contains \(1 \mathrm{~kg}\) of steam at an initial pressure of \(6 \mathrm{bar}\) and of volume \(0.26 \mathrm{~m}^{3}\). Determine the dryness fraction of...
-
What are dividend reinvestment plans. What are their advantages and disadvantages from both stockholders and firms perspectives?
-
Describe the steps in the VC investment process (Figure 3. 8). FIGURE 3.8 The VC investment process Year 0 Secure commitments from investors Development of Fund Concept Closing of Fund First capital...
-
On 1 January 2022, S Aravena commenced business with bank $5000, GST receivable $1000 and computer $10 000. By the end of May 2022 the business had expanded and S Aravena found it necessary to put in...
-
The financial report from a small college shows the following expenses: Draw a circle graph showing this income. Salaries Academic Plant operations Student activities Athletic programs TOTAL...
-
K, for HCIO, is 3.5 x10. Calculate K, for CIO?
-
MgO prevents premature evaporation of Al in a furnace by maintaining the aluminum as Al2O3. Another type of matrix modifier prevents loss of signal from the atom X that readily forms the molecular...
-
Strawn Corporation had these transactions during 2012. (a) Purchased a machine for $30,000, giving a long-term note in exchange. (b) Issued $50,000 par value common stock for cash. (c) Issued...
-
On December 31, 2011, Maxell Associates owned the following securities that are held as long-term investments. On this date, the total fair value of the securities was equal to its cost. The...
-
Condensed balance sheet and income statement data for Sievert Corporation are presented here and on the next page. InstructionsCompute these values and ratios for 2011 and 2012.(a) Earnings per...
-
A dynamic absorber is to be designed to eliminate the vibration at coordinate \(x_{1}\) for the system shown in Fig. P5.6, where the excitation frequency is \(400 \mathrm{rad} / \mathrm{s}\) and the...
-
After installation, it was found that a particular machine exhibited excessive vibration due to a harmonic excitation force with a frequency of \(100 \mathrm{~Hz}\). A dynamic absorber was designed...
-
Given the eigenvalues and eigenvectors for the two degree of freedom system shown in Fig. P5.9, complete the following. \[\begin{array}{ll} s_{1}^{2}=-1 \times 10^{6} \mathrm{rad} / \mathrm{s}^{2} &...
Study smarter with the SolutionInn App