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?
-
Using the data presented in BE13-4 for Rollaird Company, perform vertical analysis. In BE13-4 December 31, 2017 December 31, 2016 S 400,000 Accounts receivable Inventory Total assets $ 460,000 n...
-
The article "Drying of Pulps in Sprouted Bed: Effect of Composition on Dryer Performance" (M. Medeiros, S. Rocha, et al., Drying Technology, 2002:865-881) presents measurements of pH, viscosity (in...
-
Link the following environmental transactions and events with the relevant environmental accounting system: 1 A tax on emissions of carbon dioxide 2 Capital expenditure on a water-recycling plant 3 A...
-
Truck suspensions often have helper springs that engage at high loads. One such arrangement is a leaf spring with a helper coil spring mounted on the axle, as in Figure P7.17. The helper spring...
-
Smith Corporation has gone through bankruptcy and is ready to emerge as a reorganized entity on December 31, 2024. On this date, the company has the following assets (fair value is based on...
-
Throughout the course, you will be working on a Wealth Management Analyst Project For this project, imagine you are a new hire at a wealth management firm and tasked with determining the location of...
-
State whether or not the introduction in each paper is based on these key components 2. Discuss part of the introduction that relates to each of the five components (if a particular component is...
-
Three charges (Q, Qz, Q3) are arranged as shown in the diagram: Q Q and Q are an equal distance (30 cm) from the origin. Q3 is located at (30cm, 30cm). Q-1C, Q-2C and Q3-4 C. Calculate the magnitude...
-
Bar AB is pinned to the fixed support at A, and the pin P is fixed to the disk at radius R. The disk with outer radius Ro rolls without slipping over the horizontal flat surface with angular speed wd...
-
Based on the data shown below, calculate the regression line (each value to two decimal places) y= || + Enter an integer or decimal number [more..] x y 3 15.12 4 16.8 5 14.48 6 16.46 7 15.84 8 14.72...
-
According to her doctor, Mrs. Watson's cholesterol level is higher than only 10% of the females aged 50 and over. The cholesterol levels among females aged 50 mg mg and over are approximately...
-
The Intel logo is ubiquitous on computers and laptopslowercase letters surrounded by a quickly drawn oval. But few people really understand the business that Intel is in. Founded in 1968, the company...
-
AMD Incorporation manufactures micro-processors. The product costing system of AMD Incorporation has a single direct costing category (Direct Material) and a single indirect costing category...
-
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?
-
Following are the amounts spent (in millions of dollars) on media advertising in the United States by a sample of 10 companies. a. Find the mean amount spent on advertising. b. Find the median amount...
-
The following data represent the annual costs in dollars, of a sample of 22 popular magazine subscriptions. a. Find the mean annual subscription cost. b. Find the median annual subscription cost. c....
-
The Insurance Institute for Highway Safety reported that there were 5037 fatalities among drivers in auto accidents in a recent year. Following is a frequency distribution of their ages. a....
Study smarter with the SolutionInn App