Download the Applying Excel form and enter formulas in all cells that contain question marks. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Download the Applying Excel form and enter formulas in all cells that contain question marks. The Chapter 2 Form worksheet is to be used to create your own worksheet version of the example in the text. Enter formulas in the cells that contain question marks. For example, in cell B25 enter the formula "=B10". After entering formulas in all of the cells that contained question marks, verify that the amounts match the example in the text. Check your worksheet by changing the total fixed manufacturing overhead cost for the Milling Department in the Data area to $300,000, keeping all other data the same as in the original example. If your worksheet is operating properly, the total cost of Job 407 should now be $2,350. If you do not get this answer, find the errors in your worksheet and correct them. Data Markup on job cost 75% Department Milling 60,000 8,000 $390,000 $2.00 Assembly 3,000 80,000 $500,000 Machine-hours Direct labor-hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour $3.75 Cost summary for Job 407 Department Milling Assembly Machine-hours 90 Direct labor-hours 20 $800 $70 Direct materials $370 $280 Direct labor cost Enter a fomula into each of the cells marked with a ? below Step 1: Calculate the estimated total manufacturing overhead cost for each department Milling Assembly Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour or direct labor-hour ? ? Total machine-hours or direct labor-hours Total variable manufacturing overhead Total manufacturing overhead ? Step 2: Calculate the predetermined overhead rate in each department Milling Assembly Total manufacturing overhead Total machine-hours or direct labor-hours Predetemined overhead rate per machine-hour or direct labor-hour ? Step 3: Calculate the amount of overhead applied from both departments to Job 407 Milling Assembly Predetermined overhead rate per machine-hour or direct labor-hour Machine-hours or direct labor-hours for the job Manufacturing overhead applied ? Step 4: Calculate the total job cost for Job 407 Milling ? Assembly 1? Total Direct materials Direct labor cost Manufacturing overhead applied ? ? ? Total cost of Job 407 ? Step 5: Calculate the selling price for Job 407 Total cost of Job 407 ? Markup Selling price of Job 407 ? Download the Applying Excel form and enter formulas in all cells that contain question marks. The Chapter 2 Form worksheet is to be used to create your own worksheet version of the example in the text. Enter formulas in the cells that contain question marks. For example, in cell B25 enter the formula "=B10". After entering formulas in all of the cells that contained question marks, verify that the amounts match the example in the text. Check your worksheet by changing the total fixed manufacturing overhead cost for the Milling Department in the Data area to $300,000, keeping all other data the same as in the original example. If your worksheet is operating properly, the total cost of Job 407 should now be $2,350. If you do not get this answer, find the errors in your worksheet and correct them. Data Markup on job cost 75% Department Milling 60,000 8,000 $390,000 $2.00 Assembly 3,000 80,000 $500,000 Machine-hours Direct labor-hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour $3.75 Cost summary for Job 407 Department Milling Assembly Machine-hours 90 Direct labor-hours 20 $800 $70 Direct materials $370 $280 Direct labor cost Enter a fomula into each of the cells marked with a ? below Step 1: Calculate the estimated total manufacturing overhead cost for each department Milling Assembly Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour or direct labor-hour ? ? Total machine-hours or direct labor-hours Total variable manufacturing overhead Total manufacturing overhead ? Step 2: Calculate the predetermined overhead rate in each department Milling Assembly Total manufacturing overhead Total machine-hours or direct labor-hours Predetemined overhead rate per machine-hour or direct labor-hour ? Step 3: Calculate the amount of overhead applied from both departments to Job 407 Milling Assembly Predetermined overhead rate per machine-hour or direct labor-hour Machine-hours or direct labor-hours for the job Manufacturing overhead applied ? Step 4: Calculate the total job cost for Job 407 Milling ? Assembly 1? Total Direct materials Direct labor cost Manufacturing overhead applied ? ? ? Total cost of Job 407 ? Step 5: Calculate the selling price for Job 407 Total cost of Job 407 ? Markup Selling price of Job 407 ?
Expert Answer:
Answer rating: 100% (QA)
Required solution Step 1 Calculate the estimated total manufacturing overhead cost for each departme... View the full answer
Related Book For
Accounting Principles
ISBN: 978-0470533475
9th Edition
Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso
Posted Date:
Students also viewed these accounting questions
-
Change the total fixed manufacturing overhead cost for the Milling Department in the area back to $390,000, keeping all of the other data the same as in the original example. Consider a new job, Job...
-
If the user inputs an address of 1111, what data value will be output from this ROM? A, A A- A,- So S S S, 4 x 16 Decoder ENDOJAWNHO 6 8 13 14 15 D, D, D, D, D, D, D Do
-
QUESTION 3 YORK Co. Ltd and HERT Plc, are two companies in the electronic car manufacturing sector. Both companies are listed on a major stock exchange in Asia. At the last meeting of its board of...
-
In the game of roulette, a gambler who wins the bet receives $36 for every dollar she or he bet. A gambler who does not win receives nothing. If the gambler bets $1, what is the expected value of the...
-
Hot combustion gases (air) at 1500 K is used as heat source in a heat engine where the gas is cooled to 750 K and the ambient is at 300 K. This is not a constant T source. How does that affect the...
-
An auditorium measures 40.0 m X 20.0 m X 12.0 m. The density of air is 1.20 kg/m3. What are? (a) The volume of the room in cubic feet and (b) The weight of air in the room in pounds?
-
Renkas Heaters selected data for October 2017 are presented here (in millions): Calculate the following costs: 1. Direct materials inventory 10/31/2017 2. Fixed manufacturing overhead costs for...
-
The following data were taken from the records of Stellar Manufacturing Company for the fiscal year ended June 30, 2010. Instructions(a) Prepare a cost of goods manufactured schedule. (Assume all raw...
-
The table below shows the output per labourer per day for Guyana and Jamaica for Coffee and Rice. Coffee Rice Table 1 Output per labourer per day Guyana Jamaica 8 6 10 4 What is the autarky cost of...
-
Charles Whyte commenced business on May 1 2019, making up his accounts to September 30 annually. The statement of the Profit or Loss Account for the first 17 months ended September 30,2020 is as...
-
You manage a pension fund that will provide retired workers with lifetime annuities. You determine that the payouts of the fund are essentially going to resemble level perpetuities of $2.24 million...
-
A mass is attached to a spring with a spring constant of 8000 N/m. The spring and mass are set into simple harmonic motion on a frictionless horizontal surface. The period of vibration is 2.300 s....
-
Project A has an NPV of 100000. The project is financed by borrowing at 7%pa. The cost of capital for Project A is 0.11. This rate is expressed as a decimal, e.g. so that .12 is equal to 12%. The...
-
On February 1, 2013, Edwards Corporation purchased a parcel of land as a factory site for $250,000. It demolished an old building on the property and began construction on a new building that was...
-
By building a spreadsheet model, calculate this project's NPV. In this model, probably the most important value driver is the occupancy rate. Conduct the sensitivity analysis on the occupancy rate by...
-
Consider the following interface: interface Something { boolean validate (int value); Classes that implement "Something" interface can validate a specific value in different behaviors within some...
-
A normal adjustment to production cost standards is required for Blank______. Multiple choice question. defective materials due to lower than expected quality additional product evaporation due to...
-
Determine two different Hamilton circuits in each of the following graphs. A B F G
-
What factors should be considered in setting (a) The direct materials price standard and (b) The direct materials quantity standard?
-
What is a ratio? What are the different ways of expressing the relationship of two amounts? What information does a ratio provide?
-
Since the club opened, a major concern has been the pool facilities. Although the existing pool is adequate, Mindy, Oscar, and Lori all desire to make LifePath a cutting-edge facility. Until the end...
-
OMalley Corporation was incorporated and began business on January 1, 2015. It has been successful and now requires a bank loan for additional working capital to finance expansion. The bank has...
-
Presented below is information related to Viel Company at December 31, 2015, the end of its first year of operations. (a) income from operations, (b) net income, (c) net income attributable to Viel...
-
Financial Reporting Problem Marks and Spencer plc (M&S) The financial statements of M&S (GBR) are presented in Appendix A. The companys complete annual report, including the notes to the financial...
Study smarter with the SolutionInn App