Question

In: Accounting

Multiple Choice (20 marks) Query Questions (use the tables below to answer the 5 query questions...

Multiple Choice

Query Questions (use the tables below to answer the 5 query questions below)

The Business. A retail company sells electronics items by phone and on its web site. The company records information about each item sold in a table called Sales. A few rows of the Sales table in the database are shown below:

Sales table (primary key = SaleID and ItemID)

SaleID

ItemID

CustomerID

ItemType

SaleDate

101

151

52

4

1/1/2019

101

176

52

1

1/1/2019

102

227

532

1

1/1/2019

Service Calls.The company provides various warranty services by telephone. The company estimates the number of minutes of warranty services that will be required. This is shown in the table called TimeEstimate. EstimatedTime is the average number of minutes of estimated service time by TechnicianType for each item sold, organized by the ItemType.

TimeEstimate table (primary key = ItemType and TechnicianType)

ItemType

TechnicianType

EstimatedTime

1

1

30

1

2

20

1

3

10

2

1

30

2

2

20

Technician types are stored in a table called Employee.

Employee table (primary key = EmployeeID)

EmployeeID

Lastname

Firstname

TechnicianType

HireDate

53

Smith

Mark

3

3/4/20014

55

Jones

Nathan

2

3/10/2014

56

Brooks

Mary

1

3/12/2014

Technician cost by minute is stored in table TechnicianCost, which is shown below.

TechnicianCost table (primary key = TechnicianType)

TechnicianType

CostperMinute

LevelDesc

1

$1.00

Staff

2

$2.00

Senior

3

$3.00

Manager

Estimated technician expense is defined as the sum over all items sold of TechnicianCost.CostperMinute times TimeEstimate.EstimatedTime by TechnicianType.

The minutes of actual service provided is recorded in a table called ActualService. The table contains all the warranty calls for the items in the Sales table.

ActualService table (primary key = ItemID, DateService, and StartTime)

ItemID

DateService

StartTime

EmployeeID

Minutes

151

1/3/2019

11:43

56

18

151

1/8/2019

10:36

62

16

176

1/3/2019

8:56

56

12

Actual technician expense is calculated as the sum over all items sold of TechnicianCost.CostperMinute times ActualService.Minutes by TechnicianType.

The Issue. The service manager believes that actual expenses for warranty service are exceeding budgeted expenses. To investigate this, several queries will be completed. The following questions involve potential queries.

1. Some technicians revealed that most of their recent calling time related to one or two item types. To follow up on this information, you should investigate:

  1. frequency of calls by item type
  2. average time by item type by technician level
  3. average time per call by item type
  4. average time spent by technician by item type

a. 1 and 2

b. 1 and 3

c. 2 and 4

d. 3 and 4

e. none of the above

3. Assume that the number of minutes of service provided exceeds the number of minutes that were estimated. Also, the total cost of the minutes provided exceeds the budgeted cost of the estimated minutes. This indicates a need for you to investigate the time and cost differences for:

a. each item type, each technical type, and each technician

b. each item type and each technical type

c. each technician type and each technician

d. each item type and each technician

e. none of the above

Solutions

Expert Solution

1. Some technicians revealed that most of their recent calling time related to one or two item types. To follow up on this information, you should investigate:

  1. frequency of calls by item type
  2. average time by item type by technician level
  3. average time per call by item type
  4. average time spent by technician by item type

Actual expenses for warranty are exceeding budgeted expenses because of the average time by item type by technician level & average time spent by technician by item type.

Hence correct answere will be (2) & (4)

3. Assuming that the number of minutes of service provided exceeds the number of minutes that were estimated, the total cost of the minutes provided exceeds the budgted cost of the estimated minutes, it can be implied that the costs are mainly driven by two factors; item type and the technical type of person involved.

Hence, option B "each item type and each technical type" is correct.


Related Solutions

SECTION A. (25 MARKS) MULTIPLE CHOICE QUESTION : ANSWER ALL QUESTIONS 1. The opportunity cost of...
SECTION A. MULTIPLE CHOICE QUESTION : ANSWER ALL QUESTIONS 1. The opportunity cost of holding money _________ A. is zero because money is not an economic resource. B. varies inversely with the interest rate. C. varies directly with the interest rate. D. varies inversely with the level of economic activity. 2. The consumer price index is used to ___________ A. monitor changes in the level of wholesale prices in the economy. B. monitor changes in the cost of living over...
QUESTION 1 (10 marks) (12 minutes) Answer the following multiple-choice questions. Indicate your choice by selecting...
QUESTION 1 (12 minutes) Answer the following multiple-choice questions. Indicate your choice by selecting only one option from the four options given for each question answered. (a) Which one of the following is not considered to be an enhancing qualitative characteristic to ensure the usefulness of information that is already relevant and faithfully represented in terms of The Conceptual Framework for Financial Reporting 2018? 1) Completeness; 2) Comparability; 3) Timeliness; 4) Understandability. (b) Which one of the following is not...
QUESTION 1 (10 marks) Answer the following multiple-choice questions. Indicate your choice by selecting only one...
QUESTION 1 Answer the following multiple-choice questions. Indicate your choice by selecting only one option from the four options given for each question answered. (a) Which one of the following is not considered to be an enhancing qualitative characteristic to ensure the usefulness of information that is already relevant and faithfully represented in terms of The Conceptual Framework for Financial Reporting 2018? 1) Completeness; 2) Comparability; 3) Timeliness; 4) Understandability. (b) Which one of the following is not an objective...
You are taking a multiple-choice examination that has 20 questions in a particular section with 5...
You are taking a multiple-choice examination that has 20 questions in a particular section with 5 possible answers for each question. You did not study for the test and you guessed the answers. The probability that you guessed 50% of the answers correct by guessing is A:- 0.02% B:- 0.26% C:- 30.5% D:- 0.99% Which of the following statement is true? A:- A binomial distribution with n=20 and p =0.05 will be right-skewed. B:- A binomial distribution with n=6 and...
A student is given 20 multiple choice questions. Each multiple choice question has 4 options &...
A student is given 20 multiple choice questions. Each multiple choice question has 4 options & only one correct answer. The student answers all the questions in a random manner. a) What is the probability the student scores 80% or above? b) What is the probability the student scores 50% or above?
10. Multiple choice - Choose the most appropriate answer. [5 marks] I. Your friend Jana was...
10. Multiple choice - Choose the most appropriate answer. [5 marks] I. Your friend Jana was diagnosed with a specific vitamin B toxicity. However, she doesn’t recall the name of the vitamin. Which of the following is the only possible culprit associated with toxicity symptoms? a. Niacin b. Biotin c. Riboflavin d. Vitamin B12 II. What type of foods should be controlled in individuals taking anticoagulant medicines? a. Cold water fish b. Processed soups c. Enriched breads d. Green leafy...
5. Use the data set given below to answer these questions: (24 marks) Income 52.1 49.3...
5. Use the data set given below to answer these questions: Income 52.1 49.3 48.9 44.4 53.5 48.0 49.2 50.6 53.2 43.7 46.9 45.5 50.1 48.1 52.7 49.5 44.5 52.0 51.1 54.9 54.0 54.2 44.2 47.2 51.9 52.8 52.3 53.6 44.2 38.4 a. What is the sample mean of the variable Income? b. What is the sample median the variable Income? c. Find the range of Income. d. Find the sample standard deviation of Income. e. Compute the first and...
5. Use the data set given below to answer these questions: (24 marks) Income 52.1 49.3...
5. Use the data set given below to answer these questions: Income 52.1 49.3 48.9 44.4 53.5 48.0 49.2 50.6 53.2 43.7 46.9 45.5 50.1 48.1 52.7 49.5 44.5 52.0 51.1 54.9 54.0 54.2 44.2 47.2 51.9 52.8 52.3 53.6 44.2 38.4 a. What is the sample mean of the variable Income? b. What is the sample median the variable Income? c. Find the range of Income. d. Find the sample standard deviation of Income. e. Compute the first and...
Answer the following multiple choice questions below: 1a. Increasing the flow rate of the mobile phase...
Answer the following multiple choice questions below: 1a. Increasing the flow rate of the mobile phase would: A. increase longitudinal diffusion. B. affect nothing. C. increase broadening due to multiple paths. D. increase broadening due to mass transfer. 1b. Reverse phase HPLC of a multi-component solute usually uses: A . an isocratic polar solvent. B. a polar stationary phase. C. a gradient from more polar to less polar solvent. D. a gradient from less polar to more polar solvent. 1c....
Variable and Absorption Costing Use the following information to answer the following 2 multiple choice questions:...
Variable and Absorption Costing Use the following information to answer the following 2 multiple choice questions: Information taken from the accounting records of Holly Manufacturing for 2018: Direct materials used $340,000 Direct labour $70,000 Variable manufacturing overhead $60,000 Fixed manufacturing overhead $130,000 Variable selling and administrative costs $40,000 Fixed selling and administrative costs $20,000 Units produced during the year 40,000 Units in inventory at the end of the year 6,000 There was no opening inventory. Please do not give the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT