Here’s a little help with week 2 [Essay writing service – your education, our expertise: Get any assignment done with our professional essay writers before your deadlines – Zero AI, Human experts and Fast delivery.] homework; The first three problems are from Tuesday’s Session (3). See the Excel examples on tabs 5,6,7. Remember you can delete middle rows and columns from the examples to fit these problems. Do make sure they are from the middle of the array, not the ends.<\/p>\n
First is a Make\/Buy problem. It is a 6 by 6 problem. See pages 153-156. Use SOLVER here.<\/p>\n
Second is a Production Scheduling problem. It is a 10 by 12 problem. See pages 157-163. us SOLVER here.<\/p>\n
Third is a product mix. It is a 3 by 3 problem. problem. See pages 163-164. Write Equations only.<\/p>\n
Instructions<\/p>\n
The way that you write your answers matters! Syntax matters! Before you take this homework, be sure that you have successfully completed the “Getting Started in Web Assign for Mathematics” quiz this week. This quiz provides 2 bonus points that can be used during the course, and, most importantly, makes it clear how to provide answers that the homework and quizzes understand.<\/p>\n
Description<\/p>\n
Assignment Submission & Scoring<\/p>\n
Assignment Submission<\/p>\n
For this assignment, you submit answers by question parts. The number of submissions remaining for each question part only changes if you submit or change the answer.<\/p>\n
Assignment Scoring<\/p>\n
Your last submission is used for your score.<\/p>\n
1.<\/p>\n
A linear programming computer package is needed.<\/p>\n
Frandec Company manufactures, assembles, and rebuilds material-handling equipment used in warehouses and distribution centers. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and a metal strap. Frandec’s production schedule calls for 5,500 Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing and purchase costs per unit are shown.<\/p>\n
Component<\/p>\n
Manufacturing Cost<\/p>\n
Purchase Cost<\/p>\n
Frame<\/p>\n
$39.00<\/p>\n
$52.00<\/p>\n
Support<\/p>\n
$12.50<\/p>\n
$16.00<\/p>\n
Strap<\/p>\n
$7.50<\/p>\n
$8.50<\/p>\n
Three departments are involved in the production of these components. The time (in minutes per unit) required to process each component in each department and the available capacity (in hours) for the three departments are as follows.<\/p>\n
Component<\/p>\n
Department<\/p>\n
Cutting<\/p>\n
Milling<\/p>\n
Shaping<\/p>\n
Frame<\/p>\n
3.5<\/p>\n
2.2<\/p>\n
3.1<\/p>\n
Support<\/p>\n
1.3<\/p>\n
1.7<\/p>\n
2.6<\/p>\n
Strap<\/p>\n
0.8<\/p>\n
\u2014<\/p>\n
1.7<\/p>\n
Capacity (hours)<\/p>\n
350<\/p>\n
420<\/p>\n
680<\/p>\n
(a)<\/p>\n
Formulate and solve a linear programming model for this make-or-buy application. (Let FM = number of frames manufactured, FP = number of frames purchased, SM = number of supports manufactured, SP = number of supports purchased, TM = number of straps manufactured, and TP = number of straps purchased. Express time in minutes per unit.)<\/p>\n
Min<\/p>\n
Cutting constraint<\/p>\n
Milling constraint<\/p>\n
Shaping constraint<\/p>\n
Frame constraint<\/p>\n
Support constraint<\/p>\n
Strap constraint<\/p>\n
FM, FP, SM, SP, TM, TP \u2265 0<\/p>\n
How many of each component should be manufactured and how many should be purchased? (Round your answers to the nearest whole number.)<\/p>\n
(FM, FP, SM, SP, TM, TP) =<\/p>\n
(b)<\/p>\n
What is the total cost (in $) of the manufacturing and purchasing plan?<\/p>\n
$<\/p>\n
(c)<\/p>\n
How many hours of production time are used in each department? (Round your answers to two decimal places.)<\/p>\n
Cutting hrs<\/p>\n
Milling hrs<\/p>\n
Shaping hrs<\/p>\n
(d)<\/p>\n
How much (in $) should Frandec be willing to pay for an additional hour of time in the shaping department?<\/p>\n
$<\/p>\n
(e)<\/p>\n
Another manufacturer has offered to sell frames to Frandec for $45 each. Could Frandec improve its position by pursuing this opportunity? Why or why not? (Round your answer to three decimal places.)<\/p>\n
. The reduced cost of indicates that the solution be improved.<\/p>\n
2.<\/p>\n
A linear programming computer package is needed.<\/p>\n
EZ-Windows, Inc., manufactures replacement windows for the home remodeling business. In January, the company produced 15,000 windows and ended the month with 9,000 windows in inventory. EZ-Windows’ management team would like to develop a production schedule for the next three months. A smooth production schedule is obviously desirable because it maintains the current workforce and provides a similar month-to-month operation. However, given the sales forecasts, the production capacities, and the storage capabilities as shown, the management team does not think a smooth production schedule with the same production quantity each month possible.<\/p>\n
February<\/p>\n
March<\/p>\n
April<\/p>\n
Sales forecast<\/p>\n
15,000<\/p>\n
16,500<\/p>\n
20,000<\/p>\n
Production capacity<\/p>\n
14,000<\/p>\n
14,000<\/p>\n
18,000<\/p>\n
Storage capacity<\/p>\n
6,000<\/p>\n
6,000<\/p>\n
6,000<\/p>\n
The company’s cost accounting department estimates that increasing production by one window from one month to the next will increase total costs by $1.00 for each unit increase in the production level. In addition, decreasing production by one unit from one month to the next will increase total costs by $0.65 for each unit decrease in the production level. Ignoring production and inventory carrying costs, formulate a linear programming model that will minimize the cost of changing production levels while still satisfying the monthly sales forecasts. (Let F = number of windows manufactured in February, M = number of windows manufactured in March, A = number of windows manufactured in April, I1 = increase in production level necessary during month 1, I2 = increase in production level necessary during month 2, I3 = increase in production level necessary during month 3, D1 = decrease in production level necessary during month 1, D2 = decrease in production level necessary during month 2, D3 = decrease in production level necessary during month 3, s1 = ending inventory in month 1, s2 = ending inventory in month 2, and s3 = ending inventory in month 3.)<\/p>\n
Min<\/p>\n
s.t.February Demand<\/p>\n
March Demand<\/p>\n
April Demand<\/p>\n
Change in February Production<\/p>\n
Change in March Production<\/p>\n
Change in April Production<\/p>\n
February Production Capacity<\/p>\n
March Production Capacity<\/p>\n
April Production Capacity<\/p>\n
February Storage Capacity<\/p>\n
March Storage Capacity<\/p>\n
April Storage Capacity<\/p>\n
Find the optimal solution.<\/p>\n
(F, M, A, I1, I2, I3, D1, D2, D3, s1, s2, s3) =<\/p>\n
Cost = $<\/p>\n
\u00b7<\/p>\n
\u00b7<\/p>\n
3.<\/p>\n
The Ace Manufacturing Company has orders for three similar products.<\/p>\n
Product<\/p>\n
Orders (units)<\/p>\n
AA<\/p>\n
1,800<\/p>\n
BB<\/p>\n
400<\/p>\n
CC<\/p>\n
1,400<\/p>\n
Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are shown below.<\/p>\n
Machine<\/p>\n
Capacity (units)<\/p>\n
11<\/p>\n
1,700<\/p>\n
22<\/p>\n
1,400<\/p>\n
33<\/p>\n
800<\/p>\n
Machine<\/p>\n
Product<\/p>\n
1<\/p>\n
2<\/p>\n
3<\/p>\n
A<\/p>\n
$1.00<\/p>\n
$1.30<\/p>\n
$1.10<\/p>\n
B<\/p>\n
$1.20<\/p>\n
$1.40<\/p>\n
$1.00<\/p>\n
C<\/p>\n
$0.90<\/p>\n
$1.20<\/p>\n
$1.20<\/p>\n
Use the transportation model to develop the minimum cost production schedule for the products and machines.<\/p>\n
(a)<\/p>\n
Show the linear programming formulation. (Let xA1 be the number of units of product A produced by machine 1,<\/p>\n
xij<\/p>\n
be the number of units of product i produced by machine j, etc.)<\/p>\n
Min<\/p>\n
s.t.Machine 1 Capacity<\/p>\n
Machine 2 Capacity<\/p>\n
Machine 3 Capacity<\/p>\n
Product A Orders<\/p>\n
Product B Orders<\/p>\n
Product C Orders<\/p>\n
xij \u2265 0 for all i, j.<\/p>\n
(b)<\/p>\n
Show the production schedule.<\/p>\n
(xA1, xA2, xA3, xB1, xB2, xB3, xC1, xC2, xC3) =<\/p>\n
(c)<\/p>\n
Determine the cost (in dollars) of the production schedule.<\/p>\n
Total = $<\/p>\n
4.<\/p>\n
Scott and Associates, Inc., is an accounting firm that has three new clients. Project leaders will be assigned to the three clients. Based on the different backgrounds and experiences of the leaders, the various leader-client assignments differ in terms of project ( help with nursing paper writing from experts with MSN & DNP degrees)ed completion times. The possible assignments and the estimated completion times in days are as follows.<\/p>\n
Project Leader<\/p>\n
Client<\/p>\n
1<\/p>\n
2<\/p>\n
3<\/p>\n
Jackson1<\/p>\n
10<\/p>\n
16<\/p>\n
32<\/p>\n
Ellis2<\/p>\n
14<\/p>\n
22<\/p>\n
40<\/p>\n
Smith3<\/p>\n
22<\/p>\n
24<\/p>\n
34<\/p>\n
(a)<\/p>\n
Develop a network representation of this problem. (Submit a file with a maximum size of 1 MB.)<\/p>\n
This answer has not been graded yet.<\/p>\n
(b)<\/p>\n
Formulate the problem as a linear program. (Express your answers in the form xij where xij represents the completion time from leader i to client j.)<\/p>\n
Min<\/p>\n
s.t.Jackson<\/p>\n
Ellis<\/p>\n
Smith<\/p>\n
Client 1<\/p>\n
Client 2<\/p>\n
Client 3<\/p>\n
xij \u2265 0 for all i, j.<\/p>\n
Solve.<\/p>\n
Relationship<\/p>\n
Assignment<\/p>\n
Time (days)<\/p>\n
x11<\/p>\n
x12<\/p>\n
x13<\/p>\n
x21<\/p>\n
x22<\/p>\n
x23<\/p>\n
x31<\/p>\n
x32<\/p>\n
x33<\/p>\n
What is the total time required (in days)?<\/p>\n
days<\/p>\n
5.<\/p>\n
Consider the following network representation of a transportation problem.<\/p>\n
Diagram Description automatically generated<\/p>\n
A network diagram between five locations is shown. The left-hand side of the graph is labeled “Supplies” and lists Jefferson City and Omaha. The right-hand side of the graph is labeled “Demands” and lists Des Moines, Kansas City, and St. Louis. Lines are shown between various locations. The following list contains the numbers placed on the graph.<\/p>\n
\u00b7 Jefferson City: 45<\/p>\n
\u00b7 Omaha: 40<\/p>\n
\u00b7 Des Moines: 20<\/p>\n
\u00b7 Kansas City: 15<\/p>\n
\u00b7 St. Louis: 50<\/p>\n
\u00b7 Jefferson City\u2013Des Moines: 16<\/p>\n
\u00b7 Jefferson City\u2013Kansas City: 9<\/p>\n
\u00b7 Jefferson City\u2013St. Louis: 8<\/p>\n
\u00b7 Omaha\u2013Des Moines: 8<\/p>\n
\u00b7 Omaha\u2013Kansas City: 10<\/p>\n
\u00b7 Omaha\u2013St. Louis: 23<\/p>\n
The supplies, demands, and transportation costs per unit are shown on the network.<\/p>\n
(a)<\/p>\n
Develop a linear programming model for this problem; be sure to define the variables in your model.<\/p>\n
Let<\/p>\n
\u00b7 x11 = amount shipped from Jefferson City to Des Moines<\/p>\n
\u00b7 x12 = amount shipped from Jefferson City to Kansas City<\/p>\n
\u00b7 x13 = amount shipped from Jefferson City to St. Louis<\/p>\n
\u00b7 x21 = amount shipped from Omaha to Des Moines<\/p>\n
\u00b7 x22 = amount shipped from Omaha to Kansas City<\/p>\n
\u00b7 x23 = amount shipped from Omaha to St. Louis<\/p>\n
Min<\/p>\n
x11<\/p>\n
+<\/p>\n
x12<\/p>\n
+<\/p>\n
x13<\/p>\n
+<\/p>\n
x21<\/p>\n
+<\/p>\n
x22<\/p>\n
+<\/p>\n
x23<\/p>\n
s.t.<\/p>\n
x11<\/p>\n
+<\/p>\n
x12<\/p>\n
+<\/p>\n
x13<\/p>\n
\u2264<\/p>\n
x21<\/p>\n
+<\/p>\n
x22<\/p>\n
+<\/p>\n
x23<\/p>\n
\u2264<\/p>\n
x11<\/p>\n
+<\/p>\n
x21<\/p>\n
=<\/p>\n
x12<\/p>\n
+<\/p>\n
x22<\/p>\n
=<\/p>\n
x13<\/p>\n
+<\/p>\n
x23<\/p>\n
=<\/p>\n
x11, x12, x13, x21, x22, x23 \u2265 0<\/p>\n
(b)<\/p>\n
Solve the linear program to determine the optimal solution.<\/p>\n
Amount<\/p>\n
Cost<\/p>\n
Jefferson City\u2013Des Moines<\/p>\n
Jefferson City\u2013Kansas City<\/p>\n
Jefferson City\u2013St. Louis<\/p>\n
Omaha\u2013Des Moines<\/p>\n
Omaha\u2013Kansas City<\/p>\n
Omaha\u2013St. Louis<\/p>\n
Total<\/p>\n
6.<\/p>\n
Cleveland Area Rapid Delivery (CARD) operates a delivery service in the Cleveland metropolitan area. Most of CARD’s business involves rapid delivery of documents and parcels between offices during the business day. CARD promotes its ability to make fast and on-time deliveries anywhere in the metropolitan area. When a customer calls with a delivery request, CARD quotes a guaranteed delivery time. The following network shows the street routes available. The numbers above each arc indicate the travel time in minutes between the two locations.<\/p>\n
A picture containing text, watch, different Description automatically generated<\/p>\n
A network diagram between six parties, distributed across four columns, is shown. The left-most column contains node 1. The second column contains nodes 2 and 3. The third column contains nodes 4 and 5. The right-most column contains node 6. Lines are shown between various locations. The following list contains the numbers placed on the graph.<\/p>\n
\u00b7 1\u20132: 35<\/p>\n
\u00b7 1\u20133: 30<\/p>\n
\u00b7 2\u20131: 35<\/p>\n
\u00b7 2\u20133: 12<\/p>\n
\u00b7 2\u20134: 18<\/p>\n
\u00b7 2\u20136: 39<\/p>\n
\u00b7 3\u20131: 30<\/p>\n
\u00b7 3\u20132: 12<\/p>\n
\u00b7 3\u20135: 15<\/p>\n
\u00b7 4\u20132: 18<\/p>\n
\u00b7 4\u20135: 12<\/p>\n
\u00b7 4\u20136: 16<\/p>\n
\u00b7 5\u20133: 15<\/p>\n
\u00b7 5\u20134: 12<\/p>\n
\u00b7 5\u20136: 30<\/p>\n
\u00b7 6\u20132: 39<\/p>\n
\u00b7 6\u20134: 16<\/p>\n
\u00b7 6\u20135: 30<\/p>\n
(a)<\/p>\n
Develop a linear programming model that can be used to find the minimum time required to make a delivery from location 1 to location 6. (Express your answers in the form xij, where each xij represents the arc from node i to node j as either 1 or 0.)<\/p>\n
Min<\/p>\n
s.t.Node 1 Flows<\/p>\n
Node 2 Flows<\/p>\n
Node 3 Flows<\/p>\n
Node 4 Flows<\/p>\n
Node 5 Flows<\/p>\n
Node 6 Flows<\/p>\n
For all xij = 0, 1.<\/p>\n
(b)<\/p>\n
How long (in minutes) does it take to make a delivery from location 1 to location 6? (Round your answer to the nearest whole number.)<\/p>\n
min<\/p>\n
(c)<\/p>\n
Assume that it is now 1:00 p.m. and that CARD just received a request for a pickup at location 1. The closest CARD courier is 8 minutes away from location 1. If CARD provides a 20% safety margin in guaranteeing a delivery time, what is the minimum guaranteed delivery time if the package picked up at location 1 is to be delivered to location 6? (Enter your answer in standard time. Round your answer to the nearest minute.)<\/p>\n","protected":false},"excerpt":{"rendered":"
Here’s a little help with week 2 [Essay writing service – your education, our expertise: Get any assignment done with our professional essay writers before\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[479,172,478],"tags":[181,21,535,31,527,534,536,526,532,533,531,530,525,528,27,529],"class_list":["post-12228","post","type-post","status-publish","format-standard","hentry","category-nursing-course-hero","category-nursing-study-bay","category-nursing-study-pool","tag-buy-psychology-essay","tag-nursing-assignment-writing-service-uk","tag-nursing-essay-writing","tag-nursing-essay-writing-service","tag-nursing-essay-writing-service-uk","tag-nursing-essay-writing-uk","tag-nursing-essays-online","tag-nursing-essays-uk","tag-psychology-assignment-writing-service","tag-psychology-essay-pro-top-writers","tag-psychology-essay-writing-service-uk","tag-psychology-pro-papers","tag-sociology-essay-pro-research","tag-sociology-peachy-essay-writers","tag-write-my-nursing-essay","tag-writers-per-hour-sociology-writers"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/12228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=12228"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/12228\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=12228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=12228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=12228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}