Applied Decision

User Generated

ZNAFGRE53

Business Finance

Description

There are four sets of questions that need to be done with Excel QM and it also needs to be explained in Microsoft word. I have attached the instructions, I hope that will be helpful with completing the assignment. I will be able to answer any questions that you might have while you are working on the assignment.

Unformatted Attachment Preview

16. A candidate for mayor in a small town has allocated $40,000 for last-minute advertising in the days preceding the election. Two types of ads will be used: radio and television. Each radio ad costs $200 and reaches an estimated 3,000 people. Each television ad costs $500 and reaches an estimated 7,000 people. In planning the advertising campaign, the campaign manager would like to reach as many people as possible, but she has stipulated that at least 10 ads of each type must be used. Also, the number of radio ads must be at least as great as the number of television ads. How many ads of each type should be used? How many people will this reach? 18. The dean of the Western College of Business must plan the school’s course offerings for the fall semester. Student demands make it necessary to offer at least 30 undergraduate and 20 graduate courses in the term. Faculty contracts also dictate that at least 60 courses be offered in total. Each undergraduate course taught costs the college an average of $2,500 in faculty wages, and each graduate course costs $3,000. How many undergraduate and graduate courses should be taught in the fall so that total faculty salaries are kept to a minimum? 7. A large city is planning for the Olympic Games, which will be coming in a few years. The transportation system is being evaluated to determine what expansion is needed to handle the large number of visitors to the games. Which of the following models would most likely help the city planners determine the capacity of the current system? a. the transportation model b. the maximal-flow model c. the shortest-route model d. the minimal-spanning tree model 27. The hospital administrator at St. Charles General must appoint head nurses to four newly established departments: urology, cardiology, orthopedics, and obstetrics. In anticipation of this staffing problem, she had hired four nurses: Hawkins, Condriac, Bardot, and Hoolihan. Believing in the quantitative analysis approach to problem solving, the administrator has interviewed each nurse; considered his or her background, personality, and talents; and developed a cost scale ranging from 0 to 100 to be used in the assignment. A 0 for Nurse Bardot being assigned to the cardiology unit implies that she would be perfectly suited to that task. A value close to 100, on the other hand, would imply that she is not at all suited to head that unit. The table below gives the complete set of cost figures that the hospital administrator felt represented all possible assignments. Which nurse should be assigned to which unit? DEPARTMENT NURSE UROLOGY CARDIOLOGY ORTHOPEDICS OBSTETRICS Hawkins 28 18 15 75 Condriac 32 48 23 38 Bardot 51 36 24 36 Hoolihan 25 38 55 12
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hello there,As promised to you I managed to finish the task earlier this time as I think the questions were a little bit more accessible or I got used again to pressing fast through the Excel QM menu( haha). I am attaching to this message 2 files, one is the world file and one is the excel file. In the end, I did in excel questions 16,18,27 and they are also explained in word file.Word file name: Excel Questions Word VersionNumber of Pages: 10*It includes all the screenshots and graphics used*It explains the excel version of the problem*It also explains the non-excel version*So basically you have 2 versions of the first 2 questions - one is excel and second is non excel.*For question 7, since it is multiple choice question I selected the correct answer and explained it*For the last questions, i used Excel QM, attached the screenshots and also explanations of the result.Excel file name: Excel Questions Excel VersionIt contains 3 sheets, each of the sheets represented a problem: Exercise 16, Exercise 18, Exercise 27.*I kept the formulas I used so your professor can check them if he/she wants.---I suppose this is what you needed from me^^ I hope I was able to help you ^^

Radio
Cost
Reach
#

TV

200
3000
175

Formulas :
*Total Cost = B2*B4+C2*C4
*Total Reach = B3*B4+C3*C4
*# Total =
B4 + C4

500
7000
10

Total
40000
595000
185

Data

Results
x1

Objective
Constraint 1
Constraint 2
Constraint 3

x2
2500
1
1

LHS
3000 sign
>
1>
1>

RHS
30
20
60

Results
Variables
Objective

40

20
0

Slack/Surplus
0
0
0
0

< constraints
30
20
60

Problem setup area
< constraints
0
0
0

> constraints
30
0
20
0
60
0

30
20
60

Exercise 27
A

B

C

D

E

F

1
2
3

Assignment

4
5
6
7
8 Data
9
10
11
12
13
14
15

COSTS
Hawkins
Condriac
Bardot
Hoolihan

Uro

16 Assignments

Uro

Cardio
28
32
51
25

17
18
19
20...


Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags