please provide solution

The controller for Tulss Photographic S and cost drivers 219 pay has estahlished the tiowing s Badged Lave for Co Dverhend Activity Cast Peal Mactine setups Mterial handing LD 1,2,3, 4,s,T 5250,000 unres.ce ed Hszardeus waste 2500n Dher ovenead cst 0000 achire hous 20.000 An order for 1,000 boses of ilm developemet chemicals has tive following groduction reqainemems. Machine setups Row matesial ?laardous nateralo bepections Machine hous 5 setups 10,000 pounts 2 000 pounds 0 Irispectons 500 machine houns Required I. Compute the toal overhead that should be assigned to the developmest-chenical ondes 2. What is the overhcad cos per bux of chemicals? 3. Suppose Tulsa Photegraphic Supply Company were to use a single predetermsined overhead tate based on mchine heurs. Compute the rate per hour 4. Under the approuch in reqairement (3), bow much overhcad would be assigned so the develepment- chermical order a In total. Per box of chemicals 5. Explain why these two product-costing systems result in such widely dilfering costs, Whch ys em do you recommend? Why? ? nildo spreadileet. Construct an Excel spreadsheet to solve requirements (1), (2), (3), and 4 ahove Sbow how the solation will change if the following data chonge. The overbead 6. iaed wth machine setips $375.000, and there are 500 inspections budprted the stesedine groblem for Tusa Pho