Question

In: Accounting

Following the instructions on the Data tab, complete the spreadsheet for your Chief Financial Officer. Estimates...

Following the instructions on the Data tab, complete the spreadsheet for your Chief Financial Officer.

Estimates at the beginning of the year Assembly Production Total
Manufacturing Overhead Costs $       480,000 $            528,000 $          108,000
Direct Labor-hours              12,000                     7,200                 19,200
Machine hours                4,800                   24,000                 28,800
Job 142
Direct labor-hours 25 17 42
Machine hours 17 20 37
1.   Calculate the amount of manufacturing overhead applied to Job 142. Converse uses a plantwide predetermined overhead rate based on direct labor hours.  
2.   The CFO is considering changing the allocation base for Production to machine hours (instead of direct labor hours).   The allocation base for Assembly would continue to be direct labor hours.  
Assembly Production Total

Solutions

Expert Solution

1 Calculation of predetermined overhead rate
Assembly Production Total
Manufacturing overhead cost(a) $4,80,000 $5,28,000 $10,08,000
Direct labor hours(b) 12000 7200 19200
Predetermined overhead rate(a/b) $40.00 $73.33 $52.50
Manufacturing overhead applied to Job 142
Assembly Production Total
Predetermined overhead rate $40.00 $73.33 $52.50
Direct labor hours for Job 142 25 17 42
Manufacturing overhead $1,000.00 $1,246.67 $2,246.67
2 Calculation of predetermined overhead rate
Assembly Production Total
Manufacturing overhead cost(a) $4,80,000 $5,28,000 $10,08,000
Direct labor hours(b) 12000 7200 19200
Machine Hours© 4800 24000 28800
Predetermined overhead rate for Assembly(a/b) $40.00 $73.33 $52.50
Predetermined overhead rate for Production(a/c) $100.00 $22.00 $35.00

Related Solutions

Using the information on the Data tab of the spreadsheet , complete the cost of goods...
Using the information on the Data tab of the spreadsheet , complete the cost of goods manufactured for January. Show calculations for all items/questions Below is manufacturing data from Webster Company for January, 2020.   Beginning raw materials inventory $          321,300 Raw materials purchased $          845,150 Ending raw materials inventory $          275,475 Direct labor costs $          104,590 Indirect materials $             47,560 Indirect labor $             29,876 Factory utilities and maintenance $          148,890 Factory depreciation $             19,876 Other factory related overhead $               7,890...
Based on the data presented in the Spreadsheet below (Variances tab), complete the following calculations. Calculate...
Based on the data presented in the Spreadsheet below (Variances tab), complete the following calculations. Calculate the material variances. Calculate the labor variances. Complete your calculations by filling the in highlighted cells. Discuss your observations about the variances and ways to plan to improve any of the variances. Cookie Business Actual Cost of Direct Materials $          225,000 Standard Cost of Direct Materials $          224,800 Actual Materials Used                         30 Standard Materials Used                         31 Actual Direct Labor Rate $              15.50...
Instructions: You are the Chief Financial Officer (CFO) of a firm that is being sued for...
Instructions: You are the Chief Financial Officer (CFO) of a firm that is being sued for damages it caused. It is the end of your fiscal year, and you are trying to determine the appropriate treatment of this matter. Your boss, the Chief Executive Officer (CEO) acknowledges (privately) that your firm is responsible for the damages and that the judgment will be made against your firm. Your legal counsel estimates that the penalty levied by the court will be in...
Instructions: Using the data for the assignment complete your spreadsheet and answer the five questions. When...
Instructions: Using the data for the assignment complete your spreadsheet and answer the five questions. When you make the changes for question 4 and 5 your spreadsheet will change and your spreadsheet answer from the previous question may change depending on how you build your spreadsheet. That is OK, we can look at your spreadsheet and do some quick checks. Again, we are expecting to see formulas/functions in the spreadsheet. This assignment is similar to the Biz Café Individual Assignment...
Instructions Complete the following problems using either a financial calculator or a spreadsheet program. Do not...
Instructions Complete the following problems using either a financial calculator or a spreadsheet program. Do not use interim rounding, state your answers as positive values, to two decimal places for dollar or period values and four places for percentages stated as decimals; do not label answers with symbols such as $ or %. For example, 10.5% should be input as .1050. An investment with quarterly compounding has a nominal rate of 0.0917. The effective rate is:
Ms. Hunter is the chief financial officer for Atlanta Developers. In January, she estimates that the...
Ms. Hunter is the chief financial officer for Atlanta Developers. In January, she estimates that the company will need to purchase 300,000 square feet of plywood in June to meet its material needs on one of its office construction jobs. a. Suppose there is a June plywood contract trading at f0 = $0.20/sq. ft. (contract size is 5,000 square feet). Explain how Ms. Hunter could hedge the company’s June plywood costs with a position in the June plywood contract. b....
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the acquisition of a key subsidiary this year. Your chief executive officer (CEO) has requested a presentation to the board of directors describing the methods available to account for the acquisition internally and the best method for the company during the acquisition year. Please assess the value of each method identified in your presentation to the board and support your recommendation with examples. Respond to...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the acquisition of a key subsidiary this year. Your chief executive officer (CEO) has requested a presentation to the board of directors describing the methods available to account for the acquisition internally and the best method for the company during the acquisition year. Please assess the value of each method identified in your presentation to the board and support your recommendation with examples. Respond to...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the acquisition of a key subsidiary during the current year. Your chief executive officer (CEO) has requested a presentation to the Board of Directors describing the methods available to account for the acquisition internally and the best method for the company during the acquisition year. Please assess the value of each method identified in your presentation to the Board and support your recommendation with examples....
As chief financial officer, it is your responsibility to weigh financial pros and cons of the...
As chief financial officer, it is your responsibility to weigh financial pros and cons of the many investment opportunities developed by your company's research and development division. You are currently evaluating two competing 15-year projects that differ in several ways. Relative to your firm's current EPS, the first project is expected to generate above-average EPS during the first 5 years, average EPS during the second 5 years,and then below-average EPS in the last 5 years. The second project is expected...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT