Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

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.

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.

Short Answer

Expert verified

The cash received in January is $23,200 and in December is $34,800.

Step by step solution

01

Formula used for calculating the monthly cash receipts

MonthlyCashreceipts=40%×Presentmonthsales+60%×Priormonthssales

02

Cash receipts schedule

Month

January

February

March

April

May

June

Sales

$28,000

$19,000

$12,000

$14,000

$8,000

$6,000

40% cash sales

$11,200

$7,600

$4,800

$5,600

$3,200

$2,400

60% prior month sales

$12,000

$16,800

$11,400

$7,200

$8,400

$4,800

Total cash receipts

$23,200

$24,400

$16,200

$12,800

$11,600

$7,200

Month

July

August

September

October

November

December

Sales

$22,000

$26,000

$29,000

$34,000

$42,000

$24,000

40% cash sales

$8,800

$10,400

$11,600

$13,600

$16,800

$9,600

60% prior month sales

$3,600

$13,200

$15,600

$17,400

$20,400

$25,200

Total cash receipts

$12,400

$23,600

$27,200

$31,000

$37,200

$34,800

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

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.

In Problem 12, assume the term structure of interest rates becomes inverted, with short-term rates going to 11 percent and long-term rates 5 percentage points lower than short-term rates. If all other factors in the problem remain unchanged, what will earnings after taxes be?

City Farm Insurance has collection centers across the country to speed up collections. The company also makes its disbursements from remote disbursement centers so the firm’s checks will take longer to clear the bank. Collection time has been reduced by two days and disbursement time increased by one day because of these policies. Excess funds are being invested in short-term instruments yielding 12 percent per annum.

a. If City Farm has \(5 million per day in collections and \)3 million per day in disbursements, how many dollars has the cash management system freed up?

Explain how rapidly expanding sales can drain the cash resources of a firm.

Gary’s Pipe and Steel Company expects sales next year to be \(800,000 if the economy is strong, \)500,000 if the economy is steady, and $350,000 if the economy is weak. Gary believes there is a 20 percent probability the economy will be strong, a 50 percent probability of a steady economy, and a 30 percent probability of a weak economy. What is the expected level of sales for next year?

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