help please!

Novcllo Medical Center has a single opecating room that is used by local physicians to perform surgical procedures. The cost of using the operating room is accurnulated by each patient procedure and indludes the direct matenads conts (drugs and medical devices), physician rurgical tame, and operating room overbead. On danuary 1 of the current yeac, the annuat operabing rookn cverthead is estamated to be: The oveibead costs will be aswgned to procedures based on the number of surgcal room hours. Novello Medical Center exgects to use the operating room an averaye of eght hours per day, seven days per week, In addibon, the operating room will be shut done two weeks per year for general repairs. This infurmation has been collected in the Miconoft Excet Online file. Open the spreadsheet, perform the required analyms, and inpur your anwwees in the questions below. Open spredishcet a. Compute the estimated number of eperating room hours for the yeat. hours b. Dei ane the predetemined operating room overhead rate for the year. Round your anwer to the nearest dollar. The overhead costs will be assigned to procedures based on the number of surgical room hours. Novello Medical Center expects to use the operating room an average of eight bours per day, seven doys per week. In adbtion, the operating room will be shit down two weeks per year for generat repairs. This information has been collected in the Maresoft Excel Online lile. Open the spreadshect, perform the required analysis, and input your answers in the questions befow. Open speredsheet a. Compute the esfimated number of operating room hours for the year. hours b. Determine the predetermined operating foom everhead rate for the year, Round your answer to the nearest dollas. per hour c. Conrad Goldsmith had a three-hour procedure on lanuary 22. Hew much operating room overthead would be charged to his procedure, using the rate determaned in part (b)? Round your answer to the nearest dollar. a. Duriniliary, the operating room was used 230 hours. The actial overhead costs incuired for January were 553,900 . Determine the overapolied operatfig overhead of anderimnued operating overtied for the period. Enter vour aniner os a poctwe mumber, Round your answer to the nearest dollat. Predelermined factory overhesd rate Novello Medical Center has a single operabing room that is used by focal physicians to perform surgical procodures. The cost of using the cperating room is accumulaled by each patient procodure and includes the direct materials costs (drugs and medical devices) physician surgical time. and ogerating room cverhead On Jasuary 1 of the current year, the annual operating room overhead is estimated to be The ovethoad costs wil be assigned to procedures, based on the number of surpicul ioom hours. The number of hours per day and days per week during which Novello Medical Centor expects to use the oserating room and the nuntbor of woeks per year during which the operating room wil be shit down for general repars are provided bulow Using formulas and cell reterences, perform the required anaysis. and input your answers into the Amounts columen Enter underappled overhead if any, as a negative value. Transter the numeric results for tho greon entry cetls (C24, C26, C29, and C33) into the appropriate fiolds in CNOWV2 for grading The orentead costs wit be assigned to proceduses, based on the number of surgical foom hours. The number of hours por day and days per week durng which Novello Modical Center expects to use the cperating room and the number of weeks per year durng which the operating toom will be shat down for general ropais aro providod bolow Using formulas and cell reforences, perform the requred analysis; and input your answers into the Amounts column Enter underapoled ovethead, if any, as a neghtve value. Transfer the numbnc results for teo green entry cotts (C24, C26, C20, and C33) into the appropriste telts in CNOWV2 for grading