Problem 1-22:
In order for the Golden Age to break-even, 57.89 rounded to 58 people will need to attend the seminar. I computed
the answer by,
Fixed cost= 1,000 (rent) + 10,000 (advertise, insurance, etc.) = 11,000
Variable cost= 60.00 (gifts and material
Installing SensIt,
RiskSim, and TreePlan
3
3.1 INSTALLATION OVERVIEW
SensIt, RiskSim, and TreePlan are decision analysis add-ins for Microsoft Excel 20002010
(Windows) and Microsoft Excel 2004 & 2011 (Macintosh).
In general, an Excel add-in is software th
1. Question :
Student
Answer:
If the coefficient of realism alpha equals 1, then the criterion of realism
will yield the same result as the maximax criterion.
True
Points Received:
False
3 of 3
Comments:
Question 2. Question :
ABC Inc. must make a decisio
Study Guide - Exam 2 Spring 2011
Student:
1.
Refer to the figure above. If the price of a latte increases from $2.00 to $2.50,
A. total revenue would increase.
B. total revenue would stay the same.
C. total revenue would decrease.
D. the change in total r
ACC201 Test #3
Multiple choice questions 1 pt. each
1) Gross profit is calculated as the difference between net sales revenue and _.
A) purchases
B) cost of goods sold
C) cost of merchandise inventory
D) selling and administrative expenses
2) Which of the
1) Macroeconomics deals with _ while microeconomics deals with _.
A) choices important to people; choices not important to people
B) economywide choices; choices of individuals
C) choices that involve money; choices that does not involve money
D) choices
Case Study: Zipcar
1
Case Study: Zipcar Its Not about Cars-Its about Urban Life
Alicia McQueen
Saint Leo University
MKT 301: Principle of Marketing
Professor Coleen James
April 5, 2015
Case Study: Zipcar
2
Abstract
The purpose of this case study, Zipcar a
Eichler Supplies
Year
1
2
Average
Seasonal
Month
Demand Demand Ratio
Index
January
80
94
0.851
0.957
February
75
94
0.798
0.851
March
80
94
0.851
0.904
April
90
94
0.957
1.064
May
115
94
1.223
1.309
June
110
94
1.170
1.223
July
100
94
1.064
1.117
August
9
Midwestern Electric Company
Forecasting
Linear trend analysis
Enter the actual values in cells shaded YELLOW. Enter new time period at the bottom to forecast Y.
Enter the actual values in cells shaded YELLOW. Enter new time period at the bottom to forecas
Wallace Garden Supply
Forecasting
3 period moving average
Enter the data in the cells shaded YELLOW.
Enter the data in the cells shaded YELLOW.
Input Data
Period
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Mon
Wallace Garden Supply
Forecasting
Exponential smoothing
Enter the data in the cells shaded YELLOW.
Enter the data in the cells shaded YELLOW.
Input Data
Period
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month
General Foundry's Project (Using Crystal Ball)
Calculations set to Manual. Run model using Crystal Ball to recalculate simulation values.
Activity
A
B
C
D
E
F
G
H
Description
Build internal components
Modify roof and floor
Construct collection stack
Pour
Wallace Garden Supply
Forecasting
3 period weighted moving average
Enter the data in the cells shaded YELLOW.
Enter the data in the cells shaded YELLOW.
Input Data
Period
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Mon
Forecasting Home Selling Prices (Revisited)
Forecasting
Multiple regression
Enter the data in the shaded area. To get a forecast use the shaded data
Enter the data in the shaded area. To get a forecast use the shaded data
area at the bottom left of the sh
Simple Maximization Problem Using QM
In this tutorial, we will solve a simple maximization linear programming problem using
Excel QM.
MSA Computer Corporation manufactures two models of minicomputers, the Alpha 4
and Beta 5. The firm employs 5 technicians
Transportation Problem Using QM
In this tutorial, we will solve a transportation problem using linear programming problem
with Excel QM. Finnish Furniture manufactures tables in facilities located in three cities:
Reno, Denver, and Pittsburgh. The tables
Facility Location Problem Using QM
In this tutorial, we will solve a facility location problem using linear programming with
Excel QM. Don Levine Corporation is considering adding a plant to its existing three
facilities in Decatur, Minneapolis, and Carbo
Assignment Problem Using QM
In this example, we will solve an assignment problem using linear programming with
Excel QM.
The hospital administrator at St. Charles General Hospital must appoint head nurses to
four newly established departments: urology, ca
Enter the values in the shaded area. Then go to the DATA Tab on the ribbon, click on Solver in the Data Analysis
Enter the values in the shaded area. Then go to the DATA Tab on the ribbon, click on Solver in the Data Analysis
Linear, Integer and Mixed Int
Enter the values in the shaded area. Then go to the DATA Tab on the ribbon, click on Solver in the Data Analysis
Enter the values in the shaded area. Then go to the DATA Tab on the ribbon, click on Solver in the Data Analysis
Linear, Integer and Mixed Int
Transportation
Enter the transportation data in the shaded area. Then go to the DATA Tab on the ribbon, click on Solver
Enter the transportation data in the shaded area. Then go to the DATA Tab on the ribbon, click on Solver
in the Data Analysis Group and
A
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
B
C
D
E
F
G
Assignment
Enter the assignment costs in the shaded area. Then go to the DATA Tab on
Enter the assignment costs in the shaded area. Then go to the DATA Tab on
the ribbon, click on Solv
Solved Problem 11-2
Forecasting
Linear trend analysis
Enter the actual values in cells shaded YELLOW. Enter new time period at the bottom to forecast Y.
Enter the actual values in cells shaded YELLOW. Enter new time period at the bottom to forecast Y.
Inp
Sawyer Piano House (Additive Model)
Forecasting
4 seasons
Additive decomposition
Enter the actual values in the cells shaded YELLOW. Do not change the time period numbers!
Enter the actual values in the cells shaded YELLOW. Do not change the time period n
Solved Problem 11-1
Forecasting
Exponential smoothing
Enter the data in the cells shaded YELLOW.
Enter the data in the cells shaded YELLOW.
Input Data
Period
Year 1
Year 2
Year 3
Year 4
Year 5
Actual value
45
50
52
56
58
Alpha
0.2
Next period
49.785
Forec
Sawyer Piano House
Forecasting
4 seasons
Multiplicative decomposition
Enter the actual values in the cells shaded YELLOW. Do not change the time period numbers!
Enter the actual values in the cells shaded YELLOW. Do not change the time period numbers!
Inp
Forecasting Home Selling Prices
Forecasting
Causal regression analysis
Enter the (Y,X) pairs in cells shaded YELLOW. Enter new value of X at the bottom to forecast Y.
Enter the (Y,X) pairs in cells shaded YELLOW. Enter new value of X at the bottom forecas
Problem 22
Selling price per unit = s
fixed cost = f
variable cost = v
250
11000
60
BEP
57.894736842
BEP= f/(s-v)
Problem 23
Selling price per unit= s
20
fixed cost = f
375
variable cost = v
5
Part A) fixed price is 373 PART B) fixed price is 275
BEP
A)
2
Assignment 1
A list of rules that I would insist upon as a project manager of a large project tem for
weekly update meetings are the following.
1. Determine the setting for the meeting, if it is in person or through conference call.
2. Provide adequate no
Small boxes of NutraFlakes cereal are labeled "net weight 10 ounces." Each hour, random samples of size n = 4 are weighed to check pr
Weight
Time Box 1 Box 2 Box 3 Box 4
9 a.m.9.8 10.49.9 10.3
10 a.m.10.1 10.29.99.8
11 a.m. 9.9 10.510.310.1
Noon9.79.810.
Question 31
Inventory
Economic Order Quantity Model
This
This spreadsheet
spreadsheet was
was created
created by
by either
either POM,
POM, QM
QM or
or POM-QM
POM-QM for
for Windows,
Windows, V4.
V4.
Data
Demand rate, D
Setup cost, S
Holding cost, H
Unit