You are the Accountant for a Custom Furniture company. The company uses a job order costing...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are the Accountant for a Custom Furniture company. The company uses a job order costing system and applies overhead on the basis of direct labor hours. The January 1, 2024 raw materials inventory balance was $19,000. Actual overhead for January was $106,500 and Direct Labor Hours for January totaled 2,975. The January 31, 2024 raw materials inventory balance was $27,000. During January 2024, Jobs No. 21 & 22 were completed. A single Job, No. 22, was sold for $110,000 during January 2024. January 31, 2024 costing information for jobs 20, 21, 22 and 23 are below. Job No. Direct Materials Direct Labor Direct Labor Hours 20 $ 7,500 $ 18,600 1,200 21 $ 4,000 $ 12,788 825 22 $ 7,000 $ 13,563 875 23 $ 3,000 $ 3,100 200 The predetermined overhead rate for 2024 is based on the company's estimated total manufacturing overhead during all of 2024 which is $1,265,125 and the estimated total direct labor hours of 34,900. The owner of the company does not have an accounting background and doesn't understand how the balances of the inventory accounts are calculated nor how gross profit is calculated. The owner asked you to prepare a single spreadsheet providing the inventory balances and gross profit for January 2024. Your Excel Spreadsheet must include formulas, formatted cells and at least once text box. Tasks: 1. Correctly calculate predetermined overhead rate to be used in January 2024. 2. Correctly calculate the balances of the inventory accounts at January 31, 2024 indicating which jobs are included in the balance as applicable. 3. Correctly calculate gross profit for January 2024 indicating which jobs are included as applicable. You are the Accountant for a Custom Furniture company. The company uses a job order costing system and applies overhead on the basis of direct labor hours. The January 1, 2024 raw materials inventory balance was $19,000. Actual overhead for January was $106,500 and Direct Labor Hours for January totaled 2,975. The January 31, 2024 raw materials inventory balance was $27,000. During January 2024, Jobs No. 21 & 22 were completed. A single Job, No. 22, was sold for $110,000 during January 2024. January 31, 2024 costing information for jobs 20, 21, 22 and 23 are below. Job No. Direct Materials Direct Labor Direct Labor Hours 20 $ 7,500 $ 18,600 1,200 21 $ 4,000 $ 12,788 825 22 $ 7,000 $ 13,563 875 23 $ 3,000 $ 3,100 200 The predetermined overhead rate for 2024 is based on the company's estimated total manufacturing overhead during all of 2024 which is $1,265,125 and the estimated total direct labor hours of 34,900. The owner of the company does not have an accounting background and doesn't understand how the balances of the inventory accounts are calculated nor how gross profit is calculated. The owner asked you to prepare a single spreadsheet providing the inventory balances and gross profit for January 2024. Your Excel Spreadsheet must include formulas, formatted cells and at least once text box. Tasks: 1. Correctly calculate predetermined overhead rate to be used in January 2024. 2. Correctly calculate the balances of the inventory accounts at January 31, 2024 indicating which jobs are included in the balance as applicable. 3. Correctly calculate gross profit for January 2024 indicating which jobs are included as applicable.
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 9780137689453
1st Edition
Authors: Jennifer Cainas, Celina J. Jozsi, Kelly Richmond Pope
Posted Date:
Students also viewed these accounting questions
-
Data 1 You work for Thunderduck Custom Tables Inc. This is the first month of operations. The company designs and manufactures specialty tables. Each table is specially customized for the customer....
-
CMG uses a normal job order costing system and applies overhead on the basis of direct labor hours. At the beginning of 2022, management estimated that 250,000 direct labor hours would be worked and...
-
A beam of 40-eV electrons traveling in the +x-direction passes through a slit that is parallel to the y-axis and 5.0wide. The diffraction pattern is recorded on a screen 2.5 m from the slit. (a) What...
-
When an i-node is read in from the disk during the process of opening a file, it is put into an i-node table in memory. This table has some fields that are not present on the disk. One of them is a...
-
The cable supports a girder which weighs 850 Determine the tension in the cable at points A,B, and C. 40 ft -100 ft- B 20 ft L
-
Complete the second half of the proof of the "forward price formula with carrying cost". To construct the arbitrage, go long one unit of a forward and short one unit spot. To execute the short, it is...
-
During the current year, Tina purchases a beachfront condominium for $600,000, paying $150,000 down and taking out a $450,000 mortgage, secured by the property. At the time of the purchase, the...
-
In each part below, computer either matrix (or vector) of the given expression where 1 H #= ( -4). I = = (69). /2 represents tensor product. Note: (a) (1 point) H&H (b) (1 point) HOI (c) (1 point) I...
-
Karen is tasked with helping her supervisor decide which method to use when accounting for their companys by-product and two main products, all three of which result from a joint process. At the end...
-
Bob and Vikki are a married couple with $250,000 in assets. $100,000 of their assets were inherited by Vikki during the marriage when her uncle died. They live in Nevada, which is a...
-
The opening inventory at retail for the Intimate department is $395,000. Purchases for the month are $37,500, returns to vendors were $9,200, transfers out to the outlet store were $990, and employee...
-
If there are 400 vacant units on the market, of which you own 40, what is your anticipated capture rate? (Assume no other units come available within this time frame.)
-
Charlotte, a single taxpayer, operates a restaurant as a sole proprietor. In 2022, her business generates income of $160,000, and incurs expenses of $50,000, and $4,000 of qualified dividend income....
-
Tom wants to make a gift of $100,000 cash to his granddaughter Jenny. Tom has $500,000 of exemption remaining. The maximum federal estate tax rate at the time of transfer is 40%. After the automatic...
-
Write about the Ph.D. IN ORGANIZATIONAL LEADERSHIP. 1. How will the attainment of the Ph.D. in Organizational Leadership enhance your ability to fulfill your life purpose? 2. How has your leadership...
-
Swifty company is a publicly held corporation whose $1 par value stock is actively traded at $30 per share. The company issued 3400 shares of stock to acquire land recently advertised at $93000. When...
-
Under IFRS, income statements are required to show: A. Extraordinary items. B. Unusual items. C. Exceptional items. D. None of the above.
-
Set out in Figure 16.10 are summarized balance sheets and income statements for F Co. for 20X1 and 20X2. You are required to: Figure 16.10 a. prepare a table of ratios, covering all aspects of...
-
Earnings is calculated deducting: A. Dividends on ordinary shares. B. Dividends on preference shares. C. Tax expense. D. Interest expense.
Study smarter with the SolutionInn App