Question: part 1 and 2. Please only answer if you know how to do it. With a new chef and a creative menu, Caf Venetian has

part 1 and 2. Please only answer if you know how to do it.
part 1 and 2. Please only answer if you know how to
do it. With a new chef and a creative menu, Caf Venetian
has witnessed a huge surge in sales. The following data show a
portion of daily sales (in $) at Caf Venetian in the first

With a new chef and a creative menu, Caf Venetian has witnessed a huge surge in sales. The following data show a portion of daily sales (in $) at Caf Venetian in the first 100 days after the changes. Day 1 2 3 100 Sales 216 176 1,656 DpictureClick here for the Excel Dato Fils a-1. Estimate the exponential trend model. (Negative values for regression coefficients should be indicated by a minus sign. Round your answers to 2 decimal places.) Coefficient Predictor Variable Constant Day a-2. Use the estimated model to forecast for the 101st day. (Do not round coefficient estimates. Round final answer to 2 decimal places.) Forecast for the 101" day D E B F A 1 Day 21 3 2 4 3 54 6 5 7 6 LO 8 7 98 10 9 11 10 12 11 13 12 14 13 15 14 16 15 17 16 18 17 19 18 20 19 21 20 22 21 23 22 24 23 25 24 26 25 27 26 28 27 29 28 30 29 31 30 32 31 33 32 34 33 35 34 36 35 Sales 216 176 255 292 199 231 313 237 294 221 296 257 311 230 315 332 233 239 272 487 358 326 351 382 256 376 321 431 693 427 306 634 617 378 622 Sheet1 + Recover Unsaved Workbooks. We were able to save changes to G13 X fx B D E F G 37 36 38 37 39 38 40 39 41 40 42 41 43 42 44 43 45 44 46 45 47 46 48 47 49 48 50 49 51 50 52 51 53 52 54 53 55 54 56 55 57 56 58 57 59 58 60 59 61 60 62 61 63 62 64 63 65 64 66 65 67 66 68 67 69 68 70 69 71 70 72 71 575 567 626 532 548 468 483 588 287 769 663 620 659 663 1070 817 575 715 719 575 713 685 647 592 645 1096 884 642 794 1058 1397 943 1004 964 801 836 + + Sheet1 G13 x V fx B D m ro 72 71 73 72 74 73 75 74 76 75 77 76 78 77 79 78 80 79 81 80 82 81 83 82 84 83 85 84 86 85 87 86 88 87 89 88 90 89 91 90 92 91 93 92 94 93 95 94 96 95 97 96 98 97 99 98 100 99 101 100 102 103 104 LOS 106 107 00 836 878 1083 977 827 1308 775 1160 1012 1291 1153 1203 891 1312 1302 1262 1161 1161 1349 1443 1292 1405 1446 2408 1312 1483 1460 1364 2184 1656 + Sheet1 With a new chef and a creative menu, Caf Venetian has witnessed a huge surge in sales. The following data show a portion of daily sales (in $) at Caf Venetian in the first 100 days after the changes. Day 1 2 3 100 Sales 216 176 1,656 DpictureClick here for the Excel Dato Fils a-1. Estimate the exponential trend model. (Negative values for regression coefficients should be indicated by a minus sign. Round your answers to 2 decimal places.) Coefficient Predictor Variable Constant Day a-2. Use the estimated model to forecast for the 101st day. (Do not round coefficient estimates. Round final answer to 2 decimal places.) Forecast for the 101" day D E B F A 1 Day 21 3 2 4 3 54 6 5 7 6 LO 8 7 98 10 9 11 10 12 11 13 12 14 13 15 14 16 15 17 16 18 17 19 18 20 19 21 20 22 21 23 22 24 23 25 24 26 25 27 26 28 27 29 28 30 29 31 30 32 31 33 32 34 33 35 34 36 35 Sales 216 176 255 292 199 231 313 237 294 221 296 257 311 230 315 332 233 239 272 487 358 326 351 382 256 376 321 431 693 427 306 634 617 378 622 Sheet1 + Recover Unsaved Workbooks. We were able to save changes to G13 X fx B D E F G 37 36 38 37 39 38 40 39 41 40 42 41 43 42 44 43 45 44 46 45 47 46 48 47 49 48 50 49 51 50 52 51 53 52 54 53 55 54 56 55 57 56 58 57 59 58 60 59 61 60 62 61 63 62 64 63 65 64 66 65 67 66 68 67 69 68 70 69 71 70 72 71 575 567 626 532 548 468 483 588 287 769 663 620 659 663 1070 817 575 715 719 575 713 685 647 592 645 1096 884 642 794 1058 1397 943 1004 964 801 836 + + Sheet1 G13 x V fx B D m ro 72 71 73 72 74 73 75 74 76 75 77 76 78 77 79 78 80 79 81 80 82 81 83 82 84 83 85 84 86 85 87 86 88 87 89 88 90 89 91 90 92 91 93 92 94 93 95 94 96 95 97 96 98 97 99 98 100 99 101 100 102 103 104 LOS 106 107 00 836 878 1083 977 827 1308 775 1160 1012 1291 1153 1203 891 1312 1302 1262 1161 1161 1349 1443 1292 1405 1446 2408 1312 1483 1460 1364 2184 1656 + Sheet1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!