Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you upload the to google drive and put the link or you can make a excel sheet and take screenshot or maybe just solve
Can you upload the to google drive and put the link or you can make a excel sheet and take screenshot or maybe just solve on paper and I will do something
Nike produces golf carts. BUDGETED: Budgeted Volume: 1,000 carts Raw Materials Rubber: 2 kg per cart @ $2.40 per kg Metal: 3 sheets per cart @$1.50 per sheet Direct Labour 0.10 hours per cart @ $15.00 per hour Overhead $4.00 variable per hour plus $5,000 fixed overhead. ACTUAL: Actual Output: 980 carts Purchases Rubber: 2,500 kg @ $2.50 per kg Metal: 4,000 sheets @ $1.40 per sheet Usage 1,940 kg rubber 3,020 sheets metal Direct Labour 110 hours @ $16.00 per hour Overhead $500 variable $5,000 fixed REQUIRED: Create an excel spreadsheet that will compute all material, labour and overhead variances (12 in total) when the above numbers are entered. Use cell references rather than numbers in all your formulas. I should be able to change input numbers to get new correct variances. Make sure you test your results (with numbers for which you know the answers). MPV-Rubber (2), MPV Metal (2), MEV-Rubber, MEV-Metal LRV, LEV, VOHSV, VOHEV, FOHPVV, FOHSVStep 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