Label Each Case Question:

Wheels Case Microsoft Word and Excel

Create Table

Sales Mix Variance Unit Sales Prior Year Unit Sales Current Year Variance Novice Standard Contribution Margin Novice per Unit Total Contribution Margin Novice Professional Standard Contribution Margin Professional per Unit Total Contribution Margin Professional Total Contribution YYYYYY Margin $$$ The YYYY is your sales mix variance. Going Postal: Analyzing Operating Income of the Wheels of Fortune The Decision It was a beautiful Saturday morning as Lance completed his ride in the hill country of central Texas. During his ride Lance thought, \"What has caused the operating income of Wheels of Fortune to decline so drastically over the last year?\" He was concerned that if the trend persisted, Wheels of Fortune, the bicycle assembly and wholesale company he started ten years ago, would cease to exist. From the beginning, Wheels of Fortune was Lance's brainchild. At forty, after surviving a signicant health scare, Lance realized his professional cycling career was nearing an end. Yet, he wanted to stay connected to the cycling community he so dearly loved. He reasoned his years of professional cycling experience for the Postal team and rsthand knowledge of the deciencies in existing bicycle technology uniquely qualied him to build a better bicycle. During a ride after another grueling season, Lance mentioned his idea for Wheels of Fortune to his long-time training partners and best friends, Tyler and Sam. \"Last week, after Sheryl told me she is expecting our rst child and I decided to retire.\" Tyler a bit surprised asked, \"I knew you were tiring of the professional circuit, but I didn't think you were ready to retire. What's next for you?\" Lance replied, \"I'm going to start a bicycle company called Wheels of Fortune. The company will assemble bicycles to order from retailers. I know it is sudden, but I would like for you and Sam to be my partners. With your knowledge of bicycle assembly and technology, Sam's accounting and procurement acumen, and my sales and marketing appeal, we would form an unbeatable team just like we did on the circuit.\" The Challenge \"Who called this meeting?\" a slightly annoyed Tyler queried. \"I did,\" Lance replied. \"My apologies, I know how much we all hate meetings, but it could not be helped. Our operating income decreased drastically in the last year. At this rate, we won't be in business much longer if we can't gure out what happened. I asked Sam to generate a comparison of operating income for the past two years.\" Sam explained, \"Our operating income decreased signicantly in just one year even though we sold the same number of bicycles. Over the same period, our contribution margin per bicycle also. While the average variable cost per bicycle decreased signicantly, it was not enough to offset the _ ___ _ __,c_____a_ \"Who called this meeting?\" a slightly annoyed Tyler queried. \"I did,\" Lance replied. \"My apologies, I know how much we all hate meetings, but it could not be helped. Our operating income decreased drastically in the last year. At this rate, we won't be in business much longer if we can't gure out what happened. I asked Sam to generate a comparison of operating income for the past two years.\" Sam explained, \"Our operating income decreased signicantly in just one year even though we sold the same number of bicycles. Over the same period, our contribution margin per bicycle also. While the average variable cost per bicycle decreased significantly, it was not enough to offset the decrease in our average selling price per bicycle.\" Lance interrupted, \"We have always sold professional bicycles for $5,500 and Novice for $1,100. How is it possible for our average sales price to decrease so drastically in one year without a price reduction?\" Sam replied, \"That's an excellent question and I thought the same. Our accounting records show that, while we continue to produce and sell at capacity of 4,500 bicycles, our sales mix shifted drastically. In prior years, we sold more Professional than Novice bicycles. This year we sold more Novice than Professional bicycles. The demand for Professional bicycles has decreased with a corresponding increase for Novice models.\" \"We've been assembling the same top-of-the-line Professional bicycle for ten years. How is it possible that sales shifted so drastically?\" Tyler asked. Sam suggested somewhat sarcastically, \"Perhaps, our Professional bicycles are no longer considered top-of-the-line.\" Lance sensing Tyler was a little put off chimed in, \"So you are saying the shift in sales mix is the reason for our decreased operating income?\" \"You are partially correct. The shift in sales mix impacted our average selling price. However, other factors contributed to the decrease in our operating income and need to be quantied. Specically, we need to analyze our variable manufacturing and xed selling and general administration costs,\" Sam appraised. \"Okay. So, you are suggesting we have the data to analyze those costs?\" Tyler asked hopefully. \"Yes; however, analyzing our variable manufacturing costs is much more complex than analyzing sales. We need to begin by comparing our expected or standard costs to assemble a bicycle with the actual cost to calculate manufacturing variances. Analyzing manufacturing variances will provide insight about spending and the efciency of our assembly process,\" Sam explained. \"When we started the company, we used the following assumptions to generate standard costs and establish selling prices.\" Wheels of Fortune vy willpaling vul vApoviva vi biannual VUSIS IN asDVILIVIN a bicycle with the actual cost to calculate manufacturing variances. Analyzing manufacturing variances will provide insight about spending and the efficiency of our assembly process," Sam explained. "When we started the company, we used the following assumptions to generate standard costs and establish selling prices." Wheels of Fortune Summary of Standard Costs Professional Professional Novice Price: Frames 900 $ 80 Parts 2,100 S 420 Direct labor hours per bicycle 10 6 Direct labor rate per hour 40 S 30 Variable overhead rate bicycle $ 150 $ 50 "So, the direct labor and variable overhead costs are the expected conversion costs to assemble the bicycle kits (direct materials) into a bicycle?" Tyler asked. Sam replied, "Correct. You will notice the direct labor to assemble Professional bicycles is more than double Novice bicycles. Because the frames and parts are so expensive on Professional bicycles, we decided to assign our most experienced assemblers to that department. In addition, as sales of our Novice bicycles increased, we were forced to transfer idle Professional assemblers to the Novice line to keep up with demand." Tyler added, "This is the first I've seen this. I am not certain how those changes impact our direct labor costs." "Calculating manufacturing variances can help us determine the dollar impact of those changes and others have on our variable manufacturing costs," Sam affirmed, "I summarized the relevant direct material, direct labor, and variable manufacturing overhead costs in this table. The table shows the actual number of bicycle kits, direct labor hours, and variable overhead costs incurred to assemble 4,500 bicycles last year." After reviewing the information, Tyler replied, "It appears you have been keeping track of our actual costs for some time. How come we never calculated manufacturing variances before?" Sam responded, "There was no need. For the first nine years of Wheels of Fortune, the company consistently generated $6 million in operating income. However, now we need to analyze everything including the $150,000 in raises we gave ourselves last year." A concerned Lance asked Sam, "Can you analyze our operating income, so we can make changes? If the trend continues, I might need to be forced to go back to the Postal team and I'm too old and out of shape for that." Sam enthusiastically replied, "Absolutely." Prepare your responses to the following the case questions asDlCYCleS. because me rrames and parts are so expens1ve on Professional bicycles, we decided to assign our most experienced assemblers to that department. In addition, as sales of our Novice bicycles increased, we were forced to transfer idle Professional assemblers to the Novice line to keep up with demand.\" Tyler added, \"This is the rst I've seen this. I am not certain how those changes impact our direct labor costs.\" \"Calculating manufacturing variances can help us determine the dollar impact of those changes and others have on our variable manufacturing costs,\" Sam afrmed, \"I summarized the relevant direct material, direct labor, and variable manufacturing overhead costs in this table. The table shows the actual number of bicycle kits, direct labor hours, and variable overhead costs incurred to assemble 4,500 bicycles last year.\" After reviewing the information, Tyler replied, \"It appears you have been keeping track of our actual costs for some time. How come we never calculated manufacturing variances before?\" Sam responded, \"There was no need. For the rst nine years of Wheels of Fortune, the company consistently generated $6 million in operating income. However, now we need to analyze everything including the $150,000 in raises we gave ourselves last year.\" A concerned Lance asked Sam, \"Can you analyze our operating income, so we can make changes? If the trend continues, I might need to be forced to go back to the Postal team and I'm too old and out of shape for that.\" Sam enthusiastically replied, \"Absolutely.\" Prepare your responses to the following the case questions as if you were Sam, the accountant for Wheels of Fortune. Cal Questions: . What are your initial observations of the potential causes of the decrease in operating income from 2020 to 2021. . Impact on operating income: Generate the following schedules to quantify the impact on decrease in operating incoming from 2020 to 2021 for Wheels of Fortune. a. Standard variable cost and contribution margin per bicycle (percent & dollars): Utilizing the standard cost components and the selling price per bicycle, calculate the standard variable cost and contribution margin per bicycle at standard. b. Sales mix impact: Analyze the impact of the shift in sales mix by determining the sales mix variance between 2020 and 2021 . 0. Manufacturing variance impact: Calculate direct materials (price & usage), direct labor (rate & efciency), and variable overhead variance for 2021. d. Selling and general administration impact: Prepare an analysis of the impact the increase in selling and "" "" \"""\"' " \"' "\"J \"' """7 "'" ""'\"' \""'"\"J "u" """"'" overhead costs incurred to assemble 4,500 bicycles last year.\" After reviewing the information, Tyler replied, \"It appears you have been keeping track of our actual costs for some time. How come we never calculated manufacturing variances before?\" Sam responded, \"There was no need. For the rst nine years of Wheels of Fortune, the company consistently generated $6 million in operating income. However, now we need to analyze everything including the $150,000 in raises we gave ourselves last year.\" A concerned Lance asked Sam, \"Can you analyze our operating income, so we can make changes? If the trend continues, I might need to be forced to go back to the Postal team and I'm too old and out of shape for that.\" Sam enthusiastically replied, \"Absolutely.\" Prepare your responses to the following the case questions as if you were Sam, the accountant for Wheels of Fortune. Cal Questions: . What are your initial observations of the potential causes of the decrease in operating income from 2020 to 2021. . Impact on operating income: Generate the following schedules to quantify the impact on decrease in operating incoming from 2020 to 2021 for Wheels of Fortune. a. Standard variable cost and contribution margin per bicycle (percent & dollars): Utilizing the standard cost components and the selling price per bicycle, calculate the standard variable cost and contribution margin per bicycle at standard. b. Sales mix impact: Analyze the impact of the shift in sales mix by determining the sales mix variance between 2020 and 2021. c. Manufacturing variance impact: Calculate direct materials (price & usage), direct labor (rate & efciency), and variable overhead variance for 2021. (1. Selling and general administration impact: Prepare an analysis of the impact the increase in selling and administration costs on Wheels of Fortune 2021 operating income. e. Operating income reconciliation: Prepare a schedule reconciling operating income from 2020 to 2021 integrating your calculations from items b-d above, 3. Recommendations: Based on your nancial analysis, generate a professional memo to the partners with your short (less than a year) and long-term (up to ve years) recommendations on how to improve the company's operating income integrating information from the schedules you created. A reader with limited nancial expertise (e. g. Lance) should be able to comprehend your analysis and associated recommendations. Group 1 Financials Wheels of Fortune Operating Income Statement Bicycles Sold 4,500 4,500 2020 Per Bicycle 2021 Per Bicycle Sales Dollars S 19,800,000 $4,400.00 $ 11,880,000 $2,640.00 Direct Material Costs 10,800,000 $2,400.00 $ 6,963,525 $1,547.45 Direct Labor Costs 1,552,500 345.00 1,314,061 292.01 Variable Overhead 562,500 125.00 473,625 105.25 Total Variable Costs $ 12,915,000 $ 2,870.00 $ 8,751,211 $ 1,944.71 Contribution Margin S 6,885,000 $1,530.00 $ 3,128, 789 $695.29 Contribution Margin Percent 34.77% 26.34% Selling & General Administration 615,000 136.67 $ 765,000 170.00 Operating Income $ 6,270,000 $1,393.33 2,363,789 $525.29 Sales Mix Percent 2020 2021 Professional 75% 35% Novice 25% 65% Total Assembled & Sold 4,500 4,500 Wheels of Fortune Summary of Actual Costs Professional 2020 2021 Frames: Usage 3,375 1,654 Price 900 $ 925 Parts: Usage 3,375 1,607 Price CA 2,100 $ 2,165 Direct Labor Hours 33,750 16,223 Direct Labor Rate 40 $ 42 A tA Variable Overhead Rate 150 $ 180 Novice 2020 2021 Frames: Usage 1,125 3,013 Price 180 $ 190 Parts: Usage 1,125 3,071 Price 420 $ 450 Direct Labor Hours 6,750 18,077 Direct Labor Rate 30 $ 35 Variable Overhead Rate 50 $ 65 Income Reconciliation Example Wheels of Fortune Income Reconciliation Difference Operating Income 2020 $ 6,270,000 Total Sales Mix Variance $ 378,000amen uuuma 11) 1 ),uuu.uuu w,-ruu.uu 42 I I,ouu,uuu .114,u-ru.uu Direct Material Costs $ 10.800.000 $2,400.00 $ 6,963,525 $1,547.45 Direct Labor Costs 1,552,500 345.00 1,314,061 292.01 Variable Overhead 562.500 125.00 473,625 105.25 Total Variable Costs $ 12,915,000 '$ 2,870.00 $ 3,751,211 $ 1,944.71 Contribution Margin .11" 6,885,000 31,530. 00 3 3,128, 739 $695.29 Contribution Margin Percent 34.77% 26.34" 0 Selling & General Administration 615.000 136.67 ,$ 765 000 170.00 Operating Income S 6.270.000 ' $1,393.33 35 2 363 789 $525.29 ales Mix Percent 2020 202 1 Professional 75% 35% Novice 25% 65% Total Assembied & Sold 4,500 4,500 Wheels of Fortune Summary of Actual Costs Pro essionar' M & Frames: Usage 3,375 1,654 Price $ 900 $ 925 Parts: Usage 3,375 1,607 Price $ 2,100 $ 2,165 Direct Labor Hours 33,750 16,223 Direct Labor Rate $ 40 $ 42 Variable Overhead Rate 19 150 $ 1130 Novice M M Frames: Usage 1,125 3,013 Price $ 180 $ 190 Parts: Usage 1,125 3,071 Price $ 420 $ 450 Direct Labor Hours 6,750 18,077 Direct Labor Rate $ 30 $ 35 Variable Overhead Rate $ 50 $ 65 Income Reconciliation Example Wheels of Fortune Income Reconciliation Operating Income 2020 Total Sam Mix Variance $ 378,000 Manufacturing Variances Direct Materials Variance Usage $ (336,960) Price (370,800) Direct Labor Variance Efficiency (1 O1 ,970) Rate (48.060) Variable Overhead Variance Spending (121,500) Total Manufacturing Variances Selling 8. General Administration Operating Income 2021 5,518,710 (unfavorable)