Country Charm Shoppe sells a wide variety of home dcor, specializing in selling vintage items as...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Country Charm Shoppe sells a wide variety of home décor, specializing in selling vintage items as well as items that are made from recycled and repurposed materials. The Country Charm Shoppe purchases some of their inventory for direct re-sale and also manufactures a portion of the goods they sell. The manufactured items Country Charm Shoppe makes internally are wooden furniture made from reclaimed wood. Reclaimed wood is the only direct material item required for these internally manufactured furniture pieces. The Country Charm Shoppe has organized their business into two separate divisions, one division that is devoted to generating sales from a small chain of brick and mortar stores and a second division that is devoted to generating on-line sales. Each division is operated separately and is headed by a division-level manager who is responsible for all aspects of their respective division. Top management at the Country Charm Shoppe prepare budgets each year to help with planning and to help evaluate performance of their division-level managers. Country Charm Shoppe uses a standard costing system and allocates both variable and fixed manufacturing overhead using direct labor hrs. The variable selling and administrative costs reflect sales commissions the division level managers pay to their salespeople to provide an incentive for them to generate as much in sales as possible. The fixed selling and administrative expenses are costs that the company has determined are largely driven by the number of employees so they have chosen to allocate this cost using the number of employees for each division. While the division-level managers are not in charge of manufacturing the items that are made internally, they can choose the type of items that are marketed to customers which affects which specific items are manufactured. Top management is reviewing the following financial information for the overall company and from each division from the last quarter. Revenue Direct re-sale goods Manufactured goods Total sales Cost of Goods Sold - Manufactured Items Direct Materials Direct Labor Variable Manufacturing OH Fixed Manufacturing OH Total Cost of Goods Sold - Manufactured Items Cost of Goods Sold - Resale Items Total Cost of Goods Sold Gross Margin Income Statement Q3 2019- Retail Stores Division Actual Amounts Variable Selling Costs Fixed Selling and Administrative Costs Operating Income $2,128,553 6,677,321 8,805,874 1,460,100 1,580,675 321,633 571,447 3,933,855 1,353,642 5,287,497 3,518,377 567,171 538,901 $2,412,305 Budgeted Amounts $2,100,000 6,468,000 8,568,000 986,370 1,290,366 388,080 582,120 3,246,936 1,417,500 4,664,436 3,903,564 371,700 542,500 $2,989,364 Revenue Direct re-sale goods Manufactured goods Total sales Cost of Goods Sold Manufactured Items Direct Materials Direct Labor Variable Manufacturing OH Fixed Manufacturing OH Total Cost of Goods Sold - Manufactured Items Cost of Goods Sold - Resale Items Total Cost of Goods Sold Gross Margin Variable Selling Costs Fixed Selling and Administrative Costs Operating Income Income Statement Q3 2019- Online Sales Division Budgeted Amounts Actual Amounts $4,012,848 1,279,536 5,292,384 274,350 405,850 114,192 285,295 1,079,687 2,278,058 3,357,745 1,934,639 148,691 149,350 $1,636,598 $3,315,000 2,079,000 5,394,000 381,150 523,908 124,740 249,480 1,279,278 2,340,000 3,619,278 1,774,722 114,825 157,500 $1,502,397 1 As shown above, the Retail Stores division generated approximately $575,000 less in operating income than expected for Q3 2019 while the Online Sales division generated approximately $135,000 more in operating income than expected. Kimberly, the manager for the Retail Stores division has argued that evaluating her division's Q3 2019 results based on expected operating income does not accurately reflect her division's performance. When asked to explain these results Kimberly made the following statement: "While our bottom line is lower than we expected, there are several reasons why this does not reflect my division's underlying performance. When generating the budgeted numbers for my division, the amount of sales was the only number that I had significant input for and as you can see my division actually generated more in total sales for the quarter than was expected. Many of the other budgeted numbers for my division such as the costs for the internally manufactured items are outside of my control as division manager. Also, I do not believe the way fixed selling and administrative costs are allocated to my division is fair. These costs are allocated on the basis of the number of employees in the two divisions which means that since my division requires more employees to staff the retail stores, my division will always receive a much higher allocation of fixed selling and administrative costs than the online sales division which will make their performance look better in comparison to mine." To better evaluate each division managers' performance top management wishes to put together a more in-depth and complete variance analysis for Q3 2019. To do so they have put together the following information underlying the budgeted expectations and the actual results for the quarter: Expected (budget) total number of direct re-sale items to be sold Actual number of direct re-sale items sold by the Retail Stores Division Actual number of direct re-sale items sold by the Online Sales Division Expected (budget) total number of manufactured items to be sold Actual number of manufactured items sold by the Retail Stores Division Actual number of manufactured items sold by the Online Sales Division Exp. cost (budget) per sq. ft of direct materials (price/sq. ft of reclaimed wood) Actual cost per sq. ft. of direct materials (cost per sq. ft. of reclaimed wood) Expected (budget) cost per direct labor hour Actual cost per direct labor hour Expected % of direct resale items sold in the Online- Sales Division Expected % of manufactured items sold in the Retail Stores Division 70 words KX Additional Information 60,000 19,618 42,464 23,100 13,745 4,880 $5.5 $6.2 $13.30 $12.50 65% 70% Required: Part A: Create a flexible budget for each division (include all income statement items). Part B: Calculate the following variances for each division and state whether each is favorable or unfavorable: Overall static budget variance, overall flexible budget variance, sales activity variance (one for resale items and one for manufactured items), sales price variance, direct materials price variance, direct materials efficiency variance, direct labor rate variance, direct labor efficiency variance,-the direct cost variance for the resale items (this variance is based on the expected versus the actual cost per resale item), variable selling cost variance (this variance is based on the expected versus the actual variable selling cost per item), and the fixed selling and administrative cost variance. Note: The actual and budgeted amounts per unit are expected to differ for items sold across the two divisions. Part C: Using the information you have put together so far, what are the items most responsible for the overall difference between the actual and expected income for Q3 operating income for each division? Explain the “why’s” linking the calculations in part B to explain the financial results of both divisions. Utilize additional ratio analysis to support your conclusions if necessary. Provide an overall assessment to the divisions. Explain your answer in no more than 5-6 sentences for each division. Part D: Use the analysis you have done to evaluate Kimberly's objections to using her division's operating income variance to evaluate her performance. In doing so list at least two possible reasons in support of her arguments and two possible reasons why her arguments are not supported. Utilize ratio analysis in addition to the variances calculated in part to support your answer. Country Charm Shoppe sells a wide variety of home décor, specializing in selling vintage items as well as items that are made from recycled and repurposed materials. The Country Charm Shoppe purchases some of their inventory for direct re-sale and also manufactures a portion of the goods they sell. The manufactured items Country Charm Shoppe makes internally are wooden furniture made from reclaimed wood. Reclaimed wood is the only direct material item required for these internally manufactured furniture pieces. The Country Charm Shoppe has organized their business into two separate divisions, one division that is devoted to generating sales from a small chain of brick and mortar stores and a second division that is devoted to generating on-line sales. Each division is operated separately and is headed by a division-level manager who is responsible for all aspects of their respective division. Top management at the Country Charm Shoppe prepare budgets each year to help with planning and to help evaluate performance of their division-level managers. Country Charm Shoppe uses a standard costing system and allocates both variable and fixed manufacturing overhead using direct labor hrs. The variable selling and administrative costs reflect sales commissions the division level managers pay to their salespeople to provide an incentive for them to generate as much in sales as possible. The fixed selling and administrative expenses are costs that the company has determined are largely driven by the number of employees so they have chosen to allocate this cost using the number of employees for each division. While the division-level managers are not in charge of manufacturing the items that are made internally, they can choose the type of items that are marketed to customers which affects which specific items are manufactured. Top management is reviewing the following financial information for the overall company and from each division from the last quarter. Revenue Direct re-sale goods Manufactured goods Total sales Cost of Goods Sold - Manufactured Items Direct Materials Direct Labor Variable Manufacturing OH Fixed Manufacturing OH Total Cost of Goods Sold - Manufactured Items Cost of Goods Sold - Resale Items Total Cost of Goods Sold Gross Margin Income Statement Q3 2019- Retail Stores Division Actual Amounts Variable Selling Costs Fixed Selling and Administrative Costs Operating Income $2,128,553 6,677,321 8,805,874 1,460,100 1,580,675 321,633 571,447 3,933,855 1,353,642 5,287,497 3,518,377 567,171 538,901 $2,412,305 Budgeted Amounts $2,100,000 6,468,000 8,568,000 986,370 1,290,366 388,080 582,120 3,246,936 1,417,500 4,664,436 3,903,564 371,700 542,500 $2,989,364 Revenue Direct re-sale goods Manufactured goods Total sales Cost of Goods Sold Manufactured Items Direct Materials Direct Labor Variable Manufacturing OH Fixed Manufacturing OH Total Cost of Goods Sold - Manufactured Items Cost of Goods Sold - Resale Items Total Cost of Goods Sold Gross Margin Variable Selling Costs Fixed Selling and Administrative Costs Operating Income Income Statement Q3 2019- Online Sales Division Budgeted Amounts Actual Amounts $4,012,848 1,279,536 5,292,384 274,350 405,850 114,192 285,295 1,079,687 2,278,058 3,357,745 1,934,639 148,691 149,350 $1,636,598 $3,315,000 2,079,000 5,394,000 381,150 523,908 124,740 249,480 1,279,278 2,340,000 3,619,278 1,774,722 114,825 157,500 $1,502,397 1 As shown above, the Retail Stores division generated approximately $575,000 less in operating income than expected for Q3 2019 while the Online Sales division generated approximately $135,000 more in operating income than expected. Kimberly, the manager for the Retail Stores division has argued that evaluating her division's Q3 2019 results based on expected operating income does not accurately reflect her division's performance. When asked to explain these results Kimberly made the following statement: "While our bottom line is lower than we expected, there are several reasons why this does not reflect my division's underlying performance. When generating the budgeted numbers for my division, the amount of sales was the only number that I had significant input for and as you can see my division actually generated more in total sales for the quarter than was expected. Many of the other budgeted numbers for my division such as the costs for the internally manufactured items are outside of my control as division manager. Also, I do not believe the way fixed selling and administrative costs are allocated to my division is fair. These costs are allocated on the basis of the number of employees in the two divisions which means that since my division requires more employees to staff the retail stores, my division will always receive a much higher allocation of fixed selling and administrative costs than the online sales division which will make their performance look better in comparison to mine." To better evaluate each division managers' performance top management wishes to put together a more in-depth and complete variance analysis for Q3 2019. To do so they have put together the following information underlying the budgeted expectations and the actual results for the quarter: Expected (budget) total number of direct re-sale items to be sold Actual number of direct re-sale items sold by the Retail Stores Division Actual number of direct re-sale items sold by the Online Sales Division Expected (budget) total number of manufactured items to be sold Actual number of manufactured items sold by the Retail Stores Division Actual number of manufactured items sold by the Online Sales Division Exp. cost (budget) per sq. ft of direct materials (price/sq. ft of reclaimed wood) Actual cost per sq. ft. of direct materials (cost per sq. ft. of reclaimed wood) Expected (budget) cost per direct labor hour Actual cost per direct labor hour Expected % of direct resale items sold in the Online- Sales Division Expected % of manufactured items sold in the Retail Stores Division 70 words KX Additional Information 60,000 19,618 42,464 23,100 13,745 4,880 $5.5 $6.2 $13.30 $12.50 65% 70% Required: Part A: Create a flexible budget for each division (include all income statement items). Part B: Calculate the following variances for each division and state whether each is favorable or unfavorable: Overall static budget variance, overall flexible budget variance, sales activity variance (one for resale items and one for manufactured items), sales price variance, direct materials price variance, direct materials efficiency variance, direct labor rate variance, direct labor efficiency variance,-the direct cost variance for the resale items (this variance is based on the expected versus the actual cost per resale item), variable selling cost variance (this variance is based on the expected versus the actual variable selling cost per item), and the fixed selling and administrative cost variance. Note: The actual and budgeted amounts per unit are expected to differ for items sold across the two divisions. Part C: Using the information you have put together so far, what are the items most responsible for the overall difference between the actual and expected income for Q3 operating income for each division? Explain the “why’s” linking the calculations in part B to explain the financial results of both divisions. Utilize additional ratio analysis to support your conclusions if necessary. Provide an overall assessment to the divisions. Explain your answer in no more than 5-6 sentences for each division. Part D: Use the analysis you have done to evaluate Kimberly's objections to using her division's operating income variance to evaluate her performance. In doing so list at least two possible reasons in support of her arguments and two possible reasons why her arguments are not supported. Utilize ratio analysis in addition to the variances calculated in part to support your answer.
Expert Answer:
Answer rating: 100% (QA)
Answer Part A Create a flexible budget for each division include all income statement items Retail Stores Division Revenue Actual Amounts Budgeted Amounts Direct resale goods 2128553 2100000 Manufactu... View the full answer
Related Book For
Excellence in Business Communication
ISBN: 978-0136103769
9th edition
Authors: John V. Thill, Courtland L. Bovee
Posted Date:
Students also viewed these accounting questions
-
A wide variety of people visit the foundation's website, from researchers who are interested in applying for grants to reporters writing about health and education issues to members of the general...
-
Fly-Buy Frisbees sells a wide variety of frisbees and uses a perpetual inventory system. On June 1, Fly- Buy Frisbees had five Fast Flying Frisbees on hand at a unit cost of $105. During June and...
-
Triway Packaging Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the...
-
Solve Prob. 410 using singularity functions. Use statics to determine the reactions. Prob. 410, The figure shows a cantilever consisting of steel angles size 100 Ã 100 Ã 12 mm mounted...
-
In Figure P2.4.9, water is flowing in pipe A and oil (sp. gr. = 0.82) is flowing in pipe B. If mercury is used as the manometer liquid, determine the pressure difference between A and Bin psi. 32 in....
-
Without actually doing the calculations, decide which, if either, of the following two sets of data will have the greater standard deviation. Explain why. 15, 18, 19, 20, 22, 26 21, 22, 22, 23, 23, 24
-
If career opportunities in an organization are limited, do managers have a responsibility to convey this information to employees? Explain your position.
-
During March 2017, Toby Tool & Die Company worked on four jobs. A review of direct labor costs reveals the following summary data. Analysis reveals that Job A257 was a repeat job. Job A258 was a rush...
-
4. Elizabeth has $1537.21 in her savings account. The account pays 4% compounded monthly. Elizabeth does not make any deposits or withdrawals over the next 6 months. How much interest does the...
-
Banyan Industries Limited (Banyan) manufactures various models of alternators, mainly for the North American automobile industry. The company, located in Canada, has grown steadily over the past 15...
-
If the hypotenuse in a right angled triangle is 10.0cm and a side a adjacent to an angle in the triangle is 3.42cm. Calculate the value of angle.
-
Given sin x= 4/7 and cos x= -(square root of 33) divided by 7,find cot x. On the square root only square root the 33 so -/33.
-
An economy is based on three sectors-agriculture, manufacturing, and services. For each unit of output, agriculture requires inputs of 0.30 unit from agriculture, 030 unit from manufacturing, and...
-
Lori buys a $214 certificate of deposit (CD) that earns 3% interest that compounds monthly. How much will the CD be worth in 7 years? (Express your answer rounded correctly to the nearest cent!) 3
-
1. Construct and package D Flip-flop (called it D-FF) and D Latch (called it D-latch). Compare the functions of your D-FF and D-latch using the following circuit. 0- 1- HO 0 D 10 D-FF D Q Q(FF) 0 CLR...
-
The height of a trapezoid can be expressed as x-4, while the bases can be expressed as x+4 and x+9. If the area of the trapezoid is 99 cm^(2), find the length of the larger base.
-
You are an audit manager for Rodgers & Co. and have recently taken on a new client, Manufacturing Company. You are in the initial stages of planning the audit and have decided to start gathering...
-
DEPARTMENT DATA EMPLOYEE DATA EmployeeNumber FirstName Mary Rosalie Richard George Alan 3 4 5 7 8 9 855555ES 12 13 14 15 16 17 Create the database tables in SQL or ACCESS: 18 19 20 PROJECT DATA Ken...
-
Government reports vary in purpose and structure. Read through the U.S. Department of Education's report "Helping Your Child Become a Reader," available at www.ed.gov. What is the purpose of this...
-
Rewrite these sentences to reflect your audience's viewpoint. a. Your e-mail order cannot be processed; we request that you use the order form on our website instead. b. We insist that you always...
-
In less than a page, explain why you think each of the following is or is not ethical. a. Keeping quiet about a possible environmental hazard you've just discovered in your company's processing plant...
-
Find the state vector via the formal-solution approach. \(\dot{\mathbf{x}}=\left[\begin{array}{cc}5 & 1 \\ -4 & 1\end{array} ight] \mathbf{x}+\left[\begin{array}{c}1 \\ -1\end{array} ight] u, \quad...
-
A dynamic system is modeled as \[4 \ddot{x}+4 \dot{x}+5 x=10 \sin \left(\frac{1}{2} t ight), \quad x(0)=\frac{1}{2}, \quad \dot{x}(0)=0\] Plot the response \(x(t)\) for \(0 \leq t \leq 20\) by a....
-
Show that the impulse response of an underdamped, second-order system has a steady-state value of zero.
Study smarter with the SolutionInn App