Question

In: Accounting

Walnut has forecast sales for the next three months as follows: July 4,700 units, August 6,900...

Walnut has forecast sales for the next three months as follows: July 4,700 units, August 6,900 units, September 8,000 units. Walnut's policy is to have an ending inventory of 50% of the next month's sales needs on hand. July 1 inventory is projected to be 2,100 units. Selling and administrative costs are budgeted to be $16,000 per month plus $14 per unit sold. What are budgeted selling and administrative expenses for July?

  • $143,500

  • $77,300

  • $84,700

  • $81,800

Solutions

Expert Solution

Answer)

Calculation of budgeted selling and administrative expenses for July

Budgeted selling and administrative expenses = $ 16,000 + (Number of units budgeted to be sold X $ 14 per unit)

                                                                                      = $ 16,000 + (4,700 units X $ 14 per unit)

                                                                                      = $ 16,000 + $ 65,800

                                                                                       = $ 81,800

Therefore Budgeted selling and administrative expenses for July is $ 81,800.


Related Solutions

The budgeted sales in units for the next four months as follows: July 7,200 units August...
The budgeted sales in units for the next four months as follows: July 7,200 units August 5,400 units September 6,800 units October 7,000 units 1. Prepare the sales budget for the third quarter of the company knowing that each unit is sold for $40. (1.5pt) 2. Past experience has shown that the ending inventory for each month should be equal to 10% of the next month's sales in units. The inventory in the beginning of July was only 600 units....
Company budgeted sales in units for the next four months as follows: July 7,000 units August...
Company budgeted sales in units for the next four months as follows: July 7,000 units August 5,000 units September 6,500 units 1. Prepare the sales budget for the company knowing that each unit is sold for $50. (1 pt) 2. Past experience has shown that the ending inventory for each month should be equal to 20% of the next month's sales in units. The inventory in the beginning of July was only 1,000 units, & the inventory on September 30...
ZZ, Inc. has budgeted sales in units for the next six months as follows: Budgeted Sales in Units July...
ZZ, Inc. has budgeted sales in units for the next six months as follows: Budgeted Sales in Units July 7,700 units August 8,300 units September 5,400 units October 10,200 units November ?????? units December 11,700 units The selling price is $18 per unit. 30% of the company's sales are cash sales and 70% of the company's sales are made on account. The sales on account are collected in the pattern 15% in the month of sale, 20% in the month...
Wheat Inc. has forecast its sales for the coming months as follows: Standard Units Deluxe Units...
Wheat Inc. has forecast its sales for the coming months as follows: Standard Units Deluxe Units April 110 70 May 126 87 June 143 94 July 160 108 Wheat maintains finished goods inventory equal to 30% of the next month’s sales requirements. April 1 inventories were 33 standard units and 21 deluxe. Required: Prepare a production schedule for April through June. (Round your answers to the nearest whole number and use rounded values for your intermediate calculations.)
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 12,000 units April 24,000 units May 35,000 units June 13,000 units July 43,000 units August 69,000 units ABC Company sells its inventory to customers for $25 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 19,000 units April 23,000 units May 34,000 units June 17,000 units July 48,000 units August 69,000 units ABC Company sells its inventory to customers for $16 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
Bengal Co. provides the following sales forecast for the next three months:
Bengal Co. provides the following sales forecast for the next three months: The company wants to end each month with ending finished goods inventory equal to 25% of the next month sales. Finished goods inventory on June 30 is 1, 250 units. The budgeted production units for August are 6, 950 units. 4, 310 units. 7, 090 units. 5, 565 units. 4,135 units.  
1. Hospitable Co. provides the following sales forecast for the next four months: Sales (units) ....
1. Hospitable Co. provides the following sales forecast for the next four months: Sales (units) . . . . . . . . April: 500, May: 580, June: 540, July: 620 The company wants to end each month with ending finished goods inventory equal to 25% of next month’s sales. Finished goods inventory on April 1 is 190 units. Assume July’s budgeted production is 540 units. Prepare a production budget for the months of April, May, and June. 2. Refer...
Ruiz Co. provides the following sales forecast for the next four months: April May June July...
Ruiz Co. provides the following sales forecast for the next four months: April May June July Sales (units) 680 760 710 800 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 136 units. Assume July's budgeted production is 710 units. In addition, each finished unit requires four pounds (lbs.) of raw materials and the company wants to end each month with raw...
Ruiz Co. provides the following sales forecast for the next four months: April May June July...
Ruiz Co. provides the following sales forecast for the next four months: April May June July Sales (units) 570 650 600 690 The company wants to end each month with ending finished goods inventory equal to 30% of next month's forecasted sales. Finished goods inventory on April 1 is 171 units. Assume July's budgeted production is 600 units. In addition, each finished unit requires four pounds (lbs.) of raw materials and the company wants to end each month with raw...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT