Question

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

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

Accounts
Payable
Merchandise Inventory
May 31 $ 120,000 $ 250,000
June 30 120,000 500,000
July 31 300,000 200,000
August 31 110,000 380,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 (500,000) (200,000) (380,000)
Cost of goods sold
1 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

Budgeted Amounts June July August
Ending Accounts payable 120000 300000 110000
Payment on account 1500000 1350000 1400000
Subtotal 1620000 1650000 1510000
Beginning Accounts payable (120000) (120000) (300000)
Purchases 1500000 1530000 1210000
Budgeted Amounts June July August
Beginning Inventory 250000 500000 200000
Purchases 1500000 1530000 1210000
Cost of goods available for sale 1750000 2030000 1410000
Ending Invenotry (500000) (200000) (380000)
Cost of goods sold 1250000 1830000 1030000
Add a comment
Know the answer?
Add Answer to:
Ahmed Company purchases all merchandise on credit. It recently budgeted the month-end accounts payable balances and...
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
  • Aztec Company sells its product for $190 per unit its actual and budgeted sales to low....

    Aztec Company sells its product for $190 per unit its actual and budgeted sales to low. Units Dollars $950,000 Aprill (actual) May (actual) June (budgeted) July (budgeted) August (budgeted) 5.000 2,000 7,500 6,000 4,300 380,000 1.425,000 1.140,000 817,000 All sales are on credit. Recent experience shows that 20% of credit sales is collected in the month of the sale, 50% in the month after the sale, 29% in the second month after the sale, and 1% proves to be uncollectible....

  • Aztec Company sells its product for $190 per unit. Its actual and budgeted sales follow.   ...

    Aztec Company sells its product for $190 per unit. Its actual and budgeted sales follow.    Units   Dollars April (actual)   8,000     $1,520,000    May (actual)   2,600     494,000    June (budgeted)   7,500     1,425,000    July (budgeted)   8,000     1,520,000    August (budgeted)   4,000     760,000    All sales are on credit. Recent experience shows that 28% of credit sales is collected in the month of the sale, 42% in the month after the sale, 27% in the second...

  • Garda purchased $570,000 of merchandise in August and expects to purchase $790,000 in September. Merchandise purchases...

    Garda purchased $570,000 of merchandise in August and expects to purchase $790,000 in September. Merchandise purchases are paid as follows: 20% in the month of purchase and 80% in the following month. Compute cash payments for merchandise for September. GARDA Cash payments for Merchandise (Budgeted) For Month Ended September 30 Cash payments for September purchases Cash payments for August purchases Total budgeted cash payments Foyert Corp. requires a minimum $6,300 cash balance. If necessary, loans are taken to meet this...

  • Big Sound, a merchandising company specializing in home computer speakers, budgets its monthly cost of goods...

    Big Sound, a merchandising company specializing in home computer speakers, budgets its monthly cost of goods sold to equal 70% of sales. Its inventory policy calls for ending inventory at the end of each month to equal 20% of the next month's budgeted cost of goods sold. All purchases are on credit, and 25% of the purchases in a month is paid for in the same month. Another 60% is paid for during the first month after purchase, and the...

  • Daniels Company reports the following year-end account balances at December 31, 2017. Accounts payable …………….. $20,000...

    Daniels Company reports the following year-end account balances at December 31, 2017. Accounts payable …………….. $20,000 Inventory …………………… $40,000 Accounts receivable ………….. $40,000 Land ………………………... $100,000 Bonds payable, long-term …… $250,000 Goodwill ……………………. $10,000 Buildings ……………………….. $160,000 Retained earnings ………… $115,000 Cash ……………………………. $50,000 Sales revenue ……………... $500,000 Common stock ………………… $100,000 Supplies inventory ………… $5,000 Cost of goods sold ……………. $200,000 Supplies expense …………. $20,000 Equipment ……………………... $80,000 Wages expense …………… $100,000 What is Daniels Company’s net income for...

  • Summit Company has budgeted purchases of merchandise inventory of $454,500 in January and $532,000 in February....

    Summit Company has budgeted purchases of merchandise inventory of $454,500 in January and $532,000 in February. Assume Summit pays for inventory purchases 60% in the month of the purchase and 40% in the month after purchase. The Accounts Payable balance on December 31 is $98,150. Prepare a schedule of cash payments for purchases for January and February. (If a box is not used in the table leave the box empty; do not enter a zero.) Cash Payments January February Total...

  • Help Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow...

    Help Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow April (actual) May (actual) June (budgeted) July (budgeted) August (budgeted) 4,000 2.000 5.000 4.000 4,000 Dollars $ 640,000 320,000 800,000 799,000 640,000 All sales are on credit. Recent experience shows that 26% of credit sales is collected in the month of the sale, 44% in the month after the sale, 26% in the second month after the sale, and 4% proves to be uncollectible....

  • Hardy Company's cost of goods sold is consistently 60% of sales. The company plans ending merchandise...

    Hardy Company's cost of goods sold is consistently 60% of sales. The company plans ending merchandise inventory for each month equal to 20% of the next month's budgeted cost of goods sold. All merchandise is purchased on credit, and 40% of the purchases made during a month is paid for in that month. Another 45% is paid for during the first month after purchase, and the remaining 15% is paid for during the second month after purchase. Expected sales are:...

  • April May June July $37,500 $34,000 $30,000 $45,000 Budgeted cost of goods sold Humboldt had a...

    April May June July $37,500 $34,000 $30,000 $45,000 Budgeted cost of goods sold Humboldt had a beginning inventory balance of $1,800 on April 1 and a beginning balance in accounts payable of $7,400. The company desires to maintain an ending inventory balance equal to 10 percent of the next period's cost of goods sold. Humboldt makes all purchases on account. The company pays 60 percent of accounts payable in the month of purchase and the remaining 40 percent in the...

  • Artec Company sells its product for $190 per unit. Its actual and budgeted sales follow. April...

    Artec Company sells its product for $190 per unit. Its actual and budgeted sales follow. April (actual) May (actuan June (budgeted) July (budgeted) August (budgeted) Units 9,500 2,800 8,000 7,500 4,100 Dollars $1,805,000 532,000 1,520,000 1,425,000 779,000 All sales are on credit Recent experience shows that 24% of credit sales is collected in the month of the sale, 46% in the month after the sale, 29% in the second month after the sale, and 1% proves to be uncollectible The...

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