Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Generate a summary scenario utilizing the seasonal sales forecasts. Utilize the scenario manager to craft a professional summary page encompassing the Black Friday, Post -

Generate a summary scenario utilizing the seasonal sales forecasts. Utilize the scenario manager to craft a professional
summary page encompassing the Black Friday, Post-Holiday Season, and Summer Back to School Scenarios. The
variables to be adjusted are the quantities for Xbox, Smart Watches, and Holographic Glasses. The outcome should
present Revenue and Total Profit. The scenario summary should look professional.
Information Black Friday Post-Holiday Season Summer Back to School
Xbox 800100100
Smart Watches 40020070
Holographic Glasses 4005020
Problem #3
Imagine you're managing the shipment of goods from two plants (Seattle and San Diego) to three markets (New York,
Chicago, and Topeka). The goal is to figure out the best way to ship these goods, considering the costs and meeting
supply and demand requirements.
Constraints Explanation:
1.Supply Constraints:
Seattle can only ship up to 350 units in total.
San Diego can only ship up to 600 units in total.
2. Demand Constraints:
New York needs at least 325 units.
Chicago needs at least 300 units.
Topeka needs at least 275 units.
3. Non-Negativity Constraints:
We can't ship a negative amount of goods.
Shipping Costs
New York Chicago Topeka
Seattle $2.5/unit $1.7/unit $1.8/unit
San Diego $2.5/unit $1.8/unit $1.4/unit
Objective:
Minimize the total shipping cost while satisfying the supply and demand constraints.
This transportation problem involves determining the optimal quantities to ship from each plant to each market, taking
into account the shipping costs and meeting the supply and demand requirements. Use this information to set up and
solve the optimization problem using a solver.
Enter the total shipment cost in Answer Sheet of excel file provided to you.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Management

Authors: Robbins, DeCenzo, Coulter

7th Edition

132996855, 0-13-610982-9 , 9780132996853, 978-0-13-61098, 978-0136109822

More Books

Students also viewed these General Management questions