Steps for a Production Report

Recently, Stillwater Designs expanded its market by becoming an original equipment supplier to Jeep Wrangler. Stillwater Designs produces factory upgraded speakers specifically for Jeep Wrangler. The Kicker components and speaker cabinets are outsourced with assembly remaining in house. Stillwater Designs assembles the product by placing the speakers and other components in cabinets that define an audio package upgrade and that can be placed into the Jeep Wrangler, producing the desired factory$-$installed appearance. Speaker cabinets and associated Kicker components are added at the beginning of the assembly process.

Assume that Stillwater Designs uses the weighted average method to cost out the audio package. The following are cost and production data for the assembly process for April:

Line Item Description Numerical Value

Production:

Units in process, April $1,60\%$ complete $60,000$

Units completed and transferred out $150,000$

Units in process, April $30,20\%$ complete $30,000$

Costs:

WIP, April $1$:

Cabinets $$1,200,000$

Kicker components $12,600,000$

Conversion costs $5,400,000$

Costs added during April:

Cabinets $$2,400,000$

Kicker components $25,200,000$

Conversion costs $8,640,000$

Required:

Prepare a production report for the assembly department for the month of April. If an amount box does not require an entry, leave it blank or enter $"0".$

Stillwater Designs

Assembly Department Production Report

For the Month of April $($Weighted Average Method$)$

Line Item Description Units

Physical flow:

Units to account for:

Units in BWIP fill in the blank $1$

$60,000$

Units started fill in the blank $2$

$120,000$

Total units to account for fill in the blank $3$

$180,000$

Units accounted for:

Units completed fill in the blank $4$

$150,000$

Units in EWIP fill in the blank $5$

$30,000$

Total units accounted for fill in the blank $6$

$180,000$

Line Item Description Cabinets Components Conversion

Equivalent units:

Units completed fill in the blank $7$

$150,000$

fill in the blank $8$

$150,000$

fill in the blank $9$

$150,000$

Units in ending work in process fill in the blank $10$

$30,000$

fill in the blank $11$

$30,000$

fill in the blank $12$

$6,000$

Equivalent units fill in the blank $13$

$180,000$

fill in the blank $14$

$180,000$

fill in the blank $15$

$156,000$

Costs

Costs Cabinets Components Conversion Total

Costs to account for:

Beginning work in process $fill in the blank $16$

$1,200,000$

$fill in the blank $17$

$12,600,000$

$fill in the blank $18$

$5,400,000$

$fill in the blank $19$

$19,200,000$

Incurred during April fill in the blank $20$

$2,400,000$

fill in the blank $21$

$25,200,000$

fill in the blank $22$

$8,640,000$

fill in the blank $23$

$36,240,000$

Total costs to account for $fill in the blank $24$

$3,600,000$

$fill in the blank $25$

$37,800,000$

$fill in the blank $26$

$14,040,000$

$fill in the blank $27$

$55,440,000$

Equivalent units fill in the blank $28$

$180,000$

fill in the blank $29$

$180,000$

fill in the blank $30$

$156,000$

Cost per equivalent unit $fill in the blank $31$

$20$

$fill in the blank $32$

$210$

$fill in the blank $33$

$90$

$fill in the blank $34$

$320$

Costs Transferred Out Ending Work in Process Total

Costs accounted for:

Goods transferred out $fill in the blank $35$

$48,000,000$

$fill in the blank $36$

$7,440,000$

$fill in the blank $37$

$55,440,000$

Goods in ending WIP

Cabinets fill in the blank $38$

$3,000,000$

fill in the blank $39$

$600,000$

fill in the blank $40$

$360,000$

Components fill in the blank $41$

$31,500,000$

fill in the blank $42$

$6,300,000$

fill in the blank $43$

Conversion fill in the blank $44$

$13,500,000$

fill in the blank $45$

$540,000$

fill in the blank $46$

$3,780,000$

Total costs accounted for $fill in the blank $47$

$fill in the blank $48$

$fill in the blank $49$

Feedback Area

Feedback

Partially correct