here is the question! can you please do it in an excel spreadsheet and inclue numbers and formulas! thank you!

BULDING YOUR SKILLS ANALYIICAL THINKTNG LO5-2, LO5-3, LO5-4 "I think we goofed when we hired that new assistant controller," said Ruth Scarpino, president of Provost Industries. "Just look at this report that he prepared for last month for the Finishing Department. I can't understand it." Finishing Department costs: Work in process inventory, April 1, 450 units; materials 100% complete; conversion 60% complete "He's struggling to learn our system," replied Frank Harrop, the operations manager. "The problem is that he's been away from process costing for a long time, and it's coming back slowly." "It's not just the format of his report that I'm concerned about. Look at that $25.71 unit cost that he's come up with for April. Doesn't that seem high to you?" said Ms. Scarpino. "Yes, it does seem high; but on the other hand, I know we had an increase in materials prices during April, and that may be the explanation," replied Mr. Harrop. "I'll get someone else to redo this report and then we can see what's going on." Provost Industries manufactures a ceramic product that goes through two processing departments-Molding and Finishing. The company uses the weighted-average method in its process costing. Required: 1. Prepare a report for the Finishing Department showing how much cost should have been assigned to the units completed and transferred to finished goods, and how much cost should have been assigned to ending work in process inventory in the Finishing Department. 2. Explain to the president why the unit cost on the new assistant controller's report is so high