FC.73 Ties at BYU-Idaho have become very popular since Tie the Knot, an IBC company, has started
Question:
FC.73 Ties at BYU-Idaho have become very popular since Tie the Knot, an IBC company, has started operations this semester. Sales have consistently increased during the weeks and the company wants to forecast future daily sales using the following data:
Day | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 |
---|---|---|---|---|---|---|---|
Monday | 36 | 45 | 29 | 50 | 33 | 45 | 40 |
Tuesday | 40 | 24 | 20 | 27 | 30 | 26 | 27 |
Wednesday | 24 | 19 | 22 | 11 | 22 | 24 | 15 |
Thursday | 20 | 20 | 23 | 29 | 27 | 21 | 24 |
Friday | 29 | 26 | 28 | 23 | 22 | 30 | 30 |
What is the seasonal index for Monday? (Display your answer to two decimal places.)
What is the seasonal index for Wednesday? (Display your answer to two decimal places.)
What is the seasonal index for Friday? (Display your answer to two decimal places.)
Tie the Knot is projecting that sales for Week 8 will be 145ties. Based on this forecast for Week 8, how many ties should they expect to sell on Tuesday in that week? (Display your answer to two decimal places.)
FC.61Intermount Wood Products produces finished wood products made from various materials. One of their newer products, reclaimed red oak flooring, is fast becoming a best seller. However, the newness of the product makes it difficult to predict demand. The actual demand for reclaimed red oak flooring during the last 10 months (in square feet) is as follows:
Month | Square Feet Sold | Forecast |
---|---|---|
Jan | 9,620 | 10,195 |
Feb | 11,142 | |
Mar | 11,575 | |
Apr | 11,379 | |
May | 10,415 | |
Jun | 10,442 | |
Jul | 11,291 | |
Aug | 9,984 | |
Sep | 11,279 | |
Oct | 12,268 |
Suppose at the start of this year, before Intermount had any data on actual sales, they forecasted that January sales would be 10,195 square feet. Assuming they used an alpha value of 0.4 and that actual January sales materialized as shown in the table above (9,620 square feet), what would have been their forecast for the month of February? (Display your answer to twodecimal places.) If you follow this same forecasting process through all the months, continuing with March and going through October, what would be the forecast in the month of October? (Display your answer to two decimal places.)
What is the MAD for this forecast (based on 10 months of forecasts--January through October)? (Display your answer to two decimal places.)
What is the MAPEfor this forecast (based on 10 months of forecasts--January through October)? (Write your answer as a percentage, and displayyour answer to two decimal places.) %
FC.81 Psychology students at BYU-Idaho conducted a survey that compared GPA levels and number of absences among students in a certain class. The students compiled the following results:
Student | Absences | GPA |
---|---|---|
Student 1 | 2 | 2.96 |
Student 2 | 1 | 3.74 |
Student 3 | 8 | 2.35 |
Student 4 | 8 | 3.22 |
Student 5 | 2 | 3.96 |
Student 6 | 4 | 3.13 |
Student 7 | 7 | 3.12 |
Student 8 | 8 | 2.50 |
Student 9 | 8 | 2.35 |
Student 10 | 0 | 3.83 |
Based on the survey results, what would the forecasted GPA be for a student with 6absences? (Display your answer to two decimal places.) What is the r-value (correlation coefficient) for this set of data? (Display your answer to two decimal places. If you get a negative number then put a minus sign before your number.) The correlation coefficient (from the previous question)indicatesthat as the number of absences goes UP, GPA tends to go:
DOWN | ||
UP |
The psychology students determined that the magnitude of acorrelation coefficient(whether positive or negative) is considered strongif it is0.70 or more, moderate if it is between 0.40 and 0.69, and weak/noneif it is below 0.40. Based on your analysis, the correlationbetween absences and GPA is:
Strong | ||
Weak/None | ||
Moderate |
FC.56 Omar has a booming wood-carving business selling works of art to buyers who are members of the Church. One of his most popular pieces is a carving of the Prophet Joseph Smith. Omar's business has outgrown his ability to personally do all the carving on each piece. In order to grow his business, yet maintain the quality for which he is famous, he wants to hire an apprentice carver or two who would then do the easier portions of the Joseph Smith carvings and then leave the face portion for Omar to complete. Omar wants to develop a simple forecasting method to help him know how many apprentices to hire, how much wood to purchase, and so forth. The table below contains demand information for the past six months:
Month | J.S. Carvings Sold |
---|---|
1 | 53 |
2 | 49 |
3 | 58 |
4 | 52 |
5 | 40 |
6 | 60 |
What is the3-month moving averageforecast for carvings to be sold in Month 7? (Display your answer to twodecimal places.) Using a 3-monthweighted moving average (with last month's weight as 0.7, two months previous as 0.2, andthree months previous as 0.1) what is the forecast for Month 7? (Display your answer to two decimal places.)
FC.66 Skinovations needs to put together a Production schedule for next week and has asked its marketing team to give its forecasts for next week's sales. The team has used two different forecasting methods in the past and cannot decide which method to apply. The following data represents this week's actual sales compared to both forecasting methods:
Day | Actual Sales | M1 Forecast | M2 Forecast |
---|---|---|---|
Monday | 21 | 19 | 25 |
Tuesday | 25 | 26 | 29 |
Wednesday | 14 | 15 | 18 |
Thursday | 22 | 19 | 18 |
Friday | 23 | 20 | 20 |
Saturday | 11 | 11 | 11 |
What is Method 1's MAD? (Display your answer to two decimal places.)
What is Method 2's MAD? (Display your answer to two decimal places.) What is Method 1's MAPE? (Write your answer as a percentage, and display your answer to two decimal places.) % What is Method 2's MAPE? (Write your answer as a percentage, and display your answer to two decimal places.) %