+1-415-670-9189
info@expertsmind.com
How many of each robot they should produce
Course:- Other Subject
Reference No.:- EM132281457




Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Other Subject

Management Information Systems Assignment - Excel Solver

In this assignment, you are asked to solve three optimization problems using Excel Solver.

Question 1: What To Eat?

Jamie is planning to compete in her first mini triathlon this summer and wants to ensure her diet covers the energy she needs to train. The table below shows the foods she can choose from and their associated calories, some nutritional amounts, and cost. Using the information provided, determine the optimal diet (i.e. how many of each type of food) to consume that will minimize her cost and fulfil the following requirements:

Intake must be a minimum of:

3500 calories

15g protein

10g carbohydrates

And a maximum of:

20g salt

 

Sandwich

Energy Bar

Energy Drink

Trail Mix

Calories

450

200

200

400

Protein (grams)

5

5

0

2

Carbohydrates (grams)

3

5

4

4

Salt (grams)

3

5

1

2

Cost

$4.00

$3.50

$2.50

$4.00

Question 2: Cyclone Robotics

Cyclone Robotics needs some help to optimize their production. They want to make the best use of their existing resources to generate the highest possible profit. The company has asked you to help plan their upcoming production levels for the next quarter.

The company has provided the following data to help get you started:

It manufactures three types of robots, as shown below. As part of their contractual obligation, they must manufacture and distribute at least 10 of each robot to their retail partner. The table below shows the profit per unit, and the resources required per unit in the manufacturing process. The last column (furthest right) shows the total resources that are available for the upcoming quarter's production. Your task is to determine:

1. How many of each robot they should produce (given the production constraints), in order to generate the highest profit.

2. How does your answer change if they must manufacture and distribute a minimum of 11 of each robot to their retail partner? i.e. In a separate section of the same worksheet, enter the new quantities of each robot to produce under this constraint.

Robots

Kit

Cougar

Kat

Resources Available

Profit per user

$500

$1,150

$800

 

Resource Required per Unit

 

 

 

 

Labour Hours

6

15

11

850 hours

Machine Hours

7

19

12

1,200 hours

Compressors (units)

15

31

23

850 units

Motors (units)

5

9

7

250 units

Batteries (units)

2

10

6

200 units

Question 3: Total Tyre Distribution

Total Tyre Distribution wants to minimize the total shipping costs between their suppliers and their regional warehouses. Each supplier has a limited quantity of product to ship and each region has a specific demand projection that they need to fulfill. Given the information provided in the table below, how should the company stock their product? In other words, how many units should each supplier ship to each regional warehouse in order to minimize Total Tyre's shipping costs?

 

Shipping Capacity (units)

Shipping Costs per Unit to Regional Warehouses

West

Central West

Central

Central East

East

Okanagan

43,500

$1.70

$2.56

$1.95

$2.06

$2.95

Saskatoon

65,800

$1.97

$2.84

$1.93

$1.87

$1.48

Montreal

75,200

$2.17

$3.25

$2.50

$1.73

$1.26

Regional Demand in Units

46,300

32,200

29,400

37,500

39,100




Put your comment
 
View Conversion
Minimize
  1. user image
    len2281457

    In this assignment, you are asked to solve three optimization problems using Excel Solver. To get started, open a new Excel workbook and prepare three worksheets, naming the tabs Question 1, Question 2, Question 3. Save the workbook as first name_last name (e.g. Sam_Johnson.xlsx). Please enter your full name & student number into cell A1 on each worksheet. When finished, save and upload the workbook to the AS03 Moodle dropbox. You may work with a partner, but ensure both student names are included in cell A1. NB: For each question, please ensure you copy a screenshot of your solver parameter box onto the worksheet that contains your data.



Ask Question & Get Answers from Experts
Browse some more (Other Subject) Materials
What seems to be Edmundson's thesis, or main claim? What are his major pieces of evidence that support his claim? How persuasive is this evidence to you, and why? What does
Suppose that U.S. prices rise 4 percent over the next year while prices in Mexico rise 6 percent. According to the purchasing power parity theory of exchange rates, which of
Compare and contrast the concepts of optimism and hopefulness. Under what circumstances might optimism be harmful? What is defensive pessimism and under what circumstances m
Compare and contrast various views of Hinduism, Buddhism, and Taoism. Explain the connection between the Tao, Ying, and Yang. Articulate how principles of Taoism serve as the
Oscar is the warehouse manager for The OEM Connection, an auto parts business. Although the business standardized on Windows 7 Professional, Oscar needs to run a legacy parts
Determine three hindrances to the critical thinking process. Identify methods for overcoming these hindrances. Identify a time in which you experienced hindrance in critical
Define the disorder; causes and symptoms. Briefly discuss the historical and theoretical perspectives of this disorder and Discuss the cultural aspects and influences of this
An Art Museum that needs to track the artwork, artists, and locations where the art is displayed or stored within the museum. A similar environment that you have has some expe