2. Change all of the numbers in the data area of your worksheet so that it looks like this:A1Chapter 6: Applying Excel2ook3Datarint456Selling price per unitManufacturing costs:Variable per unit produced:BC$2967Direct materials$104rences891011B12345Direct labor$76Variable manufacturing overhead$26Fixed manufacturing overhead per year$184,800Selling and administrative expenses:Variable per unit sold$9Fixed per year$77,000Units in beginning inventory16Units produced during the year17Units sold during the year18Year 1Year 203,3002,8003,0003,000If your formulas are correct, you should get the correct answers to the following questions.(a) What is the net operating income (loss) in Year 1 under absorption costing?Net operating loss

Year 1 TotalSales 3,000.00 296.00 888,000.00 Cost of Goods…

Answered: 2. Change all of the numbers in the…

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.
YPLUS Kimmel, Accounting, 7e Help | System Announcements CALCULATOR PRINTER VERSION 1 BACK NEXT National Corporation needs to set a target price for its newly designed product M14-M16. The following data relate to this new product. RESOURCES OMEWORK --05 -07 -09 -11 a-b Per Unit Total Direct materials $21 -16 Direct labor $41 --01A -02A -03A Variable manufacturing overhead Fixed manufacturing overhead $14 $1,264,000 Variable selling and administrative expenses $ 4 Fixed selling and administrative expenses $ 1,106,000 Its by Study These costs are based on a budgeted volume of 79,000 units produced and sold each year. National uses cost-plus pricing methods to set its target selling price. The markup percentage on total unit cost is 40%. Compute the total variable cost per unit, otal fixed cost per unit, and total cost per unit for M14-M16. Variable cost per unit 2$ Fixed cost per unit Total cost per unit 24 MacBook
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.)
2. Change all of the numbers in the data area of your worksheet so that it looks like this: A 1 Chapter 3: Applying Excel 2 3 Data 4 Allocation base 5 Estimated manufacturing overhead cost Estimated total amount of the allocation base Actual manufacturing overhead cost 8 Actual total amount of the allocation base 6 7 Predetermined overhead rate Machine-hours $ B $ с 409,200 62,000 machine-hours 418,200 60,000 machine-hours If your formulas are correct, you should get the correct answers to the following questions. (a) What is the Predetermined overhead rate? (Round your answer to 2 decimal places.) per machine-hour
File Edit View Go Tools Window Help A ASSIGNMENT NO.1 BUSS 104.pdf (page 4 of 4) Q Search Question 5: The Information below is taken from production department of Salalah Company for April: The number of units produced is 10000. All amounts are in OMR. Total Costs Variable Cost Fixed Cost 500000 Direct material cost Total labor cost 400000 100000 Manufacturing Overhead 90000 30000 Calculate: A. Find the missing information in the above table. Some values may not be applicable, explain. B. Calculate cost per unit C. Describe the production costs in the equation form Y f+ vX. D. Assume Salalah intends to produce 10000 units next month. Calculate total production costs for the month
Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2. Determine the cost to be charged to the product for the year. 3. Determine the cost to be charged to factory overhead for the year. 4. Determine the plotted data points using Chart Wizard. 5. Determine R2. 6. How do these solutions compare to the solutions in P4-2 and P4-3? 7. What does R2 tell you about this cost model?
NOWV2 | Online teach x + O SOFTWARE UPDATE eAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress%3false macOS Big Sur 11.3.1 is available and will be in later tonight. O eBook Show Me How E Print Item Activity-Based Costing: Factory Overhead Costs The total factory overhead for Bardot Marine Company is budgeted for the year at $1,167,450, divided into four activities: fabrication, $507,000; assembly, $210,000; setup, $245,700; and inspection, $204,750. Bardot Marine manufactures two types of boats: speedboats and bass boats. The activity-base usage quantities for each product by each activity are as follows: Fabrication Assembly Setup Inspection Speedboat 9,750 dlh 31,500 dlh 70 setups 122 inspections Bass boat 29,250 10,500 515 853 39,000 dlh 42,000 dlh 585 setups 975 inspections Each product is budgeted for 5,500 units of production for the year. a. Determine the activity rates for each activity. Fabrication $ per direct labor hour Assembly 5 V per…
1. Assign Overhead Costs to Activity Cost Pools 国日 First-Stage Allocation to Activity Cost Pools - Excel Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri -A A 10 Paste BIU - A - Alignment Number Conditional Format as Cell Cells Formatting - Table - Styles - Clipboard Font Styles A1 fx A C E F G 1 == 2 Total costs and distribution of resource consumption across activity cost pools: 3 4 Activity Cost Pools Customer Product Customer Total Cost Orders Development Relations Other Total 6 Production Department: 7 Indirect factory wages $ 400,000 50% 30% 15% 5% 100% Factory equipment depreciation Factory utilities 10 Factory property taxes and insurance 8 150,000 55% 30% 0% 15% 100% 9 120,000 59% 34% 0% 7% 100% 75,000 57% 33% 0% 10% 100% 11 12 General Administrative Department: Administrative wages and salaries Office equipment depreciation 13 275,000 20% 10% 40% 30% 100% 14 40,000 32% 16% 15% 37% 100% 15 Administrative property taxes and insurance 60,000 0% 0% 0% 100%…
S Kimmel, Accounting, 7e Help | System Announcements CALCULATOR PRINTER VERSION 1 BACK NEXT National Corporation needs to set a target price for its newly designed product M14-M16. The following data relate to this new product. Per Total- Unit Direct materials $26 Direct labor $44 Variable manufacturing overhead $15 Fixed manufacturing overhead $1,377,000 Variable selling and administrative expenses $ 5 Fixed selling and administrative expenses $ 1,053,000 These costs are based on a budgeted volume of 81,000 units produced and sold each year. National uses cost-plus pricing methods to set its target selling price. The markup percentage on total unit cost is 40%. Compute the total variable cost per unit, total fixed cost per unit, and total cost per unit for M14-M16. Variable cost per unit $4 Fixed cost per unit Total cost per unit MacBook Air
View Go Tools Window Help Edit Preview File ABC AASSIGNMENT NO.1 BUSS 104.pdf (page 4 of 4) Q Search Question 5: The Information below is taken from production department of Salalah Company for April: The number of units produced is 10000. All amounts are in OMR. Total Costs 500000 Variable Cost Fixed Cost Direct material cost Total labor cost 400000 30000 100000 Manufacturing Overhead 90000 Calculate: A. Find the missing information in the above table. Some values may not be applicable, explain. B. Calculate cost per unit C. Describe the production costs in the equation form Y= f+vX. D. Assume Salalah intends to produce 10000 units next month. Calculate total production costs for the month Question 6: Find the missing information for diff.
gagenown/ilm/takeAssignment/takeAssignmentMain.do?invoker=&ta... A Q eBook Activity Fabrication Assembly Setup Inspecting Production scheduling Purchasing Activity Rate $24 per machine hour $13 per direct labor hour $50 per setup $28 per inspection $14 per production order $11 per purchase order The activity-base usage quantities and units produced for each product were as follows: Elliptical Machines Treadmill 1,687 419 53 Activity Base Machine hours Direct labor hours Setups Elliptical Machines Treadmill 4 Product Costs using Activity Rates Hercules Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication and Assembly production departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated activity rates are as follows: C 101 Print Item % 15 5 732 $ Inspections Production orders Purchase orders 198 Units produced 286 Use the activity rate…

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS