Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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_2

Step: 3

blur-text-image_3

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

The Myth Of Measurement Inspection Audit Targets And The Public Sector

Authors: Nick Frost

1st Edition

1529732662, 978-1529732665

More Books

Students also viewed these Accounting questions

Question

OLAP analyze current data. True False

Answered: 1 week ago

Question

a. What is the probability that the family has x male children?

Answered: 1 week ago