Prepare a schedule to compute expected cash collections

Reference no: EM131083020

1. Renson Corporation, a wholesaler, provided you with the following information:

Month	Merchandise Purchases	Sales
January	$ 142,000	$ 172,000
February	148,000	166,000
March	136,000	165,000
April	154,000	178,000
May	160,000	166,000

Renson's expected pattern of cash collections:

60% - collected in the month of the sale

30% - collected in the month after the sale

10% - collected in the second month after the sale

Renson pays all of its invoices in the month following the purchase and takes advantage of all available early payment discounts.

Available discount for early payment - 3%

Remson's expected payments in May for operating expenses - $119,000

Remson's actual cash balance on May 1 - $127,000

Required:

A. Prepare a schedule to compute expected cash collections for the month of May.

B. Prepare a schedule to compute expected cash payments for the month of May.

C. Prepare a schedule to the compute expected balance on May 31.

2. Santori Corporation has recently experienced a number of out-of-stock situations because of inadequate inventory levels. Here in information about their inventory levels and their budgeted sales:

Month	Ending Inventory (units)	Budgeted Sales (units)
May	50
June		5,000
July		5,600
August		5,500

Inventory Policy: Ending inventory each month as percent of next month's sales: 20%.

Required: Determine the number of units that Santori must produce during the month of June, and the number of units Santori must produce during the month of July, in order to maintain the desired inventory levels at the end of each of those two months.

Reference no: EM131083020

Questions Cloud

Current total carrying costs and economic order quantity : The Trektronics store begins each week with 240 phasers in stock. This stock is depleted each week and reordered. The carrying cost per phaser is $29 per year and the fixed order cost is $51. What are the current total carrying costs? What is the eco..

A brief research-based statement of your personal philosophy : A proposal of how the health care model articulated above can be operationalized in a real-world setting.

Integrated marketing communications brief : Please select a brand that has a brand problem. For example, recent player legal troubles have been a problem for the NFL brand. Another example is the Bonefish Grill, the country's second largest seafood chain after Red Lobster. Although their ch..

Lockbox system to reduce the firms collection times : It takes Cookie Cutter Modular Homes, Inc., about six days to receive and deposit checks from customers. Cookie Cutter’s management is considering a lockbox system to reduce the firm’s collection times. What is the maximum monthly charge Cookie Cutte..

Prepare a schedule to compute expected cash collections : Prepare a schedule to compute expected cash collections for the month of May and Prepare a schedule to compute expected cash payments for the month of May

Meeting of equity shareholders : Equity Company and Faye enter into a contract for Faye to cater a meeting of Equity's shareholders. When Faye's schedule conflicts, she asks Gudren to serve Faye's coffee and pastries at the meeting. This transfer of duties is

Compute the employers liability for unemployment taxes : You will now compute the employer's liability for unemployment taxes (FUTA and SUTA) for the pay of January 14. These computations will be used at the end of Chapter 6 in recording the payroll tax entries.

Average collection-what is effective cost of borrowing : Your firm has an average collection period of 23 days. Current practice is to factor all receivables immediately at a discount of 1.3 percent. What is the effective cost of borrowing in this case?

Provide company information and type of projects : 1) Please provide company information and type of projects you are part of. 2) Your role in the project?

User Account

All Pages