Question

In: Finance

Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units...

Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units to be produced:

April    1,000 units

May     1,200 units

June     1,250 units

Each unit requires 2 parts of component A and 3 parts of component B. Component A cost is $1.25 per unit and component B cost is $.80 per unit.

Each unit requires the following labor:

2 hours in the processing department

1 hour in the assembly department

Processing department labor rate is $4/hour

Assembly department labor rate is $6/hour

Variable Factory overhead is $.60 per unit

Fixed Factory overhead is $1,000 monthly

Using the information from the production budget of Tangshang Industries

1.Calculate total product cost per unit for the quarter April - June 2018

2.If the sale price is $32.50, what will be the Gross Profit per unit?

3.If the sale price is $32.50 for the units produced during the quarter, what will be the Total Gross Profit?

Solutions

Expert Solution

1. Total product cost per unit will be calculated as follow;

April

May

June

Number of units

1000

1200

1250

Component cost per unit

$4.90

$4.90

$4.90

Total component costs

$4900

$5880

$6125

Labor cost per unit

$14

$14

$14

Total labor costs

$14000

$16800

$17500

Variable factory overhead per unit

$0.60

$0.60

$0.60

Total variable factory overhead

$600

$720

$750

Fixed Factory overhead

$1000

$1000

$1000

Total product cost (Component costs + Labor costs + Variable factory overhead + Fixed factory overhead)

$20500

$24400

$25375

Total product cost per unit (Total product cost / Number of units)

$20.50

$20.33

$20.30

Working Note;

1. Following component cost will be for one unit = (2 * $1.25) + (3 * $0.80) = $4.90

2. Per unit labor cost for processing department will be calculated as follow;

(2 hours * $4) = $8 per unit

Per unit labor cost for assembly department will be calculated as follow;

(1 hours * $6) = $6 per unit

Thus total labor cost per unit ($8 + $6) = $14 per unit

2. If the sale price is $32.50, what will be the Gross Profit per unit?

April

May

June

Sale price per unit

$32.50

$32.50

$32.50

Less: Product cost per unit

$20.50

$20.33

$20.30

Gross profit per unit

$12

$12.17

$12.20

3. If the sale price is $32.50, what will be the Total Gross Profit?

April

May

June

Sale price per unit

$32.50

$32.50

$32.50

Less: Product cost per unit

$20.50

$20.33

$20.30

Gross profit per unit

$12

$12.17

$12.20

Number of units

1000

1200

1250

Total gross profit (Per unit gross profit * Number of units)

$12000

$14604

$15250


Related Solutions

Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units...
Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units to be produced: April 1,100 units May 1,250 units June 1,300 units Each unit requires 2 parts of component A and 3 parts of component B. Component A cost is $1.15 per unit and component B cost is $.85 per unit. 7. Calculate the Direct Material budgeted cost for May 2018 8. Calculate the Direct Material budgeted cost for the quarter April - June...
Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units...
Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units to be produced: April 1,000 units May    1,200 units June    1,250 units Each unit requires 2 parts of component A and 3 parts of component B. Component A cost is $1.25 per unit and component B cost is $.80 per unit. A. Calculate the Direct Material budgeted cost for May 2018 B. Calculate the Direct Material budgeted cost for the quarter April - June...
Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units...
Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units to be produced: April    1,000 units May     1,200 units June     1,250 units Each unit requires 2 parts of component A and 3 parts of component B. Component A cost is $1.25 per unit and component B cost is $.80 per unit. Each unit requires the following labor: 2 hours in the processing department 1 hour in the assembly department Processing department labor rate...
Tanghang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units...
Tanghang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units to be produced: April 1,100 units May     1,250 units June     1,300 units Each unit requires 2 parts of component A and 3 parts of component B. Component A cost is $1.15 per unit and component B cost is $.85 per unit. Calculate the Direct Material budgeted cost for May 2018 Calculate the Direct Material budgeted cost for the quarter April - June 2018 The...
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...
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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT