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 in 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 in
