Problem 5 .iN Excel
PTER FVE Measure Actual quantity Standard quantity Actual price Standard price Materials 150 parts 2,000 parts $575 5.00 Labor 188 hours 168 hours $20.00 per hour $18.00 per hour a. Complete a price and efficiency variance for the materials used by Blue Sp b. Complete a price and efficiency variance for the labor used by Blue Spruce. c.Where is the biggest problem? Why? 6. VARIANCE ANALYSIS. Hang Ten is a smal l manufacturer of fasteners used in the ufacturing of hang gliders. It is a competitive business, with only a few major customer and a lot of machine shops like Hang company has improved its materials to improve it product offerings. In order to top of things, management at Hang Ten runs a variance analysis every it stays on target. The following table contains its results for September. Ten competing for this specialized business, The stay on month to make sure Measure Actual quantity Standard quantity Actual price Standard price Materials 1,500 pounds 1,600 pounds $1.50 per pound $145 pe pound $600per hour Labor 4,000 hours 3600 hours $15.00 per hour a. Complete a pri b. Com c. How well did Hang Ten perform? Why? ice and efficiency variance for the material plete a price and efficiency variance for the labor us s used by Hang Ten. ed by Hang Ten. staplers. It he internal Tom Burns, manu- tries makes currently buys the parts that make up the casing of the stapler, only producing t mechanicals. It makes and sells 5,000,000 staplers per year. Recently, facturing vice president, has been looking into the potential to make all would go into the product. It currently pays S1.25 for the outer parts. The buy a used machine to make these parts for $24,000. The machine woul life. It would require four workers, paid $15 per hour Materials would cost $1. Overh have a four-year
Expert Answer
Standard | Actual | |||||
Particulars | Qty/ hours | Rate | amount | Qty/ hours | Rate | amount |
Materials | 2,000.00 | 5.00 | 10,000.00 | 2,150.00 | 5.75 | 12,362.50 |
Labour | 168.00 | 18.0000 | 3,024.00 | 188.00 | 20.00 | 3,760.00 |
DMPV = (SP-AP)*AQ purchased | ||||||
DMPV = (5 – 5.75)2150 | ||||||
DMPV = 1,612.50 U | ||||||
DMQV= (SQ-AQ)SP | ||||||
DMQV= (2000 – 2150)5 | ||||||
DMQV= 750 U | ||||||
DLRV= (SR-AR)AH | ||||||
DLRV= (18 – 20)188 | ||||||
DLRV= 376 U | ||||||
DLEV = (SH-AH)SR | ||||||
DLEV = (168 – 188)18 | ||||||
DLEV = 360 U |