Sara’s Salsa Company produces its condiments in two types: Extra
Fine for restaurant customers and Family Style for home use. Salsa
is prepared in department 1 and packaged in department 2. The
activities, overhead costs, and drivers associated with these two
manufacturing processes and the company’s production support
activities follow.
| Process | Activity | Overhead cost | Driver | Quantity | ||
| Department 1 | Mixing | $ | 5,800 | Machine hours | 2,200 | |
| Cooking | 12,900 | Machine hours | 2,200 | |||
| Product testing | 113,800 | Batches | 1,000 | |||
| $ | 132,500 | |||||
| Department 2 | Machine calibration | $ | 315,000 | Production runs | 500 | |
| Labeling | 20,000 | Cases of output | 145,000 | |||
| Defects | 9,000 | Cases of output | 145,000 | |||
| $ | 344,000 | |||||
| Support | Recipe formulation | $ | 82,000 | Focus groups | 40 | |
| Heat, lights, and water | 33,000 | Machine hours | 2,200 | |||
| Materials handling | 78,000 | Container types | 8 | |||
| $ | 193,000 | |||||
Additional production information about its two product lines
follows.
| Extra Fine | Family Style | |||
| Units produced | 33,000 | cases | 112,000 | cases |
| Batches | 330 | batches | 670 | batches |
| Machine hours | 900 | MH | 1,300 | MH |
| Focus groups | 30 | groups | 10 | groups |
| Container types | 6 | containers | 2 | containers |
| Production runs | 240 | runs | 260 | runs |
4. Using ABC, compute the total cost per case
for each product type if the direct labor and direct materials cost
is $9 per case of Extra Fine and $8 per case of Family Style.
(Round your intermediate calculations to 2 decimal places.
Round "Activity Rate" and "Overhead cost per unit" answers to 2
decimal places.)
In: Accounting
Sara’s Salsa Company produces its condiments in two types: Extra
Fine for restaurant customers and Family Style for home use. Salsa
is prepared in department 1 and packaged in department 2. The
activities, overhead costs, and drivers associated with these two
manufacturing processes and the company’s production support
activities follow.
| Process | Activity | Overhead cost | Driver | Quantity | ||
| Department 1 | Mixing | $ | 5,800 | Machine hours | 2,200 | |
| Cooking | 12,900 | Machine hours | 2,200 | |||
| Product testing | 113,800 | Batches | 1,000 | |||
| $ | 132,500 | |||||
| Department 2 | Machine calibration | $ | 315,000 | Production runs | 500 | |
| Labeling | 20,000 | Cases of output | 145,000 | |||
| Defects | 9,000 | Cases of output | 145,000 | |||
| $ | 344,000 | |||||
| Support | Recipe formulation | $ | 82,000 | Focus groups | 40 | |
| Heat, lights, and water | 33,000 | Machine hours | 2,200 | |||
| Materials handling | 78,000 | Container types | 8 | |||
| $ | 193,000 | |||||
Additional production information about its two product lines
follows.
| Extra Fine | Family Style | |||
| Units produced | 33,000 | cases | 112,000 | cases |
| Batches | 330 | batches | 670 | batches |
| Machine hours | 900 | MH | 1,300 | MH |
| Focus groups | 30 | groups | 10 | groups |
| Container types | 6 | containers | 2 | containers |
| Production runs | 240 | runs | 260 | runs |
5. If the market price is $18 per case of Extra
Fine and $12 per case of Family Style, determine the gross profit
per case for each product. (Round your intermediate
calculations and final answers to 2 decimal
places.)
In: Accounting
When one company (A) buys another company(B), some workers of company B are terminated. Terminated workers get severance pay. To be fair, company A fixes the severance payment to company B workers as equivalent to company A workers who were terminated in the last one year. A 36-year-old Mohammed, worked for company B for the last 10 years earning 32000 per year, was terminated with a severance pay of 5 weeks of salary. Bill smith complained that this is unfair that someone with the same credentials worked in company A received more. You are called in to settle the dispute. You are told that severance is determined by three factors; age, length of service with the company and the pay. You have randomly taken a sample of 40 employees of company A terminated last year. You recorded
Number of weeks of severance pay
Age of employee
Number of years with the company
Annual pay in 1000s
|
Weeks SP |
Age |
Years |
Pay |
Weeks SP |
Age |
Years |
Pay |
|
13 |
37 |
16 |
46 |
11 |
44 |
12 |
35 |
|
13 |
53 |
19 |
48 |
10 |
33 |
13 |
32 |
|
11 |
36 |
8 |
35 |
8 |
41 |
14 |
42 |
|
14 |
44 |
16 |
33 |
5 |
33 |
7 |
37 |
|
3 |
28 |
4 |
40 |
6 |
27 |
4 |
35 |
|
10 |
43 |
9 |
31 |
14 |
39 |
12 |
36 |
|
4 |
29 |
3 |
33 |
12 |
50 |
17 |
30 |
|
7 |
31 |
2 |
43 |
10 |
43 |
11 |
29 |
|
12 |
45 |
15 |
40 |
14 |
49 |
14 |
29 |
|
7 |
44 |
15 |
32 |
12 |
48 |
17 |
36 |
|
8 |
42 |
13 |
42 |
12 |
41 |
17 |
37 |
|
11 |
41 |
10 |
38 |
8 |
39 |
8 |
36 |
|
9 |
32 |
5 |
25 |
12 |
49 |
16 |
28 |
|
10 |
45 |
13 |
36 |
10 |
37 |
10 |
35 |
|
18 |
48 |
19 |
40 |
11 |
37 |
13 |
37 |
|
10 |
46 |
14 |
36 |
17 |
52 |
20 |
34 |
|
8 |
28 |
6 |
22 |
13 |
42 |
11 |
33 |
|
15 |
44 |
16 |
32 |
14 |
42 |
19 |
38 |
|
7 |
40 |
6 |
27 |
5 |
27 |
2 |
25 |
|
9 |
37 |
8 |
37 |
11 |
50 |
15 |
36 |
Answer the following questions based on your outputs. Provide the screen shots of your outputs wherever appropriate.
1. Find the regression equation and rank the variables the campaign type from the most explained to the least explained.
In: Statistics and Probability
When one company (A) buys another company(B), some workers of company B are terminated. Terminated workers get severance pay. To be fair, company A fixes the severance payment to company B workers as equivalent to company A workers who were terminated in the last one year. A 36-year-old Mohammed, worked for company B for the last 10 years earning 32000 per year, was terminated with a severance pay of 5 weeks of salary. Bill smith complained that this is unfair that someone with the same credentials worked in company A received more. You are called in to settle the dispute. You are told that severance is determined by three factors; age, length of service with the company and the pay. You have randomly taken a sample of 40 employees of company A terminated last year. You recorded
Number of weeks of severance pay
Age of employee
Number of years with the company
Annual pay in 1000s
|
Weeks SP |
Age |
Years |
Pay |
Weeks SP |
Age |
Years |
Pay |
|
13 |
37 |
16 |
46 |
11 |
44 |
12 |
35 |
|
13 |
53 |
19 |
48 |
10 |
33 |
13 |
32 |
|
11 |
36 |
8 |
35 |
8 |
41 |
14 |
42 |
|
14 |
44 |
16 |
33 |
5 |
33 |
7 |
37 |
|
3 |
28 |
4 |
40 |
6 |
27 |
4 |
35 |
|
10 |
43 |
9 |
31 |
14 |
39 |
12 |
36 |
|
4 |
29 |
3 |
33 |
12 |
50 |
17 |
30 |
|
7 |
31 |
2 |
43 |
10 |
43 |
11 |
29 |
|
12 |
45 |
15 |
40 |
14 |
49 |
14 |
29 |
|
7 |
44 |
15 |
32 |
12 |
48 |
17 |
36 |
|
8 |
42 |
13 |
42 |
12 |
41 |
17 |
37 |
|
11 |
41 |
10 |
38 |
8 |
39 |
8 |
36 |
|
9 |
32 |
5 |
25 |
12 |
49 |
16 |
28 |
|
10 |
45 |
13 |
36 |
10 |
37 |
10 |
35 |
|
18 |
48 |
19 |
40 |
11 |
37 |
13 |
37 |
|
10 |
46 |
14 |
36 |
17 |
52 |
20 |
34 |
|
8 |
28 |
6 |
22 |
13 |
42 |
11 |
33 |
|
15 |
44 |
16 |
32 |
14 |
42 |
19 |
38 |
|
7 |
40 |
6 |
27 |
5 |
27 |
2 |
25 |
|
9 |
37 |
8 |
37 |
11 |
50 |
15 |
36 |
Identify best subsets of variables based on Mallows Cp. What is the value of R-square to this “best” model? How many outliers are in the dataset? Use the criteria of your choice and mention it(them)
In: Math
When one company (A) buys another company(B), some workers of company B are terminated. Terminated workers get severance pay. To be fair, company A fixes the severance payment to company B workers as equivalent to company A workers who were terminated in the last one year. A 36-year-old Mohammed, worked for company B for the last 10 years earning 32000 per year, was terminated with a severance pay of 5 weeks of salary. Bill smith complained that this is unfair that someone with the same credentials worked in company A received more. You are called in to settle the dispute. You are told that severance is determined by three factors; age, length of service with the company and the pay. You have randomly taken a sample of 40 employees of company A terminated last year. You recorded
Number of weeks of severance pay
Age of employee
Number of years with the company
Annual pay in 1000s
|
Weeks SP |
Age |
Years |
Pay |
Weeks SP |
Age |
Years |
Pay |
|
13 |
37 |
16 |
46 |
11 |
44 |
12 |
35 |
|
13 |
53 |
19 |
48 |
10 |
33 |
13 |
32 |
|
11 |
36 |
8 |
35 |
8 |
41 |
14 |
42 |
|
14 |
44 |
16 |
33 |
5 |
33 |
7 |
37 |
|
3 |
28 |
4 |
40 |
6 |
27 |
4 |
35 |
|
10 |
43 |
9 |
31 |
14 |
39 |
12 |
36 |
|
4 |
29 |
3 |
33 |
12 |
50 |
17 |
30 |
|
7 |
31 |
2 |
43 |
10 |
43 |
11 |
29 |
|
12 |
45 |
15 |
40 |
14 |
49 |
14 |
29 |
|
7 |
44 |
15 |
32 |
12 |
48 |
17 |
36 |
|
8 |
42 |
13 |
42 |
12 |
41 |
17 |
37 |
|
11 |
41 |
10 |
38 |
8 |
39 |
8 |
36 |
|
9 |
32 |
5 |
25 |
12 |
49 |
16 |
28 |
|
10 |
45 |
13 |
36 |
10 |
37 |
10 |
35 |
|
18 |
48 |
19 |
40 |
11 |
37 |
13 |
37 |
|
10 |
46 |
14 |
36 |
17 |
52 |
20 |
34 |
|
8 |
28 |
6 |
22 |
13 |
42 |
11 |
33 |
|
15 |
44 |
16 |
32 |
14 |
42 |
19 |
38 |
|
7 |
40 |
6 |
27 |
5 |
27 |
2 |
25 |
|
9 |
37 |
8 |
37 |
11 |
50 |
15 |
36 |
2. How much variance is not explained by the model? Test the validity of the models that X predict Y (provide hypotheses, decision, conclusion and conclusion in the business context)
In: Math
(c) Actually, the 10,000 larvae in each group came from a series of 50 different runs of the experiment, with 200 larvae in each group for each run. The researchers believe that conditions differ from run to run, and thus it makes sense to treat each run as a case (rather than each fly). In this analysis, we are looking at paired data, and the response variable would be the difference in the number of larvae surviving between the choice group and the no choice group, for each of the 50 runs. The counts (Choice and NoChoice and difference (Choice − NoChoice) in number of surviving larva are stored in MateChoice. Using the single variable of differences, calculate the p-value for testing whether the average difference is greater than 0
| Choice | NoChoice | Difference |
| 114 | 131 | -17 |
| 126 | 136 | -10 |
| 140 | 130 | 10 |
| 121 | 122 | -1 |
| 123 | 130 | -7 |
| 123 | 144 | -21 |
| 137 | 133 | 4 |
| 114 | 124 | -10 |
| 118 | 110 | 8 |
| 123 | 135 | -12 |
| 116 | 128 | -12 |
| 128 | 132 | -4 |
| 141 | 145 | -4 |
| 131 | 142 | -11 |
| 125 | 179 | -54 |
| 138 | 115 | 23 |
| 111 | 140 | -29 |
| 128 | 135 | -7 |
| 126 | 142 | -16 |
| 111 | 105 | 6 |
| 122 | 124 | -2 |
| 123 | 111 | 12 |
| 142 | 123 | 19 |
| 127 | 98 | 29 |
| 132 | 135 | -3 |
| 133 | 112 | 21 |
| 98 | 106 | -8 |
| 117 | 103 | 14 |
| 98 | 116 | -18 |
| 132 | 96 | 36 |
| 104 | 116 | -12 |
| 125 | 114 | 11 |
| 118 | 114 | 4 |
| 117 | 108 | 9 |
| 116 | 104 | 12 |
| 110 | 114 | -4 |
| 132 | 111 | 21 |
| 106 | 101 | 5 |
| 110 | 115 | -5 |
| 139 | 131 | 8 |
| 101 | 99 | 2 |
| 125 | 110 | 15 |
| 117 | 112 | 5 |
| 118 | 111 | 7 |
| 116 | 109 | 7 |
| 105 | 95 | 10 |
| 129 | 120 | 9 |
| 124 | 106 | 18 |
| 113 | 92 | 21 |
| 124 | 112 | 12 |
In: Statistics and Probability
14.
Sara’s Salsa Company produces its condiments in two types: Extra
Fine for restaurant customers and Family Style for home use. Salsa
is prepared in department 1 and packaged in department 2. The
activities, overhead costs, and drivers associated with these two
manufacturing processes and the company’s production support
activities follow.
| Process | Activity | Overhead cost | Driver | Quantity | ||
| Department 1 | Mixing | $ | 5,200 | Machine hours | 1,600 | |
| Cooking | 10,800 | Machine hours | 1,600 | |||
| Product testing | 113,200 | Batches | 500 | |||
| $ | 129,200 | |||||
| Department 2 | Machine calibration | $ | 285,000 | Production runs | 750 | |
| Labeling | 10,500 | Cases of output | 155,000 | |||
| Defects | 5,000 | Cases of output | 155,000 | |||
| $ | 300,500 | |||||
| Support | Recipe formulation | $ | 97,000 | Focus groups | 50 | |
| Heat, lights, and water | 34,000 | Machine hours | 1,600 | |||
| Materials handling | 72,000 | Container types | 8 | |||
| $ | 203,000 | |||||
Additional production information about its two product lines
follows.
| Extra Fine | Family Style | |||
| Units produced | 27,000 | cases | 128,000 | cases |
| Batches | 270 | batches | 230 | batches |
| Machine hours | 600 | MH | 1,000 | MH |
| Focus groups | 40 | groups | 10 | groups |
| Container types | 6 | containers | 2 | containers |
| Production runs | 270 | runs | 480 | runs |
4. Using ABC, compute the total cost per case for each product type if the direct labor and direct materials cost is $10 per case of Extra Fine and $9 per case of Family Style. (Round your intermediate calculations to 2 decimal places. Round "Activity Rate" and "Overhead cost per unit" answers to 2 decimal places.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Imagine that you buy a new computer system with independent
components including a new desktop computer (with a CPU and a
graphics card), new software, and a new monitor. You want to play
games on the new system, but it runs games very slowly. You assume
that the keyboard and mouse are not creating the problem; so, to
figure out what is making the system run so slowly, you experiment
with combinations of your old equipment with the new equipment.
Here are your experiments and results:
Experiment 1: New computer, new software, and new monitor — and it
runs slowly.
Experiment 2: New computer, new software, and old monitor — and it
runs slowly.
Experiment 3: New computer, old software, and new monitor — and it
runs fast.
Experiment 4: New computer, old software, and old monitor — and it
runs fast.
Experiment 5: Old computer, new software, and new monitor — and it
runs fast.
Experiment 6: Old computer, new software, and old monitor — and it
slowly.
Experiment 7: Old computer, old software, and new monitor — and it
runs fast.
Experiment 8: Old computer, old software, and old monitor — and it
runs fast.
Based on this data, which experiment shows that the conjunction of
the new computer and the new software is NOT SUFFICIENT for the
system to run slowly?
In: Statistics and Probability
Imagine that you buy a new computer system with independent
components including a new desktop computer (with a CPU and a
graphics card), new software, and a new monitor. You want to play
games on the new system, but it runs games very slowly. You assume
that the keyboard and mouse are not creating the problem; so, to
figure out what is making the system run so slowly, you experiment
with combinations of your old equipment with the new equipment.
Here are your experiments and results:
Experiment 1: New computer, new software, and new monitor — and it
runs slowly.
Experiment 2: New computer, new software, and old monitor — and it
runs slowly.
Experiment 3: New computer, old software, and new monitor — and it
runs fast.
Experiment 4: New computer, old software, and old monitor — and it
runs fast.
Experiment 5: Old computer, new software, and new monitor — and it
runs fast.
Experiment 6: Old computer, new software, and old monitor — and it
slowly.
Experiment 7: Old computer, old software, and new monitor — and it
runs fast.
Experiment 8: Old computer, old software, and old monitor — and it
runs fast.
Based on this data, which experiment shows that the conjunction of
the new software and the old monitor is NOT SUFFICIENT for the
system to run slowly?
In: Advanced Math
for java
Welcome to a classic homework problem! Create a public class called Last8. You should exposed two public methods: add: adds a value, does not return a value last: returns an array containing the last 8 values that were added, in any order. You do not need a constructor, but you can add an empty one if you need. Until 8 values have been added you should return 0s in their place. For example, here's how an instance of Last8 should work:
In: Computer Science