Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a multiple regression in excel for cost drivers on total operating cost (7 cost drivers - direct labor hours, new menu items developed, number

Create a multiple regression in excel for cost drivers on total operating cost (7 cost drivers - direct labor hours, new menu items developed, number of deliveries (customer), number of deliveries (donated), total meals produced, customer meals sold, meals donated.

Week Total Sales Revenue Total Operating Cost Direct Labor Hours New Menu Items Developed Number of Deliveries (Customer Meals) Number of Deliveries (Donated Meals) Total Meals Produced Customer Meals Sold Meals Donated
1 $ 4,805 $ 3,375 110 2 375 6 2,746 1,373 1,373
2 $ 3,754 $ 3,465 94 3 315 8 2,145 1,073 1,073
3 $ 3,879 $ 3,564 98 3 325 8 2,217 1,108 1,108
4 $ 4,555 $ 3,318 98 2 450 6 2,603 1,301 1,301
5 $ 4,630 $ 3,722 98 3 445 8 2,646 1,323 1,323
6 $ 5,230 $ 3,419 131 3 435 8 2,989 1,494 1,494
7 $ 4,705 $ 3,412 105 2 465 6 2,688 1,344 1,344
8 $ 4,505 $ 3,620 110 5 400 6 2,574 1,287 1,287
9 $ 4,680 $ 3,724 115 3 400 6 2,674 1,337 1,337
10 $ 4,830 $ 3,545 125 3 425 8 2,760 1,380 1,380
11 $ 4,945 $ 3,646 140 3 440 8 2,826 1,413 1,413
12 $ 5,305 $ 3,539 125 3 460 6 3,032 1,516 1,516
13 $ 4,925 $ 3,512 100 2 375 6 2,814 1,407 1,407
14 $ 4,705 $ 3,702 146 3 350 8 2,688 1,344 1,344
15 $ 4,830 $ 3,829 101 5 460 8 2,760 1,380 1,380
16 $ 5,455 $ 3,640 131 3 475 6 3,117 1,559 1,559
17 $ 5,205 $ 3,961 135 4 400 8 2,974 1,487 1,487
18 $ 4,200 $ 3,893 135 4 460 8 2,400 1,200 1,200
19 $ 5,380 $ 3,517 135 3 450 8 3,075 1,537 1,537
20 $ 6,381 $ 4,234 135 4 600 8 3,647 1,823 1,823
21 $ 6,757 $ 4,356 135 2 620 8 3,861 1,931 1,931
22 $ 5,355 $ 4,074 139 4 412 8 3,060 1,530 1,530
23 $ 5,506 $ 4,057 141 3 440 8 3,146 1,573 1,573
24 $ 5,506 $ 3,983 143 4 460 8 3,146 1,573 1,573
25 $ 5,756 $ 3,855 143 3 465 8 3,289 1,645 1,645
26 $ 6,256 $ 4,151 143 4 570 8 3,575 1,788 1,788
27 $ 5,565 $ 3,718 131 2 400 8 3,180 1,590 1,590
28 $ 5,656 $ 4,174 146 3 458 8 3,232 1,616 1,616
29 $ 5,856 $ 3,966 147 3 490 8 3,346 1,673 1,673
30 $ 6,406 $ 4,270 147 4 588 8 3,661 1,830 1,830
31 $ 4,855 $ 3,808 150 3 300 8 2,774 1,387 1,387
32 $ 5,506 $ 4,347 150 3 420 10 3,146 1,573 1,573
33 $ 5,656 $ 4,300 150 4 440 8 3,232 1,616 1,616
34 $ 5,681 $ 4,472 150 5 430 10 3,246 1,623 1,623
35 $ 5,731 $ 4,098 150 4 475 8 3,275 1,637 1,637
36 $ 6,006 $ 3,796 150 3 500 8 3,432 1,716 1,716
37 $ 6,106 $ 3,904 150 4 515 8 3,489 1,745 1,745
38 $ 6,256 $ 4,552 150 4 480 8 3,575 1,788 1,788
39 $ 6,306 $ 4,457 150 4 540 10 3,604 1,802 1,802
40 $ 6,406 $ 4,684 150 4 490 8 3,661 1,830 1,830
41 $ 6,907 $ 4,281 150 4 650 8 3,947 1,973 1,973
42 $ 7,107 $ 4,404 150 4 670 8 4,061 2,031 2,031
43 $ 5,856 $ 4,424 154 4 450 8 3,346 1,673 1,673
44 $ 6,507 $ 4,586 120 4 320 10 3,718 1,859 1,859
45 $ 6,857 $ 4,651 169 5 580 10 3,918 1,959 1,959
46 $ 7,007 $ 4,976 169 3 700 8 4,004 2,002 2,002
47 $ 7,883 $ 4,983 169 5 680 10 4,505 2,252 2,252
48 $ 5,600 $ 4,785 173 4 600 10 3,200 1,600 1,600
49 $ 4,375 $ 5,120 173 5 720 8 2,500 1,250 1,250
50 $ 8,008 $ 5,127 173 4 600 10 4,576 2,288 2,288
51 $ 6,081 $ 4,609 180 3 450 10 3,475 1,737 1,737
52 $ 6,256 $ 4,742 188 4 460 10 3,575 1,788 1,788

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Probability Models

Authors: Sheldon M Ross

12th Edition

0128143460, 9780128143469

More Books

Students also viewed these Mathematics questions

Question

Always have the dignity of the other or others as a backdrop.

Answered: 1 week ago