Hi I M Having Issues Creating The Excel File For The Below Problem

Hi,

I’m having issues creating the excel file for the below problem:

16. The blood bank wants to determine the least expensive way to transport available blood donations from Pittsburgh and Staunton to hospitals in Charleston, Roanoke, Richmond, Norfolk, and Suffolk. The supply and demand for donated blood is shown in Figure 5.36 along with the unit cost of shipping along each possible arc.

**Within my book this info goes with Figure 5.36 but I don’t have an option to attach this figure for you to review.

Here is a link that reflects this Figure 5.36-hope you can access it.

a. I have to try to set up a spreadsheet model for this problem.

b. What is the optimal solution?

c. Suppose that no more than 1,000 units of blood can be transported over any one arc. What is the optimal solution to this revised problem?

Ragsdale, Cliff. Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (Page 230). Cengage Learning. Kindle Edition. 

Can you help me by starting me off in the right direction?

Thanks!

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

Hi I M Having Difficulty Creating A Spreadsheet With The Below Information In Ex

Hi, I’m having difficulty creating a spreadsheet with the below information in Excel Solver.

Please help!

ABC Manufacturing makes two products: rockers and chairs. Each product produced goes through the following 3 manufacturing processes:

  1. Cutting
  2. Sanding
  3. Finishing

Each rocker produced requires 1 hour in cutting, 30 minutes in sanding, and 30 minutes in finishing. Each chair requires 30 minutes in cutting, 45 minutes in sanding, and 1 hour in finishing. In the coming week, ABC manufacturing has 40 hours of cutting capacity available, 40 hours of sanding capacity, and 60 hours of finishing capacity. Assume all rockers produced can be sold for a profit $500 each, while each chair can be sold for a profit of $400 each. ABC manufacturing would like to determine the optimal production mix of rockers and chairs in order to maximize its weekly profit.

a. Formulate this problem as a linear programming problem. That is, make sure to specify what the decision variables are, what the objective function is, and what the relevant constraints are.

b. Set up the problem in a spreadsheet and solve it using Solver.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

Hi I Need Help Fairly Quick Could Someone Please Help With These 3 Questions

Hi I need help fairly quick. Could someone please help with these 3 questions?

T-tests are used when you want to examine differences but you do not know everything about the population. There are three types of t-tests that you may choose to do: one-sample t-test, independent sample t-test, or dependent sample t-test. You can calculate these by hand, in SPSS, or in Excel. The instructions below can be used for SPSS and your textbook offers instructions for using Excel.

Single-sample t-tests

These tests are used when you want to determine the probability that a sample was drawn from a population with a known mean (μ) but with a standard deviation estimated from the sample.

  • Click on analyze, compare means, one-sample t-test
  • Copy the variables you want to test into the Test Variables box
  • Type the population mean into the Test Value box
  • Click on options to get:
  • Confidence intervals (95% is default)
  • Exclude cases analysis by analysis
  • If some data is missing, this will drop the data only in analyses where that data is missing.
  • Exclude cases listwise
  • If you are doing multiple t-tests and have missing data, this will drop participants who have missing data from all t tests
  • Click on continue, ok
  • The output will display the t-statistic, degrees of freedom (n-1), significance (two-tailed), and the confidence interval

Independent sample t-test

These tests are used when you want to determine the probability that two samples were drawn from the same population with unknown means and standard deviations; both of which are estimated from the sample. No population parameters are specified.

  • The data should be entered in one column and should be named as your dependent variable.
  • You will need another column of data to identify each group according to number. So, it is a good idea to have two columns of data (one for the IV and one for the DV).
  • For the IV column, you should use two consecutive numbers (I usually use 1 and 2)
  • Also, be sure to use variable view to name your variables (otherwise this can become very confusing)

Ø First, we need to calculate means for the purpose of interpretation.

Ø Go to analyze, compare means, means

Ø Put your IV in the grouping variable box and your DV in the dependent variable box.

Ø Click OK to get the means and standard deviations

Ø Now, you need to calculate your t-test

Ø Go to analyze, compare means, independent samples t-test

Ø Your IV is the grouping variable

Ø Click on define range and enter 1-2

Ø Put the DV in the dependent variables box.

Ø You can click on options to change the confidence interval (default is 95%)

Ø Click on OK

Ø The output will show you the t-statistic, the significance level, the standard error of the mean, and the confidence interval.

Dependent samples t-test

We use this t-test when we have a repeated measures design such as the same sample completes a pre and post-test and we want to know if there is a difference from one test to the other.

Ø Go to analyze, compare means, paired sample t-test

Ø Select two variables and move into box

Ø Click on OK

Ø The output will give you means for each trial (or pre-post test measure) as well as the t-statistic and significance level

Let’s try a few using the data below. Be sure to attach your printouts and answer the questions below. 

  1. First, perform an independent sample t-test for gender (IV) and pretest scores (DV)

Were there significant gender differences? How do you know? Interpret the results statistically and in words.

2.Then perform an independent sample t-test for gender (IV) and posttest scores (DV) Were there significant gender differences? How do you know? Interpret the results statistically and in words.

3.Now, perform a paired (dependent) sample t-test for pretest and posttest scores.

Were there two scores significantly different? How do you know? Interpret the results statistically and in words.

Data Set Homework 2 (*note 1 = males, 2 = females)

Gender          Pretest                       Posttest

1.00               50.00             80.00

1.00               50.00             70.00

1.00               80.00             70.00

1.00               80.00             50.00

1.00               70.00             50.00

1.00               70.00             50.00

1.00               60.00             60.00

1.00               60.00             80.00

1.00               90.00             80.00

1.00               90.00             90.00

1.00               90.00             80.00

1.00               80.00             90.00

1.00               80.00             90.00

1.00               70.00             70.00

1.00               70.00             80.00

1.00               50.00             80.00

1.00               50.00             70.00

1.00               50.00             70.00

1.00               60.00             60.00

1.00               70.00             80.00

2.00               50.00             70.00

2.00               40.00             50.00

2.00               40.00             80.00

2.00               70.00             80.00

2.00               50.00             70.00

2.00               50.00             80.00

2.00               50.00             90.00

2.00               60.00             90.00

2.00               70.00             90.00

2.00               40.00             80.00

2.00               40.00             80.00

2.00               30.00             70.00

2.00               30.00             70.00

2.00               50.00             60.00

2.00               60.00             80.00

2.00               40.00             80.00

2.00               70.00             80.00

2.00               50.00             70.00

2.00               60.00             70.00

2.00               70.00             90.00

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

Hi I Need A Project On Security And Cloud Topic From Fundamentals Of Computer Se

Hi, I need a project on security and cloud topic from fundamentals of computer security subject, it is very urgent. Due is Thursday evening Eastern time,

Thanks for the help.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

Hi I Need Help Creating A Policy Brief Proposal This Is A Master S Level Course

Hi, I need help creating a Policy brief Proposal.  This is a master’s level course. I attached the

instructions.

Drawing on several sources of information, including  Internet resources and peer-reviewed academic journals, select a topic that affects some portion of the environment (physical, social, workplace environment, enabling healthy behaviors) and population (children, adolescents, young adults, middle age, older adults). Please cite everything that you get from other sources with the text.

1 Running head: COLLEGE STUDENTS BODY ARTS College Students Body ArtsStudents’ NameInstitution 2 COLLEGE STUDENTS BODY ARTSIncreased deviance and conflicts among college going students with…

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

Hi I Need A Research Paper 10 Pages Double Spaced Over Any Molecular Cell Biolog

Hi I need a research paper, 10 pages double spaced over any molecular cell biology topic. thanks

MOLECULAR GENETICSMolecular biology is the study of biology at the molecular level. The field overlaps with otherareas of biology and chemistry, particularly genetics and biochemistry. Cell…

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

Hi I Need Help Answering The Following Question Context Is Provided Below Accord

Hi I need help answering the following question. Context is provided below.

  1. According to psychoanalytic theory why did Jonas react with anger to these two events? 
  2. What defense mechanisms were activated in Jonas?

Synopsis of Jonas’ life:

6 months old – put up for adoption

6 months – 10 yrs- in and out of various foster care and group homes

10 yrs old – adopted

12 yrs old – sent to military school by adopted family to correct behavior

Sexually abused by male authority figure at military school

Jonas reported that he appreciated military school for the structure and found it comforting

The sexual abuse was described as “leaving an incredible mark on him”

Adopted home environment described as “immaculate, strict and neurotic.” In addition Jonas describes his adopted family as:

                                              i.    Father – cold, brutal, forbidding.

                                             ii.    Mother – could never please her

                                           iii.    Sister – 3 years younger and simply perfect

Jonas now is an adult (who identifies as a gay male) and is in counseling for his anger problem regarding two particular events.

  1. His anger (assault and vandalization of his partners property) toward his male partner when his partner started to become less interested in him and more interested in other men. Jonas reacted in rage when his partner told him he was going to leave him. This resulted in Jonas initiating a physical altercation and then vandalization of his partner’s car.
  2. In addition, he has become unable to maintain a job and in this particular instance acted out after being fired by sneaking in after hours and destroying work property.
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

Hi I Need Class Diagram To This Assignment A Department Store Has A Wedding Regi

Hi

I need class diagram to this assignment

  • A department store has a wedding registry. This registry keeps information about the customer, the products that the store carries, and the products for which each customer registers. Customers typically registers for a large number of products and many customers register for the same products.
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

Hi I Need Help Answering The Following Question Context Is Provided Below 1 A Wh

Hi I need help answering the following question. Context is provided below.

1 a. Which developmental milestones were negatively impacted or may have been missed due to Jonas difficult childhood? 

*edit… added 2nd part to question: 1 b. Also, please explain. How might this have influenced who he is today? 

Synopsis of Jonas’ life:

6 months old – put up for adoption

6 months – 10 yrs- in and out of various foster care and group homes

10 yrs old – adopted

12 yrs old – sent to military school by adopted family to correct behavior

Sexually abused by male authority figure at military school

Jonas reported that he appreciated military school for the structure and found it comforting

The sexual abuse was described as “leaving an incredible mark on him”

Adopted home environment described as “immaculate, strict and neurotic.” In addition Jonas describes his adopted family as:

                                              i.    Father – cold, brutal, forbidding.

                                             ii.    Mother – could never please her

                                           iii.    Sister – 3 years younger and simply perfect

Jonas now as an adult, identifies as a gay male. His presenting problem that brings him to counseling is his anger problem regarding two particular events.

  1. His anger (assault and vandalization of his partners property) toward his male partner when his partner started to become less interested in him and more interested in other men.
  2. In addition, he has become unable to maintain a job and in this particular instance acted out by sneaking in after hours and destroying work property as a retaliation from being fired.
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

Hi I Need Assistance With The Workings Below Part B A Recent Article In The News

Hi I need assistance with the workings below

PART B

A recent article in the news indicates that you will need 75% of your current monthly salary grown by inflation upon retirement. You currently earn R20 000 per month. The South African inflation rate is 6%. You complete the inflation adjusted calculation and you find that you will require R154 285.76 per month for 20 years when you retire (based on mortality rates). Assume you are 25 years of age and will retire at 65.

Required:

2.2 Calculate the lump sum amount you require at the date of your retirement if you are able to get an interest rate of 8% compounded annually. (6)

2.3 Ignoring your answer in question 2.2, if you require R18 000 000 at retirement, and are able to invest R3 000 per month for 40 years what nominal interest rate will you require to reach your goal? (5)

2.4 What is the effective rate of your answer calculated in 2.3? (2)

2.5 Briefly explain why an effective rate is higher than or equal to a nominal rate.(2)

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW