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:
Answer rating: 100% (QA)
Okay lets calculate the selling price for Job 408 based on the given requireme... View the full 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
-
Exercise 1.13. Suppose that F is a -field on any set and that B E F is any event. (a) Is the family H := {AUB: AE F} a -field on ? (b) Show that the family G := {An B : A F} is a -field on B.
-
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?
-
On January 1, 2017, Bryce Inc. changed from the LIFO method of inventory pricing to the FIFO method. Explain how this change in accounting principle should be treated in the company's financial...
-
Using the information in Problem 4-6B, prepare an income statement and a statement of changes in equity for the year ended December 31, 2023, and a classified balance sheet at December 31, 2023. The...
-
From the following balances in the books of Breaker plc you are to draw up (i) a detailed trading and profit and loss account for the year ending 31 March 2004 for internal use, and (ii) a profit and...
-
Hank Itzek manufactures and sells homemade wine, and he wants to develop a standard cost per gallon. The following are required for production of a 50-gallon batch. 3,000 ounces of grape concentrate...
-
Draiman Guitars is offering 150,000 shares of stock in an IPO by a general cash offer. The offer price is $20 per share and the underwriter's spread is 6.5 percent. The administrative costs are $39...
-
Build a data table in G21:AB42 that shows what 2021 EPS would be based on the revenue growth rate and cost of goods sold / revenue assumptions listed in Table 1. Input the revenue growth rate...
-
Sams Company has the following information collected to prepare a cash flow statement and uses the direct method for Cash Flow from Operations. The annual report year end is December 31, 2022....
-
On January 1 , 2 0 0 9 , Korman Company purchased 9 % bonds having a maturity value of $ 1 , 0 0 0 , 0 0 0 for $ 9 6 2 , 0 0 0 . The bonds provide the bondholders with a 1 0 % yield. The coupon is...
-
The bar AB has a pin support at C and is attached to a cable (AD) at A. The bar is subjected to a vertical load of 33 N at B. Determine the tension in the cable AD knowing that a = A 10 cm to D a 12...
-
SoonerCo. is engaged in a transfer pricing scheme with its international affiliate. It sells goods from the foreign affiliate to the US company at a high price to record more income in the lower tax...
-
The unadjusted balance for inventory is $ 1 9 5 0 0 as of December 3 1 , 2 0 2 3 . TBCS uses a perpetual inventory system to account for inventory. Below is a breakdown of inventory on hand on...
-
On January 1 , 2 0 2 2 , Don Buchanan purchases a business that he will carry on as a sole proprietor. The purchase price includes $ 6 0 , 0 0 0 for goodwill. The business has a fiscal period that...
-
Write an argument inspired by the thoughts and ideas presented in the video assigned for this unit. Do not address the speaker or use the video as a source. Review the handout on Argument at the link...
-
Problem 2. (0.6 points, 0.2 points for each question) (a) A company turns its inventory 2 times a month. Its months-of-supply = Its days-of-supply = Please show your analysis below: _months. days. (1...
-
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?
-
Explain why corporations may prefer to issue bonds to raise funds for their operations.
-
Explain the meaning of bond ratings and their impact on buying decisions.
-
Describe the characteristics of a municipal bond, including tax factors.
Study smarter with the SolutionInn App