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...
-
Consider the reaction 2CO(g) + O2(g) 2CO2(g) a. Using data from Appendix 4, calculate K at 298 K. b. What is S for this reaction at T = 298 K if the reactants, each at 10.0 atm, are changed to...
-
How do cab-mounted wind deflectors for tractor-trailer trucks work? Explain using diagrams of the flow pattern around the truck and pressure distribution on the surface of the truck.
-
You are considering buying a 14-year, semiannual-coupon bond that has a coupon rate of 8.25 percent and a YTM of 8.25 percent. What should be the price of this bond? a. $1,000.00 b. $1,106.08 c....
-
A. Identify ONE type of boundary data shown on the map.B. Identify the region of the United States where most dairy farms are located.C. Identify ONE spatial pattern shown on the map.D. Describe the...
-
Grade Level A city conducted a census to determine the types of schools attended by the city's students. Hannah finds some of the data from the census on different websites and constructs the two-way...
-
What alternative test to the APGAR could an obstetrics nurse or doctor use to assess newborn functioning? What would be the advantages and disadvantages compared to the APGAR test shown in Table 1.1?...
-
For the group application work, build a Regnier Abacus with around 6 questions, aimed at prospecting information about the attributes of the product. Add a comment about the difficulties you may have...
-
A group of elementary school students took a standardized reading test. The mean score was 70 and the standard deviation was 10. Someone says that only 50% of the students scored between 50 and 90....
-
Find the sample variance and standard deviation for the following sample: 17 40 24 18 16
-
In general, a histogram is skewed to the left if the__________________ is noticeably less than the ___________________ .
-
Lengths of newborn babies have a mean of 20.1 inches with a standard deviation of 1.9 inches. Find the coefficient of variation of newborn lengths.
-
Fill in the blank: If the points on a scatterplot tend to cluster around a straight line, the variables plotted have a ___________________ association.
-
Supplies Patent OA. $1,463 OB. $1,060 OC. $1,068 OD. $993 39 60
-
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...
-
Assume that a division of Sony, Inc. makes an electronic component for its speakers. Its manufacturing process for the component is a highly automated part of a just-in-time production system. All...
-
Consider these data regarding Muskoka Countys photocopying equipment: The county administrator is trying to decide whether to replace the old equipment. Because of rapid changes in technology, she...
-
Mussina Chemical Company produced three joint products at a joint cost of $117,000. These products were processed further and sold as follows: CHEMICAL PRODUCT ADDITIONAL SALES PROCESSING COSTS ABC...
Study smarter with the SolutionInn App