Sherman has budgeted sales for the upcoming quarter as
follows:
| April | May | June | |
| Units | 1,600 | 1,900 | 1,750 |
The desired ending finished goods inventory for each month is one-half of next month's budgeted sales. Three pounds of direct material are required for each unit produced. If direct material costs $5 per pound, and must be paid for in the month of purchase, the budgeted direct materials purchases (in dollars) for April are:
Sales = 1,600 units
Desired ending inventory = 1,900 / 2 = 950
Total finished units = 1,600 + 950 = 2,550
For 1 unit of finished unit, 3 pounds direct material is required.
Direct material cost is $5 per pound.
For 2,550 finished units the cost is = 2,550 X 3 X $5 = $38,250
Direct materials purchases (in dollars) = $38,250
Sherman has budgeted sales for the upcoming quarter as follows: April May June Units 1,600 1,900...
10. Sherman has budgeted sales for the upcoming quarter as follows: April May June Units 1,600 1,900 1,750 The desired ending finished goods inventory for each month is one-half of next month's budgeted sales. Three pounds of direct material are required for each unit produced. If direct material costs $5 per pound, and must be paid for in the month of purchase, the budgeted direct materials purchases (in dollars) for April are: a.$40,500. b.$17,500. c.$26,250. d. $38,250. 11. Ross Corporation...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in Units 370 410 430 370 Each month's ending Finished Goods Inventory should be 30% of the next month's sales. March 31 Finished Goods inventory is 111 units. A finished unit requires 5 pounds of direct material B at a cost of $3.00 per pound. The March 31 Raw Materials Inventory has 220 pounds of B. Each month's ending Raw Materials Inventory...
Garver Industries has budgeted the following unit sales: 2020 January February March April May Units 10,000 8,000 9,000 11,000 15,000 The finished goods units on hand on December 31, 2019, was 2,000 units. Each unit requires 3 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 20% of next month's anticipated sales. They also have...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in Units 270 310 330 270 Each month's ending finished goods inventory should be 30% of the next month's sales. March 31 finished goods inventory is 81 units. A finished unit requires 5 pounds of direct material B at a cost of $3.00 per pound. The March 31 Raw Materials Inventory has 230 pounds of B. Each month's ending Raw Materials Inventory...
Croy Inc. has the following projected sales for the next five months Month April May June July August Sales in Units 3.850 3.875 4.260 4,135 3.590 Croy's finished goods inventory policy is to have 60 percent of the next month's sales on hand at the end of each month. Direct material costs $3.10 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month's production needs on hand at the...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in Units 390 430 450 390 Each month's ending finished goods inventory should be 30% of the next month's sales. March 31 finished goods inventory is 117 units. A finished unit requires 5 pounds of direct material B at a cost of $3.00 per pound. The March 31 Raw Materials Inventory has 240 pounds of B. Each month's ending Raw Materials Inventory...
Croy Inc. has the following projected sales for the next five months Month April May June July August Sales in Units 3,520 3,920 4,600 4,130 3,950 Croy's finished goods inventory policy is to have 50 percent of the next month's sales on hand at the end of each month. Direct material costs $3.10 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month's production needs on hand at the...
X-Tel budgets sales of $60,000 for April, $120,000 for May, and $85,000 for June. In addition, sales are 50% cash and 50% on credit. All credit sales are collected in the month following the sale. The April 1 balance in accounts receivable is $18,000. Prepare a schedule of budgeted cash receipts for April, May, and June May June X-TEL Cash Receipts Budget For April, May, and June April Sales Less: Ending accounts receivable Cash receipts from: Cash sales Collections of...
16. Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in units 320 360 380 320 Each month's ending Finished Goods Inventory in units should be 40% of the next month's sales. March 31 Finished Goods inventory is 128 units. A finished unit requires five pounds of direct material B at a cost of $2.00 per pound. The March 31 Raw Materials Inventory has 280 pounds of direct material B. Each...
Ruiz Co. provides the following sales forecast for the next four
months:
April
May
June
July
Sales (units)
630
710
660
750
The company wants to end each month with ending finished goods
inventory equal to 20% of next month's forecasted sales. Finished
goods inventory on April 1 is 126 units. Assume July's budgeted
production is 660 units. In addition, each finished unit requires
four pounds (lbs.) of raw materials and the company wants to end
each month with...