Prepare a merchandise purchases budget

Assignment Help Managerial Accounting

Reference no: EM131196345

Prepare a Financial Report by using the following Data:

1) The Alec Corporation sells inflatable pools. On June 30, there were 105 pools in ending inventory, and accounts receivable had a balance of $12,000. Sales of inflatable pools (in units) have been budgeted at the following levels for the upcoming months:

Accounts receivable, June 30	$12,000
Number of pools budgeted to be sold in July	350
Number of pools budgeted to be sold in August	420
Number of pools budgeted to be sold in September	370
Number of pools budgeted to be sold in October	300

The company has a policy that the ending inventory of inflatable pools should be equal to 30% of the number of pools to be sold in the following month. The Outdoor Leisure Store sells the inflatable pools for $100 each. The company's collection history shows that 30% of the sales in a month are paid for by customers in the month of sale, while the remainder is collected in the following month.

Required:

a. Prepare a merchandise purchases budget showing how many pools should be purchased in each of the months including July, August, and September.

b. Prepare a cash collections budget for each of the months including July, August, and September.

Part a.
Merchandise Purchases Budget	July	August	September	October
Budgeted unit sales
Desired ending inventory (30% of next month's sales)
Total needs
Less beginning inventory
Required purchases

Part b.
Cash Collections Budget
Budgeted unit sales
Selling price per unit
Budgeted sales
Accounts receivable, June 30
July sales
August sales
Ssplember sales
Total cash collections

Reference no: EM131196345

Questions Cloud

What is the angle u assuming that the dial indicator : Suppose that in Figure 10-33 the height of the gage blocks are 3.2500 in. What is the angle u assuming that the dial indicator is reading zero?

Review the given essay and make adjustments : Review the given essay and make adjustments.- Given Essay topic is: "The Education System Is Only as Successful as the Participates"

Maximize profits along with real-life examples : Which types of firms would normally maximize profits along with real-life examples? Should a firm shut down if its weekly revenue is $2,000, its variable cost is $1,000, and its fixed cost is $1,600, of which $1,200 is avoidable if it shuts down? Why..

What happens to edward if he is competent to stand trial : What questions would you ask Edward in order to assess his competency to stand trial? Besides interviewing, what other ways would you assess his competency? Does he appear to meet the criteria for competency to stand trial? Why or why not?

Prepare a merchandise purchases budget : Prepare a merchandise purchases budget showing how many pools should be purchased in each of the months including July, August, and September - Prepare a cash collections budget for each of the months including July, August, and September.

What processes might be grouped into nanotechnology field : What processes might be grouped into the nanotechnology field? For example, what level of precision is needed in a CD player or an artificial joint?

Find the number of customers : Find the number of customers n such that the probability that the orders of all n customers can be processed in less than 2.5 hours is approximately .025. Please help with this question.

Find out their expected revenue : Suppose that Victoria and her friends are running a fundraiser by selling donuts. They want to know what will happen to their revenue if they increase the price of each donut from $0.80 to $1. What concept do they need to apply to find out their expe..

Determine the value of the firm : A firm's current profits are $450,000. These profits are expected to grow indefinitely at a constant annual rate of 3 percent. If the firm's opportunity cost of funds is 6 percent, determine the value of the firm: The instant after it pays out curren..

User Account

All Pages