accurately che Exercises 5-15 - Page 141 (6 points) Sigma Company produces three versions of a brass desk lamp: basic, custom, and deluxe. The planned production information for the upcoming month follows: Cost per Hours per Total Resources Direct labor Indirect labor cost Machinery Fringe Benefits $800 $600 Month $4,270 $4,210 $50,000 Basic $170 $40 Month 130 130 250 $5,070 4,810 $50,000 Deluxe $230 $55 Selling price per unit Durect materials cost per unit Custom $190 $50 Deluxe 1.200 3.00 3,600 0.09 Production Information Production and sales volume (unsts) Direct labor hours per unit Total direct labor Machine bours per unit Total machine run time (hours) Number of production runs Setup time per production run (machine hours) Total setup time (machine houts) Total machine hours Basic 4,500 2.00 9.000 0.05 225 12.00 200 24.00 249 Custom 3,200 2.50 8,000 0.08 256 10.00 1.00 10.00 266 108 8.00 2.50 20.00 128 Provide you Answer in an Excel file that you create and Upload to Canvas Indirect laber data Setup time perrun (hours) Number of employees per setup Indirect labor hours per setup 600 3.00 4 12.00 4.00 4 16.00 24.00 Indesto meet anticipated demand for the upcoming month, Sigma Company plans to rent three machines, cach costing $50,000 per month and hire four indirect workers, each costing $4,810 per month. The total cost of the three machines and four indirect workers comprises the total overhead cost at Sigma Company Required 1 Given the production plan what is the dela prodact's planned total contribution margin? If Sigma Company computes a plantwide rate to allocate total overhead cost to the three products by dividing the sum of indirect labor cost and machine cost by planned total direct labor hours, what is the total overhead cost that will be allocated to the deluxe product, and what will be its resulting sro CIF Sigma Company uses TDABC to allocate the indurect labor cost and the machine cost to the three products, what will be the total overhead cost allocated to the deluxe product, and what will be its resulting grossar? accurately che Exercises 5-15 - Page 141 (6 points) Sigma Company produces three versions of a brass desk lamp: basic, custom, and deluxe. The planned production information for the upcoming month follows: Cost per Hours per Total Resources Direct labor Indirect labor cost Machinery Fringe Benefits $800 $600 Month $4,270 $4,210 $50,000 Basic $170 $40 Month 130 130 250 $5,070 4,810 $50,000 Deluxe $230 $55 Selling price per unit Durect materials cost per unit Custom $190 $50 Deluxe 1.200 3.00 3,600 0.09 Production Information Production and sales volume (unsts) Direct labor hours per unit Total direct labor Machine bours per unit Total machine run time (hours) Number of production runs Setup time per production run (machine hours) Total setup time (machine houts) Total machine hours Basic 4,500 2.00 9.000 0.05 225 12.00 200 24.00 249 Custom 3,200 2.50 8,000 0.08 256 10.00 1.00 10.00 266 108 8.00 2.50 20.00 128 Provide you Answer in an Excel file that you create and Upload to Canvas Indirect laber data Setup time perrun (hours) Number of employees per setup Indirect labor hours per setup 600 3.00 4 12.00 4.00 4 16.00 24.00 Indesto meet anticipated demand for the upcoming month, Sigma Company plans to rent three machines, cach costing $50,000 per month and hire four indirect workers, each costing $4,810 per month. The total cost of the three machines and four indirect workers comprises the total overhead cost at Sigma Company Required 1 Given the production plan what is the dela prodact's planned total contribution margin? If Sigma Company computes a plantwide rate to allocate total overhead cost to the three products by dividing the sum of indirect labor cost and machine cost by planned total direct labor hours, what is the total overhead cost that will be allocated to the deluxe product, and what will be its resulting sro CIF Sigma Company uses TDABC to allocate the indurect labor cost and the machine cost to the three products, what will be the total overhead cost allocated to the deluxe product, and what will be its resulting grossar