2. Change all of the numbers in the data area of your worksheet so that it looks like this: A 1 Chapter 6: Applying Excel 2 ook 3 Data rint 456 Selling price per unit Manufacturing costs: Variable per unit produced: B C $ 296 7 Direct materials $ 104 rences 8 9 10 11 B12345 Direct labor $ 76 Variable manufacturing overhead $ 26 Fixed manufacturing overhead per year $ 184,800 Selling and administrative expenses: Variable per unit sold $ 9 Fixed per year $ 77,000 Units in beginning inventory 16 Units produced during the year 17 Units sold during the year 18 Year 1 Year 2 0 3,300 2,800 3,000 3,000 If 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
Q: please answer in text form and in proper format answer with must explanation , calculation for each…
A: To determine the investment revenue from FXC that ABC should record in year 1, we need to consider…
Q: QUESTION#1.Hot Pizza granted a franchise to Shake King. Shake King was to pay a franchise fee of…
A: What is being asked is the FRANCHISE FEE. Therefore, there is NO need to calculate the royalty ((1%…
Q: A7
A: Computation of Changes In Current Operating Assets & Liabilities 2020 2019 Increase (Decrease)…
Q: On January 2, 2019, Flint Corporation issued $1,950,000 of 10% bonds to yield 11% due December 31,…
A: Absolutely, I can help you determine the price of the Flint bonds when issued on January 2, 2 here's…
Q: A5
A: We start the 2021 beginning balance with the amount of note which is $20,000. For the rest of the…
Q: Alta Company is constructing a production complex that qualifies for interest capitalization. The…
A: Step 1: Calculating Capitalized Interest1. **Identify Expenditures During Capitalization Period:**…
Q: please answer in text form with introduction , concept , explanation, computation , steps for all…
A: Working NotesFor Material VariancesStandard QuantityStandard rateStandard CostActual QuantityActual…
Q: 13-2. Optimal capital budget Marble Construction estimates that its WACC is 10 percent if equity…
A: Here's a detailed explanation for better understanding. Internal Rate of Return (IRR): This is the…
Q: please answer in text form with introduction , concept , explanation, computation , steps clearly…
A: b).Should Gelb make or buy the part?should opt make (The manufacturing cost, at $4.67, is lower than…
Q: Walter, a single taxpayer, purchased a limited partnership interest in a tax shelter in 1996. He…
A: a. Calculating the allowable loss for rental house activities for 2023:The passive activity loss…
Q: The following Figures are for the economy of country Alpha in 2010 (in millions of dollars) \…
A: b. Net Foreign Factor Income (NFFI)NFFI = Net interest + Compensation of employees - Social security…
Q: Vernon Electronics is considering investing in manufacturing equipment expected to cost $370,000.…
A: Here's a detailed calculation for better understanding. 1. Net Present Value (NPV) and Present Value…
Q: Tasman Products has a Maintenance Department that services equipment in the company's Forming…
A: Explanations: Maintenance Department cost charged to the Forming Department: $590,848Maintenance…
Q: Comparative balance sheets for 2024 and 2023, a statement of income for 2024, and additional…
A: Start with Net Income: Begin the cash flow from operating activities section with the net income…
Q: Hanshaben
A: Accepting the wedding party's order offers Imperial Jewelers several financial benefits. Firstly,…
Q: Crane Company manufactures a check-in kiosk with an estimated economic life of 12 years and leases…
A: Explanations: Answer a:This lease is a capital lease for the lessee. A capital lease is a lease that…
Q: Lara uses the standard mileage method for determining auto expenses. During 2023, she used her car…
A: According to IRS, standard mileage rates for 2023 are:Self-employed & business = 65.5 cents/mile…
Q: In 2024, internal auditors discovered that PKE Displays, Incorporated, had debited an expense…
A: Calculation of Net Income that is understated Understated Net Income = Cost of Asset -…
Q: Refer to the balance sheet information below for Home Depot. $ millions Feb. 3, 2019 Jan. 28, 2018…
A: Solution to Home Depot RNOA Casea. Compute Return on Net Operating Assets (RNOA)Numerator: NOPAT…
Q: E9-9 (Algo) Calculating Direct Labor Variances [LO 9-4] Parker Plastic, Incorporated, manufactures…
A: To calculate the direct labor rate and efficiency variances, we need to find the standard hours…
Q: "Your answer has been saved. See score details after the due date. 2025, Carla Vista Corporation…
A: Discontinuing OperationsThe net result of discontinuing operations should be reported as "Results of…
Q: Domestic
A: ere is a schedule showing the status of the appropriation at the end of the first quarter:Amount…
Q: Haresh
A: Step 1: Calculate net income for the three-month period ended June 30, 2023.Net Income for the…
Q: Preference share capital authorized, P100 par 5,000,000 Ordinary share capital authorized, P10 par…
A: To solve for the ordinary shares that were issued, 1. Get the sum of ordinary shares subscribed and…
Q: Exercise 14-7 (Algo) Trend Percentages [LO14-1] Rotorua Products, Limited, of New Zealand markets…
A: The base year 1 was considered to calculate all the percents for all years. The excel table has been…
Q: Debra Leasing Company signs an agreement on January 1, 2025, to lease equipment to Novak Company.…
A: Approach to solving the question: Detailed explanation: Examples: Key references: Financial…
Q: Crane Company has the following merchandise account balances at its September 30 year end: Cost of…
A: To close the appropriate accounts to the Income Summary account, we need to transfer the balances of…
Q: please answer in text form and in proper format answer with must explanation , calculation for each…
A: Explanations: Income tax = $140,719.75Net investment income tax = $1,558.00Total tax liability =…
Q: Alta Company is constructing a production complex that qualifies for interest capitalization. The…
A: let's work through this step-by-step: 1. Compute the amount of interest costs capitalized each…
Q: es Balloons By Sunset (BBS) is considering the purchase of two new hot air balloons so that it can…
A: Step 1:1.) Accounting rate of Return = Annual Net Income/Average Investment= 28,294/329,000 = 8.6%…
Q: None
A: Bond Specifics:Face Value: $7,940,000Interest Rate: 6% (semi-annual rate = 6% / 2 = 3%)At 102…
Q: None
A: To calculate Oriole Corporation's 2025 diluted earnings per share, we need to follow these steps:1.…
Q: None
A: To calculate the issue price of the bond, we use the present value formula for a bond. The present…
Q: Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near…
A: Activity Variances are the items that differs between the budgeted and the actual activity levels.…
Q: Meman
A: Allocating Joint Costs using the NRV MethodThe NRV (Net Realizable Value) method allocates joint…
Q: None
A: The above answers can be explained as under - 12) The statement is true because, the financing…
Q: At June 30 Assets IKIBAN INCORPORATED Comparative Balance Sheets Cash Accounts receivable, net…
A: Those words that are in bold characters are the additional information that was not found in the…
Q: A3
A: PLEASE READ ABOVE SOLUTION AND EXPLANATION. THANK YOU!
Q: None
A: Depreciable Value = Cost of the asset - Salvage value= 1,600,000 - 150,000= 1,450,000 Annual…
Q: None
A: 1. Straight-Line Method:Given:Cost of equipment: $35,100Residual value: $2,100Useful life: 3…
Q: I need help with this practice intitial value method problem
A: ### 1. Initial Acquisition Analysis:- **Acquisition Details**: - Parkway Inc. acquired 90% of…
Q: None
A: Because political scientist Samuel P. Huntington started the clash of civilizations, "A. Huntington"…
Q: A company is considering replacing an old piece of machinery, which cost $600,000 and has $351,700…
A:
Q: please answer in text form with introduction , concept , explanation, computation , steps clearly…
A: Rouse Foods Production BudgetThis document outlines the production budget for Rouse Foods for the…
Q: Requirement 1a. In preparation for recording the transactions, prepare: An amortization schedule for…
A: Requirement 1a: Amortization Schedule (First 3 Months)Loan Details:Beginning Balance:…
Q: Facebook Inc. (now Meta Platforms Inc.) issued 421.2 million class A common shares for $38 per…
A: Now, let's record the journal entry:Date: 5/18/20121. Dr Cash (Total proceeds)…
Q: Instrument Corp. has the following equity investments which were held throughout 2010-2011: Fair…
A: Instrument Corp would report a gain of $200,000 in its income statement for the year ended December…
Q: Effect of Financing on Earnings Per Share Three different plans for financing an $18,000,000…
A: The illustration shows a financing case study, and your task is to figure out how various financing…
Q: On February 1, 2020, Stratford issued 8% bonds, dated February 1, with a face amount of $600,000.…
A: To calculate the discount on the bonds payable for February 1, 2020, we need to find the difference…
Q: None
A: Step 1: Show formula version of the solution sheet for a better understanding of the calculations:…
Step by step
Solved in 2 steps
- 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/2YPLUS 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 MacBookonedrive.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.)
- 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.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 month2. 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
- 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 AirView 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.B NOWv2 | Online teachir X + ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress... Ⓒ Thomlin Company forecasts that total factory overhead for the current year will be $17,280,000 with 180,000 total machine hours. Year to date, the actual overhead is $8,220,000, and the actual machine hours are 82,200 hours. If Thomlin Company uses a predetermined factory overhead rate based on machine hours for applying overhead, as of this point in time (year to date), the overhead is a. $328,800 underapplied Ob. $391,200 overapplied Oc. $328,800 overapplied Od. $391,200 underapplied 8:15 A 5/2/202 H U a 1 C