Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you help me with excel project. The case and questions required are on the paper and numbers that are not readable are after photo.

Can you help me with excel project. The case and questions required are on the paper and numbers that are not readable are after photo. I need formulas as well to put them in excel. PLEASE

image text in transcribed

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Petroleum Accounting: Principles, Procedures; And Issues

Authors: Dennis Jennings, John Brady, Rich Shappard, Craig Friou

8th Edition

0940966328, 978-0940966321

More Books

Students also viewed these Accounting questions

Question

What are the challenges associated with tunneling in urban areas?

Answered: 1 week ago

Question

What are the main differences between rigid and flexible pavements?

Answered: 1 week ago

Question

What is the purpose of a retaining wall, and how is it designed?

Answered: 1 week ago

Question

How do you determine the load-bearing capacity of a soil?

Answered: 1 week ago

Question

what is Edward Lemieux effect / Anomeric effect ?

Answered: 1 week ago

Question

How do rules guide verbal communication?

Answered: 1 week ago