Put together the next downside as a contribution margin revenue assertion in Excel usingspreadsheet formulation to calculate the weather of the revenue assertion. The Excel file mustshow your calculations for the necessities of the issue within the order requested. Put your identify inthe higher left-hand nook of the spreadsheet. Submit your file to DropBox by April 15.Background: Textual content chapters 1-Three and 5 current manufacturing price classifications. Processingcosts are manufacturing prices for a uncooked materials that’s processed into predictable varieties andamounts of finish merchandise. An instance is hen processing. One hen will yield 2 legs, 2wings, and so on. One hen won’t yield four legs, nevertheless fascinating or worthwhile that is likely to be. Rawmaterials reminiscent of steel ores or oil seeds have equally secure and predictable yields.Processing prices, in addition to manufacturing prices, have three part prices: uncooked or directmaterials (DM), direct labor (DL), and processing or manufacturing overhead (MOH).Conversion prices (CC) embody DL and MOH. Due to waste or processing losses, the totalquantity (tons) offered will probably be lower than the overall amount (tons) processed.Lastly, in a contribution margin revenue assertion, prices are segregated as whole variable(no matter operate) and whole mounted. See chapter Three for a lot of examples.Undertaking: Memphis Cottonseed Firm has engaged you to help within the growth ofinformation for use for managerial selections. The corporate has the capability to course of 20,000tons of cottonseed per yr. The yield of a ton of cottonseed is as follows:Desk 1: RevenuesProduct Common Yield Per Tonof Cottonseed (in kilos)Oil300Meal600Hulls800Lint100Waste200Common Promoting Priceper Commerce Unit$zero.55 per pound$225.00 per ton$210.00 per ton$10.00 per cwtConversion elements: 1 ton = 2,00zero lbs. Cwt = 100 lbs.A particular advertising examine revealed that the corporate can count on to promote its whole output for thecoming 2013 yr on the listed common promoting costs. You’ve gotten decided the companys coststo be as follows:Desk 2: Annual Cottonseed CostsProcessing Prices:Variable$27.00 per ton of cottonseed put in processFixed$308,00zero per yearMarketing Prices:100% variable$60.00 per ton soldAdministrative Prices:100% mounted$270,00zero per year2From the previous data it’s worthwhile to undergo administration an in depth report on thecompanys breakeven level. In view of the circumstances within the cottonseed market, managementtold you that it will additionally wish to know the common most quantity that the corporate canafford to pay for a ton of cottonseed.Required:1. (CVP Evaluation and Goal Costing). Assume that the revenues in Desk 1 are the annualbreakeven gross sales . On the breakeven level, what’s the highest quantity that Memphiscan pay per ton of uncooked cottonseed? Present your reply and calculations in an Excelspreadsheet with formulation for a contribution margin revenue assertion.2. (CVP Evaluation and Goal Costing). The stockholders contemplate the minimal satisfactoryreturn on their fairness funding (ROE = Pretax internet revenue/ common fairness) in thebusiness to be 20% earlier than company revenue taxes. The stockholders fairness in thecompany is $1,500,00zero. Compute the common quantity that the corporate will pay for a tonof cottonseed to understand the minimal passable return on the stockholders investmentin the corporate. Present your reply and calculations in an Excel spreadsheet withformulas for a contribution margin revenue assertion.Three. (Course of Costing). As part of your monetary projections for 2013, it’s worthwhile to estimatethe worth of Work-in-Course of stock at December 31, 2013. Use the info in Desk 3below to point out the overall stock valuation for merchandise and byproducts of the cottonseedprocess. Calculate equal items (EU) of DM and CC for every product, the endinginventory worth for every product, and the mixed stock worth for all 5 objects.Present this in a spreadsheet with formulation.Desk Three: Ending Work in Course of InventoryMealHullsEnding Stock (Lbs.)36,00048,000DM % full100%100%CC % full95%95%DM unit price per EU$zero.123$zero.123CC unit price per EU$zero.008$zero.002Lint6,00zero100%95%$zero.123$zero.002Oil18,00zero100%35%$zero.123$zero.019*Processing produces waste or Soapstock. Though it has no sale worth, it does have a value.Waste*12,00zero100%50%$zero.123$zero.011Put together the next downside as a contribution margin revenue assertion in Excel usingspreadsheet formulation to calculate the weather of the revenue assertion. The Excel file mustshow your calculations for the necessities of the issue within the order requested. Put your identify inthe higher left-hand nook of the spreadsheet. Submit your file to DropBox by April 15.Background: Textual content chapters 1-Three and 5 current manufacturing price classifications. Processingcosts are manufacturing prices for a uncooked materials that’s processed into predictable varieties andamounts of finish merchandise. An instance is hen processing. One hen will yield 2 legs, 2wings, and so on. One hen won’t yield four legs, nevertheless fascinating or worthwhile that is likely to be. Rawmaterials reminiscent of steel ores or oil seeds have equally secure and predictable yields.Processing prices, in addition to manufacturing prices, have three part prices: uncooked or directmaterials (DM), direct labor (DL), and processing or manufacturing overhead (MOH).Conversion prices (CC) embody DL and MOH. Due to waste or processing losses, the totalquantity (tons) offered will probably be lower than the overall amount (tons) processed.Lastly, in a contribution margin revenue assertion, prices are segregated as whole variable(no matter operate) and whole mounted. See chapter Three for a lot of examples.Undertaking: Memphis Cottonseed Firm has engaged you to help within the growth ofinformation for use for managerial selections. The corporate has the capability to course of 20,000tons of cottonseed per yr. The yield of a ton of cottonseed is as follows:Desk 1: RevenuesProduct Common Yield Per Tonof Cottonseed (in kilos)Oil300Meal600Hulls800Lint100Waste200Common Promoting Priceper Commerce Unit$zero.55 per pound$225.00 per ton$210.00 per ton$10.00 per cwtConversion elements: 1 ton = 2,00zero lbs. Cwt = 100 lbs.A particular advertising examine revealed that the corporate can count on to promote its whole output for thecoming 2013 yr on the listed common promoting costs. You’ve gotten decided the companys coststo be as follows:Desk 2: Annual Cottonseed CostsProcessing Prices:Variable$27.00 per ton of cottonseed put in processFixed$308,00zero per yearMarketing Prices:100% variable$60.00 per ton soldAdministrative Prices:100% mounted$270,00zero per year2From the previous data it’s worthwhile to undergo administration an in depth report on thecompanys breakeven level. In view of the circumstances within the cottonseed market, managementtold you that it will additionally wish to know the common most quantity that the corporate canafford to pay for a ton of cottonseed.Required:1. (CVP Evaluation and Goal Costing). Assume that the revenues in Desk 1 are the annualbreakeven gross sales . On the breakeven level, what’s the highest quantity that Memphiscan pay per ton of uncooked cottonseed? Present your reply and calculations in an Excelspreadsheet with formulation for a contribution margin revenue assertion.2. (CVP Evaluation and Goal Costing). The stockholders contemplate the minimal satisfactoryreturn on their fairness funding (ROE = Pretax internet revenue/ common fairness) in thebusiness to be 20% earlier than company revenue taxes. The stockholders fairness in thecompany is $1,500,00zero. Compute the common quantity that the corporate will pay for a tonof cottonseed to understand the minimal passable return on the stockholders investmentin the corporate. Present your reply and calculations in an Excel spreadsheet withformulas for a contribution margin revenue assertion.Three. (Course of Costing). As part of your monetary projections for 2013, it’s worthwhile to estimatethe worth of Work-in-Course of stock at December 31, 2013. Use the info in Desk 3below to point out the overall stock valuation for merchandise and byproducts of the cottonseedprocess. Calculate equal items (EU) of DM and CC for every product, the endinginventory worth for every product, and the mixed stock worth for all 5 objects.Present this in a spreadsheet with formulation.Desk Three: Ending Work in Course of InventoryMealHullsEnding Stock (Lbs.)36,00048,000DM % full100%100%CC % full95%95%DM unit price per EU$zero.123$zero.123CC unit price per EU$zero.008$zero.002Lint6,00zero100%95%$zero.123$zero.002Oil18,00zero100%35%$zero.123$zero.019*Processing produces waste or Soapstock. Though it has no sale worth, it does have a value.Waste*12,00zero100%50%$zero.123$zero.011
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
