At year end, the TOTES accountant prepares a summary of production and inventory data for the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
At year end, the TOTES accountant prepares a summary of production and inventory data for the year (Exhibit 3-B) and a partial income statement with the actual balances of selected accounts (Exhibit 3-C). Variances are calculated in order to adjust cost of goods sold and to provide valuable information to the company's managers Managers analyze factors that contributed to actual costs being different than standard costs This lab requires students to 1) Collect standard cost data from prior labs on a Standard Cost Sheet (Exhibit 3-A). 2) Determine the actual manufacturing overhead rate based on actual data. 3) Calculate variances Step 1: Complete the Standard Cost Sheet (Exhibit 3-A) to record standard costs o Lab 1 Company Overview, Exhibit 2-A, and Exhibit 2-B contain data relative to standard costs o Direct labor efficiency standards must be calculated using information in Exhibit 2-A o Manufacturing overhead standards per machine-hour appear on Exhibit 2-A EXHIBIT 3-A: Standard Cost Sheet Direct Materials (Company Overview) Fabric Webbing Direct Labor (Exhibit 2-A &Company Overview) Cutting Sewing Printing Total Manufacturing Overhead (Exhibit 2-A) Total Manufacturing Overhead Standard Qty. per tote Standard DLH per tote Standard MH per tote 16 1000004 Standard Cost per yard Standard Rate per DLH Standard Rate per MH $ (PDOHR) Step 2: Read the lab carefully. Step 3: Complete Exhibit 3-A, the Standard Cost Card. Data will be found in multiple locations as stated in the lab instructions. Carry data to four (4) decimal places. EXHIBIT 1-A: Classify costs as Period or Product (DM, DL or MOH) T.O.T.E.S. + Estimated Revenues And Expenses For Upcoming Year Forecasted Sales in units 500,000 ACCOUNT NAME Sales Revenue Expenses Administrative Office Supplies Administrative Staff, eg, accountant, etc. Adminstrative Payroll and Fringe Advertising, Trade Shows, Travel & Entertainment Company Labels Depreciation Admin. Furniture & Equipment Depreciation Sewing Machines & Cutting Machines Equipment Lease-Administrative Offices Executive Salaries Fabric Factory Utilities (mixed cost) Freight & Postage-Administrative. Insurance Company Liability Insurance Plant Legal & Professional Logo Ink Plant Maintenance Supervisor Plant Manager Rent Administrative Building Rent-Plant Building Repairs and Maintenance - Plant Sales Commissions Sales Salaries Shipping and Handling of Finished Product (Selling) Thread Wages Cutting Department Wages Printing Department Wages-Sewing Department Webbing 4 Period AMOUNT Cost DM $2,475,000 3,600X 125,000 X 115,800 X 46,000 X 4,200 2,450 X 7,600 5,000 X 160,000 X 600,000 38,000 2,500 9,000 14,000 XXXX X CLASSIFY COST (put on Xin the correct column) Product Cost 5,000 26,000 32,000 68,000 11,000 X 42,000 27,000 99,000 12,000 40,350 50,000 120,000 7,500 80,000 570,000 Hint: There are 15 product costs, 5 of which are direct. X X X X DL MOH X X X X X Use Excel file for Lab 1 (found on Blackboard) lab so that you can correct any errors. Summarize the results on Exhibit 1-B below. EXHIBIT 1-B: Operating Budget Summary HINTS: Use Excel file to determine totals. Include all PRODUCT costs in COGS for a traditional income statement. Include all PERIOD expenses. + SALES REVENUES COST OF GOODS SOLD (COGS) Direct Materials Direct Labor Manufacturing Overhead (MOH) TOTAL COST OF GOODS SOLD (PRODUCT COSTS) GROSS MARGIN SELLING & ADMINSTRATIVE COSTS Total Selling Total Administrative T.O.T.E.S. Operating Budget Summary - 20XX at Standard TOTAL SELLING & ADMIN. COSTS (PERIOD COSTS) OPERATING INCOME (LOSS) 4 $2,475,000 $1.170.000 $207,500 $308,800 0 $Lilable, 300 3 788,700 $197.350 $439,350 $636,700 $152,000 All information is found in the Company Description and Information section and Lab 1, EXHIBIT 2-A: Calculate Standard Direct Labor Hours, Machine Hours & Predetermined Overhead Rate T.O.T.E.S. CALCULATING STANDARD COSTS Forecasted Production per year 500,000 totes STEP 1: Calculate Standard Direct Labor Hours per tote a. Enter average number of hours worked per week per employee h. Number of weeks plant operates each year c. Number of employees for each activity d. Total Direct labor hours (DLH) per year (a*b*c) e. DLH per tote (Step 1d # totes produced) Round to 4 decimal places STEP 3: Calculate Machine-Hours used per year a 95% of Total Cutting Direct-Labor Hours (from Step 14) DIRECT LABOR ACTIVITY Cutting Sewing Printing 40 40 7.5 STEP 2: Calculate Estimated Cutting Machine-Hours (MH) per tote a. Production capacity for ONE cutting machine b. Machine-hours per tote (1+ Step 2a amount) Round to 4 decimal places Fale 10 50 50 3 10.000 4.000 375 10-016/0.0080.000e 16.700 STEP 4: Calculate Predetermined Overhead Rate (PDOHR) and Standard MOH per tote a Total Estimated Manufacturing Overhead (from Exhibit 1-8) b. Total machine-hours per year (from Step 3A) $ 308.800 5,700 $ 54.1754 c. Predetermined Overhead Rate (Step 4a Step 4b) Round to 4 decimal places totes/Mi MH/tote MH/year MH per MH Calculate the standard cost for each tote for the current year's production level using information from Exhibit 1-A and 1-B. Round all standard costs to four (4) decimal places EXHIBIT 2-8: Standard Cost Card Fabric Webbing Cutting Sewing Printing T.O.T.E.S. CALCULATING STANDARD COSTS Forecasted Production per year 500,000 totes Total Cost (for 500.000 totes) DIRECT MATERIALS Total Direct Materials Cost per Tote (Round to 4 decimal places) S DIRECT LABOR $ Estimated MOH Costs (Round per tote to 4 decimal places) 600,000 $570,000 $1,14 $234 $ $ Total Direct Labor Cost per Tote (Round to 4 decimal places) 80,000 7,500 MANUFACTURING OVERHEAD 11 Standard Cost [cost per tote) $ 0.24 $ S 0.015 1$ 0.415 308,8.00 0.6176 Total Product Cost per Tote (Round to 4 decimal places) $0.1276 Costs for each job are tracked using a Job Cost Record (Exhibit 2-C). The Job Cost Record is found after copies of the Materials Requisition form and Labor Time Records for the period. Use the information on these documents to complete the Job Cost Record for Phineas Phil's Specialty Market order of 1,000 red grocery totes with logos. At year end, the TOTES accountant prepares a summary of production and inventory data for the year (Exhibit 3-B) and a partial income statement with the actual balances of selected accounts (Exhibit 3-C). Variances are calculated in order to adjust cost of goods sold and to provide valuable information to the company's managers Managers analyze factors that contributed to actual costs being different than standard costs This lab requires students to 1) Collect standard cost data from prior labs on a Standard Cost Sheet (Exhibit 3-A). 2) Determine the actual manufacturing overhead rate based on actual data. 3) Calculate variances Step 1: Complete the Standard Cost Sheet (Exhibit 3-A) to record standard costs o Lab 1 Company Overview, Exhibit 2-A, and Exhibit 2-B contain data relative to standard costs o Direct labor efficiency standards must be calculated using information in Exhibit 2-A o Manufacturing overhead standards per machine-hour appear on Exhibit 2-A EXHIBIT 3-A: Standard Cost Sheet Direct Materials (Company Overview) Fabric Webbing Direct Labor (Exhibit 2-A &Company Overview) Cutting Sewing Printing Total Manufacturing Overhead (Exhibit 2-A) Total Manufacturing Overhead Standard Qty. per tote Standard DLH per tote Standard MH per tote 16 1000004 Standard Cost per yard Standard Rate per DLH Standard Rate per MH $ (PDOHR) Step 2: Read the lab carefully. Step 3: Complete Exhibit 3-A, the Standard Cost Card. Data will be found in multiple locations as stated in the lab instructions. Carry data to four (4) decimal places. EXHIBIT 1-A: Classify costs as Period or Product (DM, DL or MOH) T.O.T.E.S. + Estimated Revenues And Expenses For Upcoming Year Forecasted Sales in units 500,000 ACCOUNT NAME Sales Revenue Expenses Administrative Office Supplies Administrative Staff, eg, accountant, etc. Adminstrative Payroll and Fringe Advertising, Trade Shows, Travel & Entertainment Company Labels Depreciation Admin. Furniture & Equipment Depreciation Sewing Machines & Cutting Machines Equipment Lease-Administrative Offices Executive Salaries Fabric Factory Utilities (mixed cost) Freight & Postage-Administrative. Insurance Company Liability Insurance Plant Legal & Professional Logo Ink Plant Maintenance Supervisor Plant Manager Rent Administrative Building Rent-Plant Building Repairs and Maintenance - Plant Sales Commissions Sales Salaries Shipping and Handling of Finished Product (Selling) Thread Wages Cutting Department Wages Printing Department Wages-Sewing Department Webbing 4 Period AMOUNT Cost DM $2,475,000 3,600X 125,000 X 115,800 X 46,000 X 4,200 2,450 X 7,600 5,000 X 160,000 X 600,000 38,000 2,500 9,000 14,000 XXXX X CLASSIFY COST (put on Xin the correct column) Product Cost 5,000 26,000 32,000 68,000 11,000 X 42,000 27,000 99,000 12,000 40,350 50,000 120,000 7,500 80,000 570,000 Hint: There are 15 product costs, 5 of which are direct. X X X X DL MOH X X X X X Use Excel file for Lab 1 (found on Blackboard) lab so that you can correct any errors. Summarize the results on Exhibit 1-B below. EXHIBIT 1-B: Operating Budget Summary HINTS: Use Excel file to determine totals. Include all PRODUCT costs in COGS for a traditional income statement. Include all PERIOD expenses. + SALES REVENUES COST OF GOODS SOLD (COGS) Direct Materials Direct Labor Manufacturing Overhead (MOH) TOTAL COST OF GOODS SOLD (PRODUCT COSTS) GROSS MARGIN SELLING & ADMINSTRATIVE COSTS Total Selling Total Administrative T.O.T.E.S. Operating Budget Summary - 20XX at Standard TOTAL SELLING & ADMIN. COSTS (PERIOD COSTS) OPERATING INCOME (LOSS) 4 $2,475,000 $1.170.000 $207,500 $308,800 0 $Lilable, 300 3 788,700 $197.350 $439,350 $636,700 $152,000 All information is found in the Company Description and Information section and Lab 1, EXHIBIT 2-A: Calculate Standard Direct Labor Hours, Machine Hours & Predetermined Overhead Rate T.O.T.E.S. CALCULATING STANDARD COSTS Forecasted Production per year 500,000 totes STEP 1: Calculate Standard Direct Labor Hours per tote a. Enter average number of hours worked per week per employee h. Number of weeks plant operates each year c. Number of employees for each activity d. Total Direct labor hours (DLH) per year (a*b*c) e. DLH per tote (Step 1d # totes produced) Round to 4 decimal places STEP 3: Calculate Machine-Hours used per year a 95% of Total Cutting Direct-Labor Hours (from Step 14) DIRECT LABOR ACTIVITY Cutting Sewing Printing 40 40 7.5 STEP 2: Calculate Estimated Cutting Machine-Hours (MH) per tote a. Production capacity for ONE cutting machine b. Machine-hours per tote (1+ Step 2a amount) Round to 4 decimal places Fale 10 50 50 3 10.000 4.000 375 10-016/0.0080.000e 16.700 STEP 4: Calculate Predetermined Overhead Rate (PDOHR) and Standard MOH per tote a Total Estimated Manufacturing Overhead (from Exhibit 1-8) b. Total machine-hours per year (from Step 3A) $ 308.800 5,700 $ 54.1754 c. Predetermined Overhead Rate (Step 4a Step 4b) Round to 4 decimal places totes/Mi MH/tote MH/year MH per MH Calculate the standard cost for each tote for the current year's production level using information from Exhibit 1-A and 1-B. Round all standard costs to four (4) decimal places EXHIBIT 2-8: Standard Cost Card Fabric Webbing Cutting Sewing Printing T.O.T.E.S. CALCULATING STANDARD COSTS Forecasted Production per year 500,000 totes Total Cost (for 500.000 totes) DIRECT MATERIALS Total Direct Materials Cost per Tote (Round to 4 decimal places) S DIRECT LABOR $ Estimated MOH Costs (Round per tote to 4 decimal places) 600,000 $570,000 $1,14 $234 $ $ Total Direct Labor Cost per Tote (Round to 4 decimal places) 80,000 7,500 MANUFACTURING OVERHEAD 11 Standard Cost [cost per tote) $ 0.24 $ S 0.015 1$ 0.415 308,8.00 0.6176 Total Product Cost per Tote (Round to 4 decimal places) $0.1276 Costs for each job are tracked using a Job Cost Record (Exhibit 2-C). The Job Cost Record is found after copies of the Materials Requisition form and Labor Time Records for the period. Use the information on these documents to complete the Job Cost Record for Phineas Phil's Specialty Market order of 1,000 red grocery totes with logos.
Expert Answer:
Answer rating: 100% (QA)
Standard rate per DLH total labour expenses for that departmenttotal number of h... View the full answer
Related Book For
Managerial Accounting An Introduction to Concepts Methods and Uses
ISBN: 978-0324639766
10th Edition
Authors: Michael W. Maher, Clyde P. Stickney, Roman L. Weil
Posted Date:
Students also viewed these accounting questions
-
Problem 4. (12 pts. Hip implant design and material mechanics.) A metal hip implant has a femoral head, neck, and stem for insertion into the femur with geometry shown in the Figure. The neck region...
-
On Tuesday 4 October this year, the Minister for the Environment, Tanya Plibersek, announced a new strategy to protect Australias threatened plant and animal species. The Saving Native Species Plan...
-
False QUESTION 16 The balance in the prepaid rent account before adjustment at the end of the year is $32,000, which represents four months' rent paid on December 1. The adjusting entry required on...
-
One item is omitted in each of the following summaries of balance sheet and income statement data for the following four different corporations: Determine the missing amounts, identifying them...
-
Jellico Inc.s projected operating income (based on sales of 450,000 units) for the coming year is as follows: Total____ Sales ............... $11,700,000 Total variable cost ........ 8,190,000...
-
Describe and distinguish between qualitative and quantitative forecasting techniques. When should each of these forecasting techniques be used?
-
Recall, there is some disincentive for parties to elect a trial de novo after receiving an adverse arbitration award. Further investigate CCP 1141.21 and determine the costs and fees that the party...
-
Manon Corporation applies ASPE and sponsors a defined benefit pension plan. The following pension plan information is available for 2017 and 2018: The pension fund paid out benefits in each year....
-
The Knights of St. John set up a ship maintenance machinery at the Grand harbour. What is it called anmd how did it function please?
-
On March 1, 2008, Ginny Tyler established Seltzer Realty. Ginny completed the following transactions during the month of March: a. Opened a business bank account with a deposit of $30,000 from...
-
Qiang places the amount of $42 in a special bank account that guarantees to provide $150 in 11 years. What rate of return would Qiang earn on this opportunity? r = % Your answer should be in...
-
How does Dyson's vision, mission and values influence Dyson's vision to follow product orientation?
-
How to Evaluate & Measure Employee Performance?
-
Assume demand for webcams at Logitech is constant at 848 units per month. Logitech incurs a fixed order cost of $2374 each time it places an order. The holding cost per unit per year is 23% of the...
-
How Student actively participates in the continuous improvement to risk management in a business?
-
How do write Dear Gawaar, Global Network Members In light of this, I have created a Gawaar Global Network Messenger account ensuring that our communication remains uninterrupted. As you all know I...
-
I. For each of the following functions, do the following: a. Determine if f is continuous at a. b. Determine if f is differentiable at a. 1. 5-6x if x3 f(x)=-4-x ifx>3 ; a=3 4. f(x)= x-9 if x <3 ;a=3...
-
d) For die casting processes: 1. What are the most common metals processed using die casting and discuss why other metals are not commonly die casted? 2. Which die casting machines usually have a...
-
Match each of the following performance measures to one or more of the four perspectives of the balanced scorecard. Note that a performance measure could measure performance for more than...
-
Refer to the data in Exercise 30. Assume that the cost assigned to beginning inventory on April 1 was $80,000 and that the department incurred $300,000 of production costs during April. Prepare a...
-
Select one of the following companies (or any company of your choosing) and use the Internet to explore the companys most recent annual report. American Airlines (www.americanair.com) Intel...
-
a. State the functions that apply to cash disbursements transactions. b. For each cash disbursements function, indicate (1) the department that performs the function and (2) the principal document or...
-
For each function pertaining to cash disbursements transactions, indicate the applicability, if any, of (a) proper authorization (b) independent checks.
-
a. What is the direction of testing controls for purchases transactions that pertains to the existence or occurrence assertion? b. What is the direction of testing controls for purchases transactions...
Study smarter with the SolutionInn App