Calculate direct material usage variance

Assignment Help Financial Accounting
Reference no: EM13877152

Summary Problem: All Variances Funtime, Inc., manufactures video game machines. Market satu- ration and technological innovations caused pricing pressures that resulted in declining profits. To stem the slide in profits until new products can be introduced, top management turned its attention to both manufacturing economics and increased production. To realize these objectives, manage- ment developed an incentive program to reward production managers who contribute to an increase in the number of units produced and a decrease in costs.

The production managers responded to the pressure of improving manufacturing in several ways that increased the number of completed units beyond normal production levels. The assembly group puts together video game machines that require parts from both the printed circuit boards (PCB) and the reading heads (RH) groups. To attain increased production levels, the PCB and RH groups began rejecting parts that previously would have been tested and modified to meet manufacturing standards. Preventive maintenance on machines used to produce these parts has been postponed; only emergency repair work is being performed to keep production lines moving. The maintenance department is concerned about serious breakdowns and unsafe operating conditions.

The more aggressive assembly group production supervisors pressured maintenance personnel to attend to their machines rather than those of other groups. This resulted in machine downtime in the PCB and RH groups that, when coupled with demands for accelerated parts delivery by the assembly group, led to more frequent rejection of parts and increased friction among departments.

Funtime operates under a standard cost system. The standard costs per video game machine are as follows:

Standard Cost per Unit

Cost Item

Quantity

Cost

Total

Direct materials:



Housing unit

1

$20

$20

Printed circuit boards

2

15

30

Reading heads

4

10

40

Direct labor:



Assembly group

2.0 hours

10

20

PCB group

1.0 hour

11

11

RH group

1.5 hours

12

18

Total standard cost per unit

$139

Funtime prepares monthly performance reports based on standard costs. The following is the contribution report for May 2010 when production and sales both reached 2,200 units.

FUNTIME INC.

Contribution Report For the Month of May 2010


Budget

Actual

Variance

 Units

2,000

2,200

200F

Revenue

$400,000

$396,000

$ 4,000U

Variable costs: Direct materials

$180,000

$220,400

$40,400U

Direct labor

98,000

112,260

14,260U

Total variable costs

278,000

332,660

54,660U

Contribution margin

$122,000

$ 63,340

$58,660U

Funtime's top management was surprised by the unfavorable contribution margin variance in spite of the increased sales in May. Constance Brown, the firm's cost accountant, was asked to identify and report on the reasons for the unfavorable contribution margin as well as the individuals or groups responsible for them. After her review, Constance prepared the following usage report:

FUNTIME INC.

Usage Report For the Month of May 2010

Cost Item

Quantity

Actual Cost

Direct materials:



Housing units

2,200 units

$ 44,000

Printed circuit boards

4,700 units

75,200

Reading heads

9,200 units

101,200

Direct labor:

Assembly

3,900 hours

31,200

Printed circuit boards

2,400 hours

31,060

Reading heads

3,500 hours

50,000

Total variable cost

 

$332,660

Constance reported that the PCB and RH groups supported the increased production levels but experienced abnormal machine downtime, causing idle time that required the use of overtime to keep up with the accelerated demand for parts. This overtime was charged to direct labor. She also reported that the production managers of these two groups resorted to parts rejections, rather than testing and modifying them, as was done routinely in the past. Constance determined that the assembly group met management's objectives by increasing production while utilizing fewer-than- standard hours.

Required

1. Set up an Excel spreadsheet to calculate the following variances:

a. Direct material price variance, calculated at point of production.

b. Direct material usage variance.

c. Direct labor efficiency variance.

d. Direct labor rate variance.

e. Selling price variance.

f. Sales volume variance, in terms of contribution margin.

2. Determine the components of the $58,660 unfavorable variance between budgeted and actual contribu- tion margin during May 2010.

3. Identify and briefly explain the behavioral factors that could promote friction among the production managers and between them and the maintenance manager.

4. Evaluate Constance Brown's analysis of the unfavorable contribution results in terms of the report's completeness and its effect on the behavior of the production groups.

Reference no: EM13877152

Questions Cloud

Voltage of an electromagnetic wave traveling : The voltage of an electromagnetic wave traveling on a transmission line is given by v (z, t) =5e-az sin (4p x 109t - 20p2) (V), where z is the distance in meters from the generator.
Differences between an intentional tort : 1.  Other than "intent" what are he differences between an intentional tort and one that is not intentional?  for example, do they have different standards of proof? Different consequences? Other differences? Thoughts?
How would each of these whistleblowers fare : How would each of these whistleblowers fare under the law in Maryland - The company later learned that Zonyl breaks down into a substance that persists in the blood of humans, but by then the chemical was a best seller. When DuPont restructured..
Expression for the vertical velocity of particle : Suppose a tiny particle were to be attached to the string at x = 5 cm, obtain an expression for the vertical velocity of the particle as a function of time.
Calculate direct material usage variance : Calculate Direct material usage variance, Direct labor efficiency variance, Direct labor rate variance and Selling price variance.
Define the competition that the nba faces : How realistic is the goal of deputy commissioner Mark Tatum? What are the most significant challenges to accomplish this goal? Define the "competition" that the NBA faces as it enhances its presence in the Chinese market. What would your marketing pl..
What are the effects of the type of business entity : What are the effects of the type of business entity on the ability to contract for the sale of the business?  Sole Proprietorship, Partnership, Corporation, and LLC.
Find the firm''s profit-maximizing level of output and price : The market demand function for product of a monopolist with the total cost function TC(Q) = 2Q3-10Q2+ 30Q + 100 is given by P = 65000 - 8jQ- Find the firm's profit-maximizing level of output and price.
Fastart corporation makes batteries for motor vehicles : Fastart Corporation makes batteries for motor vehicles. The Federal Trade Commission (FTC) learns that Gas-Up Auto Parts Stores, a retail company that sells Fastart's batteries, engages in deceptive advertising practices. What actions can the FTC tak..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Balance in the raw materials inventory account

Cost of goods manufactured, balance in the raw materials inventory account and the cost of goods manufactured for May

  Compute the break-even point in units and sales dollars

Mozena Corporation has collected the following information after its first year of sales. Sales were $1,762,500 on 117,500 units; selling expenses $267,500 (42% variable and 58% fixed); direct materials $528,500; direct labor $307,500; Compute the br..

  Environmental issues-gasoline four-cylinder model

Mary Zimmerman decided to purchase a new automobile. Being concerned about environmental issues, she is leaning toward the hybrid rather than the completely gasoline four-cylinder model.  Determine the payback period of the incremental investment if ..

  Natural supplements to customers with unconditional right

Botanic Choice sells natural supplements to customers with an unconditional right of return if they are not satisfied. The right of returns extends 60 days. On February 10, 2014, a customer purchases $3,000 of products (cost $1,500). Assuming that ba..

  1the following are selected items from the accounting

1.the following are selected items from the accounting records of seattle chocolates for the year ended december 31

  Conversion costs are added uniformly over production process

The following unit data were assembled for the assembly process of the Super Co. for the month of June. Direct materials are added at the beginning of the process. Conversion costs are added uniformly over the production process. The company uses the..

  Complete consolidation working papers for powell corporation

Powell Corporation acquired 90% of the voting stock of Santer Corporation on January 1, 2014 for $11,700 when Santer had Capital Stock of $5,000 and Retained Earnings of $4,000. Complete the consolidation working papers for Powell Corporation and Sub..

  The product in physical inventory-periodic inventory system

There are 15 units of the product in the physical inventory at November 30. The periodic inventory system is used. Determine the both cost of goods sold and ending inventory cost by a) FIFO b) lifo and c) average cost methods.

  Regarding commercial banking balance sheets

Regarding commercial banking balance sheets. First, use a T-account to show how a $100 deposit affects the balance sheet. Separate the funds into required reserves and excess reserves using a required reserve ratio of 0.1. Second, demonstrate what ha..

  Write two accounting equations to show the effects

Bob Martin, P.A., collected cash on account from a client for whom the business had provided delivery services one month earlier.

  Expected useful life and residual value are unchanged

On January 1, 2010, the company purchased equipment for $600,000. The equipment has a 20-year expected useful life and $0 residual value. Initially, the company used double-declining-balance depreciation. On January 1, 2013, the company changed to st..

  Determine the difference in the amount of income

Determine the difference in the amount of income that the company would have reported if it had used the FIFO method instead of the LIFO method. Would income have been greater or less?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd