Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

begin{tabular}{|c|c|c|c|c|} hline multicolumn{5}{|c|}{ Mansfield Information Systems } hline multicolumn{5}{|c|}{ Budgeted Income Statement } hline & multicolumn{2}{|c|}{ November } & multicolumn{2}{|c|}{ December }

image text in transcribedimage text in transcribed \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Mansfield Information Systems } \\ \hline \multicolumn{5}{|c|}{ Budgeted Income Statement } \\ \hline & \multicolumn{2}{|c|}{ November } & \multicolumn{2}{|c|}{ December } \\ \hline \multicolumn{5}{|l|}{ Revenues: } \\ \hline \multicolumn{5}{|l|}{ Managers } \\ \hline \multicolumn{5}{|l|}{ Staff } \\ \hline Total revenue & $ & 0 & $ & 0 \\ \hline \multicolumn{5}{|l|}{ Expenses: } \\ \hline \multicolumn{5}{|l|}{ Manager pay } \\ \hline \multicolumn{5}{|l|}{ Staff pay } \\ \hline Total compensation & $ & 0 & $ & 0 \\ \hline \multicolumn{5}{|c|}{ Selling, general, and administrative } \\ \hline \multicolumn{5}{|l|}{ Depreciation } \\ \hline \multicolumn{5}{|l|}{ Marketing } \\ \hline Total expenses & $ & 0 & $ & 0 \\ \hline Income (loss) & $ & 0 & $ & 0 \\ \hline \end{tabular} 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 $780 per hour and staff at a rate of $390 per hour. Managers are paid $290 per hour worked (including nonbillable time), and staff are paid $170 per hour. The current plan calls for managers to bill 880 hours in November and 700 hours in December. Staff are expected to bill 6,260 hours in November and 4,960 hours in December. Managers will work a total of 1,280 hours in both months, and staff will work a total of 7,960 hours in November and 6,800 hours December. Other monthly costs (all fixed) are $754,000 selling, general, and administrative, $154,000 in depreciation, and $258,000 in marketing. Required: Prepare a budgeted income statement for Mansfield Information Systems for November and December (separately)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Accounting Course 2

Authors: Claudia B. Gilbertson

9th Edition

053844827X, 9780538448277

More Books

Students also viewed these Accounting questions

Question

What are the advantages of licensing as described in the case?

Answered: 1 week ago