Question

In: Accounting

Crew Clothing (CC) sells women’s resort casual clothing to high-end department stores and in its own...

Crew Clothing (CC) sells women’s resort casual clothing to high-end department stores and in its own retail boutiques. CC expects sales for January, February, and March to be $470,000, $530,000, and $550,000, respectively. Twenty percent of CC’s sales are cash, with the remainder collected evenly over two months. During December, CC’s total sales were $780,000. CC is beginning its budget process and has asked for your help in preparing the cash budget.

Compute CC’s expected cash receipts from customers for each month.

Solutions

Expert Solution

  • All working forms part of the answer
  • Working for cash sales and amount of credit sales to be collected.

50% of credit sale is collected in month of sale, 50% in following month.

December

January

February

March

Sales

$           7,80,000.00

$                 4,70,000.00

$                 5,30,000.00

$                  5,50,000.00

Cash sale 20%

$           1,56,000.00

$                    94,000.00

$                 1,06,000.00

$                  1,10,000.00

Credit Sale 80%

$           6,24,000.00

$                 3,76,000.00

$                 4,24,000.00

$                  4,40,000.00

50% of credit sale

$           3,12,000.00

$                 1,88,000.00

$                 2,12,000.00

$                  2,20,000.00

  • Requirement : Total cash collected

January

February

March

Cash Sale for the month

$               94,000.00

$                 1,06,000.00

$                 1,10,000.00

Add: Cash collected for credit sale happened in:

December

$           3,12,000.00

January

$           1,88,000.00

$                 1,88,000.00

February

$                 2,12,000.00

$                 2,12,000.00

March

$                 2,20,000.00

Total cash collected

$           5,94,000.00

$                 5,06,000.00

$                 5,42,000.00


Related Solutions

Pelican Stores Pelican Stores, a division of National Clothing, is a chain of women’s apparel stores...
Pelican Stores Pelican Stores, a division of National Clothing, is a chain of women’s apparel stores operating throughout the country. The chain recently ran a promotion in which discount coupons were sent to customers of other National Clothing stores. data collected for a sample of 100 in-store credit card transactions at Pelican Stores during one day while the promotion was running are contained in the file named PelicanStores. Table 2.19 shows a portion of the data set. The Proprietary Card...
Pelican Stores, a division of National Clothing, is a chain of women’s apparel stores operating throughout...
Pelican Stores, a division of National Clothing, is a chain of women’s apparel stores operating throughout the country. The chain recently ran a promotion in which discount coupons were sent to customers of other National Clothing stores. Data collected for a sample of 100 in-store credit card transactions at Pelican Stores during one day while the promotion was running are contained in the file named PelicanStores. The Proprietary Card method of payment refers to charges made using a National Clothing...
Following describes the credit sales procedures for clothing wholesaler that sells name-brand clothing to department stores...
Following describes the credit sales procedures for clothing wholesaler that sells name-brand clothing to department stores and boutique dress shops. The company sells to both one-time and recurring customers. A flowchart of the system is provided in the figure labeled Problem 5: Internal Control. Customer orders are received by fax and e-mail in the sales department. The sales clerk, who works on commission, approves the credit sale, calculates commissions and discounts, and records the sale in the sales journal from...
CASE 1:         BANKRUTCY On March 1, 2017, Vinson Stores, Inc. a owner of women’s clothing stores,...
CASE 1:         BANKRUTCY On March 1, 2017, Vinson Stores, Inc. a owner of women’s clothing stores, was petitioned into involuntary bankruptcy by several creditors under the provisions of Chapter 7 of the Federal Bankruptcy Code. Assets of the Corporation at that date were as follows: Cash and cash equivalents                                   $100,000 Accounts Receivable                                              80,000 Inventories                                                               140,000 Computer equipment                                                 55,000 Store equipment                                                      105,000 Land and Buildings                                                250,000 Liabilities: IRS 2011 Income taxes                                         15,000 Tom Davis (Manager)...
2. the cotton mill is an upscale chain of women’s clothing stores. Located in the southwestern...
2. the cotton mill is an upscale chain of women’s clothing stores. Located in the southwestern united states. Do to recent success, the cotton mill’s top management is planning to expand by locating new stores in other regions of the country. The director of planning has been asked to study the relationship between yearly sales and the store size. As part of the study, the director selects sample of 25 stores and determines the size of the store in square...
A national chain of women’s clothing stores with locations in the large shopping malls thinks that...
A national chain of women’s clothing stores with locations in the large shopping malls thinks that it can do a better job of planning more renovations and expansions if it understands what variables impact sales. It plans a small pilot study on stores in 25 different mall locations. The data it collects consist of monthly sales, store size (sq. ft), number of linear feet of window display, number of competitors located in mall, size of the mall (sq. ft),and distance...
A national chain of women’s clothing stores with locations in the large shopping malls thinks that...
A national chain of women’s clothing stores with locations in the large shopping malls thinks that it can do a better job of planning more renovations and expansions if it understands what variables impact sales. It plans a small pilot study on stores in 25 different mall locations. The data it collects consist of monthly sales, store size (sq. ft), number of linear feet of window display, number of competitors located in mall, size of the mall (sq. ft),and distance...
Once a pinnacle of luxury clothing found only in high-end fashion stores, by 2006 cashmere sweaters,...
Once a pinnacle of luxury clothing found only in high-end fashion stores, by 2006 cashmere sweaters, which typically sold for hundreds of dollars, could be found in big box stores for as little as $20. The reason for this substantial price drop: increased production and competition from China. The cashmere industry has been around for centuries. Historically, however, Chinese and Mongolian herders exported the raw fiber to Europe, where it was spun and converted into clothing. Beginning in the 1980’s,...
JackJoe, Inc. sells toy mice to high end pet stores. It was formed on Jan 1,...
JackJoe, Inc. sells toy mice to high end pet stores. It was formed on Jan 1, 20x4 with a sale of $1 par value common stock and the issuance of a Bond. Following is JackJoe's trial balance after the first year of operation, through December 1 20x4. This trial balance does not reflect the transactions that occurred during the last month of the year or adjustments that are necessary, as described by the additional information. The Bond payable was sold...
JackJoe, Inc. sells toy mice to high end pet stores. It was formed on Jan 1,...
JackJoe, Inc. sells toy mice to high end pet stores. It was formed on Jan 1, 20x4 with a sale of $1 par value common stock and the issuance of a Bond. Following is JackJoe's trial balance after the first year of operation, through December 1 20x4. This trial balance does not reflect the transactions that occurred during the last month of the year or adjustments that are necessary, as described by the additional information. The Bond payable was sold...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT