Questions 3.16,3.18, 3.21, 3.36

the questions in the attachments folder are from the book MCgraw hill introduction to management science fourth edition. I also need you to solve it on excel spread sheet.