Questions
Thome and Crede, CPAs, are preparing their service revenue (sales) budget for the coming year (2020)....

Thome and Crede, CPAs, are preparing their service revenue (sales) budget for the coming year (2020). The practice is divided into three departments: auditing, tax, and consulting. Billable hours for each department, by quarter, are provided below.

Department

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Auditing 2,530 1,850 2,320 2,740
Tax 3,250 2,680 2,140 2,690
Consulting 1,770 1,770 1,770 1,770


Average hourly billing rates are auditing $83, tax $94, and consulting $102.

Prepare the service revenue (sales) budget for 2020 by listing the departments and showing for each quarter and the year in total, billable hours, billable rate, and total revenue.

THOME AND CREDE, CPAs
Service Revenue Budget

choose the accounting period                                                          For the Year Ending December 31, 2020December 31, 2020For the Quarter Ending December 31, 2020

Quarter 1

Quarter 2

Dept.

Billable Hours

Billable Rate

Total Rev.

Billable Hours

Billable Rate

Total Rev.

Auditing

enter a number of hours

$enter a dollar amount

$enter a dollar amount

enter a number of hours

$enter a dollar amount

$enter a dollar amount

Tax

enter a number of hours

enter a dollar amount

enter a dollar amount

enter a number of hours

enter a dollar amount

enter a dollar amount

Consulting

enter a number of hours enter a dollar amount enter a dollar amount enter a number of hours enter a dollar amount enter a dollar amount
      Totals $enter a total dollar amount $enter a total dollar amount

THOME AND CREDE, CPAs
Service Revenue Budget

choose the accounting period                                                          For the Quarter Ending December 31, 2020December 31, 2020For the Year Ending December 31, 2020

Quarter 3

Quarter 4

Dept.

Billable Hours

Billable Rate

Total Rev.

Billable Hours

Billable Rate

Total Rev.

Auditing

enter a number of hours

$enter a dollar amount

$enter a dollar amount

enter a number of hours

$enter a dollar amount

$enter a dollar amount

Tax

enter a number of hours

enter a dollar amount

enter a dollar amount

enter a number of hours

enter a dollar amount

enter a dollar amount

Consulting enter a number of hours enter a dollar amount enter a dollar amount enter a number of hours enter a dollar amount enter a dollar amount
      Totals

$enter a total dollar amount

$enter a total dollar amount

THOME AND CREDE, CPAs
Service Revenue Budget

choose the accounting period                                                          For the Year Ending December 31, 2020December 31, 2020For the Quarter Ending December 31, 2020

Year

Dept.

Billable Hours

Billable Rate

Total Rev.

Auditing

enter a number of hours

$enter a dollar amount

$enter a dollar amount

Tax

enter a number of hours

enter a dollar amount

enter a dollar amount

Consulting

enter a number of hours enter a dollar amount enter a dollar amount
      Totals $enter a total dollar amount

In: Accounting

Box A contains 2 quarters, box B contains 1 quarter and 1 dime. A box is...

Box A contains 2 quarters, box B contains 1 quarter and 1 dime. A box is picked at random. From this box a coin is picked at random and it is a quarter. What is the probabilitythat the box picked was box B?

In: Statistics and Probability

Taylor Rule. Suppose the Quarter 1 2020 federal funds rate was 0.25%. If the output gap...

  1. Taylor Rule. Suppose the Quarter 1 2020 federal funds rate was 0.25%. If the output gap is -7% and the inflation gap is -5%, according to the Taylor Rule, what is the Fed’s target rate for Quarter 2 of 2020?

In: Economics

Question1 A market researcher wants to study TV viewing habits of residents in a particular area....

Question1

A market researcher wants to study TV viewing habits of residents in a particular area. A random sample 0f 70 respondents is selected. The results are as follows

Viewing time per week Mean=14 hours, S=3.8 hours

50 respondents watch the evening news on at least three week nights

(a)      Construct a 90% confidence interval estimate for the mean amount of TV watched per week.

(b)      Construct a 95% CI estimate of population proportion who watches evening news on at least three week nights.

Question 2

Following data gives the amount that a sample of 10 customers spent for lunch ($) at a fast food restaurant:

$8.50, $7, $5.80,  $9, $5.60,  $7.80,  $6.50, $5.40,  $7.50,  $5.50

Construct a 95% confidence interval estimate for the population mean amount spent on lunch at the fast food restaurant.

Question 3

A cell phone provider has the business objective of wanting to estimate the proportion of subscribers who would upgrade to a new cell phone with improved features if it were made available at a substantially reduced cost. Data are collected from a random sample of 500 subscribers. The results indicated that 135 of the subscribers would upgrade to a new cell phone at a reduced cost. Construct a 95% confidence interval estimate for the population proportion of subscribers that would upgrade to a new cell phone at a reduced cost.

Question 4

You are the manager of a restaurant for a fast food. Last month the mean waiting time at the drive through window for branches in your region was 3.8 minutes. You select a random sample of 49 orders. The sample mean waiting time is 3.57 minutes, with a sample standard deviation of 0.8 minutes. At the .05 level of significance is there evidence that population mean waiting time is different from 3.8 minutes?

In: Math

Superior Company provided the following data for the year ended December 31 (all raw materials are...

Superior Company provided the following data for the year ended December 31 (all raw materials are used in production as direct materials):

Selling expenses $ 215,000
Purchases of raw materials $ 267,000
Direct labor ?
Administrative expenses $ 150,000
Manufacturing overhead applied to work in process $ 367,000
Actual manufacturing overhead cost $ 351,000

Inventory balances at the beginning and end of the year were as follows:

Beginning of Year End of Year
Raw materials $ 54,000 $ 33,000
Work in process ? $ 32,000
Finished goods $ 39,000 ?

The total manufacturing costs for the year were $675,000; the cost of goods available for sale totaled $725,000; the unadjusted cost of goods sold totaled $662,000; and the net operating income was $32,000. The company’s underapplied or overapplied overhead is closed to Cost of Goods Sold.

Required:

Prepare schedules of cost of goods manufactured and cost of goods sold and an income statement. (Hint: Prepare the income statement and schedule of cost of goods sold first followed by the schedule of cost of goods manufactured.)

Prepare an income statement for the year.

Superior Company
Income Statement
Sales
Cost of goods sold
Gross margin 0
Selling and administrative expenses:
Selling expenses
Administrative expenses
0
Net operating income

Prepare a schedule of cost of goods sold.

Superior Company
Schedule of Cost of Goods Sold
Adjusted cost of goods sold

Prepare a schedule of cost of goods manufactured.

Superior Company
Schedule of Cost Goods Manufactured
Direct materials:
Total raw materials available
Raw materials used in production
Total manufacturing costs
0
Cost of goods manufactured

In: Accounting

Sara Wald died, leaving to her husband Benno an insurance policy contract that provides that the...

Sara Wald died, leaving to her husband Benno an insurance policy contract that provides that the beneficiary (Benno) can choose any one of the following options: a) 55,000 immediate cash b) 4,000 every 3 months payable at the end of each quarter for 5 years c) 18,000 immediate cash and 1,800 every 3 months for 10 years, payable at the beginning of each 3-month period d) 4,000 every 3 months for 3 years and 1,500 each quarter for the following 25 quarters, all payments payable at the end of each quarter Using the interest rate of 2.5 per quarter, compounded quarterly, which option would you recommend that Benno exercise? Show your computations!

In: Accounting

Consider the following quarterly time series. Quarter Year 1 Year 2 Year 3 1 923 1,112...

Consider the following quarterly time series.

Quarter

Year 1

Year 2

Year 3

1

923

1,112

1,243

2

1,056

1,156

1,301

3

1,124

1,124

1,254

4

992

1,078

1,198

a. Construct a time series plot. What type of pattern exists in the data?


b. Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data.

Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise.

c. Compute the quarterly forecasts for next year based on the model developed in part (b).

(that is for all the four quarters next year)

In: Statistics and Probability

(Analysis of Alternatives) Julia Baker died, leaving to her husband Brent an insurance policy contract that...

(Analysis of Alternatives) Julia Baker died, leaving to her husband
Brent an insurance policy contract that provides that the beneficiary (Brent) can
choose any one of the following four options
a. €55,000 immediate cash.
b. €4,000 every 3 months payable at the end of each quarter for 5 years.
c. €18,000 immediate cash and $1,800 every 3 months for 10 years, payable at
the beginning of each 3-month period.
d. €4,000 every 3 months for 3 years and $1,500 each quarter for the following 25
quarters, all payments payable at the end of each quarter.

Instructions
If money is worth 2½% per quarter, compounded quarterly, which option would you
recommend that Brent exercise?

In: Accounting

4. Consider the following time series: Quarter Year 1 Year 2 Year 3 1 80 74...

4. Consider the following time series:

Quarter Year 1 Year 2 Year 3
1 80 74 65
2 69 61 51
3 48 50 43
4 68 71 82

a. Construct a time-series plot. What type of pattern exists in the data? Is there an indication of a seasonal pattern? (10 points)

b. Use multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if quarter 1, 0 else; Qtr2 = 1 if quarter 2, 0 else; Qtr3 = 1 if quarter 3, 0 else. (20 points)

c. Compute the quarterly forecasts for next year. (10 points)

In: Statistics and Probability

Some Company Cash Budget Given Information For theYear Ended December 31, 2020 Some Company has asked...

Some Company
Cash Budget Given Information
For theYear Ended December 31, 2020
Some Company has asked you to prepare a cash budget for the year 2020 using the following information:
Projected cash balance at January 1 50,000
Cash balance desired December 31 65,000
Projected sales by quarter (collected 70% in the quarter of sale and 20% in the quarter after sale, with the remaining 10% uncollectible):
Accounts recievable from 4th quarter 2019 (of which 20,000 is collectible and 10,000 is uncollectible) 30,000
     Sales Quarter 1 145,000
     Sales Quarter 2 250,000
     Sales Quarter 3 160,000
     Sales Quarter 4 240,000
Projected 2020 sale of excess land:
     Original cost 40,000
     Accumulated depreciation 0
     Book value 40,000
     Cash expected to be received 75,000
     Gain on sale expected 35,000
Expected federal income tax refund from 2020 correction of error on 2018 tax return 14,000
Projected 2020 transactions, to be paid in 2020, unless otherwise noted:
Purchases of merchandise inventory 410,000
Operating expenses:
     Sales and office salaries 121,000
     Office utilities 9,000
     Insurance expense (taken from Prepaid Insurance) 6,500
     Depreciation of building and equipment 55,000
     Amortization of copyright 15,000
Purchases of office equipment 20,000
Cash dividend (declared in December 2020; to be paid in January 2021 28,000
The company has a line of credit at the bank which allows borrowing up to $500,000. Currently, the company has loans of $250,000 taken out two years ago at 10% interest. Interest is due quarterly on March 31, June 30, September 30 and December 31.

The amounts are listed in the above problem; "Some Company has asked you to prepare a cash budget for the year 2020 using the following information"

In: Accounting