Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 17, Problem 3R
Now that your worksheet has been saved as JOB2, fill in the appropriate data for Job 8961. Save the results as JOB8961 and print the completed
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The company uses ABC and has determined the following activities, cost drivers and activity rates Activity Center Activity Driver Activity rate Direct labor usage Direct labor hours $3 per DL hrMachine usage Machine hours $8 per machine hrMachine setups Setups $200 per set up Design changes Design changes $400 per design change
You have completed Job 101. Determine the cost of Job 101, if the job required $1,000 in Direct Material, $3,000 in Direct Labor, 500 direct labor hours, 75 machine hours, 2 setups and 1 design change.
RIRA Company makes attachments such as backhoes and grader and bulldozer blades for construction equipment. The company uses a job order cost system. Management is concerned about cost performance and evaluates the job cost sheets to learn more about the cost effectiveness of the operations. To facilitate a comparison, the cost sheet for Job 206 (50 backhoe buckets completed in October) was compared with Job 228, which was for 75 backhoe buckets completed in December. The two job cost sheets follow:
Clemens Cars’s job cost sheet for Job A40 shows that the cost to add security features to a car was $10,500. The car was delivered to the customer, who paid $14,900 in cash for the added features. What journal entries should Clemens record for the completion and delivery of Job A40?
Chapter 17 Solutions
Excel Applications for Accounting Principles
Ch. 17 - Nutt Products manufactures screws and bolts made...Ch. 17 - Prob. 2RCh. 17 - Now that your worksheet has been saved as JOB2,...Ch. 17 - Next, open worksheet JOB2 again. Enter the data...Ch. 17 - Use the space provided below to prepare six...Ch. 17 - Nutts management is very concerned about the cost...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- RIRA Company makes attachments such as backhoes and grader and bulldozer blades for construction equipment. The company uses a job order cost system. Management is concerned about cost performance and evaluates the job cost sheets to learn more about the cost effectiveness of the operations. To facilitate a comparison, the job cost sheets for Job 206 (for 50 backhoe buckets completed in October) and Job 228 (for 75 backhoe buckets completed in December) were pulled and presented as follows: Management is concerned about the increase in unit costs over the months from October to December. To understand what has occurred, management interviewed the purchasing manager and quality manager. Purchasing Manager: Prices have been holding steady for our raw materials during the first half of the year. I found a new supplier for our bulk steel that was willing to offer a better price than we received in the past. I saw these lower steel prices and jumped on them, knowing that a reduction in steel prices would have a very favorable impact on our costs. Quality Manager: Something happened around mid-year. All of a sudden, we were experiencing problems with respect to the quality of our steel. As a result, weve been having all sorts of problems on the shop floor in our foundry and welding operation. a. Analyze the two job cost sheets and identify why the unit costs have changed for the backhoe buckets. Complete the following schedule to help in your analysis: b. How would you interpret what has happened in light of your analysis and the interviews?arrow_forwardNutts management is very concerned about the cost of overhead on its jobs. When jobs are complete, overhead costs should be between 15% and 20% of total costs. For example, the labor cost on Job 8958 is 25% of total costs, higher than the norm. Open Job 8961 and click the Chart sheet tab. A pie chart appears showing the cost components on that job. Record the labor cost percentage in the space provided. Repeat this for each of the jobs worked on in August. Did Nutt maintain good cost control on all its jobs? Explain. Worksheet. During September, Job 8963 required two additional material requisitions to complete the job. Open JOB8963 and modify the job cost sheet to include an area for four direct material requisition entries instead of three. Then enter the following two materials requisitions onto the worksheet: Preview the printout to make sure it will print neatly on one page, and then print the worksheet. Save the completed worksheet as JOBT. Chart. Open JOB8964 and click the Chart sheet tab. Prepare a bar chart for JOB8964 showing the amount of material, labor, and overhead required to complete the job. Use the Chart Data Table found in rows 4246 as a basis for preparing the chart. Enter your name somewhere on the chart. Save the file again as J0B8964. Print the chart.arrow_forwardPlease use the information from this problem for these calculations. After grouping cost pools and estimating overhead and activities, Box Springs determined these rates: Box Springs estimates there will be four orders in the next year, and those jobs will involve: What is the total cost of the jobs?arrow_forward
- Please use the information from this problem for these calculations. After grouping cost pools and estimating overhead and activities, Box Springs determined these rates: It estimates there will be five orders in the next year, and those jobs will involve: What is the total cost of the jobs?arrow_forwardExotic Engine Shop uses a job order cost system to determine the cost of performing engine repair work. Estimated costs and expenses for the coming period are as follows: The average shop direct labor rate is 37.50 per hour. Determine the predetermined shop overhead rate per direct labor hour.arrow_forwardLeen Production Co. uses the job order cost system of accounting. The following information was taken from the companys books after all posting had been completed at the end of May: a. Compute the total production cost of each job. b. Prepare the journal entry to transfer the cost of jobs completed to Finished Goods. c. Compute the selling price per unit for each job, assuming a mark-on percentage of 40%. d. Prepare the journal entries to record the sale of Job 1065.arrow_forward
- Gerken Fabrication Inc. uses the job order cost system of accounting. The following information was taken from the companys books after all posting had been completed at the end of March: a. Compute the total production cost of each job. b. Prepare the journal entries to charge the costs of materials, labor, and factory overhead to Work in Process. c. Prepare the journal entry to transfer the cost of jobs completed to Finished Goods. d. Compute the unit cost of each job. e. Compute the selling price per unit for each job, assuming a mark-on percentage of 50%.arrow_forwardJob 113 was completed at a cost of $4,800, and Job 85 was completed at a cost of $3,300 and sold on account for $4,500. Prepare journal entries for the following: If an amount box does not require an entry, leave it blank. A. Completion of Job 113. fill in the blank ec5974fe0f8f04b_2 fill in the blank ec5974fe0f8f04b_3 fill in the blank ec5974fe0f8f04b_5 fill in the blank ec5974fe0f8f04b_6 B. Completion and sale of Job 85. fill in the blank ac9efe072f91fff_2 fill in the blank ac9efe072f91fff_3 fill in the blank ac9efe072f91fff_5 fill in the blank ac9efe072f91fff_6 fill in the blank ac9efe072f91fff_8 fill in the blank ac9efe072f91fff_9 fill in the blank ac9efe072f91fff_11 fill in the blank ac9efe072f91fff_12 fill in the blank ac9efe072f91fff_14 fill in the blank ac9efe072f91fff_15 fill in the blank ac9efe072f91fff_17 fill in the blank ac9efe072f91fff_18arrow_forwardClemens Cars’s job cost sheet for Job A40 shows that the cost to add security features to a car was $15,000. The car was delivered to the customer, who paid $19,700 in cash for the added features. What journal entries should Clemens record for the completion and delivery of Job A40? a) Record transfer of cost of completed job to Finished Goods b) Record the cost of goods sold c) Record sale price of delivered job paid in casharrow_forward
- Haywood Printing is processing a job with the following activity rates: Activity Cost Driver Driver Rate Direct labor Number of hours $8 Copying Number of copies $0.05 If this job requires 5 hours for 1,000 copies, what is the activity-based cost of the job?arrow_forwardFor each item below indicate the source documents that would most likely authorize the journal entry in a job-costing system. An answer may be used more than once ,but not all answers will be used. 1. applied overhead rate 2. budgeted invoice 3. job cost record 4. labor time card 5. materials requisition record 6. purchase invoice 7. revenue record 8. sales invoice a. direct materials purchased b. direct materials used c. direct manufacturing labor d. indirect manufacturing labor e. finished goods control f. cost of goods soldarrow_forwardThis exercise is using the question in the picture, but replacing some of the information as listed below. Please answer question 2 & 3 from the question in the picture, with the changed information. *Assume Direct Labor workers make $20 per hour, so with the given labor cost per job, you can determine the number of hours worked. CHANGE the Exercise to say that Overhead is applied at the rate of $32 per direct labor hour. ALSO CHANGE to say that Job #39 and Job #40 were completed and sold, while Job #41 and Job #42 are complete but not sold, and Job #43 is not completed yet.*arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Cost Accounting - Definition, Purpose, Types, How it Works?; Author: WallStreetMojo;https://www.youtube.com/watch?v=AwrwUf8vYEY;License: Standard YouTube License, CC-BY