Question: Suppose a lumber yard has the following data: Accounts receivable, May 31: (.2 * May sales of $360,000) = $72,000 Monthly forecasted sales:

Suppose a lumber yard has the following data:

● Accounts receivable, May 31: (.2 * May sales of $360,000) = $72,000

● Monthly forecasted sales: June, $437,000; July, $441,000; August, $502,000; September, $531,000 Sales consist of 80% cash and 20% credit. All credit accounts are collected in the month following the sales. Uncollectible accounts are negligible and may be ignored.

Prepare a sales budget schedule and a cash collections budget schedule for June, July, and August.

Step by Step Solution

★★★★★

3.43 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Cash collections are the combination of previous m... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

345-B-M-A-B-P-C (1426).docx

120 KBs Word File

Students Have Also Explored These Related Managerial Accounting Questions!

A cam operating a knife-edged follower has the following data : (a) Follower moves outwards through 40 mm during 60 of cam rotation. (b) Follower dwells for the next 45. (c) Follower returns to its...

On June 30, Fabre Fabrics has the following data pertaining to the retail inventory method: Goods available for sale: at cost $35,000, at retail $50,000; net sales $40,000, and ending inventory at...

On June 30, Francois Fabrics has the following data pertaining to the retail inventory method: Goods available for sale: at cost $35,000, at retail $50,000; net sales $40,000, and ending inventory at...

Suppose a lumber yard has the following data: Accounts receivable, May 31: (.2 X May sales of $360,000) = $72,000 Monthly forecasted sales: June, $437,000; July, $441,000; August, $502,000;...

Suppose a lumber yard has the following data: Accounts receivable, May 31: (.2 Times May sales of $360,000) = $72,000 Monthly forecasted sales: June, $437,000; July, $441,000; August, $502,000;...

7-30 Sales Budget Suppose a lumber yard has the following data: Accounts receivable, May 31: (.2 x May sales of $360,000) = $72,000 Monthly forecasted sales: June, $437.000; July, $441.000: August,...

Question content area top Part 1 Suppose a lumber yard has the following data: Accounts receivable, May 31: (0.40 x May sales of $357,000) = $142,800 Monthly forecasted sales: June, $433,000; July,...

Suppose a lumber yard has the following data: Accounts receivable, May 31: (0.30 x May sales of $359,000) = $107,700 Monthly forecasted sales: June, $437,000; July, $448,000; August, $502,000;...

Suppose a lumber yard has the following data: Accounts receivable, May 31: (0.20 x May sales of $360,000) = $72,000 . Monthly forecasted sales: June, $432,000; July, $447,000; August, $509,000;...

Suppose a lumber yard has the following data . Accounts receivable, May 31: (0.20 x May sales of $359,000) $71,800 . Monthly forecasted sales: June, $433,000; July, $445,000; August, $507,000;...

Health issues are a concern of managers, especially as they evaluate the cost of medical insurance. A recent survey of 150 executives at Elvers Industries, a large insurance and financial firm...

Gary, Peter, and Chris and have capital balances of $26,000, $38,000, and $30,000, respectively. As per the partnership agreement, Gary gets a profit share of 2/9; Peter gets 4/9; and Chris gets 3/9....

The cash value in a ( n ) Life policy may fluctuate to reflect changing assumptions regarding mortality cost, interest, and expense factors. A . Endowment B . Term C . Universal D . Graded

Which of the following is an effective outcome of a change management process? A. Minimizes productivity loss during the project. B. Strictly prohibits any change of scope during the entire project....

Should a business accept or reject a project with an NPV of zero? Explain your reasoning.

How would you explain the difference between present value and net present value?

What do you think might cause a company to reject a proposed capital project even though it promises a return significantly higher than the cost of capital?

For the given cash flows, suppose the firm uses the NPV decision rule. Year Cash Flow 0 $ 153,000 1 63,000 2 76,000 3 60,000 Requirement 1: At a required return of 9 percent, what is the NPV of the...

Which box plot below-A. B, or C-matches the stem 01233 plot shown at the right? Explain what you looked for 145677999 to make the match. 2 235 5 58 89 324 45666 Analyze and draw conclusions. Score is...

The desire to maximize profits can work against racial and other types of discrimination. To see this, consider two equally productive accountants named Ted and Jared. Ted is black, and Jared is...