Question

Dakota Fan, Inc., manufactures an inexpensive household fan that it sells to retailers for $25 per unit. All sales are on account, with 30 percent of sales collected in the month of sale and 70 percent collected in the following month. The data that follow were extracted from the companys accounting records. Dakota Fan maintains a minimum cash balance of $20,000. Total payments in January 20x1 are budgeted at $220,000. A schedule of cash collections for January and February of 20x1 revealed the following receipts for the period Cash Receipts January February From December 31 accounts$126,000 From January sales From February sales 87,000 $133,000 5,000 March 20x1 sales are expected to total 8,500 units. Finished-goods inventories are maintained at 30 percent of the following months sales. The December 31, 20x0, balance sheet revealed the following selected figures: cash, $23,600; accounts receivable, $126,000; and finished goods, $24,000. Required: 1. Determine the number of units that Dakota Fan sold in December 20x0 2. Compute the sales revenue for March 20x1 3. Compute the total sales revenue to be reported on Dakota Fans budgeted income statement for the first quarter of 20x1 4. Determine the accounts receivable balance to be reported on the March 31, 20x1, budgeted balance sheet 5. Calculate the number of units in the December 31, 20x0, finished-goods inventory 6. Calculate the number of units of finished goods to be manufactured in January 20x1 7. Calculate the financing required in January, if any, to maintain the firms minimum cash balance.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution 1:

Accounts receivables on Dec 31 = $126,000

Total sales of december = $126,000 / 70 % = $180,000

Sales units for december = $180,000 / $25 =7200 units

Solution 2:

Sales units for March 20x1 = Nos of units * Selling price per unit = 8500 * $25 = $212,500

Solution 3:

Sales for January = $87,000 + $133,000 = $220,000

Sales for february = $75,000 / 30% = $250,000

Sales for march = $212,500

Total sales revenue for 1st quarter of 20X1 = $220,000 + $250,000 + $212,500 = $682,500

Solution 4:

Accounts receivables balance to be reported in March 31, 20x1 balance sheet = $212,500 * 70% =$148,750

Solution 5:

Sales units for January = $220,000 / $25 = 8800 units

Finished goods inventory on December 31, 20X0 = 8800 * 30% = 2640 units

Solution 6:

Nos of units of finished goods to be manufacturied in January 20X1 = Sales units for January + Ending inventory for January - Beginning inventory for January

Sales units for february = $250,000 / 25 = 10000 units

Nos of units of finished goods to be manufacturied in January 20X1 = 8800 + (10000*30%) - 2640

= 9160 units

Solution 7:

Cash balance for January before financing = Beginning cash balance + Cash receipt - Cash disbursements

= $23,600 + ($126,000 + $87,000) - $220,000 = $16,600

Minimum cash balance required = $20,000

Required financing = $20,000 - $16,600 = $3,400

Add a comment
Know the answer?
Add Answer to:
Dakota Fan, Inc., manufactures an inexpensive household fan that it sells to retailers for $25 per...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Badlands, Inc. manufactures a household fan that sells for $25 per unit. All sales are on...

    Badlands, Inc. manufactures a household fan that sells for $25 per unit. All sales are on account, with 40 percent of sales collected in the month of sale and 60 percent collected in the following month. The data that follow were extracted from the company's accounting records. • Badlands maintains a minimum cash balance of $28,000. Total payments in January 20x1 are budgeted at $225,000. • A schedule of cash collections for January and February of 20x1 revealed the following...

  • Badlands, Inc. manufactures a household fan that sells for $25 per unit. All sales are on...

    Badlands, Inc. manufactures a household fan that sells for $25 per unit. All sales are on account, with 40 percent of sales collected in the month of sale and 60 percent collected in the following month. The data that follow were extracted from the company's accounting records. Badlands maintains a minimum cash balance of $32,000. Total payments in January 20x1 are budgeted at $200,000. A schedule of cash collections for January and February of 20x1 revealed the following receipts for...

  • Badlands, Inc. manufactures a household fan that sells for $25 per unit. All sales are on...

    Badlands, Inc. manufactures a household fan that sells for $25 per unit. All sales are on account, with 30 percent of sales the month of sale and 70 percent collected in the following month. The data that follow were extracted from the company's accounting in . . Badlands maintains a minimum cash balance of $21,000. Total payments in January 20x1 are budgeted at $205,000. A schedule of cash for January and February of 20x1 revealed the following receipts for the...

  • Badlands, Inc. manufactures a household fan that sells for $25 per unit. All sales are on...

    Badlands, Inc. manufactures a household fan that sells for $25 per unit. All sales are on account, with 40 percent of sales collected in the month of sale and 60 percent collected in the following month. The data that follow were extracted from the company's accounting records. • Badlands maintains a minimum cash balance of $32,000. Total payments in January 20x1 are budgeted at $200,000. • A schedule of cash collections for January and February of 20x1 revealed the following...

  • Badlands, Inc. manufactures a household fan that sells for $20 per unit. All sales are on...

    Badlands, Inc. manufactures a household fan that sells for $20 per unit. All sales are on account, with 35 percent of sales collected in the month of sale and 65 percent collected in the following month. The data that follow were extracted from the company's accounting records. • Badlands maintains a minimum cash balance of $28,000. Total payments in January 20x1 are budgeted at $195,000. • A schedule of cash collections for January and February of 20x1 revealed the following...

  • I need answers for 5,6,7 only Badlands, Inc, manufactures a household fan that sells for $20 per unit. All sales ar...

    I need answers for 5,6,7 only Badlands, Inc, manufactures a household fan that sells for $20 per unit. All sales are on account, with 40 percent of sales collected in the month of sale and 60 percent collected in the following month. The data that follow were extracted from the company's accounting records. • Badlands maintains a minimum cash balance of $32,000. Total payments in January 20x1are budgeted at $185.000 • A schedule of cash collections for January and February...

  • Problem 9-34 Relationships of the Master-Budget Components (LO 9-3, 9-5, 9-6) Badlands Inc. manufactures a household...

    Problem 9-34 Relationships of the Master-Budget Components (LO 9-3, 9-5, 9-6) Badlands Inc. manufactures a household fan that sells for $20 per unit. All sales are on account, with 40 percent of sales collected in the month of sale and 60 percent collected in the following month. The data that follow were extracted from the company's accounting records. Badlands maintains a minimum cash balance of $22,000. Total payments in January 20x1 are budgeted at $220,000. • Aschedule of cash collections...

  • records anuary February 91,800 $144,e0e 70,se0 .The 31, 20x0, balance sheet revealed the following selected figures:...

    records anuary February 91,800 $144,e0e 70,se0 .The 31, 20x0, balance sheet revealed the following selected figures: cash. $24,000; accounts receivable, $105,000: and finished goods, $24,600 Required: the number of units that Badlands sold in December 20x0 20x1 to be 31, 20x0.

  • Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling...

    Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company’s accounting records: All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 30 percent are collected in the following month. Uncollectibles amounting to 10 percent of sales are anticipated, and management believes that only 20 percent of the accounts...

  • Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling...

    Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company's accounting records: All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 30 percent are collected in the following month. Uncollectibles amounting to 10 percent of sales are anticipated, and management believes that only 20 percent of the accounts...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT