# We Helped With This Excel Programming Homework: Have A Similar One?

SOLVED
Category Programming Excel Undergraduate Solved Help With Excel

## Short Assignment Requirements

Answer the questions in the file, don't need to use excel, just answer that in the document

## Assignment Description

QUESTION 1 (60 points)

You are considering a road-trip from Seattle to Denver.  Here is a map of relevant paths you would consider.  The various paths have the travel times (in hours) listed.  For example, it takes three hours to get from Seattle to Portland.  There are numbers in parenthesis on each path which correspond to the actual highway/interstate.  You’d like to find the quickest route.

 Question: What is the best route from Seattle to Denver?  Please answer the four parts below.   (1) Please build a spreadsheet model to provide an answer & neatly cut and paste it into the space below [30 points].  Make sure to follow all color-coding conventions [10 points].  (2) Also take a picture/snapshot of the final solver dialogue box (where you wire the spreadsheet to Solver, specifying the objective function, decision variables, constraints) and include it below. [10 points]  (3) Is the model you built a LP? Why or why not? [5 points] (4) Is the model you built a minimum-cost flow problem? Why or why not? [5 points]

QUESTION 2 (40 points)

You make two types of barbeques (bbq): a regular version and a deluxe version.  Your barbeques are special because they are made of special stones.  You use both small-sized and large-sized stones to make your bbqs in addition to labor hours.  You’ve already setup a LP to decide how many bbqs of each type to make a week to maximize profit, given your resources of small-sized stones, large-sized stones, and labor.  The sensitivity report is provided below.

 Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$7 # units deluxe bbq 3 0 250 50 100 \$C\$7 # units regular bbq 2 0 150 100 25 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$E\$2 small stones 10 25 10 6 2 \$E\$3 large stones 8 0 15 1E+30 7 \$E\$4 labor hours 40 20 40 10 15

 Please answer the questions below.   (1a) [2 pts] What is the optimal number of deluxe bbqs to make each week? (1b) [2 pts] What is the optimal number of regular bbqs to make each week? (1c) [2 pts] How many large stones are you currently using to make these bbqs? (1d) [2 pts] How many hours of labor do you currently have available per week? (2a) [2 pts] What is your profit per deluxe bbq? (2b) [2 pts] What is your profit per regular bbq? (3a) [4 pts] How much is an additional small stone worth to you?  Why? (3b) [4 pts] How much is an additional large stone worth to you?  Why? (4) [5 pts] One week, one employee can not come to work due to the flu.  You lose 20 hours of labor that week.  How much profit do you lose?  Explain in detail. (5a) [5 pts] What is the value of this bundle: 3 additional small stones and 3 additional large stones.  Show your calculations and reasoning in detail.(5b) [5 pts] Suppose you obtain the bundle in part (5a), does the optimal solution stay the same?  Explain in detail.  (6) [5 pts] Suppose you were off on your profit estimates and the true profits were \$200 for the deluxe bbqs and \$175 for the regular bbqs.  Does the optimal solution stay the same for that set of simultaneous changes in the coefficients of the objective function?  Explain in detail and show any relevant calculations.

Is it free to get my assignment evaluated?

Yes. No hidden fees. You pay for the solution only, and all the explanations about how to run it are included in the price. It takes up to 24 hours to get a quote from an expert. In some cases, we can help you faster if an expert is available, but you should always order in advance to avoid the risks. You can place a new order here.

How much does it cost?

The cost depends on many factors: how far away the deadline is, how hard/big the task is, if it is code only or a report, etc. We try to give rough estimates here, but it is just for orientation (in USD):

 Regular homework \$20 - \$150 Advanced homework \$100 - \$300 Group project or a report \$200 - \$500 Mid-term or final project \$200 - \$800 Live exam help \$100 - \$300 Full thesis \$1000 - \$3000

How do I pay?

Credit card or PayPal. You don't need to create/have a Payal account in order to pay by a credit card. Paypal offers you "buyer's protection" in case of any issues.

Why do I need to pay in advance?

We have no way to request money after we send you the solution. PayPal works as a middleman, which protects you in case of any disputes, so you should feel safe paying using PayPal.

Do you do essays?

No, unless it is a data analysis essay or report. This is because essays are very personal and it is easy to see when they are written by another person. This is not the case with math and programming.

Why there are no discounts?

It is because we don't want to lie - in such services no discount can be set in advance because we set the price knowing that there is a discount. For example, if we wanted to ask for \$100, we could tell that the price is \$200 and because you are special, we can do a 50% discount. It is the way all scam websites operate. We set honest prices instead, so there is no need for fake discounts.

Do you do live tutoring?

No, it is simply not how we operate. How often do you meet a great programmer who is also a great speaker? Rarely. It is why we encourage our experts to write down explanations instead of having a live call. It is often enough to get you started - analyzing and running the solutions is a big part of learning.

What happens if I am not satisfied with the solution?

Another expert will review the task, and if your claim is reasonable - we refund the payment and often block the freelancer from our platform. Because we are so harsh with our experts - the ones working with us are very trustworthy to deliver high-quality assignment solutions on time.

Customer Feedback

"Thanks for explanations after the assignment was already completed... Emily is such a nice tutor! "

Order #13073

Find Us On