Part of your company's accounting database was destroyed during a ransomware attack. You have been able to gather the following data from your files. Reconstruct the remaining information using the available data. All of the raw material purchased during the period was used in production. Note: Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "O" for no effect (i.e., zero variance). Round "Standard Quantity per Unit of Output" to 2 decimal places. Direct Labor Direct Material Standard price or rate per unit of input Standard quantity per unit of output Actual quantity used per unit of output $ 20.00 per hour $ 12.00 per pound 2.68 hours per unit pounds per unit 2.50 hours 4.83 pounds per unit Actual output Actual price or rate per unit of input Direct-material price variance $ 21.00 per hour $ 11.00 per pound 10,000 units 10,000 units $ 52,500 F Direct-material quantity variance $ (18,000) U Total direct-material variance $ 34,500 F Direct-labor rate variance $ (25,000) U Direct-labor efficiency variance $ 35,000 F Total direct-labor variance $ 10,000 F

Part of your company's accounting database was destroyed during a ransomware attack. You have been able to gather the following data from your files. Reconstruct the remaining information using the available data. All of the raw material purchased during the period was used in production. Note: Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "O" for no effect (i.e., zero variance). Round "Standard Quantity per Unit of Output" to 2 decimal places. Direct Labor Direct Material Standard price or rate per unit of input Standard quantity per unit of output Actual quantity used per unit of output $ 20.00 per hour $ 12.00 per pound 2.68 hours per unit pounds per unit 2.50 hours 4.83 pounds per unit Actual output Actual price or rate per unit of input Direct-material price variance $ 21.00 per hour $ 11.00 per pound 10,000 units 10,000 units $ 52,500 F Direct-material quantity variance $ (18,000) U Total direct-material variance $ 34,500 F Direct-labor rate variance $ (25,000) U Direct-labor efficiency variance $ 35,000 F Total direct-labor variance $ 10,000 F

Name: Part of your company's accounting database was destroyed during a ran
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Part of your company's accounting database was destroyed during a ransomware attack. You have been able to gather the followingdata from your files. Reconstruct the remaining information using the available data. All of the raw material purchased du

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter24: Material And Labor Variances (primevar)

Section: Chapter Questions

Problem 5R: Close the PRIMEVAR4 file and open PRIMEVAR3. Click the Chart sheet tab. On the screen is a graphical...

See similar textbooks

Similar questions

at James, the purchasing agent for a local plant of the Oakden Electronics Division, was considering the possible purchase of a component from a new supplier. The component’s purchase price, $0.90, compared favorably with the standard price of $1.10. Given the quantity that would be purchased, Pat knew that the favorable price variance would help to offset an unfavorable variance for another component. By offsetting the unfavorable variance, his overall performance report would be impressive and good enough to help him qualify for the annual bonus. More importantly, a good performance rating this year would help him to secure a position at division headquarters at a significant salary increase.Purchase of the part, however, presented Pat with a dilemma. Consistent with his past behavior, Pat made inquiries regarding the reliability of the new supplier and the part’s quality. Reports were basically negative. The supplier had a reputation for making the first two or three deliveries…
In a manufacturing process the assembly line speed (feet per minute) was thought to affect the number of defective parts found during the inspection process. To test this theory, managers devised a situation in which the same batch of parts was inspected visually at a variety of line speeds. They collected the following data: Develop a scatter chart with line speed as the independent variable. What does the scatter chart indicate about the relationship between line speed and the number of defective parts found? Use the data to develop an estimated regression equation that could be used to predict the number of defective parts found, given the line speed. What is the estimated regression model? Test whether each of the regression parameters β0 and β1 is equal to zero at a 0.01 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? How much of the variation in the number of defective parts found for the sample data does the model you estimated in part (b) explain?
The management of Golding Company has determined that the cost to investigate a variance produced by its standard cost system ranges from 2,000 to 3,000. If a problem is discovered, the average benefit from taking corrective action usually outweighs the cost of investigation. Past experience from the investigation of variances has revealed that corrective action is rarely needed for deviations within 8% of the standard cost. Golding produces a single product, which has the following standards for materials and labor: Actual production for the past 3 months follows, with the associated actual usage and costs for materials and labor. There were no beginning or ending raw materials inventories. Required: 1. What upper and lower control limits would you use for materials variances? For labor variances? 2. Compute the materials and labor variances for April, May, and June. Identify those that would require investigation by comparing each variance to the amount of the limit computed in Requirement 1. Compute the actual percentage deviation from standard. Round all unit costs to four decimal places. Round variances to the nearest dollar. Round variance rates to three decimal places so that percentages will show to one decimal place. 3. CONCEPTUAL CONNECTION Let the horizontal axis be time and the vertical axis be variances measured as a percentage deviation from standard. Draw horizontal lines that identify upper and lower control limits. Plot the labor and material variances for April, May, and June. Prepare a separate graph for each type of variance. Explain how you would use these graphs (called control charts) to assist your analysis of variances.
Close the PRIMEVAR4 file and open PRIMEVAR3. Click the Chart sheet tab. On the screen is a graphical representation of the variances computed in requirement 3. Review the chart and answer the following questions: a. Which variances does each bar represent? A __________ B __________ C __________ D __________ b. Which of the variances shown would be of most concern to management for immediate attention? (Consider groups of variances and materiality also.) Explain. When the assignment is complete, close the file without saving it again. Worksheet. McGrade Industries also has the following information regarding overhead for October: actual overhead 375,000, standard variable overhead of 3 per direct labor hour, and standard fixed overhead of 5 per direct labor hour (based on 47,000 hours budgeted). Modify the PRIMEVAR3 worksheet to compute all appropriate overhead variances. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as PRIMEVART. Hint: Insert several new rows in the Data Section and in the Answer Section. Chart. Using the PRIMEVAR3 file, prepare a 3-D stacked bar chart to compare total standard cost per unit with actual cost per unit. Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. You do not need to use cell references when completing the table. Enter all appropriate titles, legends, and formats. Enter your name somewhere on the chart. Save the file again as PRIMEVAR3. Print the chart.
Many companies use a quality control technique called acceptance sampling to monitor incoming shipments of parts, raw materials, and so on. In the electronics industry, component parts are commonly shipped from suppliers in large lots. Inspection of a sample of n components can be viewed as the n trials of a binomial experiment. The outcome for each component tested (trial) will be that the component is classified as good or defective. Reynolds Electronics accepts a lot from a particular supplier if the defective components in the lot do not exceed 1%. Suppose a random sample of five items from a recent shipment is tested. Assume that 1% of the shipment is defective. Compute the probability that no items in the sample are defective. Assume that 1% of the shipment is defective. Compute the probability that exactly one item in the sample is defective. What is the probability of observing one or more defective items in the sample if 1% of the shipment is defective? Would you feel comfortable accepting the shipment if one item was found to be defective? Why or why not?
Acme Inc. has the following information available: A. Compute the material price and quantity, and the labor rate and efficiency variances. B. Describe the possible causes for this combination of favorable and unfavorable variances.
Pat James, the purchasing agent for a local plant of the Oakden Electronics Division, was considering the possible purchase of a component from a new supplier. The component’s purchase price, $0.90, compared favorably with the standard price of $1.10. Given the quantity that would be purchased, Pat knew that the favorable price variance would help to offset an unfavorable variance for another component. By offsetting the unfavorable variance, his overall performance report would be impressive and good enough to help him qualify for the annual bonus. More importantly, a good performance rating this year would help him to secure a position at division headquarters at a significant salary increase. Purchase of the part, however, presented Pat with a dilemma. Consistent with his past behavior, Pat made inquiries regarding the reliability of the new supplier and the part’s quality. Reports were basically negative. The supplier had a reputation for making the first two or three deliveries on…
You brought your work home one evening, and your nephew spilled his chocolate milk shake on the variance report you were preparing. Fortunately, knowing that overhead was applied based on machine hours, you were able to reconstruct the obliterated information from the remaining data. Fill in the missing numbers below. Note: Round your per machine hour and per unit answers to two decimal places. Indicate the effect of the variance by selecting "Positive" or "Negative". Select "None" and enter "0" for no effect (i.e., zero variance). Standard Machine hours per unit of output 5 hours Standard Variable-overhead rate per machine hour $9 Actual variable-overhead rate per mchine hours ? Actual machine hours per unit of output ? Budgeted fixed overhead $27,500 Actual fixed overhead ? Budgeted production in units 11,000 Actual production in units…
Part of your company’s accounting database was destroyed when Godzilla attacked the city. You have been able to gather the following data from your files. Reconstruct the remaining information using the available data. All of the raw material purchased during the period was used in production. (Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "0" for no effect (i.e., zero variance). Round "per unit" answer values to 2 decimal places.) Direct Labor Direct Material Standard price or rate price per unit of input ? per unit $7.00 per lb Standard Quantity per unit of output ? hours per unit 6.40 lbs per unit Actual quantity used per unit of output $1.80 hours 6.80 lbs per unit Actual price or rate per unit $11 per hour $6.00 per lb Actual Output 5,000 units 5,000 units Direct-material price variance $34,000 F Direct-material quantity variance $14,000 U Total direct-material variance $20,000 F…
I have the other problems solved but I am having a hard time with part D of the assignment, Further analyze harlows revised variances, isolating underlying potential causal factors. How do your analyses indicate bases for concern to management I have attached the problem with the data information
In 2020 standard cost variance analysis report presented by the controller of ABC Corporation, the labor cost variance shows that efficiency has resulted to favorable variance, while rate shows unfavorable variance. Which of the following could have been the reason for the said outcome? The workers assigned in the production department were experienced and skilled individuals and relatively high paid The workers assigned by the human resources management were unskilled and relatively low paid The workers were pushed to over time due to inefficiency in making the product. Low quality materials were used and caused more labor hours to be produced
Ironwood Company manufactures cast-iron barbeque cookware. During a recent windstorm, it lost some of its cost accounting records. Ironwood has managed to reconstruct portions of its standard cost system database but is still missing a few pieces of information. See attached imageRequired:Use the information in the table to determine the unknown amounts. You may assume that Ironwood does not keep any raw materials on hand. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).