Below are the monthly sales forcast and actual monthly sales for Company. Company has hired you to conduct a variance analysis for its sales. In addition to the variance analysis, Company would like the entire row highlighted in green for months where the favorable variance is at least 20 percent and the entire row highlighted in red for months where the unfavorable variance is at least 20 percent. Show in Excel Month Sales forecast Actual Sales 1 83.00 $ 83.00 2 78.00 $ 58.50 3 174.00 $ 189.66 4 138.00 $ 149.04 190.00 $ 169.10 $ 153.00 $ 107.10 7 $ 54.00 $ 64.26 113.00 2$ 128.82 9. 135.00 $ 133.65 10 $ 51.00 $ 43.86

Below are the monthly sales forcast and actual monthly sales for Company. Company has hired you to conduct a variance analysis for its sales. In addition to the variance analysis, Company would like the entire row highlighted in green for months where the favorable variance is at least 20 percent and the entire row highlighted in red for months where the unfavorable variance is at least 20 percent. Show in Excel Month Sales forecast Actual Sales 1 83.00 $ 83.00 2 78.00 $ 58.50 3 174.00 $ 189.66 4 138.00 $ 149.04 190.00 $ 169.10 $ 153.00 $ 107.10 7 $ 54.00 $ 64.26 113.00 2$ 128.82 9. 135.00 $ 133.65 10 $ 51.00 $ 43.86

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter9: Evaluating Variances From Standard Costs

Section: Chapter Questions

Problem 2CMA: Marten Company has a cost-benefit policy to investigate any variance that is greater than 1,000 or...

See similar textbooks

Similar questions

At the end of the current fiscal year, the trial balance of Big Apple Inc. revealed the following debit (unfavorable) balances: Flexible-Budget Variance — $2,000 Production–Volume Variance — $75,000 What conclusions can be drawn from these two variances?
Using variance analysis and interpretation Last year, Wrigley Corp. adopted a standard cost system. Labor standards were set on the basis of time studies and prevailing wage rates. Materials standards were determined from materials specifications and the prices then in effect. On June 30, the end of the current fiscal year, a partial trial balance revealed the following: Standards set at the beginning of the year have remained unchanged. All inventories are priced at standard cost. What conclusions can be drawn from each of the four variances shown in Wrigleys trial balance?
Lowell Manufacturing Inc. has a normal selling price of 20 per unit and has been selling 125,000 units per month. In November, Lowell Manufacturing decided to lower its price to 19 per unit expecting it can increase the units sold by 16%. a. Compute the normal revenue with a 20 selling price. b. Compute the planned revenue with a 19 selling price. c. Compute the actual revenue for November, assuming 135,000 units were sold in November at 19 per unit. d. Compute the revenue price variance, assuming 135,000 units were sold in November at 19 per unit. e. Compute the revenue volume variance, assuming 135,000 units were sold in November at 19 per unit. f. Analyze and interpret the lowering of the price to 19.
Anker Company had the data below for its most recent year, ended December 31: Required: Prepare a performance report that shows the variances on an item-by-item basis.
Marten Company has a cost-benefit policy to investigate any variance that is greater than 1,000 or 10% of budget, whichever is larger. Actual results for the previous month indicate the following: The company should investigate: a. neither the materials variance nor the labor variance. b. the materials variance only. c. the labor variance only. d. both the materials variance and the labor variance.
Using variance analysis and interpretation Last year, Endicott Corp. adopted a standard cost system. Labor standards were set on the basis of time studies and prevailing wage rates. Materials standards were determined from materials specifications and the prices then in effect. On June 30, the end of the current fiscal year, a partial trial balance revealed the following: Standards set at the beginning of the year have remained unchanged. All inventories are priced at standard cost. What conclusions can be drawn from each of the four variances shown in Endicotts trial balance?
Rosenberry Company computed the following revenue variances for January: Revenue price variance (350,000) Favorable Revenue volume variance50,000 Unfavorable Assuming that the planned selling price per unit was 10 and that actual sales were 175,000 units, determine the following: a. Actual selling price of January. b. Planned number of units that were to be sold in January.
Madison Company uses the following rule to determine whether direct labor efficiency variances ought to be investigated. A direct labor efficiency variance will be investigated anytime the amount exceeds the lesser of 12,000 or 10 percent of the standard labor cost. Reports for the past five weeks provided the following information: Required: 1. Using the rule provided, identify the cases that will be investigated. 2. Suppose that investigation reveals that the cause of an unfavorable direct labor efficiency variance is the use of lower quality direct materials than are usually used. Who is responsible? What corrective action would likely be taken? 3. Suppose that investigation reveals that the cause of a significant favorable direct labor efficiency variance is attributable to a new approach to manufacturing that takes less labor time but causes more direct materials waste. Upon examining the direct materials usage variance, it is discovered to be unfavorable, and it is larger than the favorable direct labor efficiency variance. Who is responsible? What action should be taken? How would your answer change if the unfavorable variance were smaller than the favorable?
The normal capacity of a manufacturing plant is 30,000 direct labor hours or 20,000 units per month. Standard fixed costs are 6,000, and variable costs are 12,000. Data for two months follow: For each month, make a single journal entry to charge overhead to Work in Process, to close Factory Overhead, and to record variances. Indicate the types of variances and state whether each is favorable or unfavorable. (Hint: You must first compute the flexible-budget and production-volume variances.)
Potter Company has installed a JIT purchasing and manufacturing system and is using back-flush accounting for its cost flows. It currently uses a two-trigger approach with the purchase of materials as the first trigger point and the completion of goods as the second trigger point. During the month of June, Potter had the following transactions: There were no beginning or ending inventories. All goods produced were sold with a 60 percent markup. Any variance is closed to Cost of Goods Sold. (Variances are recognized monthly.) Required: 1. Prepare the journal entries that would have been made using a traditional accounting approach for cost flows. 2. Prepare the journal entries for the month using backflush costing.
Potter Company has installed a JIT purchasing and manufacturing system and is using back-flush accounting for its cost flows. It currently uses a two-trigger approach with the purchase of materials as the first trigger point and the completion of goods as the second trigger point. During the month of June, Potter had the following transactions: There were no beginning or ending inventories. All goods produced were sold with a 60 percent markup. Any variance is closed to Cost of Goods Sold. (Variances are recognized monthly.) Required: 1. Prepare the journal entries for the month of May using backflush costing, assuming that Potter uses the completion of goods as the only trigger point. 2. Prepare the journal entries for the month of May using backflush costing, assuming that Potter uses the sale of goods as the only trigger point.
Uchdorf Manufacturing just completed a study of its purchasing activity with the objective of improving its efficiency. The driver for the activity is number of purchase orders. The following data pertain to the activity for the most recent year: Activity supply: five purchasing agents capable of processing 2,400 orders per year (12,000 orders) Purchasing agent cost (salary): 45,600 per year Actual usage: 10,600 orders per year Value-added quantity: 7,000 orders per year Required: 1. Calculate the volume variance and explain its significance. 2. Calculate the unused capacity variance and explain its use. 3. What if the actual usage drops to 9,000 orders? What effect will this have on capacity management? What will be the level of spending reduction if the value-added standard is met?