Question

In: Accounting

5) Presented is selected second quarter budget data for the Arnold Company

5) Presented is selected second quarter budget data for the Arnold Company


Sales
April20,000 units
May30,000 units
June36,000 units

Additional information:

- Each unit of finished product requires three pounds of raw materials.

- Arnold maintains ending finishing goods inventories equal to 20% of the following month's budgeted sales.

- Arnold maintains raw materials inventories equal to 25% of the following month's budgeted production.

- April 1 inventories are in line with Arnold's inventory policy.

Arnold's budgeted purchases (in pounds) for April is:

a) 66,000 pounds

b) 72,900 pounds

c) 89,400 pounds

d) None of the above

--

6) Presented is additional information for the Arnold Company (refer to the information above):

- Price per pound of raw materials: $20

- Direct labor per unit of finished product: 0.40 hours at $25 per hour

- Total monthly factory overhead: $200,000 + $10 per direct labor hour

Arnold's total manufacturing cost budget for April is:

a) $880,000

b) $1,680,000

c) $1,828,000

d) $1,966,000

Solutions

Expert Solution

(5): Correct Option is 72900 pounds

Calculation of Budgeted Purchase :

Required for current Production (3 times * Production) = (3 * 22000) = 66000 pounds

Month Sales unit = Current Budgeted sales + Closing stock - Opening Stock

= 20000 + (20% * 30000) - (20% * 20000)

= 20000 + 6000 - 4000

= 22000 units

Desired Closing Inventory (25% of following month production) = (25% * 93600) = 23400 pounds

Following Month sales units = May Budgeted sales + Closing stock - Opening Stock

= 30000 + (20% * 36000) - (20% * 30000)

= 30000 + 7200 - 6000

= 31200 units

Following Month Production = 31200 * 3 = 93600 pounds

Desire Opening Inventory (25% * Current Productio) = (25% * 66000) = 16500 pounds

Therefore April Budgeted Purchases = Required for current Production + Desired Closing Inventory - Desire Opening Inventory

= 66000 + 23400 - 16500

= 72900 pounds

(6.) Correct option is 1966000

Total Manufacturing Cost = Raw Material Cost + Labour Cost + Manufacturing Overhead

= (72900 * 20) + (0.40 * 22000 * 25) + (10 * 0.40 * 22000) + 200000

= 1458000 + 220000 + 88000 + 200000

= 1966000


Related Solutions

Problem 5-35 information used for the cash budget for second quarter Sunland Products, a rapidly growing...
Problem 5-35 information used for the cash budget for second quarter Sunland Products, a rapidly growing distributor of home gardening equipment, is formulating its plans for the coming year. Carol Jones, the firm’s marketing director, has completed the following sales forecast. Month Sales Month Sales January $909,000 July $1,506,100 February $1,006,600 August $1,506,100 March $909,000 September $1,609,500 April $1,152,600 October $1,609,500 May $1,257,100 November $1,506,100 June $1,405,000 December $1,708,200 Phillip Smith, an accountant in the Planning and Budgeting Department, is...
Soprano Co. is in the process of preparing the second quarter budget for 2016, and the...
Soprano Co. is in the process of preparing the second quarter budget for 2016, and the following data have been assembled: The company sells a single product at a selling price of $43 per unit. The estimated sales volume for the next six months is as follows: March 6,100 units June 8,000 units April 7,000 units July 9,300 units May 10,400 units August 6,400 units All sales are on account. The company's collection experience has been that 43% of a...
The first budget is to be for the second quarter of the current year (April, May...
The first budget is to be for the second quarter of the current year (April, May and June). To assist in developing the budget figures, the divisional controller has accumulated the following information. Sales: Sales through the first three months of the current year were 30,000 units. Actual sales in units for January, February, and March, and planned sales in units over the next five months, are given below: January (actual) 6,000 February (actual) 10,000 March (actual) 14,000 April (planned)...
The first budget is to be for the second quarter of the current year (April, May...
The first budget is to be for the second quarter of the current year (April, May and June). To assist in developing the budget figures, the divisional controller has accumulated the following information. Sales: Sales through the first three months of the current year were 30,000 units. Actual sales in units for January, February, and March, and planned sales in units over the next five months, are given below: January (actual) 6,000 February (actual) 10,000 March (actual) 14,000 April (planned)...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 258941 265299 284380 Credit Purchases 97804 116018 135024 Wages, Taxes, and Expenses 26612 31353 33454 Interest 7193 7571 8062 Equipment Purchases 54213 61494 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 254958 266136 282816 Credit Purchases 97321 115536 137343 Wages, Taxes, and Expenses 26176 31560 33787 Interest 7124 7595 7934 Equipment Purchases 54316 61677 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data...
Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 254849 266370 281008 Credit Purchases 97712 113113 131293 Wages, Taxes, and Expenses 26632 31305 33401 Interest 7166 7522 7997 Equipment Purchases 54127 61180 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the...
Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The...
Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The following data have been forecasted: April May Sales ………………………………………………………… $150,000 $157,500 Merchandise purchases …………………………… 107,000 112,400 Operating expenses: Payroll ………………………………………………… 13,600 14,280 Advertising ………………………………………….. 5,400 5,700 Rent …………………………………………………….. 2,500 2,500 Depreciation ………………………………………… 7,500 7,500 End of April balances: Cash ……………………………………………………… 30,000 Bank loan payable ………………………………… 26,000 Additional data: (1) Sales are 40% cash and 60% credit. The collection pattern for credit sales is 50%...
Bagus Industri Bhd. is preparing a cash budget for the second quarter of 2008. The following...
Bagus Industri Bhd. is preparing a cash budget for the second quarter of 2008. The following are its sales figures: ACTUAL SALES (RM) YEAR 2008                         FORECASTED SALES (RM) YEAR 2008                                                                January                       160,000                                   April                 225,000 February                     140,000                                   May                 250,000 March                          190,000                                   June                210,000 July                   220,000 a) The company collects 30 percent of its sales in the month of the sale, 30 percent in the month following the sale, and the remaining 40 percent two months following the...
2. Sportz Corporation is preparing its budget for the second quarter of the calendar year. The...
2. Sportz Corporation is preparing its budget for the second quarter of the calendar year. The following monthly sales data (in units) have been forecasted: April 45,000 May 48,000 June 54,000 July 60,000 August 75,000 Additional information: • Desired ending inventory each month—Finished goods: 25% of next month's sales. • Desired ending inventory each month—Raw materials: 20% of next month's production needs • Number of raw material units required per unit of finished product: 5 @ $4 Required: Prepare a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT