Esquire Products Inc. expects the following monthly sales:

January

\(28,000

February

\)19,000

March

\(12,000

April

\)14,000

May

\(8,000

June

\)6,000

July

\(22,000

August

\)26,000

September

\(29,000

October

\)34,000

November

\(42,000

December

\)24,000

Total annual sales

\(264,000

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.

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.

Short Answer

Expert verified

The cash payment per monthis $18,400.

Step by step solution

01

Meaning of cash payments

The cash payment refers to the money paid by the organization for its expenditures. These payments result in a decrease in cash balance and the decrease in accounts payables of the organization.

02

Cash payments schedule

Month

January

February

March

April

May

June

11,000 units X $1

$11,000

$11,000

$11,000

$11,000

$11,000

$11,000

Other cash payments

$7,400

$7,400

$7,400

$7,400

$7,400

$7,400

Total cash payments

$18,400

$18,400

$18,400

$18,400

$18,400

$18,400

Month

July

August

September

October

November

December

11,000 units X $1

$11,000

$11,000

$11,000

$11,000

$11,000

$11,000

Other cash payments

$7,400

$7,400

$7,400

$7,400

$7,400

$7,400

Total cash payments

$18,400

$18,400

$18,400

$18,400

$18,400

$18,400

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Henderson Office Supply is considering a more liberal credit policy to increase sales, but expects that 9 percent of the new accounts will be uncollectible. Collection costs are 6 percent of new sales, production and selling costs are 74 percent, and accounts receivable turnover is four times. Assume income taxes of 20 percent and an increase in sales of $65,000. No other asset build-up will be required to service the new accounts.

a. What is the level of accounts receivable to support this sales expansion?

Neon Light Company of Kansas City ships lamps and lighting appliances throughout the country. Ms. Neon has determined that through the establishment of local collection centers around the country, she can speed up the collection of payments by three days. Furthermore, the cash management department of her bank has indicated to her that she can defer her payments on her accounts by one-half day without affecting suppliers. The bank has a remote disbursement center in Florida.

c. If the total cost of the new system is $400,000, should it be implemented?

Esquire Products Inc. expects the following monthly sales:

January

\(28,000

February

\)19,000

March

\(12,000

April

\)14,000

May

\(8,000

June

\)6,000

July

\(22,000

August

\)26,000

September

\(29,000

October

\)34,000

November

\(42,000

December

\)24,000

Total annual sales

\(264,000

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.

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 per unit.

Orbital Communications has operating plants in over 100 countries. It also keeps funds for transactions purposes in many foreign countries. Assume in 2010 it held 150,000 kronas in Norway worth \(40,000. The funds drew 13 percent interest, and the krona increased 6 percent against the dollar. What is the value of the holdings, based on U.S. dollars, at year-end?

(Hint: Multiply \)40,000 times 1.13 and then multiply the resulting value by 106 percent.)

Guardian Inc. is trying to develop an asset financing plan. The firm has \(400,000 in temporary current assets and \)300,000 in permanent current assets. Guardian also has $500,000 in fixed assets. Assume a tax rate of 40 percent.

c. What would happen if the short- and long-term rates were reversed?

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free