Construct a data table showing profit versus quantity

Assignment Help Cost Accounting
Reference no: EM13842336

Kaizer Plastics produces a variety of plastic items for packaging and distribution. One item, container #145, has had a low contribution to profits. Last year, 20,000 units of container #145 were produced and sold. The selling price of the container was $20 per unit, with a variable cost of $18 per unit and a fixed cost of $70,000 per year.

(a) Construct a correct, flexible, and documented base-case spreadsheet model that allows the user to easily vary the inputs to the problem and see the resulting revenue, costs, and profit. What is the profit level for the base case?

(b) Using the model and Goal Seek, find the break-even quantity.

(c) Construct a Data Table and chart showing profit versus quantity.

Reference no: EM13842336

Questions Cloud

Diversification of the news media : Diversification of the news media lessens the ability of any one medium to influence. straight ticket voting.
Explain advantages of substituting e-learning for classroom : In a board meeting last year, your company has decided to adopt e-learning as a less-expensive alternative to classroom training. Apart from the cost factor, explain other advantages of substituting e-learning for classroom training.
Define the historical use of the term objective to classif : Historical Use of the Terms - Meyer and Kurtz (2006) define the historical use of the term "objective" to classify
What were the key culture-shocks during the negotiation : What were the key culture-shocks during the negotiation. Can you list more based on your experience with eastern (or other foreign) cultures. In your opinion, how should we deal with cultural conflicts in international negotiation
Construct a data table showing profit versus quantity : Using the model and Goal Seek, find the break-even quantity. Construct a Data Table and chart showing profit versus quantity.
How should the following costs affect a retailers inventory : How should the following costs affect a retailers inventory
Find three sentences with dangling modifiers : You should find three sentences with dangling modifiers, seven with passive voice, and three fragments. Be sure your group agrees on its analysis.
Compute the companys break-even-point in units sold : Compute the company's break-even-point in units sold
Compensation and lending decisions : Compensation and Lending Decisions

Reviews

Write a Review

Cost Accounting Questions & Answers

  Prepare the journal entry for arness to record the sale

Prepare Dold's journal entries for the initial transaction, recognition of interest each year, and the collection of $20,000 at maturity and prepare the journal entry for Arness to record the sale

  Find return-on-assets ratio and net-profit-margin ratio

LONE PINE COMPANY Statement of Income and Retained Earnings For the Year Ending December 31,20X2 ($000 Omitted) Net Sales* $36,000 Less: Cost of Goods Sold $20,000 Selling Expense 6,000 Administrative Expense 4,000 Interest Expense 400

  Retail business-prepare trading and profit and loss account

Prepare the Trading and Profit and Loss Account for the year ended on Mar 31, 2009 and a Balance Sheet - Provision for doubtful debts is to be maintained at 5% of the Sundry Debtors.

  Question-on january 1 2014 agassi corporation had the

question-on january 1 2014 agassi corporation had the subsequent stockholders equity accounts.common stock 10 par value

  Analysis of special products divisions assets

Analysis of Special Products Division's assets indicates that goodwill of $200,000 exists on December 31, 2007. What goodwill impairment should be recognized by General Products in 2007?

  Prepare the december 2009 journal entries to record

Prepare the December 2009 journal entries to record the newsstand sales and subscriptions received. (assume that the debit is to cash)

  What is capitals after-tax wacc

what is Capital's after-tax WACC and what balance could appear in the investment in Holister account as of December 31, 2009?

  What will your monthly lease payments be

Pings wants the PV of the lease payments to equal $3,500. Suppose that your first payment is due immediately. What will your monthly lease payments be?

  Calculate the return on assets for 2011

Explain whether translation has distorted the Spanish subsidiary's performance in 2012 compared with 2011.  If so, explain how changes in the exchange rate contributed to the distortion.

  What would be the incremental effect on the company

What would be the incremental effect on the company's overall profit of reworking and selling the material rather than selling it as is as scrap and what is the relevant cost of the 880 liters of the raw material when deciding how much to bid on th..

  Review the balance sheet of the company

Describe the alternatives the organisers have in relation to recognizing revenues and Discuss the importance of Cost of Goods Sold(COGS) in case.

  Estimate the monthly fixed costs and the unit variable cost

Estimate the monthly fixed costs and the unit variable cost per support call using the high-low estimation method and draw a scattergraph relating call center costs to the number of support calls

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd