Question

1 Approved Answer

Posted on Jul 25, 2024

please answer corretly thank you 72% 10:07 AM Sat Sep 5 cdn.inst-fs-ad-prod.inscloudgate.net ASSIGNMENT 2 - PREPARING A JOB COST SHEET FOR THE MULTI-SWING SET AND

please answer corretly thank you image text in transcribed

72% 10:07 AM Sat Sep 5 cdn.inst-fs-ad-prod.inscloudgate.net ASSIGNMENT 2 - PREPARING A JOB COST SHEET FOR THE MULTI-SWING SET AND ANALYZING COMPANY COSTS 1. Prepare a Job Cost Sheet based on the information and data provided. 2. Review the Completed Job Production Report and identify questionable items. 3. After completing these schedules, save this Excel file and upload it back to the Assignment in Canvas. This will be part of your Discussion Group grade. 4. All cells colored YELLOW should have text or data input into them. 5. You will need to prepare this Excel file so that you can participate in the Discussion Group INFORMATION ABOUT MULTI-SWING SET Andrew Willis is one the company carpenters who builds the Multi-Swing set. Using the information provided, complete the Job Cost Sheet for Job 6-12A. Information and Data: Andrew requistioned ten wooden boards from the inventory storage crib. Also, he requisitioned 20 feet of rope, and an eight foot length of steel for the slide. The costing system indicated the following: Wooden boards - $25.00 each; Rope - $3.00 per foot; Steel - $10.00 a foot. Andrew works an eight hour day. He started the job at 8:00p.m. on June 4 and completed it at 4:00p.m. on June 5. His hourly wage is $15.00 per hour and the company adds $5.00 per hour for payroll tax and health care. The company uses one Predetermined Overhead Rate for the entire factory. The rate for 2020 was based on the estimated overhead costs totaling $800,000, and the estimated 2020 direct labor costs to total $400,000 JOB COST SHEET The Job use as many lines as you need Jouber Deporte WA Dress Direct Labor Um Product 10:07 AM Sat Sep 5 72% cdn.inst-fs-lad-prod.inscloudgate.net overhead costs totaling $800,000, and the estimated 2020 direct labor costs to total $400,000 JOB COST SHEET The Job use as many lines as you need Departo DEM Rege A Direct Labor Mwing To U Product You are reviewing the Production Report showing costs for all the carpenters who worked on the Multi-Swing set. You want to confirm that everything "makes sense". Look for data that draws questions on the cost of assembling the product. Completed Job Production Report - Multi Swing Set Materials Department B A Carpenter Name Ali, M Babcock, W Canton, Morton, C Patel, Rodriguez, L Singh, S Tomasic, E Underwood, M Willis, A 390 388 0 394 388 SOS 380 384 390 390 Cost to Assemble Labor Mfg. Overhead 340 680 261 261 270 540 263 263 26 268 536 33 66 262 262 260 520 320 640 A TOTAL 1,410 910 810 920 1,183 1,309 479 908 1,170 1,350 A B A 10:07 AM Sat Sep 5 71% cdn.inst-fs-iad-prod.inscloudgate.net labor costs to total $400,000 The Job Cost Sheet Parco Job Com Show Number A. 103 Danemad Date Completed Department Wis Completed hem Wetencarpe Der Materials Des We Amount TicketHours Amount Tours Amount Commary | bale ( - Direct Labor Unit Product Com worked on the Multi-Swing set. You want to s on the cost of assembling the product. Swing Set Et to Assemble Mfg. Overhead 680 261 540 263 530 536 66 262 520 640 TOTAL 1,410 910 810 920 1.183 1,309 479 908 1.170 1,350 The Job Cost Sheet PearCo Job Cost Sheet Job Number A - 143 Date Initiated 3-4-17 Date Completed Department B3 Units Completed Item Wooden cargo crate Direct Materials Direct Labor Manufacturing Overhead Reg. No. Amount Ticket Hours Amount Hours Rate Amount Units Shipped Date Number Balance Cost Summary Direct Materiais Direct Labor Manufacturing Overhead Total Cost Unit Product Cost 72% 10:07 AM Sat Sep 5 cdn.inst-fs-ad-prod.inscloudgate.net ASSIGNMENT 2 - PREPARING A JOB COST SHEET FOR THE MULTI-SWING SET AND ANALYZING COMPANY COSTS 1. Prepare a Job Cost Sheet based on the information and data provided. 2. Review the Completed Job Production Report and identify questionable items. 3. After completing these schedules, save this Excel file and upload it back to the Assignment in Canvas. This will be part of your Discussion Group grade. 4. All cells colored YELLOW should have text or data input into them. 5. You will need to prepare this Excel file so that you can participate in the Discussion Group INFORMATION ABOUT MULTI-SWING SET Andrew Willis is one the company carpenters who builds the Multi-Swing set. Using the information provided, complete the Job Cost Sheet for Job 6-12A. Information and Data: Andrew requistioned ten wooden boards from the inventory storage crib. Also, he requisitioned 20 feet of rope, and an eight foot length of steel for the slide. The costing system indicated the following: Wooden boards - $25.00 each; Rope - $3.00 per foot; Steel - $10.00 a foot. Andrew works an eight hour day. He started the job at 8:00p.m. on June 4 and completed it at 4:00p.m. on June 5. His hourly wage is $15.00 per hour and the company adds $5.00 per hour for payroll tax and health care. The company uses one Predetermined Overhead Rate for the entire factory. The rate for 2020 was based on the estimated overhead costs totaling $800,000, and the estimated 2020 direct labor costs to total $400,000 JOB COST SHEET The Job use as many lines as you need Jouber Deporte WA Dress Direct Labor Um Product 10:07 AM Sat Sep 5 72% cdn.inst-fs-lad-prod.inscloudgate.net overhead costs totaling $800,000, and the estimated 2020 direct labor costs to total $400,000 JOB COST SHEET The Job use as many lines as you need Departo DEM Rege A Direct Labor Mwing To U Product You are reviewing the Production Report showing costs for all the carpenters who worked on the Multi-Swing set. You want to confirm that everything "makes sense". Look for data that draws questions on the cost of assembling the product. Completed Job Production Report - Multi Swing Set Materials Department B A Carpenter Name Ali, M Babcock, W Canton, Morton, C Patel, Rodriguez, L Singh, S Tomasic, E Underwood, M Willis, A 390 388 0 394 388 SOS 380 384 390 390 Cost to Assemble Labor Mfg. Overhead 340 680 261 261 270 540 263 263 26 268 536 33 66 262 262 260 520 320 640 A TOTAL 1,410 910 810 920 1,183 1,309 479 908 1,170 1,350 A B A 10:07 AM Sat Sep 5 71% cdn.inst-fs-iad-prod.inscloudgate.net labor costs to total $400,000 The Job Cost Sheet Parco Job Com Show Number A. 103 Danemad Date Completed Department Wis Completed hem Wetencarpe Der Materials Des We Amount TicketHours Amount Tours Amount Commary | bale ( - Direct Labor Unit Product Com worked on the Multi-Swing set. You want to s on the cost of assembling the product. Swing Set Et to Assemble Mfg. Overhead 680 261 540 263 530 536 66 262 520 640 TOTAL 1,410 910 810 920 1.183 1,309 479 908 1.170 1,350 The Job Cost Sheet PearCo Job Cost Sheet Job Number A - 143 Date Initiated 3-4-17 Date Completed Department B3 Units Completed Item Wooden cargo crate Direct Materials Direct Labor Manufacturing Overhead Reg. No. Amount Ticket Hours Amount Hours Rate Amount Units Shipped Date Number Balance Cost Summary Direct Materiais Direct Labor Manufacturing Overhead Total Cost Unit Product Cost