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...
-
A propped cantilever beam of length 2L is loaded by a uniformly distributed load with intensity q. The beam is supported at B by a linearly elastic rotational spring with stiffness kR, which provides...
-
The comparative statements of financial position for Hinckley SA include the following information. Additional data related to 2019 are as follows. 1. Equipment that had cost ¬11,000 and was 40%...
-
What are the distinct parts of an insurance policy?
-
The European Division of Worldwide Reference Corporation produces a pocket dictionary containing popular phrases in six European languages. Annual budget data for the coming year follow. Projected...
-
A. (4 pts.) Find the flux through the rectangular loop, in terms of the current I(t). B. (3 pts.) Find the current induced at t = 0 s. C. (3 pts.) Suppose the current was constant (I = 10), but the...
-
Halcrow, Inc. expects to replace a downtime tracking system currently installed on CNC machines. The challenger system has a first cost of $70,000, an estimated AOC of $20,000 the first year...
-
a 65 mm diameter solid shaft is to be welded to a flat plate by a fillet weld around the circumference of the shaft. Determine the size of the weld if the torque on the shaft is 3kN-m. The allowable...
-
1. Exactly five years ago, Lee Corp. issued bonds with an original maturity of 25 years.These bonds pay interest semiannually, and have a fixed coupon rate of 6.5%.These bonds are currently trading...
-
A hedge fund wants to borrow $2,500,000 using a 3 month repurchase agreement. The repo dealer is quoting a buyback price of $2,533,414.86 and a haircut of 2.49%. What is the market value of the...
-
A company's capital structure weights are 20% debt and 80% equity. If the company's cost of equity is 13% and it's after-tax cost of debt is 6%, what is the WACC for this company? Do not round...
-
A long term care policy has a thirty day elimination period for community based care. Judy has received three medical visits a week for five weeks at her assisted living facility to treat a chronic...
-
Someone offers to sell you an annuity for $6,036 in 5 years (i.e., you will buy it at t=5). The annuity pays $2300 per year, for n years, starting in year 6, and we assume a 7.0% discount rate. About...
-
The function P(x)=0.35x-73 models the relationship between th e number of pretzels x that a certain vendor sells and the profit the vendor makes. Find P(1,000), the profit the vendor makes from...
-
Write the expression in radical notation. Then evaluate the expression when the result is an integer. 23 -1/2
-
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...
-
What is the primary business of Satyam Computer Services Ltd?
-
In January 2009, approximately how many employees did Satyam Computer Services employ?
-
What was the cash balance sheet amount and how much cash actually existed in the Satyams bank accounts?
Study smarter with the SolutionInn App