Answer:
Budgeted for June = 154
For July = 183
For August = 195
As per term company purchase 21 % of the inventory for the next month's sale volume.
Purchase in June = 154 + 38 approx(21 % of 183)
Purchase in July = (183 -38 as already purchased in june) + 41 approx ( 21 % 195)
= 145 + 41
= 186
1. Purchase in July = 186 widgets
2. Total purhcase = 3906 (186*21)
3. Cash outflow = 3906
Hit like if it was helpful
Hastings Co. sells widgets. The company is currently developing a purchases budget for July. Projected sales...
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....
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...
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...
a) Prepare a sales budget(in dollars) and cash collections budget for July through September of this year. b) Prepare a production budget (in units) for July through September c) Prepare a direct materials purchase budget(in units) and cash disbursements budget for Carbon Fiber for July through September. Please give the details how to get the answers. Thanks! K&B Enterprises manufactures a high-tech raincoat for children. The following information has been assembled for next year's first quarter (i.e., Jul - Sep)...
Smithfield Company manufactures widgets. Smithfield’s sales budget shows monthly sales for the upcoming quarter as follows: July 10,000 units August 8,000 units September 12,000 units October 14,000 units Each unit sells for $20.00. 80% of sales are on account. Smithfield’s collections on sales on account are expected as follows: 65% in the month of the sale 20% in the month following the month of sale 12% in the second month following the month...
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...
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...
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....
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...
MASTER BUDGET This Company started business on January 1, 2019. The company estimated that sales for the first six months would be as follows: Month January February March April Dollars Units 12,000 S 72,000 9,500 14,000 21,700 130,200 57,000 84,000 May June 20,000 120,000 32,100 192,600 The company sells all items on account and expects collections of accounts receivable to be as follows: 80% in the month of the sale, and the remaining 20% in the month after the sale....