using the model determined when the company must have the expanded work cell up and running

+ BOT 100 For example, the sales for April 2021 will be - 2609 2632 (considering the sales as whole number only) Question 2:- Develop a quantitative forecast model for Mr.Parsons? Answer 2.- In this case we are using straight line method to forecast the total sale of drivers. We are using this formula to calculate next month sale Previous month sales *(1 + 0.8861%) MONTH 19-Apr 19-May 19-Jun 19-Jul TYPE A SALE 1410 1417 1434 1452 TYPE B SALE 377 381 387 391 TYPE C SALE 343 344 346 349 TOTAL DRIVERS 2130 2142 2167 2192 Next month forecast NA 2149 2161 2186 2211 2232 2255 396 400 403 409 412 420 423 426 19-Aug 19-Sep 19-Oct 19-Nov 19-Dec 20-Jan 20-Feb 20-Mar 20-Apr 20-May 20-Jun 20-Jul 20-Aug 20-Sep 20-Oct 20-Nov 20-Dec 21-Jan 21-Feb 21-Mar 1466 1483 1490 1505 1521 1536 1547 1554 1562 1574 1587 1595 1613 1631 1642 1656 1673 1685 1703 1720 437 441 445 454 461 464 471 477 480 485 490 350 352 354 357 359 363 365 367 369 371 375 377 381 384 386 389 392 394 396 399 2212 2235 2247 2271 2292 2319 2335 2347 2362 2382 2403 2417 2448 2476 2492 2516 2542 2559 2584 2609 2267 2291 2312 2140 2356 2368 2383 2403 2424 2438 2470 2498 2514 2538 2565 2582 2607 + BOT 100 For example, the sales for April 2021 will be - 2609 2632 (considering the sales as whole number only) Question 2:- Develop a quantitative forecast model for Mr.Parsons? Answer 2.- In this case we are using straight line method to forecast the total sale of drivers. We are using this formula to calculate next month sale Previous month sales *(1 + 0.8861%) MONTH 19-Apr 19-May 19-Jun 19-Jul TYPE A SALE 1410 1417 1434 1452 TYPE B SALE 377 381 387 391 TYPE C SALE 343 344 346 349 TOTAL DRIVERS 2130 2142 2167 2192 Next month forecast NA 2149 2161 2186 2211 2232 2255 396 400 403 409 412 420 423 426 19-Aug 19-Sep 19-Oct 19-Nov 19-Dec 20-Jan 20-Feb 20-Mar 20-Apr 20-May 20-Jun 20-Jul 20-Aug 20-Sep 20-Oct 20-Nov 20-Dec 21-Jan 21-Feb 21-Mar 1466 1483 1490 1505 1521 1536 1547 1554 1562 1574 1587 1595 1613 1631 1642 1656 1673 1685 1703 1720 437 441 445 454 461 464 471 477 480 485 490 350 352 354 357 359 363 365 367 369 371 375 377 381 384 386 389 392 394 396 399 2212 2235 2247 2271 2292 2319 2335 2347 2362 2382 2403 2417 2448 2476 2492 2516 2542 2559 2584 2609 2267 2291 2312 2140 2356 2368 2383 2403 2424 2438 2470 2498 2514 2538 2565 2582 2607