Service department charges and activity basesMiddler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of servicecategories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October.Budgeted ActivityCCS Service CategoryActivity BaseBudgeted CostBase QuantityHelp deskNumber of calls$170,0003,400Network centerNumber of devices monitored824,00010,300Electronic mailNumber of user accounts88,2009,800Number of handheld devicesHandheld Technology support118,3009,100issuedOne of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector:• The sector has 4,800 employees, of whom 35% are office employees.• Almost all office employees (98%) have a computer on the network.• One hundred percent of the employees with a computer also have an e-mail account.• The average number of help desk calls for October was 1.1 calls per individual with a computer.• There are 550 additional printers, servers, and peripherals on the network beyond the personal computers.• All the nonoffice employees have been issued a handheld device.This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.XOpen spreadsheeta. Determine the service charge rate for the four CCS service categories for October. Round your answers to the nearest dollar.CCS Service CategoryService Charge RateHelp desk50 v Per callNetwork center80 V Per device monitoredElectronic mailV Per user or e-mail accountHandheld technology support$113 V Per device a. Determine the service charge rate for the four CCS service categories for October. Round your answers to the nearest dollar.CCS Service CategoryService Charge RateHelp desk50 V Per callNetwork center$V Per device monitored80Electronic mailV Per user or e-mail account9Handheld technology supportV Per device13b. Determine the charges to the COMM sector for the four CCS service categories for October. Round your answers to the nearest dollar.October charges to the COMM sector:Help deskNetwork centerElectronic mailHandheld technology support

Activity-based costing: Activity-based costing is commonly known as ABC. It is a costing method that…

Answered: b. Determine the charges to the COMM…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Archer Electronics Company's actual sales and purchases for April and May are shown here along with forecast sales and purchases for June through September: April (actual) May (actual) June (forecast) July (forecast) August (forecast) September (forecast) Sales $ 370,000 350,000 325,000 325,000 340,000 380,000 Purchases $ 155,000 145,000 145,000 205,000 225,000 220,000 The company makes 20 percent of its sales for cash and 80 percent on credit. Of the credit sales, 50 percent are collected in the month after the sale and 50 percent are collected two months later. Archer pays for 20 percent of its purchases in the month after purchase and 80 percent two months after. Labor expense equals 15 percent of the current month's sales. Overhead expense equals $12,500 per month. Interest payments of $32,500 are due in June and September. A cash dividend of $52,500 is scheduled to be paid in June. Tax payments of $25,500 are due in June and September. There is a scheduled capital outlay of…
Kathy Hansen has a revolving credit account. The finance charge is calculated on the previous month’s balance, and the annual percentage rate is 27%. Complete the account activity table for Kathy. (round your answer to the nearest cent.)
A company purchases supplies on account. Their supplier requires that 75% of purchases on account be paid in the month of the purchase. Purchases of supplies on account were as follows: June: $300 July: $350 August: $400 Assuming the company paid only what the supplier required each month, how much would the company have paid their supplier in July? Type your answer... I
For the credit card account, assume one month between billing dates (with the appropriate number of days) and interest of 1.6% per month on the average daily balance. Find (a) the average daily balance, (b) the monthly finance charge, and (c) the account balance for the next billing. Previous Balance: $754.46 July 8 Billing Date Payment July 15 July 25 Lunch August 2 Concert tickets $300 $53.79 $76.67 (a) The average daily balance is $. (Round to the nearest cent as needed.) (b) The finance charge is $. (Round to the nearest cent as needed.) (c) The account balance for the next billing is $. (Round to the nearest cent as needed.)
Suppose that your credit card activity for December looked like this: Date Activity December 5 $234 purchase December 11 $357 purchase December 15 $312 purchase December 21 $494 purchase December 25 $131 purchase What was your average daily balance for December? Round your answer to the nearest dollar
Please assist with question 3
Tutorial Exercise On August 10, a credit card account had a balance of $320. A purchase of $51 was made on August 15, and $158 was charged on August 27. A payment of $78 was made on August 15. The interest on the average daily balance is 1.14% per month. Find the finance charge on the September 10 bill. Part 1 of 3 Based on the data provided in the problem, complete the following table. Date Payment/Purchase Balance Days Balance x Days Aug 10-14 $320 $1600 Aug 15 51 $ $0 Aug 15-26 -78 $293 12 $3516 Aug 27-Sept 9 158 $451 14 Total Submit Skip (you cannot come back),
A plumbing supply company has a discount policy which states that, if a customer pays within 15 days of the invoice, the customer can take a 3% discount; otherwise, the full amount is due in 60 days from the date of the invoice. Which of the following notations are used in business to reflect this discount? A. 3/15,n/60 B. 3/60,15/n C. 15/3,60/n D. 3/n,15/60
Calculate the portion of the prepaid subscription expenses that should be expensed during the month of April 2022 and the balance of the Prepaid Account as of April 30 considering the impact of the items in the table below. Subscriptions Adjust on a monthly basis, not daily Vendor MarketU InternationalAds Expense Account Posting Marketing - Sales & Marketing Software Marketing - Sales & Marketing Software April expense = $500; April 30 Prepaid Subscription = $3,500 April expense = $1,000; April 30 Prepaid Subscription = $11,000 April expense = $1,500; April 30 Prepaid Subscription = $4,500 April expense = $1,500; April 30 Prepaid Subscription = $10,500 Service Period Start End Amount Nov-22 $6,000 $6,000 $12,000 Dec-21 Dec-21 May-22 Q Q C Q Q
A credit card bill for $655 was due on April 14. Purchases of $155.56 were made on April 19. The amount $22.45 was charged on April 21 and $203.36 was charged on April 28. A payment of $500 was made on April 25. Find the average daily balance (in dollars) if the next due date is May 14. (Round your answer to the nearest cent.) $?
For the credit card account, assume one month between billing dates (with the appropriate number of days) and interest of 1.4% per month on the average daily balance Find (a) the average daily balance. (b) the monthly finance charge, and (c) the account balance for the next billing. Previous Balance: $455.28 January 12 Billing Date January 15 Returns January 21 Clothes January 25 Bus tickets February 4 Payment February 7 Flowers $102.86 $117.89 $89.76 $125 $66.36
Suppose the charge account of Strong's Mailing Service at the local supply store had a 1.8% interest rate per month on the average daily balance. Find the average daily balance if Strong's had an unpaid balance on March 1 of $196.90, a payment of $40 posted on March 8, and a purchase of $25.20 posted on March 16. The billing cycle ends March 31. The average daily balance is $ (Type an integer or decimal rounded to the nearest hundredth as needed.)

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS

b. Determine the charges to the COMM sector for the four cCS service categories for October. Round your answers to the nearest dollar. October charges to the COMM sector: Help desk Network center