Question

Ahmed Company purchases all merchandise on credit. It recently budgeted the following month-end accounts payable balances...

Ahmed Company purchases all merchandise on credit. It recently budgeted the following month-end accounts payable balances and merchandise inventory balances. Cash payments on accounts payable during each month are expected to be: May, $1,400,000; June, $1,400,000; July, $1,250,000; and August, $1,300,000

Accounts
Payable
Merchandise Inventory
May 31 $ 180,000 $ 250,000
June 30 160,000 300,000
July 31 300,000 400,000
August 31 180,000 300,000
(1) Compute the budgeted amounts of merchandise purchases.
Budgeted amounts: June July August
Ending accounts payable
Payments on account
Subtotal 0 0 0
Beginning accounts payable
Purchases $0 $0 $0
(2) Compute the budgeted amounts of cost of goods sold.
Budgeted amounts: June July August
Beginning inventory
Purchases
Cost of goods available for sale
Ending inventory (300,000) (400,000) (300,000)
Cost of goods sold

Homework Answers

Know the answer?
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
Similar Questions
Ahmed Inc. has developed the following sales forecast for the second third of the year: Month...
Ahmed Inc. has developed the following sales forecast for the second third of the year: Month Sales May $500,000 June $650,000 July $380,000 August $300,000 Collection pattern: 40 percent in the month of sale 60 percent in the month after sale Accounts receivable as of April 30 $80,000 Actual Finished goods inventory as of April 30 90,000 The company's selling price is $20 per unit and they want an ending inventory equal to 20 percent of the next month's sales....
Walker Company prepares monthly budgets. The current budget plans for a September ending merchandise inventory of...
Walker Company prepares monthly budgets. The current budget plans for a September ending merchandise inventory of 30,000 units. Company policy is to end each month with merchandise inventory equal to 15% of budgeted sales for the following month. Budgeted sales and merchandise purchases for the next three months follow. The company budgets sales of 200,000 units in October. Sales (Units) Purchases (Units) July 170,000 191,000 August 310,000 308,500 September 300,000 285,000 Prepare the merchandise purchases budgets for the months of...
Zachary, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget...
Zachary, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget for April, May, June, and July. April May June July Budgeted cost of goods sold $79,000 $89,000 $99,000 $105,000 Zachary had a beginning inventory balance of $4,000 on April 1 and a beginning balance in accounts payable of $15,700. The company desires to maintain an ending inventory balance equal to 15 percent of the next period’s cost of goods sold. Zachary makes all purchases...
Campbell Company, which sells electric razors, had $330,000 of cost of goods sold during the month...
Campbell Company, which sells electric razors, had $330,000 of cost of goods sold during the month of June. The company projects a 9 percent increase in cost of goods sold during July. The inventory balance as of June 30 is $35,000, and the desired ending inventory balance for July is $36,000. Campbell pays cash to settle 75 percent of its purchases on account during the month of purchase and pays the remaining 25 percent in the month following the purchase....
On July 1, MTC Wholesalers had a cash balance of $245,000 and accounts payable of $138,600....
On July 1, MTC Wholesalers had a cash balance of $245,000 and accounts payable of $138,600. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual Sales Month Budgeted Sales May $210,000 July $ 126,000 June 224,000 August 112,000 September 140,000 October 168,000 All sales are on credit with 75 percent collected during the month of sale, 20 percent collected during the next month, and 5 percent collected during the second month...
Following information relates to Acco Co. Beginning cash balance on July 1: $45,000. Cash receipts from...
Following information relates to Acco Co. Beginning cash balance on July 1: $45,000. Cash receipts from sales: 24% is collected in the month of sale, 50% in the next month, and 26% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual), $1,548,000; June (actual), $1,080,000; and July (budgeted), $1,260,000. Payments on merchandise purchases: 48% in the month of purchase and 52% in the month following purchase. Purchases amounts are: June...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July....
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 79,200 Accounts receivable 68,600 Inventory 40,200 Buildings and equipment, net of depreciation 213,000 Total assets $ 401,000 Liabilities and Stockholders’ Equity Accounts payable $ 56,000 Common stock 100,000 Retained earnings 245,000 Total liabilities and stockholders’ equity $ 401,000 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month Unit Sales...
Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month Unit Sales June 130,000 July 100,000 August 160,000 September 200,000 October 140,000 November 180,000 There were 26,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of material costs $20. Raw material...
Paul’s Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are...
Paul’s Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are billed weekly for services provided and usually pay 70 percent of their fees in the month the service is provided. In the month following service, Paul collects 25 percent of service fees. The final 5 percent is collected in the second month following service. Paul purchases his supplies on credit, and pays 50 percent in the month of purchase and the remaining 50 percent...
Adams, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget...
Adams, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget for April, May, June, and July. April May June July Budgeted cost of goods sold $69,000 $79,000 $89,000 $95,000 Adams had a beginning inventory balance of $4,500 on April 1 and a beginning balance in accounts payable of $14,300. The company desires to maintain an ending inventory balance equal to 10 percent of the next period’s cost of goods sold. Adams makes all purchases...