Question

Mast Corporation seeks your assistance in developing cash and other budget information for May, June, and July. At April 30,Required: a. Compute the budgeted purchases in dollars for May. b. Compute the budgeted purchases in dollars for June. c. Com

0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1
Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!
Mast Corporation
Purchases Budget March April May June July August Note
Sales units      13,800.00     13,100.00 10,900.00      10,400.00      11,000.00 11,200.00 A
Add: Closing     13,625.00 13,000.00      13,750.00      14,000.00 B= 125% of A of next month.
Less: Opening     16,375.00 13,625.00      13,000.00      13,750.00 C= 125% of A of same month.
Purchases Budget     10,350.00 10,275.00     11,150.00     11,250.00 D=A+B-C
Cost per unit               9.00             9.00                9.00                9.00 E
Purchases Budget $     93,150.00 92,475.00 100,350.00 101,250.00 F=D*E
Answer a
Budgeted purchases in dollars for May is $ 92,475.
Answer b
Budgeted purchases in dollars for June is $ 100,350.
Answer e
Budgeted number of units of inventory to be purchased in July is 11,250 units.
Collection budget for May Amount $
12% of sales of March (i.e. 193,200*12%)      23,184.00
60% of sales of April less 2% discount (i.e. 183,400*60%*98%) 107,839.20
25% of sales of April (i.e. 183,400*25%)      45,850.00
Collection budget for May 176,873.20
Answer c
The budgeted cash collections during May is $ 176,873.20.
Selling and Administrative expense Budget May June Note
Sales value 152,600.00 145,600.00 G
Selling and Administrative expense @ 10%      15,260.00     14,560.00 H=G*10%
Less: Depreciation expense (non cash)        3,000.00       3,000.00
Selling and Administrative expense payable for the months     12,260.00     11,560.00 I
Schedule of Cash Disbursement June Note
58% of purchases of June      58,203.00
58% of Selling and Administrative expense payable for June        6,704.80 See I
42% of purchases of May      38,839.50
42% of Selling and Administrative expense payable for May        5,149.20 See I
Total Cash Disbursements 108,896.50
Answer d
The budgeted cash Disbursement during June is $ 108,896.50.
Add a comment
Know the answer?
Add Answer to:
Mast Corporation seeks your assistance in developing cash and other budget information for May, June, and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Mast Corporation seeks your assistance in developing cash and other budget information for May, June, and...

    Mast Corporation seeks your assistance in developing cash and other budget information for May, June, and July. At April 30, the company had cash of $11,000, accounts receivable of $876,000, inventories of $106,920, and accounts payable of $30,536. The budget is to be based on the following assumptions. Each month’s sales are billed on the last day of the month. Customers are allowed a 2 percent discount if payment is made within 10 days after the billing date. Receivables are...

  • Mast Corporation seeks your assistance in developing cash and other budget information for May, June, and...

    Mast Corporation seeks your assistance in developing cash and other budget information for May, June, and July. At April 30, the company had cash of $11,000, accounts receivable of $876,000, inventories of $128,520, and accounts payable of $36,202. The budget is to be based on the following assumptions. Each month’s sales are billed on the last day of the month. Customers are allowed a 2 percent discount if payment is made within 10 days after the billing date. Receivables are...

  • Mast Corporation seeks your assistance in developing cash and other budget information for May, June, and...

    Mast Corporation seeks your assistance in developing cash and other budget information for May, June, and July. At April 30, the company had cash of $11,000, accounts receivable of $874,000, inventories of S618,800, and accounts payable of $266,110. The budget is to be based on the following assumptions .Each month's sales are billed on the last day of the month. .Customers are allowed a 2 percent discount if payment is made wihin 10 days after the billing date. Recelvables are...

  • D. Tomlinson Retail seeks your assistance in developing cash and other budget information for May, June, and July. The...

    D. Tomlinson Retail seeks your assistance in developing cash and other budget information for May, June, and July. The store expects to have the following balances at the end of April: Cash Accounts receivable Inventories Accounts payable $ 5,400 489,000 281,400 150, 190 The firm follows these guidelines in preparing its budgets: • Sales. All sales are on credit with terms of 3/10, n/30. Tomlinson bills customers on the last day of each month. The firm books receivables at gross...

  • Item1 11.11points eBook Print References Check my workCheck My Work button is now enabled Item 1...

    Item1 11.11points eBook Print References Check my workCheck My Work button is now enabled Item 1 Item 1 11.11 points Mast Corporation seeks your assistance in developing cash and other budget information for May, June, and July. At April 30, the company had cash of $10,000, accounts receivable of $874,000, inventories of $143,880, and accounts payable of $35,975. The budget is to be based on the following assumptions. Each month’s sales are billed on the last day of the month....

  • Deacon Company is a merchadising company that is preparing a budget for the three-month period ended june 30th. The fol...

    Deacon Company is a merchadising company that is preparing a budget for the three-month period ended june 30th. The following information is available Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity...

  • Cash Budget The Williams Supply Company sells for $40 one product that it purchases for $25....

    Cash Budget The Williams Supply Company sells for $40 one product that it purchases for $25. Budgeted sales in total dollars for next year are $1,400,000. The sales information needed for preparing the July budget follows: Month Sales Revenue May $ 34,000 June 48,000 July 56,000 August 64,000 Account balances at July 1 include these: Cash $ 24,000 Merchandise inventory 17,500 Accounts receivable (sales) 25,760 Accounts payable (purchases) 16,250 The company pays for one-half of its purchases in the month...

  • Purchases and Cash Budgets On July 1, MTC Wholesalers had a cash balance of $175,000 and...

    Purchases and Cash Budgets On July 1, MTC Wholesalers had a cash balance of $175,000 and accounts payable of $99,000. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual Sales Month Budgeted Sales May $150,000   July $ 90,000 June 160,000 August 80,000 September 100,000 October 120,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...

  • 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....

  • Show transcribed image text Problem 22-7AA Merchandising: Preparation and analysis of cash budgets with supporting inventory...

    Show transcribed image text Problem 22-7AA Merchandising: Preparation and analysis of cash budgets with supporting inventory and purchases budgets LO P4 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) Units 4,000 1,800 5,500 4,500 4,100 Dollars $ 640,000 288,000 880,000 879,000 656,000 All sales are on credit. Recent experience shows that 26% of credit sales is collected in the month of the sale,...

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