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.
Purchase data are as follows.
Dollars | Units | ||
March | $ | 165,200 | 11,800 |
April | 183,400 | 13,100 | |
May | 138,600 | 9,900 | |
June | 173,600 | 12,400 | |
July | 182,000 | 13,000 | |
August | 15,800 | 13,200 | |
Required:
a. Compute the budgeted purchases in dollars for May.
b. Compute the budgeted purchases in dollars for
June.
c. Compute the budgeted cash collections during May. (Do not round intermediate calculations.)
d. Compute the budgeted cash disbursements during June. (Do not round intermediate calculations.)
e. Compute the budgeted number of units of inventory to be purchased during July.
a and b.
May | Jun | |
Budgeted Units Sale | 9900 | 12400 |
Selling price per unit | 14 | 14 |
Total Sales | 138600 | 173600 |
Merchandise Purchase Budget | ||
May | Jun | |
Requirement for the month | 9,900 | 12,400 |
Add: Desired Ending Inventory | 14,880 | 15,600 |
Total Needs | 24,780 | 28,000 |
Less: Beginning Inventory | 11,880 | 14,880 |
Total Purchase in units | 12,900 | 13,120 |
Cost per units | 9 | 9 |
Total Purchase ($) | 116,100 | 118,080 |
c)
Cash Collection Budget | ||
May | Jun | |
Apr Sales (12%) | 22,008 | - |
May Sales (65% less discount) | 88,288 | |
May Sales (20% and 12%) | 27,720 | 16,632 |
June Sales (65% less discount) | 110,583 | |
Jun Sales (20% and 12%) | 34,720 | |
Total Collection | 138,016 | 161,935 |
d)
Cash Disbursement Budget - For Merchandise | ||||
Jun | ||||
May Purchase (57% * 116100) | 49,923 | |||
Jun Purchase (43% * 118080) | 67,306 | |||
Total Payment | 117,229 |
e)
Merchandise Purchase Budget | |||
May | Jun | Jul | |
Requirement for the month | 9,900 | 12,400 | 13,000 |
Add: Desired Ending Inventory | 14,880 | 15,600 | 15,840 |
Total Needs | 24,780 | 28,000 | 28,840 |
Less: Beginning Inventory | 11,880 | 14,880 | 15,600 |
Total Purchase in units | 12,900 | 13,120 | 13,240 |
Cost per units | 9 | 9 | 9 |
Total Purchase ($) | 116,100 | 118,080 | 119,160 |
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 July. At April 30, the company had cash of $11,000, accounts receivable of $855,000, inventories of $122,625, and accounts payable of $29,134. 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....
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 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 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....
You have been asked to prepare the monthly cash budget for June and July for the Merchandise and Mercantile Company. The company sells a unique product that is specially made for it by a major product manufacturer. The selling price is $18.00 per unit. All sales are on account. Merchandise purchases are also on account. The policy of the company is to purchase sufficient quantity of product to ensure that each month’s ending inventory is 50% of the following month’s...
You have been asked to prepare the monthly cash budget for June and July for the Merchandise and Mercantile Company. The company sells a unique product that is specially made for it by a major product manufacturer. The selling price is $18.00 per unit. All sales are on account. Merchandise purchases are also on account. The policy of the company is to purchase sufficient quantity of product to ensure that each month’s ending inventory is 50% of the following month’s...
You have been asked to prepare the monthly cash budget for June and July for the Merchandise and Mercantile Company. The company sells a unique product that is specially made for it by a major product manufacturer. The selling price is $25.00 per unit. All sales are on account. Merchandise purchases are also on account. The policy of the company is to purchase sufficient quantity of product to ensure that each month’s ending inventory is 50% of the following month’s...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $140,000 June 140,000 July 180,000 August 120,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 1...
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 $ 55,400 Accounts receivable 41,200 Inventory 53,200 Buildings and equipment, net of depreciation 180,000 Total assets $ 329,800 Liabilities and Stockholders’ Equity Accounts payable $ 143,500 Common stock 70,000 Retained earnings 116,300 Total liabilities and stockholders’ equity $ 329,800 Budgeted Income Statements April May June Sales $ 144,000 $...