# Ac505 Course Project a

Powerful Essays
3135 Words
Grammar
Plagiarism
Writing
Score
Ac505 Course Project a
AC505 Course Project Hints:

The beginning cash balance for April, is the cash from March 31 in the Asset section of the balance sheet. In the merchandise purchases budget, in April, we need 50% of March purchases (that amount is also given to us 3/31 Accounts payable of \$100,000 on page 415). Therefore, Total cash disbursements for April is (50% x \$316,000 April purchases) + (\$100,000 remaining March purchases to be paid) = \$258,000.

Class, Here are some hints. Lets start from the beginning:

SALES BUDGET:
First, take budgeted sales in units for each month of April, May, and June, and multiply by the selling price of \$10/unit. You will get TOTAL SALES which you will also need to plug into the Income Statement later. For example, April should be 65,000 units times \$10 = \$650,000 Total Sales.

For your Schedule of Expected Cash Collections, each months units must be multiplied by the \$10 selling price to yield the months sales. Per page 414, we know 10% of a given months sales is collected in the 2nd month following the sale, 70% in the month following the sale, and 20% in the month of sale.
Therefore, for example Total Cash Collection for April will consist of the last 10% of February sales and 70% of March sales and 20% of April sales: (26,000 Feb units x \$10 x 0.10) +(40,000 March units x \$10 x 0.70) + (65,000 April units x \$10 x 0.20) = \$436,000. You have to repeat the same process for May and June that I just did for April, and then add up all three months to get the quarter.

Next, we have the Merchandise Purchases Budget. Total Needs are Budgeted sales in units plus Budgeted ending inventory (budgeted ending inventory =40% of the next months sales in units according to the terms of the problem). Once we have Total Needs, we subtract the Beginning Inventory (which of course is the previous months ending inventory) to get Required Unit Purchases. So for April, that is 65,000 April budgeted units + (0.40 x 100,000 May budgeted units) = 105,000

## You May Also Find These Documents Helpful

• Satisfactory Essays

One-quarter of a month’s inventory purchases is paid for in the month of purchase; the other three-quarters is paid for in the following month. The accounts payable at December 31 are the result of December purchases of inventory.…

• 434 Words
• 4 Pages
Satisfactory Essays
• Powerful Essays

If a company has ending inventory of \$25,000, purchases during the year of \$95,000, and beginning…

• 4852 Words
• 20 Pages
Powerful Essays
• Good Essays

Sixty percent of all purchases, selling and administrative expenses, and advertising expenses are paid in the month incurred. The remainder is paid in the following month. Ending inventory is set at 25 percent of the next month's budgeted cost of goods sold. The company's gross profit averages 30 percent of sales for the month. Selling and administrative expenses follow the formula of 5 percent of the current month's sales plus \$75,000, which includes depreciation of \$5,000. Advertising expenses are budgeted at 3 percent of sales.…

• 987 Words
• 4 Pages
Good Essays
• Satisfactory Essays

(a) Compute the estimated inventory at May 31, assuming that the gross profit is 25% of sales.…

• 383 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

• Subtract inventory from the sales forecast and that is how much you should produce…

• 788 Words
• 4 Pages
Satisfactory Essays
• Good Essays

Sales on account for the first two months of the current year are budgeted as follows:…

• 1277 Words
• 10 Pages
Good Essays
• Satisfactory Essays

Cash Receipts From Footwear Sales = 25 Percent of Previous Year from Receivables and 75% of current year…

• 348 Words
• 1 Page
Satisfactory Essays
• Powerful Essays

The sales budget is prepared by multiplying the expected unit sales volume for each product by its anticipated unit-selling price. As reflected in Exhibit A noted below and included in the overall Peyton Approved budget worksheet included in Appendix A, Peyton Approved expects sales volume to be 18000, 22000 and 20000 units in the month of July, August and September respectively. The budgeted sales in August exceeded July's sales units by 4000 units, however, sales declined in September by 2000 units from August. Peyten Approved budgeted sales price per units for the quarter was based on a sales price of \$18 per unit. Thus, budgeted total dollars per month are 324,000 computed 18 sales price per unit, 396000 sales price per unit, and 360000 sales price per unit in July, August, and September respectively.…

• 1555 Words
• 5 Pages
Powerful Essays
• Satisfactory Essays

\$220,000 (end inventory) - \$25,000 (inventory at end of year) = \$195,000 (cost of goods sold)…

• 951 Words
• 7 Pages
Satisfactory Essays
• Satisfactory Essays

Compute the April 30 inventory and the April cost of goods sold using the average cost method.…

• 1420 Words
• 7 Pages
Satisfactory Essays
• Satisfactory Essays

The policy is to acquire enough inventory each month to equal the following month’s projected cost of goods sold. All purchases are paid for in the month following purchase. Salaries, wages, and commissions average 20% of sales; all other variable expenses are 4% of sales. Fixed expenses for rent, property taxes, and miscellaneous payroll and other items are \$55,000 monthly. Assume that these variable and fixed expenses require cash disbursements each month. Depreciation is \$2,500 monthly. In June, \$55,000 is going to be disbursed for fixtures acquired and recorded in furniture and fixtures in May. The May 31 balance of accounts…

• 692 Words
• 3 Pages
Satisfactory Essays
• Good Essays

Compute his likely cash balance or deficit for the end of the year. Start with beginning cash and subtract the asset buildup (equal to 50 percent of the sales increase) and add in profit.…

• 1968 Words
• 8 Pages
Good Essays
• Satisfactory Essays

65,000 100,000 50,000 \$10 \$650,000 Correct! Requirement 1b. Schedule of expected cash collections: February sales \$26,000 March sales 280,000 April sales 130,000 May sales June sales Total cash collections \$436,000 Correct! Requirement 1c. Merchandise purchases budget: Budgeted unit sales 65,000 100,000 Add desired ending inventory 40,000 Total needs 105,000 Less beginning inventory 26,000 Required purchases in units 79,000 Unit cost \$4 Required dollar purchases \$316,000 Correct! Requirement 1d. Budgeted cash disbursements for merchandise purchases: Accounts payable 100,000 April purchases 158,000 158,000 May purchases June purchases Total cash disbursements \$258,000 Correct!…

• 376 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

1. Determine the March 31 ending balances of Materials Inventory, Work in Process Inventory and Finished Goods inventory.…

• 551 Words
• 3 Pages
Satisfactory Essays
• Good Essays

C. Calculate the balances for the three accounts: Cost of Goods Sold, Work-in-Process Inventory at 31st October 2011 and Finished Goods inventory at 31st October 2011. (Use the chart below to summarize your totals.) (3 marks)…

• 1797 Words
• 8 Pages
Good Essays