Mechanical Product Innovation 1All requirements in the file attachedSimilarity should be less than 5%plagrisim report is neededFor any clarification please ask

Assignment

Instructions

Please, follow the following instructions. Failure to do so will result in a 0 in those parts that do not comply with them.

Your submission will consist of the following files:

A computer-typed Word file that contains the solution to the problems in this assignment. For equations, use Microsoft Word’s equation editor. Use figures as needed. This Word file must include the LP formulation required in Problem 1a (including definition of variables objective function, constraints, and final model, as seen in class) and the numerical solutions and interpretations of all other problems or subproblems in this assignment.
An Excel file that contains three tabs (Problem 1b, Problem 2, Problem 3) with Solver’s solution to these problems. Note that it is imperative that Excel file and Solver are set up so the grader can run the model with Solver and obtain a solution immediately.
In both files, the names of all the group members must appear.

Problem 1 (35 pt)

Bowman & Kinkins (B&K) is a hi-fi speaker manufacturer. They proudly engineer and manufacture their speakers in the United Kingdom. To celebrate their 75-year anniversary, they will release a Limited Edition of their most well-known speakers from the acclaimed 6000 Series, the floorstanding speaker B&K 6003.

B&K has three manufacturing plants in the UK (Manchester, Edinburgh, Southampton) that will be in charge of producing a first batch of these hi-fi limited-edition speakers. Their production will be sent to B&K’s distribution centers in other continents. More concisely, these distribution centers are located in Santiago de Chile (Chile), Atlanta (USA), Frankfurt (Germany), and Shanghai (China). The cost of producing these speakers varies with the location they are produced at. Likewise, transporting them to the company’s distribution centers has a variable transportation cost that depends on the route. Production costs and capacities for the next month are given in Table 1. The amount that needs to be put in inventory in each distribution center is shown in Table 2. The transportation costs (in USD/speaker) are given in Table 3.

 
Production cost (per speaker)
Capacity (in speakers)

Manchester
$100
100

Edinburgh
$75
100

Southampton
$90
80

Table 1

 
Santiago
Atlanta
Frankfurt
Shanghai

Demand (tons)
80
70
60
40

Table 2

Shipping cost (per speaker)
Santiago
Atlanta
Frankfurt
Shanghai

Manchester
11
8
4
15

Edinburgh
12
9
4
12

Southampton
10
8
4
13

Table 3

(18pt) Problems in B&K’s procurement of raw materials has resulted in shortage of their production capacity. Consequently, their new production capacities are shown in Table 4. Formulate an LP model that can at least tell B&K how to better distribute the production they can come up with.
(17pt) Solve this model with Excel and interpret its solution.

 
Production cost (per speaker)
Capacity (in speakers)

Manchester
$100
45

Edinburgh
$75
70

Southampton
$90
55

Table 4

Problem 2 (30 pt)

Consider the network below:

If the numbers by the edges indicate distance, use Excel’s Solver to find the shortest path between nodes 1 and 7. Note that arcs can be traversed in both directions. Clearly indicate this path.

Problem 3 (35 pt)

Consider the network below:

If the numbers by the edges indicate capacity, use Excel’s Solver to find the maximum flow that can be sent between nodes s and t. Clearly indicate the value of this flow and the way it would traverse the network.

Get professional assignment help cheaply

Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?

Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.

Our essay writers are graduates with diplomas, bachelor, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.

Why choose our academic writing service?

Plagiarism free papers
Timely delivery
Any deadline
Skilled, Experienced Native English Writers
Subject-relevant academic writer
Adherence to paper instructions
Ability to tackle bulk assignments
Reasonable prices
24/7 Customer Support
Get superb grades consistently

Get Professional Assignment Help Cheaply
Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?
Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.
Our essay writers are graduates with diplomas, bachelor’s, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.
Why Choose Our Academic Writing Service?

Plagiarism free papers
Timely delivery
Any deadline
Skilled, Experienced Native English Writers
Subject-relevant academic writer
Adherence to paper instructions
Ability to tackle bulk assignments
Reasonable prices
24/7 Customer Support
Get superb grades consistently

How It Works
1.      Place an order
You fill all the paper instructions in the order form. Make sure you include all the helpful materials so that our academic writers can deliver the perfect paper. It will also help to eliminate unnecessary revisions.
2.      Pay for the order
Proceed to pay for the paper so that it can be assigned to one of our expert academic writers. The paper subject is matched with the writer’s area of specialization.
3.      Track the progress
You communicate with the writer and know about the progress of the paper. The client can ask the writer for drafts of the paper. The client can upload extra material and include additional instructions from the lecturer. Receive a paper.
4.      Download the paper
The paper is sent to your email and uploaded to your personal account. You also get a plagiarism report attached to your paper.

 

PLACE THIS ORDER OR A SIMILAR ORDER WITH Essay fount TODAY AND GET AN AMAZING DISCOUNT

The post mechanical innovation requirement appeared first on Essay fount.


What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."


"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"