Questions
Month Hospital Overhead Cost Nursing Hrs # of Patient Days Overhead Cost Per Nursing Hrs Overhead...

Month Hospital Overhead Cost Nursing Hrs # of Patient Days Overhead Cost Per Nursing Hrs Overhead cost Per Patient Day
July 965,000 51,000 8,000 18.92 120.63
August 1,000,000 53,000 9,000 18.86 111.11
September 830,000 38,000 8,750 21.84 94.86
October 925,000 43,000 7,000 21.51 132.14
November 1,100,000 65,000 12,000 16.92 91.67
December 900,000 42,000 7,900 21.42 113.92

The hospital ran a regression analysis using nursing hours as the cost driver to predict total hospital overhead costs. The regression analysis produced the following data:

Intercept: 346245

Slope: 12.81796

RSQ: 0.909311

A.) Round the variable portion of the regression equation formula to two decimal places. Based on the regression equation formula, what will the predicted total hospital overhead costs be if 54,000 nursing hours are expended during a month?

The hospital then ran a regression analysis using number of patient days as cost driver. The regression analysis produced the following data:

Intercept: 559764

Slope: 47.970926

RSQ: 0.563496482

B.) Again, round the variable portion of the regression equation to two decimal places. If 9,500 patient days are predicted for a month, what is the total predicted hospital overhead costs using the regression equation?

C.) Which regression equation, the one using nursing hours as the cost driver or the one using patient days as the cost driver, produces the most accurate correlation (best explanation of) the predicted hospital overhead costs. How do you know that your answer is correct? In other words, justify your answer.

In: Accounting

Problem 3 (Textbook Reference: P4-4) – Activity-based costing versus traditional costing C&W Corporation manufactures travel clocks...

Problem 3 (Textbook Reference: P4-4) – Activity-based costing versus traditional costing C&W Corporation manufactures travel clocks and watches. Overhead costs are currently allocated using direct- labor hours, but the controller has recommended using an activity-based costing system based on the following data:

Activity =Production setup, Material handling and requisition, Packaging and shipping ,Total overhead

Cost Driver= Setups, Parts, Units shipped

Cost $ 100,000 $ 30,000 $ 60,000 $ 190,000

Activity Level= Travel Clocks20,24,80,000 Watches 30, 36, 120,000 Required (Traditional Method):

1. Using the traditional cost assignment method, calculate the plant-wide overhead rate using labor-hours as the allocation base. Assume labor-hours required to assemble each unit are 0.5 hours per travel clock and 1.0 hour per watch, and that 80,000 travel clocks and 120,000 watches were produced. Plant-wide overhead rate: $___________________per direct labor hour

2. Under the traditional cost assignment method using the plant-wide overhead rate, how much total overhead cost is allocated to the: Travel clocks: $________________ Watches: $________________ *** Problem 3 is continued on the next page *** Required (ABC Method):

3. Using the Activity-based Costing (ABC) assignment method, calculate the activity cost rates for the following activities: (a) Setup costs: $___________________per production run (b) Materials handling costs: $___________________per part (c) Packaging and shipping costs: $___________________per shipment

4. Using the Activity-based Costing (ABC) assignment method how much total overhead cost is allocated to the: Travel clocks: $________________ Watches: $________________

In: Accounting

Aaha Inc. produces premium protective automotive covers. The direct materials and direct labour standards for one...

Aaha Inc. produces premium protective automotive covers. The direct materials and direct labour standards for one car cover are as follows:

Standard Quantity
or Hours
Standard Price
or Rate
Standard Cost
  Direct materials 9.0 metres of cloth $ 10 per metre $ 90.00
  Direct labour 0 hours $ 20 per hour $ 7
  Variable overhead 0 hours $ 8 per hour $ 3
Budgeted fixed overhead cost is $17,400, and the normal production volume is 2,885 car covers. Overhead is applied on the basis of direct labour-hours.
     In September, the following activity was recorded:
24,300 metres of cloth were purchased at a cost of $10.50 per metre.
All of the purchased material was used to produce 2,700 car covers.
585 direct labour-hours were recorded at a total labour cost of $11,700.
Actual variable overhead cost was $5,600, and fixed overhead cost was $16,850.
Required:
1.

Compute all direct materials variances for September. (Indicate the effect of each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (i.e., zero variance).)


           

2.

Compute all direct labour cost variances for September. (Indicate the effect of each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (i.e., zero variance).)

  

      

3.

Calculate the total under- or overapplied overhead. Show all the variances calculated and indicate if each variance is favourable or unfavourable. (Indicate the effect of each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (i.e., zero variance). Do not round intermediate calculations and round "Fixed overhead volume variance and total variance" to 2 decimal places.)

In: Accounting

Garfield Company manufactures a popular brand of dog repellant known as DogGone It, which it sells...

Garfield Company manufactures a popular brand of dog repellant known as DogGone It, which it sells in gallon-size bottles with a spray attachment. The majority of Garfield’s business comes from orders placed by homeowners who are trying to keep neighborhood dogs out of their yards. Garfield’s operating information for the first six months of the year follows:

Month Number of Bottles Sold Operating Cost
January 1,060 $ 10,780
February 1,410 15,730
March 1,790 15,990
April 2,500 19,530
May 3,490 27,740
June 3,790 34,890

Required:
3.
Using the high-low method, calculate Garfield’s total fixed operating costs and variable operating cost per bottle. (Do not round your intermediate calculations. Round your variable cost per unit answer to 2 decimal places and fixed cost answer to the nearest whole number.)



4. Perform a least-squares regression analysis on Garfield’s data. (Use Microsoft Excel or a statistical package to find the coefficients using least-squares regression. Round your answers to 3 decimal places.)

Coefficients
Intercept
X Variable 1



5. Determine how well this regression analysis explains the data. (Round you regression statistics to three decimal places and your percentage answer to the nearest whole number.)

Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
From the regression output, number of bottles explains about % of the variability in Garfield’s total cost.


6. Using the regression output, create a linear cost equation (y = a + bx) for estimating Garfield’s operating costs. (Round your answers to 3 decimal places.)

Total Cost = + (Number of Bottles)

In: Accounting

1. The cost-allocation system Choice Hotels has been using allocates over 90 percent of overhead costs...

1. The cost-allocation system Choice Hotels has been using allocates over 90 percent of overhead costs to the Standard Guest Room and the Junior Suite, because over 90 percent of the models produced were one of these two models. How much overhead was allocated to each of the three models last year? Discuss why this might not be an accurate way to assign overhead costs to products.

2. How would the use of more than one cost pool improve Choice Hotels’ cost allocation?

3. Choice Hotels' production manager proposes allocating overhead by direct labor hours instead, since the different models require different amounts of labor. How much overhead would be allocated to each guest room (per unit and in total) using this method? Show all supporting calculations.

Choice Hotels Sales, Production, and Cost Information

Room Type Standard Guest Room Junior Suite Presidential Suite Type Cost
Volume 150 110 25 Depreciation $3,200,000
Price $140,000 $240,000 $1,050,000 Maintenance $1,800,000
Unit costs Purchasing $320,000
Direct materials $30,000 $92,000 $310,000 Inspection $850,000
Direct labor $54,000 $85,000 $640,000 Indirect materials $490,000
Manufacturing $30,000 $30,000 $30,000 Supervision $1,700,000
overhead Supplies $190,000
Total unit cost $114,000 $207,000 $980,000 Total manufacturing overhead cost $8,550,000
Unit gross profit $26,000 $33,000 $70,000 Note: Manufacturing overhead costs are fixed. They do not vary with the volume of manufacturing activity.
Direct labor hours 1,200 1,300 5,940
Rate per hour $45.00 $65.38 $107.74

In: Accounting

Job Cost Sheet Job Number Date  Initiated Item Date completed Direct Matarials Direct Labor Manufacturing Overhead Amount...

Job Cost Sheet
Job Number Date  Initiated
Item Date completed
Direct Matarials Direct Labor Manufacturing Overhead
Amount Hours Rate Amount Hours Rate Amount
Cost Summary
Direct Materials
Direct Labor
Manufacturing Overhead
Total Product Cost
Unit Product Cost

QUESTION 1

Step 1 You work for Thunderduck Custom Tables Inc. This is the first month of operations. The company designs and manufactures specialty tables. Each table is specially customized for the customer. This month, you have been asked to develop and manufacture two new tables for customers. You will design and build the tables. This is a no nail, no screw, and no glue manufacturing ( no indirect materials used). You will be keeping track of the costs incurred to manufacture the tables.
The cost of the direct materials that can be used to manufacture the table are as follows. These cost are on a per unit basis.
Table Top $ 1,900.00
Table Leg $     600.00
Drawer $     390.00
Assume a $25 per hour wage rate to the assembly employees.
The company uses a job order costing system and applies manufacturing overhead to jobs based on direct labor hours.   
The company estimates that there will be 12 direct labor hours worked during the month.
The estimated manufacturing overhead cost for the month is:
a. Factory supervisor salary per month $ 4,500.00
b. Rent for the factory per month $ 1,500.00
c. Depreciation of factory equipment per month $     600.00
Total Estimated manufacturing overhead $ 6,600.00
What is the predetermined manufacturing overhead rate?     
Step 2

The first order you received was to manufacture a table using a table top and four legs. This is your Job #1. Go to the "Job #1 Cost Sheet" tab. There are three assembly employees that spend 2 hours each to make the table. Here, you will calculate the cost of making the table by calculating the direct material, direct labor and applied overhead cost. Complete the job cost sheet by calculating the direct material, direct labor and manufacturing overhead applied that would be incurred for job #1.

Step 3 The customer that has ordered Job #2, wants a table that is the same as Job #1, but wants to also add a drawer to the table. There are three assembly employees that spend 3 hours each to make the table. On the "Job #2 Cost Sheet" tab you calculate the cost of making the table by calculating the direct material, direct labor and applied overhead cost.  
Step 4 Here you will find a list of transactions that must be recorded for the company for the month of December. On the "General Journal" tab, you will record all of these entries in proper journal entry format. The following is a list of transactions that need to be recorded for the company for activity in the month of December. Record these in the "General Journal" tab using the proper journal entry format. Please use the following accounts: Accounts Receivables, Raw materials, Work in process, Finished goods, Accumulated depreciation, Accounts payable, Salaries and wages payable, Sales revenue, Manufacturing overhead, Cost of goods sold, Salaries and wages expense, Advertising expenses, and Depreciation expense.
1-Dec Raw Materials purchased on account, $19,000.
5-Dec All Raw Materials needed for Job #1 were requisitioned from the material storage for use during the month. Assume all materials are direct.
10-Dec The following employee costs were incurred but not paid during the month:
Total cost incurred for direct labor for Job #1 Cost Sheet.
Salary for supervisor of the factory $5,000.
Administrative Salary $2,000.
15-Dec All Raw Materials needed for Job #2 were requisitioned from the material storage for use during the month. Assume all materials are direct.
16-Dec Rent for the month of December for the factory building incurred but not paid $1,500.
17-Dec Advertising costs incurred but not paid for the month was $1,200.
20-Dec Depreciation for the month of December was recorded on equipment was $750 ($150 for equipment used in the factory and the remainder for equipment used in selling and administrative activities).
22-Dec Manufacturing overhead cost was applied based on direct labor hours to Job #1 based on the POHR determined on the "Job Cost Sheet".  
26-Dec Job #1 was completed and transferred to Finished Goods during the month.
28-Dec The completed table from Job #1 was sold on account to the customer for $24,000 during the month. (Hint: Make sure to account for the cost of the table that was sold using the cost from the job cost sheet.)
31-Dec Direct labor cost incurred but not paid for three employees to start manufacturing Job #2. The employees only worked one hour each, three hours total during the month and they did not complete their work on the job.
31-Dec Manufacturing overhead cost was applied based on direct labor hours to Job #2 based on the POHR. Only three direct labor hours were worked on Job #2 during the month.
31-Dec Any underapplied or overapplied overhead for the month was closed out to Cost of Goods Sold.
Step 5 Post the journal entries that you recorded on the "General Journal" tab to the "T-accounts" tab. This is the company's first month of business, so there will not be any beginning balances. Compute the balance for each T-account after all of the entries have been posted.
Step 6 Prepare a Schedule of Cost of Goods Manufactured and a Schedule of Cost of Goods Sold on the "Schedule of COGM and COGS" tab for Job #1 and Job #2 that were worked on during the month by the company. Make sure to follow the format noted in your book (pg. 87). (Hint: This is the company's first month of operations and therefore the beginning balances will be zero.)
Step 7 Prepare an Income Statement for the month using the Traditional Format on the "Income Statement" tab.  
Step 8 Answer the additional questions below
Check Figure: Cost of Goods Manufactured= $7,750
What is the ending balance for raw materials?
What is the ending balance for work in process?
What is the ending balance for finished goods?
What is the actual manufacturing overhead cost incurred during December?
What is the total applied manufacturing overhead cost during December?
What is the unadjusted cost of goods sold?
Was the manufacturing overhead for the month of December overapplied/underapplied ?
What is the amount of Manufacturing overhead overapplied/underapplied?
What is the adjusted cost of goods sold?
What is gross margin?
What is net operating income?
What is the total prime cost for Job#1?
What is the total conversion cost for job #1?
What is the total product cost for job#1?
What was the period cost incurred for the month of December?  
What is the contribution margin for Job #1 (assume that all selling and administrative cost and all manufacturing overhead costs are fixed.)?

What would be the actual (not applied) total fixed manufacturing overhead cost incurred for the company for the month if the order in Job #1 is for five tables instead of one table assuming this cost is with in the relevant range?

General Journal
Date Description Debit Credit
Thunderduck Custom Tables, Inc. Thunderduck Custom Tables, Inc. Thunderduck Custom Tables, Inc.
Schedule of cost of goods manufactured Cost of goods sold   Income Statement
For the month Ended December 31, 20XX For the month Ended December 31, 20XX For the month Ended December 31, 20XX

In: Accounting

The Meyers CPA firm has the following overhead budget for theyear:OverheadIndirect materials $350000.00...

The Meyers CPA firm has the following overhead budget for the year:

Overhead

Indirect materials $350000.00

Indirect labor $1675000.00

Depreciation Bldg 303000.00

Depreciation Furniture 35000.00

Utilities 310000.00

Insurance 39000.00

Property Tax 53000.00

Other Expenses 145000.00

Total 2910000.00

The fir estimates direct labor cost to be $1818750.00. The firm uses direct labor cost driver to apply overhead to clients. During Jan the firms worked for many clients; data for two of them follow:

Gargus account

Direct Labor $3000.00

Feller Account

Direct Labor$9000

Compute the firm's predetermined overhead rate

Compute the amount of overhead to be charged to Gargus and Feller accountsusing the predetermined overhead rate

Compute total job cost for Gargus account and Feller account

In: Accounting

A firm is currently producing 80 units of output. At this level of output produced: its...

A firm is currently producing 80 units of output. At this level of output produced:

its average total cost is 100 (ATC = 100

) The market price per unit of output is 120

MR = 40 MC = 20

i. Is this firm making profits or losses? How much?

ii. Are they maximum profits? Why?

iii. If your answer to part ii was no, what does this firm have to do with maximize its profits?

A firm's total cost and marginal cost functions are

TC = 15Q^2+3Q - 25

MC = 30Q+3

Assuming that the market price is 183 and that the marginal revenue (MR) is also 183 ( it is constant at all output levels); how much output will this firm sell (produce) to maximize profits? What will be maximum profits for this firm?

In: Economics

Manufacturing overhead $500,000 Selling and administrative overhead $300,000 Assembling Units Processing Orders Supporting Customers Other Manufacturing...

Manufacturing overhead $500,000
Selling and administrative overhead $300,000
Assembling Units Processing Orders Supporting Customers Other
Manufacturing overhead 50% 35% 5% 10%
Selling and administrative overhead 10% 45% 25% 20%
Total activity 1,000 250 100
units orders customers
OfficeMart orders:
Customers 1 customer
Orders 4 orders
Number of filing cabinets ordered in total 80 units
Selling price $595
Direct materials $180
Direct labor $50
Compute the overhead cost attributable to the OfficeMart orders
Activity Cost Pools Activity Rate Activity ABC Cost
Assembling units ? per unit ? units ?
Processing orders ? per order ? orders ?
Supporting customers ? per customer ? customer ?

In: Accounting

(a) Luis Mahla purchases a Porsche Boxster for $49,700 and finances the entire amount at an...

(a) Luis Mahla purchases a Porsche Boxster for $49,700 and finances the entire amount at an annual interest rate of 6.3% for 8 years. Find the monthly payment. Assume the sales tax is 6% of the purchase price and the license fee is 1% of the purchase price. (Round your answer to the nearest cent.)

(b) After becoming a commercial pilot, Lorna Kao decides to purchase a Cessna 182 for $64,975. Assuming the sales tax is 4.9% of the purchase price, find each of the following.

(1) What is the total cost, including sales tax?
(2) If Lorna makes a down payment of 18% of the total cost, find the down payment.
(3) Assuming Lorna finances the remaining cost at an annual interest rate of 7.15% for 10 years, find the monthly payment.

In: Advanced Math