Create a spreadsheet model for this problem and solve it to determine the optimal solution.

Order Description
Please find attach documents for assignment requiremnets and assignment deliverables information…..I have also attach lectures documents for this assignment guide.