Cost-Volume-Price Analysis

docx

School

St. Clair College *

*We aren’t endorsed by this school

Course

145

Subject

Accounting

Date

Jan 9, 2024

Type

docx

Pages

5

Uploaded by haneengummah12

Report
Cost-Volume-Price Analysis Details Sunflower oil is produced by the company from sunflower seeds. Mash is a by-product that uses 70% of the seeds intake and 30% of the oil. At 90% capacity, the company's daily operating capacity is 135 short tons of seeds. Oil must have a minimum of 77% oleic acid and a minimum of 0.78% and a maximum of 0.88% iodine. Raw sunflower seeds are supplied from three suppliers: A, B, and C. Issues For the coming year, the company intends to purchase sunflower seeds as a raw material. The company will provide data on seed, oil, and mash prices for the previous 15 years, as well as a price projection for the coming year. The company's breakeven point must also be calculated. It must also be determined from whom sunflower seeds will be obtained. Methodology Time series forecasting on the basis of a three-year moving average is the methodology used to forecast prices of seeds, oil, and mash. Fixed costs divided by contribution margin ratio equals breakeven. The best approach is to plot the data on graph to see the data trend. 1 | P a g e
One can see that three is a considerable increasing trend in the data. Hence, it would be easier to use the regression analysis. Now, create a spreadsheet for regression analysis as shown below. Analysis As seen in the excel spreadsheet below, a three-year moving average was used to anticipate prices for seeds, oil, and mash, with prices for the future year forecasted as follows: Using the formula for MSE: 2 | P a g e
The requirement forecast for the three is as follows: Seed Oil Mash $558.41 $1,645.89 $252.42 Seeds $456.7 per short ton of oil $1278.1 per short ton of mash $216.3 Since the minimum and maximum values of oleic acid and iodine are set, suppliers A and C do not meet the requirements, hence seeds should be obtained from supplier B at the anticipated price. It is the foundation for all calculations. As a result, the cost of seeds is $456.7 per short ton (supplier B). Since the additional variable cost per short ton is $10, the total variable cost per short ton is $466.7. Because the fixed cost for the time is $1750000, the total cost calculation is TC = 466.7V+ 1750000 Where V are short tons of seeds Total seed required at 90% capacity 49275 short tons   TC = 466.7V+1750000      TC = (466.7*49275)+1750000  =  24746642.5        TC = (466.7*49275)+1750000 = 24746642.5    TC per short ton  =  $502.21           Total seed required at 90% capacity 49275 short tons Exp. price Sales revenue Oil production 30%  14782.5 short tons 1278.1  $18,893,513  Mash Production 70%  34492.5 short tons 216.3  $7,460,728  Total   =    $26,354,241        Total sales revenue  $26,354,241      Less Variable costs 22996643     Contribution Margin  $3,357,598.50      CM Ratio  12.74%     Fixed costs  1750000     Expected operating profits  $1,607,598.50       3 | P a g e
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Recommendations First, the company should buy raw seeds from Supplier B as it is the only one that fulfils required standards of oleic acid and iodine. Secondly, the company's breakeven sales is 52% of normal operating capacity sales, which is $13735985. Break Even Chart Unit seeds Revenue variable Variable costs Fixed cost Total cost 8000 4278720 3733600 1750000 5483600 16000 8557440 7467200 1750000 9217200 24000 12836160 11200800 1750000 12950800 32000 17114880 14934400 1750000 16684400 40000 21393600 18668000 1750000 20418000 48000 25672320 22401600 1750000 24151600 52000 27811680 24268400 1750000 26018400 4 | P a g e
References Adar, Z., Barnea, A., & Lev, B. (1977). A comprehensive cost-volume-profit analysis under uncertainty. Accounting Review, 137-149.' Jaedicke, R. K., & Robichek, A. A. (1964). Cost-volume-profit analysis under conditions of uncertainty. The Accounting Review, 39(4), 917. McIntyre, E. V. (1977). Cost-volume-profit analysis adjusted for learning. Management Science, 24(2), 149-160. Shih, W. (1979). A general decision model for cost-volume-profit analysis under uncertainty. Accounting Review, 687-706. 5 | P a g e