I really need help with this item below. I have tried a few different ways to do this problem, but the top box keeps coming back as incorrect. I know that the amounts are correct, but the first box is wrong for some reason. Please read the feedback boxes and include the appropriate formulas and cell references for this item. This is done through Excel. PLEASE HELP!!!!!! Note that the pictures are the same exact problem, but I used two separate formulas to try and solve this problem. Formatting as TableM12fx=(E10*C10+E11*C11+E12*C12)/(C10+C11+C12)ACD EF1 Function: ROUND; Formula: Add, Multiply, Divide; Cell ReferencingMN OPQ23 Using Excel to Cost InventoryStudent Work Area4.5 In its first month of operations, McLanie Company made three purchases.6 Information concerning these purchases and units on hand are:PROBLEMRequired: Provide input into cells shaded in yellow in this template.Use onlymathematical formulas with cell references to compute the unit cost and thecost of ending inventory.UnitsCost per Unit$ 6.00Compute the cost of the ending inventory under the average-cost method ina periodic inventory system.10300114008.00125009.00Weighted-average unit costIncorrect137.9166714Units on hand at period endFeedback: The cost of each purchase is determinedby multiplying the cost per unit by the unitsacquired. These purchase cost amounts are addedand divided by the total units of the three purchases.All amounts must be cell referenced to the Problemarea and formulas must be used to add, multiple anddivide the respective amounts.200Round unit cost to 3 decimals using the7.91715ROUND function16 Purchases of merchandise were made in the sequence listed above.17Cost of ending inventory$1,583.40181920%24 00.00 0Conditional FormatFormatting as TableM12fx=G13/C13CD EFH1 Function: ROUND; Formula: Add, Multiply, Divide; Cell ReferencingLMN O3 Using Excel to Cost InventoryStudent Work AreaRequired: Provide input into cells shaded in yellow in this template.Use onlymathematical formulas with cell references to compute the unit cost and the4.PROBLEM5 In its first month of operations, McLanie Company made three purchases.6 Information concerning these purchases and units on hand are:cost of ending inventory.UnitsCost per Unit$ 6.009.ValueCompute the cost of the ending inventory under the average-cost method ina periodic inventory system.103001,800114008.003,2005009.00Incorrect124,500Weighted-average unit cost2S 7.916671,200Units on hand at period end139,500Feedback: The cost of each purchase is determinedby multiplying the cost per unit by the unitsacquired. These purchase cost amounts are addedand divided by the total units of the three purchases.All amounts must be cell referenced to the Problemarea and formulas must be used to add, multiple anddivide the respective amounts.14200Round unit cost to 3 decimals using the7.91715ROUND function16 Purchases of merchandise were made in the sequence listed above.17Cost of ending inventory1,583.40181920P.%24

Compute the cost of the ending inventory under the average-cost method in a periodic inventory system. Weighted-average unit cost A 7.91667 Incorre Feedba Round unit cost to 3 decimals using the ROUND function 7.917 by multi acquired and divic All amou Cost of ending inventory 1,583.40 area and

Compute the cost of the ending inventory under the average-cost method in a periodic inventory system. Weighted-average unit cost A 7.91667 Incorre Feedba Round unit cost to 3 decimals using the ROUND function 7.917 by multi acquired and divic All amou Cost of ending inventory 1,583.40 area and

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter4: Accounting For Factory Overhead

Section: Chapter Questions

Problem 4P: Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2....

See similar textbooks

Similar questions

ngageNOWv2 | Online teachin X + om/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress... € Compute conversion costs given the following data: direct materials, $363,600; direct labor, $192,400; factory overhead, $204,500 and selling expenses, $35,600. Oa. $396,900 Ob. $568.100 Oc. $168,900 Od. $760,500 8 5/2
4. Change the estimated total amount of the allocation base back to 83,000 machine-hours, so that the data area of you workshe looks exactly the same as in Requirement 2. Now change the actual manufacturing overhead cost from $637,900 to $633,100. Th data area of your worksheet should now look like this: A в 1 Chapter 3: Applying Excel 2. Data Allocation base Estimated manufacturing overhead cost Estimated total amount of the allocation base Actual manufacturing overhead cost Actual total amount of the allocation base 4 Machine-hours 655,700 83,000 machine-hours 7 $ 633,100 78,000 machine-hours 8 (a) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead 3. 5. 6.
RI 6.7.8-Q-InsertYourLastName E Share KEE Insert v V A eral Delete v 个八Z Analyz- Data Conditional Format Cell Sort & Find & Formatting as Table Styles Format v Filter Select 0 00 |6 % K M. 7. Job-Order Costing Problem Using the weighted procedure method of setting rates, calculate the relative value and cost per procedure $1,250,000 and an average hourly lab tech rate of 0.25 ) for the following lab procedures, given a total lab cost of $15 (to calculate the RVU, divide the total sample expense by Sample Labor In Hours Labor Sample Labor Sample Supply In Minutes Projected Procedure Volume Expense ($) Expense ($) Amylase 15 0.75 000 12 Bleeding Time 0.50 000'sS 0.50 000' 7,800 Uric Acid Platelet Count 0.25 6. Hematocit 0.25 8.
ctoring Enabled: Chapter 4 The Art of Modellin. i Saved Help Save & Exit 1 An analyst built the following spreadsheet, complete with named ranges (for example, cell B2 is named "Unit_Price" based on the heading in cell A2). A 2 Unit Price 19 3. Unit Cost 8.57 4 Unit Gross Profit Unit Price Unit Cost 5. 6. Quantity Sold 5,800 7 8. Gross Revenue Quantity Sold x Unit Price Quantity Sold x Unit Cost 3,200 Gross Revenue - Variable Costs Variable Costs 10 Fixed Costs 11 Net Profit Fixed Costs 12 Profit per Unit = Net Profit/Quantity Sold After entering the data shown below in cells B2, B3, B6, and B10, what values should appear Gross Profit and Profit per Unit" answers to 2 decimal places.) the following cells? (Round your "Unit Cell Value B4 (Unit_Gross_Profit) B8 (Gross Revenue) B9 (Variable_Costs) B11 (Net Profit) B12 (Profit_per_Unit) aw Prev 1 of 5 Next >
Excel SIM: Cost of Goods Manufactured and Cost of Goods Sold 1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold. 国日 Cost of Goods Manufactured and Cost of Goods Sold - Excel FILE DATA VIEW Sign In НОМЕ INSERT PAGE LAYOUT FORMULAS REVIEW HA A Calibri 11 Conditional Format as Cell Table - Styles - Paste I U Alignment Number Cells Formatting Clipboard Font Styles A1 fe A C E F G H 2 The allocation base for overhead is direct labor hours. 3 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost $ 275,000 6 Estimated total direct labor hours 25,000 7 Actual total direct labor hours 27,760 8 9 Actual costs for the year: $375,000 $536,300 $302,750 10 Purchase of raw materials (all direct) 11 Direct labor cost 12 Manufacturing overhead costs 13 Beginning $ 14 Inventories: Ending 15,000 $ Raw materials (all direct) Work in process 15 11,375 16 $ 27,875 $ 22,350 17 Finished goods $ 34,600 $ 26,450 18 19 Use…
Excel File Edit View Insert Format Tools Data .. AutoSaveB2-C- Home Insert Draw Page Layout - n Paste H16 X 12 13 Calibri (Body) B I U . 14 14 15 16 17 18 19 20 21 33 Ready HY B A B 1 Formulas: Multiply, Add, Divide; Cell Referencing 2 12 Direct labor rate per hour Markup charged on jobs Enter Answer + Accessibility: Investigate Formulas LEOO tab *** A A & A ✓ Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. x ✓ fx Budgeted MOH costs at start of year Budgeted direct labor hours at start of year Estimated hours for new client's job esc BE8.12-Using Excel to Determine Job Cost and Bid Price for a Service 4 Company 5 PROBLEM 6 Jace and Associates provides professional consulting services to a variety of 7 clientele in an effort to help them improve the operating effectiveness and 8 profitability of their businesses. The company's accountant established 9 budgeted direct labor hours as its allocation base. The company is 10…
O Topic: Week 6: Discu ssion IIl x + a ezto.mheducation.com/ext/map/index.html?_con=con&external_browser-D0& launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F# z- Chapter 6 A Saved Denton Company manufactures and sells a single product. Cost data for the product are given: Variable costs per unit: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Total variable cost per unit Skipped 2$ 3 12 2 3 $ 20 Fixed costs per month: Fixed manufacturing overhead Fixed selling and administrative $ 96, 000 166, 000 $ 262, 000 Total fixed cost per month The product sells for $45 per unit. Production and sales data for July and August, the first two months of operations, follow: Units Produced 24, 000 24, 000 Units Sold July August 20, 000 28, 000 The company's Accounting Department has prepared the following absorption costing income statements for July and August: Sales Cost of goods sold Gross margin Selling and administrative expenses…
A company makes a product R. which requires one each of two first-level components, 5 and T. Routing data for these items are as follows tem Operation No. Dept Work Center Run Time Per unit Setup Time Average Lot size No. No. Std hours) Std hours) R 10 12 0.80 1.50 20 10 12 16 0.50 0.60 40 20 14 1.20 2.00 40 10 16 1.00 0.40 40 20 14 0.30 1.20 40 (a) The Bill of Capacity for product R (in standard hours) at work center 12 is closest to:
ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A% merica AS... rk i Required information Use the following information for the Problems below. (Algo) [The following information applies to the questions displayed below.] Trini Company set the following standard costs per unit for its single product Direct materials (30 pounds @ $5.00 per pound) $ 150.00 98.00 Direct labor (7 hours @ $14 per hour) Variable overhead (7 hours @ $7 per hour) Fixed overhead (7 hours @ $9 per hour) Standard cost per unit Production (in units) Standard direct labor hours (7 DLH per unit) Budgeted overhead (flexible budget) Fixed overhead Variable overhead Overhead is applied using direct labor hours. The standard overhead rate is based on a predicted activity level of 80% of the company's capacity of 51,000 units per quarter. The following additional information is available. 49.00 63.00 $360.00 70% 35,700 249,900 Direct materials (1,377,000 pounds @ $5.00 per pound)…
Smoky Mountain Corporation makes two types of hiking boots-the Xtreme and the Pathfinder. Data concerning these two product lines appear below: Xtreme $ 121.00 $ 64.70 $ 10.80 Pathfinder Selling price per unit Direct materials per unit Direct labor per unit Direct labor-hours per unit Estimated annual production and sales $ 88.00 $ 54.00 %24 9.00 1.0 DLHS 71,000 units 1.2 DLHS 25, 000 units The company has a traditional costing system in which manufacturing overhead is applied to units based on direct labor-hours. Data concerning manufacturing overhead and direct labor-hours for the upcoming year appear below: Estimated total manufacturing overhead Estimated total direct labor-hours $ 2,020,000 101,000 DLH5 Required: 1. Compute the product margins for the Xtreme and the Pathfinder products under the company's traditional costing system. 2. The company is considering replacing its traditional costing system with an activity-based costing system that would assign its manufacturing…
onedrive.live.com/?cid%3D95827CFFCF17 ايسر سبين 3، را Join Meeting - Zoom Sign In Zoom Micr... - Jg Juzeui Goo صدارات Exercise 1. Classify the below cost on their behavior (Fixed Costs and Variable Costs) (a) Rent of Factory Building, (b) Managerial Salaries, (c)Direct wages, (d) Direct Materials, (e) Building Insurance, (f) Commission of salesman, (g)Municipal taxes, (h) Power, (1) Normal Spoilage, G) Small tools Exercise 2 The Information bellow has been taken from production department of XYZ Company for December is as follows: Total Costs Variable Cost Fixed Cost Material used in Production OMR 200000 200000 Labour used in Production 150000 100000 50000 (Assembly and supervisor) Production Facilities cost ( 50000 40000 10000 rent general, utilities.)
p.mheducation.com/ext/map/index.html?_con=con&external_browser%3D0&launchUrl=https%253A%252F%252Flms.mhe D and P Indeed 6 Monster Jobs w Degree Programs O L02 A Hearn: Student Da.. 6 Consumer Center ework: Assignment 1 i Saved Perez Company reported the following operating results for two consecutive years: Required Compute each income statement component for each of the two years as a percentage of sales due to rounding. Round your percentage answers to 1 decimal place. (i.e., 0.234 should be e PEREZ COMPANY Vertical Analysis of Income Statements Percentage of Sales Percentage of Sales Year 4 Year 3 Sales 1,077,500 00S'000'L Cost of goods sold 550,275 000 Z09 Gross margin on sales 450,225 475,500 Operating expenses 130,500 149,800 319.725 325,700 Income before taxes 79.700 81,800 Income taxes 240.025 243.900 % Net income