Question

2. (4 points) Here are quarterly data for the past two years. From these data, prepare a forecast for the upcoming year using decomposition. Period Actual (units) Period Actual (units 12 18 26 16 16 24 28 18 3 Solution Average from same quarterly Seasonal Deseasonaiz deseasonalized factor ed demand 2 demand y period 12 18 26 16 16 24 28 18 14 21 27 17 0.71 1.06 1.37 0.86 0.71 1.06 1.37 0.86 16.93 16.93 19.02 18.59 16 2.5725 22.5736 20.48 49 20.91 158.00 20 16.93 33.86 57.06 74.35 112.86 135.43 143.37 167.29 741.14 4 4. 6 64 Total 36 158 4 y19.75 t4.5 320.718 nt 16.520could you please walk me through the solution on how to find all of these things like seasonal factor ect.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

EXCEL FORMULAS:

Add a comment
Know the answer?
Add Answer to:
could you please walk me through the solution on how to find all of these things...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Please show all written work as I am having trouble finding my way through the solution...

    Please show all written work as I am having trouble finding my way through the solution to this problem. Thank you in advance! Question 4 (12 points: 1, 2, 2, 2, 5) Consider the three-stage process shown here (a) What is the minimum TPT? (b) Calculate hourly capacity of each stage. G1 6 min 6 min D1 4 min W2 G2 6 min min Consider the following schedule. Jobs are numbered 1, 2, 3, 4 and so on. Jobs are...

  • If someone could explain how to find the answers above please! I added all the data...

    If someone could explain how to find the answers above please! I added all the data that was given to me, plus the titration curve. Thank you! Volume of Glass Cleaner (mL): 25.00 Glass Cleaner Titration 14 12 10 & ph -Series Concentration of HCI (M): 0.445 Volume/mL) pH data point 0 11.62 data point 2 11.01 data point 4 10.71 data point 6 10.47 data point 8 10.3 data point 10 10.17 data point 12 10.3 data point 14...

  • could you plz help me with question number 5, I did question 1 through 4 I...

    could you plz help me with question number 5, I did question 1 through 4 I hope my answers are correct! you can see the answer it is in excel pic A с . о EF 1 1) Calculate net present value of store managers Investment Investment Year 0 Year 1 Year 2 Year 3 Total 3 Amount to be invested $(800,000.00) $ (800,000.00) 4 Annual cash Inflow $ 400,000.00 $ 400,000.00 $ 400,000.00 $1,200,000.00 5 Annual cash Outflow $(250,000.00)...

  • Could you please help me with questions 1a-1b please? ( since i could only find the formula neede...

    Could you please help me with questions 1a-1b please? ( since i could only find the formula needed for 1a, if u aren't sure with 1b u can just do 1a but please dont reply "no enough data given " because i have a lil systemical problem with replying the comments) * the first question was asked to complete the anova table ( table 9.1 in the picture ) by using the formulas ( in the pictures) * I have...

  • hi, can you please help me with required 1 through 6B. thanks and have a great...

    hi, can you please help me with required 1 through 6B. thanks and have a great day Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 20% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product $ 250,000...

  • can you please help me figure out the break even analysis? (last photo ) fx =ROUND(420*(2500/4200),2)...

    can you please help me figure out the break even analysis? (last photo ) fx =ROUND(420*(2500/4200),2) Total Variable Costs 2$ 4.65 Total Fixed Costs 2$ 858.44 Based on 12 dogs per day. Assume 22 eight-hour work days for kennel attendant. BOARDING Item Variable Costs Item Fixed Costs Kennel attendant 2$ 5.62 Depreciation on kennels 2$ 80.00 Bowls 0.86 Rent 386.90 Towels 0.87 Loan 250.00 Utilities and Insurance 357.14 Depreciation on heating system Cleaning Products: Odoban Cleaning Products: Simple Green 49.40...

  • Can you please provide the formula for the worksheet also. CASE PROBLEMS Level 1- Analyzing Sales...

    Can you please provide the formula for the worksheet also. CASE PROBLEMS Level 1- Analyzing Sales for Crèmes Ice Cream Judd Hemming is the eastern regional marketing manager for Crèmes Ice Cream. Eac quarter, he completes two separate analyses: an analysis comparing ice cream flavor sale volumes from all regional locations with the same quarter sales volumes from the previou year and an analysis comparing total sales in dollars, including mean, median, mode, and standard deviation, of sales by store....

  • can you please complete the income statement (last photo) other pages are for refernce. please let...

    can you please complete the income statement (last photo) other pages are for refernce. please let me know what additional information is needed to complete the question TOLED Tuy Demstalled, but first we need to close some apps. Update now A B C D E F G H J K L M N O P Q R S OPERATIONAL & COST INFORMATION: For simplicity, base all calculations using 30 days in each month m OPERATIONAL DATA Grooming: The Groomer can...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT