Assignment 3 Data Month t Demand 1 574 - 2345678 1,004 717 1,076 1,076 932 1,291...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assignment 3 Data Month t Demand 1 574 - 2345678 1,004 717 1,076 1,076 932 1,291 1,219 9 932 10 1,219 11 1,219 21 29 30 2345678222222222222 12 1,076 13 1,650 14 1,650 15 1,434 16 1,219 17 1,291 18 1,578 19 1,793 20 1,721 1,578 1,865 1,434 1,793 1,865 1,506 1,650 1,506 1,721 1,506 BUAD306 Assignment 3 Due Date: Wednesday October 26, 11:59 PM, Canvas Submission The assignment must be completed in groups of two unless otherwise is permitted by the instructor. You must hand-write your answers and submit a scanned version (scanning/taking pictures with phone is ok) to Canvas. You must combine those several pages of scans/pictures of your handwritten answers into one Word or PDF file only (Do not submit the scans/pictures separately). Submit your Microsoft Excel file for Question 1 as well. The assignment should be submitted to Canvas by one of the group members only (write the names of both team members on the assignment). Handwriting on iPad, Surface, etc. is accepted, but typing is not allowed. You are responsible for making sure the hand-writing is neat to read and the scanned copy/picture is of high-quality. No late assignments will be accepted for any reasons, and zero grade will be assigned. You can start working on Question 1 right now (Thursday Oct 20), and Question 2 after Friday Oct 21 Lecture. I encourage you to study the course material before attempting to solve the questions to reduce the chance of confusion, and to enhance your learning experience. You will lose marks if you do not clearly mention the units, or do not clearly write down all steps of your discussions, calculations and solutions, at any part of the problems. It is your responsibility to follow this requirement in all parts of all questions. Question 1. The spreadsheet "Assignment3-Forecasting.xlsx" contains data for the past 30 months of demand for a product. Based on the data, answer the following questions. a) Plot the data. Just by looking at the plot, do you think a 3-month moving average would be a better forecast, or a 6-month moving average (different people could reach different conclusions, but you need to give good reasons for your conclusions)? b) Which one of the following four forecast methods is the best forecast: 3-month and 6-month moving averages, and exponential smoothing with = 0.2 and a = 0.6. Justify your answer by calculating MAD. [Submit the excel file along with your solutions to the assignment. Note that you need to explain your answers to the following questions in detail, and just submitting the calculations done by excel is not enough.] Question 2. The following activities are part of a project to be scheduled. Activity Immediate Predecessor Time (Weeks) A 5 B A 4 B 6 B 1 E C,D 2 F E 7 G F 7 (a) Draw a network diagram and Gantt chart. (b) What is the critical path? (c) How many weeks will it take to complete the project? (d) How much slack (the time that an activity can be delayed) does activity E have? Assignment 3 Data Month t Demand 1 574 - 2345678 1,004 717 1,076 1,076 932 1,291 1,219 9 932 10 1,219 11 1,219 21 29 30 2345678222222222222 12 1,076 13 1,650 14 1,650 15 1,434 16 1,219 17 1,291 18 1,578 19 1,793 20 1,721 1,578 1,865 1,434 1,793 1,865 1,506 1,650 1,506 1,721 1,506 BUAD306 Assignment 3 Due Date: Wednesday October 26, 11:59 PM, Canvas Submission The assignment must be completed in groups of two unless otherwise is permitted by the instructor. You must hand-write your answers and submit a scanned version (scanning/taking pictures with phone is ok) to Canvas. You must combine those several pages of scans/pictures of your handwritten answers into one Word or PDF file only (Do not submit the scans/pictures separately). Submit your Microsoft Excel file for Question 1 as well. The assignment should be submitted to Canvas by one of the group members only (write the names of both team members on the assignment). Handwriting on iPad, Surface, etc. is accepted, but typing is not allowed. You are responsible for making sure the hand-writing is neat to read and the scanned copy/picture is of high-quality. No late assignments will be accepted for any reasons, and zero grade will be assigned. You can start working on Question 1 right now (Thursday Oct 20), and Question 2 after Friday Oct 21 Lecture. I encourage you to study the course material before attempting to solve the questions to reduce the chance of confusion, and to enhance your learning experience. You will lose marks if you do not clearly mention the units, or do not clearly write down all steps of your discussions, calculations and solutions, at any part of the problems. It is your responsibility to follow this requirement in all parts of all questions. Question 1. The spreadsheet "Assignment3-Forecasting.xlsx" contains data for the past 30 months of demand for a product. Based on the data, answer the following questions. a) Plot the data. Just by looking at the plot, do you think a 3-month moving average would be a better forecast, or a 6-month moving average (different people could reach different conclusions, but you need to give good reasons for your conclusions)? b) Which one of the following four forecast methods is the best forecast: 3-month and 6-month moving averages, and exponential smoothing with = 0.2 and a = 0.6. Justify your answer by calculating MAD. [Submit the excel file along with your solutions to the assignment. Note that you need to explain your answers to the following questions in detail, and just submitting the calculations done by excel is not enough.] Question 2. The following activities are part of a project to be scheduled. Activity Immediate Predecessor Time (Weeks) A 5 B A 4 B 6 B 1 E C,D 2 F E 7 G F 7 (a) Draw a network diagram and Gantt chart. (b) What is the critical path? (c) How many weeks will it take to complete the project? (d) How much slack (the time that an activity can be delayed) does activity E have?
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these general management questions
-
Angus & Hannah want general information regarding their personal insurance options in the event of death, total or permanent disability, critical illness or inability to work due to injury or illness
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
My question is how to write the code in WareHouse.java This is WareHouse.java package warehouse; /* * * This class implements a warehouse on a Hash Table like structure, * where each entry of the...
-
. What is the output of the following program? Write your answer in the box below. #include using namespace std; int main() { int a=4; int b=6; int i; int j; } int** k; i = &a; j = &b; *j = 8; if...
-
Identify and explain the main types of cultural and institutional risks, except protectionism.
-
Cohen Sounds produces two automotive subwoofers: S12L7 and S12L5. Projected sales (number of speakers) for the coming five quarters are as follows: The vice-president of sales believes that the...
-
This activity requires teamwork to reinforce understanding of accounting for partnerships. Required 1. Assume that Baker, Warner, and Rice form the BWR Partnership by making capital contributions of...
-
On December 31, 2016, Rugaboo Corp. issues 6%, 10-year convertible bonds payable with a maturity value of $4,000,000. The semiannual interest dates are June 30 and December 31. The market interest...
-
Assume the following: The standard labor rate per hour is $17.65. The standard labor-hours allowed per unit of finished goods is 3 hours. The actual quantity of labor hours worked during the period...
-
For each time period M and listing ~x = x1, . . . , xn of wonderful variables containing the unfastened variables of M, outline a non-stop characteristic ? 7? [[~x ` M]](?) mapping elements ? of the...
-
You are the Treasurer for the Winter Corporation.Winter Corporation is planning to buy Debt Investments.In addition, due to COVID-19, the political climate, and inflation, the fair values of these...
-
5. Suppose that Wilkerson uses capacity rather than actual levels of production for product costing. Now what difference does your cost assignment have on reported costs and profitability? Should...
-
Select the contrapositive of the following proposition: "If the number is positive, then its square is positive." If the number is positive, then its square is positive. If the square of a number is...
-
Write a note on ELECTRICAL TRANSMISSION NETWORKS.
-
QUESTION 2 Excellent Sdn Bhd manufactures a single product called Magenta. The budgeted costs of the company for the first half year of 2021 based on budgeted productions and sales of 15,000 units of...
-
Temperatures in Decatur in July follow a normal model with a mean of 76.7 degrees and a standard deviation of 5.7 degrees. An innovative school has decided that the coolest 4.5% of days will...
-
7 A 29-year-old, previously healthy man suddenly collapses at a party where legal and illicit drugs are being used. Enroute to the hospital, he requires resuscitation with defibrillation to establish...
-
Hambleys Toy Store is on Regent Street in London. It has a magic department near the main door. Management is considering dropping the magic department, which has consistently shown an operating...
-
Ethos Day School is a private elementary school. In addition to regular classes, after-school care is provided between 3:00 p.m. and 6:00 p.m. at SF12 per child per hour. Financial results for the...
-
The Velasquez Company, a maker of a variety of metal and plastic products, is in the midst of a business downturn and is saddled with many idle facilities. The National Hospital Supply Company has...
Study smarter with the SolutionInn App