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 |
||||||
|---|---|---|---|---|---|---|
|
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 |
||||||
|---|---|---|---|---|---|---|
|
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 |
|||
|---|---|---|---|
|
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 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
In: Economics
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 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.
|
|||||||||||||||||||||||||||||||||
Prepare a schedule of cost of goods sold.
|
||||||||||||||||||
Prepare a schedule of cost of goods manufactured.
|
||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
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 |
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 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 | 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 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