Pampa Parts produces a single product, the NF-9. The product has a unit variable cost of $70
Question:
Pampa Parts produces a single product, the NF-9. The product has a unit variable cost of $70 and annual fixed costs of $343,200. Pampa is subject to a 20 percent tax rate.
Required
Suppose the NF-9 sells for $110 per unit. Using the Goal Seek function in Microsoft Excel, how many units of NF-9 must Pampa sell to earn an annual operating profit after taxes of $38,400?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 86% (15 reviews)
Using Microsoft Excel to Perform CVP Analysis with Taxes Pampa Parts 9780 u...View the full answer
Answered By
Ashington Waweru
I am a lecturer, research writer and also a qualified financial analyst and accountant. I am qualified and articulate in many disciplines including English, Accounting, Finance, Quantitative spreadsheet analysis, Economics, and Statistics. I am an expert with sixteen years of experience in online industry-related work. I have a master's in business administration and a bachelor’s degree in education, accounting, and economics options.
I am a writer and proofreading expert with sixteen years of experience in online writing, proofreading, and text editing. I have vast knowledge and experience in writing techniques and styles such as APA, ASA, MLA, Chicago, Turabian, IEEE, and many others.
I am also an online blogger and research writer with sixteen years of writing and proofreading articles and reports. I have written many scripts and articles for blogs, and I also specialize in search engine
I have sixteen years of experience in Excel data entry, Excel data analysis, R-studio quantitative analysis, SPSS quantitative analysis, research writing, and proofreading articles and reports. I will deliver the highest quality online and offline Excel, R, SPSS, and other spreadsheet solutions within your operational deadlines. I have also compiled many original Excel quantitative and text spreadsheets which solve client’s problems in my research writing career.
I have extensive enterprise resource planning accounting, financial modeling, financial reporting, and company analysis: customer relationship management, enterprise resource planning, financial accounting projects, and corporate finance.
I am articulate in psychology, engineering, nursing, counseling, project management, accounting, finance, quantitative spreadsheet analysis, statistical and economic analysis, among many other industry fields and academic disciplines. I work to solve problems and provide accurate and credible solutions and research reports in all industries in the global economy.
I have taught and conducted masters and Ph.D. thesis research for specialists in Quantitative finance, Financial Accounting, Actuarial science, Macroeconomics, Microeconomics, Risk Management, Managerial Economics, Engineering Economics, Financial economics, Taxation and many other disciplines including water engineering, psychology, e-commerce, mechanical engineering, leadership and many others.
I have developed many courses on online websites like Teachable and Thinkific. I also developed an accounting reporting automation software project for Utafiti sacco located at ILRI Uthiru Kenya when I was working there in year 2001.
I am a mature, self-motivated worker who delivers high-quality, on-time reports which solve client’s problems accurately.
I have written many academic and professional industry research papers and tutored many clients from college to university undergraduate, master's and Ph.D. students, and corporate professionals. I anticipate your hiring me.
I know I will deliver the highest quality work you will find anywhere to award me your project work. Please note that I am looking for a long-term work relationship with you. I look forward to you delivering the best service to you.
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Fundamentals of Cost Accounting
ISBN: 978-1259969478
6th edition
Authors: William N. Lanen, Shannon Anderson, Michael W Maher
Question Posted:
Students also viewed these Business questions
-
Refer to the data for Pampa Parts in Exercise 3-44. Required Suppose Pampa expects to sell 8,150 units of NF-9 next year, but the price is uncertain. Using the Goal Seek function in Microsoft Excel,...
-
Topaz Company produces a single product. The company has set standards as follows for materials and labor: During the past month, the company purchased 6,000 pounds of direct materials at a cost of...
-
Assume that a company produces a single product by processing it first through a single production department. Direct labor costs flow through what accounts in this companys process cost system?
-
Given an array, Arr[] of integer numbers have size N. The task is to find out single or consecutive numbers from Arr[] with 0 sum. When found, print "1" otherwise "0". Example-1: Input: 4 (6,-2,3,-1)...
-
Explain Keynes's theory of how expectations affect investment demand. How is this theory related to Keynes's view that aggregate demand would be unstable in the absence of government stabilization...
-
Briefly describe how DNS(Domain Name Service) works. Also, demonstrate how the URL "ABC.uws.edu.au "is resolved.
-
People from different cultural backgrounds have different communicative norms, different ways of sending and receiving messages. Give examples of the confusions and misunderstandings caused by...
-
Here are the comparative income statements of Blevins Corporation. Instructions(a) Prepare a horizontal analysis of the income statement data for Blevins Corporation, using 2011 as a base. (Show the...
-
please help Selected current year-end financial statements of Cabot Corporation follow (All sales were on credit selected balance sheet amounts at December 31 of the enor year were inventory. 554900...
-
You are working in an ice skating rink and have been asked to hang a new banner on the wall. Your friend is helping you so that the ladder does not collapse by exerting a force FAL at an angle...
-
Pfizer Inc., a pharmaceutical firm, incurs many types of costs in its operations. Required For each cost in the following table, identify the stage in the value chain where this cost is incurred....
-
Consider the Business Application, Indirect Costs and Allocating Costs to Contracts. Required a. How should Greenfield Consultants allocate indirect costs to units? Why? b. What ethical issues arise...
-
1. For each of the following goods, explain whether there is a free-rider problem. If there is no such problem, how is it avoided? Fire protection A July 4th fireworks display Interstate 80 in...
-
Refer to the information presented in M7-9. Suppose that Juanita has developed a rectangular, medium-size ceramic pot. It requires 3 hours of kiln time; however, two medium-size pots can fit m the...
-
Eclipse Company manufactures a variety of sunglasses. Production information for its most popular line, the Total Eclipse (TE), follows: Suppose that Eclipse has been approached about making a...
-
Sunblocker Corp. makes several varieties of beach umbrellas and accessories. It has been approached about producing a special order for custom umbrellas. The special-order umbrellas with the Randolph...
-
Sunblocker Corp. is considering eliminating a product from its Happy Sand line of beach umbrellas. This collection is aimed at people who spend time on the beach or have an outdoor patio near the...
-
Suppose that annual demand for a certain item has decreased dramatically this year, although the store that stocks this item has not updated its inventory policy, so the store is still using the same...
-
The population of a herd of deer is represented by the function A(t) = 205(1.13)t, where t is given in years. To the nearest whole number, what will the herd population be after 6 years?
-
The column shown in the figure is fixed at the base and free at the upper end. A compressive load P acts at the top of the column with an eccentricity e from the axis of the column. Beginning with...
-
What is the difference between expenses and cash outflows?
-
What is the difference between expenses and cash outflows?
-
What is the difference between depreciation and the tax shield on depreciation?
-
When credit terms for a sale are 2/15, n/40, the customer saves by paying early. What percent (rounded) would this savings amount to on an annual basis
-
An industrial robot that is depreciated by the MACRS method has B = $60,000 and a 5-year depreciable life. If the depreciation charge in year 3 is $8,640, the salvage value that was used in the...
-
What determines a firm's beta? Should firm management make changes to its beta? Be sure to consider the implications for the firm's investors using CAPM.
Study smarter with the SolutionInn App