Cost Formula Actual Cost in March Utilities $16,600 + $0.11 per machine-hour $ 20,270 Maintenance $38,300 + $1.50 per machine-hour $ 57,600 Supplies $0.80 per machine-hour $ 13,400 Indirect labor $94,600 + $1.80 per machine-hour $ 126,100 Depreciation $68,000 $ 69,700 During March, the company worked 15,000 machine-hours and produced 9,000 units. The company had originally planned to work 17,000 machine-hours during March.
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: Answer 1)
Q: 1. Prepare a flexible budget for March. 2. Prepare a report showing the spending variances for…
A: 1) FAB Corporation Flexible Budget For the Month Ended March 31 Machine-hours…
Q: After much effort and analysis, you determined the following cost formulas and gathered the…
A: The variance is the difference between actual and Budgeted cost.
Q: e president has asked that you review the company’s costing system and “do what you can to help us…
A: Solution: Activity variances are based on Budgeted amount at planned level and budgeted amounts at…
Q: Sarina is a cost controller in a manufacturing company that produces ceramic products. The…
A:
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: >Planned Budget is the static budget prepared on the basis of budgeted level and budgeted…
Q: The managers of GB Inc. are discussing ways to allocate the cost of service departments such as:…
A: Quality control cost allocated to maintenance = P350,000 * 7000/35000 = P70,000 Total cost of…
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: >Planned Budget is the static budget prepared on the basis of budgeted level and budgeted…
Q: Cain Components manufactures and distributes various plumbing products used in homes and other…
A: Direct material cost refers to the cost of the raw materials and components used to create a…
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: Activity variance is caused by the difference between planning level of activity and actual level of…
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: Flexible budget is the one that shows the estimates relating to both the fixed and variable costs.
Q: The following are some quotes provided by a number of managers at Hawkeye Machining Company…
A: Lean manufacturing: Lean manufacturing is based on the Kaizen principle. The process of continuous…
Q: You have Just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: Formulas:
Q: The head of production at your manufacturing facility said, “Our manufacturing processes are doing…
A: The head of the production is the head of the production department. The head of the production…
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: Spending Variance = Actual Results - Flexible budget results Activity Variance = Planning Budget -…
Q: fter much effort and analysis, you determined the following cost formulas and gathered the following…
A: 1. Activity Variances - Fab Corporation For the month ended March 31 Particulars Flexible…
Q: Susan Mills, Company B's chief accountant, has developed an automated costing system that helps…
A: Costing system: The company uses this framework so that it can estimate the cost of its products…
Q: Setting materials, labor, and overhead standards is challenging. If standards are set too low,…
A:
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: Solution: Activity variances are based on Budgeted amount at planned level and budgeted amounts at…
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: The variance is the difference between the actual data and standard output of the production.
Q: Q.Are these budget standards challenging for the department that produces product Z?
A: Budget: The budget is an estimation made by the management in quantitative terms. This estimation is…
Q: Cain Components manufactures and distributes various plumbing products used in homes and other…
A: ( Computation of overhead rate ) = Overhead rate = { Total overhead estimated / Estimated…
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: U= Unfavorable F= Favorable N= No effect
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: The question is based on the concept of Cost Accounting.
Q: Diane Barone was a good friend of yours in high school and is from your home town. While you chose…
A: A memo seems to be a brief formal message delivered from one individual inside a corporation or…
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: NOTE 1. A FAVOURABLE SPENDING VARIANCE MEANS THAT THE ACTUAL COST WAS LESS THAN WHAT THE COST…
Q: Having joined the company as a fresh graduate , the CFO call you to her office an gave you a report…
A: GIVEN Having joined the company as a fresh graduate, the CFO call you to her office an gave you a…
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: Budgeting: It is a process of planning the work to be performed. Under this process a formal plan is…
Q: ou have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: Cost Formula Actual Cost in March Utilities $16,800 + $0.16 per machine-hour $ 21,800…
Q: Paula Woodward is the head of the Information Systems Department at Mo Manufacturing Company. Roland…
A: Job Order Costing - It is system when customers order small and unique bathes of products in which…
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: 1. Activity Variances - Fab Corporation For the month ended March 31 Particulars Flexible…
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: Solution 1: Activity Variances - Fab Corporation For the month ended March 31 Particulars…
Q: You have Just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: The Numerical has covered the concept of Flexible Budget and Variances. The Flexible Budget is that…
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: The spending variance is the difference between actual budget and flexible budget of the production.
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: working note: 1 FAB corporation Activity variances For the month ended…
Q: Sleep Late, a large hotel chain, has been using activity-based costing to determine the cost of a…
A: Cost: Cost is that amount which is paid to get something from the any supplier and the amount which…
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: Cost variance is a disparity between the expense that was actually incurred and the expense that was…
Q: Chance Realtors, a real estate consulting firm, specializes in advising companies on potential new…
A: To calculate the bid price, required profit shall be added to the total predicted cost of the job.
Q: Required: 1. Calculate the activity variances for March. 2. Calculate the spending variances for…
A: Spending Variance A spending variance is the difference between the actual and expected (or…
Q: You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door…
A: Gg
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door opening device. The president has asked that you review the company’s costing system and “do what you can to help us get better control of our
After much effort and analysis, you determined the following cost formulas and gathered the following actual cost data for March:
| Cost Formula | Actual Cost in March | ||
| Utilities | $16,600 + $0.11 per machine-hour | $ | 20,270 |
| Maintenance | $38,300 + $1.50 per machine-hour | $ | 57,600 |
| Supplies | $0.80 per machine-hour | $ | 13,400 |
| Indirect labor | $94,600 + $1.80 per machine-hour | $ | 126,100 |
| $68,000 | $ | 69,700 | |
During March, the company worked 15,000 machine-hours and produced 9,000 units. The company had originally planned to work 17,000 machine-hours during March.
Required:
1. Calculate the activity variances for March.
2. Calculate the spending variances for March.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
- Firenza Company manufactures specialty tools to customer order. Budgeted overhead for the coming year is: Previously, Sanjay Bhatt, Firenza Companys controller, had applied overhead on the basis of machine hours. Expected machine hours for the coming year are 50,000. Sanjay has been reading about activity-based costing, and he wonders whether or not it might offer some advantages to his company. He decided that appropriate drivers for overhead activities are purchase orders for purchasing, number of setups for setup cost, engineering hours for engineering cost, and machine hours for other. Budgeted amounts for these drivers are 5,000 purchase orders, 500 setups, and 2,500 engineering hours. Sanjay has been asked to prepare bids for two jobs with the following information: The typical bid price includes a 40 percent markup over full manufacturing cost. Required: 1. Calculate a plantwide rate for Firenza Company based on machine hours. What is the bid price of each job using this rate? 2. Calculate activity rates for the four overhead activities. What is the bid price of each job using these rates? 3. Which bids are more accurate? Why?Randy Harris, controller, has been given the charge to implement an advanced cost management system. As part of this process, he needs to identify activity drivers for the activities of the firm. During the past four months, Randy has spent considerable effort identifying activities, their associated costs, and possible drivers for the activities costs. Initially, Randy made his selections based on his own judgment using his experience and input from employees who perform the activities. Later, he used regression analysis to confirm his judgment. Randy prefers to use one driver per activity, provided that an R2 of at least 80 percent can be produced. Otherwise, multiple drivers will be used, based on evidence provided by multiple regression analysis. For example, the activity of inspecting finished goods produced an R2 of less than 80 percent for any single activity driver. Randy believes, however, that a satisfactory cost formula can be developed using two activity drivers: the number of batches and the number of inspection hours. Data collected for a 14-month period are as follows: Required: 1. Calculate the cost formula for inspection costs using the two drivers, inspection hours and number of batches. Are both activity drivers useful? What does the R2 indicate about the formula? 2. Using the formula developed in Requirement 1, calculate the inspection cost when 300 inspection hours are used and 30 batches are produced. Prepare a 90 percent confidence interval for this prediction.Kelly Gray, production manager, was upset with the latest performance report, which indicated that she was 100,000 over budget. Given the efforts that she and her workers had made, she was confident that they had met or beat the budget. Now, she was not only upset but also genuinely puzzled over the results. Three itemsdirect labor, power, and setupswere over budget. The actual costs for these three items follow: Kelly knew that her operation had produced more units than originally had been budgeted, so more power and labor had naturally been used. She also knew that the uncertainty in scheduling had led to more setups than planned. When she pointed this out to John Huang, the controller, he assured her that the budgeted costs had been adjusted for the increase in productive activity. Curious, Kelly questioned John about the methods used to make the adjustment. JOHN: If the actual level of activity differs from the original planned level, we adjust the budget by using budget formulasformulas that allow us to predict what the costs will be for different levels of activity. KELLY: The approach sounds reasonable. However, Im sure something is wrong here. Tell me exactly how you adjusted the costs of labor, power, and setups. JOHN: First, we obtain formulas for the individual items in the budget by using the method of least squares. We assume that cost variations can be explained by variations in productive activity where activity is measured by direct labor hours. Here is a list of the cost formulas for the three items you mentioned. The variable X is the number of direct labor hours: Labor cost = 10X Power cost = 5,000 + 4X Setup cost = 100,000 KELLY: I think I see the problem. Power costs dont have a lot to do with direct labor hours. They have more to do with machine hours. As production increases, machine hours increase more rapidly than direct labor hours. Also, ... JOHN: You know, you have a point. The coefficient of determination for power cost is only about 50 percent. That leaves a lot of unexplained cost variation. The coefficient for labor, however, is much betterit explains about 96 percent of the cost variation. Setup costs, of course, are fixed. KELLY: Well, as I was about to say, setup costs also have very little to do with direct labor hours. And I might add that they certainly are not fixedat least not all of them. We had to do more setups than our original plan called for because of the scheduling changes. And we have to pay our people when they work extra hours. It seems as if we are always paying overtime. I wonder if we simply do not have enough people for the setup activity. Supplies are used for each setup, and these are not cheap. Did you build these extra costs of increased setup activity into your budget? JOHN: No, we assumed that setup costs were fixed. I see now that some of them could vary as the number of setups increases. Kelly, let me see if I can develop some cost formulas based on better explanatory variables. Ill get back with you in a few days. Assume that after a few days work, John developed the following cost formulas, all with a coefficient of determination greater than 90 percent: Labor cost = 10X; where X = Direct labor hours Power cost = 68,000 + 0.9Y; where Y = Machine hours Setup cost = 98,000 + 400Z; where Z = Number of setups The actual measures of each of the activity drivers are as follows: Required: 1. Prepare a performance report for direct labor, power, and setups using the direct-labor-based formulas. 2. Prepare a performance report for direct labor, power, and setups using the multiple cost driver formulas that John developed. 3. Of the two approaches, which provides the most accurate picture of Kellys performance? Why? 4. After reviewing the approach to performance measurement, a consultant remarked that non-value-added cost trend reports would be a much better performance measurement approach than comparing actual costs with budgeted costseven if activity flexible budgets were used. Do you agree or disagree? Explain.
- Anderson Company has the following departmental manufacturing structure for one of its products: After some study, the production manager of Anderson recommended the following revised cellular manufacturing approach: Required: 1. Calculate the total time it takes to produce a batch of 20 units using Andersons traditional departmental structure. 2. Using cellular manufacturing, how much time is saved producing the same batch of 20 units? Assuming the cell operates continuously, what is the production rate? Which process controls this production rate? 3. What if the processing times of molding, welding, and assembly are all reduced to six minutes each? What is the production rate now, and how long will it take to produce a batch of 20 units?Big Mikes, a large hardware store, has gathered data on its overhead activities and associated costs for the past 10 months. Nizam Sanjay, a member of the controllers department, believes that overhead activities and costs should be classified into groups that have the same driver. He has decided that unloading incoming goods, counting goods, and inspecting goods can be grouped together as a more general receiving activity, since these three activities are all driven by the number of receiving orders. The 10 months of data shown below have been gathered for the receiving activity. Required: 1. Prepare a scattergraph, plotting the receiving costs against the number of purchase orders. Use the vertical axis for costs and the horizontal axis for orders. 2. Select two points that make the best fit, and compute a cost formula for receiving costs. 3. Using the high-low method, prepare a cost formula for the receiving activity. 4. Using the method of least squares, prepare a cost formula for the receiving activity. What is the coefficient of determination?Jolene Askew, manager of Feagan Company, has committed her company to a strategically sound cost reduction program. Emphasizing life-cycle cost management is a major part of this effort. Jolene is convinced that production costs can be reduced by paying more attention to the relationships between design and manufacturing. Design engineers need to know what causes manufacturing costs. She instructed her controller to develop a manufacturing cost formula for a newly proposed product. Marketing had already projected sales of 25,000 units for the new product. (The life cycle was estimated to be 18 months. The company expected to have 50 percent of the market and priced its product to achieve this goal.) The projected selling price was 20 per unit. The following cost formula was developed: Y=200,000+10X1 where X1=Machinehours(Theproductisexpectedtouseonemachinehourforeveryunitproduced.) Upon seeing the cost formula, Jolene quickly calculated the projected gross profit to be 50,000. This produced a gross profit of 2 per unit, well below the targeted gross profit of 4 per unit. Jolene then sent a memo to the Engineering Department, instructing them to search for a new design that would lower the costs of production by at least 50,000 so that the target profit could be met. Within two days, the Engineering Department proposed a new design that would reduce unit-variable cost from 10 per machine hour to 8 per machine hour (Design Z). The chief engineer, upon reviewing the design, questioned the validity of the controllers cost formula. He suggested a more careful assessment of the proposed designs effect on activities other than machining. Based on this suggestion, the following revised cost formula was developed. This cost formula reflected the cost relationships of the most recent design (Design Z). Y=140,000+8X1+5,000X2+2,000X3 where X1=MachinehoursX2=NumberofbatchesX3=Numberofengineeringchangeorders Based on scheduling and inventory considerations, the product would be produced in batches of 1,000; thus, 25 batches would be needed over the products life cycle. Furthermore, based on past experience, the product would likely generate about 20 engineering change orders. This new insight into the linkage of the product with its underlying activities led to a different design (Design W). This second design also lowered the unit-level cost by 2 per unit but decreased the number of design support requirements from 20 orders to 10 orders. Attention was also given to the setup activity, and the design engineer assigned to the product created a design that reduced setup time and lowered variable setup costs from 5,000 to 3,000 per setup. Furthermore, Design W also creates excess activity capacity for the setup activity, and resource spending for setup activity capacity can be decreased by 40,000, reducing the fixed cost component in the equation by this amount. Design W was recommended and accepted. As prototypes of the design were tested, an additional benefit emerged. Based on test results, the post-purchase costs dropped from an estimated 0.70 per unit sold to 0.40 per unit sold. Using this information, the Marketing Department revised the projected market share upward from 50 percent to 60 percent (with no price decrease). Required: 1. Calculate the expected gross profit per unit for Design Z using the controllers original cost formula. According to this outcome, does Design Z reach the targeted unit profit? Repeat, using the engineers revised cost formula. Explain why Design Z failed to meet the targeted profit. What does this say about the use of unit-based costing for life-cycle cost management? 2. Calculate the expected profit per unit using Design W. Comment on the value of activity information for life-cycle cost management. 3. The benefit of the post-purchase cost reduction of Design W was discovered in testing. What direct benefit did it create for Feagan Company (in dollars)? Reducing post-purchase costs was not a specific design objective. Should it have been? Are there any other design objectives that should have been considered?
- Kagle design engineers are in the process of developing a new green product, one that will significantly reduce impact on the environment and yet still provide the desired customer functionality. Currently, two designs are being considered. The manager of Kagle has told the engineers that the cost for the new product cannot exceed 550 per unit (target cost). In the past, the Cost Accounting Department has given estimated costs using a unit-based system. At the request of the Engineering Department, Cost Accounting is providing both unit-and activity-based accounting information (made possible by a recent pilot study producing the activity-based data). Unit-based system: Variable conversion activity rate: 100 per direct labor hour Material usage rate: 20 per part ABC system: Labor usage: 15 per direct labor hour Material usage (direct materials): 20 per part Machining: 75 per machine hour Purchasing activity: 150 per purchase order Setup activity: 3,000 per setup hour Warranty activity: 500 per returned unit (usually requires extensive rework) Customer repair cost: 25 per repair hour (average) Required: 1. Select the lower-cost design using unit-based costing. Are logistical and post-purchase activities considered in this analysis? 2. Select the lower-cost design using ABC analysis. Explain why the analysis differs from the unit-based analysis. 3. What if the post-purchase cost was an environmental contaminant and amounted to 10 per unit for Design A and 40 per unit for Design B? Assume that the environmental cost is borne by society. Now which is the better design?Gumbrecht Company has the following departmental manufacturing layout for one of its plants: A consulting firm has recommended a value stream with the following manufacturing cell: Required: 1. Calculate the total time it takes to produce a batch of 20 units using the traditional departmental manufacturing layout. 2. Using cellular manufacturing, how much time is saved producing the same batch of 20 units? Assuming the cell operates continuously, what is the production rate? Which process controls this production rate? 3. Assume the processing time of Casting is reduced to 9 minutes, while the times of the other processes stay the same. What is the production rate now, and how long will it take to produce a batch of 20 units if the cell is in a continuous production mode?The management of Wheeler Company has decided to develop cost formulas for its major overhead activities. Wheeler uses a highly automated manufacturing process, and power costs are a significant manufacturing cost. Cost analysts have decided that power costs are mixed; thus, they must be broken into their fixed and variable elements so that the cost behavior of the power usage activity can be properly described. Machine hours have been selected as the activity driver for power costs. The following data for the past eight quarters have been collected: Required: 1. Prepare a scattergraph by plotting power costs against machine hours. Does the scatter-graph show a linear relationship between machine hours and power cost? 2. Using the high and low points, compute a power cost formula. 3. Use the method of least squares to compute a power cost formula. Evaluate the coefficient of determination. 4. Rerun the regression and drop the point (20,000; 26,000) as an outlier. Compare the results from this regression to those for the regression in Requirement 3. Which is better?
- Tom Young, vice president of Dunn Company (a producer of plastic products), has been supervising the implementation of an activity-based cost management system. One of Toms objectives is to improve process efficiency by improving the activities that define the processes. To illustrate the potential of the new system to the president, Tom has decided to focus on two processes: production and customer service. Within each process, one activity will be selected for improvement: molding for production and sustaining engineering for customer service. (Sustaining engineers are responsible for redesigning products based on customer needs and feedback.) Value-added standards are identified for each activity. For molding, the value-added standard calls for nine pounds per mold. (Although the products differ in shape and function, their size, as measured by weight, is uniform.) The value-added standard is based on the elimination of all waste due to defective molds (materials is by far the major cost for the molding activity). The standard price for molding is 15 per pound. For sustaining engineering, the standard is 60 percent of current practical activity capacity. This standard is based on the fact that about 40 percent of the complaints have to do with design features that could have been avoided or anticipated by the company. Current practical capacity (the first year) is defined by the following requirements: 18,000 engineering hours for each product group that has been on the market or in development for five years or less, and 7,200 hours per product group of more than five years. Four product groups have less than five years experience, and 10 product groups have more. There are 72 engineers, each paid a salary of 70,000. Each engineer can provide 2,000 hours of service per year. There are no other significant costs for the engineering activity. For the first year, actual pounds used for molding were 25 percent above the level called for by the value-added standard; engineering usage was 138,000 hours. There were 240,000 units of output produced. Tom and the operational managers have selected some improvement measures that promise to reduce non-value-added activity usage by 30 percent in the second year. Selected actual results achieved for the second year are as follows: The actual prices paid per pound and per engineering hour are identical to the standard or budgeted prices. Required: 1. For the first year, calculate the non-value-added usage and costs for molding and sustaining engineering. Also, calculate the cost of unused capacity for the engineering activity. 2. Using the targeted reduction, establish kaizen standards for molding and engineering (for the second year). 3. Using the kaizen standards prepared in Requirement 2, compute the second-year usage variances, expressed in both physical and financial measures, for molding and engineering. (For engineering, explain why it is necessary to compare actual resource usage with the kaizen standard.) Comment on the companys ability to achieve its targeted reductions. In particular, discuss what measures the company must take to capture any realized reductions in resource usage.Joseph Fox, controller of Thorpe Company, has been in charge of a project to install an activity-based cost management system. This new system is designed to support the companys efforts to become more competitive. For the past six weeks, he and the project committee members have been identifying and defining activities, associating workers with activities, and assessing the time and resources consumed by individual activities. Now, he and the project committee are focusing on three additional implementation issues: (1) identifying activity drivers, (2) assessing value content, and (3) identifying cost drivers (root causes). Joseph has assigned a committee member the responsibilities of assessing the value content of five activities, choosing a suitable activity driver for each activity, and identifying the possible root causes of the activities. Following are the five activities with possible activity drivers: The committee member ran a regression analysis for each potential activity driver, using the method of least squares to estimate the variable and fixed cost components. In all five cases, costs were highly correlated with the potential drivers. Thus, all drivers appeared to be good candidates for assigning costs to products. The company plans to reward production managers for reducing product costs. Required: 1. What is the difference between an activity driver and a cost driver? In answering the question, describe the purpose of each type of driver. 2. For each activity, assess the value content and classify each activity as value-added or non-value-added (justify the classification). Identify some possible root causes of each activity, and describe how this knowledge can be used to improve activity performance. For purposes of discussion, assume that the value-added activities are not performed with perfect efficiency. 3. Describe the behavior that each activity driver will encourage, and evaluate the suitability of that behavior for the companys objective of becoming more competitive.You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door opening device. The president has asked that you review the company’s costing system and “do what you can to help us get better control of our manufacturing overhead costs.” You find that the company has never used a flexible budget, and you suggest that preparing such a budget would be an excellent first step in overhead planning and control. After much effort and analysis, you determined the following cost formulas and gathered the following actual cost data for March: Cost Formula Actual Cost in March Utilities $16,300 + $0.18 per machine-hour $ 21,520 Maintenance $38,500 + $2.00 per machine-hour $ 70,300 Supplies $0.50 per machine-hour $ 9,300 Indirect labor $94,100 + $1.50 per machine-hour $ 123,500 Depreciation $68,200 $ 69,900 During March, the company worked 17,000 machine-hours and produced 11,000 units. The company had originally planned to work 19,000…
