Calculating Cost of Goods Manufactured and Cost of Goods Sold using Excel's SUM and Basic Math...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Calculating Cost of Goods Manufactured and Cost of Goods Sold using Excel's SUM and Basic Math Functions Paste FILE Clipboard Al 1. Calculate and dispose of overapplied or underapplied manufacturing overhead. 2. Calculate the cost of goods manufactured and cost of goods sold. 3. Prepare an income statement for a manufacturing firm. 10 HOME 11 Calibri INSERT PAGE LAYOUT BIU- Font BB- X 9 Actual costs for the year: 5 Estimated total overhead costs 6 Estimated total direct labor hours 7 Actual total direct labor hours 8 11 Cost of Goods Manufactured and Cost of Goods Sold-Excel DATA REVIEW VIEW Purchase of raw (direct) materials Direct labor cost 12 Manufacturing overhead 13 D 1 Stanford Enterprises uses job-order costing. 2 Overhead is applied on the basis of direct labor hours. 3 The following information relates to the year just ended. 4 Data: A A f FORMULAS % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Stanford Enterprises uses job-order costing. E $ $ $ S 275,000 25,000 27,760 375,000 536,300 302.750 < Prev F 11 of 11 G Cells 200 Editing H Next > Sign In B D 1 Stanford Enterprises uses job-order costing. 2 Overhead is applied on the basis of direct labor hours. 3 The following information relates to the year just ended. 4 Data: 5 Estimated total overhead costs 6 Estimated total direct labor hours 7 Actual total direct labor hours 8 9 Actual costs for the year: 10 Purchase of raw (direct) materials 11 Direct labor cost 12 Manufacturing overhead 13 14 Inventories: 15 16 17 18 19 Ise the data to answer the following. Raw Materials (All Direct) Work in Process Finished Goods $ Beginning $ 15,000 $ 27,875 34,600 $ $ $ E 275,000 25,000 27,760 375,000 536,300 302,750 Ending 11,375 22,350 26,450 FL G H A B 20 21 1. Overhead: 22 Actual overhead cost 23 Predetermined overhead rate 24 25 26 27 28 Actual direct labor hours Total overhead applied (Over) or under applied overhead 29 2. Prepare a schedule of cost of goods manufactured: 30 31 32 Direct materials: 33 Beginning raw materials inventory Plus: Raw materials purchased 34 35 Less: Ending raw materials inventory 36 Raw materials used in production 37 Direct labor D Stanford Enterprises Cost of Goods Manufactured Report 38 Manufacturing overhead applied 39 Total current manufacturing costs Sheet1 40 Plus: Beginning work in process inventory 41 Less: Ending work in process inventory Cost of goods manufactured 42 43 E F G H A1 61 B 4 Font 44 3. Prepare an income statement. 45 46 D 40 Plus: Beginning work in process inventory 41 Less: Ending work in process inventory Cost of goods manufactured 42 43 51 52 53 54 Adjusted cost of goods sold 55 Gross Profit READY Attemptie) f 47 Sales revenue 48 Less: Cost of Goods Sold 49 Finished goods inventory, beginning 50 Plus: Cost of goods manufactured Less: Ending finished goods inventory Unadjusted cost of goods sold Underapplied (overapplied) overhead Sheet1 Stanford Enterprises uses job-order costing. F Stanford Enterprises Income Statement 56 Less: Selling, general, and administrative expenses (10% of Sales) 57 Net Operating Income 58 59 60 Format as Cell Formatting Table Styles Styles E G Cells $ 1,500,000 E Editing H Hinh - 100% + Shall Ma Calculating Cost of Goods Manufactured and Cost of Goods Sold using Excel's SUM and Basic Math Functions Paste FILE Clipboard Al 1. Calculate and dispose of overapplied or underapplied manufacturing overhead. 2. Calculate the cost of goods manufactured and cost of goods sold. 3. Prepare an income statement for a manufacturing firm. 10 HOME 11 Calibri INSERT PAGE LAYOUT BIU- Font BB- X 9 Actual costs for the year: 5 Estimated total overhead costs 6 Estimated total direct labor hours 7 Actual total direct labor hours 8 11 Cost of Goods Manufactured and Cost of Goods Sold-Excel DATA REVIEW VIEW Purchase of raw (direct) materials Direct labor cost 12 Manufacturing overhead 13 D 1 Stanford Enterprises uses job-order costing. 2 Overhead is applied on the basis of direct labor hours. 3 The following information relates to the year just ended. 4 Data: A A f FORMULAS % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Stanford Enterprises uses job-order costing. E $ $ $ S 275,000 25,000 27,760 375,000 536,300 302.750 < Prev F 11 of 11 G Cells 200 Editing H Next > Sign In B D 1 Stanford Enterprises uses job-order costing. 2 Overhead is applied on the basis of direct labor hours. 3 The following information relates to the year just ended. 4 Data: 5 Estimated total overhead costs 6 Estimated total direct labor hours 7 Actual total direct labor hours 8 9 Actual costs for the year: 10 Purchase of raw (direct) materials 11 Direct labor cost 12 Manufacturing overhead 13 14 Inventories: 15 16 17 18 19 Ise the data to answer the following. Raw Materials (All Direct) Work in Process Finished Goods $ Beginning $ 15,000 $ 27,875 34,600 $ $ $ E 275,000 25,000 27,760 375,000 536,300 302,750 Ending 11,375 22,350 26,450 FL G H A B 20 21 1. Overhead: 22 Actual overhead cost 23 Predetermined overhead rate 24 25 26 27 28 Actual direct labor hours Total overhead applied (Over) or under applied overhead 29 2. Prepare a schedule of cost of goods manufactured: 30 31 32 Direct materials: 33 Beginning raw materials inventory Plus: Raw materials purchased 34 35 Less: Ending raw materials inventory 36 Raw materials used in production 37 Direct labor D Stanford Enterprises Cost of Goods Manufactured Report 38 Manufacturing overhead applied 39 Total current manufacturing costs Sheet1 40 Plus: Beginning work in process inventory 41 Less: Ending work in process inventory Cost of goods manufactured 42 43 E F G H A1 61 B 4 Font 44 3. Prepare an income statement. 45 46 D 40 Plus: Beginning work in process inventory 41 Less: Ending work in process inventory Cost of goods manufactured 42 43 51 52 53 54 Adjusted cost of goods sold 55 Gross Profit READY Attemptie) f 47 Sales revenue 48 Less: Cost of Goods Sold 49 Finished goods inventory, beginning 50 Plus: Cost of goods manufactured Less: Ending finished goods inventory Unadjusted cost of goods sold Underapplied (overapplied) overhead Sheet1 Stanford Enterprises uses job-order costing. F Stanford Enterprises Income Statement 56 Less: Selling, general, and administrative expenses (10% of Sales) 57 Net Operating Income 58 59 60 Format as Cell Formatting Table Styles Styles E G Cells $ 1,500,000 E Editing H Hinh - 100% + Shall Ma
Expert Answer:
Related Book For
Cost Accounting Foundations and Evolutions
ISBN: 978-1111626822
8th Edition
Authors: Michael R. Kinney, Cecily A. Raiborn
Posted Date:
Students also viewed these accounting questions
-
Prepare an income statement for a profitable small business. Include at least 10 operating expenses. Use an income tax rate of 25%.
-
Calculate cost of goods manufactured and cost of goods sold from the following account balances relating to 2015 (in millions): Property tax on plant...
-
Following is a statement of cost of goods manufactured for Pratas Manufacturing, Inc. Because the records that support this statement were destroyed by water damage caused by a collapsed roof, fill...
-
If a= 3 m, determine the magnitudes of P and Q required to maintain the cable in the shape shown. DI 120 kN
-
Distinguish between errors and irregularities. Which do you think concern auditors the most?
-
Century Communications, Inc., began 2018 with 290,000 shares of $1 par common stock issued and outstanding. Beginning Paid-in Capital in Excess of ParCommon was $580,000, and retained earnings was...
-
The Racial Divide The website http://vallandingham.me/racial_divide/\#pt uses data from the US Census to visualize where whites and blacks live in different cities. Figure 2.98 gives a heat map of...
-
Consider the unadjusted trial balance of Princess, Inc., at December 31, 2020, and the related month-end adjustment data. Adjustment data at December 31, 2020: a. Accrued service revenue at December...
-
The goal in this problem is to estimate the strength of an interatomic bond in silver. We will model a thin, silver wire as parallel chains of springs, and each spring will represent an interatomic...
-
The comparative financial statements of Vision International, Inc., are as follows. The market price of Vision International, Inc., common stock was $20 on December 31, 2007. Instructions Determine...
-
Choose the correct ground state term symbol of high spin octahedral Ir**. 3+ A)'F B)'D C) *F D) 'S
-
Telford Engineers plc, a medium-sized manufacturer of automobile components, has decided to modernise its factory by introducing a number of robots. These will cost 20 million and will reduce...
-
Saeed made the following purchases of ordinary shares in Hyban plc: In June 2017, the company made a 1 for 20 rights issue at 1.50 per share and Saeed took up the shares which he was offered....
-
Boswell Enterprises Ltd is reviewing its trade credit policy. The business, which sells all of its goods on credit, has estimated that sales revenue for the forthcoming year will be 3 million under...
-
Virtual randomization requires the timezero average for feral hosts to be the same as that for giant runts, but the temporal trends are otherwise unconstrained. It appears that the model matrix...
-
Following are some illustrative numbers for benefits and costs arising from a program to restrict emissions of a pollutant. Current emissions are 10 tons per month. Identify the emission level at...
-
Question: A chemical reactor operates at steady-state and receives a feed stream containing 100 kg/hr of a reactant with a mass fraction of 0.2. The reactant undergoes a reaction in the reactor,...
-
For the following exercises, write the polynomial function that models the given situation. Consider the same rectangle of the preceding problem. Squares of 2x by 2x units are cut out of each corner....
-
Always Christmas makes artificial Christmas trees in two departments: Cutting and Boxing. In the Cutting Department, wire wrapped with green "needles" is placed into production at the beginning of...
-
A portion of the costs incurred by business organizations is designated as direct labor cost. As used in practice, the term direct labor cost has a wide variety of meanings. Unless the meaning...
-
Joe Giles is a product engineer for a firm that makes various home and office electronic gadgets. Some of this company's products have long product life cycles and others have life cycles that are as...
-
With reference to Exercise 4.5, find an expression for the distribution function \(F(x)\) of the random variable. Data From Exercise 4.5 k 4.5 Given that f(x): = is a probability distribution for 2x...
-
Given that \(f(x)=\frac{k}{2^{x}}\) is a probability distribution for a random variable that can take on the values \(x=\) \(0,1,2,3\), and 4 , find \(k\).
-
Check whether the following can define probability distributions and explain your answers. (a) \(f(x)=\frac{1}{4}\) for \(x=10,11,12,13\) (b) \(f(x)=\frac{2 x}{5}\) for \(x=0,1,2,3,4,5\) (c)...
Study smarter with the SolutionInn App