teuer furniture case study 1

I need help with solving this case study excel templet and the questions in the CaseStudyGuideline file. It needs to be short, around 5-7 pages with detailed explanation. I have attached all the required information.