Revenue Income Statement Q3 2019- Retail Stores Division Direct re-sale goods Actual Amounts $2,128,553 Manufactured goods...

Transcribed Image Text:

Revenue Income Statement Q3 2019- Retail Stores Division Direct re-sale goods Actual Amounts $2,128,553 Manufactured goods 6,677,321 Total sales 8,805,874 Budgeted Amounts $2,100,000 6,468,000 8,568,000 Cost of Goods Sold - Manufactured Items Direct Materials 1,460,100 986,370 Direct Labor 1,580,675 1,290,366 Variable Manufacturing OH 321,633 388,080 Fixed Manufacturing OH 571,447 582,120 Total Cost of Goods Sold - Manufactured Items 3,933,855 3,246,936 Cost of Goods Sold - Resale Items 1,353,642 1,417,500 Total Cost of Goods Sold 5,287,497 4,664,436 Gross Margin 3,518,377 3,903,564 Variable Selling and Administrative Costs 567,171 371,700 Fixed Selling and Administrative Costs 538,901 542,500 Operating Income $2,412,305 $2,989,364 Income Statement Q3 2019- Online Sales Division Revenue Direct re-sale goods Manufactured goods Total sales Actual Amounts $4,012,848 1,279,536 5,292,384 Budgeted Amounts $3,315,000 2,079,000 5,394,000 Cost of Goods Sold - Manufactured Items Direct Materials 274,350 381,150 Direct Labor 405,850 523,908 Variable Manufacturing OH 114,192 124,740 Fixed Manufacturing OH 285,295 249,480 Total Cost of Goods Sold - Manufactured Items 1,079,687 1,279,278 Cost of Goods Sold - Resale Items 2,278,058 2,340,000 Total Cost of Goods Sold 3,357,745 3,619,278 Gross Margin 1,934,639 1,774,722 Variable Selling and Administrative Costs 148,691 114,825 Fixed Selling and Administrative Costs 149,350 157,500 Operating Income $1,636,598 $1,502,397 + Additional Information Expected total number of direct re-sale items to be sold Actual number of direct re-sale items sold by the Retail Stores Division Actual number of direct re-sale items sold by the Online Sales Division Expected total number of manufactured items to be sold Actual number of manufactured items sold by the Retail Stores Division Actual number of manufactured items sold by the Online Sales Division Expected cost per sq. ft of direct materials (price per sq. ft of reclaimed wood) Actual cost per sq. ft. of direct materials (cost per sq. ft. of reclaimed wood) Expected cost per direct labor hour Actual cost per direct labor hour Expected % of direct resale items sold in the Online-Sales Division Expected % of manufactured items sold in the Retail Stores Division 60,000 19,618 42,464 23,100 13,745 4,880 $5.5 $6.2 $13.30 $12.50 65% 70% Revenue Income Statement Q3 2019- Retail Stores Division Direct re-sale goods Actual Amounts $2,128,553 Manufactured goods 6,677,321 Total sales 8,805,874 Budgeted Amounts $2,100,000 6,468,000 8,568,000 Cost of Goods Sold - Manufactured Items Direct Materials 1,460,100 986,370 Direct Labor 1,580,675 1,290,366 Variable Manufacturing OH 321,633 388,080 Fixed Manufacturing OH 571,447 582,120 Total Cost of Goods Sold - Manufactured Items 3,933,855 3,246,936 Cost of Goods Sold - Resale Items 1,353,642 1,417,500 Total Cost of Goods Sold 5,287,497 4,664,436 Gross Margin 3,518,377 3,903,564 Variable Selling and Administrative Costs 567,171 371,700 Fixed Selling and Administrative Costs 538,901 542,500 Operating Income $2,412,305 $2,989,364 Income Statement Q3 2019- Online Sales Division Revenue Direct re-sale goods Manufactured goods Total sales Actual Amounts $4,012,848 1,279,536 5,292,384 Budgeted Amounts $3,315,000 2,079,000 5,394,000 Cost of Goods Sold - Manufactured Items Direct Materials 274,350 381,150 Direct Labor 405,850 523,908 Variable Manufacturing OH 114,192 124,740 Fixed Manufacturing OH 285,295 249,480 Total Cost of Goods Sold - Manufactured Items 1,079,687 1,279,278 Cost of Goods Sold - Resale Items 2,278,058 2,340,000 Total Cost of Goods Sold 3,357,745 3,619,278 Gross Margin 1,934,639 1,774,722 Variable Selling and Administrative Costs 148,691 114,825 Fixed Selling and Administrative Costs 149,350 157,500 Operating Income $1,636,598 $1,502,397 + Additional Information Expected total number of direct re-sale items to be sold Actual number of direct re-sale items sold by the Retail Stores Division Actual number of direct re-sale items sold by the Online Sales Division Expected total number of manufactured items to be sold Actual number of manufactured items sold by the Retail Stores Division Actual number of manufactured items sold by the Online Sales Division Expected cost per sq. ft of direct materials (price per sq. ft of reclaimed wood) Actual cost per sq. ft. of direct materials (cost per sq. ft. of reclaimed wood) Expected cost per direct labor hour Actual cost per direct labor hour Expected % of direct resale items sold in the Online-Sales Division Expected % of manufactured items sold in the Retail Stores Division 60,000 19,618 42,464 23,100 13,745 4,880 $5.5 $6.2 $13.30 $12.50 65% 70%