Search here for Tutorials

If the Data is different in your question, please send your questions to homeworksolutionsnow@gmail.com. The questions will be answered at the same price.

Week 8 P8-3, P8-7 P8-13 EXCEL TEMPLATES

Week 8 P8-3, P8-7 P8-13 EXCEL TEMPLATES

 
P8-3 Materials and labor variances analyses
P8-3 Accelerator, Inc. manufactures a fuel additive, Stomp, that has a stable selling price of $44 per drum. The company has been producing and selling 80,000 drums per month.
 

In connection with your examination of Accelerator’s financial statements for the year ended September 30, management has asked you to review some computations made by Accelerator’scost accountant. Your working papers disclose the following about the company’s operations:

 
Standard costs per drum of product manufactured:

Materials:
8 gallons of chemicals@$2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .               $16
1 empty drum @ $1/drum . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .             1                  $17
Direct labor: 1 hour @ $8/hour  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .                               $ 8
Factory Overhead . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .                             $ 6
 

Costs and expenses during September:
Stomp: 600,000 gallons purchased at a cost of $1,140,000; 645,000 gallons used.
Empty drums: 94,000 purchased at a cost of $94,000; 80,000 drums used.
Direct labor: 81,000 hours worked at a cost of $654,480.
Factory overhead: $768,000.


Required:
Calculate the following variances for September
1. Materials quantity variance.
2. Materials purchase price variance.
3. Labor efficiency variance.
4. Labor rate variance.

 
P8-7 Materials and labor variance analyses
P8-7 The standard cost summary for the most popular product of Excelsior Products Company is shown as follows, together with production and cost data for the period.


Standard Cost Summary
Materials:
2 gallons of liquid lead@$2.00/gallon . . . . . . . . . . . . . . . . . . . . . . . . . . . . .             $4.00
2 gallons of varnish@$3.00/gallon . . . . . . . . . . . . . . . . . . . . . . . . . . . .                      $6.00    $10.00
Labor:
1 hour@$12.00/hour. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .                                 12.00
Factory overhead:
$1.00 per direct labor hour . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .                                  1.00
Total standard unit cost . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .                              $23.00
Production and Cost Summary
Units completed during the month . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .               9,000
Ending units in process (one-fourth completed) . . . . . . . . . . . . . . . . . .                     2,000
Gallons of liquid lead used . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .             21,000
Gallons of varnish used . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .            20,000

Direct labor hours worked . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .            10,000
Cost of liquid lead used . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .            41,160
Cost of varnish used . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .           60,000
Cost of direct labor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .           117,000

 
One gallon each of liquid lead and varnish are added at the start of processing. The balance of the materials is added when the process is two-thirds complete. Labor and overhead are added evenly throughout the process.
 

Required:
1. Calculate equivalent production. (Be sure to refer to the standard cost summary to help determine the percentage of materials in ending work in process.)
2. Calculate materials and labor variances and indicate whether they are favorable or unfavorable.
3. Determine the cost of materials and labor in the work in process account at the end of the month.
4. Prove that all materials and labor costs have been accounted for.
 

P8-13 Variance analysis
P8-7 Folsom Shirts, Inc., manufactures men’s sport shirts for large stores. Folsom produces a single quality shirt in lots of a dozen according to each customer’s order and attaches the store’s label.


The standard costs for a dozen shirts include the following:
Direct materials . . . . . . . . . . . . . . . . . . . . . . . . . . . .               24yards@$0.55/yard            $13.20
Direct labor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .             3hours@$7.35/hour                  22.05
Factory overhead . . . . . . . . . . . . . . . . . . . . . . . . . .                3hours@$2.00/hour                   6.00
Standard cost per dozen . . . . . . . . . . . . . . . . . .                                                                     $41.25

 
During October, Folsum worked on three orders for shirts. Job cost records for the month disclose the following:
Lot                  Units in Lot                 Materials Used            Hours Worked
30                    1,000 dozen                24,100 yards                           2,980
31                    1,700 dozen                40,440 yards                          5,130
32                    1,200 dozen                28,825 yards                           2,890 


The following information is also available:
a. Folsom purchased 95,000 yards of materials during October at a cost of $53,200. The materials price variance is recorded when goods are purchased, and all inventories are carried at standard cost.
b. Direct labor incurred amounted to $81,400 during October. According to payroll records, production employees were paid $7.40 per hour.
c. Overhead is applied on the basis of direct labor hours. Factory overhead totaling $22,800 was incurred during October.
d. A total of $288,000 was budgeted for overhead for the year, based on estimated production at the plant’s normal capacity of 48,000 dozen shirts per year. Overhead is 40% fixed and 60% variable at this level of production.
e. There was no work in process at October 1. During October, Lots 30 and 31 were completed, and all materials were issued for Lot 32, which was 80% completed as to labor and overhead.

 
Required:
1. Prepare a schedule computing the October standard cost of Lots 30, 31, and 32.
2. Prepare a schedule computing the materials price variance for October and indicate whether it is favorable or unfavorable.
3. For each lot produced during October, prepare schedules computing the following (indicate whether favorable or unfavorable):
a.Materials quantity variance in yards.
b. Labor efficiency variance in hours. (Hint: Don’t forget the percentage of completion.)
c. Labor rate variance in dollars.
4. Prepare a schedule computing the total controllable and volume overhead variances for October and indicate whether they are favorable or unfavorable.


SOLUTION PREVIEW
Problem 8-13
1. Prepare a schedule computing the October standard cost of Lots 30, 31, and 32.
Standard Cost of Production for October
Lot
Quantity (Dozens)
Standard Cost per Dozen
Total Standard Cost
30
                        1,000
 $                     41.25
 $                   41,250
31
                        1,700
 $                     41.25
                      70,125
32
                        1,200
 $                     35.64
                      42,768
          Standard cost of production
 $                  154,143

 

File name: Week-8-P8-3-P8-7-P8-13.xls File type: application/vnd.ms-excel Price: $20