could you please post on a spreadsheet v

Problem 19-2A (Algo) Computing and recording job costs; preparing schedule of cost of goods manufactured LO P1, P2, P3, P4 [The following information applies to the questions displayed below] Marco Company shows the following costs for three jobs worked on in April Additional Information a. Raw Materials inventory has a March 31 balance of $86,800 b. Raw materials purchases in April are $517,000, and total factory payroll cost in April is $380,000. c. Actual overhead costs incurred in April are indirect materials, $54.250, indirect labor, $27,250, factory rent, $36,250; factory utilities, $23,250, and factory equipment depreciation, $55.250 d. Predetermined overhead rate is 50% of direct labor cost. e. Job 306 is sold for $652,000 cash in April. Required: 1. Determine the amount of overhead applied to each job in April \begin{tabular}{l} MARCO COMPANY \\ \hline Schedule of Cost of Goods Manuractured \\ \hline For Month Ended April 30 \\ \hline Book 5 \\ \hline Total manufacturing costs \\ \hline Total cost of work in process \\ \hline \end{tabular} 5-a. Compute gross profit for April. 5-b. Show how the three inventory accounts are reported on the April 30 balance sheet. Complete this question by entering your answers in the tabs below. Compute gross profit for April. Compute gross profit for April. Show how the three inventory accounts are reported on the April 30 balance sheet