DQ Sales 2023

xlsx

School

University of Illinois, Chicago *

*We aren’t endorsed by this school

Course

355

Subject

Aerospace Engineering

Date

Oct 30, 2023

Type

xlsx

Pages

9

Uploaded by marnoux11

Report
Date Sales 4DMA 7DMA 14DMA 2/2/2022 2500 2/3/2022 2922 2/4/2022 1974 2/5/2022 2002 2/6/2022 1973 2350 2/7/2022 2179 2218 2/8/2022 2286 2032 2/9/2022 3074 2110 2262 2/10/2022 2532 2378 2344 2/11/2022 2151 2518 2289 2/12/2022 2214 2511 2314 2/13/2022 2244 2493 2344 2/14/2022 2244 2285 2383 2/15/2022 2619 2213 2392 2/16/2022 3249 2330 2440 2351 2/17/2022 3139 2589 2465 2405 2/18/2022 2296 2813 2551 2420 2/19/2022 2371 2826 2572 2443 2/20/2022 2283 2764 2595 2469 2/21/2022 2292 2522 2600 2492 2/22/2022 2728 2311 2607 2500 2/23/2022 3269 2419 2623 2531 2/24/2022 3287 2643 2625 2545 2/25/2022 2361 2894 2647 2599 2/26/2022 2582 2911 2656 2614 2/27/2022 2352 2875 2686 2640 2/28/2022 2611 2646 2696 2648 3/1/2022 2735 2477 2741 2674 3/2/2022 3405 2570 2742 2683 3/3/2022 3476 2776 2762 2694 3/4/2022 2455 3057 2789 2718 3/5/2022 2408 3018 2802 2729 3/6/2022 2621 2936 2777 2732 3/7/2022 2815 2740 2816 2756 3/8/2022 2997 2575 2845 2793 3/9/2022 3650 2710 2882 2812 3/10/2022 3322 3021 2917 2840 3/11/2022 2803 3196 2895 2842 3/12/2022 2839 3193 2945 2874 3/13/2022 2811 3154 3007 2892 3/14/2022 3009 2944 3034 2925 3/15/2022 3138 2866 3062 2953 3/16/2022 3381 2949 3082 2982 3/17/2022 3276 3085 3043 2980 3/18/2022 2708 3201 3037 2966 3/19/2022 2927 3126 3023 2984 1/29/202 0 500 1000 1500 2000 2500 3000 3500 4000 4500
3/20/2022 3021 3073 3036 3021 3/21/2022 2907 2983 3066 3050 3/22/2022 2986 2891 3051 3056 3/23/2022 3961 2960 3029 3056 3/24/2022 3870 3219 3112 3078 3/25/2022 2942 3431 3197 3117 3/26/2022 3098 3440 3231 3127 3/27/2022 2937 3468 3255 3145 3/28/2022 3278 3212 3243 3154 3/29/2022 3481 3064 3296 3174 3/30/2022 3579 3199 3367 3198 3/31/2022 3622 3319 3312 3212 4/1/2022 3088 3490 3277 3237
22 2/8/2022 2/18/2022 2/28/2022 3/10/2022 3/20/2022 3/30/2022 4/9/2022
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Date Sales 4DWMA 7DWMA 14DWMA 4/2/2022 3067 4/3/2022 3264 4/4/2022 3382 4/5/2022 3429 4/6/2022 3960 3346 4/7/2022 3647 3616 4/8/2022 3324 3671 4/9/2022 3393 3559 3514.5357143 4/10/2022 3193 3480 3503.0357143 4/11/2022 3509 3325 3429.8928571 4/12/2022 3752 3373 3438.2857143 4/13/2022 4146 3531 3502.8928571 4/14/2022 4252 3805 3654.4642857 4/15/2022 3459 4046 3825.8928571 4/16/2022 3442 3864 3777.4642857 3658.1333333 4/17/2022 3432 3680 3719.9642857 3643 4/18/2022 3676 3522 3658.2142857 3622.9619048 4/19/2022 3863 3534 3648.9285714 3633.8571429 4/20/2022 4473 3679 3680.4285714 3666.8857143 4/21/2022 4170 4027 3860.4642857 3777.1142857 4/22/2022 3424 4150 3953.0714286 3842.0571429 4/23/2022 3591 3902 3862.1071429 3802.552381 4/24/2022 3799 3745 3814.1428571 3784.3619048 4/25/2022 3610 3699 3812.8571429 3792.0190476 4/26/2022 3788 3644 3751.2142857 3768.7047619 4/27/2022 4228 3717 3736.4285714 3768.1619048 4/28/2022 4373 3930 3834.3214286 3825.9428571 4/29/2022 3749 4136 3977.2142857 3902.2761905 4/30/2022 3821 4036 3956.8571429 3894.2571429 5/1/2022 3718 3951 3942.8928571 3893.0761905 5/2/2022 3865 3821 3894.9642857 3874.552381 5/3/2022 3817 3801 3886.6785714 3872.9047619 5/4/2022 4603 3812 3857.2857143 3863.0571429 5/5/2022 4594 4131 4023.3571429 3958.447619 5/6/2022 3774 4368 4173.7857143 4051.4 5/7/2022 3797 4190 4111.3214286 4030.9809524 5/8/2022 3903 4030 4053.7142857 4010.2952381 5/9/2022 4028 3915 4023.4642857 4001.7809524 5/10/2022 4064 3919 4017.8571429 4008.9428571 5/11/2022 4749 3994 4015.4285714 4016.9238095 5/12/2022 4483 4315 4175.4285714 4113.6095238 5/13/2022 3963 4434 4263.7142857 4169.8666667 5/14/2022 4094 4286 4225.9642857 4155.7428571 3/30/2022 0 1000 2000 3000 4000 5000 6000
5/15/2022 4025 4198 4214.2142857 4157.047619 5/16/2022 4024 4079 4174.6071429 4146.552381 5/17/2022 4467 4032 4130.3928571 4133 5/18/2022 5070 4208 4197.0714286 4177 5/19/2022 4516 4575 4400.1071429 4295.2095238 5/20/2022 4150 4623 4453.1785714 4335.1047619 5/21/2022 4211 4476 4413.5714286 4326.9428571 5/22/2022 4264 4340 4382.5357143 4323.3333333 5/23/2022 4405 4251 4360.5714286 4322.847619 5/24/2022 4232 4298 4365.3214286 4337.7238095 5/25/2022 4997 4288 4313.2142857 4325.9428571 5/26/2022 4935 4576 4460.75 4414.5619048 5/27/2022 4109 4760 4595.3928571 4492.552381 5/28/2022 4160 4547 4508.5714286 4456.1047619 5/29/2022 4193 4383 4435.9642857 4425.0666667 5/30/2022 4580 4241 4373.4285714 4397.8 5/31/2022 4686 4333 4410.1785714 4420.5333333 6/1/2022 5182 4503 4467.1785714 4452.1047619
Weights 4DWMA 7DWMA 14DWMA 14 days prior 0.0095 13 days prior 0.0190 12 days prior 0.0286 11 days prior 0.0381 10 days prior 0.0476 9 days prior 0.0571 8 day prior 0.0667 7 days prior 0.0357 0.0762 6 days prior 0.0714 0.0857 5 days prior 0.1071 0.0952 4 days prior 0.1000 0.1429 0.1048 3 days prior 0.2000 0.1786 0.1143 2 days prior 0.3000 0.2143 0.1238 1 day prior 0.4000 0.2500 0.1333 4/9/2022 4/19/2022 4/29/2022 5/9/2022 5/19/2022 5/29/2022 6/8/2022 Chart Title Sales 4DWMA 7DWMA 14DWMA
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Date Sales Forecast Error Sq. Error 6/2/2022 4741 4741 0 0 Alpha 6/3/2022 4384 4741 -357 127449 6/4/2022 4282 4276.9 5.1 26.01 6/5/2022 4350 4283.53 66.47 4418.2609 6/6/2022 4716 4369.941 346.059 119756.83148 6/7/2022 4581 4819.8177 -238.8177 57033.893833 6/8/2022 5420 4509.35469 910.64531 829274.88062 6/9/2022 5330 5693.193593 -363.193593 131909.586 6/10/2022 4340 5221.0419221 -881.0419221 776234.8685 6/11/2022 4593 4075.6874234 517.31257663 267612.30194 6/12/2022 4744 4748.193773 -4.193772989 17.587731883 6/13/2022 4775 4742.7418681 32.258131897 1040.5870735 6/14/2022 5054 4784.6774396 269.32256043 72534.641557 6/15/2022 5224 5134.7967681 89.203231871 7957.2165762 6/16/2022 5075 5250.7609696 -175.76096956 30891.918421 6/17/2022 4723 5022.2717091 -299.27170913 89563.555887 6/18/2022 4641 4633.2184873 7.7815127395 60.551940515 6/19/2022 4644 4643.3344538 0.6655461782 0.4429517153 6/20/2022 4940 4644.1996639 295.80033615 87497.838864 6/21/2022 4931 5028.7401008 -97.740100844 9553.127313 6/22/2022 5644 4901.6779697 742.32203025 551041.9966 6/23/2022 5316 5866.6966091 -550.69660908 303266.75525 6/24/2022 4833 5150.7910173 -317.79101728 100991.13066 6/25/2022 4775 4737.6626948 37.337305183 1394.0743583 6/26/2022 4868 4786.2011916 81.798808445 6691.045063 6/27/2022 4996 4892.5396425 103.46035747 10704.045567 6/28/2022 5311 5027.0381072 283.96189276 80634.35654 6/29/2022 5758 5396.1885678 361.81143217 130907.51245 6/30/2022 5345 5866.5434297 -521.54342965 272007.54901 7/1/2022 4784 5188.5369711 -404.5369711 163650.16099 7/2/2022 4885 4662.6389087 222.36109133 49444.454938 7/3/2022 4968 4951.7083274 16.291672601 265.41859612 7/4/2022 5057 4972.8875018 84.11249822 7074.9123568 7/5/2022 5104 5082.2337495 21.766250534 473.76966231 7/6/2022 5994 5110.5298752 883.47012484 780519.46148 7/7/2022 5798 6259.0410375 -461.04103745 212558.83821 7/8/2022 4969 5659.6876888 -690.68768876 477049.48341 7/9/2022 5242 4761.7936934 480.20630663 230598.09693 7/10/2022 5191 5386.061892 -195.06189199 38049.141706 7/11/2022 5145 5132.4814324 12.518567597 156.71453467 7/12/2022 5422 5148.7555703 273.24442972 74662.518374 7/13/2022 5870 5503.9733289 366.02667108 133975.52394 7/14/2022 5841 5979.8080013 -138.80800133 19267.661232 7/15/2022 5273 5799.3575996 -526.3575996 277052.32266 7/16/2022 5302 5115.0927201 186.90727988 34934.331272 7/17/2022 5260 5358.072184 -98.072183964 9618.1532675
7/18/2022 5347 5230.5783448 116.42165519 13554.001797 7/19/2022 5505 5381.9264966 123.07350344 15147.08725 7/20/2022 6013 5541.922051 471.07794897 221914.434 7/21/2022 5865 6154.3233847 -289.32338469 83708.020929 7/22/2022 5290 5778.2029846 -488.20298459 238342.15417 7/23/2022 5403 5143.5391046 259.46089538 67319.95623 7/24/2022 5355 5480.8382686 -125.83826861 15835.269848 7/25/2022 5535 5317.2485194 217.75148058 47415.707297 7/26/2022 5555 5600.3254442 -45.325444175 2054.3958897 7/27/2022 5917 5541.4023667 375.59763325 141073.5821 7/28/2022 6176 6029.67929 146.32071002 21409.750182 7/29/2022 5504 6219.896213 -715.89621301 512507.3878 7/30/2022 5464 5289.2311361 174.7688639 30544.15579 7/31/2022 5412 5516.4306592 -104.43065917 10905.762575 8/1/2022 5741 5380.6708022 360.32919775 129837.13075 8/2/2022 5945 5849.0987593 95.901240675 9197.0479629 MSE 135676.47292
0.3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

IV-3 Assigmt- Module 2 Safety _ Mobility.docx
ITC Quiz A.docx
Lab B1 Report.pdf
Final Exam Part 1B-Rugas.docx
Overview Chandana.docx
AME 341b—Mini Talk Prep.docx
pdfcoffee.com-astro160-problems-solutions-philipsquestion24pg40.pdf
Quiz 2 Lecture Notes 2.1 (1).pdf
PA #3.pdf
Prelab_Centripetal Force.pdf
Lab 6.pdf
Phys_131_Problem_Set_7_Solutions (3).pdf

Browse Popular Homework Q&A

Q: What is the molality of ions in a 0.283 m solution of (NH₄)₃PO₄ assuming the compound dissociates…
Q: 2AgNO3(aq) +CaCl2(aq)--> 2AgCl(s) + Ca(NO3)2(aq) You have a 1.00 M solution of silver nitrate and a…
Q: A cell has an internal resistance of 0.02 ohm and an e.m.f. of 2.0V. Calculate its terminal p f it…
Q: Consider a trapezoid that has a constant area of 300 cm². The height of the trapezoid is increasing…
Q: How should public education be financed? Is a property tax the best way to do it? What are the…
Q: Problem 05.047 - A difference amplifier The circuit given below is for a difference amplifier. Find…
Q: Write SQL CODE a. Create a new Table, and name it DEPARTMENT. It contains 3 columns: DEPT_CODE,…
Q: Problem 05.072 - Output of a cascaded amplifier circuit Find the load voltage VL in the circuit.…
Q: Consider a pool shaped like the bottom half of a sphere, that is being filled. The radius of the…
Q: Shown below is T-v plot for a pure substance, where , ,  and  are known values.…
Q: Use the phasor concept to find the steady-state expression for i, (t) in the circuit below. (10…
Q: Jupiter Explorers has $7400 in sales.  The profit margin is 5 poercent.  There are 4100 shares of…
Q: Calculate the future value of $9,000 invested (single amount) for ten years in an account with an…
Q: The resistance of an electric heater is 25 2 when connected to 120 V. How much energy does it use…
Q: A car is accelerated from velocity v₁ to v2 in the time period of t. The mass of the car is m. The…
Q: Calculate the mass flow rate   _________
Q: A rigid tank is divided into two equal parts by a partition. One part of the tank contains 2.5 kg of…
Q: What is the equilibrium level of
Q: 3. You toss a snack to your friend on a hike. Your friend is located 8.6 m up a 39° slope. Determine…
Q: gram staining. Will this procedure stain all cells
Q: When separating proteins from cellular extractions, what electrophoresis method works best and what…
Q: How do the examples in Caroline’s Hentz’s The Planter’s Northern Bride illustrate the concept of…
Q: 2 5 What is the shape and size of this tolerance zone? 1.25 0.50 Dum +/-0.002 0.010
Q: The total cost (in hundreds of dollars) of producing x calculators per day is given by the equation.…
Q: The profit function for a firm making widgets is  P(x) = 154x − x2 − 1800.  Find the number of…