Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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, FOHSV

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

Financial Accounting

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

3rd Edition

0471372668, 978-0471372660

More Books

Students also viewed these Accounting questions

Question

Confronting Objections to the Economic Approach

Answered: 1 week ago

Question

According ti the january 3 1 , 2 0 2 2 physical inventory count

Answered: 1 week ago