Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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. Prepare a cash receipts schedule for January through December. Assume that dollar sales in the prior December were $20,000.

c. Prepare 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. (Negative amounts should be indicated by a minus sign.)

e. Determine total current assets for each month. Include cash, accounts receivable, and inventory. The accounts receivable for a given month is equal to 60 percent of that month's sales. Inventory is equal to ending inventory (part a) times the cost of $1 per unit.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Basics Of IT Audit Purposes Processes And Practical Information

Authors: Stephen D. Gantz

1st Edition

0124171591, 978-0124171596

More Books

Students also viewed these Accounting questions

Question

Explain the various methods of job evaluation

Answered: 1 week ago

Question

Differentiate Personnel Management and Human Resource Management

Answered: 1 week ago

Question

Describe the functions of Human resource management

Answered: 1 week ago

Question

At what level(s) was this OD intervention scoped?

Answered: 1 week ago