![Problem 9-2 The following information applies to the questions displayed below] An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls for the previous week, as shown in the table. Problem/ob Problem/Job Problem/ Number Customer Type Number Customer Type Number Customer Type 301 O/R WIC N/R 315 316 317 318 W/R W/R O/R F/R N/R O/C F/C N/R WIC N/R Wic O/R F/C O/R N/R O/R N/R W/R WiC F/R 330 303 304 305 332 F/R W/R F/R O/C FIC O/C F/R F/R N/C F/R 321 322 323 324 325 326 327 334 335 336 337 338 339 309 N/R N/R N/R O/C 312 313 314 341](http://img.homeworklib.com/questions/cdaf9740-757c-11ea-aef5-8d648be664e6.png?x-oss-process=image/resize,w_560)
Homework Answers
Answer (1):
Working:
Create a column with column header 'Count' and Assign a value of 1 for all rows in this column.
Using pivot table we get:
Filtering the pivot table for values N/R, F/R, O/R and W/R we get:
Answer (2):
Working:
Using the pivot table (as in answer 1 above) filtering for F/C, N/C, O/C and W/C we get:
Add Answer to:
Problem 9-2 The following information applies to the questions displayed below] An air-conditioning repair department manager...
[The following information applies to the questions displayed below.] An air-conditioning repair department manager has compiled...
[The following information applies to the questions displayed below.] An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls for the previous week, as shown in the table. Job Number 301 302 303 304 305 306 307 308 309 310 311 312 313 314 Problem/ Customer Type N/C N/R N/R N/C F/R F/R N/C o/c F/R o/c w/c W/R N/R o/c Job Number 315 316 317 318 319 320 321 322 323 324 325...
An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls...
An air-conditioning repair department manager has compiled data
on the primary reason for 41 service calls for the previous week,
as shown in the table.
Job
Number
Problem/
Customer Type
Job
Number
Problem/
Customer Type
Job
Number
Problem/
Customer Type
301
F/R
315
F/C
329
O/C
302
O/R
316
O/C
330
N/R
303
N/C
317
W/C
331
N/R
304
N/R
318
N/R
332
W/R
305
W/C
319
O/C
333
O/R
306
N/R
320
F/R
334
O/C
307
F/R
321
F/R...
Required information [The following information applies to the questions displayed below.) An air-conditioning repair department manager...
Required information [The following information applies to the questions displayed below.) An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls for the previous week, as shown in the table. Job Problem/ Number Customer Type 301 F/c 302 F/R 303 o/C 304 o/c 305 W/C 306 W/R 307 o/R 308 N/R 309 F/C 310 N/R 311 o/c 312 F/R o/C W/C Job Problem/ Number Customer Type 315 N/C 316 N/R 317 N/R 318 N/C...
Problem 3-52 (LO 3-5) [The following information applies to the questions displayed below.) Tonya Jefferson (single),...
Problem 3-52 (LO 3-5) [The following information applies to the questions displayed below.) Tonya Jefferson (single), a sole proprietor, runs a successful lobbying business in Washington, DC. She doesn't sell many business assets, but she is planning on retiring and selling her historic townhouse, from which she runs her business, to buy a place somewhere sunny and warm. Tonya's townhouse is worth $1,000,000 and the land is worth another $1,000,000. The original basis in the townhouse was $600,000, and she...
Required information [The following information applies to the questions displayed below) Part 7 of 9 Brothers...
Required information [The following information applies to the questions displayed below) Part 7 of 9 Brothers Harry and Herman Hausyerday began operations of their machine shop (H & H Tool, Inc.) on January 1, 2016. The annual reporting period ends December 31. The trial balance on January 1, 2018, follows the amounts are rounded to thousands of dollars to simplify: DO Debit Credit Account Titles Cash Accounts Receivable Supplies Land Equipment Accumulated Depreciation Software Accumulated Artiration Accounts Payable Notes Payable...
Required information Problem 3-52 (LO 3-5) [The following information applies to the questions displayed below.) Tonya...
Required information Problem 3-52 (LO 3-5) [The following information applies to the questions displayed below.) Tonya Jefferson (single), a sole proprietor, runs a successful lobbying business in Washington, DC. She doesn't sell many business assets, but she is planning on retiring and selling her historic townhouse, from which she runs her business, to buy a place somewhere sunny and warm. Tonya's townhouse is worth $1,000,000 and the land is worth another $1,000,000. The original basis in the townhouse was $600,000,...
Served Required information [The following information applies to the questions displayed below) The December 31, 2021,...
Served Required information [The following information applies to the questions displayed below) The December 31, 2021, unadjusted trial balance for Demon Deacons Corporation is presented below. Credit Accounts Cash Accounts Receivable Prepaid Rent Supplies Deferred Revenge Common Stock Retained Earnings Service Revenue Salaries Expense Debit $ 8,500 13,500 5,400 2,500 $1,500 10,000 4.500 41,400 21,500 $57.400 $57,400 At year-end, the following additional information is available: 1. The balance of Prepaid Rent, $5,400, represents payment on October 31, 2021, for rent...
Required information The following information applies to the questions displayed below) The following data is provided...
Required information The following information applies to the questions displayed below) The following data is provided for Garcon Company and Pepper Company, Garcon Company Beginning finished goods inventory $ 14,000 Beginning work in process inventory 16,700 Beginning raw materials inventory (direct materials) 9,500 Rental cost on factory equipment 27,500 Direct labor 24,200 Ending finished goods inventory 21,200 Ending work in process inventory 24,700 Ending raw materials inventory 5,500 Factory utilities 13,350 Factory supplies used indirect materials) 10,000 General and administrative...
2 of 2 Required information (The following information applies to the questions displayed below) Golden Corp.'s...
2 of 2 Required information (The following information applies to the questions displayed below) Golden Corp.'s current year income statement, comparative balance sheets, and additional information follow. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from customers, (3) all purchases of inventory are on credit, (4) all debits to Accounts Payable reflect cash payments for inventory. (5) Other Expenses are all cash expenses, and (6) any change in Income Taxes...
(The following information applies to the questions displayed below The following data were selected from the...
(The following information applies to the questions displayed below The following data were selected from the records of Sykes Company for the year ended December 31 2014. Balances January 1, 2014 Accounts receivable (various customers) Allowance for doubtful accounts $ 116,000 7,000 In the following order, except for cash sales, the company sold merchandise and made collections on credit terms 4/10, n/30 (assume a unit sales price of $800 in all transactions and use the gross method to record sales...
[The following information applies to the questions displayed below.] An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls for the previous week, as shown in the table. Job Number 301 302 303 304 305 306 307 308 309 310 311 312 313 314 Problem/ Customer Type N/C N/R N/R N/C F/R F/R N/C o/c F/R o/c w/c W/R N/R o/c Job Number 315 316 317 318 319 320 321 322 323 324 325...
An air-conditioning repair department manager has compiled data
on the primary reason for 41 service calls for the previous week,
as shown in the table.
Job
Number
Problem/
Customer Type
Job
Number
Problem/
Customer Type
Job
Number
Problem/
Customer Type
301
F/R
315
F/C
329
O/C
302
O/R
316
O/C
330
N/R
303
N/C
317
W/C
331
N/R
304
N/R
318
N/R
332
W/R
305
W/C
319
O/C
333
O/R
306
N/R
320
F/R
334
O/C
307
F/R
321
F/R...
Required information [The following information applies to the questions displayed below.) An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls for the previous week, as shown in the table. Job Problem/ Number Customer Type 301 F/c 302 F/R 303 o/C 304 o/c 305 W/C 306 W/R 307 o/R 308 N/R 309 F/C 310 N/R 311 o/c 312 F/R o/C W/C Job Problem/ Number Customer Type 315 N/C 316 N/R 317 N/R 318 N/C...
Problem 3-52 (LO 3-5) [The following information applies to the questions displayed below.) Tonya Jefferson (single), a sole proprietor, runs a successful lobbying business in Washington, DC. She doesn't sell many business assets, but she is planning on retiring and selling her historic townhouse, from which she runs her business, to buy a place somewhere sunny and warm. Tonya's townhouse is worth $1,000,000 and the land is worth another $1,000,000. The original basis in the townhouse was $600,000, and she...
Required information [The following information applies to the questions displayed below) Part 7 of 9 Brothers Harry and Herman Hausyerday began operations of their machine shop (H & H Tool, Inc.) on January 1, 2016. The annual reporting period ends December 31. The trial balance on January 1, 2018, follows the amounts are rounded to thousands of dollars to simplify: DO Debit Credit Account Titles Cash Accounts Receivable Supplies Land Equipment Accumulated Depreciation Software Accumulated Artiration Accounts Payable Notes Payable...
Required information Problem 3-52 (LO 3-5) [The following information applies to the questions displayed below.) Tonya Jefferson (single), a sole proprietor, runs a successful lobbying business in Washington, DC. She doesn't sell many business assets, but she is planning on retiring and selling her historic townhouse, from which she runs her business, to buy a place somewhere sunny and warm. Tonya's townhouse is worth $1,000,000 and the land is worth another $1,000,000. The original basis in the townhouse was $600,000,...
Served Required information [The following information applies to the questions displayed below) The December 31, 2021, unadjusted trial balance for Demon Deacons Corporation is presented below. Credit Accounts Cash Accounts Receivable Prepaid Rent Supplies Deferred Revenge Common Stock Retained Earnings Service Revenue Salaries Expense Debit $ 8,500 13,500 5,400 2,500 $1,500 10,000 4.500 41,400 21,500 $57.400 $57,400 At year-end, the following additional information is available: 1. The balance of Prepaid Rent, $5,400, represents payment on October 31, 2021, for rent...
Required information The following information applies to the questions displayed below) The following data is provided for Garcon Company and Pepper Company, Garcon Company Beginning finished goods inventory $ 14,000 Beginning work in process inventory 16,700 Beginning raw materials inventory (direct materials) 9,500 Rental cost on factory equipment 27,500 Direct labor 24,200 Ending finished goods inventory 21,200 Ending work in process inventory 24,700 Ending raw materials inventory 5,500 Factory utilities 13,350 Factory supplies used indirect materials) 10,000 General and administrative...
2 of 2 Required information (The following information applies to the questions displayed below) Golden Corp.'s current year income statement, comparative balance sheets, and additional information follow. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from customers, (3) all purchases of inventory are on credit, (4) all debits to Accounts Payable reflect cash payments for inventory. (5) Other Expenses are all cash expenses, and (6) any change in Income Taxes...
(The following information applies to the questions displayed below The following data were selected from the records of Sykes Company for the year ended December 31 2014. Balances January 1, 2014 Accounts receivable (various customers) Allowance for doubtful accounts $ 116,000 7,000 In the following order, except for cash sales, the company sold merchandise and made collections on credit terms 4/10, n/30 (assume a unit sales price of $800 in all transactions and use the gross method to record sales...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago