Questions
Builder Products, Inc. manufactures a caulking compound that goes through three processing stages prior to completion....

Builder Products, Inc. manufactures a caulking compound that goes through three processing stages prior to completion. Information on work in the first department, cooking, is given below for May:

Production data:

Units in process, May 1: 100% complete as to materials and 80% complete as to labour and overhead

16,700

Units started into production during May

127,000

Units completed and transferred out

117,000

Units in process, May 31: 60% complete as to materials and 20% complete as to labour and overhead

?

Cost data:

Work-in-process inventory, May 1:

Materials cost

$

2,850

Labour cost

3,760

Overhead cost

7,700

Cost added during May:

Materials cost

194,000

Labour cost

37,600

Overhead cost

90,400

Materials are added at several stages during the cooking process, whereas labour and overhead costs are incurred uniformly. The company uses the weighted average cost method. The company combines labour and overhead into a single cost category—conversion cost.

Required:

Prepare a production report for the cooking department for May. Use the following three steps in preparing your report:

1. Prepare a quantity schedule and a computation of equivalent units.

Quantity Schedule

Units to be accounted for:

Work in process, May 1

Units brought into production and fully completed during the month

Total units

0

Equivalent Units (EU)
Units Materials Labour Overhead
Units accounted for as follows:
Transferred out
Units brought into production and fully completed during the month
Total units and equivalent units of production 0 0 0 0

  

2. Compute the costs per equivalent unit for the month. (Round your answers to 3 decimal places.)

Materials Labour Overhead
Costs per equivalent unit

3. Using the data from parts (1) and (2), prepare a cost reconciliation. (Round "Cost per equivalent unit" to 3 decimal places and the rest to the nearest dollar amount.)

Note: There is difference of "$28" in both the values due to rounding and we feel a note which reads: "Due to rounding, your "Cost accounted for" may not be equal to "Cost to account for"".

Equivalent Units (EU)
Total Cost Materials Labour Overhead
Cost accounted for as follows:
Work in process, May 31:
Total work in process 0
Total cost $0

4. Prepare a production report for the cooking department for May. Assuming the company uses the FIFO method. Follow parts (1) to (3). (Leave no cells blank, enter "0" wherever required. Round "Cost per equivalent unit" to 3 decimal places and the rest to the nearest dollar amount.)

  
Quantity Schedule and Equivalent Units

Quantity Schedule
Units to be accounted for:
Total units 0
Equivalent Units (EU)
Units Materials Labour Overhead
Units accounted for as follows:
Total units and equivalent units of production 0 0 0 0

Cost per Equivalent Unit

Materials Labour Overhead
Costs per equivalent unit

Cost Reconciliation

Note: There is difference of "$28" in both the values due to rounding and we feel a note which reads: "Due to rounding, your "Cost accounted for" may not be equal to "Cost to account for"".

Equivalent Units (EU)
Total Cost Materials Labour Overhead
Cost accounted for as follows:
Prior period cost in Work in Process, May 1 $14,310
Cost incurred during May:
To complete units in Work in Process, May 1
Total 0
To partially complete units in Work in Process, May 31
Total 0
Total cost $14,310
Cost transferred out, May 31 $14,310

In: Accounting

(PLEASE COPY PASTE THIS TABLE AND ANSWER IN THE BLANKS) Builder Products, Inc. manufactures a caulking...

(PLEASE COPY PASTE THIS TABLE AND ANSWER IN THE BLANKS)

Builder Products, Inc. manufactures a caulking compound that goes through three processing stages prior to completion. Information on work in the first department, cooking, is given below for May:

Production data:
Units in process, May 1: 100% complete as to materials and 80% complete as to labour and overhead 16,700
Units started into production during May 127,000
Units completed and transferred out 117,000
Units in process, May 31: 60% complete as to materials and 20% complete as to labour and overhead ?
Cost data:
Work-in-process inventory, May 1:
Materials cost $ 2,850
Labour cost 3,760
Overhead cost 7,700
Cost added during May:
Materials cost 194,000
Labour cost 37,600
Overhead cost 90,400

Materials are added at several stages during the cooking process, whereas labour and overhead costs are incurred uniformly. The company uses the weighted average cost method. The company combines labour and overhead into a single cost category—conversion cost.

Required:

Prepare a production report for the cooking department for May. Use the following three steps in preparing your report:

1. Prepare a quantity schedule and a computation of equivalent units.

Quantity Schedule

Units to be accounted for:

Work in process, May 1

Units brought into production and fully completed during the month

Total units

0

Equivalent Units (EU)
Units Materials Labour Overhead
Units accounted for as follows:
Transferred out
Units brought into production and fully completed during the month
Total units and equivalent units of production 0 0 0 0

  

2. Compute the costs per equivalent unit for the month. (Round your answers to 3 decimal places.)

Materials Labour Overhead
Costs per equivalent unit

3. Using the data from parts (1) and (2), prepare a cost reconciliation. (Round "Cost per equivalent unit" to 3 decimal places and the rest to the nearest dollar amount.)

Note: There is difference of "$28" in both the values due to rounding and we feel a note which reads: "Due to rounding, your "Cost accounted for" may not be equal to "Cost to account for"".

Equivalent Units (EU)
Total Cost Materials Labour Overhead
Cost accounted for as follows:
Work in process, May 31:
Total work in process 0
Total cost $0

4. Prepare a production report for the cooking department for May. Assuming the company uses the FIFO method. Follow parts (1) to (3). (Leave no cells blank, enter "0" wherever required. Round "Cost per equivalent unit" to 3 decimal places and the rest to the nearest dollar amount.)

  
Quantity Schedule and Equivalent Units

Quantity Schedule
Units to be accounted for:
Total units 0
Equivalent Units (EU)
Units Materials Labour Overhead
Units accounted for as follows:
Total units and equivalent units of production 0 0 0 0

Cost per Equivalent Unit

Materials Labour Overhead
Costs per equivalent unit

Cost Reconciliation

Note: There is difference of "$28" in both the values due to rounding and we feel a note which reads: "Due to rounding, your "Cost accounted for" may not be equal to "Cost to account for"".

Equivalent Units (EU)
Total Cost Materials Labour Overhead
Cost accounted for as follows:
Prior period cost in Work in Process, May 1 $14,310
Cost incurred during May:
To complete units in Work in Process, May 1
Total 0
To partially complete units in Work in Process, May 31
Total 0
Total cost $14,310
Cost transferred out, May 31 $14,310

In: Accounting

Builder Products, Inc. manufactures a caulking compound that goes through three processing stages prior to completion....

Builder Products, Inc. manufactures a caulking compound that goes through three processing stages prior to completion. Information on work in the first department, cooking, is given below for May:

Production data:
Units in process, May 1: 100% complete as to materials and 80% complete as to labour and overhead 16,700
Units started into production during May 127,000
Units completed and transferred out 117,000
Units in process, May 31: 60% complete as to materials and 20% complete as to labour and overhead ?
Cost data:
Work-in-process inventory, May 1:
Materials cost $ 2,850
Labour cost 3,760
Overhead cost 7,700
Cost added during May:
Materials cost 194,000
Labour cost 37,600
Overhead cost 90,400

Materials are added at several stages during the cooking process, whereas labour and overhead costs are incurred uniformly. The company uses the weighted average cost method. The company combines labour and overhead into a single cost category—conversion cost.

Required:

Prepare a production report for the cooking department for May. Use the following three steps in preparing your report:

1. Prepare a quantity schedule and a computation of equivalent units.

Quantity Schedule

Units to be accounted for:

Work in process, May 1

Units brought into production and fully completed during the month

Total units

0

Equivalent Units (EU)
Units Materials Labour Overhead
Units accounted for as follows:
Transferred out
Units brought into production and fully completed during the month
Total units and equivalent units of production 0 0 0 0

  

2. Compute the costs per equivalent unit for the month. (Round your answers to 3 decimal places.)

Materials Labour Overhead
Costs per equivalent unit

3. Using the data from parts (1) and (2), prepare a cost reconciliation. (Round "Cost per equivalent unit" to 3 decimal places and the rest to the nearest dollar amount.)

Note: There is difference of "$28" in both the values due to rounding and we feel a note which reads: "Due to rounding, your "Cost accounted for" may not be equal to "Cost to account for"".

Equivalent Units (EU)
Total Cost Materials Labour Overhead
Cost accounted for as follows:
Work in process, May 31:
Total work in process 0
Total cost $0

4. Prepare a production report for the cooking department for May. Assuming the company uses the FIFO method. Follow parts (1) to (3). (Leave no cells blank, enter "0" wherever required. Round "Cost per equivalent unit" to 3 decimal places and the rest to the nearest dollar amount.)

  
Quantity Schedule and Equivalent Units

Quantity Schedule
Units to be accounted for:
Total units 0
Equivalent Units (EU)
Units Materials Labour Overhead
Units accounted for as follows:
Total units and equivalent units of production 0 0 0 0

Cost per Equivalent Unit

Materials Labour Overhead
Costs per equivalent unit

Cost Reconciliation

Note: There is difference of "$28" in both the values due to rounding and we feel a note which reads: "Due to rounding, your "Cost accounted for" may not be equal to "Cost to account for"".

Equivalent Units (EU)
Total Cost Materials Labour Overhead
Cost accounted for as follows:
Prior period cost in Work in Process, May 1 $14,310
Cost incurred during May:
To complete units in Work in Process, May 1
Total 0
To partially complete units in Work in Process, May 31
Total 0
Total cost $14,310
Cost transferred out, May 31 $14,310

In: Accounting

An important application of regression analysis in accounting is in the estimation of cost. By collecting...

An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. Consider the following sample of production volumes and total cost data for a manufacturing operation.

Production Volume (units) Total Cost ($)
400 3,700
450 4,700
550 5,100
600 5,600
700 6,100
750 6,700

a. Compute b1 and b0 (to 1 decimal).
b1 [     ]
b0 [     ]
Compute the estimated regression equation (to 1 decimal).
= [ ] + [ ]x

b. What is the variable cost per unit produced (to 1 decimal)?
$[     ]

c. Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1.
r2 = [     ]
What percentage of the variation in total cost can be explained by the production volume (to 1 decimal)?
[     ]%

d. The company's production schedule shows 500 units must be produced next month. What is the estimated total cost for this operation (to the nearest whole number)?
$[     ]

In: Statistics and Probability

An important application of regression analysis in accounting is in the estimation of cost. By collecting...

An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. Consider the following sample of production volumes and total cost data for a manufacturing operation.

Production Volume (units) Total Cost ($)
400 4,200
450 5,200
550 5,600
600 6,100
700 6,600
750 7,200
  1. Compute b1 and b0 (to 1 decimal).
    b1  
    b0  

    Complete the estimated regression equation (to 1 decimal).
    =  +  x
  2. What is the variable cost per unit produced (to 1 decimal)?
    $
  3. Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1.
    r2 =  

    What percentage of the variation in total cost can be explained by the production volume (to 1 decimal)?
    %
  4. The company's production schedule shows 500 units must be produced next month. What is the estimated total cost for this operation (to the nearest whole number)?
    $

In: Statistics and Probability

An important application of regression analysis in accounting is in the estimation of cost. By collecting...

An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. Consider the following sample of production volumes and total cost data for a manufacturing operation.

Production Volume (units) Total Cost ($)
400 3,500
450 4,500
550 4,900
600 5,400
700 5,900
750 6,500

a. Compute b1 and b0 (to 1 decimal).



Complete the estimated regression equation (to 1 decimal).
y^=___+___x

b. What is the variable cost per unit produced (to 1 decimal)?


c. Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1.


What percentage of the variation in total cost can be explained by the production volume (to 1 decimal)?


d. The company's production schedule shows 500 units must be produced next month. What is the estimated total cost for this operation (to the nearest whole number)?

In: Statistics and Probability

An important application of regression analysis in accounting is in the estimation of cost. By collecting...

An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. Consider the following sample of production volumes and total cost data for a manufacturing operation.

Production Volume (units) Total Cost ($)
400 4,400
450 5,400
550 5,800
600 6,300
700 6,800
750 7,400
  1. Compute b1 and b0 (to 1 decimal).
    b1
    b0

    Complete the estimated regression equation (to 1 decimal).
    yhat = ____ + _____ x
  2. What is the variable cost per unit produced (to 1 decimal)?
    $
  3. Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1.
    r2 =

    What percentage of the variation in total cost can be explained by the production volume (to 1 decimal)?
    %
  4. The company's production schedule shows 500 units must be produced next month. What is the estimated total cost for this operation (to the nearest whole number)?

In: Statistics and Probability

Presidio, Inc. produces one model of mountain bike. Partial information for the company follows: Required: 1....

Presidio, Inc. produces one model of mountain bike. Partial information for the company follows:

Required:
1. Complete Presidio’s cost data table. (Round your Cost per Unit answers to 2 decimal places.)
Bikes Produced and sold 470 units 850 units 1534 units

Total cost .

Variable cost . 150400   

fixed per yer ____ _____ ______

total costs ____-_ . _____ . ______

cost per unit

variable cost per unit ______ _______ ______

fixed cost per unit _____ ______ ____________

total cost per unit _______ 540.00_ ___________


2. Calculate Presidio’s contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $610. (Round your Margin Ratio percentage answers to 2 decimal places (i.e. .1234 should be entered as 12.34%.))



3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $610.(Round your answers to the nearest whole dollar amount.)

rev: 02_08_2017_QC_CS-78107

In: Accounting

An important application of regression analysis in accounting is in the estimation of cost. By collecting...

An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. Consider the following sample of production volumes and total cost data for a manufacturing operation.

Production Volume (units) Total Cost ($)
400 4,200
450 5,200
550 5,600
600 6,100
700 6,600
750 7,200
  1. Compute b1 and b0 (to 1 decimal).
    b1
    b0

    Complete the estimated regression equation (to 1 decimal).
    ŷ = + x
  2. What is the variable cost per unit produced (to 1 decimal)?

  3. Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1.
    r2 =

    What percentage of the variation in total cost can be explained by the production volume (to 1 decimal)?
    %
  4. The company's production schedule shows 500 units must be produced next month. What is the estimated total cost for this operation (to the nearest whole number)?

In: Statistics and Probability

An important application of regression analysis in accounting is in the estimation of cost. By collecting...

An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. Consider the following sample of production volumes and total cost data for a manufacturing operation.

Production Volume (units) Total Cost ($)
400 4,100
450 5,100
550 5,500
600 6,000
700 6,500
750 7,100
  1. Compute b1 and b0 (to 1 decimal).
    b1
    b0

    Complete the estimated regression equation (to 1 decimal).
    =  +  x
  2. What is the variable cost per unit produced (to 1 decimal)?
    $
  3. Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1.
    r2 =

    What percentage of the variation in total cost can be explained by the production volume (to 1 decimal)?
    %
  4. The company's production schedule shows 500 units must be produced next month. What is the estimated total cost for this operation (to the nearest whole number)?
    $

In: Statistics and Probability