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:
1. Check your worksheet by changing the total fixed
How much is the selling price of Job 407? Did it change? Why or why not?
Selling price: The cost incurred by selling the product in the market is known as the selling price.
Fixed overhead cost: The cost which does not vary even though there are changes in the business activity. Some of the costs which come under fixed overhead cost are rent, insurance, salaries etc.
Determine the missing figures. Once the figures are obtained, what is the change in the selling price if the fixed overhead cost is reduced to $300000 provided the total cost of Job 407 should be $2350.
Answer to Problem 1AE
Solution: There is a fall in the selling price since there is a change in the fixed overhead cost.
Explanation of Solution
This calculation should be done in the work book and it is explained below,
Part -1- Finding the missing figures:
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: To find the selling price of the job 407 after changes in the fixed overhead cost.
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,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 407 | |||
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) | 90 | 20 |
20 | Manufacturing overhead applied (18 x 19) | $630.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) | $630.00 | $200.00 |
24 | Total cost of Job 407 (21 + 22 + 23) | $1,500.00 | $850.00 |
Total cost of Job 407 (Milling + Assembly) | $2,350.00 | ||
Step 5: Calculate the selling price for Job 407 | |||
Milling | Assembly | ||
25 | Total cost of Job 407 ( 24) | $1,500.00 | $850.00 |
26 | Mark-up (14 x 75%) | $1,125.00 | $637.50 |
27 | Selling price of Job 407 (25 + 26 ) | $2,625.00 | $1,487.50 |
28 | Total Selling Price of Job 407 (Milling + Assembly) | $4,112.50 |
The selling price of the Job 407 reduces from $4348.75 to $4112.50 since selling price is based on cost plus mark-up method. Hence, it is directly affected by the fall in Fixed Overhead cost.
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_forwardBumblebee 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_forwardAssume you are the leather department manager at the Famous Football Factory. The leather department is a cost center and you are reviewing the scrap costs for the previous year, shown here: A. Using Microsoft Excel or another spreadsheet application, create a line chart with markers showing the leather scrap expense. Describe your observations. B. Knowing that leather is susceptible to indoor temperature, you decide to talk with the maintenance manager and obtain the following information: Using Microsoft Excel or another spreadsheet application, create individual line charts with markers showing the indoor temperature, spare parts inventory, and breakdowns. Describe your observations and actions you might consider.arrow_forward
- Vargas, 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_forwardGeneva, 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_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_forward
- Lansing. 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_forwardThe Bangor Manufacturing Company makes mechanical toy robots that are typically produced in batches of 250 units. Prior to the current year, the company’s accountants used a standard cost system with a simplified method of assigning manufacturing support (i.e., overhead) costs to products: All such costs were allocated to outputs based on the standard machine hours allowed for output produced. You have recently joined the accounting team and are developing a proposal that the company adopt an ABC system for both product-costing and control purposes. To illustrate the benefit of such a system in terms of the latter, you decide to put together an analysis of batch-related overhead costs. You chose these costs because a previous investigation indicated that there is both a variable component to these costs (materials plus power) plus a fixed component (depreciation and salaries). Last year’s budget indicated that the variable overhead cost per setup hour was $20.00 and that the fixed…arrow_forwardUse the following information for the Exercises below. (Algo) Skip to question [The following information applies to the questions displayed below.]Textra produces parts for a machine manufacturer. Parts go through two departments, Molding and Trimming. The company budgets overhead cost of $248,750 in the Molding department and $208,750 in the Trimming department. The company budgets 16,000 machine hours (MH) in Molding and 25,000 direct labor hours (DLH) in Trimming. Actual production information follows. Number of Units Molding Department Trimming Department Hours per Unit Total Hours Hours per Unit Total Hours Part Z 3,000 2.0 MH per unit 6,000 MH 3 DLH per unit 9,000 DLH Part X 4,000 2.5 MH per unit 10,000 MH 4 DLH per unit 16,000 DLH Totals 16,000 MH 25,000 DLH Exercise 17-8 (Algo) Departmental overhead rates LO P2 Required:1. Compute a departmental overhead rate for the Molding department based on machine hours and a departmental overhead rate…arrow_forward
- The following information has been extracted from the cost accounting information system database for Casio Ltd. The company manufactures Casio Calculators. The cost accountant wants to carry out some analysis on the following 5 costs to ascertain the behavior of the costs. The cost accountant extracted the values of the 5 costs at three activity levels of 24,000 units,30,000 units and 36,000 units. (Note: The cost accountant intends to use the units produced as the activity level in the cost analysis. Required: i) Using the information provided in the above table identify and explain how you classify each of the above costs according to behavior of cost approach. ii) From the above classification in (i) calculate the fixed cost for any mixed cost that is identified from the above 5 costs using the high-low cost estimation method.arrow_forwardThis section has a nine-part comprehensive problem with multiple questions to address. Download the Chapter 9 Comprehensive Problem Template below to complete all parts. You will need your Bergevin and MacQueen book for reference. Redlands Inc. reported standard and actual costs for the product that it manufactures: Item Standard Actual Direct material price $3 per lb. $2 per lb. Direct materials quantity 2 lbs. 4 lbs. Direct labor price $5 $7 Direct labor quantity 3 hours 2 hours Factory overhead cost $2 per machine hour ---- Machine hours per unit 2 machine hours 3 machine hours Number of finished products made 10 12 Number of finished products sold 10 11 Sales per unit $40 $40 * Redlands used machine hours to apply factory overhead costs. The company incurred $90 actual total factory overhead costs to make the 12 products. 1. Standard product cost Item Price Quantity Total Direct materials Direct labor Factory overhead Standard…arrow_forwardI could use some help answering this with the attached spreadsheet. I finished parts a through c: Glassman Company acculated the following data for 2019: Milling Department manufacturing overhead $484,000 Finishing Department manufacturing overhead $260,000 Machine hours used Milling Department 10,000 Finishing Deparment 2000 Labor hours used Milling Department 1000 Finishing Department 1000 Assume that manufacturing overhead for Glassman Company above consisted of the following activities and costs: Setup (1000 setup hours) $288,000 Production scheduling (400 batches) $60,000 Production engineering (60 change orders) $180,000 Supervision (2000 direct labor hours) $56,000 Machine maintenance (12,000 machine hours) $168,000 Total activity costs $752,000 The following additional data were provided for Job 845: Direct materials costs $7000 Direct labor cost (5 milling direct labor hours; 35 finishing direct…arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College