Surrey Bikes, Inc. manufactures double bench bikes for resorts and other vacation properties. Management now wants the accountants to complete an analysis to compare the budgeted costs to standard costs for 2022. During the year 2022, the company completed 680 bikes. Let's discuss changes from budget and standard that occurred during 2022. Overall, the company was able to increase several efficiencies. However, the company also experienced some increased costs. Use this information to complete the CH24 Budet Variances tab; the green section. Electrical Parts Direct Materials The purchase price increased by $2.50 per set. There was also an increase in freight of by $0.25 per set. Wheels and Tires Direct Materials: The company was able to secure the same materials from a new supplier at a cost of $9/set. However, freight cost increased by $0.50 per wheel and tire set. Metal Parts Direct Materials: The company was also able to reduce the amount of material used for each bike by 3 pounds. The acual cost of the metal parts was $0.52 per pound. Canvas Fabric Direct Materials: The company was also able to reduce the amount of material used for each bike by one-half a yard. The acual cost of the canvas fabric was $4.95 per yard. Direct labor: Employees were tasked with increasing equipment assembly and decreasing labor hours. They were successful in 2022 and brought hours down by 5/hours/unit! The company provided a $1/hour raisel This also lead to an increase of $0.25/hour in payroll taxes. Manufacturing overhead: There were no changes in manufacturing overhead, no variance needs to be computed Using this information, computer the budget variances incurred during 2022. Surrey Bikes, Inc. manufactures double bench bikes for resorts and other vacation properties. Management is preparing the budget 2022 and has asked for the accountants help. Sales in 2021 were 600 units. They are bringing on a new customer and management is expecting a 10% increase in 2022. They will increase the selling price to $3,300 this year to account for anticipated rising costs. Surrey Bikes, Inc. Sales Budget For the Year Ended December 31, 2022 Expected sales units Unit selling price $ 3,300 Total sales $ 2,178,000 660 At the end of 2021, there were no bikes left in inventory to sell in 2022. Management would like to start 2022 with inventory on hand. They would like to budget to end 2022 with 60 completed and finished bikes. Surrey Bikes, Inc. Production Budget For the Year Ended December 31, 2022 Expected sales units Add: Desired ending finished goods units (ending balance 2022) Total required units Less: Beginning finished goods units (ending balance 2021) Required production units Management expects to end 2021 with some direct materials. They want to make sure that at the end of 2022, they have enough direct materials on hand to start production right away in 2023. Expected Per Unit Ending Balance Ending Balance 2022 Cost 2021 2022 Electrical sets direct materials: 1 set $ 100.00 50 150 Wheel and tire sets direct materials 4 wheel & tire sets $ 10.00 200 400 Metal parts direct materials: 200 pounds $ 0.50 1,000 5,000 Canvas fabric direct materials: 3 yards $ 10.00 20 200 Surrey Bikes, Inc. Direct Materials Budget For the Year Ended December 31, 2022 Required production units Electrical sets per unit produced: Total needed for production Add: Desired ending direct materials Total materials required Less: Beginning direct materials Direct materials purchases Cost per sot Total cost of electrical sets direct materials purchases Required production units Wheel and tire sets per unit produced Total wheel and tire sets needed for production Add: Desired ending direct materials (ending balance 2022) Total materials required Less: Beginning direct materials (ending balance 2021) Direct materials purchases Cost per unit Total cost of wheel and tire sets direct materials purchases Required production units Metal parts direct materials pounds per unit produced Total pounds needed for production Add: Desired ending direct materials in pounds (ending balance 2022) Total materials required Less: Beginning direct materials in pounds (ending balance 2021) Direct materials purchases Cost per pound Total cost of metal parts direct materials purchases Required production units Canvas direct material yards per unit produced: Total yards needed for production Add: Desired ending direct materials in yards (ending balance 2022) Total materials required Less: Beginning direct materials in pounds (ending balance 2021) Direct materials purchases Cost per yard Total cost of canvas direct materials purchases Total cost of ALL direct materials purchases Management expects that it will take 50 hours of direct labor to manufacture each bike. Direct labor is billed at $20hour. Surrey Bikes, Inc. Direct Labor Budget For the Year Ended December 31, 2022 Units to be produced Direct labor time (hours) per unit Total required direct labor hours Direct labor cost per hour Total direct labor cost Machine usage is the only component of manufacturing overhead. It will take 75 machine hours per bike and the cost is $8hour. Surrey Bikes, Inc. Manufacturing Overhead Budget For the Year Ended December 31, 2022 Units to be produced Machine hours per unit Total required machine hours Machine cost per hour Total manufacturing overhead Management also anticipates the following fixed costs, some anticipated changes from last year: Building and Equipment Depreciation Company Insurance Company Advertising Selling and Administrative Salaries and Benefits $45.000 $23,000 $117,000 $300,000 Surrey Bikes, Inc. Selling and Administrative Expense Budget For the Year Ended December 31, 2022 Fixed expenses Building and Equipment Depreciation Company Insurance Company Advertising Selling and administrative salaries and benefits Total selling and administrative expenses Management had to borrow some money from the bank to start the business five years ago. As a result, they still have some interest expense. It is $10,000 per ear. Management anticipates a 20% tax rate for 2022. Surrey Bikes, Inc. Budget Income Statement For the Year Ended December 31, 2022 Bales Cost of goods sold Gross profit Belling and administrative expenses ncome from operations interest expense ncome before income taxes income tax expense Net Income Unit Cost Total Supplemental Schedule - COGS Cost Budget per Unit Cost Element Electrical sets direct materials: Wheel & tire sets Metal parts direct materials: Canvas direct materials: Direct labor Manufacturing overhead - machine hours Total COGS Budget per Unit Quantity set set pounds yards hour hour Management is asking that the accountant compute the budget variances for 2022. Using the information provided on the BLUE TABS, calculate the following variances. Include a description of the variables for each computation. In order to receive credit -> show your calculations!! Hint:Start by calculating the standard DM cost of one unit, actual DM cost of one unit, standard labor cost for one unit and actual labor cost for one unit. Check the production budget for the planned number of bikes. The actual number of bikes produced is provided in the Additional Info - Actual Costs tab. Expected / Standard Unit Cost Total Product Costs Actual Cost Unit Total Material Price Variance Material Quantity Variance Total Materials Variance Labor Quantity Variance Labor Price Variance Total Labor Variance Surrey Bikes, Inc. manufactures double bench bikes for resorts and other vacation properties. Management now wants the accountants to complete an analysis to compare the budgeted costs to standard costs for 2022. During the year 2022, the company completed 680 bikes. Let's discuss changes from budget and standard that occurred during 2022. Overall, the company was able to increase several efficiencies. However, the company also experienced some increased costs. Use this information to complete the CH24 Budet Variances tab; the green section. Electrical Parts Direct Materials The purchase price increased by $2.50 per set. There was also an increase in freight of by $0.25 per set. Wheels and Tires Direct Materials: The company was able to secure the same materials from a new supplier at a cost of $9/set. However, freight cost increased by $0.50 per wheel and tire set. Metal Parts Direct Materials: The company was also able to reduce the amount of material used for each bike by 3 pounds. The acual cost of the metal parts was $0.52 per pound. Canvas Fabric Direct Materials: The company was also able to reduce the amount of material used for each bike by one-half a yard. The acual cost of the canvas fabric was $4.95 per yard. Direct labor: Employees were tasked with increasing equipment assembly and decreasing labor hours. They were successful in 2022 and brought hours down by 5/hours/unit! The company provided a $1/hour raisel This also lead to an increase of $0.25/hour in payroll taxes. Manufacturing overhead: There were no changes in manufacturing overhead, no variance needs to be computed Using this information, computer the budget variances incurred during 2022. Surrey Bikes, Inc. manufactures double bench bikes for resorts and other vacation properties. Management is preparing the budget 2022 and has asked for the accountants help. Sales in 2021 were 600 units. They are bringing on a new customer and management is expecting a 10% increase in 2022. They will increase the selling price to $3,300 this year to account for anticipated rising costs. Surrey Bikes, Inc. Sales Budget For the Year Ended December 31, 2022 Expected sales units Unit selling price $ 3,300 Total sales $ 2,178,000 660 At the end of 2021, there were no bikes left in inventory to sell in 2022. Management would like to start 2022 with inventory on hand. They would like to budget to end 2022 with 60 completed and finished bikes. Surrey Bikes, Inc. Production Budget For the Year Ended December 31, 2022 Expected sales units Add: Desired ending finished goods units (ending balance 2022) Total required units Less: Beginning finished goods units (ending balance 2021) Required production units Management expects to end 2021 with some direct materials. They want to make sure that at the end of 2022, they have enough direct materials on hand to start production right away in 2023. Expected Per Unit Ending Balance Ending Balance 2022 Cost 2021 2022 Electrical sets direct materials: 1 set $ 100.00 50 150 Wheel and tire sets direct materials 4 wheel & tire sets $ 10.00 200 400 Metal parts direct materials: 200 pounds $ 0.50 1,000 5,000 Canvas fabric direct materials: 3 yards $ 10.00 20 200 Surrey Bikes, Inc. Direct Materials Budget For the Year Ended December 31, 2022 Required production units Electrical sets per unit produced: Total needed for production Add: Desired ending direct materials Total materials required Less: Beginning direct materials Direct materials purchases Cost per sot Total cost of electrical sets direct materials purchases Required production units Wheel and tire sets per unit produced Total wheel and tire sets needed for production Add: Desired ending direct materials (ending balance 2022) Total materials required Less: Beginning direct materials (ending balance 2021) Direct materials purchases Cost per unit Total cost of wheel and tire sets direct materials purchases Required production units Metal parts direct materials pounds per unit produced Total pounds needed for production Add: Desired ending direct materials in pounds (ending balance 2022) Total materials required Less: Beginning direct materials in pounds (ending balance 2021) Direct materials purchases Cost per pound Total cost of metal parts direct materials purchases Required production units Canvas direct material yards per unit produced: Total yards needed for production Add: Desired ending direct materials in yards (ending balance 2022) Total materials required Less: Beginning direct materials in pounds (ending balance 2021) Direct materials purchases Cost per yard Total cost of canvas direct materials purchases Total cost of ALL direct materials purchases Management expects that it will take 50 hours of direct labor to manufacture each bike. Direct labor is billed at $20hour. Surrey Bikes, Inc. Direct Labor Budget For the Year Ended December 31, 2022 Units to be produced Direct labor time (hours) per unit Total required direct labor hours Direct labor cost per hour Total direct labor cost Machine usage is the only component of manufacturing overhead. It will take 75 machine hours per bike and the cost is $8hour. Surrey Bikes, Inc. Manufacturing Overhead Budget For the Year Ended December 31, 2022 Units to be produced Machine hours per unit Total required machine hours Machine cost per hour Total manufacturing overhead Management also anticipates the following fixed costs, some anticipated changes from last year: Building and Equipment Depreciation Company Insurance Company Advertising Selling and Administrative Salaries and Benefits $45.000 $23,000 $117,000 $300,000 Surrey Bikes, Inc. Selling and Administrative Expense Budget For the Year Ended December 31, 2022 Fixed expenses Building and Equipment Depreciation Company Insurance Company Advertising Selling and administrative salaries and benefits Total selling and administrative expenses Management had to borrow some money from the bank to start the business five years ago. As a result, they still have some interest expense. It is $10,000 per ear. Management anticipates a 20% tax rate for 2022. Surrey Bikes, Inc. Budget Income Statement For the Year Ended December 31, 2022 Bales Cost of goods sold Gross profit Belling and administrative expenses ncome from operations interest expense ncome before income taxes income tax expense Net Income Unit Cost Total Supplemental Schedule - COGS Cost Budget per Unit Cost Element Electrical sets direct materials: Wheel & tire sets Metal parts direct materials: Canvas direct materials: Direct labor Manufacturing overhead - machine hours Total COGS Budget per Unit Quantity set set pounds yards hour hour Management is asking that the accountant compute the budget variances for 2022. Using the information provided on the BLUE TABS, calculate the following variances. Include a description of the variables for each computation. In order to receive credit -> show your calculations!! Hint:Start by calculating the standard DM cost of one unit, actual DM cost of one unit, standard labor cost for one unit and actual labor cost for one unit. Check the production budget for the planned number of bikes. The actual number of bikes produced is provided in the Additional Info - Actual Costs tab. Expected / Standard Unit Cost Total Product Costs Actual Cost Unit Total Material Price Variance Material Quantity Variance Total Materials Variance Labor Quantity Variance Labor Price Variance Total Labor Variance