Can you help me with excel project. The case and questions required are on the p
ID: 2584565 • Letter: C
Question
Can you help me with excel project. The case and questions required are on the paper and numbers that are not readable are in excel file. I need formulas as well to put them in excel. PLEASE
FINE METALS, INC. Gold Investment Data Silver Investment Data Silver Industrial Data Budget Actual Budget Actual Budget Actual Sales in ounces 1,200,000 1,150,000 2,500,000 2,850,000 3,425,000 3,500,000 Average price per ounce $1,580.00 $1,490.00 $26.25 $26.50 $26.25 $26.50 Variable acquisition costs per ounce $35.00 $38.75 $10.00 $11.00 $9.00 $9.25 Fixed acquisition costs $250,000,000.00 $257,500,000.00 $10,500,000.00 $12,000,000.00 $20,500,000.00 $19,500,000.00 Variable SG&A costs per ounce $40.50 $42.00 $12.00 $12.50 $10.00 $9.50 Fixed SG&A costs $40,000,000.00 $45,000,000.00 $3,750,000.00 $3,500,000.00 $4,250,000.00 $4,500,000.00 ooo Lycamobile 17:38 64 % AC201 Fall 2017 Project.pdf REQUIRED: Comment on the situation at Holy Cow, using some of the terms and concepts from the chapter CASE 12.2FLEXIBLE BUDGETS AND PERFORMANCE EVALUATION. Fine Metals, Inc is a wholesaler of preclous metals. The company maintains two key product lines gold and siver The company keeps the metals in both colins and bers and sells to both the investing market and the various industries that use silver in their manufacturing process. Keith Bolton, president of Fine Metals, Inc, has assigned responsibility for sales to theee managers, one in charge of gold sales to investors Cloy Bames), one in charge of sliver sales to investors (Pete Blake), and one in charge of industrial sales of silver (Joey Michaels). Each subdivision of the business develops its own budget which is then "Texed" to develop variances once a sales period has ended. This variance analysis is used to judge the performance of the three managers. The following table contains the key infor- mation for the three branches of the business for the latest year No inventory changes have taken place as the company buys only what it sels in an arbitrage market-t does not really hold any inventory on hand. The results are Fine Metals, Inc The company does net have enough sales to really infiuence the trends in the marketplace Individual managers, however, can be more or less successtul at moving their products, using mar keting pitches on major television networks and radio programs to move the product into the markatplace Sliver industrial sales are an exception to this type of marketing. Here, the marketing dollars need to go into trade shows and trade publications, including the buyersguides that pur- chasing agents use when making purchases for their company. it is a very different business from the investing side of the house, facing diterent types of competition Market demand is much steadier for industrial sales, also, as companies that make products using siliver are fairly large and reliable consumers of the silver ingots, Industrial sales can buy in larger quantities, driving down ts acquisuition costs as compared to the other two products EVALIATING AND IPPWOVING ENTITY The gold market is volatle, with annual price swings being significant. when economies get inExplanation / Answer
Variance Analysis Gold Investment Data Silver Investment Data Silver Industrial Data Budget Actual Variance Budget Actual Variance Budget Actual Variance Sales in ounces 12,00,000 11,50,000 -50,000 25,00,000 28,50,000 3,50,000 34,25,000 35,00,000 75,000 Ounces 759 772 18,354 95,238 1,07,547 3,26,190 1,30,476 1,32,075 42,381 Average price per ounce 1,580 1,490 -68,354 26 27 23,810 26 27 32,619 Variable acquisition costs per ounce 35 39 2,848 10 11 95,238 9 9 32,619 Fixed acquisition costs 25,00,00,000 25,75,00,000 -75,00,000 1,05,00,000 1,20,00,000 -15,00,000 2,05,00,000 1,95,00,000 10,00,000 Variable SG&A costs per ounce 41 42 -2 12 13 -1 10 10 1 Fixed SG&A costs 4,00,00,000 4,50,00,000 -50,00,000 37,50,000 35,00,000 2,50,000 42,50,000 45,00,000 -2,50,000 The performance of Silver industrial data is best where all the components have favourable variance here I would like to say that for cost I have deducted budget-actual whereas in sales actual -budget
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.