Answered step by step
Verified Expert Solution
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
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 | |||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started