2. Change the total fixed manufacturing overhead cost for the Milling Department in Data area back...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. Change the total fixed manufacturing overhead cost for the Milling Department in Data area back to $390,000, keeping all of the other data the same as in the original example. Consider a new job, Job 408, with the following characteristics: A 1 Chapter 2: Applying Excel B C 2 3 Cost summary for Job 408 Department 4 Milling Assembly Machine-hours 70 3 5 Direct labor-hours 6 20 6 Direct materials cost $ 590 $ 220 7 Direct labor cost $ 108 $ 380 8 In your worksheet, enter this new data in the cells for Job 407. What is the new selling price for Job 408? (Round your final answer to 2 decimal places.) Selling price for Job 408 3. Without changing the data for the job from requirement 2 above, what is the selling price for Job 408 if the total number of machine-hours in the Assembly Department increases from 3,000 machine-hours to 5,000 machine-hours? (Round your final answer to 2 decimal places.) Selling price for Job 408 4. Restore the total number of machine-hours in the Assembly Department to 3,000 machine-hours. And keep the job data the same as it was in Requirement 2. What is the selling price for Job 408 if the total number of direct labor-hours in the Assembly Department decreases from 80,000 direct labor-hours to 50,000 direct labor-hours? (Round your final answer to 2 decimal places.) Selling price for Job 408 2. Change the total fixed manufacturing overhead cost for the Milling Department in Data area back to $390,000, keeping all of the other data the same as in the original example. Consider a new job, Job 408, with the following characteristics: A 1 Chapter 2: Applying Excel B C 2 3 Cost summary for Job 408 Department 4 Milling Assembly Machine-hours 70 3 5 Direct labor-hours 6 20 6 Direct materials cost $ 590 $ 220 7 Direct labor cost $ 108 $ 380 8 In your worksheet, enter this new data in the cells for Job 407. What is the new selling price for Job 408? (Round your final answer to 2 decimal places.) Selling price for Job 408 3. Without changing the data for the job from requirement 2 above, what is the selling price for Job 408 if the total number of machine-hours in the Assembly Department increases from 3,000 machine-hours to 5,000 machine-hours? (Round your final answer to 2 decimal places.) Selling price for Job 408 4. Restore the total number of machine-hours in the Assembly Department to 3,000 machine-hours. And keep the job data the same as it was in Requirement 2. What is the selling price for Job 408 if the total number of direct labor-hours in the Assembly Department decreases from 80,000 direct labor-hours to 50,000 direct labor-hours? (Round your final answer to 2 decimal places.) Selling price for Job 408
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 9781260247787
17th Edition
Authors: Ray Garrison, Eric Noreen, Peter Brewer
Posted Date:
Students also viewed these accounting questions
-
This Excel worksheet relates to the Dickson Company example that is summarized in Exhibit 25. The workbook, and instructions on how to complete the file, can be found in Connect. You should proceed...
-
The info following the questions are from the original example. Change the total fixed manufacturing overhead cost for the Milling Department in the area back to $390,000, keeping all of the other...
-
what would you like to recommend to Australian government in regards to their fiscal stimulus policy for supporting covid affected society?
-
Net income was $500,000 in 2015, $485,000 in 2016, and $518,400 in 2017. What is the percentage of change from (a) 2015 to 2016, (b) From 2016 to 2017? Is the change an increase or a decrease?
-
All five of your credit cards are stolen from your motel room while you are skiing. Fortunately you discover the loss within a few hours and immediately notify the credit card companies by telephone....
-
If the IRR of Alternative \(A\) is 18 percent, the IRR of Alternative B is 16 percent, and MARR is 12 percent, which of the following is correct? a. Alternative B is preferred over Alternative A. b....
-
On January 1, 2014, Primo Corporation had the following stockholders equity accounts. Common Stock ($10 par value, 75,000 shares issued and outstanding) .....$750,000 Paid-in Capital in Excess of...
-
8. Two dice are rolled. Let A represent rolling a sum greater than 7. Let B represent rolling a sum that is a multiple of 3. Determine n(AB). A. 5 B. 8 C. 12 D. 15 Long Answer: Show all work for the...
-
Funtime, Inc., manufactures video game machines. Market saturation and technological innovations caused pricing pressures that resulted in declining profits. To stem the slide in profits until new...
-
Suppose the market supply curve for movie tickets is given by p=1/50Qs+7.5 and the market demand curve is given by p=30-1/50Qd+5n where n is an indicator that takes on the value 1 if Netflix raises...
-
Analyze how social media marketing can empower a marketing strategy, including the benefits and potential risks (if any) of using this type of marketing. Explain how search and content marketing can...
-
CASE STUDY: A noteworthy and historic case of involuntary active euthanasia, with ramifications that persist today, is that of Robert Latimer, a Saskatchewan farmer who killed his daughter, Tracy, in...
-
A Del Monte bond with a face value of $1,000 has an annual coupon of 6.75%. The bond had an original 7-year tenor and 4 years remaining to maturity. If the market interest rate for similar high yield...
-
Please write about social media and the bullying, harassment, and discrimination that takes place. Use a real world lawsuit you find about someone suing someone for online harassment and talk about...
-
Power relating to social status is premised on a willingness to "participate"; what might constitute criteria for non-participation, and should we think of this as a powerful instrument? Add...
-
Paul Lewis is the quality review partner on the Richards & Co. engagement. He was reviewing the workpapers prior to the December 31, 2015, annual audit when he came across transactions that...
-
Following is the current balance sheet for a local partnership of doctors: The following questions represent independent situations: a. E is going to invest enough money in this partnership to...
-
The table shown below contains three performance measures for each of the four perspectives of the balanced scorecard.
-
What is meant by residual income?
-
What is a quantity standard? What is a price standard?
-
Discuss the importance of validity and research design. Next, choose one type of validity (internal, external, construct, or statistical conclusion) and discuss its relevance to experimental, quasi...
-
Explain from a technical viewpoint why it is important to distinguish a method, research, approach, and design. Next, briefly discuss how understanding each term individually in addition to how these...
-
Define the two major types of sampling strategies .
Study smarter with the SolutionInn App