Piper Products Inc. is required to account for seven jobs during the current month (Job 251-257). Complete the posting of all job costs to the various jobs. Refer to the following excel worksheet: Job 251 Job 252 Job 253 Job 254 Job 255 Job 256 Job 257 . . Identify within each job its current status, i.e. budgetednot yet working, WIP, completed and transferred to Finished Goods, billed and sold-ie. out the door. Use the information given supplemental pages of the excel workshbet tabs, eg: Budgets Begin WIP DM Requisitions DL Costs MO Costs Other Data The POR rate is calculated based on Direct Labor Hours. Use the data on the MO Costs worksheet and calculate the rate on the GL Control worksheet. You may refer to the POR rate by using POR in a calculation, eg. =d18*POR Calculate the actual DL cost incurred by using the DLHs and the per-hour rate listed, place the result in the DL Costs worksheet in the appropriate cells. . 1 Budget Amounts - Job Cost Summary 2 Job # DM DL MO TOTAL Revenues 251 4 252 5 253 6 254 $224,056 $586,938 $635,060 $352,506 $656,920 $213,688 $411,615 $3,080,783 $349,926 $751,343 $781,918 $475,496 $772,426 $330,610 $668,419 $4,130,138 $227,450 $488,374 $508,246 $309,073 $502,078 $214,896 $384,719 $2,634,836 7 255 $801,432 $1,826,655 $1,925,224 $1,137,075 $1,931,424 $759,194 $1,464,753 $9,845,757 $1,041,862 $2,374,651 $2,464,284 $1,387,232 $2,510,850 $1,062,870 $2,209,721 $13,051,470 8 256 9 257 10 Total Jobs in WIP at the beginning of the month Job # DM DL Total 251 $ 643,158 252 $ 1,744,289 178,433 $ 565,807 $ 437,976 $ 1,182,216 $ 281,652 $ 714,232 $ 551,296 $ 1,547,180 $ 183,073 $ 464,250 $ 358,343 $ 1,005,666 $ 253 $ 1,347,615 3,735,062 Total $ 2 3 Direct Material Activity - Requisitions From Raw Material Inventory Job # Requisition # DM Requisitioned 251 REQ-190 47,796 252 REQ-191 $ 24,190 $ 4 253 REQ-192 $ 69,676 6 254 REQ-193 354,770 255 $ $ $ REQ-194 REQ-195 392,422 8 256 205,418 419,603 9 257 REQ-196 $ $ 10 Total 1,513,875 11 12 13 Raw material purchased during month $ 1,757,219 14 Direct Labor - Actual Costs & Data Status - Jobs Job # DL Hours DL Incurred 251 672$ 68,544 252 386 $ 39,372 253 742 $ 75,684 254 4,726 $ 482,052 255 4,997 $ 509,694 256 3,277 $ 334,254 257 6,169 $ 20,969 $ 629,238 2,138,838 Total Direct Labor Rate + Benefits / Hour $ 102 Total Payroll Incurred $ 2,353,844 Predetermined Overhead Information 2. Estimated Manufacturing Overhead $ 3 Estimated Activity - DLHS 13,478,400 207,360 11 in 5 - Indirect Material requisitioned $ 243,344 B e Indirect Labor incurred $ 215,006 0 -1 Total Actual Overhead cost-other than IM & IL $ 912,789 2 Clear all under and overapplied balances in MO at the end of the month 3 Job Status Billing markup % Job # End of month on total cost N 3 251 Completed 32% 4 252 WIP 32% 5 253 WIP 26% 6 254 Completed 24% 7 255 WIP 32% 8 256 Completed 45% 9 257 Completed 70% Raw Materials DR CR GL Control Accounts Payroll DR Mis. Overhead DR CR POR Rate Estimated MO Estimated DLHS Per DLH CR NDIV/0! Purchases DM IM Payroll DL IL IM IL Other Applied Adjust Balance Balance Balance WIP Finished Goods DR CR Cost of Goods Sold DR CR DR CR BB SBB DM DL MO + BB Job 251 Job 252 Job 253 Job 254 Job 255 Job 256 Job 257 Job 251 Job 252 Job 253 Job 254 5 Job 255 5 Job 256 Job 257 Balance Balance 0 Balance 0 Job Cost Sheets Reconciliation - WIP Status DL MO DM Total Job Detail Balance ob 251 Job 252 Job 253 Job 254 lob 255 ob 256 Job 257 Balance + Job Billing Balance Job 251 Job 252 Job 253 Job 254 Job 255 Job 256 Job 257 Balance Direct Materials DR CR Job Number 251 Direct Labor DR CR Mfg. Overhead DR CR BB BB alance Balance Balance 0 Job Summary DM DL MO Total Job 0 0 Status Budget WIP Complete Bill Status Unbilled Billed 0 1 2 1 Job Cost Summary - Current Status Budget Actual Variance Markup % Billing Billings DM DL MO Total Cost Profit Direct Materials DR CR Job Number 252 Direct Labor CR Mfg. Overhead DR CR DR BB BB BB Balance Balance Balance 0 0 > + 1 2 3 4 5 Job Summary DM DL Total Job Status Budget WIP Complete 0 1 2 Bill Status Unbilled Billed 0 1 LO 7 8 9 Job Cost Summary - Current Status Budget Actual Markup % Billing Variance 0 Billings 1 2 3 4 DM DL MO Total Cost 26 27 28 Profit Direct Materials DR CR Job Number 253 Direct Labor DR CR Mfg. Overhead DR CR BB BB BB Balance Balance Balance 0 0 > Job Summary DM DL MO Total Job Status Budget WIP Complete 0 1 2 Bill Status Unbilled Billed 0 1 Job Cost Summary. Current Status Budget Actual Markup 96 Billing Variance Billings - 3 DM DL MO Total Cost IT 5 5 7 Profit 3 Direct Materials DR CR Job Number 254 Direct Labor DR CR Mfg. Overhead DR CR BB BB BB Balance Balance Balance 0 0 Job Summary DM DL MO Total Job 3 Status Budget WIP Complete Bill Status Unbilled Billed 0 1 2 0 1 4 5 6 7 Job Cost Summary. Current Status Budget Actual Markup 8 9 0 1 Billing Variance Billings N 23 24 25 26 27 28 DM DL MO Total Cost Profit Piper Products Inc. is required to account for seven jobs during the current month (Job 251-257). Complete the posting of all job costs to the various jobs. Refer to the following excel worksheet: Job 251 Job 252 Job 253 Job 254 Job 255 Job 256 Job 257 . . Identify within each job its current status, i.e. budgetednot yet working, WIP, completed and transferred to Finished Goods, billed and sold-ie. out the door. Use the information given supplemental pages of the excel workshbet tabs, eg: Budgets Begin WIP DM Requisitions DL Costs MO Costs Other Data The POR rate is calculated based on Direct Labor Hours. Use the data on the MO Costs worksheet and calculate the rate on the GL Control worksheet. You may refer to the POR rate by using POR in a calculation, eg. =d18*POR Calculate the actual DL cost incurred by using the DLHs and the per-hour rate listed, place the result in the DL Costs worksheet in the appropriate cells. . 1 Budget Amounts - Job Cost Summary 2 Job # DM DL MO TOTAL Revenues 251 4 252 5 253 6 254 $224,056 $586,938 $635,060 $352,506 $656,920 $213,688 $411,615 $3,080,783 $349,926 $751,343 $781,918 $475,496 $772,426 $330,610 $668,419 $4,130,138 $227,450 $488,374 $508,246 $309,073 $502,078 $214,896 $384,719 $2,634,836 7 255 $801,432 $1,826,655 $1,925,224 $1,137,075 $1,931,424 $759,194 $1,464,753 $9,845,757 $1,041,862 $2,374,651 $2,464,284 $1,387,232 $2,510,850 $1,062,870 $2,209,721 $13,051,470 8 256 9 257 10 Total Jobs in WIP at the beginning of the month Job # DM DL Total 251 $ 643,158 252 $ 1,744,289 178,433 $ 565,807 $ 437,976 $ 1,182,216 $ 281,652 $ 714,232 $ 551,296 $ 1,547,180 $ 183,073 $ 464,250 $ 358,343 $ 1,005,666 $ 253 $ 1,347,615 3,735,062 Total $ 2 3 Direct Material Activity - Requisitions From Raw Material Inventory Job # Requisition # DM Requisitioned 251 REQ-190 47,796 252 REQ-191 $ 24,190 $ 4 253 REQ-192 $ 69,676 6 254 REQ-193 354,770 255 $ $ $ REQ-194 REQ-195 392,422 8 256 205,418 419,603 9 257 REQ-196 $ $ 10 Total 1,513,875 11 12 13 Raw material purchased during month $ 1,757,219 14 Direct Labor - Actual Costs & Data Status - Jobs Job # DL Hours DL Incurred 251 672$ 68,544 252 386 $ 39,372 253 742 $ 75,684 254 4,726 $ 482,052 255 4,997 $ 509,694 256 3,277 $ 334,254 257 6,169 $ 20,969 $ 629,238 2,138,838 Total Direct Labor Rate + Benefits / Hour $ 102 Total Payroll Incurred $ 2,353,844 Predetermined Overhead Information 2. Estimated Manufacturing Overhead $ 3 Estimated Activity - DLHS 13,478,400 207,360 11 in 5 - Indirect Material requisitioned $ 243,344 B e Indirect Labor incurred $ 215,006 0 -1 Total Actual Overhead cost-other than IM & IL $ 912,789 2 Clear all under and overapplied balances in MO at the end of the month 3 Job Status Billing markup % Job # End of month on total cost N 3 251 Completed 32% 4 252 WIP 32% 5 253 WIP 26% 6 254 Completed 24% 7 255 WIP 32% 8 256 Completed 45% 9 257 Completed 70% Raw Materials DR CR GL Control Accounts Payroll DR Mis. Overhead DR CR POR Rate Estimated MO Estimated DLHS Per DLH CR NDIV/0! Purchases DM IM Payroll DL IL IM IL Other Applied Adjust Balance Balance Balance WIP Finished Goods DR CR Cost of Goods Sold DR CR DR CR BB SBB DM DL MO + BB Job 251 Job 252 Job 253 Job 254 Job 255 Job 256 Job 257 Job 251 Job 252 Job 253 Job 254 5 Job 255 5 Job 256 Job 257 Balance Balance 0 Balance 0 Job Cost Sheets Reconciliation - WIP Status DL MO DM Total Job Detail Balance ob 251 Job 252 Job 253 Job 254 lob 255 ob 256 Job 257 Balance + Job Billing Balance Job 251 Job 252 Job 253 Job 254 Job 255 Job 256 Job 257 Balance Direct Materials DR CR Job Number 251 Direct Labor DR CR Mfg. Overhead DR CR BB BB alance Balance Balance 0 Job Summary DM DL MO Total Job 0 0 Status Budget WIP Complete Bill Status Unbilled Billed 0 1 2 1 Job Cost Summary - Current Status Budget Actual Variance Markup % Billing Billings DM DL MO Total Cost Profit Direct Materials DR CR Job Number 252 Direct Labor CR Mfg. Overhead DR CR DR BB BB BB Balance Balance Balance 0 0 > + 1 2 3 4 5 Job Summary DM DL Total Job Status Budget WIP Complete 0 1 2 Bill Status Unbilled Billed 0 1 LO 7 8 9 Job Cost Summary - Current Status Budget Actual Markup % Billing Variance 0 Billings 1 2 3 4 DM DL MO Total Cost 26 27 28 Profit Direct Materials DR CR Job Number 253 Direct Labor DR CR Mfg. Overhead DR CR BB BB BB Balance Balance Balance 0 0 > Job Summary DM DL MO Total Job Status Budget WIP Complete 0 1 2 Bill Status Unbilled Billed 0 1 Job Cost Summary. Current Status Budget Actual Markup 96 Billing Variance Billings - 3 DM DL MO Total Cost IT 5 5 7 Profit 3 Direct Materials DR CR Job Number 254 Direct Labor DR CR Mfg. Overhead DR CR BB BB BB Balance Balance Balance 0 0 Job Summary DM DL MO Total Job 3 Status Budget WIP Complete Bill Status Unbilled Billed 0 1 2 0 1 4 5 6 7 Job Cost Summary. Current Status Budget Actual Markup 8 9 0 1 Billing Variance Billings N 23 24 25 26 27 28 DM DL MO Total Cost Profit