Questions
1. Using the Data Set, create and calculate the following in Excel®: Determine the range of...

1. Using the Data Set, create and calculate the following in Excel®:

Determine the range of values in which you would expect to find the average weekly sales for the entire sales force in your company 90% of the time, and calculate the following:

A. The impact of increasing the confidence level to 95%

B. The impact of increasing the sample size to 150, assuming the same mean and standard deviation, but allowing the confidence level to remain at 90%

Data Set:

SAMPLE OF WEEKLY SALES
Sales Rep # AverageWeekly Sales($) Week # Weekly Sales($) - Rep A Weekly Sales($) - Rep B
1 1228 1 4657 5839
2 7374 2 6133 2602
3 1055 3 3438 2830
4 1859 4 7394 4763
5 3938 5 4327 3740
6 1692 6 2552 2315
7 569 7 7063 1599
8 4059 8 7844 1629
9 3689 9 6898 2416
10 607 10 4003 2107
11 1370 11 6884 4237
12 3735 12 4007 6322
13 3305 13 7214 3710
14 7228 14 2358 5890
15 6279 15 7745 5119
16 1671 16 1337 5184
17 5708 17 1052 3439
18 2569 18 6056 4828
19 4163 19 1495 3667
20 1519 20 3530 3518
21 7734 21 4749 6073
22 784 22 3833 5566
23 6766 23 7869 4555
24 7261 24 4541 5867
25 5034 25 6882 6039
26 7115 26 3868 1032
27 6291 27 5934 4834
28 6287 28 4447 3687
29 2080 29 5504 5500
30 7621 30 5554 4659
31 1047
32 6517
33 5172
34 3876
35 5429
36 4538
37 3786
38 2510
39 4863
40 7246
41 1175
42 641
43 4269
44 7034
45 3406
46 2256
47 3182
48 5178
49 4428
50 1189

In: Math

2.c++ if and loop statement Write a program that will count the number of even number...

2.c++ if and loop statement Write a program that will count the number of even number and odd numbers between two inputted numbers. Display the numbers and compute the sum and average of all the even numbers and the sum and average all the odd numbers.

Sample outputs:

Enter starting number:3 Enter starting number:4

Enter ending number:10 Enter ending number:10

odd numbers Even number

3 4

5 6

7 8

9 10

number of even numbers=4 number of even numbers=4

sum=24 sum=28

average=6 average=7

Even number odd number

4 5

6 7

8 9

10

Number of even number=4 Number of even number=3

sum=28 sum=21

average=7 average=7

In: Computer Science

x 2 8 5 9 4 3 9 6 7 8 y 3 6 5 7...

x 2 8 5 9 4 3 9 6 7 8
y 3 6 5 7 9 7 4 6 9 9

-5.48x + 0.17
5.48x + 0.17
-0.17x + 5.48
0.17x + 5.48

In: Statistics and Probability

Data: 7,-5, -8, 7, 9, 15, 0, 2, 13, 8, 6, -2, 4 (a) Mean= Mode=...

Data: 7,-5, -8, 7, 9, 15, 0, 2, 13, 8, 6, -2, 4 (a) Mean= Mode= median= (b) Variance= Standard deviation= (c) Range= IQR(Interquartilerange)= (d) Mid-Range= Mid-Hinge=

In: Math

Statement of cash flows contains the following sections: a. net cash flow from operating activies b....

Statement of cash flows contains the following sections:

a. net cash flow from operating activies

b. cash flows from investing activites

c. cash flows from financing activities

d. investing and financing activities NOT affecting cash

A list of items that appear on the statement is provided below:

_____ 1. Depreciation Expense

_____ 2. Proceeds from sale of land on gain (two solutions)

_____ 3. Decrease in accounts payable

_____ 4. Conversion of bonds to common stock

_____ 5. Payment of dividends, declared last fiscal year

_____ 6. Proceeds from issuance of short-term note payable, NOT relating to operating activities

_____ 7. Loss on cash sale of equipment (two solutions)

_____ 8. Payment for purchase of a building

_____ 9. Bond premium amortization using the effective interest method

_____ 10. Issuance of common stock to convert bonds payable

REQUIRED:

In the space provided, using the letter (a-d), indicate in which section(s) of the statement of cash flows (or accompanying schedule) the preceeding items would most likely be classified. After each items affecting cash, indicate with a plus sign (+) or a minus sign (-) whether the item would be reported as an increase (inflow) or a decrease (outflow).

In: Accounting

Unit- and Batch-Level Cost Drivers KC, a fast-food restaurant, serves fried chicken, fried fish, and French...

Unit- and Batch-Level Cost Drivers
KC, a fast-food restaurant, serves fried chicken, fried fish, and French fries. The managers have estimated the costs of a batch of fried chicken for KC's all-you-can-eat Friday Fried Fiesta. Each batch must be 100 pieces. The chicken is precut by the chain headquarters and sent to the stores in 10-piece bags. Each bag costs $3. Preparing a batch of 100 pieces of chicken with KC's special coating takes one employee two hours. The current wage rate is $8 per hour. Another cost driver is the cost of putting fresh oil into the fryers. New oil, costing $3, is used for each batch.

Round answers to two decimal places, when applicable.

(a) Determine the cost of preparing one batch of 100 pieces.
$Answer



(b) If management projects that it will sell 300 pieces of fried chicken, determine the total batch and unit costs.
Batch cost $Answer


Unit cost $Answer



(c) If management estimates the sales to be 250 pieces, determine the total costs.
$Answer



(d) How much will the batch costs increase if the government raises the minimum wage to $10 per hour?
$Answer



(e) If management decided to reduce the number of pieces in a batch to 50, determine the cost of preparing 250 pieces. Assume that the batch would take half as long to prepare, and management wants to replace the oil after 50 pieces are cooked.
$Answer

In: Accounting

Unit- and Batch-Level Cost Drivers KC, a fast-food restaurant, serves fried chicken, fried fish, and French...

Unit- and Batch-Level Cost Drivers
KC, a fast-food restaurant, serves fried chicken, fried fish, and French fries. The managers have estimated the costs of a batch of fried chicken for KC's all-you-can-eat Friday Fried Fiesta. Each batch must be 100 pieces. The chicken is precut by the chain headquarters and sent to the stores in 10-piece bags. Each bag costs $3. Preparing a batch of 100 pieces of chicken with KC's special coating takes one employee two hours. The current wage rate is $8 per hour. Another cost driver is the cost of putting fresh oil into the fryers. New oil, costing $3, is used for each batch.

Round answers to two decimal places, when applicable.

(a) Determine the cost of preparing one batch of 100 pieces.
$Answer

(b) If management projects that it will sell 300 pieces of fried chicken, determine the total batch and unit costs.

Batch cost $Answer

Unit cost $Answer

(c) If management estimates the sales to be 250 pieces, determine the total costs.

$Answer

(d) How much will the batch costs increase if the government raises the minimum wage to $10 per hour?
$Answer

(e) If management decided to reduce the number of pieces in a batch to 50, determine the cost of preparing 250 pieces. Assume that the batch would take half as long to prepare, and management wants to replace the oil after 50 pieces are cooked.

$Answer

In: Accounting

Unit- and Batch-Level Cost Drivers KC, a fast-food restaurant, serves fried chicken, fried fish, and French...

Unit- and Batch-Level Cost Drivers
KC, a fast-food restaurant, serves fried chicken, fried fish, and French fries. The managers have estimated the costs of a batch of fried chicken for KC's all-you-can-eat Friday Fried Fiesta. Each batch must be 100 pieces. The chicken is precut by the chain headquarters and sent to the stores in 10-piece bags. Each bag costs $2. Preparing a batch of 100 pieces of chicken with KC's special coating takes one employee two hours. The current wage rate is $8 per hour. Another cost driver is the cost of putting fresh oil into the fryers. New oil, costing $3, is used for each batch.

Round answers to two decimal places, when applicable.

(a) Determine the cost of preparing one batch of 100 pieces.
$Answer

(b) If management projects that it will sell 300 pieces of fried chicken, determine the total batch and unit costs.
Batch cost $Answer
Unit cost $Answer

(c) If management estimates the sales to be 450 pieces, determine the total costs.
$Answer

(d) How much will the batch costs increase if the government raises the minimum wage to $10 per hour?
$Answer

(e) If management decided to reduce the number of pieces in a batch to 50, determine the cost of preparing 450 pieces. Assume that the batch would take half as long to prepare, and management wants to replace the oil after 50 pieces are cooked.
$Answer

In: Accounting

Quantitative Problem: At the end of last year, Edwin Inc. reported the following income statement (in...

Quantitative Problem: At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars):

Sales $4,290.00
Operating costs (excluding depreciation) 3,058.00
EBITDA $1,232.00
Depreciation 345.00
EBIT $887.00
Interest 130.00
EBT $757.00
Taxes (40%) 302.80
Net income $454.20

Looking ahead to the following year, the company's CFO has assembled this information:

  • Year-end sales are expected to be 5% higher than $4.29 billion in sales generated last year.
  • Year-end operating costs, excluding depreciation, are expected to increase at the same rates as sales.
  • Depreciation costs are expected to increase at the same rate as sales.
  • Interest costs are expected to remain unchanged.
  • The tax rate is expected to remain at 40%.

On the basis of this information, what will be the forecast for Edwin's year-end net income? Enter your answers as positive values. Enter your answers in millions. For example, an answer of $10,550,000 should be entered as 10.55. Do not round intermediate calculations. Round your answers to two decimal places.

Edwin Inc.
Income Statement
(in millions of dollars)
Sales $  
Operating costs (excluding depreciation)    
EBITDA $  
Depreciation    
EBIT $  
Interest    
EBT $  
Taxes (40%)    
Net income $  

In: Finance

Germany introduced its version of the above game " Heimfreiheit und Spaß." The German branch strongly...

Germany introduced its version of the above game " Heimfreiheit und Spaß." The German branch strongly argued against using the standard deviation of the online game population. They argued that the game is unique in a unique environment. They reported the following daily revenue. Create a 92% confidence interval for the population mean of daily revenue in Germany Day Revenue

Day Revenue
1 $      5,756.67
2 $      9,830.94
3 $      4,816.01
4 $    14,223.89
5 $    10,165.92
6 $    11,536.27
7 $          369.86
8 $      6,653.34
9 $      4,094.15
10 $      8,991.33
11 $    18,661.26
12 $    19,761.52
13 $      9,941.33
14 $      4,562.90
15 $      5,048.30
16 $    10,797.53
17 $      2,095.75
18 $      7,080.88
19 $    11,508.74
20 $    20,999.13
21 $    13,782.45
22 $      6,777.79
23 $    13,548.91
24 $      2,302.33
25 $      8,151.19
26 $      9,048.90
27 $      8,723.91
28 $    20,045.47
29 $    11,861.94
30 $      9,267.34
31 $          125.79
32 $    11,564.47
33 $      9,663.64
34 $    10,827.95
35 $    13,924.31
36 $    20,185.78
37 $    20,882.18
38 $    10,009.74
39 $    10,734.91
40 $    18,305.92
41 $    13,791.64
42 $      1,195.78
43 $      9,118.23
44 $      8,062.51

In: Statistics and Probability