Question

In: Accounting

Part 1 Bainbridge, Inc. has projected sales and production in units for the second quarter of...

Part 1

Bainbridge, Inc. has projected sales and production in units for the second quarter of the coming year as follows:

August

September

October

Production

95,000

85,000

70,000

Sales

85,000

75,000

95,000



Cash-related production costs are budgeted at $12 per unit produced. Of these production costs, 35% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $125,000 per month and increase 2% each month thereafter. The accounts payable balance on July 31 totals $388,000, which will be paid in August.


All units are sold on account for $20 each. Cash collections from sales are budgeted at 50% in the month of sale, 30% in the month following the month of sale, and the remaining 20% in the second month following the month of sale. Accounts receivable on August 1 totaled $575,000 of which $125,000 was from June's sales and the remainder from July). Show work for A & B below on excel schedule.


Required:

  1. Prepare a schedule for each month showing budgeted cash disbursements for the Bainbridge, Inc. (5 points)
  2. Prepare a schedule for each month showing budgeted cash receipts for Bainbridge, Inc. (5 Points)

Part 2

(Answer this question on the second worksheet in your Excel file.)

Barry Company's standard and actual costs per unit for the most recent period are given below. 15,000 units were actually produced.


Standard

Actual

Materials:

Standard: 3 feet at $1.75 per foot

$5.25

Actual: 3.2 feet at $1.90 per foot

$6.08

Direct Labor:

Standard: 2 hours at $7.00 per hour

$14.00

Actual: 1.9 hours at $8.00 per hour

$15.20

Variable Overhead:

Standard: 2 hours at $4.00 per hour

$8.00

Actual: 2.2 hours at $3.85 per hour

$8.47



Required:

From the foregoing information, compute the following variances and indicate whether the variances are favorable or unfavorable: Show work on excel schedule

  1. Materials price variance. (2 points)
  2. Materials quantity variance. (2 points)
  3. Direct labor rate variance. (2 points)
  4. Direct labor efficiency variance. (2 points)

Part 3

  1. What manager is generally in the best position to influence the direct-labor efficiency variance? (2 points) .   Answer on tab 3 of excel schedule.

Solutions

Expert Solution


Related Solutions

Bainbridge, Inc. has projected sales and production in units for the second quarter of the coming...
Bainbridge, Inc. has projected sales and production in units for the second quarter of the coming year as follows: August September October Production 95,000 85,000 70,000 Sales 85,000 75,000 95,000 Cash-related production costs are budgeted at $12 per unit produced. Of these production costs, 35% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $125,000 per month and increase 2% each month thereafter. The accounts...
ABC Inc. has projected sales and production in units for the second quarter of the coming...
ABC Inc. has projected sales and production in units for the second quarter of the coming year as follows: April May June sales....... 50,000 40,000 60,000 production..... 60,000 50,000 50,000 cash related production costs are budgeted at $5 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $100,000 per month. The accounts payable balance on March 31...
Tilson Corporation has projected sales and production in units for the second quarter of the coming...
Tilson Corporation has projected sales and production in units for the second quarter of the coming year as follows: April May June Sales 45,000 35,000 55,000 Production 55,000 45,000 45,000 Cash-related production costs are budgeted at $7 per unit produced. Of these production costs, 25% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $70,000 per month. The accounts payable balance on March 31 totals...
Tilson Company has projected sales and production in units for the second quarter of the coming...
Tilson Company has projected sales and production in units for the second quarter of the coming year as follows:                                                 April                May                 June Sales                                        55,000             45,000             65,000 Production                              65,000             55,000             55,000 Cash-related production costs are budgeted at $7 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $110,000 per month. The accounts payable balance on March...
Tilson Corporation has projected sales and production in units for the second quarter of the coming...
Tilson Corporation has projected sales and production in units for the second quarter of the coming year as follows:     April   May   June Sales   50,000   40,000   60,000 Production   60,000   50,000   50,000 Cash-related production costs are budgeted at $8 per unit produced. Of these production costs, 35% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $80,000 per month. The accounts payable balance on March 31...
Tilson Corporation has projected sales and production in units for the second quarter of the coming...
Tilson Corporation has projected sales and production in units for the second quarter of the coming year as follows: April May June Sales 49,000 39,000 59,000 Production 59,000 49,000 49,000 Cash-related production costs are budgeted at $6 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $60,000 per month. The accounts payable balance on March 31 totals...
Tilson Corporation has projected sales and production in units for the second quarter of the coming...
Tilson Corporation has projected sales and production in units for the second quarter of the coming year as follows: April May June Sales 53,000 43,000 63,000 Production 63,000 53,000 53,000 Cash-related production costs are budgeted at $5 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $50,000 per month. The accounts payable balance on March 31 totals...
Clay Corporation has projected sales and production in units for the second quarter of the coming...
Clay Corporation has projected sales and production in units for the second quarter of the coming year as follows: April May June Sales 55,000 47,000 65,000 Production 62,500 52,500 52,500 Cash-related production costs are budgeted at $5.5 per unit produced. Of these production costs, 30% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $150,000 per month. The accounts payable balance on March 31 totals...
Tilson Corporation has projected sales and production in units for the second quarter of the coming...
Tilson Corporation has projected sales and production in units for the second quarter of the coming year as follows: April May June Sales 61,000 51,000 71,000 Production 71,000 61,000 61,000 Cash-related production costs are budgeted at $6 per unit produced. Of these production costs, 50% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $60,000 per month. The accounts payable balance on March 31 totals...
Tilson Corporation has projected sales and production in units for the second quarter of the coming...
Tilson Corporation has projected sales and production in units for the second quarter of the coming year as follows: April May June Sales 60,000 50,000 70,000 Production 70,000 60,000 60,000 Cash-related production costs are budgeted at $8 per unit produced. Of these production costs, 45% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $80,000 per month. The accounts payable balance on March 31 totals...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT