Homework Help is Here – Start Your Trial Now!
Business
Accounting
X FILE Paste Clipboard H5 1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold. HOME Calibri 23 24 INSERT BIU I Font X 11 Cost of Goods Manufactured and Cost of Goods Sold - Excel FORMULAS DATA REVIEW VIEW PAGE LAYOUT fx B с 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 3 Raw materials (all direct) Work in process Finished goods 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost 6 Estimated total direct labor hours 7 Actual total direct labor hours 8 9 Actual costs for the year: 10 11 12 13 14 Inventories: 15 16 17 18 19 Use the data to answer the following. 20 % Alignment Number Purchase of raw materials (all direct) Direct labor cost Manufacturing overhead costs D Cell Conditional Format as Formatting Table Styles Styles E $ 275,000 25,000 27,760 $375,000 $536,300 $302,750 Ending Beginning $ 15,000 $ $ 27,875 $ $ 34,600 $ 26,450 11,375 22,350 F Cells 21 1. Compute applied overhead and determine the amount of underapplied or overapplied overhead: 22 Actual manufacturing overhead cost Predetermined overhead rate Actual direct labor hours ? 26 Editing G I 0 Sign In H X < <

X FILE Paste Clipboard H5 1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold. HOME Calibri 23 24 INSERT BIU I Font X 11 Cost of Goods Manufactured and Cost of Goods Sold - Excel FORMULAS DATA REVIEW VIEW PAGE LAYOUT fx B с 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 3 Raw materials (all direct) Work in process Finished goods 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost 6 Estimated total direct labor hours 7 Actual total direct labor hours 8 9 Actual costs for the year: 10 11 12 13 14 Inventories: 15 16 17 18 19 Use the data to answer the following. 20 % Alignment Number Purchase of raw materials (all direct) Direct labor cost Manufacturing overhead costs D Cell Conditional Format as Formatting Table Styles Styles E $ 275,000 25,000 27,760 $375,000 $536,300 $302,750 Ending Beginning $ 15,000 $ $ 27,875 $ $ 34,600 $ 26,450 11,375 22,350 F Cells 21 1. Compute applied overhead and determine the amount of underapplied or overapplied overhead: 22 Actual manufacturing overhead cost Predetermined overhead rate Actual direct labor hours ? 26 Editing G I 0 Sign In H X < <

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question
X Paste Clipboard FILE H5 1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold. 15 56 HOME A Calibri 의 INSERT BI U ▾ 11 12 13 14 Inventories: 1 9 Actual costs for the year: 10 READY ▾ Font 6 Estimated total direct labor hours 7 Actual total direct labor hours 8 Raw materials (all direct) 16 Work in process 17 Finished goods 18 11 B с 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 3 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost PAGE LAYOUT Cost of Goods Manufactured and Cost of Goods Sold - Excel DATA REVIEW VIEW A A Purchase of raw materials (all direct) Direct labor cost Manufacturing overhead costs fx 19 Use the data to answer the following. 20 Predetermined overhead rate Actual direct labor hours Sheet1 G FORMULAS % Alignment Number D Beginning $ $ $ Conditional Format as Cell Formatting Table Styles Styles E T $ 275,000 25,000 27,760 $375,000 $536,300 $302,750 Ending $ 11,375 15,000 27,875 $ 22,350 34,600 $ 26,450 F 21 1. Compute applied overhead and determine the amount of underapplied or overapplied overhead: 22 Actual manufacturing overhead cost 23 24 Cells Editing G I Sign In H u + ► < 100%
Transcribed Image Text:X Paste Clipboard FILE H5 1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold. 15 56 HOME A Calibri 의 INSERT BI U ▾ 11 12 13 14 Inventories: 1 9 Actual costs for the year: 10 READY ▾ Font 6 Estimated total direct labor hours 7 Actual total direct labor hours 8 Raw materials (all direct) 16 Work in process 17 Finished goods 18 11 B с 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 3 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost PAGE LAYOUT Cost of Goods Manufactured and Cost of Goods Sold - Excel DATA REVIEW VIEW A A Purchase of raw materials (all direct) Direct labor cost Manufacturing overhead costs fx 19 Use the data to answer the following. 20 Predetermined overhead rate Actual direct labor hours Sheet1 G FORMULAS % Alignment Number D Beginning $ $ $ Conditional Format as Cell Formatting Table Styles Styles E T $ 275,000 25,000 27,760 $375,000 $536,300 $302,750 Ending $ 11,375 15,000 27,875 $ 22,350 34,600 $ 26,450 F 21 1. Compute applied overhead and determine the amount of underapplied or overapplied overhead: 22 Actual manufacturing overhead cost 23 24 Cells Editing G I Sign In H u + ► < 100%
X FILE Paste Clipboard G14 HOME Calibri INSERT BIU Font A B Actual direct labor hours READY PAGE LAYOUT Cost of Goods Manufactured and Cost of Goods Sold - Excel FORMULAS DATA REVIEW VIEW 11 A с Schedule Raw materials inventory, beginning 35 Add: Purchases of raw materials Total raw materials available 24 25 Manufacturing overhead applied 26 27 Underapplied (overapplied) manufacturing overhead 28 29 2. Prepare a schedule of cost of goods manufactured: 30 31 32 33 Direct materials: 34 38 Raw materials used in production 39 Direct labor 36 37 Deduct: Raw materials inventory, ending % Alignment Number D 47 3. Prepare a schedule of cost of goods sold. Sheet1 Stanford Enterprises of Cost of Goods Manufactured 40 Manufacturing overhead applied to work in process 41 Total manufacturing costs 42 Add: Beginning work in process inventory 43 Total cost of work in process 44 Deduct: Ending work in process inventory 45 Cost of goods manufactured 46 Conditional Format as Cell Formatting Table Styles Styles E T E F HI Cells H ? 23 Editing 4 U Sign In H ▶ X < < + 100%
Transcribed Image Text:X FILE Paste Clipboard G14 HOME Calibri INSERT BIU Font A B Actual direct labor hours READY PAGE LAYOUT Cost of Goods Manufactured and Cost of Goods Sold - Excel FORMULAS DATA REVIEW VIEW 11 A с Schedule Raw materials inventory, beginning 35 Add: Purchases of raw materials Total raw materials available 24 25 Manufacturing overhead applied 26 27 Underapplied (overapplied) manufacturing overhead 28 29 2. Prepare a schedule of cost of goods manufactured: 30 31 32 33 Direct materials: 34 38 Raw materials used in production 39 Direct labor 36 37 Deduct: Raw materials inventory, ending % Alignment Number D 47 3. Prepare a schedule of cost of goods sold. Sheet1 Stanford Enterprises of Cost of Goods Manufactured 40 Manufacturing overhead applied to work in process 41 Total manufacturing costs 42 Add: Beginning work in process inventory 43 Total cost of work in process 44 Deduct: Ending work in process inventory 45 Cost of goods manufactured 46 Conditional Format as Cell Formatting Table Styles Styles E T E F HI Cells H ? 23 Editing 4 U Sign In H ▶ X < < + 100%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Cost Sheet
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.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS