Question

In: Accounting

Use the following information to answer questions 42 to 44: The following summary data are from...

Use the following information to answer questions 42 to 44:

The following summary data are from a performance report for CDE Ltd for June, during which 11,000 units were produced. Budgeted production was 10,000 units.

Budget
(10,000 units)

Actual Costs
(11,000 units)

Variances

   Raw materials

$200 000

$208 800

$8 800 A

   Direct labour

$70 000

$71 000

$1 000 A

   Factory fixed overhead

$24 000

$24 200

$200 A

$294 000

$304 000

$10 000 A

  1. The performance report shows overspending (adverse /unfavourable variance) of $10,000. Senior management (with no accounting background) is not impressed with the performance reflected in this report. Why might the factory manager under evaluation question the accuracy of the report above?
  2. Revise the performance report using flexible budgeting.
  3. Comment on the performance of the factory manager based on your revised report

Solutions

Expert Solution

A.
The senior management is just comparing the actual costs with budgeted costs.
The factor manager might be concerned about the report because the actual units produced are higher than budgeted units and thus the actual total costs could be higher.
B.
Performance report using flexible budgeting
Raw material per unit $20.00 200000/10000
Direct labour per unit $7.00 70000/10000
Flexible budgeting is shown below
Flexible budget Actual costs Variances
Units 11000 11000
Raw materials (11,000*20) $220,000 $208,800 $11,200 F
Direct Labour (11,000*7) $77,000 $71,000 $6,000 F
Factory fixed overhead $24,000 $24,200 $200 U
$321,000 $304,000 $17,000 F
C.
Based on revised performance report the variance was $17,000 favourable indicating under spending.
Factory managers performance was therefore good in controlling the actual costs where direct material and direct labour actual spent was lower than budgeted costs.
Factory manager was able to control costs and thus this created favourable total costs vaiance.

Related Solutions

Use the following to answer Questions. The table includes summary of data concerning advertising expenditures and...
Use the following to answer Questions. The table includes summary of data concerning advertising expenditures and computer sales for ACME electronics. Ad Expenditures ($1000) Computer Sales ($1000) 2.5 6.1 3.8 4.9 3.1 5.9 2.1 6.8 What is the linear regression equation for the data? Y = 8.88 – 1.03x Y = 5.22 – 1.92x Y = 6.85 + 1.03x Y = 3.72 + 2.46x What is the standard error of the regression model? .2219 .3276 .7324 .9777 What is the...
Use the following information to answer questions 44-46 using the sales comparison approach. A comparable property...
Use the following information to answer questions 44-46 using the sales comparison approach. A comparable property sold 7 months ago for $231,200. The adjustments for the various elements of comparison have been calculated as follows: Location: +4.5 % Market conditions: -0.54% per month Physical characteristics: + $4,500 Financing terms: -$3,500 Nonrealty items: +$5,200 Conditions of sale, Legal characteristics, Use: 0 What is the value of the market conditions adjustment?* None of the above -$14,800 -$8,600 -$1,200 6 points Question 45...
Use the following information to answer questions (problems) 16 - 18. The following data are the...
Use the following information to answer questions (problems) 16 - 18. The following data are the result of inspecting aircraft seat belt buckles produced in various lot sizes. Number of buckles in each sample Number of defective buckles found 100 15 110 7 95 18 90 8 150 10 85 14 50 9 115 20 110 6 95 12 A- WORTH 4 POINTS: What is the average percent defective? Show work & formulae used or just use Minitab and attach/embed....
Use the following information to answer the next three questions: The following information is available from...
Use the following information to answer the next three questions: The following information is available from the records of Aggies R Us, Inc. at the end of the 2017 calendar year.  Assume this is Aggies’ 1st year of operation. Accounts Receivable           $102,200        Notes Payable                       $???? Cash                                        70,890              Salary Expense                   320,000 Building                                    75,000           Retained earnings ???? Advertising Expense                60,000             Accounts Payable                  62,800                                    Dividends                                 12,200             Income Tax Expense             23,100 Service Revenues                  460,000             Common Stock                    120,000            Office Equipment                     22,500             Wages Payable                     15,450 Determine Aggies’ Net Income for the year ended December 31, 2017: A. $36,900 B. $80,000 C. $56,900 D. $44,700...
Use the data in the Mod8-2Data file to answer the following questions. The data contains information...
Use the data in the Mod8-2Data file to answer the following questions. The data contains information from a car seat manufacturer on the age of machine (in months) and the cost of repairs (in 10s of $). Run the regression in Minitab and show the regression line on a scatter plot. Assume a level of significance of 5%. Age Repairs10 110 32.767 113 37.668 114 39.252 134 44.314 93 34.262 141 47.616 115 32.474 115 33.898 115 43.345 142 52.637...
Use the heights from the SCC data to answer the following questions. Men are to use...
Use the heights from the SCC data to answer the following questions. Men are to use the male data, and women are to use the female data (only answer the questions for ONE set of data, not both). 2. State the following for the SCC sample female/male heights. a. Sample size (n) b. Sample mean (?̅) c. Sample standard deviation (s) 3. Use the sample to make a point estimate of the mean height of the entire female/male SCC student...
Use the heights from the SCC data to answer the following questions. Men are to use...
Use the heights from the SCC data to answer the following questions. Men are to use the male data, and women are to use the female data (only answer the questions for ONE set of data, not both). 2. State the following for the SCC sample male heights. a. Sample size (n) b. Sample mean (?̅) c. Sample standard deviation (s male Student # Gender Height Shoe Age Hand 1 M 67 10 19 R 2 M 74 12 17...
Use the following information to answer the next three questions. Civil engineers collected data from one...
Use the following information to answer the next three questions. Civil engineers collected data from one area of Calgary on the amount of salt (in tons) used to keep highways drivable during a snowstorm. The amount of salt for n=10 snowstorms were as follows: 1111, 2215, 1573, 2813, 2815, 2126, 854, 3965, 1819, 776. Find a 95% confidence interval for the true population mean amount of salt required in a snowstorm. 1) What is the margin of error for this...
Required information Use the following information to answer questions [The following information applies to the questions...
Required information Use the following information to answer questions [The following information applies to the questions displayed below.] The following information is available for Lock-Tite Company, which produces special-order security products and uses a job order costing system. April 30 May 31 Inventories Raw materials $ 31,000 $ 30,000 Work in process 9,500 18,200 Finished goods 54,000 34,000 Activities and information for May Raw materials purchases (paid with cash) 197,000 Factory payroll (paid with cash) 200,000 Factory overhead Indirect materials...
Use the following information from June 17, 2020 to answer the questions below. COVID-19 case data...
Use the following information from June 17, 2020 to answer the questions below. COVID-19 case data by county - Connecticut County Total Cases New London 1,217 Fairfield 16,475 Windham 579 Hartford 11,405 Litchfield 1,467 Middlesex 1,259 New Haven 12,185 Tolland 895 Based on the data from 6/17/20, which county is at the 75th percentile for total number of cases by county. Based on the data from 6/17/20, what is the percentile rank for New London? Please show all your work,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT