Capes Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: Sales are...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Capes Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: Sales are budgeted at $220,000 for November, $230,000 for December, and $210,000 for January. Collections are expected to be 55% in the month of sale and 45% in the month following the sale. The cost of goods sold is 70% of sales. • The company desires an ending merchandise inventory equal to 35% 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 $57,000. The November beginning balance in the accounts payable account is $244,000. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December. Required A Required B Prepare a Schedule of Expected Cash Collections for November and December. November Sales Schedule of Expected Cash Collections Accounts receivable November sales December sales Total cash collections 0 December 0 Required A Required B Prepare a Merchandise Purchases Budget for November and December. Merchandise Purchases Budget Cost of goods sold Total needs Required purchases November 69 0 0 December 0 0 Capes Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: Sales are budgeted at $220,000 for November, $230,000 for December, and $210,000 for January. Collections are expected to be 55% in the month of sale and 45% in the month following the sale. The cost of goods sold is 70% of sales. • The company desires an ending merchandise inventory equal to 35% 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 $57,000. The November beginning balance in the accounts payable account is $244,000. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December. Required A Required B Prepare a Schedule of Expected Cash Collections for November and December. November Sales Schedule of Expected Cash Collections Accounts receivable November sales December sales Total cash collections 0 December 0 Required A Required B Prepare a Merchandise Purchases Budget for November and December. Merchandise Purchases Budget Cost of goods sold Total needs Required purchases November 69 0 0 December 0 0
Expert Answer:
Answer rating: 100% (QA)
Schedule of Expected cash Particulars Accounts receivables Nov sales 220000 x 5... View the full answer
Related Book For
Supply Chain Focused Manufacturing Planning and Control
ISBN: 978-1133586715
1st edition
Authors: W. C. Benton
Posted Date:
Students also viewed these accounting questions
-
Write a brief memo to your immediate manager discussing why the study of supply chain-focused manufacturing planning and control is important in today's competitive manufacturing environment.
-
The sole shareholder of an S corporation should never be able to avoid liability for the torts of her or his employees. Explain
-
An analyst developed two scenarios with respect to the recovery of $100,000 principal from defaulted loans: The amount of the expected recovery is closest to: A. $36,400 B. $63,600 C. $81,600...
-
World Information Group has two major divisions: print and Internet. Summary financial data (in millions) for 2011 and 2012 are: The annual bonuses of the two division managers are based on division...
-
The loud music coming from the sorority next to your dorm is a negative externality that can be directly quantified. The accompanying table shows the marginal social benefit and the marginal social...
-
Recording Journal Entries Jimmy Langenberger is the president of TemPro, Inc., a company that provides temporary employees for not-for-profit companies. TemPro has been operating for five years; its...
-
With reference to Example 4. (a) verify the calculation of the tolerance bound \(L\); (b) if the confidence is decreased to \(90 \%\), calculate the new tolerance bound (use \(K=2.010)\) (c) check...
-
ABC is an electronic manufacturing company based in Singapore. It sells a wide rangeof products to markets in the Asian region. Currently, it has a sizeable IT division withthe following...
-
Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below:...
-
Excel worksheets to use for journal entries and t-accounts and also utilize Excel for trial balances and financial statements. Students are to complete journal entries for each month, including...
-
Most stable product of the following reaction is : OH (i) HC (ii) NaCN, DMF SOCl, Pyridine
-
In data compression, a set of strings is prefix-free if no string is a prefix of another. For example, the set of strings \(\{01,10,0010,1111\}\) is prefix-free, but the set of strings...
-
Write a program SubsetSum that reads 1ong integers from standard input, and counts the number of subsets of those integers that sum to exactly zero. Give the order of growth of the running time of...
-
Modify BST to add a method rangeSearch () that takes two keys as arguments and returns an iterable over all keys that are between the two given keys. The running time should be proportional to the...
-
Given an array of \(n\) real numbers, design a linear-time algorithm to find a pair of numbers that are furthest apart in value.
-
Modify BST to add methods \(\min ()\) and \(\max ()\) that return the smallest (or largest) key in the table (or nu17 if no such key exists).
-
Given the equations 2x + y = 1 and y = x + 7. Find the value of x - y.
-
The Adjusted Trial Balance columns of a 10-column work sheet for Webber Co. follow. Complete the work sheet by extending the account balances into the appropriate financial statement columns and by...
-
The manager of Pat's Organic Farm must make the annual purchasing plans for rakes, gloves, and other gardening items. One of the items the company stocks is Lean-feed for chickens. The sales of this...
-
No Tell Motel operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases bath soap for $5.65 per box. The following information is available about these...
-
Using the data below, develop a spreadsheet for finding the least-cost order quantities when there are quantity discounts (order cost = $60, inventory holding cost = 30 percent of item value, and...
-
Hannah Gilpin is the controller of Blakemore Auto Glass, a division of Eastern Glass and Window. Her division has been under pressure to improve its divisional operating income. Currently, divisions...
-
Key success factors. Dalworth Construction Company provides construction services for major projects. Managers at the company believe that construction is a people-management business, and they list...
-
How do companies add value, and what are the dimensions of performance that customers are expecting of companies?
Study smarter with the SolutionInn App