You brought your work home one evening, and your nephew spilled his chocolate milk shake on the variance reportyou were preparing. Fortunately, knowing that overhead was applied based on machine hours, you were able toreconstruct 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 thevarlance by selecting "Positive" or "Negative". Select "None" and enter "O" for no effect (l.e., zero varlance).Standard machine hours per unit of output5 hoursStandard variable-overhead rate per machine hour$9.00Actual variable-overhead rate per machine hourActual machine hours per unit of outputBudgeted fixed overhead$31,625Actual fixed overheadBudgeted production in units11,500Actual production in unitsVariable-overhead spending variance$34,000 UnfavorableVariable-overhead efficiency variance$126,000 FavorableFixed-overhead budget variance$9,500 UnfavorableFixed-overhead volume varianceTotal actual overhead$381,125Total budgeted overhead (flexible budget)Total budgeted overhead (static budget)Total applied overhead$458,400

Name: You brought your work home one evening, and your nephew spilled his c
Uploaded: 2024-03-04T10:43:15.000Z
Channel: Bartleby
Description: You brought your work home one evening, and your nephew spilled his chocolate milk shake on the variance reportyou were preparing. Fortunately, knowing that overhead was applied based on machine hours, you were able toreconstruct the obliterated inf

Variance analysis is a tool used in management accounting. In this, we calculate the deviations of…

Answered: Fill in the missing numbers below.

Business

Accounting

Fill in the missing numbers below.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter23: Flexible Budgeting (flexbud)

Section: Chapter Questions

Problem 6R

See similar textbooks

Similar questions

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. Standard machine hours per unit of output ............................................... 4 hoursStandard variable-overhead rate per machine hour ............................... $8.00Actual variable-overhead rate per machine hour ............................................. bActual machine hours per unit of output ............................................................. dBudgeted fixed overhead .................................................................................... $50,000Actual fixed overhead ..................................................................................................... aBudgeted production in units…
The managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c. Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs +(9) x Billable Hours (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) X Monthly Overhead Costs and Billable Hours Data Overhead Costs Billable Hours $315,000 3,000 $360,000 4,000 $385,000 5,000 $438,000 6,000 $520,000 7,000 $540,000 8,000 D Print Done
Simkin Corporation keeps careful track of the time required to fill orders. Data concerning a particular order appear below: Wait time Process time Inspection time Move time. Queue time The manufacturing cycle efficiency (MCE) was closest to: (Round your intermediate calculations to 1 decimal place.) Multiple Choice O 0.51 O 0.10 0.15 Hours 20.8 2.5 0.3 2.9 5.0 O 0.23
Silven Company has identified the following overhead activities, costs, and activity drivers for the coming year: Activity Expected Cost Activity Driver Activity Capacity Setting up equipment $138,000 Number of setups 120 Ordering materials 21,600 Number of orders 1,200 Machining 107,100 Machine hours 11,900 Receiving 16,740 Receiving hours 930 Silven produces two models of cell phones with the following expected activity demands: Model X 4,600 80 400 Units completed Number of setups Number of orders Machine hours Receiving hours Required: 6,800 310 Model X Model Y Model Y 9,200 40 800 5,100 620 1. Determine the total overhead assigned to each product using the four activity drivers. Total Overhead Assigned
Management of Mittel Company wants to reduce the elapsed time from when a customer places an order to when it is shipped. It provided the following data for a recent quarter: Inspection time Wait time (from order to start of production) Process time Move time Queue time Required: 1. Compute the throughput time. Note: Round your answer to 1 decimal place. 0.6 day 16.7 days 3.1 days 0.5 day 4.1 days 2. Compute the manufacturing cycle efficiency (MCE) for the quarter. Note: Round your percentage answer to nearest whole percent. 3. What percentage of the throughput time was spent in non-value-added activities? Note: Round your percentage answer to nearest whole percent. 4. Compute the delivery cycle time. Note: Round your intermediate calculations and final answer to 1 decimal place. 5. If using Lean Production eliminates all queue time, what will be the new MCE? Note: Do not round intermediate calculations. Round your percentage answer to 1 decimal place. 1. Throughput time 2.…
A manufacturing firm just received a shipment of 20 assembly parts, of slightly varied sizes, from a vendor. The manager knows that there are only 15 parts in the shipment that would be suitable. He examines these parts one at a time.a. Find the probability that the first part is suitable. (Round your answer to 2 decimal places.) b. If the first part is suitable, find the probability that the second part is also suitable. (Round your answer to 4 decimal places.) c. If the first part is suitable, find the probability that the second part is not suitable. (Round your answer to 4 decimal places.)
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 managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c. Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs = +xBillable Hours X Monthly Overhead Costs and Billable Hours Data (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) Overhead Costs Billable Hours 0 $315,000 3,000 $365,000 4,000 $395,000 5,000 $447,000 6,000 $530,000 7,000 $550,000 8,000
Vandenheuvel Corporation keeps careful track of the time required to fill orders. The times recorded for a particular order appear below: Move time Wait time Queue time Process time Inspection time Multiple Choice 0.36 The manufacturing cycle efficiency (MCE) was closest to: (Round your Intermediate calculations to 1 decimal place.) 0.06 0.04 Hours 2.4 0.14 31.9 28.4 2.0 0.4
In the Excel, or spreadsheet, approach to recording financial transactions, if manufacturing overhead is underapplied by X dollars, the Manufacturing Overhead account is closed out by deducting X dollars in the Manufacturing Overhead column and deducting X dollars in the Retained Earnings column. True or False True False
Hi, I need help imputting the following values. Thank you. NOTES: #1: (Round answer to 2 decimal places.) #2: (Round "predetermined overhead rate" to 2 decimal places. Round other calculations and final answer to the nearest whole dollar.) #3 and #4: (Round intermediate calculations to the nearest whole number and final answer to 2 decimal places.)
My formular function was wrong in cell C5 in contribution sheet. Please give me the right solution. Instruction: Enter a SUMIFS function into cell C5 on the Contribution worksheet that sums the Sales Revenue on the Sales and Cost Data worksheet based on the year that is entered into cell B1 on the Contribution worksheet. The data to be summed is in Column E on the Sales and Cost Data worksheet. The function should find a match in the Year column on the Sales and Cost Data worksheet to the year entered in cell B. The function should also find a match to the item in cell A5 (Sales Revenue) in Column C on the Sales and Cost Data worksheet. Add cell capacity to include Row 100 on the Sales and Cost Data worksheet.