Concept explainers
This Excel worksheet relates to the Dickson Company example that is summarized in Exhibit 2-5. Download the workbook containing this form from Connect, where you will also find instructions about how to use this worksheet form.
You should proceed to the requirements below only after completing your worksheet.
Required:
2. Change the total fixed
Selling price: The cost incurred by selling the product in the market is known as the selling price.
Determine the missing figures in the sheet. After finding the missing figures determine the selling price of Job 408 by replacing the current data with the data given in the question.
Answer to Problem 2AE
Solution: The selling price of Job 408 using current data is $4348.75 and the selling price of Job 408 after replacing the current data with the given data is $2800.
Explanation of Solution
This calculation is done in the workbook and it is explained below,
Part -1- The missing figures in the sheet is determined here.
Chapter 2: Applying Excel | |||
Data | |||
Mark-up on job cost | 75% | ||
Department | |||
Milling | Assembly | ||
1 | Machine hours | 60000 | 3000 |
2 | Direct Labour Hours | 8000 | 80000 |
3 | Total fixed manufacturing overhead cost | $3,90,000.00 | $5,00,000.00 |
4 | Variable manufacturing overhead per machine hour | $2.00 | $ - |
5 | Variable manufacturing overhead per direct labour hour | $ - | $ 3.75 |
Cost Summary for job 407 | Department | ||
Milling | Assembly | ||
6 | Machine hours | 90 | 4 |
7 | Direct Labour Hours | 5 | 20 |
8 | Direct Materials | $800.00 | $370.00 |
9 | Direct Labour cost | $70.00 | $280.00 |
Enter a formula into each of the cells marked with? below | |||
Step 1: Calculate the estimated total manufacturing overhead cost for each department | |||
Milling | Assembly | ||
10 | Total fixed manufacturing overhead (given) | $3,90,000.00 | $5,00,000.00 |
11 | Variable manufacturing overhead per machine hour or direct labour hour (given) | $2.00 | $3.75 |
12 | Total machine hours or direct labour hours (given) | 60000 | 80000 |
13 | Total Variable manufacturing overhead (11 x 12) | $1,20,000.00 | $3,00,000.00 |
14 | Total manufacturing overhead (10 + 13) | $5,10,000.00 | $8,00,000.00 |
Step 2: Calculate the pre-determined overhead rate in each department | |||
Milling | Assembly | ||
15 | Total manufacturing overhead (14) | $5,10,000.00 | $8,00,000.00 |
16 | Total machine hours or direct labour hours (given) | 60000 | 80000 |
17 | Pre-determined overhead rate per machine hour or direct labour hour (15 divided by 16) | $8.50 | $10.00 |
Step 3: Calculate the amount of overhead applied to both departments to Job 407 | |||
Milling | Assembly | ||
18 | Pre-determined overhead rate per machine hour or direct labour hour (17) | $8.50 | $10.00 |
19 | Machine hours or direct labour hours for the job (given) | 90 | 20 |
20 | Manufacturing overhead applied (18 x 19) | $765.00 | $200.00 |
Step 4: Calculate the total job cost for Job 407 | |||
Milling | Assembly | ||
21 | Direct Materials (given) | $800.00 | $370.00 |
22 | Direct Labour cost (given) | $70.00 | $280.00 |
23 | Manufacturing overhead applied (20) | $765.00 | $200.00 |
24 | Total cost of Job 407 (21 + 22 + 23) | $1,635.00 | $850.00 |
Total cost of Job 407 (Milling + Assembly) | $2,485.00 | ||
Step 5: Calculate the selling price for Job 407 | |||
Milling | Assembly | ||
25 | Total cost of Job 407 ( 24) | $1,635.00 | $850.00 |
26 | Mark-up (24 x 75%) | $1,226.25 | $637.50 |
27 | Selling price of Job 407 (25 + 26) | $2,861.25 | $1,487.50 |
Total Selling Price (Milling + Assembly) | $4,348.75 |
Part 2 - The selling price of Job 408 by replacing the current data with data given
Chapter 2: Applying Excel | |||
Data | |||
Mark-up on job cost | 75% | ||
Department | |||
Milling | Assembly | ||
1 | Machine hours | 60000 | 3000 |
2 | Direct Labour Hours | 8000 | 80000 |
3 | Total fixed manufacturing overhead cost | $3,90,000.00 | $5,00,000.00 |
4 | Variable manufacturing overhead per machine hour | $2.00 | $ - |
5 | Variable manufacturing overhead per direct labour hour | $ - | $3.75 |
Cost Summary for job 408 | Department | ||
Milling | Assembly | ||
6 | Machine hours | 40 | 10 |
7 | Direct Labour Hours | 2 | 6 |
8 | Direct Materials | $700.00 | $360.00 |
9 | Direct Labour cost | $50.00 | $150.00 |
Enter a formula into each of the cells marked with? Below | |||
Step 1: Calculate the estimated total manufacturing overhead cost for each department | |||
Milling | Assembly | ||
10 | Total fixed manufacturing overhead (given) | $3,00,000.00 | $5,00,000.00 |
11 | Variable manufacturing overhead per machine hour or direct labour hour (given) | $2.00 | $3.75 |
12 | Total machine hours or direct labour hours (given) | 60000 | 80000 |
13 | Total Variable manufacturing overhead (11 x 12) | $1,20,000.00 | $3,00,000.00 |
14 | Total manufacturing overhead (10 + 13) | $4,20,000.00 | $8,00,000.00 |
Step 2: Calculate the pre-determined overhead rate in each department | |||
Milling | Assembly | ||
15 | Total manufacturing overhead (14) | $4,20,000.00 | $8,00,000.00 |
16 | Total machine hours or direct labour hours (given) | 60000 | 80000 |
17 | Pre-determined overhead rate per machine hour or direct labour hour (15 divided by 16) | $7.00 | $10.00 |
Step 3: Calculate the amount of overhead applied to both departments to Job 408 | |||
Milling | Assembly | ||
18 | Pre-determined overhead rate per machine hour or direct labour hour (17) | $7.00 | $10.00 |
19 | Machine hours or direct labour hours for the job (given) | 40 | 6 |
20 | Manufacturing overhead applied (18 x 19) | $280.00 | $60.00 |
Step 4: Calculate the total job cost for Job 408 | |||
Milling | Assembly | ||
21 | Direct Materials (given) | $700.00 | $360.00 |
22 | Direct Labour cost (given) | $50.00 | $150.00 |
23 | Manufacturing overhead applied (20) | $280.00 | $60.00 |
24 | Total cost of Job 407 (21 + 22 + 23) | $1,030.00 | $570.00 |
Total cost of Job 407 (Milling + Assembly) | $1,600.00 | ||
Step 5: Calculate the selling price for Job 408 | |||
Milling | Assembly | ||
25 | Total cost of Job 407 ( 24) | $1,030.00 | $570.00 |
26 | Mark-up (24 x 75%) | $772.50 | $427.50 |
27 | Selling price of Job 407 (25 + 26 ) | $1,802.50 | $997.50 |
28 | Total Selling Price of Job 408 (Milling + Assembly) | $2,800.00 |
Thus, the selling price of Job 408 after replacing the current data with the given data is $2800.
Want to see more full solutions like this?
Chapter 2 Solutions
MANAGERIAL ACCOUNTING LL 8TH ED+CONNECT
- Big Mikes, a large hardware store, has gathered data on its overhead activities and associated costs for the past 10 months. Nizam Sanjay, a member of the controllers department, believes that overhead activities and costs should be classified into groups that have the same driver. He has decided that unloading incoming goods, counting goods, and inspecting goods can be grouped together as a more general receiving activity, since these three activities are all driven by the number of receiving orders. The 10 months of data shown below have been gathered for the receiving activity. Required: 1. Prepare a scattergraph, plotting the receiving costs against the number of purchase orders. Use the vertical axis for costs and the horizontal axis for orders. 2. Select two points that make the best fit, and compute a cost formula for receiving costs. 3. Using the high-low method, prepare a cost formula for the receiving activity. 4. Using the method of least squares, prepare a cost formula for the receiving activity. What is the coefficient of determination?arrow_forwardMott Company recently implemented a JIT manufacturing system. After one year of operation, Heidi Burrows, president of the company, wanted to compare product cost under the JIT system with product cost under the old system. Motts two products are weed eaters and lawn edgers. The unit prime costs under the old system are as follows: Under the old manufacturing system, the company operated three service centers and two production departments. Overhead was applied using departmental overhead rates. The direct overhead costs associated with each department for the year preceding the installation of JIT are as follows: Under the old system, the overhead costs of the service departments were allocated directly to the producing departments and then to the products passing through them. (Both products passed through each producing department.) The overhead rate for the Machining Department was based on machine hours, and the overhead rate for assembly was based on direct labor hours. During the last year of operations for the old system, the Machining Department used 80,000 machine hours, and the Assembly Department used 20,000 direct labor hours. Each weed eater required 1.0 machine hour in Machining and 0.25 direct labor hour in Assembly. Each lawn edger required 2.0 machine hours in Machining and 0.5 hour in Assembly. Bases for allocation of the service costs are as follows: Upon implementing JIT, a manufacturing cell for each product was created to replace the departmental structure. Each cell occupied 40,000 square feet. Maintenance and materials handling were both decentralized to the cell level. Essentially, cell workers were trained to operate the machines in each cell, assemble the components, maintain the machines, and move the partially completed units from one point to the next within the cell. During the first year of the JIT system, the company produced and sold 20,000 weed eaters and 30,000 lawn edgers. This output was identical to that for the last year of operations under the old system. The following costs have been assigned to the manufacturing cells: Required: 1. Compute the unit cost for each product under the old manufacturing system. 2. Compute the unit cost for each product under the JIT system. 3. Which of the unit costs is more accurate? Explain. Include in your explanation a discussion of how the computational approaches differ. 4. Calculate the decrease in overhead costs under JIT, and provide some possible reasons that explain the decrease.arrow_forwardKenkel, Ltd. uses backflush costing to account for its manufacturing costs. The trigger points are the purchase of materials, the completion of goods, and the sale of goods. Prepare journal entries to account for the following: a. Purchased raw materials, on account, 80,000. b. Requisitioned raw materials to production, 80,000. c. Distributed direct labor costs, 10,000. d. Factory overhead costs incurred, 60,000. (Use Various Credits for the account in the credit part of the entry.) e. Completed all of the production started. f. Sold the completed production for 225,000, on account.arrow_forward
- Bumblebee Mobiles manufactures a line of cell phones. The management has identified the following overhead costs and related cost drivers for the coming year. The following were incurred in manufacturing two of their cell phones, Bubble and Burst, during the first quarter. REQUIREMENT Review the worksheet called ABC that follows these requirements. You have been asked to determine the cost of each product using an activity-based cost system. Note that the problem information is already entered into the Data Section of the ABC worksheet.arrow_forwardDavis Co. uses backflush costing to account for its manufacturing costs. The trigger points are the purchase of materials, the completion of goods, and the sale of goods. Prepare journal entries to account for the following: a. Purchased raw materials, on account, 70,000. b. Requisitioned raw materials to production, 70,000. c. Distributed direct labor costs, 15,000. d. Factory overhead costs incurred, 45,000. (Use Various Credits for the account in the credit part of the entry.) e. Completed all of the production started. f. Sold the completed production for 195,000, on account. (Hint: Use a single account for raw materials and work in process.)arrow_forwardVargas, Inc., produces industrial machinery. Vargas has a machining department and a group of direct laborers called machinists. Each machinist is paid 25,000 and can machine up to 500 units per year. Vargas also hires supervisors to develop machine specification plans and to oversee production within the machining department. Given the planning and supervisory work, a supervisor can oversee three machinists, at most. Vargass accounting and production history reveal the following relationships between units produced and the costs of direct labor and supervision (measured on an annual basis): Required: 1. Prepare two graphs: one that illustrates the relationship between direct labor cost and units produced, and one that illustrates the relationship between the cost of supervision and units produced. Let cost be the vertical axis and units produced the horizontal axis. 2. How would you classify each cost? Why? 3. Suppose that the normal range of activity is between 2,400 and 2,450 units and that the exact number of machinists is currently hired to support this level of activity. Further suppose that production for the next year is expected to increase by an additional 400 units. How much will the cost of direct labor increase (and how will this increase be realized)? Cost of supervision?arrow_forward
- Geneva, Inc., makes two products, X and Y, that require allocation of indirect manufacturing costs. The following data were compiled by the accountants before making any allocations: The total cost of purchasing and receiving parts used in manufacturing is 60,000. The company uses a job-costing system with a single indirect cost rate. Under this system, allocated costs were 48,000 and 12,000 for X and Y, respectively. If an activity-based system is used, what would be the allocated costs for each product?arrow_forwardIn 20x2, Choctaw Company implements a new process affecting labor and materials. The following reported data are provided to evaluate the effect on the companys productivity: Required: 1. Calculate the productivity profile for 20x1. 2. Calculate the productivity profile for 20x2, and comment on the effect of the new production and assembly process. 3. What if the labor hours used in 20x2 were 112,500? What does comparison of the 20x1 and 20x2 profiles now communicate?arrow_forwardPinter Company had the following environmental activities and product information: 1. Environmental activity costs 2. Driver data 3. Other production data Required: 1. Calculate the activity rates that will be used to assign environmental costs to products. 2. Determine the unit environmental and unit costs of each product using ABC. 3. What if the design costs increased to 360,000 and the cost of toxic waste decreased to 750,000? Assume that Solvent Y uses 6,000 out of 12,000 design hours. Also assume that waste is cut by 50 percent and that Solvent Y is responsible for 14,250 of 15,000 pounds of toxic waste. What is the new environmental cost for Solvent Y?arrow_forward
- Evans, Inc., has a unit-based costing system. Evanss Miami plant produces 10 different electronic products. The demand for each product is about the same. Although they differ in complexity, each product uses about the same labor time and materials. The plant has used direct labor hours for years to assign overhead to products. To help design engineers understand the assumed cost relationships, the Cost Accounting Department developed the following cost equation. (The equation describes the relationship between total manufacturing costs and direct labor hours; the equation is supported by a coefficient of determination of 60 percent.) Y=5,000,000+30X,whereX=directlaborhours The variable rate of 30 is broken down as follows: Because of competitive pressures, product engineering was given the charge to redesign products to reduce the total cost of manufacturing. Using the above cost relationships, product engineering adopted the strategy of redesigning to reduce direct labor content. As each design was completed, an engineering change order was cut, triggering a series of events such as design approval, vendor selection, bill of materials update, redrawing of schematic, test runs, changes in setup procedures, development of new inspection procedures, and so on. After one year of design changes, the normal volume of direct labor was reduced from 250,000 hours to 200,000 hours, with the same number of products being produced. Although each product differs in its labor content, the redesign efforts reduced the labor content for all products. On average, the labor content per unit of product dropped from 1.25 hours per unit to one hour per unit. Fixed overhead, however, increased from 5,000,000 to 6,600,000 per year. Suppose that a consultant was hired to explain the increase in fixed overhead costs. The consultants study revealed that the 30 per hour rate captured the unit-level variable costs; however, the cost behavior of other activities was quite different. For example, setting up equipment is a step-fixed cost, where each step is 2,000 setup hours, costing 90,000. The study also revealed that the cost of receiving goods is a function of the number of different components. This activity has a variable cost of 2,000 per component type and a fixed cost that follows a step-cost pattern. The step is defined by 20 components with a cost of 50,000 per step. Assume also that the consultant indicated that the design adopted by the engineers increased the demand for setups from 20,000 setup hours to 40,000 setup hours and the number of different components from 100 to 250. The demand for other non-unit-level activities remained unchanged. The consultant also recommended that management take a look at a rejected design for its products. This rejected design increased direct labor content from 250,000 hours to 260,000 hours, decreased the demand for setups from 20,000 hours to 10,000 hours, and decreased the demand for purchasing from 100 component types to 75 component types, while the demand for all other activities remained unchanged. Required: 1. Using normal volume, compute the manufacturing cost per labor hour before the year of design changes. What is the cost per unit of an average product? 2. Using normal volume after the one year of design changes, compute the manufacturing cost per hour. What is the cost per unit of an average product? 3. Before considering the consultants study, what do you think is the most likely explanation for the failure of the design changes to reduce manufacturing costs? Now use the information from the consultants study to explain the increase in the average cost per unit of product. What changes would you suggest to improve Evanss efforts to reduce costs? 4. Explain why the consultant recommended a second look at a rejected design. Provide computational support. What does this tell you about the strategic importance of cost management?arrow_forwardLansing. Inc., provided the following data for its two producing departments: Machine hours are used to assign the overhead of the Molding Department, and direct labor hours are used to assign the overhead of the Polishing Department. There are 30,000 units of Form A produced and sold and 50,000 of Form B. Required: 1. Calculate the overhead rates for each department. 2. Using departmental rates, assign overhead to live two products and calculate the overhead cost per unit. How does this compare with the plantwide rate unit cost, using direct labor hours? 3. What if the machine hours in Molding were 1,200 for Form A and 3,800 for Form B and the direct labor hours used in Polishing were 5,000 and 15,000, respectively? Calculate the overhead cost per unit for each product using departmental rates, and compare with the plantwide rate unit costs calculated in Requirement 2. What can you conclude from this outcome?arrow_forwardFisico Company produces exercise bikes. One of its plants produces two versions: a standard model and a deluxe model. The deluxe model has a wider and sturdier base and a variety of electronic gadgets to help the exerciser monitor heartbeat, calories burned, distance traveled, etc. At the beginning of the year, the following data were prepared for this plant: Additionally, the following overhead activity costs are reported: Required: 1. Calculate the cost per unit for each product using direct labor hours to assign all overhead costs. 2. Calculate activity rates and determine the overhead cost per unit. Compare these costs with those calculated using the unit-based method. Which cost is the most accurate? Explain.arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub