Please set up a linear program and solve the problem using the Excel Solver. Thank you very much. 5. Freshly Baked Hub has 3 warehouses and 3 branches store. The following tableshows the shipping costs between each warehouses and store, the warehousecapabilities and store capacities.Branch StoreToCapabilitiesFromYAP 350P 400P 2807,000P 197P 510P 3708,000P 470P 630P 28512,000Сарacity6,00014,0007,00027,000Linear Program:Solver Solution:x1 x2 x3 x4x5x6x7x8 x9Decision:Constraints:TotalSign Capability1234Minimize C:WarehouseB.

Answered: Please set up a linear program and…

Business

Operations Management

Please set up a linear program and solve the problem using the Excel Solver. Thank you very much.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: Suppose that material hardness is normally distributed with a mean of 52 and a standard deviation of…

A: Given-Upper specification limit (USL) = 55Lower specification limit (LSL) = 45Standard deviation (σ)…

Q: The control limits for the 3-sigma R-chart are (round all intermediate calculations to three…

A: Control charts are also known as process-behavior charts. It is a statistical process that helps in…

Q: Give more Solution, some of the calculations is missing? please answer as soon as possible

A: Production is the process in which inputs are combined to have the required output. It includes a…

Q: Based on the sampling done, the control limits for 3-sigma x chart are: Upper Control Limit…

A: For the given data, I would determine the control limits for three sigma Sample mean chart or X bar…

Q: Based on the sampling done, the control limits for 3-sigma x chart are (round all intermediate…

A: Here, for the given data, I could see the value of the sample mean for each sample, and the range…

Q: Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last…

A: Given-

Q: ABC Corporation resells one product to a small isolated community. It has 365 working days. It sells…

A: Reorder Point (ROP) Model: Reorder Point (ROP) is the minimum level of inventory at which a company…

Q: Of the following, which is NOT a detail that managers need to be aware of when conducting…

A: Option A) "Managers may need to fire workers if appraisals show a lack of improvement" This detail…

Q: How has the current cultural environment of our country shaped the way that companies are looking at…

A: More and more famous personalities have been forced into the limelight since 2017 and the #metoo…

Q: Ergonomics problem A work measurement analyst in the Electrical Company took 10 observations (for…

A: a. To determine the standard time and standard output using the information provided, you will need…

Q: Solve the following exercise using dynamic programming: a company distributes an article with a…

A: Dear Student please mention exact criteria to be calculated. Assuming cost minimization:-…

Q: Hello, can someone here help me find the Economic Order Quantity with the given information: Average…

A: The economic order quantity (EOQ) is the order quantity that limits complete holding and ordering…

Q: Assign tasks to workstations using the longest task-time heuristic. Use the table format below

A: Project schedule helps in calculating different values all related to the production cycle like the…

Q: 6 Variable Cells 7 8 9 10 11 12 Constraints 13 14 15 16 17 Cell $C$8 A $D$8 B Name Cell Name $B$15…

A: sensitivity analysis is a report provided by excel solver It helps to analyse various aspects…

Q: Why distribution range negative infinity to positive infinity is transformed to zero to positive…

A: The distribution range from negative infinity to positive infinity is transformed to zero to…

Q: what is Marshall olkin transformation? When it is first used and why we need it? Simply explain…

A: Marshall Olkin Transformation is a mathematical technique used in the field of probability and…

Q: how is a time series module and a causal model used in a business?

A: Time series module is used to measure, analyze and forecast patterns in data. It is used for changes…

Q: When using a project triangle to illustrate conflicting priorities, Microsoft suggests that if the…

A: A project triangle, also known as an "iron triangle," is a visual representation of the three main…

Q: Product A is made from components B and C. Item B, inturn, is made from D and E. Item C also is an…

A: BOM Diagram:

Q: d. How many customers in total should have been served in a day by all the sales people? e. What is…

A: Given Formulas used :-

Q: What is time management? What are some ways to manage time? Why is time management important. Please…

A: Here, as per this question, I would discuss the concept of time management, I would also include…

Q: 1. Is outsourcing a completely negative activity? How does its reputation tie in with insourcing?.

A: The act of allocating a company's business activities to an outside organization in order to improve…

Q: Do you agree that the Internet has affected consumer and supplier relationship? Discuss how…

A: The supplier is responsible for giving the quality that will satisfy the customer and submitting…

Q: If you worked for an international firm doing business in Asia, is there anything you would suggest…

A: If I worked for an international firm doing business in Asia, I would respect and base my strategy…

Q: Audi Company's Strategic Approach 1. Analyze the company’s strategic approach and why it works for…

A: 1. Audi's strategic approach involves a combination of differentiation and low cost. The…

Q: Consider the following: Activity A B C D Normal time 4 DEFG 238 2 Crash time Normal cost Crash cost…

A: Project crashing is a process which helps to reduce the project duration using additional cost and…

Q: As firms expand and post increasing information about their business activities on their websites,…

A: As mentioned only to list challenges, Three significant challenges for effective knowledge discovery…

Q: QUESTION 2: The Advanced Tech Company has a project to design an integrated information database for…

A: Path Duration Is duration maximum critical A-C-E-F 6+3+6+2 = 17 yes yes B-C-E-F 4+3+6+2 = 15 no…

Q: McDonald’s is a company that is all-in globally, having become a staple in over 100 countries around…

A: McDonald's is a global powerhouse that has become a staple in over 100 countries around the world.…

Q: onal companies considering cultural differences when engaging in Foreign Direct Investment.

A: For developing and rising market nations, foreign direct investment (FDI) is essential. To grow,…

Q: As a tool service centre the arrival rate is two per hour and the service potential is three per…

Q: [LO 5-3] 5-23 The materials handling charge for ABC Corp. is $0.50 per pound of finished product.…

A: Given- Material handling charge rate = $0.50 per poundNo. of units produced = 10,000 unitsWeight…

Q: What is a workflow chart and how is it important for business planning purposes?

A: Workflow chart:- The workflow chart is a graphical representation of the business process. There…

Q: Assume that the normal duration of activity A is 20 days and that it can be shortened to 14 for an…

A: The crash cost of finishing any work is more than the typical cost. The cost of finishing work is…

Q: Technology Trends in Services, except for: As humans travel globally they carry and spread disease…

A: NOTE: We are allowed to do one question only. Technology is transforming the way services are…

Q: A.). What do you think of the statement “Boeing dug its own grave by outsourcing so much of the 787…

A: Supply chain outsourcing refers to the practice of transferring the management and performance of…

Q: Write 5 paragraphs in Answer, Proof, Explain format about which are the most important pillars in…

A: Leadership Leadership means directing and coordinating individuals within an organization to achieve…

Q: Supplier Evatuation and selection. Explain supplier evaluation and selection and how it is used in…

A: *As per the question, not specified any industry, giving general solution.Companies operate supplier…

Q: To measure overtime hours

A: Measuring overtime hours is an important part of managing a business. It helps ensure that employees…

Q: How can we identify inefficient business processes via a reengineering study? Why?

A: Meaning of Business Process Reengineering- Business Process Reengineering includes the revolutionary…

Q: Hello, I was wondering if anyone can help me out with calculating safety stock with the information…

A: Given the data stated below, The average customer demand=100 units The standard deviation of…

Q: Refer to Table S6.1 - Factors for Computing Control Chart Limits (3 sigma) LOADING... for this…

A: Given-

Q: Consider the following product. Draw its product structure (Note: use sub-assemblies).

A: A product structure tree refers to the hierarchical arrangement of components used to make a final…

Q: What is the most important role of the project manager in project staffing? Give one specific…

A: NOTE: We are allowed to do one question only at a time. Staffing is a critical part of any…

Q: [A] Using the following warehouse information, allocate the apples to their appropriate locations.…

A: a) To allocate the apples to the appropriate locations, we can use the following formula for each…

Q: Anna runs a small cafe that’s really busy at lunchtime but quiet at other times. She needs a way to…

A: Introduction: Managing the inventory or capacity according to the demand of the market is a tricky…

Q: d) If the firm operates 11 hours per day, 20 days per month, the monthly capacity of the…

A: Given- The capacity of the sawing station is 2.4 units per hourThe capacity of the sanding station…

Q: The activities needed to replace a broken window pane are given below. Activity Duration (in…

A: (a)

Q: A. Create an excel file. (Show all formulas in one screen shot and the results as another…

A: Given We need 6 Kanbans for the production process. Kanban is a method for managing and…

Q: The relationship between planning and controlling is intimate and mutual. Describe this statement.

A: Planning and controlling are two integral parts of any organization. Planning is the process of…

Question

Please set up a linear program and solve the problem using the Excel Solver. Thank you very much.

5. Freshly Baked Hub has 3 warehouses and 3 branches store. The following table
shows the shipping costs between each warehouses and store, the warehouse
capabilities and store capacities.
Branch Store
To
Capabilities
From
Y
A
P 350
P 400
P 280
7,000
P 197
P 510
P 370
8,000
P 470
P 630
P 285
12,000
Сарacity
6,000
14,000
7,000
27,000
Linear Program:
Solver Solution:
x1 x2 x3 x4
x5
x6
x7
x8 x9
Decision:
Constraints:
Total
Sign Capability
1
2
3
4
Minimize C:
Warehouse
B.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1 - Introduction

VIEW

Step 2 - Formulating LPP

VIEW

Step 3 - Optimal solution

VIEW

Step by step

Solved in 3 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

4. In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,100 radials each year. In the past 2 years, 220 and 250, respectively were sold in fall, 360 and 300 in winter, 150 and 160 in spring, and 320 and 440 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,300 radials. Part 2 Based on next year's projected sales, the demand for each season is going to be (enter your responses as whole numbers): Season Demand Fall __________
Problem 21-9 (Algo) Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 131 units. The following is the BOM in indented form: ITEM X A B C DESCRIPTION Bracket assembly wall board Hanger subassembly D Hanger casting E Ceramic knob Rivet head screw F Metal tong G Plastic cap Item Inventory X 23 A 18 B5 Below is a table indicating current inventory levels: 55 USAGE 1 C 25 4 2 2 1 5 2 D 200 170 1,100 G 90
DJA Trucking Co. owns several truck used in hauling crushed stones from three different plants to three road projects in Pampanga. The contractor in charge of the project gives the company the ff. Projec A B C F/T X Y Z Requirement per week 150 175 140 A B P100 P200 150 175 200 500 C P75 225 125 Plants X Y Z Available per week 145 160 160 Compute for the optimal hauling schedule and the total transportation costs. (Use stepping stone and Least Cost Method (minimum entry method))
Data collected on the yearly demand for 50- pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Estimate demand for vear 12 with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other two years are each given a weight of 1. Year Demand (Bags) 4 6. 3 4. 4. 10 6 8. 8. 8. 12 10 14 11 15 O A. 13.67 O B. 14.00 OC. 14.87 O D. 11.79 Click to select your answer. Us MacBook Air 888 * ES F2 F4 F6 F7 4) F9 F10 %23 2$ & * 4 6. 7 8 9. Q W R T Y F C V В alt command command option %#3
13.2 A company manufactures component parts for machine tools in North America and ships them to Southeast Asia for assembly and sale in the local market. The components are shipped by sea, transit time averages 6 weeks, and the shipping costs $2700 per shipment. The company is considering moving the parts by air at an estimated cost of $7500; the shipment taking 2 days to get there. If inventory in transit for the shipment costs $125 per day, should they ship by air?
Table 1. Demand of Hairdryer from January to July [Jadual 1. Permintaan Pengering Rambut dari Januari 2021 hingga Julai 2021] Month Demand January February 2800 2870 March 2968 April Мay 3000 3100 Jun 3150 July 3400 a) Calculate forecast future demand for May, June, July and August by using 3 months simple moving average.[hitung ramalan permintaan masa depan untuk bulan Mei, Jun, Julai dan Ogos dengan menggunakan purata bergerak sederhana 3 bulan.] *
16. Complete the following schedule and then answer Problems 16 and 17. Forecast requirements In transit On Hand 1 35 50 Projected available balance 30 Planned Shipments Shipping quantity = 50, Lead time = 1, Safety stock = 25 2 30 Period 3 45 What will the planned shipments be for periods 2, 3, and 4? a) 25 units for each period b) 50 units for periods 2 and 4; zero units for period 3 4 65 c) 50 units for each period d) 100 units in period 2, zero units in period 3, and 50 units in period 4 e) 75 units in period 2, 35 units in period 3, 20 units in period 4 17. What is the projected available balance for period 4? a) 50 units b) 55 units c) 60 units d) 65 units e) 75 units 5 30
Suppose an Excel spreadsheet model has been partially created as shown below. 1 2 3 4 5 6 7 8 9 10 11 12 A From 0 0.2 0.5 0.9 B To 0.2 0.5 0.9 1 C Lead Time Probability Lead Time (in days) 1 2 3 4 0.2 0.3 0.4 0.1 D What formula should be used to generate a lead time (in days) from this distribution? =VLOOKUP(RAND(),A6:D9,3) =VLOOKUP(RAND(),A6:D9,4) =VLOOKUP(A6:A9,A6:D9,3) =VLOOKUP(A6:A9,A6:D9,4) E
Variable cells Cell $B$6 $C$6 $D$6 Cell $E$2 $E$3 Name Constraints- $E$4 Variable 1 Variable 2 Variable 3 Name Resource A Resource B Resource C Final Value Cost 3 10 20 Reduced 30 18 0 -7 Final Value Shadow Price Constraint R.H. Side 7.78 6 Objective Coefficient 10 30 40 20 20 30 40 What is the range of optimality for the objective coefficient for Variable 2? Allowable Increase 23 50 Allowable Increase 10 50 1E+30 Allowable Decrease 17 10 1E+30 Allowable Decrease 12.5 10 22
The Ace Manufacturing Company has orders for three similar products. Product Min A s.t. B C 1 Machine 2 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. 3 A A B Product B с 4 2 3 Machine 1 Capacity Machine 2 Capacity Machine 3 Capacity Product A Orders Product B Orders Orders (units) Product C Orders 2,100 ≥ 0 for all i, j. 700 1,200 Capacity (units) 1,400 1,400 1,400 1 Use the transportation model to develop the minimum cost production schedule for the products and machines. (a) Show the linear programming formulation. (Let XA1 be the number of units of product A produced by machine 1, X;; be the number of units of product i produced by machine j, etc.) Xij Machine 2 $1.00 $1.30…
REQIRED QUESTION 1, and 2,
Using the information in Problem(The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure. ), construct agross material requirements plan.