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 |
|
|||||||||||||||||||||||||||||||
2. Compute the costs per equivalent unit for the month. (Round your answers to 3 decimal places.)
|
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"".
|
||||||||||||||||||||||||||||||||||||||||||||||||||
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
|
|
||||||||||||||||||||||||||||||||||||
Cost 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"".
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
(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 |
|
|||||||||||||||||||||||||||||||
2. Compute the costs per equivalent unit for the month. (Round your answers to 3 decimal places.)
|
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"".
|
||||||||||||||||||||||||||||||||||||||||||||||||||
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
|
|
||||||||||||||||||||||||||||||||||||
Cost 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"".
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
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 |
|
|||||||||||||||||||||||||||||||
2. Compute the costs per equivalent unit for the month. (Round your answers to 3 decimal places.)
|
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"".
|
||||||||||||||||||||||||||||||||||||||||||||||||||
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
|
|
||||||||||||||||||||||||||||||||||||
Cost 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"".
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
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 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 |
In: Statistics and Probability
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 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 |
In: Statistics and Probability
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 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 |
In: Statistics and Probability
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 |
In: Statistics and Probability