$\backslash$table$[[$B$,$C$,$D$],[$Monthly Data for Joe Company is Given Below.$],[$Units Produced,$5,000,],[$Units Sold,$4,000,],[$Sales Price,,$],[$No Beginning Inventory,No Beg Inventory,$*],[$Cost Category,Cost,Description$],[$Raw Materials used in production,$$210,$Per Unit Produced$],[$Office Building Rent,$ $ $15,000,$Monthly$],[$Manufacturing Supplies,$$26,$Per Unit Produced$],[$Factory Depreciation,$$0,$Monthly$],[$Advertising$,$$$222,000,$Monthly$],[$Sales Salaries,$$0,$Monthly$],[$Sales Commissions $(5\%$ Sales$),$$$2\mathrm{.}75,$Per Unit Sold$],[$Executive Salaries,$$035,000,$Monthly$],[$Production Staff Wages,$$4,$Per Unit Produced$],[$Factory Rent,$$1(11,000,$Monthly$],[$Administrative support staff,$$5,$Per Unit Sold$]]$

$\backslash$table$[[$Part $1$: Complete the production Cost Report and Calculate COGS and Ending Inventory$]]$

$\backslash$table$[[$Production Report,$],[$Product Costs,Total Per Unit Produced,$],[$Direct Material,$=,],[$Direct Labor,,$7$ Points$],[$Fixed Manufacturing Overhead,C$27,],[$Variable Manufacturing Overhead,$],[$Total Product Costs,,$]]$

Cost remaining in FG Inventory $($Ending Inventory$)$

COGS

Income Statement for $\frac{1}{31}\frac{?}{xxxx}$

Monthly Data for Joe Company is Given Below.

$\backslash$table$[[$Units Produced,$5,000],[$Units Sold,$4,000],[$Sales Price,$$],[$No Beginning Inventory,No Beg Inventory$]]$

$\backslash$table$[[$Cost Category,Cost,Description,$],[$Raw Materials used in production,$$,10,$Per Unit Produced$],[$Office Building Rent,$$,15,000,$Monthly$],[$Manufacturing Supplies,$$,6,$Per Unit Produced$],[$Factory Depreciation,$$,3,000,$Monthly$],[$Advertising$,$$$,22,000,$Monthly$],[$Sales Salaries,$$,1,000,$Monthly$],[$Sales Commissions $(5\%$ Sales$),$$$,2\mathrm{.}75,$Per Unit Sold$],[$Executive Salaries,$$,35,000,$Monthly$],[$Production Staff Wages,$$,4,$Per Unit Produced$],[$Factory Rent,$$,11,000,$Monthly$],[$Administrative support staff,$$,5,$Per Unit Sold$]]$

$\backslash$table$[[$Part $1$: Complete the production Cost Report and Calculate COGS and Ending Inventory$],[$Production Report,$],[$Product Costs,Total,Per Unit Produced,$],[$Direct Material,$=,,],[$Direct Labor,,,$7$ Poi$],[$Fixed Manufacturing Overhead,,,$],[$Variable Manufacturing Overhead,,,$],[$Total Product Costs,,,$],[$Cost remaining in FG Inventory $($Ending Inventory$),,,]]$