留学生论文网源于英伦 服务世界 专业代写服务12年 <-- -->
当前位置: 首页 > 代写assignment >

美国留学生统计学方面课程作业辅导-statistics

时间:2013-09-15 14:04来源:www.liuxuelw.com 作者:stan 点击:
美国留学生统计学方面课程作业辅导-statistics
美国留学生统计学方面课程作业辅导-statistics
 
 
 
Demonstrate an ability to use Excel to build simple decision models. Using Excel, you will build a set
of models designed to simulate a series of decisions along a supply chain.
 
 
Format: Keep everything in one Excel workbook, composed of several worksheets. Be sure to label the 
tab at the bottom of each worksheet with an appropriate short titl
 
Worksheet #1 TITLE
 
The first worksheet will contain your name, date, “DSCI-305-xx” (where “xx” is 
your section number – 01 or 03 or 50) AND your student ID number
 
The first worksheet will also contain a cell labeled “ANSWER” followed by a number.
In this cell you will place the result of calculations you make on other worksheets.
(You will be told later exactly which result to put in the ANSWER cell.)
Your final answer here will be copied from Worksheet #7.
 
The first worksheet will also contain a cell labeled “INTERPRETATION.” 
In this cell you will type a short statement of what your answer means in a practical sense.
 
Worksheets 2 through 7 will contain various models. Each model must be generalized so that it works for any set of input values, not some specific set. You must use Excel features to calculate these values; do not simply use Excel as a typewriter.ontain您的姓名,日期,“DSCI-305-XX”(“XX”
您的节数 - 01或03或50)和你的学生身份证号码
 
第一个工作表,也将包含一个细胞标记后跟一个数字的“答案”。
在这个单元中,您将放置你做其他工作表计算的结果。
(你会被告知以后完全,结果把在答题细胞)。
你最终的答案将被复制表#7。
 
第一个工作表也将包含一个细胞标记“解释。”
在这个单元中,你将键入你的答案意味着在实际意义上的简短陈述。
 
工作表2到7将包含各种型号。每个模型都必须是广义的,它适用于任何一组输入值,而不是一些特定的一组。您必须使用Excel来计算这些值的功能,不只是简单地使用Excel作为一台打字机
 
Worksheet #2 Forecasting and Forecast Accuracy
Inputs: (1) a series of up to 18 historical time periods [given]
(2) two different alpha values [given]
Process: Make four different forecasts using the four methods in the
next paragraph; measure the accuracy of each method.
Outputs: (1) forecasts for the 19th period using these methods:
(a) a 3-period moving average
(b) a 5-period moving average
(c) exponential smoothing with alpha = A
(d) exponential smoothing with alpha = B
(2) MAD calculations using periods 7 through 18 only
 
Worksheet #3 Expected Value
Inputs: (1) the output from Worksheet #2, methods (1a-1d)
(2) four different probabilities, matched to input (1) [given]
Process: Calculate one EV from the four inputs in the previous paragraph.
Outputs: (1) a single Expected Value calculation
 
Worksheet #4 Inventory / EOQ
Inputs: (1) let Demand = the output (1) from Worksheet #3
(2) input cells for Ordering Cost and Carrying Cost [given]
Process: Calculate EOQ and Orders Per Year using the basic method.
Outputs: (1) EOQ using the Basic model
(2)  Orders Per Year using the Basic model
 
Worksheet #5 Distribution (LP method)
Inputs: (1) let Demand #1 = the EOQ output from Worksheet #4
(2) let Demand #2 = best forecast
(using MAD), from Worksheet #2
DIVIDED BY Orders Per Year, from Worksheet #4
(3) input cells for two other Demand values [given]
(5) input cells for three Supply values [given]
(6) twelve cells for Cost Coefficients [given]
Process: Using Solver, calculate twelve Decision Variable values, Xij.
Outputs: (1) twelve cells, one for each Decision Variable
HINT: Each Decision Variable represents a “from-to”
quantity, where the “from-to” is identified by “i-j”.
 
Worksheet #1 ANSWER CELL
Your answer will be ONE of the outputs from Worksheet #5 [given]
 
Method: Models for this project should be variations of the same models you have done earlier as homework exercises. The difference is we are now “chaining” them together to simulate a series of related decisions. Be sure to make your models general enough to work with any set of values, within the limits described above.
 
Using the Moodle file labeled Individual Input Values, locate your name and use your personal values as inputs to your models. Assuming that you have already validated your models, you will simply plug in the assigned numbers, interpret and revise your models as needed, and read your answer.
 
HINT: Design your models so that the output of one “flows” automatically to the input of the next (wherever it is needed). If you do that, then the “answer” cell on Worksheet #1 will be automatically populated with the correct answer.
 
 
1 Build and solve your models using the instructions above.
 
2 When you are satisfied with your work, click your cursor on the cell at the top left corner of 
Worksheet #1. Then click “save” and end Excel. (This way, when I open the file, it will open 
on the page with your name and answer.) Your saved file name should consist of your class section, 
last name, and first name (Example: 03 Smith Susan).
 
3 Send an email to wgarrett@slu.edu with the subject line “305 Project” and attach your saved file.
No other content is necessary.提示:设计的模型,使输出的一个“流动”自动输入下一个(在需要的地方)。如果你这样做,那么细胞表#1“答案”会自动填入正确的答案。
 
 
1建立并使用上述指导解决您的模型。
 
2当你与你的工作感到满意,请单击左上角光标对细胞
表#1。然后点击“保存”和结束的Excel。 (这样一来,当我打开文件时,它会打开
页面上您的姓名和答案。)你保存的文件名应该由你的类部分,
姓氏和名字(例如:03史密斯苏珊)。
 
3发送电子邮件至wgarrett@slu.edu的主题行“305工程”和附上您保存的文件。
没有任何其他的内容是必要的。
 
 
(责任编辑:selinashen)
织梦二维码生成器
顶一下
(0)
0%
踩一下
(0)
0%
------分隔线----------------------------
发表评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评价:
栏目列表
推荐内容

Europe (24-hours)
EN:13917206902
china (24-hours)
CN:13917206902
在线客服团队
全天候24小时在线客服 QQ:1455780998

微信在线客服(24小时)

微信公众订阅号