Stanford Enterprises has provided its manufacturing estimated and actual data for the year end. The Controller...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Stanford Enterprises has provided its manufacturing estimated and actual data for the year end. The Controller has asked you to compute the predetermined overhead rate, the schedule of cost of goods manufactured, and the schedule of cost of goods sold. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=E5" was entered, the formula would output the result from cell E5, or $275,000 in this example. • Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), (asterisk sign to multiply), and / (forward slash to divide). From the Excel Simulation below, if in a blank cell "=E6+E7" was entered, the formula would add the values from those cells and output the result, or 52,760 in this example. If using the other math symbols the result would output an appropriate answer for its function. • SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to utilize this function. From the Excel Simulation below, if in a blank cell "=SUM(E10,E11,E12)" was entered, the formula would output the result of adding those three separate cells, or 1,214,050 in this example. Similarly, if in a blank cell "=SUM(E10:E12)" was entered, the formula would output the same result of adding those cells, except they are expressed as a range in the formula, and the result would be 1,214,050 in this example. Cost of Goods Manufactured and Cost of Goods Sold - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In V Ruler V Formula Bar Normal Page Break Page Custom Preview Layout Views Zoom 100% Zoom to Selection V Gridlines Headings Window Macros Workbook Views Show Zoom Macros A1 fe Stanford Enterprises uses job-order costing. A B D E F G H 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 6 Estimated total direct labor hours 7 Actual total direct labor hours $ 275,000 25,000 27,760 8 9 Actual costs for the year: 10 Purchase of raw materials (all direct) $375,000 11 Direct labor cost $536.300 12 Manufacturing overhead costs $302,750 13 Ending 11,375 14 Inventories: Beginning 15 Raw materials (all direct) 15.000 $ Work in process 27,875 $ 22.350 16 17 Finished goods 34,600 2$ 26,450 18 19 Use the data to answer the following. 20 21 1. Compute applied overhead and determine the amount of underapplied or overapplied overhead: 22 Actual manufacturing overhead cost 23 Predetermined overhead rate 24 Actual direct labor hours 25 Manufacturing overhead applied 26 27 Underapplied (overapplied) manufacturing overhead 28 29 2. Prepare a schedule of cost of goods manufactured: 30 31 Stanford Enterprises 32 Schedule of Cost of Goods Manufactured 33 Direct materials: 34 Raw materials inventory, beginning 35 Add: Purchases of raw materials 36 Total raw materials available 37 Deduct: Raw materials inventory, ending 38 Raw materials used in production 39 Direct labor 40 Manufacturing overhead applied to work in process 41 Total manufacturing costs 42 Add: Beginning work in process inventory 43 44 Deduct: Ending work in process inventory 45 Cost of goods manufactured 46 47 3. Prepare a schedule of cost of goods sold. 48 49 Stanford Enterprises 50 Schedule of Cost of Goods Sold 51 52 Finished goods inventory, beginning 53 Add: Cost of goods manufactured 54 Cost of goods available for sale 55 Deduct: Finished goods inventory, ending 56 Unadjusted cost of goods sold 57 Underapplied (overapplied) overhead 58 Adjusted cost of goods sold 59 60 Stanford Enterprises has provided its manufacturing estimated and actual data for the year end. The Controller has asked you to compute the predetermined overhead rate, the schedule of cost of goods manufactured, and the schedule of cost of goods sold. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=E5" was entered, the formula would output the result from cell E5, or $275,000 in this example. • Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), (asterisk sign to multiply), and / (forward slash to divide). From the Excel Simulation below, if in a blank cell "=E6+E7" was entered, the formula would add the values from those cells and output the result, or 52,760 in this example. If using the other math symbols the result would output an appropriate answer for its function. • SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to utilize this function. From the Excel Simulation below, if in a blank cell "=SUM(E10,E11,E12)" was entered, the formula would output the result of adding those three separate cells, or 1,214,050 in this example. Similarly, if in a blank cell "=SUM(E10:E12)" was entered, the formula would output the same result of adding those cells, except they are expressed as a range in the formula, and the result would be 1,214,050 in this example. Cost of Goods Manufactured and Cost of Goods Sold - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In V Ruler V Formula Bar Normal Page Break Page Custom Preview Layout Views Zoom 100% Zoom to Selection V Gridlines Headings Window Macros Workbook Views Show Zoom Macros A1 fe Stanford Enterprises uses job-order costing. A B D E F G H 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 6 Estimated total direct labor hours 7 Actual total direct labor hours $ 275,000 25,000 27,760 8 9 Actual costs for the year: 10 Purchase of raw materials (all direct) $375,000 11 Direct labor cost $536.300 12 Manufacturing overhead costs $302,750 13 Ending 11,375 14 Inventories: Beginning 15 Raw materials (all direct) 15.000 $ Work in process 27,875 $ 22.350 16 17 Finished goods 34,600 2$ 26,450 18 19 Use the data to answer the following. 20 21 1. Compute applied overhead and determine the amount of underapplied or overapplied overhead: 22 Actual manufacturing overhead cost 23 Predetermined overhead rate 24 Actual direct labor hours 25 Manufacturing overhead applied 26 27 Underapplied (overapplied) manufacturing overhead 28 29 2. Prepare a schedule of cost of goods manufactured: 30 31 Stanford Enterprises 32 Schedule of Cost of Goods Manufactured 33 Direct materials: 34 Raw materials inventory, beginning 35 Add: Purchases of raw materials 36 Total raw materials available 37 Deduct: Raw materials inventory, ending 38 Raw materials used in production 39 Direct labor 40 Manufacturing overhead applied to work in process 41 Total manufacturing costs 42 Add: Beginning work in process inventory 43 44 Deduct: Ending work in process inventory 45 Cost of goods manufactured 46 47 3. Prepare a schedule of cost of goods sold. 48 49 Stanford Enterprises 50 Schedule of Cost of Goods Sold 51 52 Finished goods inventory, beginning 53 Add: Cost of goods manufactured 54 Cost of goods available for sale 55 Deduct: Finished goods inventory, ending 56 Unadjusted cost of goods sold 57 Underapplied (overapplied) overhead 58 Adjusted cost of goods sold 59 60
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
8(ppm) = (i) 0.92 (3H, d, J = 7.0 Hz) 1.14 (6H, s) 1.18 (1H, dd, J = 13.3, 10.0 Hz) 1.25 (1H, dd, J = 13.3, 2.1 Hz) 1.54 (1H, m) 2.00 (1H, ddd, J = 13.5, 11.3, 10.0 Hz) 2.33 (1H, ddd, J = 13.5, 6.6,...
-
Refer to the schedule of cost of goods manufactured prepared for Huron Corporation in the preceding problem. Required: 1. How much of the manufacturing costs incurred during 20x2 remained associated...
-
Refer to the schedule of cost of goods manufactured prepared in problem 2.39. Problem 2.39 data Required: 1. How much of the manufacturing costs incurred during the current year remain in work in...
-
Panettones are fluffy dome-shaped Italian cakes popular during the holiday season. For Balucis Bakery in Milan, sales of panettones in December account for 50% of its income for the year. The bakery...
-
An American insurance company issued $10 million of one-year, zero-coupon GICs (guaranteed investment contracts) denominated in Swiss francs at a rate of 5 percent. The insurance company holds no SF...
-
Veda Storey and Gordon Rogers have a partnership agreement with the following provisions for sharing profit or loss: 1. A salary allowance of $30,900 to Storey and $39,700 to Rogers 2. An interest...
-
Which of the following assertion is inaccurate concerning the risks of material misstatement? (a) Risks of material misstatement can arise from a variety of sources, including external factors (b)...
-
The following information pertains to Mason Company for 2016: Beginning inventory ...... 90 units @ $40 Units purchased ........310 units @ $45 Ending inventory consisted of 30 units. Mason sold 370...
-
pleasecomplete all 3 sub questions. The Regal Cycle Company manufactures three types of bicycles-a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter...
-
One technique for limiting fault current is to place reactance in series with the generators. Such reactance can be modeled in PowerWorld Simulator by increasing the value of the generator's positive...
-
During its 2018 year of assessment Peter (Pty) Ltd borrowed R3,5 million from ABC Bank to acquire new plant and machinery used in a process of manufacture. During the 2019 year of assessment, Peter...
-
Compose an Essay Write an essay to describe how the government protects individuals against discrimination. Your essay should include at least four paragraphs. In the first paragraph, explain an...
-
Mr Coetzee works for an advertising company, Litaba Ltd. In his spare time, he writes articles for an online news website, Lesedi News. On this website he publishes an article (which he wrote from...
-
Polaski Company manufactures and sells a single product called a Ret. Operating at capacity, the company can produce and sell 30,000 Rets per year. Costs associated with this level of production and...
-
Lopez Apparels reports a operating profit of R10,000 during the month under absorption costing. It had no opening inventory. It manufactured 1,000 units during the month and sold 800 units. It has a...
-
1) Briefly describe and review one actual capital project/product failure either from your personal/work experiences, a web article, this week's learning resources, or other financial literature. 2)...
-
Question 20 (5 points) Glean & Co., a well-established law firm, provided 500 hours of its time to Video Corporation in exchange for 1,000 shares of Video's $5 par common stock. Glean's usual bill...
-
Choose two matrices A and B with dimension 2 x 2. Calculate det A, det B, and det (AB). Repeat this process until you are able to discover how these three determinants are related. Summarize your...
-
Sandy Johnson owns a small variety store. The following transactions took place during March of the current year. Journalize the transactions in a general journal using the perpetual inventory...
-
In a period of rising prices, which inventory method will result in: (a) The highest cost of goods sold? (b) The lowest cost of goods sold? (c) The highest ending inventory ? (d) The lowest ending...
-
INCOME STATEMENT WITH DEPARTMENTAL DIRECT OPERATING MARGIN AND TOTAL OPERATING INCOME Tom Peterson owns the business Peterson's Furniture and Appliances. The following information is provided for the...
-
Imagine that you have \($10,000\) to invest. Use a newspaper, the Internet, or other source to select a mutual fund. Use the same source to fi nd out how much gold you could buy for \($10,000\)....
-
Animation art, hand-painted images from which cartoons used to be made, is a popular collectible.
-
The PBS television program, Antiques Roadshow, has generated enormous interest among viewers to find out the value of the furniture, art, jewelry, and collectibles they own.
Study smarter with the SolutionInn App