Texas Rex, Inc.

Ending Finished Goods Inventory Budget

For the year ending December 31, 2018

Logo T-shirts 5,920

Unit Cost ____________

Total Ending Inventory

(showing work please)

Overhead cost and unit cost: A Q1 2 Budgeted Direct Labor hours 3 Variable Overhead Rate 4 Budgeted Variable Overhead 5 Budgeted Fixed Overhead 6 Total Overhead Cost 127.20 S5 $636 $1,645 $2.281 02 151.20 $5 $756 $1.645 $2.401 | 03 192.00 $5 $960 $1,645 $2.605) 04 240.000 $5 $1,200 $1.645 $2.845 | Total 710.40 $5 $3,552 $6,580 $10.132 8 Calculate the Total Unit Cost: 9 Direct Materials 10 Direct Labor 11 Overhead 12 Total Unit Cost $4.00 $1.20 $1.71 $6.91 Calculations are shown below: C 02 151.2 D 03 192 E 04 240 F Total =SUM(B2:E2) A 01 2 Budgeted Direct Labor hours 127.2 3 Variable Overhead Rate 5 4 Budgeted Variable Overhead =B2 B3 5 Budgeted Fixed Overhead 1645 6 Total Overhead Cost =B4+B5 =C2*C3 =D2 D3 =E2 E3 =F2*F3 1645 1645 1645 =SUMB5:E5) =C4+C5 =D4+D5 =E4+E5 =F4+F5 8 Calculate the Total Unit Cost: 9 Direct Materials =(1*3)+(5*0.2) 10 Direct Labor =0.12*10 11 Overhead =F6/5920 12 Total Unit Cost =SUM(B9:B11)