Homework Help is Here – Start Your Trial Now!
Business
Accounting
Mansfield Information Systems (MIS) is an IT support firm. Managers and staff are billed to clients on an hourly basis. The senior administrative staff does not directly provide client support. Because of the clientele of MIS, there is significant fluctuation from month to month. Managers are billed to clients at a rate of $870 per hour and staff at a rate of $435 per hour. Managers are paid $380 per hour worked (including nonbillable time), and staff are paid $215 per hour. The current plan calls for managers to bill 970 hours in November and 790 hours in December. Staff are expected to bill 6,440 hours in November and 5,140 hours in December. Managers will work a total of 1,460 hours in both months, and staff will work a total of 8,140 hours in November and 7,700 hours in December. Other monthly costs (all fixed) are $758,500 selling, general, and administrative, $158,500 in depreciation, and $267,000 in marketing. Required: Prepare a budgeted income statement for Mansfield Information Systems for November and December (separately). Revenues: Managers Staff Total revenue Expenses Manager pay Staff pay Total compensation Selling, general, and administrative Depreciation Marketing Total expenses Mansfield Information Systems Budgeted Income Statement Income (loss) November S S December 0$ 0$ 0$ 0 $ 0 0 0

Mansfield Information Systems (MIS) is an IT support firm. Managers and staff are billed to clients on an hourly basis. The senior administrative staff does not directly provide client support. Because of the clientele of MIS, there is significant fluctuation from month to month. Managers are billed to clients at a rate of $870 per hour and staff at a rate of $435 per hour. Managers are paid $380 per hour worked (including nonbillable time), and staff are paid $215 per hour. The current plan calls for managers to bill 970 hours in November and 790 hours in December. Staff are expected to bill 6,440 hours in November and 5,140 hours in December. Managers will work a total of 1,460 hours in both months, and staff will work a total of 8,140 hours in November and 7,700 hours in December. Other monthly costs (all fixed) are $758,500 selling, general, and administrative, $158,500 in depreciation, and $267,000 in marketing. Required: Prepare a budgeted income statement for Mansfield Information Systems for November and December (separately). Revenues: Managers Staff Total revenue Expenses Manager pay Staff pay Total compensation Selling, general, and administrative Depreciation Marketing Total expenses Mansfield Information Systems Budgeted Income Statement Income (loss) November S S December 0$ 0$ 0$ 0 $ 0 0 0

Principles of Cost Accounting
Principles of Cost Accounting
17th Edition
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Edward J. Vanderbeck, Maria R. Mitchell
Chapter3: Accounting For Labor
Section: Chapter Questions
Problem 2MC: Huron Manufacturing Co. uses a job order cost system to cost its products. It recently signed a new...
See similar textbooks
icon
Related questions
Question

help me 

Mansfield Information Systems (MIS) is an IT support firm. Managers and staff are billed to clients on an hourly basis. The senior administrative staff does not directly provide client support. Because of the clientele of MIS, there is significant fluctuation from month to month. Managers are billed to clients at a rate of $870 per hour and staff at a rate of $435 per hour. Managers are paid $380 per hour worked (including nonbillable time), and staff are paid $215 per hour. The current plan calls for managers to bill 970 hours in November and 790 hours in December. Staff are expected to bill 6,440 hours in November and 5,140 hours in December. Managers will work a total of 1,460 hours in both months, and staff will work a total of 8,140 hours in November and 7,700 hours in December. Other monthly costs (all fixed) are $758,500 selling, general, and administrative, $158,500 in depreciation, and $267,000 in marketing. Required: Prepare a budgeted income statement for Mansfield Information Systems for November and December (separately). Revenues: Managers Staff Total revenue Expenses Manager pay Staff pay Total compensation Selling, general, and administrative Depreciation Marketing Total expenses Mansfield Information Systems Budgeted Ingame Statement i Income (loss) November $ $ S S December 0$ 0 $ 0 $ 0 $ 0 0 0 0
Transcribed Image Text:Mansfield Information Systems (MIS) is an IT support firm. Managers and staff are billed to clients on an hourly basis. The senior administrative staff does not directly provide client support. Because of the clientele of MIS, there is significant fluctuation from month to month. Managers are billed to clients at a rate of $870 per hour and staff at a rate of $435 per hour. Managers are paid $380 per hour worked (including nonbillable time), and staff are paid $215 per hour. The current plan calls for managers to bill 970 hours in November and 790 hours in December. Staff are expected to bill 6,440 hours in November and 5,140 hours in December. Managers will work a total of 1,460 hours in both months, and staff will work a total of 8,140 hours in November and 7,700 hours in December. Other monthly costs (all fixed) are $758,500 selling, general, and administrative, $158,500 in depreciation, and $267,000 in marketing. Required: Prepare a budgeted income statement for Mansfield Information Systems for November and December (separately). Revenues: Managers Staff Total revenue Expenses Manager pay Staff pay Total compensation Selling, general, and administrative Depreciation Marketing Total expenses Mansfield Information Systems Budgeted Ingame Statement i Income (loss) November $ $ S S December 0$ 0 $ 0 $ 0 $ 0 0 0 0
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Payroll Procedures
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781305084087
Author:
Cathy J. Scott
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
PAYROLL ACCT., 2019 ED.(LL)-TEXT
PAYROLL ACCT., 2019 ED.(LL)-TEXT
Accounting
ISBN:
9781337619783
Author:
BIEG
Publisher:
CENGAGE L
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS