# Question: Esquire Products Inc expects the following monthly sales

Esquire Products Inc. expects the following monthly sales:

Cash sales are 40 percent in a given month, with the remainder going into accounts receivable. All receivables are collected in the month following the sale. Esquire sells all of its goods for $2 each and produces them for $1 each. Esquire uses level production, and average monthly production is equal to annual production divided by 12.

a. Generate a monthly production and inventory schedule in units. Beginning inventory in January is 12,000 units.

b. Determine a cash receipts schedule for January through December. Assume that dollar sales in the prior December were $20,000. Work part b using dollars.

c. Determine a cash payments schedule for January through December. The production costs ($1 per unit produced) are paid for in the month in which they occur. Other cash payments (besides those for production costs) are $7,400 per month.

d. Construct a cash budget for January through December using the cash receipts schedule from part b and the cash payments schedule from part c. The beginning cash balance is $3,000, which is also the minimum desired.

e. Determine total current assets for each month. Include cash, accounts receivable, and inventory. Accounts receivable equal sales minus 40 percent of sales for a given month. Inventory is equal to ending inventory (part a) times the cost of $1 perunit.

Cash sales are 40 percent in a given month, with the remainder going into accounts receivable. All receivables are collected in the month following the sale. Esquire sells all of its goods for $2 each and produces them for $1 each. Esquire uses level production, and average monthly production is equal to annual production divided by 12.

a. Generate a monthly production and inventory schedule in units. Beginning inventory in January is 12,000 units.

b. Determine a cash receipts schedule for January through December. Assume that dollar sales in the prior December were $20,000. Work part b using dollars.

c. Determine a cash payments schedule for January through December. The production costs ($1 per unit produced) are paid for in the month in which they occur. Other cash payments (besides those for production costs) are $7,400 per month.

d. Construct a cash budget for January through December using the cash receipts schedule from part b and the cash payments schedule from part c. The beginning cash balance is $3,000, which is also the minimum desired.

e. Determine total current assets for each month. Include cash, accounts receivable, and inventory. Accounts receivable equal sales minus 40 percent of sales for a given month. Inventory is equal to ending inventory (part a) times the cost of $1 perunit.

**View Solution:**## Answer to relevant Questions

Using the expectations hypothesis theory for the term structure of interest rates, determine the expected return for securities with maturities of two, three, and four years based on the following data. Do an analysis ...What is meant by hedging in the financial futures market to offset interest rate risks?Your bank will lend you $4,000 for 45 days at a cost of $50 interest. What is your effective rate of interest?Maxim Air Filters Inc. plans to borrow $300,000 for one year. Northeast National Bank will lend the money at 10 percent interest and requires a compensating balance of 20 percent. What is the effective rate of interest?Mr. Hugh Warner is a very cautious businessman. His supplier offers trade credit terms of 3/15, net 85. Mr. Warner never takes the discount offered, but he pays his suppliers in 75 days rather than the 85 days allowed so he ...Post your question