Please help with questions $3-5.$ Thank you.

Part $1$: Relates to Module $18$ and I have support videos in the Module $18$ Resources in the applicable weekly folder.

The scenario to this part is below and the requirements follow where you will answer the questions pertaining to this part.

Glass Company makes glass orders based on the customer specifications, so the company uses job costing to track costs.

$1.$ The company uses direct labor hours as the cost driver for manufacturing overhead application.

The company estimated the following manufacturing overhead costs for the year: $$340,000$

The company estimated the following usage of direct$-$labor hours for the year: $170,000$

$2.$ Beginning Work$-$in$-$process, March $1($Job $55)$ $$21,000$

$3.$ Beginning Finished Goods, March $1($Job $57)$ $$88,000$

$2.$ Labor Information for March:

Direct$-$labor hours:

Job $555,000$

Job $586,400$

Job $592,600$

Labor costs in factory:

Direct$-$labor wages $$280,000$

Indirect$-$labor wages $$20,000$

$3.$ Material Information for March:

Raw Materials, Inventory, March $1$ $$8,000$

Purchase or raw material $$159,000$

Direct materials requisitioned:

Job $55$ $$55,000$

Job $58$ $$72,000$

Job $59$ $$18,000$

$4.$ Other costs incurred in March:

Factory Utilities $$1,800$

Sales offices Utilities $$1,100$

Administrative offices Utilities $$1,900$

Factory equipment repair and maintenance costs $$1,700$

Depreciation on factory equipment $$3,000$

Manufacturing supplies purchased and used $$2,000$

$5.$ During March the following jobs were completed :

Job $55$

Job $58$

$6.$ During March the following jobs were sold for the following amounts:

Job $55$ $$215,000$

Job $57$ $$100,000$

Required: You need to use cell references to provide answers and calculations. There are $9$ questions in Part $1.$

$1.$ Develop the predetermined overhead rate. $2\mathrm{.}00$

Pre determine Overhad rate $=$ Estimated Manufacturing overhead rate$/$Direct labor hours $=$ $$340,000/$$$170,000$

$2.$ Complete the job cost sheets provided below for the month of March:

Job $55$ Job $58$ Job $59$

Beginning Balance $$21,00000$

Current costs:

Direct materials $$55,000$ $$72,00018,000$

Direct Labor @$$20$ $$100,000128,00052,000$ Hint: You need to calculate the hourly rate and then compute direct labor cost per job.

Applied overhead @ $2\mathrm{.}0$ $$10,000$ $$12,800$ $$5,200$

Total $$186,000$ $$212,800$ $$75,200$

$3.$ Determine the ending Work$-$In$-$Process Inventory at the end of March and provide the Job number of the job$($s$)$ still in Work$-$in$-$Process at the end of March and the determine total cost of ending work in process for March.

$4.$ Determine the ending Finished Goods for March and provide the Job number$($s$)$ of the job$($s$)$ in Finished Goods at the end of March and determine the total cost of ending finished goods for March.

$5.$ Determine the Cost of Goods Sold for March and provide the Job number of the Job$($s$)$ in Cost of Goods Sold for March and determine the total cost of goods sold for March.